public List<WeightCharge> GetAllWeightCharge() { List<WeightCharge> list = new List<WeightCharge>(); using (SqlCommand cmd = GetCommand("getAllWeightCharge", CommandType.StoredProcedure)) { WeightCharge weightCharge = new WeightCharge(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(weightCharge.WeightChargeIDatareader(dr)); } } } weightCharge = null; } return list; }
public List<WeightCharge> GetWeightChargeByID(string id) { List<WeightCharge> list = new List<WeightCharge>(); using (SqlCommand cmd = GetCommand("getWeightChargeByID", CommandType.StoredProcedure)) { AddParameter(cmd, "@ID", Convert.ToInt32(id)); WeightCharge weightCharge = new WeightCharge(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(weightCharge.WeightChargeIDatareader(dr)); } } } weightCharge = null; } return list; }