public DataTable GetCarRentalScheduleDetails(int sid)
{
DBParams[] dbParams = new DBParams[1];
dbParams[0] = new DBParams("@CarRentalSessionID", sid, ParamType.Int, ParamDirection.Input);
return(DALHandler.GetDataTable(Constants.GetCarRentalScheduleDetails, dbParams));
}
public DataTable GetLoginInfo(string username, string pwd)
{
DBParams[] dbParams = new DBParams[2];
dbParams[0] = new DBParams("@user_name", username, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@pwd", pwd, ParamType.String, ParamDirection.Input);
return(DALHandler.GetDataTable("USP_GET_Logininfo", dbParams));
}
public DataTable GetFranchiseeList(string city)
{
DBParams[] dbParams = new DBParams[1];
dbParams[0] = new DBParams("@forcity", city, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.GetFranchiseeList, dbParams);
return(dt);
}
public DataTable PaymentUpdateBMETWallet(string tranid)
{
DBParams[] dbParams = new DBParams[1];
dbParams[0] = new DBParams("@CustomerID", tranid, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.PaymentUpdateBMETWallet, dbParams);
return(dt);
}
//***********CarRentalDataAccessLib*********************************
public DataTable GetCarRentalSchedule(string travel_type, string Source_city, string Destination_city, string travel_mode)
{
DBParams[] dbParams = new DBParams[4];
dbParams[0] = new DBParams("@travel_type", travel_type, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@Source_city", Source_city, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@Destination_city", Destination_city, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@travel_mode", travel_mode, ParamType.String, ParamDirection.Input);
return(DALHandler.GetDataTable(Constants.GetCarRentalSchedule, dbParams));
}
public DataTable GetSoldTicketsList(string calledFrom)
{
DBParams[] dbParams = new DBParams[1];
dbParams[0] = new DBParams("@calledFrom", calledFrom, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.GetSoldTicketsList, dbParams);
return(dt);
}
public DataTable GetFranchiseeDetails(string FranCode, int sessionid, string mode)
{
DBParams[] dbParams = new DBParams[3];
dbParams[0] = new DBParams("@FranCode", FranCode, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@sessionid", sessionid, ParamType.Int, ParamDirection.Input);
dbParams[2] = new DBParams("@mode", mode, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.GetFranchiseedetails, dbParams);
return(dt);
}
public DataTable BlockSeat(int sessionid, string mode, int seatno, string action)
{
DBParams[] dbParams = new DBParams[4];
dbParams[0] = new DBParams("@session_id", sessionid, ParamType.Int, ParamDirection.Input);
dbParams[1] = new DBParams("@mode", mode, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@seatno", seatno, ParamType.Int, ParamDirection.Input);
dbParams[3] = new DBParams("@action", action, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.BlockTicket, dbParams);
return(dt);
}
public DataTable CancelTicket(TicketCancel obj)
{
DBParams[] dbParams = new DBParams[6];
dbParams[0] = new DBParams("@TicketNo", obj.Ticketno, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@AccountHolderName", obj.AccountHolderName, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@BankAccountNo", obj.BankAccountNo, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@BankName", obj.BankName, ParamType.String, ParamDirection.Input);
dbParams[4] = new DBParams("@Email_id", obj.Email_id, ParamType.String, ParamDirection.Input);
dbParams[5] = new DBParams("@Mobile_no", obj.Mobile_no, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.CancelTicket, dbParams);
return(dt);
}
public DataTable AddApprochingUserdetails(string name, string phone, string Email, string Address, string city, string state, string entitytype)
{
DBParams[] dbParams = new DBParams[7];
dbParams[0] = new DBParams("@CustName", name, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@Mobile_no", phone, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@EmailID", Email, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@Address", Address, ParamType.String, ParamDirection.Input);
dbParams[4] = new DBParams("@City", city, ParamType.String, ParamDirection.Input);
dbParams[5] = new DBParams("@State", state, ParamType.String, ParamDirection.Input);
dbParams[6] = new DBParams("@EntityType", entitytype, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.AddApprochingUserdetails, dbParams);
return(dt);
}
public DataTable UpdateUserCashDetails(TPSLResponse obj)
{
DBParams[] dbParams = new DBParams[27];
dbParams[0] = new DBParams("@MERCHANTID", obj.MERCHANTID, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@CustomerID", obj.CustomerID, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@TxnreferenceNo", obj.TxnreferenceNo, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@BankReferenceNo", obj.BankReferenceNo, ParamType.String, ParamDirection.Input);
dbParams[4] = new DBParams("@TxnAmount", obj.TxnAmount, ParamType.String, ParamDirection.Input);
dbParams[5] = new DBParams("@BankID", obj.BankID, ParamType.String, ParamDirection.Input);
dbParams[6] = new DBParams("@BankMERCHANTID", obj.BankMERCHANTID, ParamType.String, ParamDirection.Input);
dbParams[7] = new DBParams("@TxnType", obj.TxnType, ParamType.String, ParamDirection.Input);
dbParams[8] = new DBParams("@CurrencyName", obj.CurrencyName, ParamType.String, ParamDirection.Input);
dbParams[9] = new DBParams("@ItemCode", obj.ItemCode, ParamType.String, ParamDirection.Input);
dbParams[10] = new DBParams("@SecurityType", obj.SecurityType, ParamType.String, ParamDirection.Input);
dbParams[11] = new DBParams("@SecurityID", obj.SecurityID, ParamType.String, ParamDirection.Input);
dbParams[12] = new DBParams("@SecurityPassword", obj.SecurityPassword, ParamType.String, ParamDirection.Input);
dbParams[13] = new DBParams("@TxnDate", obj.TxnDate, ParamType.String, ParamDirection.Input);
dbParams[14] = new DBParams("@AuthStatus", obj.AuthStatus, ParamType.String, ParamDirection.Input);
dbParams[15] = new DBParams("@SettlementType", obj.SettlementType, ParamType.String, ParamDirection.Input);
dbParams[16] = new DBParams("@AdditionalInfo1", obj.AdditionalInfo1, ParamType.String, ParamDirection.Input);
dbParams[17] = new DBParams("@AdditionalInfo2", obj.AdditionalInfo2, ParamType.String, ParamDirection.Input);
dbParams[18] = new DBParams("@AdditionalInfo3", obj.AdditionalInfo3, ParamType.String, ParamDirection.Input);
dbParams[19] = new DBParams("@AdditionalInfo4", obj.AdditionalInfo4, ParamType.String, ParamDirection.Input);
dbParams[20] = new DBParams("@AdditionalInfo5", obj.AdditionalInfo5, ParamType.String, ParamDirection.Input);
dbParams[21] = new DBParams("@AdditionalInfo6", obj.AdditionalInfo6, ParamType.String, ParamDirection.Input);
dbParams[22] = new DBParams("@AdditionalInfo7", obj.AdditionalInfo7, ParamType.String, ParamDirection.Input);
dbParams[23] = new DBParams("@ErrorStatus", obj.ErrorStatus, ParamType.String, ParamDirection.Input);
dbParams[24] = new DBParams("@ErrorDescription", obj.ErrorDescription, ParamType.String, ParamDirection.Input);
dbParams[25] = new DBParams("@CheckSum", obj.CheckSum, ParamType.String, ParamDirection.Input);
dbParams[26] = new DBParams("@Status", obj.Status, ParamType.String, ParamDirection.Input);
DataTable dt = DALHandler.GetDataTable(Constants.UpdateUserCashDetails, dbParams);
return(dt);
}