public JsonResult GetList(string[] stringArray)
{
ViewBag.IsView = true;
DALExportSite dalExportSite = new DALExportSite();
BALExportSite model = new BALExportSite();
string filepath = Convert.ToString(Session["FilePathSite"]);
model.ItemList = dalExportSite.getExcelColumnName(filepath);
List<string> MatchListOfExcel = new List<string>();
model.ListtblColumnName = (List<string>)Session["DBColumnNameSite"];
List<tblColumn> list = new List<tblColumn>();
MatchListOfExcel.Add("ClientId");
MatchListOfExcel.Add("Client");
MatchListOfExcel.Add("BillingFrequencyId");
MatchListOfExcel.Add("Billing Frequency");
MatchListOfExcel.Add("ConsumerDepartmentId");
MatchListOfExcel.Add("Consumer Department");
foreach (var item in stringArray)
{
MatchListOfExcel.Add(item);
}
DataTable dt = dalExportSite.GetExcelTable(filepath, 0);
model.dtItem = dalExportSite.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]);
list.Add(tblColumnObj);
}
return this.Json(list);
}
public JsonResult GetList(string[] stringArray)
{
ViewBag.IsView = true;
DALExportProperty dalExportProperty = new DALExportProperty();
BALExportProperty model = new BALExportProperty();
string filepath = Convert.ToString(Session["FilePath"]);
model.ItemList = dalExportProperty.getExcelColumnName(filepath);
List<string> MatchListOfExcel = new List<string>();
model.ListtblColumnName = (List<string>)Session["DBColumnName"];
List<tblColumn> list = new List<tblColumn>();
MatchListOfExcel.Add("ClientId");
MatchListOfExcel.Add("Client");
MatchListOfExcel.Add("NetworkId");
MatchListOfExcel.Add("Network");
MatchListOfExcel.Add("PropertyBandId");
MatchListOfExcel.Add("Property Band");
foreach (var item in stringArray)
{
MatchListOfExcel.Add(item);
}
DataTable dt=dalExportProperty.GetExcelTable(filepath, 0);
model.dtItem = dalExportProperty.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]);
list.Add(tblColumnObj);
}
return this.Json(list);
}
public JsonResult GetList(string[] stringArray)
{
ViewBag.IsView = true;
DALExportMeter dalExportMeter = new DALExportMeter();
BALExportMeter model = new BALExportMeter();
string filepath = Convert.ToString(Session["FilePathMeter"]);
model.ItemList = dalExportMeter.getExcelColumnName(filepath);
List<string> MatchListOfExcel = new List<string>();
model.ListtblColumnName = (List<string>)Session["DBColumnNameMeter"];
List<tblColumn> list = new List<tblColumn>();
MatchListOfExcel.Add("ClientId");
MatchListOfExcel.Add("Client");
MatchListOfExcel.Add("NetworkId");
MatchListOfExcel.Add("Network");
MatchListOfExcel.Add("PropertyId");
MatchListOfExcel.Add("Property Address");
MatchListOfExcel.Add("SupplyTypeId");
MatchListOfExcel.Add("Supply Type");
MatchListOfExcel.Add("ReadFrequencyId");
MatchListOfExcel.Add("Read Frequency");
MatchListOfExcel.Add("MeterCategoryId");
MatchListOfExcel.Add("Meter Category");
MatchListOfExcel.Add("Reading Interval");
foreach (var item in stringArray)
{
MatchListOfExcel.Add(item);
}
DataTable dt = dalExportMeter.GetExcelTable(filepath, 0);
model.dtItem = dalExportMeter.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]);
list.Add(tblColumnObj);
}
return this.Json(list);
}
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);
}
