public long InsertUpdateTempReceiptPayment(PharmaBusinessObjects.Transaction.ReceiptPayment.ReceiptPaymentItem receiptPayment) { try { long receiptPaymentID = 0; using (PharmaDBEntities context = new PharmaDBEntities()) { var receiptPaymentDB = context.TempReceiptPayment.Where(x => x.ReceiptPaymentID == receiptPayment.ReceiptPaymentID).FirstOrDefault(); if (receiptPaymentDB != null) { receiptPaymentDB.PaymentMode = receiptPayment.PaymentMode; receiptPaymentDB.Ammount = receiptPayment.Amount; receiptPaymentDB.BankAccountLedgerTypeCode = receiptPayment.BankAccountLedgerTypeCode; receiptPaymentDB.BankAccountLedgerTypeName = receiptPayment.BankAccountLedgerTypeName; receiptPaymentDB.ChequeNumber = receiptPayment.ChequeNumber; receiptPaymentDB.ChequeDate = receiptPayment.ChequeDate; receiptPaymentDB.UnadjustedAmount = receiptPayment.UnadjustedAmount; context.SaveChanges(); receiptPaymentID = receiptPaymentDB.ReceiptPaymentID; } else { Entity.TempReceiptPayment receiptPaymentDBEntry = new Entity.TempReceiptPayment() { VoucherNumber = "TPVOCHER", VoucherTypeCode = receiptPayment.VoucherTypeCode, VoucherDate = receiptPayment.VoucherDate, LedgerType = receiptPayment.LedgerType, LedgerTypeCode = receiptPayment.LedgerTypeCode, LedgerTypeName = receiptPayment.LedgerTypeName, PaymentMode = receiptPayment.PaymentMode, BankAccountLedgerTypeCode = receiptPayment.BankAccountLedgerTypeCode, BankAccountLedgerTypeName = receiptPayment.BankAccountLedgerTypeName, CreatedBy = LoggedInUser.Username, CreatedOn = DateTime.Now }; context.TempReceiptPayment.Add(receiptPaymentDBEntry); context.SaveChanges(); receiptPaymentID = receiptPaymentDBEntry.ReceiptPaymentID; } } return(receiptPaymentID); } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public int UpdateUser(PharmaBusinessObjects.Master.UserMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var user = context.Users.Where(q => q.UserId == p.UserId).FirstOrDefault(); if (user != null) { user.Password = p.Password; user.Status = p.Status; user.FirstName = p.FirstName; user.LastName = p.LastName; user.RoleID = p.RoleID; user.IsSysAdmin = p.IsSystemAdmin; user.ModifiedBy = this.LoggedInUser.Username; user.ModifiedOn = System.DateTime.Now; } return(context.SaveChanges()); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public bool AddPrivledge(PharmaBusinessObjects.Master.Privledge privledge) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { int result = 0; if (context.Privledges.Any(p => p.PriviledgeName.ToLower() == privledge.PrivledgeName.ToLower())) { throw new Exception("Privledge already exists"); } Privledges priv = new Privledges() { PriviledgeName = privledge.PrivledgeName, Status = privledge.Status, ControlName = privledge.ControlName, CreatedBy = this.LoggedInUser.Username, CreatedOn = DateTime.Now }; context.Privledges.Add(priv); result = context.SaveChanges(); return(result > 0); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public int UpdateAccountLedger(PharmaBusinessObjects.Master.AccountLedgerMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var accountLedgerMaster = context.AccountLedgerMaster.Where(q => q.AccountLedgerID == p.AccountLedgerID).FirstOrDefault(); if (accountLedgerMaster != null) { accountLedgerMaster.AccountLedgerName = p.AccountLedgerName; accountLedgerMaster.AccountLedgerCode = p.AccountLedgerCode; accountLedgerMaster.AccountLedgerTypeId = p.AccountLedgerTypeId; accountLedgerMaster.AccountTypeId = p.AccountTypeId; accountLedgerMaster.CreditControlCodeID = p.CreditControlCodeID; accountLedgerMaster.DebitControlCodeID = p.DebitControlCodeID; accountLedgerMaster.OpeningBalance = p.OpeningBalance; accountLedgerMaster.CreditDebit = p.CreditDebit; accountLedgerMaster.Status = p.Status; accountLedgerMaster.SalePurchaseTaxType = p.SalePurchaseTaxValue; accountLedgerMaster.CreatedBy = this.LoggedInUser.Username; accountLedgerMaster.CreatedOn = System.DateTime.Now; } return(context.SaveChanges()); } catch (DbEntityValidationException ex) { throw ex; } } }
public bool UpdatePrivledges(PharmaBusinessObjects.Master.Privledge privledge) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { int result = 0; Privledges priv = context.Privledges.Where(p => p.PrivledgeId == privledge.PrivledgeId).FirstOrDefault(); if (priv != null) { priv.PriviledgeName = privledge.PrivledgeName; priv.Status = privledge.Status; priv.ControlName = privledge.ControlName; priv.ModifiedBy = this.LoggedInUser.Username; priv.ModifiedOn = DateTime.Now; } result = context.SaveChanges(); return(result > 0); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public int AddCompany(PharmaBusinessObjects.Master.CompanyMaster company) { using (PharmaDBEntities context = new PharmaDBEntities()) { List <string> companyCodeList = context.CompanyMaster.Select(p => p.CompanyCode).ToList(); int maxCompanyCode = companyCodeList.Count > 0 ? companyCodeList.Max(p => Convert.ToInt32(p)) + 1 : 1; var companyCode = maxCompanyCode.ToString().PadLeft(6, '0'); Entity.CompanyMaster table = new Entity.CompanyMaster() { CompanyCode = companyCode, Status = company.Status, StockSummaryRequired = company.StockSummaryRequired, IsDirect = company.IsDirect, OrderPreferenceRating = company.OrderPreferenceRating, BillingPreferenceRating = company.BillingPreferenceRating, CompanyName = company.CompanyName, CreatedBy = this.LoggedInUser.Username, CreatedOn = System.DateTime.Now }; context.CompanyMaster.Add(table); if (context.SaveChanges() > 0) { return(table.CompanyId); } else { return(0); } } }
public int AddAccountLedger(PharmaBusinessObjects.Master.AccountLedgerMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { var maxAccountLedgerID = context.AccountLedgerMaster.Count() > 0 ? context.AccountLedgerMaster.Max(q => q.AccountLedgerID) + 1 : 1; var accountLedgerCode = "L" + maxAccountLedgerID.ToString().PadLeft(6, '0'); AccountLedgerMaster table = new AccountLedgerMaster() { AccountLedgerName = p.AccountLedgerName, AccountLedgerCode = accountLedgerCode, AccountLedgerTypeId = p.AccountLedgerTypeId, AccountTypeId = p.AccountTypeId, OpeningBalance = p.OpeningBalance, CreditDebit = p.CreditDebit, SalePurchaseTaxType = p.SalePurchaseTaxValue, Status = p.Status, CreatedBy = this.LoggedInUser.Username, CreatedOn = System.DateTime.Now }; var accountLedger = new Common.CommonDao().GetAccountLedgerTypes().Where(q => q.AccountLedgerTypeID == p.AccountLedgerTypeId).FirstOrDefault(); if (accountLedger.AccountLedgerTypeSystemName != Constants.AccountLedgerType.ControlCodes) { table.CreditControlCodeID = p.CreditControlCodeID; table.DebitControlCodeID = p.DebitControlCodeID; } context.AccountLedgerMaster.Add(table); return(context.SaveChanges()); } }
public void UpdateSaleDiscount(PharmaBusinessObjects.Common.Enums.SaleEntryChangeType changeType, decimal discount, decimal specialDiscount, decimal volumeDiscount, string itemCode, string customerCode) { using (PharmaDBEntities context = new PharmaDBEntities()) { CustomerLedger ledger = context.CustomerLedger.FirstOrDefault(p => p.CustomerLedgerCode == customerCode); ItemMaster master = context.ItemMaster.FirstOrDefault(p => p.ItemCode == itemCode); if (changeType == PharmaBusinessObjects.Common.Enums.SaleEntryChangeType.CompanyWiseChange) { var compItem = context.CustomerCompanyDiscountRef.Where(p => p.CustomerLedgerID == ledger.CustomerLedgerId && p.CompanyID == master.CompanyID && p.ItemID == null).FirstOrDefault(); if (compItem != null) { compItem.Normal = discount; } } else { var disItem = context.CustomerCompanyDiscountRef.Where(p => p.CustomerLedgerID == ledger.CustomerLedgerId && p.CompanyID == master.CompanyID && p.ItemID == master.ItemID).FirstOrDefault(); if (disItem != null) { disItem.Normal = discount; } master.SpecialDiscount = specialDiscount; } context.SaveChanges(); } }
public int UpdatePersonRoute(PharmaBusinessObjects.Master.PersonRouteMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var personRouteMaster = context.PersonRouteMaster.Where(q => q.PersonRouteID == p.PersonRouteID).FirstOrDefault(); if (personRouteMaster != null) { //personRouteMaster.PersonRouteCode = p.PersonRouteCode; personRouteMaster.PersonRouteName = p.PersonRouteName; personRouteMaster.ModifiedBy = this.LoggedInUser.Username; personRouteMaster.ModifiedOn = System.DateTime.Now; personRouteMaster.Status = p.Status; } if (context.SaveChanges() > 0) { return(personRouteMaster.PersonRouteID); } else { return(0); } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public bool DeleteItem(PharmaBusinessObjects.Master.ItemMaster existingItem) { using (PharmaDBEntities context = new PharmaDBEntities()) { int _result = 0; Entity.ItemMaster existingItemDB = context.ItemMaster.Where(p => p.ItemCode == existingItem.ItemCode && p.Status).FirstOrDefault(); if (existingItemDB != null) { existingItemDB.Status = false; existingItemDB.Status = existingItem.Status; existingItemDB.ModifiedBy = this.LoggedInUser.Username; existingItemDB.ModifiedOn = System.DateTime.Now; } _result = context.SaveChanges(); if (_result > 0) { return(true); } else { return(false); } } }
public int UpdateFifoBatchesByItemCode(FifoBatches fifoBatch) { using (PharmaDBEntities context = new PharmaDBEntities()) { FIFO fifo = context.FIFO.Where(p => p.FifoID == fifoBatch.FifoID).FirstOrDefault(); if (fifo != null) { fifo.Batch = fifoBatch.Batch; fifo.SaleRate = fifoBatch.SaleRate; fifo.WholeSaleRate = fifoBatch.WholeSaleRate; fifo.SpecialRate = fifoBatch.SpecialRate; fifo.MRP = fifoBatch.MRP; fifo.PurchaseRate = fifoBatch.PurchaseRate; fifo.IsOnHold = fifoBatch.IsOnHold; fifo.OnHoldRemarks = fifoBatch.OnHoldRemarks; fifo.MfgDate = fifoBatch.MfgDate; fifo.ExpiryDate = fifoBatch.ExpiryDate; context.SaveChanges(); return(1); } else { return(0); } } }
public int UpdatePersonalLedger(PharmaBusinessObjects.Master.PersonalLedgerMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var personlLedgerMaster = context.PersonalLedger.Where(q => q.PersonalLedgerId == p.PersonalLedgerId).FirstOrDefault(); if (personlLedgerMaster != null) { personlLedgerMaster.PersonalLedgerName = p.PersonalLedgerName; personlLedgerMaster.PersonalLedgerShortName = p.PersonalLedgerShortName; personlLedgerMaster.Address = p.Address; personlLedgerMaster.ContactPerson = p.ContactPerson; personlLedgerMaster.Mobile = p.Mobile; //personlLedgerMaster.Pager = p.Pager; //personlLedgerMaster.Fax = p.Fax; personlLedgerMaster.OfficePhone = p.OfficePhone; personlLedgerMaster.ResidentPhone = p.ResidentPhone; personlLedgerMaster.EmailAddress = p.EmailAddress; personlLedgerMaster.Status = p.Status; personlLedgerMaster.ModifiedBy = this.LoggedInUser.Username; personlLedgerMaster.ModifiedOn = System.DateTime.Now; } return(context.SaveChanges()); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public int AddPersonalLedger(PharmaBusinessObjects.Master.PersonalLedgerMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { var maxAccountLedgerID = context.PersonalLedger.Count() > 0 ? context.PersonalLedger.Max(q => q.PersonalLedgerId) + 1 : 1; var personaltLedgerCode = "P" + maxAccountLedgerID.ToString().PadLeft(6, '0'); PersonalLedger table = new PersonalLedger() { PersonalLedgerCode = personaltLedgerCode, PersonalLedgerName = p.PersonalLedgerName, PersonalLedgerShortName = p.PersonalLedgerShortName, Address = p.Address, ContactPerson = p.ContactPerson, Mobile = p.Mobile, //Pager = p.Pager, //Fax = p.Fax, OfficePhone = p.OfficePhone, ResidentPhone = p.ResidentPhone, EmailAddress = p.EmailAddress, Status = p.Status, CreatedBy = this.LoggedInUser.Username, CreatedOn = System.DateTime.Now }; context.PersonalLedger.Add(table); return(context.SaveChanges()); } }
public bool DeleteUnSavedData(long purchaseSaleBookHeaderID) { try { using (PharmaDBEntities context = new PharmaDBEntities()) { var lineItems = context.TempPurchaseSaleBookLineItem.Where(p => p.PurchaseSaleBookHeaderID == purchaseSaleBookHeaderID).ToList(); var header = context.TempPurchaseSaleBookHeader.Where(p => p.PurchaseSaleBookHeaderID == purchaseSaleBookHeaderID).FirstOrDefault(); if (lineItems != null && lineItems.Count > 0) { context.TempPurchaseSaleBookLineItem.RemoveRange(lineItems); } if (header != null) { context.TempPurchaseSaleBookHeader.Remove(header); } context.SaveChanges(); } } catch (Exception ex) { throw ex; } return(true); }
public bool UpdateRole(PharmaBusinessObjects.Master.Role role) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { int result = 0; Roles roles = context.Roles.Where(p => p.RoleId == role.RoleId).FirstOrDefault(); if (roles != null) { roles.RoleName = role.RoleName; roles.Status = role.Status; roles.CreatedBy = this.LoggedInUser.Username; roles.CreatedOn = DateTime.Now; } result = context.SaveChanges(); var privledges = context.RolePrivledges.Where(p => p.RoleId == role.RoleId).ToList(); privledges.ForEach(p => context.RolePrivledges.Remove(p)); foreach (var item in role.PrivledgeList) { RolePrivledges priv = new RolePrivledges() { RoleId = role.RoleId, PrivledgeId = item.PrivledgeId }; } result = result + context.SaveChanges(); return(result > 0); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public int InsertRSMData() { try { string query = "select * from MASTERS where slcd = 'RS'"; DataTable dtRSMMaster = dbConnection.GetData(query); List <PharmaDAL.Entity.PersonRouteMaster> listRSMMaster = new List <PharmaDAL.Entity.PersonRouteMaster>(); int _result = 0; using (PharmaDBEntities context = new PharmaDBEntities()) { var systemName = PharmaBusinessObjects.Common.Constants.RecordType.RSM; int recordTypeID = context.RecordType.Where(q => q.SystemName == systemName).FirstOrDefault().RecordTypeId; var maxRSMID = context.PersonRouteMaster.Where(q => q.RecordTypeId == recordTypeID).Count(); if (dtRSMMaster != null && dtRSMMaster.Rows.Count > 0) { foreach (DataRow dr in dtRSMMaster.Rows) { maxRSMID++; string originalPersonRouteCode = Convert.ToString(dr["ACNO"]).TrimEnd(); string mappedPersonRouteCode = systemName + maxRSMID.ToString().PadLeft(3, '0'); Common.rsmCodeMap.Add(new RSMCodeMap() { OriginalRSMCode = originalPersonRouteCode, MappedRSMCode = mappedPersonRouteCode }); PharmaDAL.Entity.PersonRouteMaster newRSMMaster = new PharmaDAL.Entity.PersonRouteMaster() { PersonRouteCode = mappedPersonRouteCode, PersonRouteName = Convert.ToString(dr["ACName"]).TrimEnd(), RecordTypeId = recordTypeID, CreatedBy = "admin", CreatedOn = DateTime.Now, Status = Convert.ToChar(dr["ACSTS"]) == '*' ? false : true }; listRSMMaster.Add(newRSMMaster); } } context.PersonRouteMaster.AddRange(listRSMMaster); _result = context.SaveChanges(); return(_result); } } catch (Exception ex) { throw ex; } }
public bool AddRole(PharmaBusinessObjects.Master.Role role) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { int result = 0; if (context.Roles.Any(p => p.RoleName.ToLower() == role.RoleName.ToLower())) { throw new Exception("Role already exists"); } Roles roles = new Roles() { RoleName = role.RoleName, Status = role.Status, CreatedBy = this.LoggedInUser.Username, CreatedOn = DateTime.Now }; context.Roles.Add(roles); result = context.SaveChanges(); foreach (Privledge item in role.PrivledgeList) { RolePrivledges priv = new RolePrivledges(); priv.RoleId = roles.RoleId; priv.PrivledgeId = item.PrivledgeId; context.RolePrivledges.Add(priv); } result = result + context.SaveChanges(); return(result > 0); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public void ClearTempTransaction(PharmaBusinessObjects.Transaction.TransactionEntity entity) { try { using (PharmaDBEntities context = new PharmaDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { try { var tempAdjustments = context.TempBillOutStandingsAudjustment.Where(x => x.ReceiptPaymentID == entity.ReceiptPaymentID).ToList(); ///Rollback all amount deducted amount from OS amount from Bill outstanding /// foreach (var tempAdj in tempAdjustments) { if (tempAdj.TempReceiptPayment.OldReceiptPaymentID != null) { var billOutStanding = context.BillOutStandings.Where(p => p.BillOutStandingsID == tempAdj.TempReceiptPayment.OldReceiptPaymentID).FirstOrDefault(); if (billOutStanding != null) { billOutStanding.OSAmount = tempAdj.BillOutStandings.BillAmount - tempAdj.Amount; } // tempAdj.BillOutStandings.OSAmount = tempAdj.BillOutStandings.BillAmount - tempAdj.Amount; } else { tempAdj.BillOutStandings.OSAmount += tempAdj.Amount; } } context.TempBillOutStandingsAudjustment.RemoveRange(tempAdjustments); var tempReceipt = context.TempReceiptPayment.Where(x => x.ReceiptPaymentID == entity.ReceiptPaymentID).ToList(); context.TempReceiptPayment.RemoveRange(tempReceipt); context.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); throw; } } } } catch (Exception ex) { throw ex; } }
public int DeletePersonalLedger(PharmaBusinessObjects.Master.PersonalLedgerMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { var personalLedgerMaster = context.PersonalLedger.FirstOrDefault(q => q.PersonalLedgerCode == p.PersonalLedgerCode); if (personalLedgerMaster != null) { personalLedgerMaster.Status = false; personalLedgerMaster.ModifiedBy = this.LoggedInUser.Username; personalLedgerMaster.ModifiedOn = System.DateTime.Now; } return(context.SaveChanges()); } }
public int DeleteCompany(int companyId) { using (PharmaDBEntities context = new PharmaDBEntities()) { var companyMaster = context.CompanyMaster.FirstOrDefault(p => p.CompanyId == companyId); if (companyMaster != null) { companyMaster.Status = false; companyMaster.ModifiedBy = this.LoggedInUser.Username; companyMaster.ModifiedOn = System.DateTime.Now; } return(context.SaveChanges()); } }
public int DeleteCustomerLedger(int customerLedgerID) { using (PharmaDBEntities context = new PharmaDBEntities()) { var customerLedgerMaster = context.CustomerLedger.FirstOrDefault(p => p.CustomerLedgerId == customerLedgerID); if (customerLedgerMaster != null) { customerLedgerMaster.Status = false; customerLedgerMaster.ModifiedBy = this.LoggedInUser.Username; customerLedgerMaster.ModifiedOn = System.DateTime.Now; } return(context.SaveChanges()); } }
public int UpdateCompany(PharmaBusinessObjects.Master.CompanyMaster company) { using (PharmaDBEntities context = new PharmaDBEntities()) { var companyMaster = context.CompanyMaster.FirstOrDefault(p => p.CompanyId == company.CompanyId); if (companyMaster != null) { companyMaster.Status = company.Status; companyMaster.StockSummaryRequired = company.StockSummaryRequired; companyMaster.IsDirect = company.IsDirect; companyMaster.OrderPreferenceRating = company.OrderPreferenceRating; companyMaster.BillingPreferenceRating = company.BillingPreferenceRating; companyMaster.CompanyName = company.CompanyName; companyMaster.ModifiedBy = this.LoggedInUser.Username; companyMaster.ModifiedOn = System.DateTime.Now; } return(context.SaveChanges()); } }
public int AddUser(PharmaBusinessObjects.Master.UserMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { Entity.Users table = new Entity.Users() { Username = p.Username, Password = p.Password, FirstName = p.FirstName, LastName = p.LastName, RoleID = p.RoleID, IsSysAdmin = p.IsSystemAdmin, CreatedBy = this.LoggedInUser.Username, CreatedOn = System.DateTime.Now, Status = p.Status }; context.Users.Add(table); return(context.SaveChanges()); } }
public int AddPersonRoute(PharmaBusinessObjects.Master.PersonRouteMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var maxPersonRouteMasterID = context.PersonRouteMaster.Where(q => q.RecordTypeId == p.RecordTypeId).Count() + 1; var systemName = context.RecordType.Where(q => q.RecordTypeId == p.RecordTypeId).FirstOrDefault().SystemName; var personRouteCode = systemName + maxPersonRouteMasterID.ToString().PadLeft(3, '0'); Entity.PersonRouteMaster table = new Entity.PersonRouteMaster() { PersonRouteID = p.PersonRouteID, PersonRouteCode = personRouteCode, PersonRouteName = p.PersonRouteName, RecordTypeId = p.RecordTypeId, CreatedBy = this.LoggedInUser.LastName, CreatedOn = System.DateTime.Now, Status = p.Status }; context.PersonRouteMaster.Add(table); if (context.SaveChanges() > 0) { return(table.PersonRouteID); } else { return(0); } } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }
public void ClearTempBillAdjustment(PharmaBusinessObjects.Transaction.TransactionEntity entity) { try { using (PharmaDBEntities context = new PharmaDBEntities()) { var tempBillAdjustmentForEntity = context.TempBillOutStandingsAudjustment.Where(q => q.ReceiptPaymentID == entity.ReceiptPaymentID && q.LedgerTypeCode == entity.EntityCode) .Select(q => q).ToList(); ///Rollback all amount deducted amount from OS amount from Bill outstanding /// foreach (var tempAdj in tempBillAdjustmentForEntity) { if (tempAdj.TempReceiptPayment.OldReceiptPaymentID != null) { var billOutStanding = context.BillOutStandings.Where(p => p.BillOutStandingsID == tempAdj.TempReceiptPayment.OldReceiptPaymentID).FirstOrDefault(); if (billOutStanding != null) { billOutStanding.OSAmount = tempAdj.BillOutStandings.BillAmount - tempAdj.Amount; } // tempAdj.BillOutStandings.OSAmount = tempAdj.BillOutStandings.BillAmount - tempAdj.Amount; } else { tempAdj.BillOutStandings.OSAmount += tempAdj.Amount; } } context.TempBillOutStandingsAudjustment.RemoveRange(tempBillAdjustmentForEntity); context.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public int InsertData(DataTable dtSalePur) { using (PharmaDBEntities context = new PharmaDBEntities()) { int _result = 0; List <PharmaDAL.Entity.PurchaseSaleBookLineItem> listPurchaseSaleBookLineItem = new List <PharmaDAL.Entity.PurchaseSaleBookLineItem>(); if (dtSalePur != null && dtSalePur.Rows.Count > 0) { foreach (DataRow dr in dtSalePur.Rows) { try { PharmaDAL.Entity.PurchaseSaleBookLineItem newPurchaseSaleBookLineItem = new PharmaDAL.Entity.PurchaseSaleBookLineItem(); string oldVNo = string.Empty; string oldPVNo = string.Empty; oldVNo = Convert.ToString(dr["vno"]).Trim(); oldPVNo = Convert.ToString(dr["PURVNO"]).Trim(); var header = Common.voucherNumberMap.Where(p => p.OriginalVoucherNumber == oldVNo).FirstOrDefault(); if (header != null) { string oldItemCode = Convert.ToString(dr["ITEMC"]).Trim(); string newItemCode = Common.itemCodeMap.Where(p => p.OriginalItemCode == oldItemCode).Select(p => p.MappedItemCode).FirstOrDefault(); if (string.IsNullOrEmpty(newItemCode)) { throw new Exception(string.Format("FIFO: Item Code Not found in Item Master {0}", oldItemCode)); } string oldPSType = Convert.ToString(dr["PSTYPE"]); if (!string.IsNullOrEmpty(oldPSType)) { string newPSType = Common.accountLedgerCodeMap.Where(p => p.OriginalAccountLedgerCode == oldPSType).Select(p => p.MappedAccountLedgerCode).FirstOrDefault(); if (!string.IsNullOrEmpty(newPSType)) { newPurchaseSaleBookLineItem.PurchaseSaleTypeCode = newPSType; } } newPurchaseSaleBookLineItem.PurchaseSaleBookHeaderID = header.MappedPurchaseHeaderID; //newPurchaseSaleBookLineItem.FifoID = 0; if (dr["PURVDT"] != null) { newPurchaseSaleBookLineItem.PurchaseBillDate = CommonMethods.SafeConversionDatetime(Convert.ToString(dr["PURVDT"])); } if (!string.IsNullOrEmpty(oldPVNo)) { var pHeader = Common.voucherNumberMap.Where(p => p.OriginalVoucherNumber == oldPVNo).FirstOrDefault(); if (pHeader != null) { newPurchaseSaleBookLineItem.PurchaseVoucherNumber = pHeader.MappedVoucherNumber; } } if (dr["PURSRLNO"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["PURSRLNO"]))) { newPurchaseSaleBookLineItem.PurchaseSrlNo = Convert.ToInt32(Convert.ToString(dr["PURSRLNO"]).Trim()); } newPurchaseSaleBookLineItem.ItemCode = newItemCode; newPurchaseSaleBookLineItem.Batch = Convert.ToString(dr["BATCH"]); newPurchaseSaleBookLineItem.BatchNew = Convert.ToString(dr["BATCH1"]); newPurchaseSaleBookLineItem.Quantity = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["QTY"])); newPurchaseSaleBookLineItem.FreeQuantity = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["FQTY"])); newPurchaseSaleBookLineItem.PurchaseSaleRate = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["PSRATE"])); newPurchaseSaleBookLineItem.EffecivePurchaseSaleRate = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["EPSRATE"])) + CommonMethods.SafeConversionDecimal(Convert.ToString(dr["EPCOST"])); newPurchaseSaleBookLineItem.SurCharge = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SC"])); newPurchaseSaleBookLineItem.SalePurchaseTax = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["TAX"])); newPurchaseSaleBookLineItem.TaxAmount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["TAXAMT"])); newPurchaseSaleBookLineItem.LocalCentral = header.LocalCentral; if (header.LocalCentral == "L") { newPurchaseSaleBookLineItem.SGST = newPurchaseSaleBookLineItem.TaxAmount * (decimal)0.5; newPurchaseSaleBookLineItem.CGST = newPurchaseSaleBookLineItem.TaxAmount * (decimal)0.5; } else { newPurchaseSaleBookLineItem.IGST = newPurchaseSaleBookLineItem.TaxAmount; } newPurchaseSaleBookLineItem.Amount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SALEAMT"])); // PSSRATE * QYTY = GROSS = SALEAMT newPurchaseSaleBookLineItem.Discount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["DIS"])); newPurchaseSaleBookLineItem.SpecialDiscount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SPLDIS"])); newPurchaseSaleBookLineItem.DiscountQuantity = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["DISQTY"])); newPurchaseSaleBookLineItem.VolumeDiscount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["VDIS"])); newPurchaseSaleBookLineItem.Scheme1 = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SCHEME1"])); newPurchaseSaleBookLineItem.Scheme2 = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SCHEME2"])); newPurchaseSaleBookLineItem.IsHalfScheme = false;// Convert.ToString(dr["HALF"]) == "Y" ? true : false;// Convert.ToBoolean(dr["HALF"]); // ??? newPurchaseSaleBookLineItem.HalfSchemeRate = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["HALFP"])); newPurchaseSaleBookLineItem.CostAmount = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["EPSRATE"])) + CommonMethods.SafeConversionDecimal(Convert.ToString(dr["EPCOST"]));//?? newPurchaseSaleBookLineItem.GrossAmount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SALEAMT"])); newPurchaseSaleBookLineItem.SchemeAmount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SCAMT"])); newPurchaseSaleBookLineItem.DiscountAmount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["DISAMT"])); newPurchaseSaleBookLineItem.SurchargeAmount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SCAMT"])); newPurchaseSaleBookLineItem.ConversionRate = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["CONVRATE"])); newPurchaseSaleBookLineItem.MRP = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["MRP"])); // newPurchaseSaleBookLineItem.MfgDate = Convert.ToDateTime(dr["MRP"]); newPurchaseSaleBookLineItem.ExpiryDate = CommonMethods.SafeConversionDatetime(Convert.ToString(dr["EXPDT"])); newPurchaseSaleBookLineItem.SaleRate = 0;//Convert.ToDecimal(dr["MRP"]); //?? newPurchaseSaleBookLineItem.WholeSaleRate = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["WSRATE"])); newPurchaseSaleBookLineItem.SpecialRate = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["SPLRATE"])); newPurchaseSaleBookLineItem.SpecialDiscountAmount = 0; // Convert.ToDecimal(dr["SPLRATE"]); newPurchaseSaleBookLineItem.VolumeDiscountAmount = 0; // Convert.ToDecimal(dr["SPLRATE"]); newPurchaseSaleBookLineItem.TotalDiscountAmount = (decimal)CommonMethods.SafeConversionDecimal(Convert.ToString(dr["DISAMT"])); newPurchaseSaleBookLineItem.CreatedBy = "admin"; newPurchaseSaleBookLineItem.CreatedOn = DateTime.Now; newPurchaseSaleBookLineItem.ModifiedBy = "admin"; newPurchaseSaleBookLineItem.ModifiedOn = DateTime.Now; listPurchaseSaleBookLineItem.Add(newPurchaseSaleBookLineItem); } else { log.Info(string.Format("PurchaseSaleBookHeader: Error in VNo {0}}", Convert.ToString(dr["vno"]).Trim())); } } catch (Exception ex) { log.Info(string.Format("PurchaseSaleBookLineItem: Error in Voucher Number {0}", Convert.ToString(dr["vno"]).Trim())); log.Info(ex.ToString()); } } } context.PurchaseSaleBookLineItem.AddRange(listPurchaseSaleBookLineItem); _result = context.SaveChanges(); return(_result); } }
public int InsertFIFOData() { try { string query = "select * from FIFO"; DataTable dtFIFO = dbConnection.GetData(query); List <PharmaDAL.Entity.FIFO> listFIFO = new List <PharmaDAL.Entity.FIFO>(); int _result = 0; using (PharmaDBEntities context = new PharmaDBEntities()) { if (dtFIFO != null && dtFIFO.Rows.Count > 0) { foreach (DataRow dr in dtFIFO.Rows) { try { string originalItemCode = Convert.ToString(dr["itemc"]).TrimEnd(); string mappedItemCode = Common.itemCodeMap.Where(x => x.OriginalItemCode == originalItemCode).Select(x => x.MappedItemCode).FirstOrDefault(); if (mappedItemCode == null) { log.Error(string.Format("FIFO: Item Code Not found in Item Master {0}", originalItemCode)); throw new Exception(); } PharmaDAL.Entity.FIFO newFIFO = new PharmaDAL.Entity.FIFO(); newFIFO.PurchaseSaleBookHeaderID = null; newFIFO.VoucherNumber = (Convert.ToString(dr["vno"]).TrimEnd()).PadLeft(8, '0'); newFIFO.VoucherDate = Convert.ToDateTime(dr["vdt"]); newFIFO.SRLNO = Convert.ToInt32(dr["srlno"]); newFIFO.ItemCode = mappedItemCode; newFIFO.PurchaseBillNo = Convert.ToString(dr["pbillno"]).TrimEnd(); newFIFO.Batch = Convert.ToString(dr["batch"]).TrimEnd(); newFIFO.ExpiryDate = CommonMethods.SafeConversionDatetime(Convert.ToString(dr["expdt"]).TrimEnd()); newFIFO.Quantity = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["qty"]).TrimEnd()) ?? default(decimal); newFIFO.BalanceQuanity = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["bqty"]).TrimEnd()) ?? default(decimal); newFIFO.PurchaseTypeId = null; newFIFO.PurchaseRate = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["prate"]).TrimEnd()) ?? default(decimal); newFIFO.EffectivePurchaseRate = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["eprate"]).TrimEnd()); newFIFO.SaleRate = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["srate"]).TrimEnd()) ?? default(decimal); newFIFO.WholeSaleRate = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["wsrate"]).TrimEnd()); newFIFO.SpecialRate = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["splrate"]).TrimEnd()); newFIFO.MRP = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["mrp"]).TrimEnd()) ?? default(decimal); newFIFO.Scheme1 = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["scheme1"]).TrimEnd()); newFIFO.Scheme2 = CommonMethods.SafeConversionDecimal(Convert.ToString(dr["scheme2"]).TrimEnd()); newFIFO.IsOnHold = Convert.ToString(dr["hold"]).TrimEnd() == "Y" ? true : false; newFIFO.OnHoldRemarks = null; newFIFO.MfgDate = CommonMethods.SafeConversionDatetime(Convert.ToString(dr["mfgdt"]).TrimEnd()); newFIFO.UPC = Convert.ToString(dr["barcode"]).TrimEnd(); listFIFO.Add(newFIFO); } catch (Exception ex) { log.Info(string.Format("FIFO: Error in Voucher Number {0}", Convert.ToString(dr["vno"]).TrimEnd())); } } } context.FIFO.AddRange(listFIFO); _result = context.SaveChanges(); return(_result); } } catch (DbEntityValidationException ex) { log.Info(string.Format("FIFO: Error {0}", ex.Message)); throw ex; } catch (Exception ex) { log.Info(string.Format("FIFO: Error {0}", ex.Message)); 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"]).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 InsertSupplierCompanyReferenceData() { try { //string query = "select * from DIS where Icode not in (select distinct acno from masters where slcd = 'IT') and Ccode not in (select distinct acno from masters where slcd = 'CO')"; string query = "select * from DIS1 WHERE Disamt > 0"; DataTable dtSupplierCompanyRef = dbConnection.GetData(query); List <SupplierCompanyDiscountRef> listSupplierCompanyRef = new List <SupplierCompanyDiscountRef>(); int _result = 0; using (PharmaDBEntities context = new PharmaDBEntities()) { if (dtSupplierCompanyRef != null && dtSupplierCompanyRef.Rows.Count > 0) { var companyList = context.CompanyMaster.Select(p => p).ToList(); var supplierLedgerList = context.SupplierLedger.Select(p => p).ToList(); var itemList = context.ItemMaster.Select(p => p).ToList(); foreach (DataRow dr in dtSupplierCompanyRef.Rows) { try { if (dr["Disamt"] != null && Convert.ToDecimal(dr["Disamt"]) > 0) { string supplierLedgerCode = Common.supplierLedgerCodeMap.Where(p => p.OriginalSupplierLedgerCode == Convert.ToString(dr["PCode"]).TrimEnd()).FirstOrDefault().MappedSupplierLedgerCode; int supplierLedgerID = supplierLedgerList.Where(p => p.SupplierLedgerCode == supplierLedgerCode).FirstOrDefault().SupplierLedgerId; string companyCode = string.Empty; var company = Common.companyCodeMap.Where(p => p.OriginalCompanyCode == Convert.ToString(dr["Ccode"]).TrimEnd()).FirstOrDefault(); if (company == null) { continue; } companyCode = company.MappedCompanyCode; int companyID = companyList.Where(p => p.CompanyCode == companyCode).FirstOrDefault().CompanyId; string itemCode = string.IsNullOrEmpty(Convert.ToString(dr["ICode"]).TrimEnd()) ? null : Common.itemCodeMap.Where(p => p.OriginalItemCode == Convert.ToString(dr["ICode"]).TrimEnd()).FirstOrDefault().MappedItemCode; int? itemID = itemCode == null ? (int?)null : itemList.Where(p => p.ItemCode == itemCode).FirstOrDefault().ItemID; SupplierCompanyDiscountRef newSupplierCompanyRef = new SupplierCompanyDiscountRef() { SupplierLedgerID = supplierLedgerID, CompanyID = companyID, ItemID = itemID, Normal = Convert.ToDecimal(dr["Disamt"]), Breakage = Convert.ToDecimal(dr["Disamtbe"]), Expired = Convert.ToDecimal(dr["Disamtex"]), IsLessEcise = Convert.ToString(dr["Less_ex"]) == "Y" ? true : false }; listSupplierCompanyRef.Add(newSupplierCompanyRef); } } catch (Exception) { //throw ex; } } } context.SupplierCompanyDiscountRef.AddRange(listSupplierCompanyRef); _result = context.SaveChanges(); return(_result); } } catch (Exception ex) { throw ex; } }
public int InsertSupplierLedgerMasterData() { try { string query = "select * from ACM where slcd = 'SL'"; DataTable dtSupplierLedgerMaster = dbConnection.GetData(query); List <SupplierLedger> listSupplierLedgerMaster = new List <SupplierLedger>(); int _result = 0; using (PharmaDBEntities context = new PharmaDBEntities()) { var maxSupplierLedgerID = context.SupplierLedger.Count(); if (dtSupplierLedgerMaster != null && dtSupplierLedgerMaster.Rows.Count > 0) { foreach (DataRow dr in dtSupplierLedgerMaster.Rows) { try { maxSupplierLedgerID++; string supplierLedgerCode = "S" + maxSupplierLedgerID.ToString().PadLeft(6, '0'); string originalSupplierLedgerCode = Convert.ToString(dr["ACNO"]).TrimEnd(); Common.supplierLedgerCodeMap.Add(new SupplierLedgerCodeMap() { OriginalSupplierLedgerCode = originalSupplierLedgerCode, MappedSupplierLedgerCode = supplierLedgerCode }); string areaCode = Common.areaCodeMap.Where(p => p.OriginalAreaCode == Convert.ToString(dr["PAREA"]).TrimEnd()).FirstOrDefault().MappedAreaCode; int areaID = context.PersonRouteMaster.Where(q => q.PersonRouteCode == areaCode).FirstOrDefault().PersonRouteID; string purchaseLedgerCode = Common.accountLedgerCodeMap.Where(q => q.OriginalAccountLedgerCode == Convert.ToString(dr["PCODE"]).TrimEnd()).FirstOrDefault().MappedAccountLedgerCode; int purchaseTypeID = context.AccountLedgerMaster.Where(p => p.AccountLedgerCode == purchaseLedgerCode).FirstOrDefault().AccountLedgerID; SupplierLedger newSupplierLedgerMaster = new SupplierLedger() { SupplierLedgerCode = supplierLedgerCode, SupplierLedgerName = Convert.ToString(dr["ACName"]).TrimEnd(), SupplierLedgerShortName = Convert.ToString(dr["Alt_name_1"]).TrimEnd(), SupplierLedgerShortDesc = Convert.ToString(dr["Alt_name_2"]).TrimEnd(), Address = string.Concat(Convert.ToString(dr["ACAD1"]).TrimEnd(), " ", Convert.ToString(dr["ACAD2"]).TrimEnd(), " ", Convert.ToString(dr["ACAD3"]).TrimEnd()), ContactPerson = Convert.ToString(dr["ACAD4"]).TrimEnd(), Mobile = Convert.ToString(dr["Mobile"]).TrimEnd(), //Pager = Convert.ToString(dr["Pager"]).TrimEnd(), //Fax = Convert.ToString(dr["Fax"]).TrimEnd(), OfficePhone = Convert.ToString(dr["Telo"]).TrimEnd(), ResidentPhone = Convert.ToString(dr["Telr"]).TrimEnd(), EmailAddress = Convert.ToString(dr["Email"]).TrimEnd(), AreaId = areaID, CreditDebit = Convert.ToDecimal(dr["Abop"]) > 0 ? Convert.ToString(PharmaBusinessObjects.Common.Enums.TransType.D) : Convert.ToString(PharmaBusinessObjects.Common.Enums.TransType.C), DLNo = "test", // Convert.ToString(dr["Stnol"]).TrimEnd(), OpeningBal = Convert.ToDecimal(dr["Abop"]), TaxRetail = Convert.ToString(dr["Vat"]).TrimEnd(), Status = Convert.ToChar(dr["ACSTS"]) == '*' ? false : true, PurchaseTypeID = purchaseTypeID, CreatedBy = "admin", CreatedOn = DateTime.Now }; listSupplierLedgerMaster.Add(newSupplierLedgerMaster); } catch (Exception) { log.Info("SuPPLIER LEDGER : Error in ACName --> " + Convert.ToString(dr["ACName"]).TrimEnd()); } } } context.SupplierLedger.AddRange(listSupplierLedgerMaster); _result = context.SaveChanges(); return(_result); } } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } }