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