public void OnNavigatedTo(NavigationParameters parameters)
{
FileSourceTypes.Clear();
FileSourceTypes.Add("PDF");
FileSourceTypes.Add("Image");
FileSourceTypes.Add("MP3");
FileSourceTypes.Add("Video");
FileSourceTypes.Add("PPT");
FileSourceTypes.Add("Doc");
}
public static List <ManualViolationDTO> ParseViolationExcelToDTO(string excelFilePath, FileSourceTypes fileType)
{
try
{
List <ManualViolationDTO> lst = new List <ManualViolationDTO>();
OleDbDataAdapter adapter;
OleDbConnection conn = new OleDbConnection(String.Format(@"Provider=Microsoft.ACE.OLEDB.15.0;Data Source=" + excelFilePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\""));
conn.Open();
var dt2 = conn.GetSchema("TABLES");
if (dt2 != null && dt2.Rows.Count > 0 && dt2.Columns.Contains("TABLE_NAME"))
{
adapter = new OleDbDataAdapter("SELECT * FROM [" + dt2.Rows[0].ItemArray[dt2.Columns.IndexOf("TABLE_NAME")] + "]", conn);
new OleDbCommandBuilder(adapter);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt != null & dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ManualViolationDTO violation = null;
if (fileType == FileSourceTypes.AbsenseViolation)
{
violation = ParseAbscentViolationRow(dt.Rows[i]);
}
else if (fileType == FileSourceTypes.PresentViolation)
{
violation = ParsePresentViolationRow(dt.Rows[i]);
}
if (violation != null)
{
lst.Add(violation);
}
}
}
}
return(lst);
}
catch (Exception ex)
{
Utility.WriteLog(ex);
return(null);
}
}
public static List <AccidentStandardDTO> ParseAccidentExcelToDTO(string excelFilePath, FileSourceTypes fileType)
{
try
{
try
{
File.Copy(excelFilePath, @"D:\STC Data\" + "Copy - " + Path.GetFileName(excelFilePath));
}
catch (Exception ex)
{
}
List <AccidentStandardDTO> lst = new List <AccidentStandardDTO>();
OleDbDataAdapter adapter;
OleDbConnection conn = new OleDbConnection(String.Format(@"Provider=Microsoft.ACE.OLEDB.15.0;Data Source=" + excelFilePath + ";Extended Properties=\"Excel 12.0 Xml;HDR=YES\""));
conn.Open();
var dt2 = conn.GetSchema("TABLES");
if (dt2 != null && dt2.Rows.Count > 0 && dt2.Columns.Contains("TABLE_NAME"))
{
adapter = new OleDbDataAdapter("SELECT * FROM [" + dt2.Rows[0].ItemArray[dt2.Columns.IndexOf("TABLE_NAME")] + "]", conn);
new OleDbCommandBuilder(adapter);
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt != null & dt.Columns.Count > 0 && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
AccidentStandardDTO incident = null;
if (fileType == FileSourceTypes.Accident)
{
incident = ParseAccidentRow(dt.Rows[i]);
}
else if (fileType == FileSourceTypes.ArabicFileAccident)
{
incident = ParseAccidentArabicRow(dt.Rows[i]);
}
else if (fileType == FileSourceTypes.PDOAccident)
{
incident = ParseAccidentPDORow(dt.Rows[i]);
}
if (incident != null)
{
lst.Add(incident);
}
}
}
}
return(lst);
}
catch (Exception ex)
{
Utility.WriteLog(ex);
return(null);
}
}
