public TrainSchedule GetTrainSchedule(string stationName)
{
TrainSchedule scheduleObj = new TrainSchedule();
DBAccess objDBAccess = new DBAccess();
scheduleObj = objDBAccess.getTrainSchedule(stationName);
return(scheduleObj);
}
public TrainSchedule getTrainSchedule(string stationName)
{
TrainSchedule timeObj;
timeObj = new TrainSchedule();
string sqlNorthBound;
string sqlSouthBound;
if (stationName == "FivePoints")
{
sqlNorthBound = "sp_getFivePointsNorthBoundSchedule";
sqlSouthBound = "sp_getFivePointsSouthBoundSchedule";
}
else
{
sqlNorthBound = "sp_getSandySpringsNorthBoundSchedule";
sqlSouthBound = "sp_getSandySpringsSouthBoundSchedule";
}
DateTime currentTime = DateTime.Now;
//Execute query for northbound data
SqlCommand command = new SqlCommand(sqlNorthBound, connection);
command.CommandType = CommandType.StoredProcedure;
try
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
DateTime firstNorthBoundTrain = Convert.ToDateTime(Convert.ToString(reader["NorthBound"]));
do
{
DateTime northbound = Convert.ToDateTime(Convert.ToString(reader["NorthBound"]));
if (DateTime.Compare(northbound, currentTime) > 0)
{
timeObj.northBound = northbound.ToString("hh:mm:ss tt");
break;
}
} while (reader.Read());
if (timeObj.northBound == null)
{
timeObj.northBound = firstNorthBoundTrain.ToString("hh:mm:ss tt");
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
connection.Close();
//Execute query for southbound data
command = new SqlCommand(sqlSouthBound, connection);
command.CommandType = CommandType.StoredProcedure;
try
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
DateTime firstSouthBoundTrain = Convert.ToDateTime(Convert.ToString(reader["SouthBound"]));
do
{
DateTime southbound = Convert.ToDateTime(Convert.ToString(reader["SouthBound"]));
if (DateTime.Compare(southbound, currentTime) > 0)
{
timeObj.southBound = southbound.ToString("hh:mm:ss tt");
break;
}
} while (reader.Read());
if (timeObj.southBound == null)
{
timeObj.southBound = firstSouthBoundTrain.ToString("hh:mm:ss tt");
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
connection.Close();
return(timeObj);
}