public static CarriageType GetCarriageTypeByType(string type) { CarriageType result = null; Hashtable pars = new Hashtable(); pars.Add("@type", type); try { using (DBManager db = new DBManager()) { db.Open(); using (SqlDataReader reader = db.ExecuteQuery(GetCarriageTypeQueryByType, pars)) { result = GetCarriageTypeFromDataReader(reader); reader.Close(); } db.Close(); } } catch (Exception ex) { throw ex; } return(result); }
private static CarriageType GetCarriageTypeFromDataReader(SqlDataReader reader) { reader.Read(); CarriageType t = new CarriageType() { Id_CarriageType = reader.GetInt32(0), Type = reader.GetString(1), PlasesCount = reader.GetInt32(2) }; return(t); }
private static List <CarriageType> GetCarriageTypesListFromDataReader(SqlDataReader reader) { List <CarriageType> result = new List <CarriageType>(); while (reader.Read()) { CarriageType t = new CarriageType() { Id_CarriageType = reader.GetInt32(0), Type = reader.GetString(1), PlasesCount = reader.GetInt32(2) }; result.Add(t); } return(result); }