public DataSet GetBoardingPoints(int session_id)
{
DBParams[] dbParams = new DBParams[1];
dbParams[0] = new DBParams("@session_id", session_id, ParamType.Int, ParamDirection.Input);
return(DALHandler.GetDataSet("USP_Get_BoardingPoints", dbParams));
}
public DataSet GetScheduleDetails(int sid)
{
DBParams[] dbParams = new DBParams[1];
dbParams[0] = new DBParams("@session_id", sid, ParamType.Int, ParamDirection.Input);
return(DALHandler.GetDataSet("USP_GET_Schedule_details", dbParams));
}
public DataSet GetScheduleInfo(int sessionid, string mode)
{
DBParams[] dbParams = new DBParams[2];
dbParams[0] = new DBParams("@session_id", sessionid, ParamType.Int, ParamDirection.Input);
dbParams[1] = new DBParams("@mode", mode, ParamType.String, ParamDirection.Input);
return(DALHandler.GetDataSet("USP_GET_SESSION_INFO", dbParams));
}
public DataTable GetTicketInfo(string tranid, string mobno)
{
DBParams[] dbParams = new DBParams[2];
dbParams[0] = new DBParams("@tranid", tranid, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@mobileno", mobno, ParamType.String, ParamDirection.Input);
return(DALHandler.GetDataSet(Constants.GetTicketDetails.ToString(), dbParams).Tables[0]);
}
public DataSet GetSchedule(string from, string to, string mode, string dt)
{
DBParams[] dbParams = new DBParams[4];
dbParams[0] = new DBParams("@from_city", from, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@to_city", to, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@mode", mode, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@dt", dt, ParamType.DateTime, ParamDirection.Input);
return(DALHandler.GetDataSet("USP_Get_Schedule", dbParams));
}
public DataSet GetAvailableSeatsDetails(int sessionid, string action)
{
DBParams[] dbParams = new DBParams[2];
dbParams[0] = new DBParams("@session_id", sessionid, ParamType.Int, ParamDirection.Input);
dbParams[1] = new DBParams("@action", action, ParamType.String, ParamDirection.Input);
DataSet ds = DALHandler.GetDataSet(Constants.GetAvailableSeats, dbParams);
return(ds);
}
public DataSet GetTravellingInfo(string src, string des, int sid)
{
DBParams[] dbParams = new DBParams[3];
dbParams[0] = new DBParams("@src", src, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@des", des, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@sid", sid, ParamType.Int, ParamDirection.Input);
return(DALHandler.GetDataSet("USP_Get_travellingInfo", dbParams));
}