private void LoadFieldToStg_Installments_Normal(string str) { try { //using (var transacContainer = new TransactionModelContainer()) //{ var stgInstallmentNormal = new stg_Installments_Normal(); stgInstallmentNormal.BankCode = str.Substring(7, 3).Trim(); stgInstallmentNormal.CompanyAccount = str.Substring(10, 10).Trim(); string dd = str.Substring(20, 2); string mm = str.Substring(22, 2); string yyyy = str.Substring(24, 4); string hh = str.Substring(28, 2); string m = str.Substring(30, 2); string ss = str.Substring(32, 2); var dt = new DateTime(Convert.ToInt32(yyyy), Convert.ToInt32(mm), Convert.ToInt32(dd), Convert.ToInt32(hh), Convert.ToInt32(m), Convert.ToInt32(ss)); stgInstallmentNormal.PaymentDate = dt; stgInstallmentNormal.CustomerName = str.Substring(34, 50).Trim(); stgInstallmentNormal.PaymentCode = str.Substring(84, 20).Trim(); stgInstallmentNormal.BranchNo = str.Substring(144, 4).Trim(); stgInstallmentNormal.TransactionType = str.Substring(152, 1).Trim(); stgInstallmentNormal.TransactionCode = str.Substring(153, 3).Trim(); stgInstallmentNormal.Amount = Convert.ToDecimal(str.Substring(163, 13).Trim()); stgInstallmentNormal.FileName = fileName; stgInstallmentNormal.RecordStatus = "Success"; stgInstallmentNormal.RecordRemark = ""; if (stgInstallmentNormal.BankCode == "014") { stgInstallmentNormal.ProcessStatus = str.Substring(179, 1).Trim(); stgInstallmentNormal.TransactionDate = Convert.ToDateTime(str.Substring(180, 8).Trim()); stgInstallmentNormal.PostingDate = Convert.ToDateTime(str.Substring(188, 60).Trim()); } else { stgInstallmentNormal.ProcessStatus = " "; stgInstallmentNormal.TransactionDate = Convert.ToDateTime("1753/1/1"); stgInstallmentNormal.PostingDate = Convert.ToDateTime("1753/1/1");; } // check null if (string.IsNullOrEmpty(str.Substring(104, 20).Trim())) { stgInstallmentNormal.Ref2 = ""; } else { stgInstallmentNormal.Ref2 = str.Substring(104, 20).Trim(); } // check null if (string.IsNullOrEmpty(str.Substring(148, 4).Trim())) { stgInstallmentNormal.TellerNo = ""; } else { stgInstallmentNormal.TellerNo = str.Substring(148, 4).Trim(); } // check null if (string.IsNullOrEmpty(str.Substring(156, 7).Trim())) { stgInstallmentNormal.ChequeNo = ""; } else { stgInstallmentNormal.ChequeNo = str.Substring(156, 7).Trim(); } // check null if (string.IsNullOrEmpty(str.Substring(176, 3).Trim())) { stgInstallmentNormal.ChequeBankCode = ""; } else { stgInstallmentNormal.ChequeBankCode = str.Substring(176, 3).Trim(); } //transacContainer.stg_Installments_Normal.AddObject(stgInstallmentNormal); //transacContainer.SaveChanges(); //} } catch (Exception ex) { throw ex; } }
private void LoadFieldToStg_Installments_Normal(string str) { try { //using (var transacContainer = new TransactionModelContainer()) //{ var stgInstallmentNormal = new stg_Installments_Normal(); stgInstallmentNormal.BankCode = str.Substring(7, 3).Trim(); stgInstallmentNormal.CompanyAccount = str.Substring(10, 10).Trim(); string dd = str.Substring(20, 2); string mm = str.Substring(22, 2); string yyyy = str.Substring(24, 4); string hh = str.Substring(28, 2); string m = str.Substring(30, 2); string ss = str.Substring(32, 2); var dt = new DateTime(Convert.ToInt32(yyyy), Convert.ToInt32(mm), Convert.ToInt32(dd), Convert.ToInt32(hh), Convert.ToInt32(m), Convert.ToInt32(ss)); stgInstallmentNormal.PaymentDate = dt; stgInstallmentNormal.CustomerName = str.Substring(34, 50).Trim(); stgInstallmentNormal.PaymentCode = str.Substring(84, 20).Trim(); stgInstallmentNormal.BranchNo = str.Substring(144, 4).Trim(); stgInstallmentNormal.TransactionType = str.Substring(152, 1).Trim(); stgInstallmentNormal.TransactionCode = str.Substring(153, 3).Trim(); stgInstallmentNormal.Amount = Convert.ToDecimal(str.Substring(163, 13).Trim()); stgInstallmentNormal.FileName = fileName; stgInstallmentNormal.RecordStatus = "Success"; stgInstallmentNormal.RecordRemark = ""; if (stgInstallmentNormal.BankCode == "014") { stgInstallmentNormal.ProcessStatus = str.Substring(179, 1).Trim(); stgInstallmentNormal.TransactionDate = Convert.ToDateTime(str.Substring(180, 8).Trim()); stgInstallmentNormal.PostingDate = Convert.ToDateTime(str.Substring(188, 60).Trim()); } else { stgInstallmentNormal.ProcessStatus = " "; stgInstallmentNormal.TransactionDate = Convert.ToDateTime("1753/1/1"); stgInstallmentNormal.PostingDate = Convert.ToDateTime("1753/1/1"); ; } // check null if (string.IsNullOrEmpty(str.Substring(104, 20).Trim())) { stgInstallmentNormal.Ref2 = ""; } else { stgInstallmentNormal.Ref2 = str.Substring(104, 20).Trim(); } // check null if (string.IsNullOrEmpty(str.Substring(148, 4).Trim())) { stgInstallmentNormal.TellerNo = ""; } else { stgInstallmentNormal.TellerNo = str.Substring(148, 4).Trim(); } // check null if (string.IsNullOrEmpty(str.Substring(156, 7).Trim())) { stgInstallmentNormal.ChequeNo = ""; } else { stgInstallmentNormal.ChequeNo = str.Substring(156, 7).Trim(); } // check null if (string.IsNullOrEmpty(str.Substring(176, 3).Trim())) { stgInstallmentNormal.ChequeBankCode = ""; } else { stgInstallmentNormal.ChequeBankCode = str.Substring(176, 3).Trim(); } //transacContainer.stg_Installments_Normal.AddObject(stgInstallmentNormal); //transacContainer.SaveChanges(); //} } catch (Exception ex) { throw ex; } }