public string Save(string[] stringArray)
{
try
{
DALExportConsumer dalExportConsumer = new DALExportConsumer();
BALExportProperty model = new BALExportProperty();
string filepath = Convert.ToString(Session["FilePathMeter"]);
model.ItemList = dalExportConsumer.getExcelColumnName(filepath);
ViewBag.IsView = true;
List<string> MatchListOfExcel = new List<string>();
model.ListtblColumnName = (List<string>)Session["DBColumnNameMeter"];
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 = dalExportConsumer.GetExcelTable(filepath, 0);
model.dtItem = dalExportConsumer.ExportView(dt, MatchListOfExcel.ToArray(), model.ListtblColumnName.ToArray(), filepath);
LoginSession loginsession = (LoginSession)Session["Login"];
dalExportConsumer.AddCreatedById(model.dtItem, loginsession.ClientID);
SqlParameterMeter sqlParameterMeter = new SqlParameterMeter();
sqlParameterMeter.ExecuteExportData(model.dtItem);
return "Import Data Sucessfully.";
}
catch (Exception ex)
{
return ex.Message;
}
}
