public CLayer.BookingExternalInventory GetAllDetailsByRoomIdandHotelId(string RoomId, string HotelId)
{
CLayer.BookingExternalInventory result = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pRoomId", DataPlug.DataType._Varchar, RoomId));
param.Add(Connection.GetParameter("pHotelId", DataPlug.DataType._Varchar, HotelId));
DataTable dt = Connection.GetTable("BookExternalInventory_ByRoomIdandHotelId", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.BookingExternalInventory()
{
hotel_id = Connection.ToString(dt.Rows[0]["HotelId"]),
hotel_name = Connection.ToString(dt.Rows[0]["HotelName"]),
roomtype_id = Connection.ToString(dt.Rows[0]["RoomId"]),
room_name = Connection.ToString(dt.Rows[0]["RoomName"]),
room_desc = Connection.ToString(dt.Rows[0]["RoomDesc"]),
final_price_at_bookingamt = Connection.ToDecimal(dt.Rows[0]["FinalPriceAtBookingAmt"]),
final_price_at_bookingamtcurr = Connection.ToString(dt.Rows[0]["FinalPriceAtBookingAmtCurr"]),
final_price_at_checkoutamt = Connection.ToDecimal(dt.Rows[0]["FinalPriceAtCheckoutAmt"]),
final_price_at_checkoutamtcurr = Connection.ToString(dt.Rows[0]["FinalPriceAtCheckoutAmtCurr"]),
DomainId = Connection.ToString(dt.Rows[0]["DomainId"]),
RatePlanId = Connection.ToString(dt.Rows[0]["RatePlanId"]),
PromotionId = Connection.ToString(dt.Rows[0]["PromotionId"])
};
}
return(result);
}
public ActionResult CancelExternalRequestEach(long BookingExtInvReqId)
{
CLayer.BookingExternalInventory reqbook = BLayer.BookingExternalInventory.getAllDetailsfromExternalRequest(BookingExtInvReqId);
var Book_Cancelobj = new StayBazar.Inventory.Models.MaxBooking_Cancel.RootObject
{
hotel_id = reqbook.hotel_id,
reservation_id = reqbook.reservation_id
};
string ResponseCancel = StayBazar.Inventory.MaximojoBook.MaximojoBook_Booking_Cancel(Book_Cancelobj);
StayBazar.Inventory.Models.MaxBooking_Cancel_Response.RootObject Bookingcanceldetails = JsonConvert.DeserializeObject <StayBazar.Inventory.Models.MaxBooking_Cancel_Response.RootObject>(ResponseCancel);
//Saving Cancel Details of external booking request
CLayer.BookingExternalInventory bookcandt = new CLayer.BookingExternalInventory();
bookcandt.BookingExtInvReqId = reqbook.BookingExtInvReqId;
bookcandt.BookingId = reqbook.BookingId;
bookcandt.reservation_id = reqbook.reservation_id;
if (Bookingcanceldetails.status == "Success")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.Success;
}
else if (Bookingcanceldetails.status == "AlreadyCancelled")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.AlreadyCancelled;
}
else if (Bookingcanceldetails.status == "CannotBeCancelled")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.CannotBeCancelled;
}
else if (Bookingcanceldetails.status == "UnknownReference")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.UnknownReference;
}
else if (Bookingcanceldetails.status == "Error")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.Error;
}
else
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.none;
}
int CacelSts = bookcandt.Cancellation_Status;
BLayer.BookingExternalInventory.UpdateCancellationStatus(reqbook.BookingExtInvReqId, CacelSts);
bookcandt.Cancellation_Number = Bookingcanceldetails.cancellation_number;
if (Bookingcanceldetails.cancelled_date == null)
{
Bookingcanceldetails.cancelled_date = Convert.ToString(DateTime.Now);
}
bookcandt.Cancelled_Date = Bookingcanceldetails.cancelled_date;
bookcandt.Cancellation_Response = ResponseCancel;
BLayer.BookingExternalInventory.SaveBookingCancelResponse(bookcandt);
return(RedirectToAction("Index", "ExternalInventoryBookingRequest", new { area = "Admin" }));
}
public long SaveBookingCancelResponse(CLayer.BookingExternalInventory data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBookingExtInvReqId", DataPlug.DataType._BigInt, data.BookingExtInvReqId));
param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._BigInt, data.BookingId));
param.Add(Connection.GetParameter("pReservation_id", DataPlug.DataType._Varchar, data.reservation_id));
param.Add(Connection.GetParameter("pCancellation_Status", DataPlug.DataType._Int, data.Cancellation_Status));
param.Add(Connection.GetParameter("pCancelled_Date", DataPlug.DataType._Varchar, data.Cancelled_Date));
param.Add(Connection.GetParameter("pCancellation_Number", DataPlug.DataType._Varchar, data.Cancellation_Number));
param.Add(Connection.GetParameter("pCancellation_Response", DataPlug.DataType._Text, data.Cancellation_Response));
object result = Connection.ExecuteQueryScalar("BookingExternalInventoryCancel_save", param);
return(Connection.ToInteger(result));
}
public long SaveBookingSubmitResponse(CLayer.BookingExternalInventory data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBookingId", DataPlug.DataType._Varchar, data.BookingId));
param.Add(Connection.GetParameter("pHotel_id", DataPlug.DataType._Varchar, data.hotel_id));
param.Add(Connection.GetParameter("pReference_Id", DataPlug.DataType._Varchar, data.Reference_Id));
param.Add(Connection.GetParameter("preservation_id", DataPlug.DataType._Varchar, data.reservation_id));
param.Add(Connection.GetParameter("pBookingStatus", DataPlug.DataType._Varchar, data.BookingStatus));
param.Add(Connection.GetParameter("pStatusDetails", DataPlug.DataType._Varchar, data.StatusDetails));
param.Add(Connection.GetParameter("pReservationStatus", DataPlug.DataType._Varchar, data.ReservationStatus));
param.Add(Connection.GetParameter("pCheckInDate", DataPlug.DataType._Varchar, data.CheckInDate));
param.Add(Connection.GetParameter("pCheckOutDate", DataPlug.DataType._Varchar, data.CheckOutDate));
param.Add(Connection.GetParameter("pCustomerId", DataPlug.DataType._Varchar, data.CustomerId));
param.Add(Connection.GetParameter("pIpAddtress", DataPlug.DataType._Varchar, data.IpAddtress));
param.Add(Connection.GetParameter("pRoomtype_id", DataPlug.DataType._Varchar, data.roomtype_id));
param.Add(Connection.GetParameter("pRoom_name", DataPlug.DataType._Varchar, data.room_name));
param.Add(Connection.GetParameter("pRoom_desc", DataPlug.DataType._Text, data.room_desc));
param.Add(Connection.GetParameter("pFinal_price_at_bookingamt", DataPlug.DataType._Decimal, data.final_price_at_bookingamt));
param.Add(Connection.GetParameter("pFinal_price_at_checkoutamt", DataPlug.DataType._Decimal, data.final_price_at_checkoutamt));
param.Add(Connection.GetParameter("pResponse", DataPlug.DataType._Varchar, data.Response));
param.Add(Connection.GetParameter("pBookingApiType", DataPlug.DataType._Varchar, data.BookingApiType));
param.Add(Connection.GetParameter("pDomainId", DataPlug.DataType._Varchar, data.DomainId));
param.Add(Connection.GetParameter("pPromotionId", DataPlug.DataType._Varchar, data.PromotionId));
param.Add(Connection.GetParameter("pRatePlanId", DataPlug.DataType._Varchar, data.RatePlanId));
param.Add(Connection.GetParameter("pquery_key", DataPlug.DataType._Varchar, data.query_key));
param.Add(Connection.GetParameter("pBookingsessionId", DataPlug.DataType._Varchar, data.BookingsessionId));
param.Add(Connection.GetParameter("pBookingrequestId", DataPlug.DataType._Varchar, data.BookingrequestId));
param.Add(Connection.GetParameter("pCancellation_Status", DataPlug.DataType._Varchar, data.Cancellation_Status));
object result = Connection.ExecuteQueryScalar("BookingExternalInventoryRequest_save", param);
return(Connection.ToInteger(result));
}
public long Save(CLayer.BookingExternalInventory data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBookingExtInvReqId", DataPlug.DataType._Varchar, data.BookingExtInvReqId));
param.Add(Connection.GetParameter("pHotel_id", DataPlug.DataType._Varchar, data.hotel_id));
param.Add(Connection.GetParameter("pHotel_name", DataPlug.DataType._Varchar, data.hotel_name));
param.Add(Connection.GetParameter("pRoomtype_id", DataPlug.DataType._Varchar, data.roomtype_id));
param.Add(Connection.GetParameter("pRoom_name", DataPlug.DataType._Varchar, data.room_name));
param.Add(Connection.GetParameter("pRoom_desc", DataPlug.DataType._Text, data.room_desc));
param.Add(Connection.GetParameter("pFinal_price_at_bookingamt", DataPlug.DataType._Decimal, data.final_price_at_bookingamt));
param.Add(Connection.GetParameter("pFinal_price_at_bookingamtcurr", DataPlug.DataType._Varchar, data.final_price_at_bookingamtcurr));
param.Add(Connection.GetParameter("pFinal_price_at_checkoutamt", DataPlug.DataType._Decimal, data.final_price_at_checkoutamt));
param.Add(Connection.GetParameter("pFinal_price_at_checkoutamtcurr", DataPlug.DataType._Varchar, data.final_price_at_checkoutamtcurr));
param.Add(Connection.GetParameter("pDomainId", DataPlug.DataType._Varchar, data.DomainId));
param.Add(Connection.GetParameter("pPromotionId", DataPlug.DataType._Varchar, data.PromotionId));
param.Add(Connection.GetParameter("pRatePlanId", DataPlug.DataType._Varchar, data.RatePlanId));
object result = Connection.ExecuteQueryScalar("BookingExternalInventory_save", param);
return(Connection.ToInteger(result));
}
public CLayer.BookingExternalInventory getAllDetailsfromExternalRequest(long BookingExtInvReqId)
{
CLayer.BookingExternalInventory result = new CLayer.BookingExternalInventory();
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pBookingExtInvReqId", DataPlug.DataType._Varchar, BookingExtInvReqId));
DataTable dt = Connection.GetTable("GetAllDetailsfromExternalRequest", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.BookingExternalInventory()
{
BookingExtInvReqId = Connection.ToLong(dt.Rows[0]["BookingExtInvReqId"]),
BookingId = Connection.ToLong(dt.Rows[0]["Booking_Id"]),
hotel_id = Connection.ToString(dt.Rows[0]["Hotel_Id"]),
Reference_Id = Connection.ToString(dt.Rows[0]["Reference_Id"]),
reservation_id = Connection.ToString(dt.Rows[0]["Reservation_Id"]),
BookingStatus = Connection.ToInteger(dt.Rows[0]["Status"]),
StatusDetails = Connection.ToString(dt.Rows[0]["StatusDetails"]),
ReservationStatus = Connection.ToInteger(dt.Rows[0]["Reservation_Status"]),
CheckInDate = Connection.ToString(dt.Rows[0]["CheckIn_date"]),
CheckOutDate = Connection.ToString(dt.Rows[0]["CheckOut_date"]),
CustomerId = Connection.ToLong(dt.Rows[0]["Customer_Id"]),
IpAddtress = Connection.ToString(dt.Rows[0]["Ip_Address"]),
roomtype_id = Connection.ToString(dt.Rows[0]["RoomId"]),
room_name = Connection.ToString(dt.Rows[0]["RoomName"]),
room_desc = Connection.ToString(dt.Rows[0]["RoomDesc"]),
final_price_at_bookingamt = Connection.ToDecimal(dt.Rows[0]["FinalPriceAtBookingAmt"]),
final_price_at_checkoutamt = Connection.ToDecimal(dt.Rows[0]["FinalPriceAtCheckoutAmt"]),
Response = Connection.ToString(dt.Rows[0]["Response"]),
BookingApiType = Connection.ToInteger(dt.Rows[0]["BookingApi_Type"]),
CreateDate = Connection.ToString(dt.Rows[0]["CreatedDate"]),
Cancellation_Status = Connection.ToInteger(dt.Rows[0]["Cancellaton_Status"])
};
}
return(result);
}
public CLayer.BookingExternalInventory GetExternalBookingInvetoryCanceldetById(long bookinBookingExtInvReqId, string ReservattionId)
{
CLayer.BookingExternalInventory result = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pbookinBookingExtInvReqId", DataPlug.DataType._Varchar, bookinBookingExtInvReqId));
param.Add(Connection.GetParameter("pReservattionId", DataPlug.DataType._Varchar, ReservattionId));
DataTable dt = Connection.GetTable("GetExternalBookingInvetoryCanceldet_ByIdResId", param);
if (dt.Rows.Count > 0)
{
result = new CLayer.BookingExternalInventory()
{
BookingExtInvCancelId = Connection.ToLong(dt.Rows[0]["BookingExtInvCancelId"]),
BookingExtInvReqId = Connection.ToLong(dt.Rows[0]["BookingExtInvReqId"]),
BookingId = Connection.ToLong(dt.Rows[0]["Booking_Id"]),
reservation_id = Connection.ToString(dt.Rows[0]["Reservation_Id"]),
Cancellation_Status = Connection.ToInteger(dt.Rows[0]["Cancellation_Status"]),
Cancelled_Date = Connection.ToString(dt.Rows[0]["Cancelled_Date"]),
Cancellation_Number = Connection.ToString(dt.Rows[0]["Cancellation_Number"])
};
}
return(result);
}
public string CheckBookAvail()
{
//hotelavailability
string Book_Hotel_Avail = StayBazar.Inventory.MaximojoBook.Maximojo_Hotel_Availabilty();
List <CLayer.BookingExternalInventory> DtBookReq = BLayer.BookingExternalInventory.GetExternalInventoryReqDetailsByBookingId(1464);
foreach (CLayer.BookingExternalInventory reqbook in DtBookReq)
{
var Book_Cancelobj1 = new StayBazar.Inventory.Models.MaxBooking_Cancel.RootObject
{
hotel_id = reqbook.hotel_id,
reservation_id = reqbook.reservation_id
};
string ResponseCancel1 = StayBazar.Inventory.MaximojoBook.MaximojoBook_Booking_Cancel(Book_Cancelobj1);
StayBazar.Inventory.Models.MaxBooking_Cancel_Response.RootObject Bookingcanceldetails = JsonConvert.DeserializeObject <StayBazar.Inventory.Models.MaxBooking_Cancel_Response.RootObject>(ResponseCancel1);
//Saving Cancel Details of external booking request
CLayer.BookingExternalInventory bookcandt = new CLayer.BookingExternalInventory();
bookcandt.BookingExtInvReqId = reqbook.BookingExtInvReqId;
bookcandt.BookingId = reqbook.BookingId;
bookcandt.reservation_id = reqbook.reservation_id;
if (Bookingcanceldetails.status == "Success")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.Success;
}
else if (Bookingcanceldetails.status == "AlreadyCancelled")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.AlreadyCancelled;
}
else if (Bookingcanceldetails.status == "CannotBeCancelled")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.CannotBeCancelled;
}
else if (Bookingcanceldetails.status == "UnknownReference")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.UnknownReference;
}
else if (Bookingcanceldetails.status == "Error")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.Error;
}
else
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.none;
}
//UPDATE BOOKING STATUS
int CacelSts = bookcandt.Cancellation_Status;
BLayer.BookingExternalInventory.UpdateCancellationStatus(reqbook.BookingExtInvReqId, CacelSts);
bookcandt.Cancellation_Number = Bookingcanceldetails.cancellation_number;
bookcandt.Cancelled_Date = DateTime.Now.ToString();
bookcandt.Cancellation_Response = ResponseCancel1;
BLayer.BookingExternalInventory.SaveBookingCancelResponse(bookcandt);
}
string ipA = GetIPAddress();
//List<StayBazar.Inventory.BookingAvailibility_Response.HotelroomsDetails> HotelRoomList1 = StayBazar.Inventory.MaximojoBook.BookingAvailDeserializeJsonResponse();
//data for booking submit with Payment details
StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.RootObject dd = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.RootObject();
StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room room1 = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room {
party = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Party {
adults = 2
}, traveler_first_name = "111", traveler_last_name = "30"
};
StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room room2 = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room {
party = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Party {
adults = 2
}, traveler_first_name = "111", traveler_last_name = "30"
};
StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room room3 = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room {
party = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Party {
adults = 2
}, traveler_first_name = "111", traveler_last_name = "30"
};
List <StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room> oList = new List <StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Room>();
oList.Add(room1);
oList.Add(room2);
oList.Add(room3);
var Book_Payobj = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.RootObject
{
checkin_date = "dd",
checkout_date = "dd",
hotel_id = "",
reference_id = "",
ip_address = "",
customer = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.Customer
{
first_name = "ddd",
last_name = "ff",
email = "ff",
phone_number = "ff",
country = "ff"
},
payment_method = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.PaymentMethod
{
billing_address = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.BillingAddress
{
city = "",
country = "",
postal_code = "",
state = "",
street = ""
},
card_number = "",
card_type = "",
cardholder_name = "",
cvv = "",
expiration_month = "",
expiration_year = ""
},
final_price_at_booking = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.FinalPriceAtBooking
{
amount = 0,
currency = "in"
},
final_price_at_checkout = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.FinalPriceAtCheckout
{
amount = 0,
currency = "in"
},
partner_data = new StayBazar.Inventory.Models.MaxBooking_Submit_PayDetails.PartnerData
{
domainId = "",
hotelId = "",
promotionId = "",
ratePlanId = "",
roomTypeId = ""
},
rooms = oList
};
//data for booking submit without Payment details
StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.RootObject dd1 = new Inventory.Models.MaxBooking_Submit_WithoutPaydt.RootObject();
StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room room4 = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room {
party = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Party {
adults = 2
}, traveler_first_name = "111", traveler_last_name = "30"
};
StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room room5 = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room {
party = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Party {
adults = 2
}, traveler_first_name = "111", traveler_last_name = "30"
};
StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room room6 = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room {
party = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Party {
adults = 2
}, traveler_first_name = "111", traveler_last_name = "30"
};
List <StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room> oList1 = new List <StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Room>();
oList1.Add(room4);
oList1.Add(room5);
oList1.Add(room6);
var Book_WihoutPayobj = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.RootObject
{
checkin_date = "dd",
checkout_date = "dd",
hotel_id = "",
reference_id = "",
ip_address = "",
customer = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.Customer
{
first_name = "ddd",
last_name = "ff",
email = "ff",
phone_number = "ff",
country = "ff"
},
final_price_at_booking = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.FinalPriceAtBooking
{
amount = 0,
currency = "in"
},
final_price_at_checkout = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.FinalPriceAtCheckout
{
amount = 0,
currency = "in"
},
partner_data = new StayBazar.Inventory.Models.MaxBooking_Submit_WithoutPaydt.PartnerData
{
DomainId = "",
HotelId = "",
PromotionId = "",
RatePlanId = "",
RoomId = ""
},
rooms = oList1
};
//data for booking cancel
var Book_Cancelobj = new StayBazar.Inventory.Models.MaxBooking_Cancel.RootObject
{
hotel_id = "",
reservation_id = ""
};
//hotelavailability
string Book_Hotel_Avail1 = StayBazar.Inventory.MaximojoBook.Maximojo_Hotel_Availabilty();
//booking available
// List<StayBazar.Inventory.BookingAvailibility_Response.HotelroomsDetails> HotelRoomList = StayBazar.Inventory.MaximojoBook.BookingAvailDeserializeJsonResponse();
//bookingsubmitWithPay
string ResponseBookSubPay = StayBazar.Inventory.MaximojoBook.MaximojoBook_Booking_Submit_paypaldetails(Book_Payobj);
//bookingsubmitWithoutPay
string ResponseBookSub = StayBazar.Inventory.MaximojoBook.MaximojoBook_Booking_Submit_Without_paypaldetails(Book_WihoutPayobj);
//BookingCancel
string ResponseCancel = StayBazar.Inventory.MaximojoBook.MaximojoBook_Booking_Cancel(Book_Cancelobj);
//booking verify
string Hotel_Id = "";
string reference_id = "";
string reservation_id = "";
string Booking_VerifyResponse = StayBazar.Inventory.MaximojoBook.Maximojo_Booking_Verify(Hotel_Id, reference_id, reservation_id);
string kk = "";
return(kk);
}
public static long SaveBookingSubmitResponse(CLayer.BookingExternalInventory data)
{
DataLayer.BookingExternalInventory acc = new DataLayer.BookingExternalInventory();
return(acc.SaveBookingSubmitResponse(data));
}
public ActionResult ExternalBookRequestCancel(long bookingId)
{
try
{
List <CLayer.BookingExternalInventory> DtBookReq = BLayer.BookingExternalInventory.GetExternalInventoryReqDetailsByBookingId(bookingId);
foreach (CLayer.BookingExternalInventory reqbook in DtBookReq)
{
var Book_Cancelobj = new StayBazar.Inventory.Models.MaxBooking_Cancel.RootObject
{
hotel_id = reqbook.hotel_id,
reservation_id = reqbook.reservation_id
};
string ResponseCancel = StayBazar.Inventory.MaximojoBook.MaximojoBook_Booking_Cancel(Book_Cancelobj);
StayBazar.Inventory.Models.MaxBooking_Cancel_Response.RootObject Bookingcanceldetails = JsonConvert.DeserializeObject <StayBazar.Inventory.Models.MaxBooking_Cancel_Response.RootObject>(ResponseCancel);
//Saving Cancel Details of external booking request
CLayer.BookingExternalInventory bookcandt = new CLayer.BookingExternalInventory();
bookcandt.BookingExtInvReqId = reqbook.BookingExtInvReqId;
bookcandt.BookingId = reqbook.BookingId;
bookcandt.reservation_id = reqbook.reservation_id;
if (Bookingcanceldetails.status == "Success")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.Success;
//UPDATE BOOKING EXTERNAL INVENTORY REQUEST STATUS CHANGE
}
else if (Bookingcanceldetails.status == "AlreadyCancelled")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.AlreadyCancelled;
}
else if (Bookingcanceldetails.status == "CannotBeCancelled")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.CannotBeCancelled;
}
else if (Bookingcanceldetails.status == "UnknownReference")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.UnknownReference;
}
else if (Bookingcanceldetails.status == "Error")
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.Error;
}
else
{
bookcandt.Cancellation_Status = (int)CLayer.BookingExternalInventory.CancellationStatus.none;
}
//UPDATE BOOKING STATUS
int CacelSts = bookcandt.Cancellation_Status;
BLayer.BookingExternalInventory.UpdateCancellationStatus(reqbook.BookingExtInvReqId, CacelSts);
bookcandt.Cancellation_Number = Bookingcanceldetails.cancellation_number;
if (Bookingcanceldetails.cancelled_date == null)
{
Bookingcanceldetails.cancelled_date = Convert.ToString(DateTime.Now);
}
bookcandt.Cancelled_Date = Bookingcanceldetails.cancelled_date;
bookcandt.Cancellation_Response = ResponseCancel;
BLayer.BookingExternalInventory.SaveBookingCancelResponse(bookcandt);
}
}
catch (Exception ex)
{
Exception Error = new Exception("#Error from External Booking Request Cancel ,partial payment cancel by task manager (service , ExternalBookRequestCancel) for bookingId :- " + bookingId + " , " + DateTime.Now + " , " + ex);
Common.LogHandler.HandleError(Error);
}
return(null);
}
