public void startImporting() { #region To Import Debit Note DataSet dsPath = new DataSet(); dsPath = getPathDetail("FlexDownload"); string ImportPath = dsPath.Tables[0].Rows[0]["KeyValue"].ToString(); if (!Directory.Exists(ImportPath)) { try { CreateNewFolder(ImportPath); } catch { throw; } } ds = new DataSet(); ds = getDebitNoteDetailToCsv(); if (ds.Tables["TM_FlexDebitNote_BSToFlex"].Rows.Count > 0) { GenerateCsvFile objCSv = new GenerateCsvFile(); string strFile = "DBN" + ".csv"; string FilePath = ImportPath + strFile + ""; objCSv.exportToCSVfile(ds, ",", "\n", FilePath); objBstoCsv = new FlexBsToCsv(); objBstoCsv.csvId = 0; objBstoCsv.InternalFileName = strFile; objBstoCsv.ImportFor = "DBN"; objBstoCsv.Total_No_of_Records = ds.Tables["TM_FlexDebitNote_BSToFlex"].Rows.Count; SaveDebitNoteDetailToCsv(objBstoCsv); } #endregion }
public void makeCsvForInValidRecords(DataSet dsRecord) { GenerateCsvFile objCSv = new GenerateCsvFile(); string strDestPath = mstrSourceFilePath + "ExceptionFiles"; if (!Directory.Exists(strDestPath)) { try { CreateNewFolder(strDestPath); } catch { throw; } } //string FilePath = strCurrFileName.Substring(0, strCurrFileName.LastIndexOf(@"\")) + @"\ExceptionFiles\" + strCurrFileName.Substring(strCurrFileName.LastIndexOf(@"\") + 1); string FilePath = strDestPath + "\\" + strFileName; objCSv.exportToCSVfile(dsRecord, ",", "\n", FilePath); }
public void startIPDNImporting() { #region To Import ICAM DataSet dsPath = new DataSet(); dsPath = getPathDetail("IPDNDownload"); string ImportPath = dsPath.Tables[0].Rows[0]["KeyValue"].ToString(); if (!Directory.Exists(ImportPath)) { try { CreateNewFolder(ImportPath); } catch { throw; } } ds = new DataSet(); ds = getIPDNDetailToCsv(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { GenerateCsvFile objCSv = new GenerateCsvFile(); //string strFile = "IPDN" + System.DateTime.Now.ToString("yyyyMMdd").Trim().Replace(" ", "").Replace("/", "_").Replace(":", "_") + ".csv"; string strFile = "IPDN" + ".csv"; string FilePath = ImportPath + strFile + ""; //EventLog.WriteEntry("NWI_IRMFlexProcess", "Importing Started Successfully", System.Diagnostics.EventLogEntryType.Error); objCSv.exportToCSVfile(ds, ",", "\n", FilePath); objBstoCsv = new FlexBsToCsv(); objBstoCsv.csvId = 0; objBstoCsv.InternalFileName = strFile; objBstoCsv.ImportFor = "IPDN"; objBstoCsv.Total_No_of_Records = ds.Tables[0].Rows.Count; SaveDebitNoteDetailToCsv(objBstoCsv); } #endregion }