public DataTable BlockSeatsForBooking(string scheduleId, string TravelDate, string FromStationId, string ToStationId, string boardingPointId, string emailId, string mobileNbr, string address, PassengerDetailDTO[] PassengerDetailDTO) { try { TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); BlockedSeatsForBookingDetails BlockSeatsBooking = o.blockSeatsForBooking(UserId, Password, scheduleId, TravelDate, FromStationId, ToStationId, boardingPointId, emailId, mobileNbr, address, PassengerDetailDTO); DataTable data = new DataTable(); data.Columns.Add("BookingId"); data.Columns.Add("expireTime"); data.Columns.Add("cancellationDescList"); if (BlockSeatsBooking.status.message.ToString() == "Success") { foreach (var canceldesc in BlockSeatsBooking.cancellationDescList) { DataRow row = data.NewRow(); row["BookingId"] = BlockSeatsBooking.bookingId; row["expireTime"] = BlockSeatsBooking.expireTime; row["cancellationDescList"] = canceldesc.ToString(); data.Rows.Add(row); } } o.Close(); return data; } catch (Exception ex) { throw ex; } }
public DataTable CancelTicket(string bookingId, String[] SeatNo) { try { TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); DataTable data = new DataTable(); data.Columns.Add("cancellationCharge"); data.Columns.Add("seatFare"); data.Columns.Add("seatNbr"); data.Columns.Add("Status"); CancellationChargeDetails CTicket = o.cancelTicket(UserId, Password, bookingId, SeatNo); foreach (CancellationChargeDetailsDTO CT in CTicket.cancellationChargeDetailsList) { if (CTicket.status.message.ToString() == "Success") { DataRow row = data.NewRow(); row["cancellationCharge"] = CT.cancellationCharge; row["seatFare"] = CT.seatFare; row["seatNbr"] = CT.seatNbr; row["Status"] = CTicket.status.message.ToString(); data.Rows.Add(row); } } o.Close(); return data; } catch (Exception ex) { throw ex; } }
public DataTable BookTicket(string bookingId) { try { TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); DataTable data = new DataTable(); data.Columns.Add("bookingId"); data.Columns.Add("extraSeatInfo"); data.Columns.Add("seatNbr"); data.Columns.Add("travelsPhoneNbr"); data.Columns.Add("cancellationDescList"); data.Columns.Add("Status"); BookingDetails booking = o.bookTicket(UserId, Password, bookingId); Array cancelarr = booking.extraSeatInfoList; foreach (ExtraSeatInfoDTO Cdesc in cancelarr) { DataRow row = data.NewRow(); row["bookingId"] = bookingId; row["extraSeatInfo"] = Cdesc.extraSeatInfo; row["seatNbr"] = Cdesc.seatNbr; row["travelsPhoneNbr"] = booking.travelsPhoneNbr; row["Status"] = booking.status.message.ToString(); Array ac = booking.cancellationDescList; row["cancellationDescList"] = ac.ToString(); data.Rows.Add(row); } o.Close(); return data; } catch (Exception ex) { throw ex; } }
public DataTable GetTripList(string FromStationId, string ToStationId, string TravelDate) { try { DataTable dataTable = new DataTable(); TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); TripWithArrival TripList = o.getTripListV2(UserId, Password, FromStationId, ToStationId, TravelDate); if (TripList.status.message.ToString() == "success") { Array ObjArray = TripList.tripList; dataTable.Columns.Add("arrivalTime"); dataTable.Columns.Add("availableSeats"); dataTable.Columns.Add("departureTime"); dataTable.Columns.Add("fare"); dataTable.Columns.Add("provider"); dataTable.Columns.Add("scheduleId"); dataTable.Columns.Add("ticketType"); dataTable.Columns.Add("type"); dataTable.Columns.Add("pickUpPoint"); dataTable.Columns.Add("sequence"); foreach (TripWithArrivalDTO Trip1 in ObjArray) { //foreach (PickUpPointDTO PickupPoint in Trip1.pickUpPointList) { DataRow dr = dataTable.NewRow(); dr["arrivalTime"] = Trip1.arrivalTime; dr["availableSeats"] = Trip1.availableSeats; dr["departureTime"] = Trip1.departureTime; dr["fare"] = Trip1.fare; dr["provider"] = Trip1.provider; dr["scheduleId"] = Trip1.scheduleId; dr["ticketType"] = Trip1.ticketType; dr["type"] = Trip1.type; dr["pickUpPoint"] = "";//PickupPoint.description; dr["sequence"] = "";//PickupPoint.sequence; DataRow[] ddd = dataTable.Select("scheduleId = '" + Trip1.scheduleId + "'"); if (ddd.Length == 0) { dataTable.Rows.Add(dr); } } } } o.Close(); return dataTable; } catch (Exception ex) { throw ex; } }
public DataSet GetTripDetails(string FromStationId, string ToStationId, string TravelDate, string scheduleId) { try { TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); DataSet ds1 = new DataSet("dataset"); TripDetails TripDt = o.getTripDetailsV2(UserId, Password, FromStationId, ToStationId, TravelDate, scheduleId); DataTable dataTable = new DataTable(); dataTable.TableName = "BusLayoutList"; if (TripDt.status.message.ToString() == "success") { dataTable.Columns.Add("level"); dataTable.Columns.Add("noOfRows"); dataTable.Columns.Add("noOfColumns"); dataTable.Columns.Add("rowNbr"); dataTable.Columns.Add("columnNbr"); dataTable.Columns.Add("seatNbr"); dataTable.Columns.Add("cellType"); TripDetailsDTO dd = TripDt.tripDetails; foreach (BusLayoutDTO Bdt in dd.busLayoutList) { foreach (SeatDetailsDTO sdt in Bdt.seatDetailsList) { DataRow dr = dataTable.NewRow(); dr["level"] = Bdt.level; dr["noOfRows"] = Bdt.nbrOfRows; dr["noOfColumns"] = Bdt.nbrOfColumns; dr["rowNbr"] = sdt.rowNbr; dr["columnNbr"] = sdt.columnNbr; dr["seatNbr"] = sdt.seatNbr; dr["cellType"] = sdt.cellType; dataTable.Rows.Add(dr); } } DataTable dtseatdetails = new DataTable(); dtseatdetails.TableName = "SeatDetails"; dtseatdetails.Columns.Add("SeatseatNbr"); dtseatdetails.Columns.Add("seatType"); dtseatdetails.Columns.Add("fare"); dtseatdetails.Columns.Add("seatStatus"); foreach (SeatDetailDTO SDt in dd.seatDetailList) { DataRow drseat = dtseatdetails.NewRow(); drseat["SeatseatNbr"] = SDt.seatNbr; drseat["seatType"] = SDt.seatType; drseat["fare"] = SDt.fare; drseat["seatStatus"] = SDt.seatStatus; dtseatdetails.Rows.Add(drseat); } DataTable dtBoarding = new DataTable(); dtBoarding.TableName = "BoardingPoints"; dtBoarding.Columns.Add("boardingPointId"); dtBoarding.Columns.Add("boardingPointName"); dtBoarding.Columns.Add("time"); foreach (BoardingPointDTO BPdt in dd.boardingPointList) { DataRow drboarding = dtBoarding.NewRow(); drboarding["boardingPointId"] = BPdt.boardingPointId; drboarding["boardingPointName"] = BPdt.boardingPointName; drboarding["time"] = BPdt.time; dtBoarding.Rows.Add(drboarding); } ds1.Tables.Add(dtseatdetails); ds1.Tables.Add(dtBoarding); ds1.Tables.Add(dataTable); } o.Close(); return ds1; } catch (Exception ex) { throw ex; } }
public DataTable GetStationList() { try { TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); Station s = o.getStationList(UserId, Password); Array st = s.stationList; DataTable dataTable = new DataTable(); dataTable.Columns.Add("stationId"); dataTable.Columns.Add("stationName"); foreach (StationDTO i in st) { DataRow dr = dataTable.NewRow(); dr["stationId"] = i.stationId; dr["stationName"] = i.stationName; dataTable.Rows.Add(dr); } o.Close(); return dataTable; } catch (Exception ex) { throw ex; } }
public DataTable GetFromToStation() { try { TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); FromToStation from = o.getFromToStationIdList(UserId, Password); Array fm = from.fromToStationList; DataTable dtsid = new DataTable(); dtsid.Columns.Add("toStationId"); dtsid.Columns.Add("fromStationId"); foreach (FromToStationDTO f in fm) { foreach (string str in f.toStationId) { DataRow dd = dtsid.NewRow(); dd["toStationId"] = str.ToString(); dd["fromStationId"] = f.fromStationId; dtsid.Rows.Add(dd); } } o.Close(); return dtsid; } catch (Exception ex) { throw ex; } }
public DataTable ConfirmTicketCancellation(string bookingId, String[] SeatNo) { try { TGTravelServiceClient o = new TGTravelServiceClient(); o.Open(); DataTable data = new DataTable(); data.Columns.Add("Status"); data.Columns.Add("refundAmount"); CancellationDetails CDetails = o.confirmTicketCancellation(UserId, Password, bookingId, SeatNo); DataRow row = data.NewRow(); if (CDetails.status.message.ToString() == "Success") { row["refundAmount"] = CDetails.refundAmount; row["Status"] = CDetails.status.message; data.Rows.Add(row); } o.Close(); return data; } catch (Exception ex) { throw ex; } }