public ItemMasterModel GetItemsByName(string itemname) { ItemMasterModel objItem = new ItemMasterModel(); string Query = string.Empty; Query = "SELECT * FROM ITEM_MASTER WHERE ITEM_Name='" + itemname + "'"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objItem = new eSunSpeedDomain.ItemMasterModel(); objItem.Name = dr["ITEM_Name"].ToString(); objItem.Alias = dr["ITEM_ALIAS"].ToString(); objItem.Unit = dr["ITEM_UNIT"].ToString(); objItem.OpStockQty = Convert.ToDouble(dr["ITEM_OPSTOCKQTY"]); objItem.OpStockValue = Convert.ToDouble(dr["ITEM_OPSTOCKVALUE"]); objItem.SalePrice = Convert.ToDouble(dr["ITEM_SALEPRICE"]); objItem.MRP = Convert.ToDouble(dr["ITEM_MRP"]); objItem.MinSalePrice = Convert.ToDouble(dr["ITEM_MINSALEPRICE"]); objItem.SelfValuePrice = Convert.ToDouble(dr["ITEM_SELFVALUEPRICE"]); objItem.SaleDiscount = Convert.ToDouble(dr["ITEM_SALEDISCOUNT"]); } return(objItem); }
//List public List <ItemMasterModel> GetAllItems() { List <ItemMasterModel> lstItems = new List <ItemMasterModel>(); ItemMasterModel objItem; string Query = string.Empty; Query = "SELECT * FROM ITEM_MASTER"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objItem = new eSunSpeedDomain.ItemMasterModel(); objItem.ItemId = Convert.ToInt32(dr["ITM_ID"]); objItem.Name = dr["ITEM_Name"].ToString(); objItem.Alias = dr["ITEM_ALIAS"].ToString(); objItem.Group = dr["ITEM_GROUP"].ToString(); objItem.PrintName = dr["ITEM_PRINTNAME"].ToString(); objItem.Unit = dr["ITEM_UNIT"].ToString(); objItem.OpStockQty = Convert.ToDouble(dr["ITEM_OPSTOCKQTY"]); objItem.OpStockValue = Convert.ToDouble(dr["ITEM_OPSTOCKVALUE"]); objItem.SalePrice = Convert.ToDouble(dr["ITEM_SALEPRICE"]); objItem.Purprice = Convert.ToDouble(dr["ITEM_PURCHASEPRICE"]); objItem.MRP = Convert.ToDouble(dr["ITEM_MRP"]); objItem.MinSalePrice = Convert.ToDouble(dr["ITEM_MINSALEPRICE"]); objItem.SelfValuePrice = Convert.ToDouble(dr["ITEM_SELFVALUEPRICE"]); objItem.SaleDiscount = Convert.ToDouble(dr["ITEM_SALEDISCOUNT"]); objItem.PurDiscount = Convert.ToDouble(dr["ITEM_PURCHASEDISCOUNT"]); objItem.SaleCompoundDiscount = Convert.ToDouble(dr["ITEM_SALECOMPDISCOUNT"]); objItem.PurCompoundDiscount = Convert.ToDouble(dr["ITEM_PURCHCOMPDISCOUNT"]); objItem.SpecifySaleDiscStructure = Convert.ToBoolean(dr["ITEM_SPECIFYSALEDISCSTRUCT"]); objItem.SpecifyPurDiscStructure = Convert.ToBoolean(dr["ITEM_SPECIFYPURDISCSTRUCT"]); objItem.SaleMarkup = dr["ITEM_SALEMARKUP"].ToString(); objItem.PurMarkup = dr["ITEM_PURMARKUP"].ToString(); objItem.SaleCompMarkup = dr["ITEM_SALECOMPMARKUP"].ToString(); objItem.PurCompMarkup = dr["ITEM_PURCOMPMARKUP"].ToString(); objItem.SpecifySaleMarkupStruct = Convert.ToBoolean(dr["ITEM_SPECIFYSALEMARKUPSTRUCT"]); objItem.SpecifyPurMarkupStruct = Convert.ToBoolean(dr["ITEM_SPECIFYPURMARKUPSTRUCT"]); objItem.TaxCategory = dr["ITEM_TAXCATEGORY"].ToString(); objItem.TaxType = dr["ITEM_TAXTYPE"].ToString(); objItem.ServiceTaxRate = Convert.ToDouble(dr["ITEM_SERVICETAXRATE"]); objItem.RateofTax_Local = Convert.ToDouble(dr["ITEM_LOCALTAX"]); objItem.RateofTax_Central = Convert.ToDouble(dr["ITEM_CENTRALTAX"]); objItem.TaxonMRP = Convert.ToBoolean(dr["ITEM_TAXONMRP"]); objItem.HSNCode = dr["ITEM_HSNCODE"].ToString(); objItem.ItemDescription1 = dr["ITEM_DESCRIPTION1"].ToString(); objItem.ItemDescription2 = dr["ITEM_DESCRIPTION2"].ToString(); objItem.ItemDescription3 = dr["ITEM_DESCRIPTION3"].ToString(); objItem.ItemDescription4 = dr["ITEM_DESCRIPTION4"].ToString(); objItem.ItemDescription5 = dr["ITEM_DESCRIPTION5"].ToString(); objItem.ItemDescription6 = dr["ITEM_DESCRIPTION6"].ToString(); objItem.SetCriticalLevel = Convert.ToBoolean(dr["ITEM_SETCRITICALLEVEL"]); objItem.MaintainRG23D = Convert.ToBoolean(dr["ITEM_MAINTAINRG23D"]); objItem.TariffHeading = dr["ITEM_TARIFHEADING"].ToString(); objItem.SerialNumberwiseDetails = Convert.ToBoolean(dr["ITEM_SERIALWISEDETAILS"]); objItem.MRPWiseDetails = Convert.ToBoolean(dr["ITEM_MRPWISEDETAILS"]); objItem.ParameterizedDetails = Convert.ToBoolean(dr["ITEM_PARAMETERIZEDDETAILS"]); objItem.BatchwiseDetails = Convert.ToBoolean(dr["ITEM_BATCHWISEDETAILS"]); objItem.ExpDateRequired = Convert.ToBoolean(dr["ITEM_EXPDATEREQUIRED"]); objItem.ExpiryDays = Convert.ToInt32(dr["ITEM_EXPIRYDAYS"]); objItem.SalesAccount = dr["ITEM_SALESACCOUNT"].ToString(); objItem.PurcAccount = dr["ITEM_PURCACCOUNT"].ToString(); objItem.SpecifyDefaultMC = Convert.ToBoolean(dr["ITEM_SPECIFYDEFAULTMC"]); objItem.FreezeMCforItem = Convert.ToBoolean(dr["ITEM_FREEZEMCFORITEM"]); objItem.TotalNumberofAuthors = Convert.ToInt32(dr["ITEM_TOTALNUMBEROFAUTHORS"]); objItem.DontMaintainStockBal = Convert.ToBoolean(dr["ITEM_MAINTAINSTOCKBAL"]); objItem.PickItemSizefromDescription = Convert.ToBoolean(dr["ITEM_PICKITEMSIZEFROMDESC"]); objItem.SpecifyDefaultVendor = Convert.ToBoolean(dr["ITEM_SPECIFYDEFAULTVENDOR"]); lstItems.Add(objItem); } return(lstItems); }
//Update public bool UpdateItemMaster(eSunSpeedDomain.ItemMasterModel objItem) { string Query = string.Empty; DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ITEM_Name", objItem.Name)); paramCollection.Add(new DBParameter("@ITEM_ALIAS", objItem.Alias)); paramCollection.Add(new DBParameter("@ITEM_GROUP", objItem.Group)); paramCollection.Add(new DBParameter("@ITEM_PRINTNAME", objItem.PrintName)); paramCollection.Add(new DBParameter("@ITEM_UNIT", objItem.Unit)); paramCollection.Add(new DBParameter("@ITEM_OPENINGSTOCKQTY", objItem.OpStockQty)); paramCollection.Add(new DBParameter("@ITEM_OPENINGSTOCKVALUE", objItem.OpStockValue)); paramCollection.Add(new DBParameter("@ITEM_SALEPRICE", objItem.SalePrice)); paramCollection.Add(new DBParameter("@ITEM_PURCHASEPRICE", objItem.Purprice)); paramCollection.Add(new DBParameter("@ITEM_MRP", objItem.MRP)); paramCollection.Add(new DBParameter("@ITEM_MINSALEPRICE", objItem.MinSalePrice)); paramCollection.Add(new DBParameter("@ITEM_SELFVALUEPRICE", objItem.SelfValuePrice)); paramCollection.Add(new DBParameter("@ITEM_SALEDISCOUNT", objItem.SaleDiscount)); paramCollection.Add(new DBParameter("@ITEM_PURCHASEDISCOUNT", objItem.PurDiscount)); paramCollection.Add(new DBParameter("@ITEM_SALECOMPOUNDDISCOUNT", objItem.SaleCompoundDiscount)); paramCollection.Add(new DBParameter("@ITEM_PURCHASECOMPOUNDDISCOUNT", objItem.PurCompoundDiscount)); paramCollection.Add(new DBParameter("@ITEM_SPECIFYSALEDISCSTRUCTURE", objItem.SpecifySaleDiscStructure, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_SPECIFYPURDISCSTRUCTURE", objItem.SpecifyPurDiscStructure, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_SALEMARKUP", objItem.SaleMarkup)); paramCollection.Add(new DBParameter("@ITEM_PURMARKUP", objItem.PurMarkup)); paramCollection.Add(new DBParameter("@ITEM_SALECOMPMARKUP", objItem.SaleCompMarkup)); paramCollection.Add(new DBParameter("@ITEM_PURCOMPMARKUP", objItem.PurCompMarkup)); paramCollection.Add(new DBParameter("@ITEM_SPECIFYSALEMARKUPPSTRUCTURE", objItem.SpecifySaleMarkupStruct, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_SPECIFYPURMPARKUPSTRUCTURE", objItem.SpecifyPurMarkupStruct, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_TAXCATEGORY", objItem.TaxCategory)); paramCollection.Add(new DBParameter("@ITEM_TAXTYPE", objItem.TaxType)); paramCollection.Add(new DBParameter("@ITEM_SERVICETAXRATE", objItem.ServiceTaxRate)); paramCollection.Add(new DBParameter("@ITEM_RATEOFTAX_LOCAL", objItem.RateofTax_Central)); paramCollection.Add(new DBParameter("@ITEM_RETEOFTAX_CENTRAL", objItem.RateofTax_Central)); paramCollection.Add(new DBParameter("@ITEM_TAXONMRP", objItem.TaxonMRP, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_HSNCODE", objItem.HSNCode)); paramCollection.Add(new DBParameter("@ITEM_DESCRIPTION1", objItem.ItemDescription1)); paramCollection.Add(new DBParameter("@ITEM_DESCRIPTION2", objItem.ItemDescription2)); paramCollection.Add(new DBParameter("@ITEM_DESCRIPTION3", objItem.ItemDescription3)); paramCollection.Add(new DBParameter("@ITEM_DESCRIPTION4", objItem.ItemDescription4)); paramCollection.Add(new DBParameter("@ITEM_DESCRIPTION5", objItem.ItemDescription5)); paramCollection.Add(new DBParameter("@ITEM_DESCRIPTION6", objItem.ItemDescription6)); paramCollection.Add(new DBParameter("@ITEM_SETCRITICALLEVEL", objItem.SetCriticalLevel, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_MAINTAINRG23D", objItem.MaintainRG23D, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_TARIFHEDING", objItem.TariffHeading)); paramCollection.Add(new DBParameter("@ITEM_SERIALNUMBERWISEDETAILS", objItem.SerialNumberwiseDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_MRPWISEDETAILS", objItem.MRPWiseDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_PARAMETERIZEDDETAILS", objItem.ParameterizedDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_BATCHWISEDETAILS", objItem.BatchwiseDetails, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_EXPDATEREQUIRED", objItem.ExpDateRequired, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_EXPIRYDAYS", objItem.ExpiryDays)); paramCollection.Add(new DBParameter("@ITEM_SALESACCOUNT", objItem.SalesAccount)); paramCollection.Add(new DBParameter("@ITEM_PURCACCOUNT", objItem.PurcAccount)); paramCollection.Add(new DBParameter("@ITEM_SPECIFYDEFULTMC", objItem.SpecifyDefaultMC, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_FREEZEMCFORITEM", objItem.FreezeMCforItem, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_TOTALNUMBEROFAUTHORS", objItem.TotalNumberofAuthors)); paramCollection.Add(new DBParameter("@ITEM_DONTMAINTAINSTOCKBAL", objItem.DontMaintainStockBal, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_PICKITEMSIZEFROMDESCRIPTION", objItem.PickItemSizefromDescription, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@ITEM_SPECIFYDEFAULTVENDOR", objItem.SpecifyDefaultVendor, System.Data.DbType.Boolean)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@ITEM_ID", objItem.ItemId)); Query = "UPDATE ITEM_MASTER SET [ITEM_NAME]=@ITEM_Name,[ITEM_ALIAS]=@ITEM_ALIAS,[ITEM_GROUP]=@ITEM_GROUP,[ITEM_PRINTNAME]=@ITEM_PRINTNAME," + "[ITEM_UNIT]=@ITEM_UNIT,[ITEM_OPENINGSTOCKQTY]=@ITEM_OPENINGSTOCKQTY,[ITEM_OPENINGSTOCKVALUE]=@ITEM_OPENINGSTOCKVALUE, " + "[ITEM_SALEPRICE]=@ITEM_SALEPRICE,[ITEM_PURCHASEPRICE]=@ITEM_PURCHASEPRICE,[ITEM_MRP]=@ITEM_MRP,[ITEM_MINSALEPRICE]=@ITEM_MINSALEPRICE," + "[ITEM_SELFVALUEPRICE]=@ITEM_SELFVALUEPRICE,[ITEM_SALEDISCOUNT]=@ITEM_SALEDISCOUNT,[ITEM_PURCHASEDISCOUNT]=@ITEM_PURCHASEDISCOUNT," + "[ITEM_SALECOMPOUNDDISCOUNT]=@ITEM_SALECOMPOUNDDISCOUNT,[ITEM_PURCHASECOMPOUNDDISCOUNT]=@ITEM_PURCHASECOMPOUNDDISCOUNT," + "[ITEM_SPECIFYSALEDISCSTRUCTURE]=@ITEM_SPECIFYSALEDISCSTRUCTURE,[ITEM_SPECIFYPURDISCSTRUCTURE]=@ITEM_SPECIFYPURDISCSTRUCTURE," + "[ITEM_SALEMARKUP]=@ITEM_SALEMARKUP,[ITEM_PURMARKUP]=@ITEM_PURMARKUP,[ITEM_SALECOMPMARKUP]=@ITEM_SALECOMPMARKUP," + "[ITEM_PURCOMPMARKUP]=@ITEM_PURCOMPMARKUP,[ITEM_SPECIFYSALEMARKUPPSTRUCTURE]=@ITEM_SPECIFYSALEMARKUPPSTRUCTURE," + "[ITEM_SPECIFYPURMPARKUPSTRUCTURE]=@ITEM_SPECIFYPURMPARKUPSTRUCTURE,[ITEM_TAXCATEGORY]=@ITEM_TAXCATEGORY,[ITEM_TAXTYPE]=@ITEM_TAXTYPE," + "[ITEM_SERVICETAXRATE]=@ITEM_SERVICETAXRATE,[ITEM_RATEOFTAX_LOCAL]=@ITEM_RATEOFTAX_LOCAL,[ITEM_RETEOFTAX_CENTRAL]=@ITEM_RETEOFTAX_CENTRAL," + "[ITEM_TAXONMRP]=@ITEM_TAXONMRP,[ITEM_HSNCODE]=@ITEM_HSNCODE,[ITEM_DESCRIPTION1]=@ITEM_DESCRIPTION1,[ITEM_DESCRIPTION2]=@ITEM_DESCRIPTION2," + "[ITEM_DESCRIPTION3]=@ITEM_DESCRIPTION3,[ITEM_DESCRIPTION4]=@ITEM_DESCRIPTION4,[ITEM_DESCRIPTION5]=@ITEM_DESCRIPTION5,[ITEM_DESCRIPTION6]=@ITEM_DESCRIPTION6," + "[ITEM_SETCRITICALLEVEL]=@ITEM_SETCRITICALLEVEL,[ITEM_MAINTAINRG23D]=@ITEM_MAINTAINRG23D,[ITEM_TARIFHEDING]=@ITEM_TARIFHEDING," + "[ITEM_SERIALNUMBERWISEDETAILS]=@ITEM_SERIALNUMBERWISEDETAILS,[ITEM_MRPWISEDETAILS]=@ITEM_MRPWISEDETAILS," + "[ITEM_PARAMETERIZEDDETAILS]=@ITEM_PARAMETERIZEDDETAILS,[ITEM_BATCHWISEDETAILS]=@ITEM_BATCHWISEDETAILS,[ITEM_EXPDATEREQUIRED]=@ITEM_EXPDATEREQUIRED," + "[ITEM_EXPIRYDAYS]=@ITEM_EXPIRYDAYS,[ITEM_SALESACCOUNT]=@ITEM_SALESACCOUNT,[ITEM_PURCACCOUNT]=@ITEM_PURCACCOUNT,[ITEM_SPECIFYDEFULTMC]=@ITEM_SPECIFYDEFULTMC," + "[ITEM_FREEZEMCFORITEM]=@ITEM_FREEZEMCFORITEM,[ITEM_TOTALNUMBEROFAUTHORS]=@ITEM_TOTALNUMBEROFAUTHORS,[ITEM_DONTMAINTAINSTOCKBAL]=@ITEM_DONTMAINTAINSTOCKBAL," + "[ITEM_PICKITEMSIZEFROMDESCRIPTION]=@ITEM_PICKITEMSIZEFROMDESCRIPTION,[ITEM_SPECIFYDEFAULTVENDOR]=@ITEM_SPECIFYDEFAULTVENDOR,[CREATEDBY]=@CreatedBy " + "WHERE [ITM_ID]=@ITEM_ID"; return(_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0); }