//Event Booking Section
public string AddEventBookingDetails(string name, string gender, int age, string email, string mob, string address, int stagboy, int staggirl, int couple, int child, decimal bookingAmt, out string booking_id)
{
try
{
booking_id = "";
DBParams[] dbParams = new DBParams[12];
dbParams[0] = new DBParams("@Customer_name", name, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@Gender", gender, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@Age", age, ParamType.Int, ParamDirection.Input);
dbParams[3] = new DBParams("@Email_id", email, ParamType.String, ParamDirection.Input);
dbParams[4] = new DBParams("@Mobile_no", mob, ParamType.String, ParamDirection.Input);
dbParams[5] = new DBParams("@Address", address, ParamType.String, ParamDirection.Input);
dbParams[6] = new DBParams("@StagBoy", stagboy, ParamType.Int, ParamDirection.Input);
dbParams[7] = new DBParams("@StagGirl", staggirl, ParamType.Int, ParamDirection.Input);
dbParams[8] = new DBParams("@Couple", couple, ParamType.Int, ParamDirection.Input);
dbParams[9] = new DBParams("@Booking_ID", booking_id, ParamType.String, ParamDirection.Output, 20);
dbParams[10] = new DBParams("@Child", child, ParamType.Int, ParamDirection.Input);
dbParams[11] = new DBParams("@bookingBMET_amt", bookingAmt, ParamType.Float, ParamDirection.Input);
booking_id = DALHandler.ExecuteStatementCashEntry(Constants.AddUserEventBookingdetails, dbParams);
return(booking_id);
}
catch (Exception)
{
throw;
}
}
public string AddCarRentalDeatails(CarRentalEntity obj)
{
DBParams[] dbParams = new DBParams[14];
dbParams[0] = new DBParams("@pickup_time", obj.Pickup_Time, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@Rental_SchdID", obj.ScheduleID, ParamType.Int, ParamDirection.Input);
dbParams[2] = new DBParams("@Customer_name", obj.CustName, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@Gender", obj.Gender, ParamType.String, ParamDirection.Input);
dbParams[4] = new DBParams("@Age", obj.Age, ParamType.Int, ParamDirection.Input);
dbParams[5] = new DBParams("@Email_id", obj.EmailID, ParamType.String, ParamDirection.Input);
dbParams[6] = new DBParams("@Mobile_no", obj.Mobile_no, ParamType.String, ParamDirection.Input);
dbParams[7] = new DBParams("@pickup_Address", obj.Pickup_Address, ParamType.String, ParamDirection.Input);
dbParams[8] = new DBParams("@pickup_date", obj.Pickup_Date, ParamType.DateTime, ParamDirection.Input);
dbParams[9] = new DBParams("@Booking_ID", obj.BookingID, ParamType.String, ParamDirection.Output, 20);
dbParams[10] = new DBParams("@bookingBMET_amt", obj.bookingBMET_amt, ParamType.Float, ParamDirection.Input);
dbParams[11] = new DBParams("@bookingFRAN_amt", obj.bookingFRAN_amt, ParamType.Float, ParamDirection.Input);
dbParams[12] = new DBParams("@Fran_code", obj.Fran_code, ParamType.String, ParamDirection.Input);
dbParams[13] = new DBParams("@Fran_Markup", obj.Fran_Markup, ParamType.Int, ParamDirection.Input);
String tranid = DALHandler.ExecuteStatementCashEntry(Constants.AddUserCarRentaldetails, dbParams);
return(tranid);
}
public string AddCashDeatails(CashDetails obj)
{
DBParams[] dbParams = new DBParams[15];
dbParams[0] = new DBParams("@CustName", obj.CustName, ParamType.String, ParamDirection.Input);
dbParams[1] = new DBParams("@EmailID", obj.EmailID, ParamType.String, ParamDirection.Input);
dbParams[2] = new DBParams("@Mobile_no", obj.Mobile_no, ParamType.String, ParamDirection.Input);
dbParams[3] = new DBParams("@Address", obj.Address, ParamType.String, ParamDirection.Input);
//dbParams[4] = new DBParams("@User_session_id", obj.User_session_id, ParamType.Int, ParamDirection.Input);
dbParams[4] = new DBParams("@session_id", obj.session_id, ParamType.Int, ParamDirection.Input);
dbParams[5] = new DBParams("@total_seat", obj.total_seats, ParamType.String, ParamDirection.Input);
dbParams[6] = new DBParams("@total_amount", obj.total_amount, ParamType.Int, ParamDirection.Input);
dbParams[7] = new DBParams("@ActiveID", obj.ActiveID, ParamType.Int, ParamDirection.Input);
dbParams[8] = new DBParams("@mode", obj.Mode, ParamType.String, ParamDirection.Input);
dbParams[9] = new DBParams("@tranid", obj.tranid, ParamType.String, ParamDirection.Output, 20);
dbParams[10] = new DBParams("@FranCode", obj.FranCode, ParamType.String, ParamDirection.Input);
dbParams[11] = new DBParams("@cust_Amt", obj.cust_amount, ParamType.Int, ParamDirection.Input);
dbParams[12] = new DBParams("@boardingPoint", obj.BoardingPoint, ParamType.String, ParamDirection.Input);
dbParams[13] = new DBParams("@gender", obj.Gender, ParamType.String, ParamDirection.Input);
dbParams[14] = new DBParams("@age", obj.Age, ParamType.String, ParamDirection.Input);
string tranid = DALHandler.ExecuteStatementCashEntry(Constants.AddCashDetails, dbParams).ToString();
return(tranid);
}
