public JsonResult GetList(string[] stringArray)
        {
            int i = 0;
            ViewBag.IsView = true;
            DALExportClient dalExportClient = new DALExportClient();
            BALExportClient model = new BALExportClient();

            string filepath = Convert.ToString(Session["FilePathClient"]);
            model.ItemList = dalExportClient.getExcelColumnName(filepath);
            List<string> MatchListOfExcel = new List<string>();
            model.ListtblColumnName = (List<string>)Session["DBColumnNameClient"];
            List<tblColumn> list = new List<tblColumn>();

            MatchListOfExcel.Add("NotificationFrequencyId");
            MatchListOfExcel.Add("Notification Frequency");
            MatchListOfExcel.Add("Notification Time");
            MatchListOfExcel.Add("BillingCurrencyId" );
            MatchListOfExcel.Add("Billing Currency");
            MatchListOfExcel.Add("ContractTypeId");
            MatchListOfExcel.Add("Contract Type");
            MatchListOfExcel.Add("ClientContactDepartmentId");
            MatchListOfExcel.Add("Client Contact Department");

            foreach (var item in stringArray)
            {
                MatchListOfExcel.Add(item);
                i++;
                if (i == 23)
                {
                    break;
                }
            }

            DataTable dt = dalExportClient.GetExcelTable(filepath, 0);

            if (!dt.Columns.Contains("NotificationFrequencyId") || !dt.Columns.Contains("Notification Frequency") || !dt.Columns.Contains("Notification Time")
                 && !dt.Columns.Contains("BillingCurrencyId") || !dt.Columns.Contains("Billing Currency") || !dt.Columns.Contains("ContractTypeId")
                || !dt.Columns.Contains("Contract Type") || !dt.Columns.Contains("ClientContactDepartmentId") || !dt.Columns.Contains("Client Contact Department"))
            {

                dalExportClient.AddTemplateValue(dt, stringArray);
            }

            model.dtItem = dalExportClient.ExportView(dt, MatchListOfExcel.ToArray(), model.ListtblColumnName.ToArray(), filepath);

            foreach (DataRow row in model.dtItem.Rows)
            {
                tblColumn tblColumnObj = new tblColumn();
                tblColumnObj.col1 = Convert.ToString(row[0]);
                tblColumnObj.col2 = Convert.ToString(row[1]);
                tblColumnObj.col3 = Convert.ToString(row[2]);
                tblColumnObj.col4 = Convert.ToString(row[3]);
                tblColumnObj.col5 = Convert.ToString(row[4]);
                tblColumnObj.col6 = Convert.ToString(row[5]);
                tblColumnObj.col7 = Convert.ToString(row[6]);
                tblColumnObj.col8 = Convert.ToString(row[7]);
                tblColumnObj.col9 = Convert.ToString(row[8]);
                tblColumnObj.col10 = Convert.ToString(row[9]);
                tblColumnObj.col11 = Convert.ToString(row[10]);
                tblColumnObj.col12 = Convert.ToString(row[11]);
                tblColumnObj.col13 = Convert.ToString(row[12]);
                tblColumnObj.col14 = Convert.ToString(row[13]);
                tblColumnObj.col15 = Convert.ToString(row[14]);
                tblColumnObj.col16 = Convert.ToString(row[15]);
                tblColumnObj.col17 = Convert.ToString(row[16]);
                tblColumnObj.col18 = Convert.ToString(row[17]);
                tblColumnObj.col19 = Convert.ToString(row[18]);
                tblColumnObj.col20 = Convert.ToString(row[19]);
                tblColumnObj.col21 = Convert.ToString(row[20]);
                tblColumnObj.col22 = Convert.ToString(row[21]);
                tblColumnObj.col23 = Convert.ToString(row[22]);
                tblColumnObj.col24 = Convert.ToString(row[23]);
                tblColumnObj.col25 = Convert.ToString(row[24]);
                tblColumnObj.col26 = Convert.ToString(row[25]);
                tblColumnObj.col27 = Convert.ToString(row[26]);
                tblColumnObj.col28 = Convert.ToString(row[27]);
                tblColumnObj.col29 = Convert.ToString(row[28]);
                tblColumnObj.col30 = Convert.ToString(row[29]);
                tblColumnObj.col31 = Convert.ToString(row[30]);
                tblColumnObj.col32 = Convert.ToString(row[31]);
                list.Add(tblColumnObj);
            }

            return this.Json(list);
        }
        public string Save(string[] stringArray)
        {
            try
            {
                int i = 0;
                DALExportClient dalExportClient = new DALExportClient();
                BALExportClient model = new BALExportClient();
                string filepath = Convert.ToString(Session["FilePathClient"]);
                model.ItemList = dalExportClient.getExcelColumnName(filepath);
                ViewBag.IsView = true;

                List<string> MatchListOfExcel = new List<string>();

                model.ListtblColumnName = (List<string>)Session["DBColumnNameClient"];

                MatchListOfExcel.Add("NotificationFrequencyId");
                MatchListOfExcel.Add("Notification Frequency");
                MatchListOfExcel.Add("Notification Time");
                MatchListOfExcel.Add("BillingCurrencyId");
                MatchListOfExcel.Add("Billing Currency");
                MatchListOfExcel.Add("ContractTypeId");
                MatchListOfExcel.Add("Contract Type");
                MatchListOfExcel.Add("ClientContactDepartmentId");
                MatchListOfExcel.Add("Client Contact Department");

                foreach (var item in stringArray)
                {
                    MatchListOfExcel.Add(item);
                    i++;
                    if (i == 23)
                    {
                        break;
                    }
                }

                DataTable dt = dalExportClient.GetExcelTable(filepath, 0);

                if (!dt.Columns.Contains("NotificationFrequencyId") || !dt.Columns.Contains("Notification Frequency") || !dt.Columns.Contains("Notification Time")
                && !dt.Columns.Contains("BillingCurrencyId") || !dt.Columns.Contains("Billing Currency") || !dt.Columns.Contains("ContractTypeId")
               || !dt.Columns.Contains("Contract Type") || !dt.Columns.Contains("ClientContactDepartmentId") || !dt.Columns.Contains("Client Contact Department"))
                {

                    dalExportClient.AddTemplateValue(dt, stringArray);
                }

                model.dtItem = dalExportClient.ExportView(dt, MatchListOfExcel.ToArray(), model.ListtblColumnName.ToArray(), filepath);

                LoginSession loginsession = (LoginSession)Session["Login"];
                dalExportClient.AddCreatedById(model.dtItem, loginsession.ClientID);
                SqlParameterClient sqlParameterClient = new SqlParameterClient();
                sqlParameterClient.ExecuteExportData(model.dtItem);

                return "Import Data Sucessfully.";
            }
            catch (Exception ex)
            {
                return ex.Message;
            }
        }