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 List <Entity.ItemMaster> GetItemMasterList() { try { List <Entity.ItemMaster> objList = new List <Entity.ItemMaster>(); foreach (var data in masterRepository.GetItemMasterList()) { Entity.ItemMaster obj = new Entity.ItemMaster(); obj.ItemId = data.ItemId; obj.ImagesPath = data.ImagesPath; obj.Active = data.Active; obj.CreatedBy = data.CreatedBy; obj.CreatedDate = data.CreatedDate; obj.ItemType = data.ItemType; obj.Name = data.Name; obj.Rate = data.Rate; objList.Add(obj); } return(objList); } catch (Exception ex) { return(new List <Entity.ItemMaster>()); } }
public bool AddNewItem(PharmaBusinessObjects.Master.ItemMaster newItem) { try { using (PharmaDBEntities context = new PharmaDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { try { int _result = 0; int totalItemsFromSameCompany = context.ItemMaster.Where(p => p.CompanyID == newItem.CompanyID).Count(); totalItemsFromSameCompany++; //Add HSN if does not exist if (!context.HSNCode.Where(x => x.HSNCode1 == newItem.HSNCode).Any()) { Entity.HSNCode HSNCodeDBEntry = new HSNCode() { HSNCode1 = newItem.HSNCode, HSNDescription = newItem.HSNCode + "- Default Description", CreatedBy = this.LoggedInUser.Username, CreatedOn = System.DateTime.Now }; context.HSNCode.Add(HSNCodeDBEntry); } string companyCode = context.CompanyMaster.Where(p => p.CompanyId == newItem.CompanyID).FirstOrDefault().CompanyCode; Entity.ItemMaster newItemMasterDB = new Entity.ItemMaster(); newItemMasterDB.ItemCode = string.Concat(companyCode, totalItemsFromSameCompany.ToString().PadLeft((9 - companyCode.Length), '0')); newItemMasterDB.ItemName = newItem.ItemName; newItemMasterDB.CompanyID = newItem.CompanyID; newItemMasterDB.ConversionRate = newItem.ConversionRate; newItemMasterDB.ShortName = newItem.ShortName; newItemMasterDB.Packing = newItem.Packing; newItemMasterDB.PurchaseRate = newItem.PurchaseRate; newItemMasterDB.MRP = newItem.MRP; newItemMasterDB.SaleRate = newItem.SaleRate; newItemMasterDB.SpecialRate = newItem.SpecialRate; newItemMasterDB.WholeSaleRate = newItem.WholeSaleRate; newItemMasterDB.SaleExcise = newItem.SaleExcise; newItemMasterDB.SurchargeOnSale = newItem.SurchargeOnSale; newItemMasterDB.TaxOnSale = newItem.TaxOnSale; newItemMasterDB.Scheme1 = newItem.Scheme1; newItemMasterDB.Scheme2 = newItem.Scheme2; newItemMasterDB.PurchaseExcise = newItem.PurchaseExcise; newItemMasterDB.UPC = newItem.UPC; newItemMasterDB.IsHalfScheme = newItem.IsHalfScheme; newItemMasterDB.IsQTRScheme = newItem.IsQTRScheme; newItemMasterDB.SpecialDiscount = newItem.SpecialDiscount; newItemMasterDB.SpecialDiscountOnQty = newItem.SpecialDiscountOnQty; newItemMasterDB.IsFixedDiscount = newItem.IsFixedDiscount; newItemMasterDB.FixedDiscountRate = newItem.FixedDiscountRate; newItemMasterDB.SurchargeOnPurchase = newItem.SurchargeOnPurchase; newItemMasterDB.TaxOnPurchase = newItem.TaxOnPurchase; newItemMasterDB.DiscountRecieved = newItem.DiscountRecieved; newItemMasterDB.SpecialDiscountRecieved = newItem.SpecialDiscountRecieved; newItemMasterDB.QtyPerCase = newItem.QtyPerCase; newItemMasterDB.Location = newItem.Location; newItemMasterDB.SaleTypeId = newItem.SaleTypeId; newItemMasterDB.PurchaseTypeId = newItem.PurchaseTypeId; newItemMasterDB.HSNCode = newItem.HSNCode; newItemMasterDB.Status = newItem.Status; newItemMasterDB.CreatedBy = this.LoggedInUser.Username; newItemMasterDB.CreatedOn = System.DateTime.Now; context.ItemMaster.Add(newItemMasterDB); _result = context.SaveChanges(); transaction.Commit(); if (_result > 0) { return(true); } else { return(false); } } catch (DbEntityValidationException ex) { transaction.Rollback(); throw ex; } catch (Exception ex) { transaction.Rollback(); throw ex; } } } } catch (Exception ex) { throw ex; } }
public bool UpdateItem(PharmaBusinessObjects.Master.ItemMaster existingItem) { using (PharmaDBEntities context = new PharmaDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { try { int _result = 0; Entity.ItemMaster existingItemDB = context.ItemMaster.Where(p => p.ItemCode == existingItem.ItemCode && p.Status).FirstOrDefault(); //Add HSN if does not exist if (!context.HSNCode.Where(x => x.HSNCode1 == existingItem.HSNCode).Any()) { Entity.HSNCode HSNCodeDBEntry = new HSNCode() { HSNCode1 = existingItem.HSNCode, HSNDescription = existingItem.HSNCode + "- Default Description", CreatedBy = this.LoggedInUser.Username, CreatedOn = System.DateTime.Now }; context.HSNCode.Add(HSNCodeDBEntry); } if (existingItemDB != null) { existingItemDB.ItemName = existingItem.ItemName; existingItemDB.CompanyID = existingItem.CompanyID; existingItemDB.ConversionRate = existingItem.ConversionRate; existingItemDB.ShortName = existingItem.ShortName; existingItemDB.Packing = existingItem.Packing; existingItemDB.PurchaseRate = existingItem.PurchaseRate; existingItemDB.MRP = existingItem.MRP; existingItemDB.SaleRate = existingItem.SaleRate; existingItemDB.SpecialRate = existingItem.SpecialRate; existingItemDB.WholeSaleRate = existingItem.WholeSaleRate; existingItemDB.SaleExcise = existingItem.SaleExcise; existingItemDB.SurchargeOnSale = existingItem.SurchargeOnSale; existingItemDB.TaxOnSale = existingItem.TaxOnSale; existingItemDB.Scheme1 = existingItem.Scheme1; existingItemDB.Scheme2 = existingItem.Scheme2; existingItemDB.PurchaseExcise = existingItem.PurchaseExcise; existingItemDB.UPC = existingItem.UPC; existingItemDB.IsHalfScheme = existingItem.IsHalfScheme; existingItemDB.IsQTRScheme = existingItem.IsQTRScheme; existingItemDB.SpecialDiscount = existingItem.SpecialDiscount; existingItemDB.SpecialDiscountOnQty = existingItem.SpecialDiscountOnQty; existingItemDB.IsFixedDiscount = existingItem.IsFixedDiscount; existingItemDB.FixedDiscountRate = existingItem.FixedDiscountRate; existingItemDB.SurchargeOnPurchase = existingItem.SurchargeOnPurchase; existingItemDB.TaxOnPurchase = existingItem.TaxOnPurchase; existingItemDB.DiscountRecieved = existingItem.DiscountRecieved; existingItemDB.SpecialDiscountRecieved = existingItem.SpecialDiscountRecieved; existingItemDB.QtyPerCase = existingItem.QtyPerCase; existingItemDB.Location = existingItem.Location; existingItemDB.SaleTypeId = existingItem.SaleTypeId; existingItemDB.PurchaseTypeId = existingItem.PurchaseTypeId; existingItemDB.HSNCode = existingItem.HSNCode; existingItemDB.Status = existingItem.Status; existingItemDB.ModifiedBy = this.LoggedInUser.Username; existingItemDB.ModifiedOn = System.DateTime.Now; } _result = context.SaveChanges(); transaction.Commit(); _result = 1; if (_result > 0) { return(true); } else { return(false); } } catch (Exception) { transaction.Rollback(); return(false); } } } }