public DateTime GetDepartArrivlDateTime(DateTime departDateTime, int trainNumb, string startStation, string endStation) { if (startStation == endStation) { return(departDateTime); } DateTime result = new DateTime(); int startStatId = stationRepo.GetIdByName(startStation); int endStatId = stationRepo.GetIdByName(endStation); int trainId = trainRepo.GetIdByNumber(trainNumb); using (SqlConnection sqlConn = new SqlConnection(connStr)) { sqlConn.Open(); using (SqlCommand sqlComm = new SqlCommand("SELECT dbo.ArrivalDateTimeCalculation (@DepartureDateTime, @TrainId, @StartStationId, @EndStationId)", sqlConn)) { sqlComm.Parameters.AddWithValue("@DepartureDateTime", departDateTime.ToString("MM.dd.yyyy HH:mm:ss")); sqlComm.Parameters.AddWithValue("@TrainId", trainId); sqlComm.Parameters.AddWithValue("@StartStationId", startStatId); sqlComm.Parameters.AddWithValue("@EndStationId", endStatId); result = Convert.ToDateTime(sqlComm.ExecuteScalar()); } } return(result); }
public int GetIdByNumber(int trainNumb) { return(trainRepo.GetIdByNumber(trainNumb)); }