public int InsertBillOutstandingData() { try { string query = "select * from BILLOS"; DataTable dtBillOutstanding = dbConnection.GetData(query); List <PharmaDAL.Entity.BillOutStandings> listBillOutstandings = new List <PharmaDAL.Entity.BillOutStandings>(); int _result = 0; using (PharmaDBEntities context = new PharmaDBEntities()) { if (dtBillOutstanding != null && dtBillOutstanding.Rows.Count > 0) { foreach (DataRow dr in dtBillOutstanding.Rows) { try { string ledgerType = string.Empty; string ledgerTypeCode = string.Empty; if (string.IsNullOrWhiteSpace(Convert.ToString(dr["vno"]).Trim())) { throw new Exception(); } else if (Convert.ToString(dr["vno"]).Trim().Length > 8) { log.Error("BillOS : VNO Length is greater than 8 -->" + Convert.ToString(dr["vno"]).Trim()); throw new Exception(); } string originalVoucherTypeCode = Convert.ToString(dr["vtyp"]).Trim(); string mappedVoucherTypeCode = Common.voucherTypeMap.Where(x => x.OriginalVoucherType == originalVoucherTypeCode).Select(x => x.MappedVoucherType).FirstOrDefault(); if (Convert.ToString(dr["slcd"]).Trim() == "SL") { ledgerType = Common.ledgerTypeMap.Where(p => p.OriginaLedgerType == "SL").Select(p => p.MappedLedgerType).FirstOrDefault(); ledgerTypeCode = Common.supplierLedgerCodeMap.Where(p => p.OriginalSupplierLedgerCode == Convert.ToString(dr["ACNO"]).Trim()).Select(x => x.MappedSupplierLedgerCode).FirstOrDefault(); } else if (Convert.ToString(dr["slcd"]).Trim() == "CL") { ledgerType = Common.ledgerTypeMap.Where(p => p.OriginaLedgerType == "CL").Select(p => p.MappedLedgerType).FirstOrDefault(); ledgerTypeCode = Common.customerLedgerCodeMap.Where(p => p.OriginalCustomerLedgerCode == Convert.ToString(dr["ACNO"]).Trim()).Select(x => x.MappedCustomerLedgerCode).FirstOrDefault(); } string oldVNo = Convert.ToString(dr["vno"]).Trim(); var header = Common.voucherNumberMap.Where(p => p.OriginalVoucherNumber == oldVNo).FirstOrDefault(); PharmaDAL.Entity.BillOutStandings newBillOS = new PharmaDAL.Entity.BillOutStandings(); if (header != null) { newBillOS.PurchaseSaleBookHeaderID = header.MappedPurchaseHeaderID; newBillOS.VoucherNumber = header.MappedVoucherNumber; } else { newBillOS.VoucherNumber = (Convert.ToString(dr["vno"]).Trim()).PadLeft(8, '0'); //log.Info(string.Format("BILLOS: Voucher No Not found in for VNO {0}", oldVNo)); } newBillOS.VoucherTypeCode = mappedVoucherTypeCode; newBillOS.VoucherDate = (DateTime)CommonMethods.SafeConversionDatetime(Convert.ToString(dr["vdt"])); newBillOS.DueDate = CommonMethods.SafeConversionDatetime(Convert.ToString(dr["duedt"])); newBillOS.LedgerType = ledgerType; newBillOS.LedgerTypeCode = ledgerTypeCode; newBillOS.BillAmount = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["osamt"])) ?? default(decimal); newBillOS.OSAmount = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["osamt"])) ?? default(decimal); newBillOS.IsHold = Convert.ToString(dr["vno"]).Trim() == "Y" ? true : false; newBillOS.HOLDRemarks = null; listBillOutstandings.Add(newBillOS); } catch (Exception) { log.Info(string.Format("BILL OUTSTANDING: Error in Voucher Number {0}", Convert.ToString(dr["vno"]).Trim())); } } } context.BillOutStandings.AddRange(listBillOutstandings); _result = context.SaveChanges(); } FillBillOsId(); return(_result); } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public int InsertBillOutstandingData() { try { string query = "select * from BILLOS"; DataTable dtBillOutstanding = dbConnection.GetData(query); List <PharmaDAL.Entity.BillOutStandings> listBillOutstandings = new List <PharmaDAL.Entity.BillOutStandings>(); int _result = 0; using (PharmaDBEntities context = new PharmaDBEntities()) { if (dtBillOutstanding != null && dtBillOutstanding.Rows.Count > 0) { foreach (DataRow dr in dtBillOutstanding.Rows) { try { string ledgerType = string.Empty; string ledgerTypeCode = string.Empty; if (string.IsNullOrWhiteSpace(Convert.ToString(dr["vno"]).TrimEnd())) { throw new Exception(); } else if (Convert.ToString(dr["vno"]).TrimEnd().Length > 8) { log.Error("BillOS : VNO Length is greater than 8 -->" + Convert.ToString(dr["vno"]).TrimEnd()); throw new Exception(); } string originalVoucherTypeCode = Convert.ToString(dr["vtyp"]).TrimEnd(); string mappedVoucherTypeCode = Common.voucherTypeMap.Where(x => x.OriginalVoucherType == originalVoucherTypeCode).Select(x => x.MappedVoucherType).FirstOrDefault(); if (Convert.ToString(dr["slcd"]).TrimEnd() == ORIGINAL_SLCD_SL) { ledgerType = MAPPED_SLCD_SL; ledgerTypeCode = Common.supplierLedgerCodeMap.Where(p => p.OriginalSupplierLedgerCode == Convert.ToString(dr["ACNO"]).TrimEnd()).Select(x => x.MappedSupplierLedgerCode).FirstOrDefault(); } else { ledgerType = MAPPED_SLCD_CL; ledgerTypeCode = Common.customerLedgerCodeMap.Where(p => p.OriginalCustomerLedgerCode == Convert.ToString(dr["ACNO"]).TrimEnd()).Select(x => x.MappedCustomerLedgerCode).FirstOrDefault(); } PharmaDAL.Entity.BillOutStandings newBillOS = new PharmaDAL.Entity.BillOutStandings() { PurchaseSaleBookHeaderID = null, VoucherNumber = (Convert.ToString(dr["vno"]).TrimEnd()).PadLeft(8, '0'), VoucherTypeCode = mappedVoucherTypeCode, VoucherDate = Convert.ToDateTime(dr["vdt"]), DueDate = Convert.ToDateTime(dr["duedt"]), LedgerType = ledgerType, LedgerTypeCode = ledgerTypeCode, BillAmount = 0, OSAmount = Convert.ToDecimal(dr["osamt"]), IsHold = Convert.ToString(dr["vno"]).TrimEnd() == "Y" ? true :false, HOLDRemarks = null }; listBillOutstandings.Add(newBillOS); } catch (Exception) { log.Info(string.Format("BILL OUTSTANDING: Error in Voucher Number {0}", Convert.ToString(dr["vno"]).TrimEnd())); } } } context.BillOutStandings.AddRange(listBillOutstandings); _result = context.SaveChanges(); return(_result); } } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } }