public DataSet TentativeBooking(DataTable dtTicketInfo, string referenceNumber, out string api, out string status, out string statusReason)
{
try
{
DataSet ds = null;
string str = dtTicketInfo.Rows[0]["OtherInfo"].ToString();
string[] strArray = str.Split(';');
api = ""; status = ""; statusReason = "";
api = strArray[0].ToString();
#region KesneniTentativeBooking
if (api == "Kes")
{
int sourceStationId = 0; int destinationStationId = 0; string journeyDate = ""; long serviceId = 0;
int coachTypeId = 0; int noOfSeats = 0; string seatNumbersList = ""; string firstNameList = "";
string lastNameList = ""; string genderList = ""; string ageList = ""; string contactNumberList = "";
string boardingPointIdList = ""; string droppingPointId = ""; string ticketFare = ""; string emailId = "";
string address = ""; string photoIdType = ""; string photoIdNo = ""; string photoIdIssuingAuthority = "";
decimal totalBasicFare = 0; decimal serviceTaxPercentage = 0; string discountcode = ""; string travels = "";
string sourcename = ""; string destinationname = ""; string bustype = "";
string boardingPoint = ""; int age = 0;
sourceStationId = Convert.ToInt32(strArray[1].ToString());
destinationStationId = Convert.ToInt32(strArray[2].ToString());
journeyDate = strArray[3].ToString();
serviceId = Convert.ToInt64(strArray[4].ToString());
coachTypeId = Convert.ToInt32(strArray[5].ToString());
noOfSeats = Convert.ToInt32(strArray[7].ToString());
seatNumbersList = strArray[8].ToString();
boardingPointIdList = strArray[9].ToString();
ticketFare = Convert.ToString(strArray[6].ToString());
droppingPointId = strArray[11].ToString();
emailId = dtTicketInfo.Rows[0]["EmailId"].ToString();
address = dtTicketInfo.Rows[0]["Address"].ToString();
travels = dtTicketInfo.Rows[0]["Travels"].ToString();
bustype = dtTicketInfo.Rows[0]["BusType"].ToString();
//sourcename = ViewState["From"].ToString();
//destinationname = ViewState["To"].ToString();
boardingPoint = dtTicketInfo.Rows[0]["BoardingPoint"].ToString();
age = Convert.ToInt32(dtTicketInfo.Rows[0]["Age"].ToString());
string firstname = dtTicketInfo.Rows[0]["FullName"].ToString();
string contactno = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
photoIdType = "photoIdType";
photoIdNo = referenceNumber;
photoIdIssuingAuthority = "photoIdIssuingAuthority";
totalBasicFare = Convert.ToDecimal(strArray[10].ToString());
serviceTaxPercentage = Convert.ToDecimal(0);
discountcode = "0";
if (dtTicketInfo.Columns.Contains("FullNameList") &&
dtTicketInfo.Columns.Contains("PhoneNoList") &&
dtTicketInfo.Columns.Contains("AgeList") &&
dtTicketInfo.Columns.Contains("GenderList"))
{
if (dtTicketInfo.Rows[0]["FullNameList"].ToString() != "" &&
dtTicketInfo.Rows[0]["PhoneNoList"].ToString() != "" &&
dtTicketInfo.Rows[0]["AgeList"].ToString() != "" &&
dtTicketInfo.Rows[0]["GenderList"].ToString() != "")
{
firstNameList = dtTicketInfo.Rows[0]["FullNameList"].ToString();
lastNameList = dtTicketInfo.Rows[0]["FullNameList"].ToString();
genderList = dtTicketInfo.Rows[0]["GenderList"].ToString();
ageList = dtTicketInfo.Rows[0]["AgeList"].ToString();
contactNumberList = dtTicketInfo.Rows[0]["PhoneNoList"].ToString();
}
else
{
firstNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
genderList = dtTicketInfo.Rows[0]["Title"].ToString();
ageList = dtTicketInfo.Rows[0]["Age"].ToString();
contactNumberList = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
firstNameList = firstNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = lastNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
contactNumberList = contactNumberList + "," + dtTicketInfo.Rows[0]["PhoneNo"].ToString();
ageList = ageList + "," + dtTicketInfo.Rows[0]["Age"].ToString();
genderList = genderList + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
}
}
else
{
firstNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
genderList = dtTicketInfo.Rows[0]["Title"].ToString();
ageList = dtTicketInfo.Rows[0]["Age"].ToString();
contactNumberList = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
firstNameList = firstNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = lastNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
contactNumberList = contactNumberList + "," + dtTicketInfo.Rows[0]["PhoneNo"].ToString();
ageList = ageList + "," + dtTicketInfo.Rows[0]["Age"].ToString();
genderList = genderList + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
}
if (dtTicketInfo.Columns.Contains("IdType") &&
dtTicketInfo.Columns.Contains("IdNo") &&
dtTicketInfo.Columns.Contains("IdIssuedBy"))
{
if (dtTicketInfo.Rows[0]["IdType"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdNo"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdIssuedBy"].ToString() != "")
{
photoIdType = dtTicketInfo.Rows[0]["IdType"].ToString();
photoIdNo = dtTicketInfo.Rows[0]["IdNo"].ToString();
photoIdIssuingAuthority = dtTicketInfo.Rows[0]["IdIssuedBy"].ToString();
}
}
ds = objKesineniAPILayer.BookTicketsOnwardJourney(sourceStationId, destinationStationId, journeyDate,
serviceId, coachTypeId, noOfSeats, seatNumbersList, firstNameList, lastNameList, genderList,
ageList, contactNumberList, boardingPointIdList, droppingPointId, ticketFare, emailId, address,
photoIdType, photoIdNo, photoIdIssuingAuthority, totalBasicFare, serviceTaxPercentage, discountcode);
if (ds != null && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 1)
{
status = "Success";
statusReason = "";
}
if (ds.Tables[0].Columns.Count == 1)
{
status = "Fail";
statusReason = ds.Tables[0].Rows[0]["Message"].ToString();
}
}
#endregion
#region BitlaTentativeBooking
if (api == "Bit")
{
objBitlaAPILayer.ReservationId = strArray[1].ToString();
objBitlaAPILayer.OriginId = strArray[2].ToString();
objBitlaAPILayer.DestinationId = strArray[3].ToString();
objBitlaAPILayer.BoardingAt = strArray[5].ToString();
objBitlaAPILayer.NoOfSeats = strArray[4].ToString();
objBitlaAPILayer.RefNumber = referenceNumber;
int noOfSeats = Convert.ToInt32(strArray[4].ToString());
string selectedSeats = strArray[6].ToString();
string[] selectedSeatsArray = selectedSeats.Split(',');
book_ticket bookTicket = new book_ticket();
object[] obj = new object[2];
book_ticketSeat_detailsSeat_detail[] sD = new book_ticketSeat_detailsSeat_detail[noOfSeats];
if (dtTicketInfo.Columns.Contains("FullNameList") &&
dtTicketInfo.Columns.Contains("PhoneNoList") &&
dtTicketInfo.Columns.Contains("AgeList") &&
dtTicketInfo.Columns.Contains("GenderList") &&
dtTicketInfo.Columns.Contains("IdType") &&
dtTicketInfo.Columns.Contains("IdNo") &&
dtTicketInfo.Columns.Contains("IdIssuedBy"))
{
if (dtTicketInfo.Rows[0]["FullNameList"].ToString() != "" &&
dtTicketInfo.Rows[0]["PhoneNoList"].ToString() != "" &&
dtTicketInfo.Rows[0]["AgeList"].ToString() != "" &&
dtTicketInfo.Rows[0]["GenderList"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdType"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdNo"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdIssuedBy"].ToString() != "")
{
string[] fullNameListArray = dtTicketInfo.Rows[0]["FullNameList"].ToString().Split(',');
string[] phoneNoListArray = dtTicketInfo.Rows[0]["PhoneNoList"].ToString().Split(',');
string[] ageListArray = dtTicketInfo.Rows[0]["AgeList"].ToString().Split(',');
string[] genderListArray = dtTicketInfo.Rows[0]["GenderList"].ToString().Split(',');
string address = dtTicketInfo.Rows[0]["Address"].ToString();
string idType = dtTicketInfo.Rows[0]["IdType"].ToString();
string idNo = dtTicketInfo.Rows[0]["IdNo"].ToString();
string idIssuedBy = dtTicketInfo.Rows[0]["IdIssuedBy"].ToString();
for (int i = 0; i < noOfSeats; i++)
{
book_ticketSeat_detailsSeat_detail sdd = new book_ticketSeat_detailsSeat_detail();
sdd.seat_number = selectedSeatsArray[i].ToString();
sdd.title = genderListArray[i].ToString();
sdd.name = fullNameListArray[i].ToString();
sdd.age = ageListArray[i].ToString();
sdd.sex = genderListArray[i].ToString();
if (i == 0) { sdd.is_primary = "true"; }
else { sdd.is_primary = "false"; }
sdd.address = address;
string id = "";//1 -> Pan Card, 2 -> D/L, 3 -> Passport, 4 -> Voter, 5 -> Aadhar Card
if (idType.ToString().ToLower().Contains("pan"))
{
id = "1";
}
else if (idType.ToString().ToLower().Contains("dri"))
{
id = "2";
}
else if (idType.ToString().ToLower().Contains("pass"))
{
id = "3";
}
else if (idType.ToString().ToLower().Contains("voter"))
{
id = "4";
}
else if (idType.ToString().ToLower().Contains("adhar"))
{
id = "5";
}
else if (idType.ToString().ToLower().Contains("ration"))
{
id = "4";
}
sdd.id_card_type = id;
sdd.id_card_number = idNo;
sdd.id_card_issued_by = idIssuedBy;
sD[i] = sdd;
}
}
else
{
for (int i = 0; i < noOfSeats; i++)
{
book_ticketSeat_detailsSeat_detail sdd = new book_ticketSeat_detailsSeat_detail();
sdd.seat_number = selectedSeatsArray[i].ToString();
sdd.title = "Mr";
sdd.name = dtTicketInfo.Rows[0]["FullName"].ToString();
sdd.age = dtTicketInfo.Rows[0]["Age"].ToString();
sdd.sex = dtTicketInfo.Rows[0]["Title"].ToString();
if (i == 0) { sdd.is_primary = "true"; }
else { sdd.is_primary = "false"; }
sdd.address = "";
sdd.id_card_type = "";//1 -> Pan Card, 2 -> D/L, 3 -> Passport, 4 -> Voter, 5 -> Aadhar Card
sdd.id_card_number = "";
sdd.id_card_issued_by = "";
sD[i] = sdd;
}
}
}
else
{
for (int i = 0; i < noOfSeats; i++)
{
book_ticketSeat_detailsSeat_detail sdd = new book_ticketSeat_detailsSeat_detail();
sdd.seat_number = selectedSeatsArray[i].ToString();
sdd.title = "Mr";
sdd.name = dtTicketInfo.Rows[0]["FullName"].ToString();
sdd.age = dtTicketInfo.Rows[0]["Age"].ToString();
sdd.sex = dtTicketInfo.Rows[0]["Title"].ToString();
if (i == 0) { sdd.is_primary = "true"; }
else { sdd.is_primary = "false"; }
sdd.address = "";
sdd.id_card_type = "";//1 -> Pan Card, 2 -> D/L, 3 -> Passport, 4 -> Voter, 5 -> Aadhar Card
sdd.id_card_number = "";
sdd.id_card_issued_by = "";
sD[i] = sdd;
}
}
book_ticketSeat_details ss = new book_ticketSeat_details();
ss.seat_detail = sD;
book_ticketContact_detail cc = new book_ticketContact_detail();
cc.mobile_number = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
cc.email = dtTicketInfo.Rows[0]["EmailId"].ToString();
cc.emergency_name = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
obj[0] = ss;
obj[1] = cc;
bookTicket.Items = obj;
objBitlaAPILayer.TicketDetails = bookTicket;
ds = objBitlaAPILayer.ValidateBookTicket();
string strValidateBookTicket = "";
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count == 2)
{
strValidateBookTicket = ds.Tables[0].Rows[0]["message"].ToString();
}
}
if (strValidateBookTicket == "Success! You can book this ticket.")
{
status = "Success";
statusReason = "";
}
else
{
status = "Fail";
statusReason = ds.Tables[0].Rows[0]["message"].ToString();
}
}
#endregion
#region AbhiBusTentativeBooking
if (api == "Abh")
{
string jDate = ""; string sId = ""; string dId = ""; string serviceId = ""; string selectedSeats = "";
int noOfSeats = 0; string bId = ""; string genderType = ""; string psgrName = "";
jDate = strArray[1].ToString();
sId = strArray[2].ToString();
dId = strArray[3].ToString();
serviceId = strArray[4].ToString();
selectedSeats = strArray[5].ToString();
bId = strArray[6].ToString();
noOfSeats = Convert.ToInt32(strArray[7].ToString());
genderType = dtTicketInfo.Rows[0]["Title"].ToString();
psgrName = dtTicketInfo.Rows[0]["FullName"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
psgrName = psgrName + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
genderType = genderType + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
DataTable dt1 = objAbhiBusAPILayer.SeatBlocking(jDate, sId, dId, serviceId, selectedSeats);
ds = new DataSet();
ds.Tables.Add(dt1);
if (dt1 != null && dt1.Columns.Count > 0 && dt1.Rows.Count > 0)
{
string sel_seats = dt1.Rows[0]["sel_seats"].ToString();
string sel_seat_row_cols = dt1.Rows[0]["sel_seat_row_cols"].ToString();
string total_fare = dt1.Rows[0]["total_fare"].ToString();
if (sel_seats != "" && total_fare != "")
{
status = "Success";
statusReason = "";
}
else
{
status = "Fail";
statusReason = "Your given seat numbers are already booked or not available in seat layout.";
}
}
else
{
status = "Fail";
statusReason = "Your given seat numbers are already booked or not available in seat layout.";
}
}
#endregion
#region KalladaTentativeBooking
if (api == "Kal")
{
string jDate = ""; string sId = ""; string dId = ""; string serviceId = ""; string selectedSeats = "";
int noOfSeats = 0; string bId = ""; string genderType = ""; string psgrName = "";
jDate = strArray[1].ToString();
sId = strArray[2].ToString();
dId = strArray[3].ToString();
serviceId = strArray[4].ToString();
selectedSeats = strArray[5].ToString();
bId = strArray[6].ToString();
noOfSeats = Convert.ToInt32(strArray[7].ToString());
genderType = dtTicketInfo.Rows[0]["Title"].ToString();
psgrName = dtTicketInfo.Rows[0]["FullName"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
psgrName = psgrName + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
genderType = genderType + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
DataTable dt1 = objKalladaAPILayer.SeatBlocking(jDate, sId, dId, serviceId, selectedSeats);
ds = new DataSet();
ds.Tables.Add(dt1);
if (dt1 != null && dt1.Columns.Count > 0 && dt1.Rows.Count > 0)
{
string sel_seats = dt1.Rows[0]["sel_seats"].ToString();
string sel_seat_row_cols = dt1.Rows[0]["sel_seat_row_cols"].ToString();
string total_fare = dt1.Rows[0]["total_fare"].ToString();
if (sel_seats != "" && total_fare != "")
{
status = "Success";
statusReason = "";
}
else
{
status = "Fail";
statusReason = "Your given seat numbers are already booked or not available in seat layout.";
}
}
else
{
status = "Fail";
statusReason = "Your given seat numbers are already booked or not available in seat layout.";
}
}
#endregion
#region TicketGooseBooking
if (api == "Tig")
{
string scheduleId = ""; string TravelDate = ""; string FromStationId = "";
string ToStationId = ""; string boardingPointId = ""; string emailId = "";
string mobileNbr = ""; string address = "";
string[] otherInfo = dtTicketInfo.Rows[0]["OtherInfo"].ToString().Split(';');
FromStationId = otherInfo[1].ToString();
ToStationId = otherInfo[2].ToString();
TravelDate = otherInfo[3].ToString();
scheduleId = otherInfo[4].ToString();
boardingPointId = otherInfo[5].ToString();
emailId = dtTicketInfo.Rows[0]["EmailId"].ToString();
mobileNbr = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
address = dtTicketInfo.Rows[0]["Address"].ToString();
string[] seatNos = dtTicketInfo.Rows[0]["SeatNos"].ToString().Split(',');
string[] ages = dtTicketInfo.Rows[0]["AgeList"].ToString().Split(',');
string[] genders = dtTicketInfo.Rows[0]["GenderList"].ToString().Split(',');
string[] names = dtTicketInfo.Rows[0]["FullNameList"].ToString().Split(',');
PassengerDetailDTO[] PassengerDetailDT = new PassengerDetailDTO[seatNos.Length];
for (int i = 0; i < seatNos.Length; i++)
{
PassengerDetailDTO PassengerDetailDTO1 = new PassengerDetailDTO();
PassengerDetailDTO1.age = ages[i].ToString();
PassengerDetailDTO1.name = names[i].ToString();
PassengerDetailDTO1.seatNbr = seatNos[i].ToString();
PassengerDetailDTO1.sex = genders[i].ToString();
PassengerDetailDT[i] = PassengerDetailDTO1;
}
DataTable dt = objTicketGooseAPILayer.BlockSeatsForBooking(scheduleId, TravelDate, FromStationId, ToStationId,
boardingPointId, emailId, mobileNbr, address, PassengerDetailDT);
ds = new DataSet();
ds.Tables.Add(dt);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
if (dt.Columns.Contains("BookingId"))
{
status = "Success";
statusReason = "";
}
else
{
status = "Fail";
statusReason = "Your given seat numbers are already booked or not available in seat layout.";
}
}
else
{
status = "Fail";
statusReason = "Your given seat numbers are already booked or not available in seat layout.";
}
}
else
{
status = "Fail";
statusReason = "Your given seat numbers are already booked or not available in seat layout.";
}
}
#endregion
return ds;
}
catch (Exception)
{
throw;
}
}
protected void BookTicket()
{
try
{
int sourceStationId = 0; int destinationStationId = 0; string journeyDate = "";
long serviceId = 0; int serviceTransId = 0; int noOfSeats = 0; string address = ""; string contactNo = ""; string emailID = "";
long blockedTicketId = 0; string apiname = ""; string boradingpointid = ""; int k = 0;
string status = ""; string api = "";
DataSet dsbookresult = null;
if (Session["manabusrefno"] != null)
{
ObjBAL = new ClsBAL();
ObjBAL.manabusRefNo = Session["manabusrefno"].ToString();
_objDataSetBook = (DataSet)ObjBAL.GetTcktDetByMRefNo();
if (_objDataSetBook != null)
{
if (_objDataSetBook.Tables.Count > 0)
{
if (_objDataSetBook.Tables[0].Rows.Count > 0)
{
if (_objDataSetBook.Tables[0].Rows.Count < 3)
{
#region Book Ticket
foreach (DataRow dr in _objDataSetBook.Tables[0].Rows)
{
string manabusrefNo = dr["OnewayMBRefNo"].ToString();
apiname = dr["APIName"].ToString();
sourceStationId = Convert.ToInt32(dr["SourceId"].ToString());
destinationStationId = Convert.ToInt32(dr["DestinationId"].ToString());
DateTime doj = Convert.ToDateTime(dr["DateOfJourney"]);
boradingpointid = dr["BoardingPointID"].ToString();
if (apiname == "Abhibus" || apiname == "Kallada")
{
journeyDate = doj.ToString("yyyy-MM-dd");
}
else
{
journeyDate = doj.ToString("yyyy/MM/dd");
}
if (dr["ServiceID"].ToString() == "")
{
serviceId = 0;
}
else
{
serviceId = Convert.ToInt64(dr["ServiceID"].ToString());
}
string bookinId = "";
address = dr["Address"].ToString();
contactNo = dr["ContactNo"].ToString();
emailID = dr["EmailId"].ToString();
if (dr["ServiceTranDateID"].ToString() == "")
{
serviceTransId = 0;
}
else
{
serviceTransId = Convert.ToInt32(dr["ServiceTranDateID"].ToString());
}
noOfSeats = Convert.ToInt32(dr["NoOfSeats"].ToString());
if (apiname != "TicketGoose")
{
if (dr["BlockedId"].ToString() == "")
{
blockedTicketId = 0;
}
else
{
blockedTicketId = Convert.ToInt64(dr["BlockedId"].ToString());
}
}
else { blockedTicketId = 0; bookinId = Convert.ToString(dr["BlockedId"].ToString()); }
string seatNos = dr["SeatNos"].ToString();
string gendertype = dr["Gender"].ToString();
string psgrname = dr["FullName"].ToString();
string idType = dr["IDType"].ToString();
string idNo = dr["IDNumber"].ToString();
string idIssuedBy = dr["IDIssuedBy"].ToString();
string[] selectedSeatsArray = seatNos.Split(',');
book_ticket bookTicket = new book_ticket();
object[] obj = new object[2];
book_ticketSeat_detailsSeat_detail[] sD = new book_ticketSeat_detailsSeat_detail[noOfSeats];
string strPassengers = dr["PassengerDetails"].ToString();
string[] strPassengersArray = strPassengers.Split(',');
for (int i = 0; i < noOfSeats; i++)
{
book_ticketSeat_detailsSeat_detail sdd = new book_ticketSeat_detailsSeat_detail();
sdd.seat_number = selectedSeatsArray[i].ToString();
string strPassenger = strPassengersArray[i].ToString();
string[] strPassengerArray = strPassenger.Split('-');
sdd.title = strPassengerArray[1].ToString();
if (strPassengerArray[1].ToString() == "Mr")
{
sdd.sex = "M";
}
else { sdd.sex = "F"; }
if (i == 0) { sdd.is_primary = "true"; }
else { sdd.is_primary = "false"; }
sdd.address = address;
string id = "";//1 -> Pan Card, 2 -> D/L, 3 -> Passport, 4 -> Voter, 5 -> Aadhar Card
if (idType.ToString().ToLower().Contains("pan"))
{
id = "1";
}
else if (idType.ToString().ToLower().Contains("dri"))
{
id = "2";
}
else if (idType.ToString().ToLower().Contains("pass"))
{
id = "3";
}
else if (idType.ToString().ToLower().Contains("voter"))
{
id = "4";
}
else if (idType.ToString().ToLower().Contains("adhar"))
{
id = "5";
}
else if (idType.ToString().ToLower().Contains("ration"))
{
id = "4";
}
sdd.id_card_type = id;
sdd.id_card_number = idNo;
sdd.id_card_issued_by = idIssuedBy;
sD[i] = sdd;
}
book_ticketSeat_details ss = new book_ticketSeat_details();
ss.seat_detail = sD;
book_ticketContact_detail cc = new book_ticketContact_detail();
cc.mobile_number = contactNo;
cc.email = emailID;
cc.emergency_name = contactNo;
obj[0] = ss;
bookTicket.Items = obj;
dsbookresult = CommonBookticket(sourceStationId, destinationStationId, journeyDate, serviceId, serviceTransId,
blockedTicketId, boradingpointid, bookTicket, noOfSeats, seatNos, gendertype, psgrname, address,
dr["FullName"].ToString(), contactNo, emailID, Session["manabusrefno"].ToString(), manabusrefNo,
apiname, out api, out status, bookinId);
if (status == "Success")
{
InsertBookedTicketDetails(dsbookresult, manabusrefNo, api);
}
else
{
lblReturnMsg.Text = "Failed to book. Please contact administartor of LoveJourney.";
lblReturnMsg.Visible = true;
}
}
#endregion
#region GetTicketDetails
if (status == "Success")
{
#region Update Cash Coupon
UpdateCashCoupon(Session["manabusrefno"].ToString(), emailID);
#endregion
GetTicketDetails();
}
#endregion
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Booking(DataTable dtTicketInfo, DataSet dsTentativeInfo, string referenceNumber, out string api,
out string status, out string statusReason)
{
try
{
DataSet dsBookingResult = null;
string str = dtTicketInfo.Rows[0]["OtherInfo"].ToString();
string[] strArray = str.Split(';');
api = ""; status = ""; statusReason = "";
api = strArray[0].ToString();
#region KesineniBooking
if (api == "Kes")
{
int sourceStationId = 0; int destinationStationId = 0; string journeyDate = ""; long serviceId = 0;
int coachTypeId = 0; int noOfSeats = 0; string seatNumbersList = ""; string firstNameList = "";
string lastNameList = ""; string genderList = ""; string ageList = ""; string contactNumberList = "";
string boardingPointIdList = ""; string droppingPointId = ""; string ticketFare = ""; string emailId = "";
string address = ""; string photoIdType = ""; string photoIdNo = ""; string photoIdIssuingAuthority = "";
decimal totalBasicFare = 0; decimal serviceTaxPercentage = 0; string discountcode = "";
sourceStationId = Convert.ToInt32(strArray[1].ToString());
destinationStationId = Convert.ToInt32(strArray[2].ToString());
journeyDate = strArray[3].ToString();
serviceId = Convert.ToInt64(strArray[4].ToString());
coachTypeId = Convert.ToInt32(strArray[5].ToString());
noOfSeats = Convert.ToInt32(strArray[7].ToString());
seatNumbersList = strArray[8].ToString();
boardingPointIdList = strArray[9].ToString();
ticketFare = Convert.ToString(strArray[6].ToString());
droppingPointId = strArray[11].ToString();
emailId = dtTicketInfo.Rows[0]["EmailId"].ToString();
address = dtTicketInfo.Rows[0]["Address"].ToString();
photoIdType = "photoIdType";
photoIdNo = referenceNumber;
photoIdIssuingAuthority = "photoIdIssuingAuthority";
totalBasicFare = Convert.ToDecimal(strArray[10].ToString());
serviceTaxPercentage = Convert.ToDecimal(0);
discountcode = "0";
if (dtTicketInfo.Columns.Contains("FullNameList") &&
dtTicketInfo.Columns.Contains("PhoneNoList") &&
dtTicketInfo.Columns.Contains("AgeList") &&
dtTicketInfo.Columns.Contains("GenderList"))
{
if (dtTicketInfo.Rows[0]["FullNameList"].ToString() != "" &&
dtTicketInfo.Rows[0]["PhoneNoList"].ToString() != "" &&
dtTicketInfo.Rows[0]["AgeList"].ToString() != "" &&
dtTicketInfo.Rows[0]["GenderList"].ToString() != "")
{
firstNameList = dtTicketInfo.Rows[0]["FullNameList"].ToString();
lastNameList = dtTicketInfo.Rows[0]["FullNameList"].ToString();
genderList = dtTicketInfo.Rows[0]["GenderList"].ToString();
ageList = dtTicketInfo.Rows[0]["AgeList"].ToString();
contactNumberList = dtTicketInfo.Rows[0]["PhoneNoList"].ToString();
}
else
{
firstNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
genderList = dtTicketInfo.Rows[0]["Title"].ToString();
ageList = dtTicketInfo.Rows[0]["Age"].ToString();
contactNumberList = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
firstNameList = firstNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = lastNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
contactNumberList = contactNumberList + "," + dtTicketInfo.Rows[0]["PhoneNo"].ToString();
ageList = ageList + "," + dtTicketInfo.Rows[0]["Age"].ToString();
genderList = genderList + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
}
}
else
{
firstNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = dtTicketInfo.Rows[0]["FullName"].ToString();
genderList = dtTicketInfo.Rows[0]["Title"].ToString();
ageList = dtTicketInfo.Rows[0]["Age"].ToString();
contactNumberList = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
firstNameList = firstNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
lastNameList = lastNameList + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
contactNumberList = contactNumberList + "," + dtTicketInfo.Rows[0]["PhoneNo"].ToString();
ageList = ageList + "," + dtTicketInfo.Rows[0]["Age"].ToString();
genderList = genderList + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
}
if (dtTicketInfo.Columns.Contains("IdType") &&
dtTicketInfo.Columns.Contains("IdNo") &&
dtTicketInfo.Columns.Contains("IdIssuedBy"))
{
if (dtTicketInfo.Rows[0]["IdType"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdNo"].ToString() != "")
{
photoIdType = dtTicketInfo.Rows[0]["IdType"].ToString();
photoIdNo = dtTicketInfo.Rows[0]["IdNo"].ToString();
photoIdIssuingAuthority = dtTicketInfo.Rows[0]["IdIssuedBy"].ToString();
}
}
DataSet ds = dsTentativeInfo;
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Columns.Count > 1)
{
int serviceTransId = 0;
long blockedTicketId = 0;
serviceTransId = Convert.ToInt32(ds.Tables[0].Rows[0]["ServiceTransDateID"].ToString());
blockedTicketId = Convert.ToInt64(ds.Tables[0].Rows[0]["BlockedTicketID"].ToString());
dsBookingResult = objKesineniAPILayer.BookTicketsConfirmationOnwardJourney(sourceStationId, destinationStationId, journeyDate,
serviceId, serviceTransId, noOfSeats, blockedTicketId, GenerateManabusRefNo(), GenerateManabusRefNo());
status = "Success"; statusReason = "";
}
}
else
{
status = "Fail"; statusReason = "Need to write.";
}
}
#endregion
#region BitlaBooking
if (api == "Bit")
{
objBitlaAPILayer.ReservationId = strArray[1].ToString();
objBitlaAPILayer.OriginId = strArray[2].ToString();
objBitlaAPILayer.DestinationId = strArray[3].ToString();
objBitlaAPILayer.BoardingAt = strArray[5].ToString();
objBitlaAPILayer.NoOfSeats = strArray[4].ToString();
objBitlaAPILayer.RefNumber = referenceNumber;
int noOfSeats = Convert.ToInt32(strArray[4].ToString());
string selectedSeats = strArray[6].ToString();
string[] selectedSeatsArray = selectedSeats.Split(',');
book_ticket bookTicket = new book_ticket();
object[] obj = new object[2];
book_ticketSeat_detailsSeat_detail[] sD = new book_ticketSeat_detailsSeat_detail[noOfSeats];
if (dtTicketInfo.Columns.Contains("FullNameList") &&
dtTicketInfo.Columns.Contains("PhoneNoList") &&
dtTicketInfo.Columns.Contains("AgeList") &&
dtTicketInfo.Columns.Contains("GenderList") &&
dtTicketInfo.Columns.Contains("IdType") &&
dtTicketInfo.Columns.Contains("IdNo") &&
dtTicketInfo.Columns.Contains("IdIssuedBy"))
{
if (dtTicketInfo.Rows[0]["FullNameList"].ToString() != "" &&
dtTicketInfo.Rows[0]["PhoneNoList"].ToString() != "" &&
dtTicketInfo.Rows[0]["AgeList"].ToString() != "" &&
dtTicketInfo.Rows[0]["GenderList"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdType"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdNo"].ToString() != "" &&
dtTicketInfo.Rows[0]["IdIssuedBy"].ToString() != "")
{
string[] fullNameListArray = dtTicketInfo.Rows[0]["FullNameList"].ToString().Split(',');
string[] phoneNoListArray = dtTicketInfo.Rows[0]["PhoneNoList"].ToString().Split(',');
string[] ageListArray = dtTicketInfo.Rows[0]["AgeList"].ToString().Split(',');
string[] genderListArray = dtTicketInfo.Rows[0]["GenderList"].ToString().Split(',');
string address = dtTicketInfo.Rows[0]["Address"].ToString();
string idType = dtTicketInfo.Rows[0]["IdType"].ToString();
string idNo = dtTicketInfo.Rows[0]["IdNo"].ToString();
string idIssuedBy = dtTicketInfo.Rows[0]["IdIssuedBy"].ToString();
for (int i = 0; i < noOfSeats; i++)
{
book_ticketSeat_detailsSeat_detail sdd = new book_ticketSeat_detailsSeat_detail();
sdd.seat_number = selectedSeatsArray[i].ToString();
sdd.title = genderListArray[i].ToString();
sdd.name = fullNameListArray[i].ToString();
sdd.age = ageListArray[i].ToString();
sdd.sex = genderListArray[i].ToString();
if (i == 0) { sdd.is_primary = "true"; }
else { sdd.is_primary = "false"; }
sdd.address = address;
string id = "";//1 -> Pan Card, 2 -> D/L, 3 -> Passport, 4 -> Voter, 5 -> Aadhar Card
if (idType.ToString().ToLower().Contains("pan"))
{
id = "1";
}
else if (idType.ToString().ToLower().Contains("dri"))
{
id = "2";
}
else if (idType.ToString().ToLower().Contains("pass"))
{
id = "3";
}
else if (idType.ToString().ToLower().Contains("voter"))
{
id = "4";
}
else if (idType.ToString().ToLower().Contains("adhar"))
{
id = "5";
}
else if (idType.ToString().ToLower().Contains("ration"))
{
id = "4";
}
sdd.id_card_type = id;
sdd.id_card_number = idNo;
sdd.id_card_issued_by = idIssuedBy;
sD[i] = sdd;
}
}
else
{
for (int i = 0; i < noOfSeats; i++)
{
book_ticketSeat_detailsSeat_detail sdd = new book_ticketSeat_detailsSeat_detail();
sdd.seat_number = selectedSeatsArray[i].ToString();
sdd.title = "Mr";
sdd.name = dtTicketInfo.Rows[0]["FullName"].ToString();
sdd.age = dtTicketInfo.Rows[0]["Age"].ToString();
sdd.sex = dtTicketInfo.Rows[0]["Title"].ToString();
if (i == 0) { sdd.is_primary = "true"; }
else { sdd.is_primary = "false"; }
sdd.address = "";
sdd.id_card_type = "";//1 -> Pan Card, 2 -> D/L, 3 -> Passport, 4 -> Voter, 5 -> Aadhar Card
sdd.id_card_number = "";
sdd.id_card_issued_by = "";
sD[i] = sdd;
}
}
}
else
{
for (int i = 0; i < noOfSeats; i++)
{
book_ticketSeat_detailsSeat_detail sdd = new book_ticketSeat_detailsSeat_detail();
sdd.seat_number = selectedSeatsArray[i].ToString();
sdd.title = "Mr";
sdd.name = dtTicketInfo.Rows[0]["FullName"].ToString();
sdd.age = dtTicketInfo.Rows[0]["Age"].ToString();
sdd.sex = dtTicketInfo.Rows[0]["Title"].ToString();
if (i == 0) { sdd.is_primary = "true"; }
else { sdd.is_primary = "false"; }
sdd.address = "";
sdd.id_card_type = "";//1 -> Pan Card, 2 -> D/L, 3 -> Passport, 4 -> Voter, 5 -> Aadhar Card
sdd.id_card_number = "";
sdd.id_card_issued_by = "";
sD[i] = sdd;
}
}
book_ticketSeat_details ss = new book_ticketSeat_details();
ss.seat_detail = sD;
book_ticketContact_detail cc = new book_ticketContact_detail();
cc.mobile_number = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
cc.email = dtTicketInfo.Rows[0]["EmailId"].ToString();
cc.emergency_name = dtTicketInfo.Rows[0]["PhoneNo"].ToString();
obj[0] = ss;
obj[1] = cc;
bookTicket.Items = obj;
objBitlaAPILayer.TicketDetails = bookTicket;
DataSet dsBookTicket = dsTentativeInfo;
DataSet dsBookTicket2 = objBitlaAPILayer.BookTicket();
if (dsBookTicket2 != null)
{
if (dsBookTicket2.Tables[0].Rows.Count > 0)
{
status = "Success"; statusReason = "";
dsBookingResult = dsBookTicket2;
}
else
{
status = "Fail"; statusReason = "Need to write.";
}
}
else
{
status = "Fail"; statusReason = "Need to write.";
}
}
#endregion
#region AbhiBusBooking
if (api == "Abh")
{
string jDate = ""; string sId = ""; string dId = ""; string serviceId = ""; string selectedSeats = "";
int noOfSeats = 0; string bId = ""; string genderType = ""; string psgrName = "";
jDate = strArray[1].ToString();
sId = strArray[2].ToString();
dId = strArray[3].ToString();
serviceId = strArray[4].ToString();
selectedSeats = strArray[5].ToString();
bId = strArray[6].ToString();
noOfSeats = Convert.ToInt32(strArray[7].ToString());
genderType = dtTicketInfo.Rows[0]["Title"].ToString();
psgrName = dtTicketInfo.Rows[0]["FullName"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
psgrName = psgrName + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
genderType = genderType + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
DataSet ds11 = dsTentativeInfo;
DataTable dt1 = ds11.Tables[0];
if (dt1 != null && dt1.Columns.Count > 0 && dt1.Rows.Count > 0)
{
string sel_seats = dt1.Rows[0]["sel_seats"].ToString();
string sel_seat_row_cols = dt1.Rows[0]["sel_seat_row_cols"].ToString();
string total_fare = dt1.Rows[0]["total_fare"].ToString();
if (sel_seats != "" && sel_seat_row_cols != "" && total_fare != "")
{
DataTable dt2 = objAbhiBusAPILayer.SeatBooking(jDate, sId, dId, serviceId, selectedSeats, genderType, psgrName,
bId, dtTicketInfo.Rows[0]["Address"].ToString(), dtTicketInfo.Rows[0]["FullName"].ToString(),
dtTicketInfo.Rows[0]["PhoneNo"].ToString(), dtTicketInfo.Rows[0]["EmailId"].ToString(), referenceNumber);
status = "Success"; statusReason = "Need to write";
dsBookingResult = new DataSet();
dsBookingResult.Tables.Add(dt2);
}
}
else
{
status = "Fail"; statusReason = "Need to write";
}
}
#endregion
#region KalladaBooking
if (api == "Kal")
{
string jDate = ""; string sId = ""; string dId = ""; string serviceId = ""; string selectedSeats = "";
int noOfSeats = 0; string bId = ""; string genderType = ""; string psgrName = "";
jDate = strArray[1].ToString();
sId = strArray[2].ToString();
dId = strArray[3].ToString();
serviceId = strArray[4].ToString();
selectedSeats = strArray[5].ToString();
bId = strArray[6].ToString();
noOfSeats = Convert.ToInt32(strArray[7].ToString());
genderType = dtTicketInfo.Rows[0]["Title"].ToString();
psgrName = dtTicketInfo.Rows[0]["FullName"].ToString();
if (noOfSeats > 1)
{
for (int i = 0; i < noOfSeats - 1; i++)
{
psgrName = psgrName + "," + dtTicketInfo.Rows[0]["FullName"].ToString();
genderType = genderType + "," + dtTicketInfo.Rows[0]["Title"].ToString();
}
}
DataSet ds11 = dsTentativeInfo;
DataTable dt1 = ds11.Tables[0];
if (dt1 != null && dt1.Columns.Count > 0 && dt1.Rows.Count > 0)
{
string sel_seats = dt1.Rows[0]["sel_seats"].ToString();
string sel_seat_row_cols = dt1.Rows[0]["sel_seat_row_cols"].ToString();
string total_fare = dt1.Rows[0]["total_fare"].ToString();
if (sel_seats != "" && sel_seat_row_cols != "" && total_fare != "")
{
DataTable dt2 = objKalladaAPILayer.SeatBooking(jDate, sId, dId, serviceId, selectedSeats, genderType, psgrName,
bId, dtTicketInfo.Rows[0]["Address"].ToString(), dtTicketInfo.Rows[0]["FullName"].ToString(),
dtTicketInfo.Rows[0]["PhoneNo"].ToString(), dtTicketInfo.Rows[0]["EmailId"].ToString(), referenceNumber);
status = "Success"; statusReason = "Need to write";
dsBookingResult = new DataSet();
dsBookingResult.Tables.Add(dt2);
}
}
else
{
status = "Fail"; statusReason = "Need to write";
}
}
#endregion
return dsBookingResult;
}
catch (Exception)
{
throw;
}
}
protected DataSet CommonBookticket(int sourceId, int destinationId, string DOJ, long servicereservationId, int serviceTransId,
long blockedTicketId, string boardingpointId, book_ticket bookTicket, int noofSeats, string selectedSeats, string genderType,
string psgrName, string address, string fullName, string phoneNo, string emailId, string refNo, string manabusref, string Api,
out string api, out string status, string bookinId)
{
try
{
api = ""; status = "Fail"; DataSet dsBookingResult = null; bool res = false;
if (Api.ToString() == "Kesineni")
{
#region Kesineni
dsBookingResult = objKesineniAPILayer.BookTicketsConfirmationOnwardJourney(sourceId, destinationId, DOJ,
servicereservationId, serviceTransId, noofSeats, blockedTicketId, GenerateCashCoupon(), GenerateCashCoupon());
if (dsBookingResult != null)
{
if (dsBookingResult.Tables.Count > 0)
{
if (dsBookingResult.Tables[0].Rows.Count > 0)
{
res = true;
status = "Success";
api = "Kesineni";
}
}
}
#endregion
}
else if (Api.ToString() == "Bitla")
{
#region Bitla
objBitlaAPILayer.ReservationId = Convert.ToString(servicereservationId);
objBitlaAPILayer.OriginId = Convert.ToString(sourceId);
objBitlaAPILayer.DestinationId = Convert.ToString(destinationId);
objBitlaAPILayer.BoardingAt = boardingpointId;
objBitlaAPILayer.NoOfSeats = Convert.ToString(noofSeats);
objBitlaAPILayer.RefNumber = refNo;
objBitlaAPILayer.TicketDetails = bookTicket;
dsBookingResult = objBitlaAPILayer.BookTicket();
if (dsBookingResult != null)
{
if (dsBookingResult.Tables[0].Rows.Count > 0)
{
if (dsBookingResult.Tables[0].Columns.Count > 3)
{
res = true;
status = "Success";
api = "Bitla";
}
}
}
#endregion
}
else if (Api.ToString() == "Abhibus")
{
#region Abhibus
DataTable dtabhibus = objAbhiBusAPILayer.SeatBooking(DOJ, Convert.ToString(sourceId),
Convert.ToString(destinationId), Convert.ToString(servicereservationId), selectedSeats, genderType, psgrName,
boardingpointId, address.ToString(), fullName.ToString(),
phoneNo.ToString(), emailId.ToString(), refNo);
dsBookingResult = new DataSet();
dsBookingResult.Tables.Add(dtabhibus);
if (dsBookingResult != null)
{
if (dsBookingResult.Tables[0].Rows.Count > 0)
{
if (dsBookingResult.Tables[0].Columns.Count > 2 && dsBookingResult.Tables[0].Rows[0]["TicketNumber"].ToString() != "")
{
res = true;
status = "Success";
api = "Abhibus";
}
}
}
#endregion
}
else if (Api.ToString() == "Kallada")
{
DataTable dtKallada = objKalladaAPILayer.SeatBooking(DOJ, Convert.ToString(sourceId), Convert.ToString(destinationId),
Convert.ToString(servicereservationId), selectedSeats, genderType, psgrName,
boardingpointId, address.ToString(), fullName.ToString(),
phoneNo.ToString(), emailId.ToString(), refNo);
dsBookingResult = new DataSet();
dsBookingResult.Tables.Add(dtKallada);
if (dsBookingResult != null)
{
if (dsBookingResult.Tables[0].Rows.Count > 0)
{
if (dsBookingResult.Tables[0].Columns.Count > 2 && dsBookingResult.Tables[0].Rows[0]["TicketNumber"].ToString() != "")
{
res = true;
status = "Success";
api = "Kallada";
}
}
}
}
else if (Api.ToString() == "TicketGoose")
{
DataTable dt = objTicketGooseAPILayer.BookTicket(bookinId);
dsBookingResult = new DataSet();
dsBookingResult.Tables.Add(dt);
if (dsBookingResult != null)
{
if (dsBookingResult.Tables[0].Rows.Count > 0)
{
if (dsBookingResult.Tables[0].Columns.Count > 2 && dsBookingResult.Tables[0].Rows[0]["Status"].ToString() != "")
{
if (dsBookingResult.Tables[0].Rows[0]["Status"].ToString() == "Success")
{
res = true;
status = "Success";
api = "TicketGoose";
}
}
}
}
}
return dsBookingResult;
}
catch (Exception ex)
{
throw ex;
}
}
