public List<DistanceCharge> GetAllDistanceCharge() { List<DistanceCharge> list = new List<DistanceCharge>(); using (SqlCommand cmd = GetCommand("getAllDistanceCharge", CommandType.StoredProcedure)) { DistanceCharge distanceCharge = new DistanceCharge(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(distanceCharge.DistanceChargeIDatareader(dr)); } } } distanceCharge = null; } return list; }
public List<DistanceCharge> GetDistanceChargeByID(string id) { List<DistanceCharge> list = new List<DistanceCharge>(); using (SqlCommand cmd = GetCommand("getDistanceChargeByID", CommandType.StoredProcedure)) { AddParameter(cmd, "@ID", Convert.ToInt32(id)); DistanceCharge distanceCharge = new DistanceCharge(); using (SqlDataReader dr = ExeDataReader(cmd)) { if (dr.HasRows) { while (dr.Read()) { list.Add(distanceCharge.DistanceChargeIDatareader(dr)); } } } distanceCharge = null; } return list; }