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));
}
