public bool DeleteMItemDiscount(MItemDiscount mitemdiscount) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteMItemDiscount"; cmd.Parameters.AddWithValue("@PkSrNo", mitemdiscount.PkSrNo); cmd.Parameters.AddWithValue("@IsActive", mitemdiscount.IsActive); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { mitemdiscount.msg = ObjTrans.ErrorMessage; return(false); } }
public bool AddMItemDiscount(MItemDiscount mitemdiscount) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMItemDiscount"; cmd.Parameters.AddWithValue("@PkSrNo", mitemdiscount.PkSrNo); cmd.Parameters.AddWithValue("@DiscUserNo", mitemdiscount.DiscUserNo); cmd.Parameters.AddWithValue("@MfgCompanyNo", mitemdiscount.MfgCompanyNo); cmd.Parameters.AddWithValue("@DiscDate", mitemdiscount.DiscDate); cmd.Parameters.AddWithValue("@PeriodFrom", mitemdiscount.PeriodFrom); cmd.Parameters.AddWithValue("@PeriodTo", mitemdiscount.PeriodTo); cmd.Parameters.AddWithValue("@CompanyNo", mitemdiscount.CompanyNo); cmd.Parameters.AddWithValue("@IsActive", mitemdiscount.IsActive); cmd.Parameters.AddWithValue("@UserID", mitemdiscount.UserID); cmd.Parameters.AddWithValue("@UserDate", mitemdiscount.UserDate); SqlParameter outParameter = new SqlParameter(); outParameter.ParameterName = "@ReturnID"; outParameter.Direction = ParameterDirection.Output; outParameter.DbType = DbType.Int32; cmd.Parameters.Add(outParameter); commandcollection.Add(cmd); return(true); }
public MItemDiscount ModifyMItemDiscountByID(long ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from MItemDiscount 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) { MItemDiscount MM = new MItemDiscount(); while (dr.Read()) { MM.PkSrNo = Convert.ToInt32(dr["PkSrNo"]); if (!Convert.IsDBNull(dr["DiscUserNo"])) { MM.DiscUserNo = Convert.ToInt64(dr["DiscUserNo"]); } if (!Convert.IsDBNull(dr["MfgCompanyNo"])) { MM.MfgCompanyNo = Convert.ToInt64(dr["MfgCompanyNo"]); } if (!Convert.IsDBNull(dr["DiscDate"])) { MM.DiscDate = Convert.ToDateTime(dr["DiscDate"]); } if (!Convert.IsDBNull(dr["PeriodFrom"])) { MM.PeriodFrom = Convert.ToDateTime(dr["PeriodFrom"]); } if (!Convert.IsDBNull(dr["PeriodTo"])) { MM.PeriodTo = Convert.ToDateTime(dr["PeriodTo"]); } if (!Convert.IsDBNull(dr["CompanyNo"])) { MM.CompanyNo = Convert.ToInt64(dr["CompanyNo"]); } if (!Convert.IsDBNull(dr["IsActive"])) { MM.IsActive = Convert.ToInt32(dr["IsActive"]); } if (!Convert.IsDBNull(dr["UserID"])) { MM.UserID = Convert.ToInt64(dr["UserID"]); } if (!Convert.IsDBNull(dr["UserDate"])) { MM.UserDate = Convert.ToDateTime(dr["UserDate"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new MItemDiscount()); }