private void ReadFileUploaded(string filePath)
{
string connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=Excel 12.0;"; // xlsx
OleDbConnection connExcel = new OleDbConnection(connStr);
OleDbCommand cmdExcel = new OleDbCommand();
OleDbDataAdapter oda = new OleDbDataAdapter();
DataTable dt = new DataTable();
cmdExcel.Connection = connExcel;
//Get the name of First Sheet
connExcel.Open();
DataTable dtExcelSchema;
dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
connExcel.Close();
//Read Data from First Sheet
connExcel.Open();
cmdExcel.CommandText = "SELECT * From [" + SheetName + "]";
oda.SelectCommand = cmdExcel;
oda.Fill(dt);
connExcel.Close();
var listRepNAme = SetRepList();
StringBuilder sb = new StringBuilder();
var list = new List <RepAtt>();
foreach (DataRow row in dt.Rows)
{
var obj = new RepAtt();
var repContent = row[8].ToString().Trim();
if (!string.IsNullOrEmpty(repContent))
{
if (listRepNAme.Contains(repContent))
{
if (row[2].ToString() == "System")
{
obj.RepName = repContent;
obj.TimeDay = row[1].ToString();
list.Add(obj);
}
}
}
}
ReAssignFileData(list);
}
private List <RepAtt> TestFile()
{
var list = new List <RepAtt>();
var obj = new RepAtt();
obj.RepName = "PARTI";
obj.TimeDay = "Wed 07 Feb 2018 - 05:01:32 PM";
list.Add(obj);
var obj2 = new RepAtt();
obj2.RepName = "PARTI";
obj2.TimeDay = "Wed 07 Feb 2018 - 09:05:52 AM";
list.Add(obj2);
var obj3 = new RepAtt();
obj3.RepName = "PARTI";
obj3.TimeDay = "Thu 08 Feb 2018 - 04:50:32 PM";
list.Add(obj3);
var obj4 = new RepAtt();
obj4.RepName = "PARTI";
obj4.TimeDay = "Thu 08 Feb 2018 - 09:10:52 AM";
list.Add(obj4);
var obj5 = new RepAtt();
obj5.RepName = "PARTI";
obj5.TimeDay = "Fri 10 Feb 2018 - 05:14:32 PM";
list.Add(obj5);
var obj6 = new RepAtt();
obj6.RepName = "PARTI";
obj6.TimeDay = "Fri 10 Feb 2018 - 08:50:52 AM";
list.Add(obj6);
var objd1 = new RepAtt();
objd1.RepName = "DIMITRI";
objd1.TimeDay = "Wed 07 Feb 2018 - 05:01:32 PM";
list.Add(objd1);
var objd2 = new RepAtt();
objd2.RepName = "DIMITRI";
objd2.TimeDay = "Wed 07 Feb 2018 - 08:30:52 AM";
list.Add(objd2);
var objd3 = new RepAtt();
objd3.RepName = "DIMITRI";
objd3.TimeDay = "Thu 08 Feb 2018 - 05:20:32 PM";
list.Add(objd3);
var objd4 = new RepAtt();
objd4.RepName = "DIMITRI";
objd4.TimeDay = "Thu 08 Feb 2018 - 09:08:52 AM";
list.Add(objd4);
return(list);
}
