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 PharmaBusinessObjects.Master.ItemMaster GetItemByCodeAndCustomer(int itemCode, string customerCode) { PharmaBusinessObjects.Master.ItemMaster master = new PharmaBusinessObjects.Master.ItemMaster(); using (PharmaDBEntities context = new PharmaDBEntities()) { SqlConnection connection = (SqlConnection)context.Database.Connection; SqlCommand cmd = new SqlCommand("GetSaleLineItemByCode", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@ItemCode", itemCode)); cmd.Parameters.Add(new SqlParameter("@CustomerCode", customerCode)); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt != null && dt.Rows.Count > 0) { master.ItemID = Convert.IsDBNull(dt.Rows[0]["ItemId"]) ? 0 : Convert.ToInt32(dt.Rows[0]["ItemId"]); master.ItemCode = Convert.ToString(dt.Rows[0]["ItemCode"]); master.ItemName = Convert.ToString(dt.Rows[0]["ItemName"]); master.CompanyID = Convert.IsDBNull(dt.Rows[0]["CompanyID"]) ? 0 : Convert.ToInt32(dt.Rows[0]["CompanyID"]); master.SaleRate = Convert.IsDBNull(dt.Rows[0]["SaleRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SaleRate"]); master.SpecialRate = Convert.IsDBNull(dt.Rows[0]["SpecialRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SpecialRate"]); master.WholeSaleRate = Convert.IsDBNull(dt.Rows[0]["WholeSaleRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["WholeSaleRate"]); master.SaleExcise = Convert.IsDBNull(dt.Rows[0]["SaleExcise"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SaleExcise"]); master.SurchargeOnSale = Convert.IsDBNull(dt.Rows[0]["SurchargeOnSale"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SurchargeOnSale"]); master.TaxOnSale = Convert.IsDBNull(dt.Rows[0]["TaxOnSale"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["TaxOnSale"]); master.Scheme1 = Convert.IsDBNull(dt.Rows[0]["Scheme1"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["Scheme1"]); master.Scheme2 = Convert.IsDBNull(dt.Rows[0]["Scheme2"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["Scheme2"]); master.IsHalfScheme = Convert.IsDBNull(dt.Rows[0]["IsHalfScheme"]) ? false : Convert.ToBoolean(dt.Rows[0]["IsHalfScheme"]); master.IsQTRScheme = Convert.IsDBNull(dt.Rows[0]["IsQTRScheme"]) ? false : Convert.ToBoolean(dt.Rows[0]["IsQTRScheme"]); master.SpecialDiscount = Convert.IsDBNull(dt.Rows[0]["SpecialDiscount"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SpecialDiscount"]); master.SpecialDiscountOnQty = Convert.IsDBNull(dt.Rows[0]["SpecialDiscountOnQty"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["SpecialDiscountOnQty"]); master.IsFixedDiscount = Convert.IsDBNull(dt.Rows[0]["IsFixedDiscount"]) ? false : Convert.ToBoolean(dt.Rows[0]["IsFixedDiscount"]); master.FixedDiscountRate = Convert.IsDBNull(dt.Rows[0]["FixedDiscountRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["FixedDiscountRate"]); master.QtyPerCase = Convert.IsDBNull(dt.Rows[0]["QtyPerCase"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["QtyPerCase"]); master.Location = Convert.ToString(dt.Rows[0]["Location"]); master.SaleTypeId = Convert.IsDBNull(dt.Rows[0]["SaleTypeId"]) ? 0 : Convert.ToInt32(dt.Rows[0]["SaleTypeId"]); //master.Discount = Convert.IsDBNull(dt.Rows[0]["Discount"]) ? 0 : Convert.ToDouble(dt.Rows[0]["Discount"]); // master.Batch = Convert.ToString(dt.Rows[0]["Batch"]); master.Packing = Convert.ToString(dt.Rows[0]["Packing"]); master.PurchaseRate = Convert.IsDBNull(dt.Rows[0]["PurchaseRate"]) ? 0 : Convert.ToDecimal(dt.Rows[0]["PurchaseRate"]); // master.FifoID = Convert.IsDBNull(dt.Rows[0]["FifoID"]) ? 0 : Convert.ToInt32(dt.Rows[0]["FifoID"]); } } return(master); }
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); } } } }