public int AddSupplierLedger(PharmaBusinessObjects.Master.SupplierLedgerMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var maxSupplierLedgerID = context.SupplierLedger.Count() + 1; var supplierLedgerCode = "S" + maxSupplierLedgerID.ToString().PadLeft(6, '0'); Entity.SupplierLedger table = new Entity.SupplierLedger() { SupplierLedgerCode = supplierLedgerCode, SupplierLedgerName = p.SupplierLedgerName, SupplierLedgerShortName = p.SupplierLedgerShortName, Address = p.Address, ContactPerson = p.ContactPerson, Mobile = p.Mobile, OfficePhone = p.OfficePhone, ResidentPhone = p.ResidentPhone, EmailAddress = p.EmailAddress, AreaId = p.AreaId, CreditDebit = p.CreditDebit, OpeningBal = p.OpeningBal, TaxRetail = p.TaxRetail, PurchaseTypeID = p.PurchaseTypeId, DLNo = p.DLNo, GSTNo = p.GSTNo, CINNo = p.CINNo, LINNo = p.LINNo, ServiceTaxNo = p.ServiceTaxNo, PANNo = p.PANNo, Status = p.Status, CreatedBy = this.LoggedInUser.Username, CreatedOn = System.DateTime.Now }; context.SupplierLedger.Add(table); ///Add Supplier Company discount data /// var previousMappings = context.SupplierCompanyDiscountRef.Where(x => x.SupplierLedgerID == p.SupplierLedgerId).ToList(); context.SupplierCompanyDiscountRef.RemoveRange(previousMappings); foreach (var newEntry in p.SupplierCompanyDiscountList) { context.SupplierCompanyDiscountRef.Add(new Entity.SupplierCompanyDiscountRef() { SupplierLedgerID = p.SupplierLedgerId, CompanyID = newEntry.CompanyID, Normal = newEntry.Normal, Breakage = newEntry.Breakage, Expired = newEntry.Expired }); ///All entry for item mappings /// if (newEntry.SupplierItemDiscountMapping != null) { foreach (var newItem in newEntry.SupplierItemDiscountMapping) { context.SupplierCompanyDiscountRef.Add(new Entity.SupplierCompanyDiscountRef() { SupplierLedgerID = table.SupplierLedgerId, CompanyID = newEntry.CompanyID, ItemID = newItem.ItemID, Normal = newItem.Normal, Breakage = newItem.Breakage, Expired = newItem.Expired }); } } } return(context.SaveChanges()); } catch (DbEntityValidationException ex) { throw ex; } } }
internal int UpdateSupplierLedger(PharmaBusinessObjects.Master.SupplierLedgerMaster p) { return(new SupplierLedgerMasterDao(this.LoggedInUser).UpdateSupplierLedger(p)); }
public int UpdateSupplierLedger(PharmaBusinessObjects.Master.SupplierLedgerMaster p) { using (PharmaDBEntities context = new PharmaDBEntities()) { try { var supplierLedgerMaster = context.SupplierLedger.Where(q => q.SupplierLedgerId == p.SupplierLedgerId).FirstOrDefault(); if (supplierLedgerMaster != null) { supplierLedgerMaster.SupplierLedgerName = p.SupplierLedgerName; supplierLedgerMaster.SupplierLedgerShortName = p.SupplierLedgerShortName; supplierLedgerMaster.Address = p.Address; supplierLedgerMaster.ContactPerson = p.ContactPerson; supplierLedgerMaster.Mobile = p.Mobile; supplierLedgerMaster.OfficePhone = p.OfficePhone; supplierLedgerMaster.ResidentPhone = p.ResidentPhone; supplierLedgerMaster.EmailAddress = p.EmailAddress; supplierLedgerMaster.AreaId = p.AreaId; supplierLedgerMaster.CreditDebit = p.CreditDebit; supplierLedgerMaster.OpeningBal = p.OpeningBal; supplierLedgerMaster.TaxRetail = p.TaxRetail; supplierLedgerMaster.DLNo = p.DLNo; supplierLedgerMaster.GSTNo = p.GSTNo; supplierLedgerMaster.CINNo = p.CINNo; supplierLedgerMaster.LINNo = p.LINNo; supplierLedgerMaster.ServiceTaxNo = p.ServiceTaxNo; supplierLedgerMaster.PANNo = p.PANNo; supplierLedgerMaster.Status = p.Status; supplierLedgerMaster.ModifiedBy = this.LoggedInUser.Username; supplierLedgerMaster.ModifiedOn = System.DateTime.Now; } ///Add Supplier Company discount data /// var previousMappings = context.SupplierCompanyDiscountRef.Where(x => x.SupplierLedgerID == p.SupplierLedgerId).ToList(); context.SupplierCompanyDiscountRef.RemoveRange(previousMappings); foreach (var newEntry in p.SupplierCompanyDiscountList) { context.SupplierCompanyDiscountRef.Add(new Entity.SupplierCompanyDiscountRef() { SupplierLedgerID = p.SupplierLedgerId, CompanyID = newEntry.CompanyID, Normal = newEntry.Normal, Breakage = newEntry.Breakage, Expired = newEntry.Expired }); ///All entry for item mappings /// if (newEntry.SupplierItemDiscountMapping != null) { foreach (var newItem in newEntry.SupplierItemDiscountMapping) { context.SupplierCompanyDiscountRef.Add(new Entity.SupplierCompanyDiscountRef() { SupplierLedgerID = p.SupplierLedgerId, CompanyID = newEntry.CompanyID, ItemID = newItem.ItemID, Normal = newItem.Normal, Breakage = newItem.Breakage, Expired = newItem.Expired }); } } } return(context.SaveChanges()); } catch (System.Data.Entity.Validation.DbEntityValidationException ex) { throw ex; } } }