public bool AddMItemDiscountDetails(MItemDiscountDetails mitemdiscountdetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMItemDiscountDetails"; cmd.Parameters.AddWithValue("@PkSrNo", mitemdiscountdetails.PkSrNo); // cmd.Parameters.AddWithValue("@ItemBrandDiscNo", mitemdiscountdetails.ItemBrandDiscNo); cmd.Parameters.AddWithValue("@ItemNo", mitemdiscountdetails.ItemNo); cmd.Parameters.AddWithValue("@FkRateSettingNo", mitemdiscountdetails.FkRateSettingNo); cmd.Parameters.AddWithValue("@DiscPercentage", mitemdiscountdetails.DiscPercentage); cmd.Parameters.AddWithValue("@MRP", mitemdiscountdetails.MRP); cmd.Parameters.AddWithValue("@IsActive", mitemdiscountdetails.IsActive); cmd.Parameters.AddWithValue("@CompanyNo", mitemdiscountdetails.CompanyNo); commandcollection.Add(cmd); return(true); }
public MItemDiscountDetails ModifyMItemDiscountDetailsByID(int ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from MItemDiscountDetails where CompanyNo=" + DBGetVal.FirmNo + " And PkSrNo =" + ID; cmd = new SqlCommand(sql, Con); cmd.Connection = Con; Con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.HasRows) { MItemDiscountDetails MM = new MItemDiscountDetails(); while (dr.Read()) { MM.PkSrNo = Convert.ToInt32(dr["PkSrNo"]); if (!Convert.IsDBNull(dr["ItemBrandDiscNo"])) { MM.ItemBrandDiscNo = Convert.ToInt64(dr["ItemBrandDiscNo"]); } if (!Convert.IsDBNull(dr["ItemNo"])) { MM.ItemNo = Convert.ToInt64(dr["ItemNo"]); } if (!Convert.IsDBNull(dr["FkRateSettingNo"])) { MM.FkRateSettingNo = Convert.ToInt64(dr["FkRateSettingNo"]); } if (!Convert.IsDBNull(dr["DiscPercentage"])) { MM.DiscPercentage = Convert.ToDouble(dr["DiscPercentage"]); } if (!Convert.IsDBNull(dr["MRP"])) { MM.MRP = Convert.ToDouble(dr["MRP"]); } if (!Convert.IsDBNull(dr["IsActive"])) { MM.IsActive = Convert.ToBoolean(dr["IsActive"]); } if (!Convert.IsDBNull(dr["CompanyNo"])) { MM.CompanyNo = Convert.ToInt64(dr["CompanyNo"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new MItemDiscountDetails()); }
public bool DeleteMItemDiscountDetails(MItemDiscountDetails mitemdiscountdetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteMItemDiscountDetails"; cmd.Parameters.AddWithValue("@PkSrNo", mitemdiscountdetails.PkSrNo); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { return(false); } }