using System;

using System.Collections.Generic;

using NPOI.XSSF.UserModel;

using NPOI.SS.UserModel;

using NPOI.SS.Util;

using NPOI.XSSF.Util;

using NPOI.POIFS.FileSystem;

using NPOI.HPSF;

using System.IO;

​

public class Program

{

    public static void Main()

    {

        //General Workflow:

        //Create project --> Set up --> Calculate --> Output to Tracker.    

        DefaultProject TP = new DefaultProject();

        TP.SetUp();

        TP.Calculate();

        Dictionary<int, string> dic1 = TP.WriteOnline();

        Dictionary<int, string> dic2 = TP.WriteValue();

        string filePath1 = @"C:\Users\helen.wu\Desktop\SOFT Project Tracking HUB\NVIDIA_Online_Tracker_Template.xlsx";

        string filePath2 = @"C:\Users\helen.wu\Desktop\SOFT Project Tracking HUB\Helen_All_Projects.xlsx";

        TP.SaveExcel(filePath1, dic1);

        TP.SaveExcel(filePath2, dic2);

    }

​

    public class DefaultProject

    {

        //Counts

        public int TotalCounts = 0;

        public DefaultProject()

        {

            TotalCounts++;

        }

​

        //Default Properties

        public DateTime DTCreationDate = DateTime.Now;

        public String STCreationDate = DateTime.Now.ToString("MM/dd/yyyy");

        private string falconid;

        public string FalconID

        {

            get

            {

                return falconid;

            }

​

            set

            {

                falconid = "nvidia_" + this.DTCreationDate.ToString("yyMM") + "_" + value;

            }

        }

​

        private string jiraid;

        public string JIRAID

        {

            get

            {

                return jiraid;

            }

​

            set

            {

                jiraid = "TRAN-" + value;

            }

        }

​

        public string GSID

        {

            get;

            set;

        }

​

        public string ProjectName

        {

            get;

            set;

        }

​

        public string WordCounts

        {

            get;

            set;

        }

​

        public string Amounts

        {

            get;

            set;

        }

​

        public string Status = "Pending";

        //Optional Properties - to be supplemented

        //File Name; Project Folder(Auto Create);

        public string Requestor

        {

            get;

            set;

        }

​

        //Methods

        public void SaveExcel(string filePath, Dictionary<int, string> dic)

        {

            FileStream file = new FileStream(filePath, FileMode.Open, FileAccess.ReadWrite);

        IWorkbook wb = new XSSFWorkbook(file);

        ISheet sht = wb.GetSheet("sheet1");

        int newrowNum = sht.LastRowNum + 1;

        IRow row = sht.CreateRow(newrowNum);

        ICell cell;

        for (int i = 0; i < dic.count; i++)

        {

            cell = row.CreateCell(i);

            cell.SetCellValue(dic[i]);

        }

​

        FileStream file2 = new FileStream(filePath, FileMode.Create);

        wb1.Write(file2);

        file.Close();

        }

​

        public Dictionary<int, string> WriteOnline()

        {

            string[] header = {"WL Project Code", "JIRA ID", "Requestor", "Region", "Requested Date", "File name/Email subject", "Satuts", "Complete Month", "Product", "Type", "Word Count", "Quote - Total"}; //12个

            string[] cV = new string[12];

            cV[0] = this.FalconID;

            cV[1] = this.JIRAID;

            cV[2] = this.Requestor;

            cV[3] = "CN";

            cV[4] = this.STCreationDate;

            cV[5] = this.ProjectName;

            cV[6] = this.Status;

            cV[7] = " ";

            cV[8] = "NVIDIA";

            cV[9] = " ";

            cV[10] = this.WordCounts;

            cV[11] = this.Amounts;

            Dictionary<int, string> writeRow = new Dictionary<int, string>();

            for (int n = 0; n < 12; n++)

            {

                writeRow.Add(n, cV[n]);

            }

​

            return writeRow;

        }

​

        public override Dictionary<int, string> WriteValue()

        {

            string[] header = {"No.", "Status", "Create Date", "Falcon ID", "JIRA ID", "GS ID", "Project Name", "Word Counts", "Amounts"}; //9个

            string[] cV = new string[9];

            cV[0] = this.TotalCounts.ToString();

            cV[1] = this.Status;

            cV[2] = this.STCreationDate;

            cV[3] = this.FalconID;

            cV[4] = this.JIRAID;

            cV[5] = this.GSID;

            cV[6] = this.ProjectName;

            cV[7] = this.WordCounts;

            cV[8] = this.Amounts;

            Dictionary<int, string> writeRow = new Dictionary<int, string>();

            for (int n = 0; n < 9; n++)

            {

                writeRow.Add(n, cV[n]);

            }

​

            return writeRow;

        }

​

        public void SetUp() //Get basic information. For now we type it manually, later will get from server.

        {

            Console.WriteLine("Type 1 for DMO, 2 for Blog.");

            string type = Console.ReadLine();

            if (type == "1")

            {

                Console.WriteLine("JIRA ID");

                this.JIRAID = Console.ReadLine();

                Console.WriteLine("GS ID");

                this.GSID = Console.ReadLine();

                Console.WriteLine("Project Name");

                this.ProjectName = Console.ReadLine();

                Console.WriteLine("Falcon ID");

                this.FalconID = Console.ReadLine();

                Console.WriteLine("Type 1 for Wilson, 2 for Mengdi");

                string requestor = Console.ReadLine();

                //below needs further supplementation

                if (requestor == "1")

                {

                    this.Requestor = "Wilson";

                }

                else

                {

                    this.Requestor = "Mengdi";

                }

            }

        }

​

        public virtual void Calculate()

        {

            Dictionary<string, double> NVQuote1 = new Dictionary<string, double>();

            NVQuote1.Add("100%", 0.025);

            NVQuote1.Add("95% - 99%", 0.04);

            NVQuote1.Add("85% - 94%", 0.05);

            NVQuote1.Add("75% - 84%", 0.065);

            NVQuote1.Add("No Match", 0.09); //???我猜的

            NVQuote1.Add("Repetitions", 0.025);

            NVQuote1.Add("In Context Matches", 0.025);

            NVQuote1.Add("MT", 0.09);

            int totalWC = 0;

            double money = 0;

            foreach (string key in NVQuote1.Keys)

            {

                Console.WriteLine(key);

                int detailedWC = Convert.ToInt32(Console.ReadLine());

                totalWC += detailedWC;

                money += detailedWC * NVQuote1[key];

            }

​

            money *= 1.1;

            money = Math.Round(money, 2, MidpointRounding.AwayFromZero);

            this.WordCounts = totalWC.ToString();

            this.Amounts = money.ToString();

        }

    //Output to NVIDIA Online Tracker

    //sheet.CreateCell(0).SetCellValue(this.FalconID);

    //sheet.CreateCell(1).SetCellValue(this.FalconID);

    }

}