protected void btnProceedToPayment_Click(object sender, EventArgs e)
{
try
{
if (cbxAgree.Checked == false)
{
lblMsg.Text = "please check the Terms & conditions.";
return;
}
int? createdBy = null;
if (Session["UserID"] != null) { createdBy = Convert.ToInt32(Session["UserID"].ToString()); }
else { createdBy = 0; }
if (Session["RedBusBookingDetails"] != null)
{
BookingDetails = (String[])Session["RedBusBookingDetails"];
// string gridviewdata = client.getBoardingPoint(BookingDetails[4].Split('~')[1]);
// DataTable dtOnwardBoardingInfo = convertJsonStringToDataSet(gridviewdata).Tables[0];
string boardinginf = BookingDetails[4].ToString();
string strOnwardBoardingInfo = string.Empty;
if (BookingDetails[19].ToString().Trim() == "TICKETGOOSE")
{
strOnwardBoardingInfo = Convert.ToString(BookingDetails[4].Split('~')[0]);
}
else
{
strOnwardBoardingInfo = Convert.ToString(BookingDetails[4]);
}
// string strOnwardBoardingInfo = dtOnwardBoardingInfo.Rows[0]["address"].ToString() + "," +
// dtOnwardBoardingInfo.Rows[0]["landmark"].ToString();
String referenceNumber = "";
String referenceNumberReturn = "";
referenceNumber = GenerateManabusRefNo();
string provider = BookingDetails[19].ToString();
if (BookingDetails[5].ToLower().Contains("single"))
{
Session["Ticketrefno"] = referenceNumber;
}
Session["Order_Id"] = referenceNumber;
Session["Amount"] = lblTotalAmountPayable.Text;
string phoneno;
//SingleTrip
if (BookingDetails[5].ToLower().Contains("single"))
{
#region onwardTrip
String nameList = ""; String genderList = ""; String titleList = ""; String ageList = "";
int countlist = 0;
foreach (RepeaterItem item in rptPassengersonward.Items)
{
DropDownList ddlrptr = (DropDownList)item.FindControl("ddlGender");
TextBox txtPassengerNamerptr = (TextBox)item.FindControl("txtPassengerName");
TextBox txtAgerptr = (TextBox)item.FindControl("txtAge");
phoneno = txtPhoneNo.Text;
if (countlist == 0)
{
++countlist;
nameList += txtPassengerNamerptr.Text;
titleList += ddlrptr.SelectedItem.Value.ToString();
ageList += txtAgerptr.Text;
genderList += ddlrptr.SelectedItem.Text.ToString();
}
else
{
++countlist;
nameList += "," + txtPassengerNamerptr.Text;
titleList += "," + ddlrptr.SelectedItem.Value.ToString();
ageList += "," + txtAgerptr.Text;
genderList += "," + ddlrptr.SelectedItem.Text.ToString();
}
}
String passengerDetailsonward = "";
string bookingid = "";
string boarding = lblBoardingPoint.ToolTip.ToString();
BlockSeats blockseats = new BlockSeats();
blockseats.SourceId = int.Parse(BookingDetails[10]);
blockseats.DestinationId = int.Parse(BookingDetails[11]);
blockseats.TripId = BookingDetails[12];
blockseats.JourneyDate = BookingDetails[1];
blockseats.BoardingId = BookingDetails[4].Split('~')[1];
blockseats.NoOfSeats = countlist;
blockseats.SeatNo = BookingDetails[2];
blockseats.Title = titleList;
blockseats.Name = nameList;
blockseats.Age = ageList;
blockseats.Sex = genderList;
blockseats.Address = txtAddress.Text;
blockseats.BookingRefNo = referenceNumber;
blockseats.IdCardType = ddlIDType.SelectedItem.Text;
blockseats.IdCardNo = txtIDNumber.Text;
blockseats.IdCardIssuedBy = txtIdIssuedBY.Text;
blockseats.MobileNo = txtPhoneNo.Text;
blockseats.EmergencyMobileNo = txtPhoneNo.Text;
blockseats.EmailId = txtEmailId.Text;
blockseats.ProviderName = BookingDetails[19].ToString();
blockseats.BookingId = bookingid;
string blockresult = client.blockTicket(blockseats);
DataSet ds = convertJsonStringToDataSet(blockresult);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Columns.Contains("Status"))
{
if (ds.Tables[0].Rows[0]["Status"].ToString().ToUpper() == "SUCCESS")
{
if (ds.Tables[0].Columns.Contains("BookingID"))
{
blockseats.BookingId = ds.Tables[0].Rows[0]["BookingID"].ToString();
lblMsg.Text = Convert.ToString(ds.Tables[0].Rows[0]["Status"]);
}
}
else
{
lblMsg.Text = ds.Tables[0].Rows[0]["message"].ToString();
return;
}
}
}
}
if (Session["UserID"] != null)
{
if (Session["Role"].ToString() == "Agent")
{
ClsBAL objBAL = new ClsBAL();
DataSet dsBalance = objBAL.GetAgentByUserId(Convert.ToInt32(Session["UserID"]));
DataSet dsCommSlab = objBAL.GetCommissionSlab(Session["Role"].ToString(), "Bus", provider); // Change it
if (dsCommSlab != null)
{
if (dsCommSlab.Tables[0].Rows.Count > 0)
{
string commisionPercentage = dsCommSlab.Tables[0].Rows[0]["Commission"].ToString();// Change it
string balance = dsBalance.Tables[0].Rows[0]["Balance"].ToString();
//string commisionPercentage = dsBalance.Tables[0].Rows[0]["CommisionPercentage"].ToString();
string agentId = dsBalance.Tables[0].Rows[0]["AgentId"].ToString();
string actualFare;
string deductAmount;
string commisionFare;
if (ViewState["MarkUp"] != null)
{
double Am = Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) - Convert.ToDouble(ViewState["MarkUp"].ToString());
actualFare = Am.ToString();
deductAmount = Convert.ToString(Convert.ToDouble(actualFare.ToString()) - ((Convert.ToDouble(actualFare.ToString()) * Convert.ToDouble(commisionPercentage)) / 100));
commisionFare = Convert.ToString(Convert.ToDouble(actualFare.ToString()) - Convert.ToDouble(deductAmount));
}
else
{
actualFare = lblTotalAmountPayable.Text.ToString();
deductAmount = Convert.ToString(Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) - ((Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) * Convert.ToDouble(commisionPercentage)) / 100));
commisionFare = Convert.ToString(Convert.ToDouble(lblTotalAmountPayable.Text.ToString()) - Convert.ToDouble(deductAmount));
}
Session["AgentId_Agent"] = agentId;
Session["ActualFare_Agent"] = actualFare;
Session["CommisionFare_Agent"] = commisionFare;
Session["CommisionPercentage_Agent"] = commisionPercentage;
Session["DeductAmount_Agent"] = deductAmount;
Session["Markup"] = ViewState["MarkUp"];
if (Convert.ToDouble(balance) >= Convert.ToDouble(deductAmount))
{
bool b = objBAL.UpdateAgentBalance(Convert.ToInt32(agentId), Convert.ToDouble(deductAmount), Convert.ToDouble(commisionFare));
//UpdateagentBalance,@RefundAmount
}
else
{
lblMsg.Text = "You dont have enough balance to book a ticket.";
return;
}
}
else
{
lblMsg.Text = "Please Contact administrater ";
return;
}
}
}
}
Session["blockseats"] = blockseats;
if (lblMsg.Text.ToString().ToUpper() == "SUCCESS" && lblMsg.Text.ToString().ToLower() != "tentative booking failed")
{
string[] strDate = BookingDetails[1].Trim().ToString().Split('-');
dt = Convert.ToDateTime(strDate[2] + "-" + strDate[1] + "-" + strDate[0]);
int countpassengers = 0;
foreach (RepeaterItem item in rptPassengersonward.Items)
{
DropDownList ddlrptr = (DropDownList)item.FindControl("ddlGender");
Label lblSeatNorptr = (Label)item.FindControl("lblSeatNo");
TextBox txtPassengerNamerptr = (TextBox)item.FindControl("txtPassengerName");
TextBox txtAgerptr = (TextBox)item.FindControl("txtAge");
if (countpassengers == 0)
{
++countpassengers;
passengerDetailsonward += lblSeatNorptr.Text + "-" + ddlrptr.SelectedItem.Value + "-" + txtPassengerNamerptr.Text + "-" + txtAgerptr.Text;
}
else
{
++countpassengers;
passengerDetailsonward += "," + lblSeatNorptr.Text + "-" + ddlrptr.SelectedItem.Value + "-" + txtPassengerNamerptr.Text + "-" + txtAgerptr.Text;
}
}
}
string[] str = new string[1];
str[0] = " to";
//BookingDetails[4].Split('-')[7].Split('~')[1]
String[] cities = BookingDetails[0].ToString().Split(str, StringSplitOptions.None);
res = InsertTentativeBooking(referenceNumber, Convert.ToString(Session["Ticketrefno"]), blockseats.BookingId, lblMsg.Text.ToString(), "", "", null, provider
, BookingDetails[15].ToString(), BookingDetails[14].ToString(), dt
, Convert.ToInt32(BookingDetails[10].ToString()), cities[0].ToString()
, Convert.ToInt32(BookingDetails[11].ToString()), cities[1].ToString()
, lblSeatNos.Text.ToString(), rptPassengersonward.Items.Count,Convert.ToDecimal(ViewState["MarkUp"].ToString()), Convert.ToDecimal(lblFare.Text.Trim().ToString()), null
, strOnwardBoardingInfo, BookingDetails[4].Split('-')[0].ToString() + "-" + BookingDetails[4].Split('-')[BookingDetails[4].Split('-').Length - 1].ToString().Split('~')[0].ToString(), nameList, 20, "M", txtPhoneNo.Text.ToString()
, txtEmailId.Text.ToString(), txtAddress.Text.ToString()
, "", null, 0, 0, "Online", "Cash", "Oneway", createdBy, "Online", "", passengerDetailsonward
, ddlIDType.SelectedItem.Text.ToString(), txtIDNumber.Text.ToString(), "", provider, Convert.ToDouble(Session["CommisionFare_Agent"]), blockseats.TripId, blockseats.Title, Convert.ToString(blockseats.BoardingId));
if (res == true)
{
if (Session["UserID"] != null)
{
if (Session["Role"].ToString() == "Admin" || Session["Role"].ToString() == "CSE")
{
lblMsg.Text = client.bookTicket(blockseats);
DataSet dsbook = convertJsonStringToDataSet(lblMsg.Text);
if (dsbook != null)
{
if (dsbook.Tables[0].Rows.Count > 0)
{
if (dsbook.Tables[0].Columns.Contains("APIPNR"))
{
lblMsg.Text = dsbook.Tables[0].Rows[0]["APIPNR"].ToString();
}
}
}
if (Convert.ToString(dsbook.Tables[0].Rows[0]["APIPNR"]) == "SUCCESS" || Convert.ToString(dsbook.Tables[0].Rows[0]["Status"]).ToUpper() == "SUCCESS")
{
if (lblMsg.Text.ToString().Split(' ').Length == 1)
{
InsertBookedTicketDetails(referenceNumber, lblMsg.Text.ToString());
Response.Redirect("redirectbus.aspx", false);
}
}
else
{
return; //Booking Failed.
}
}
else if (Session["Role"].ToString() == "Agent")
{
lblMsg.Text = client.bookTicket(blockseats);
DataSet dsbook = convertJsonStringToDataSet(lblMsg.Text);
if (dsbook != null)
{
if (dsbook.Tables[0].Rows.Count > 0)
{
if (dsbook.Tables[0].Columns.Contains("APIPNR"))
{
lblMsg.Text = dsbook.Tables[0].Rows[0]["APIPNR"].ToString();
}
}
}
if (Convert.ToString(dsbook.Tables[0].Rows[0]["APIPNR"]) == "SUCCESS" || Convert.ToString(dsbook.Tables[0].Rows[0]["Status"]).ToUpper() == "SUCCESS")
{
if (lblMsg.Text.ToString().Split(' ').Length == 1)
{
InsertBookedTicketDetails(referenceNumber, lblMsg.Text.ToString());
Response.Redirect("redirectbus.aspx", false);
}
}
else
{
return; //Booking Failed.
}
}
else if (Convert.ToDouble(lblTotalAmountPayable.Text) == Convert.ToDouble(0))
{
lblMsg.Text = client.bookTicket(blockseats);
DataSet dsbook = convertJsonStringToDataSet(lblMsg.Text);
if (dsbook != null)
{
if (dsbook.Tables[0].Rows.Count > 0)
{
if (dsbook.Tables[0].Columns.Contains("APIPNR"))
{
lblMsg.Text = dsbook.Tables[0].Rows[0]["APIPNR"].ToString();
}
}
}
if (Convert.ToString(dsbook.Tables[0].Rows[0]["APIPNR"]) == "SUCCESS" || Convert.ToString(dsbook.Tables[0].Rows[0]["Status"]).ToUpper() == "SUCCESS")
{
if (lblMsg.Text.ToString().Split(' ').Length == 1)
{
InsertBookedTicketDetails(referenceNumber, lblMsg.Text.ToString());
Response.Redirect("redirectbus.aspx", false);
}
}
else
{
return; //Booking Failed.
}
}
else if (Session["Role"].ToString() == "User")
{
Server.Transfer("Pay.aspx?val=bus");
}
}
else
{
// Response.Redirect("redirectbus.aspx?Refno=" + Session["Ticketrefno"].ToString(), false);
Response.Redirect("Pay.aspx?val=bus", false);
}
}
#endregion
}
}
else
{
Response.Redirect("~/Default.aspx", false);
}
}
catch (Exception ex)
{
lblMsg.Text = ex.ToString();
}
}
