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); } }