public static IntermediateStation GetIntermediateStationByName(string name) { IntermediateStation result = null; Hashtable pars = new Hashtable(); pars.Add("@name", name); try { using (DBManager db = new DBManager()) { db.Open(); using (SqlDataReader reader = db.ExecuteQuery(GetIntermediateStationQueryByName, pars)) { result = GetIntermediateStationFromDataReader(reader); reader.Close(); } db.Close(); } } catch (Exception ex) { throw ex; } return(result); }
private static IntermediateStation GetIntermediateStationFromDataReader(SqlDataReader reader) { reader.Read(); IntermediateStation t = new IntermediateStation() { Id_IntermediateStation = reader.GetInt32(0), Id_id_Station = reader.GetInt32(1), Station = StationDAL.GetStationById(reader.GetInt32(1)).Name, Id_id_Trip = reader.GetInt32(2), DepartureDate = reader.GetDateTime(3).ToShortDateString(), ArrivalDate = reader.GetDateTime(5).ToShortDateString(), DepartureTime = reader.GetValue(4).ToString(), ArrivalTime = reader.GetValue(6).ToString() }; return(t); }
private static List <IntermediateStation> GetIntermediateStationsListFromDataReader(SqlDataReader reader) { List <IntermediateStation> result = new List <IntermediateStation>(); while (reader.Read()) { IntermediateStation t = new IntermediateStation() { Id_IntermediateStation = reader.GetInt32(0), Id_id_Station = reader.GetInt32(1), Station = StationDAL.GetStationById(reader.GetInt32(1)).Name, Id_id_Trip = reader.GetInt32(2), DepartureDate = reader.GetDateTime(3).ToShortDateString(), ArrivalDate = reader.GetDateTime(5).ToShortDateString(), DepartureTime = reader.GetValue(4).ToString(), ArrivalTime = reader.GetValue(6).ToString() }; result.Add(t); } return(result); }