public static Boolean SOMS_RefreshedDeliverySchedule(IDeliverySchedule _schedule) { SqlCommand cmd = new SqlCommand("SOMS_RefreshedDeliverySchedule"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PartID", _schedule.PartID); SqlHelper.ExecuteNonQuery(ClsConfig.SqlConnectionString, cmd); return(true); }
public static Boolean RefreshedDeliveryScheduleByYear(IDeliverySchedule _schedule) { SqlCommand cmd = new SqlCommand("RefreshedDeliveryScheduleByYear"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PartID", _schedule.PartID); //cmd.Parameters.AddWithValue("@month", _schedule.DateMonth); cmd.Parameters.AddWithValue("@year", _schedule.DateYear); SqlHelper.ExecuteNonQuery(ClsConfig.SqlConnectionString, cmd); return(true); }