public static void MapResponseToDB(AvailabilityRes value, string SessionID)
{
try {
HotelBedEntities db = new HotelBedEntities();
AvailabilityResponse availability = new AvailabilityResponse();
availability.Currency = value.hotel.currency;
availability.TotalPrice = value.hotel.totalNet;
availability.response = Newtonsoft.Json.JsonConvert.SerializeObject(value.hotel);
availability.SearchID = SessionID;
var hotel = db.SearchHotelDatas.FirstOrDefault(a => a.SessionID == SessionID);
availability.SearchHotelID = hotel.Id;
db.AvailabilityResponses.Add(availability);
db.SaveChanges();
foreach (var room in value.hotel.rooms)
{
foreach (var rate in room.rates)
{
SearchRoom searchRoom = new SearchRoom();
searchRoom.adults = rate.adults;
searchRoom.boardCode = rate.boardCode;
searchRoom.boardName = rate.boardName;
searchRoom.children = rate.children;
searchRoom.childrenAges = rate.childrenAges;
searchRoom.hotelMandatory = rate.hotelMandatory.ToString();
searchRoom.netPrice = rate.net;
searchRoom.packaging = rate.packaging.ToString();
searchRoom.paymentType = rate.paymentType;
searchRoom.rateClass = rate.rateClass;
searchRoom.rateKey = rate.rateKey;
searchRoom.rateType = rate.rateType;
searchRoom.ResponseType = "availability";
searchRoom.RoomCode = room.code;
searchRoom.RoomName = room.name;
searchRoom.rooms = rate.rooms;
searchRoom.SearchHotelID = availability.ID;
searchRoom.sessionID = SessionID;
searchRoom.sellingRate = rate.sellingRate;
db.SearchRooms.Add(searchRoom);
db.SaveChanges();
foreach (var p in rate.cancellationPolicies)
{
RoomPolicy policy = new RoomPolicy();
policy.amount = p.amount;
policy.fromDate = p.from.ToString();;
policy.RoomID = searchRoom.Id;
policy.CallingType = "check";
db.RoomPolicies.Add(policy);
}
db.SaveChanges();
}
}
}
catch (Exception ex)
{
var requestData = JsonConvert.SerializeObject(ex);
LogData.WriteToFile("c:/HotelsB2C/Logs/HBLogs/AvailabilityException", "AvailabilityException_" + SessionID, "AvailabilityException", requestData);
}
}
public static void MapRequestToDB(HBSearchData value, string SessionID)
{
try
{
HotelBedEntities db = new HotelBedEntities();
SearchRequest search = new SearchRequest();
search.SessionId = SessionID;
search.Req = Newtonsoft.Json.JsonConvert.SerializeObject(value);
db.SearchRequests.Add(search);
db.SaveChanges();
}
catch (Exception ex)
{
var requestData = JsonConvert.SerializeObject(ex);
LogData.WriteToFile("c:/HotelsB2C/Logs/HBLogs/SearchException", "SearchException_" + SessionID, "SearchException", requestData);
}
}
public static void MapRequestToDB(AvailabilityReq value, string SessionID)
{
try
{
HotelBedEntities db = new HotelBedEntities();
foreach (var item in value.rooms)
{
AvailabilityRequest request = new AvailabilityRequest();
request.SessionID = SessionID;
request.rate = item.rateKey;
db.AvailabilityRequests.Add(request);
}
db.SaveChanges();
}
catch (Exception ex)
{
var requestData = JsonConvert.SerializeObject(ex);
LogData.WriteToFile("c:/HotelsB2C/Logs/HBLogs/AvailabilityException", "AvailabilityException_" + SessionID, "AvailabilityException", requestData);
}
}
public static void MapRequestToDB(BookingReq value, string SessionID)
{
try
{
HotelBedEntities db = new HotelBedEntities();
foreach (var item in value.rooms)
{
BookingRequest booking = new BookingRequest();
booking.ClientReference = value.clientReference;
booking.HolderName = value.holder.name;
booking.SurName = value.holder.surname;
booking.session = SessionID;
booking.Roomkey = item.rateKey;
db.BookingRequests.Add(booking);
db.SaveChanges();
foreach (var p in item.paxes)
{
RequestPAX requestPAX = new RequestPAX();
requestPAX.BookingID = booking.id;
requestPAX.Name = p.name;
requestPAX.RID = p.roomId;
requestPAX.SurName = p.surname;
requestPAX.Type = p.type;
db.RequestPAXES.Add(requestPAX);
}
db.SaveChanges();
}
}
catch (Exception ex)
{
var requestData = JsonConvert.SerializeObject(ex);
LogData.WriteToFile("c:/HotelsB2C/Logs/HBLogs/BookingException", "BookingException_" + SessionID, "BookingException", requestData);
}
}
public static void MapResponseToDB(BookingRes value, string SessionID)
{
try {
HotelBedEntities db = new HotelBedEntities();
BookingConfirmation booking = new BookingConfirmation();
booking.cancellationPolicy = value.booking.modificationPolicies.cancellation.ToString();
booking.clientReference = value.booking.clientReference;
booking.CreationData = value.booking.creationDate;
booking.CreationUser = value.booking.creationUser;
booking.Currency = value.booking.currency;
booking.HolderName = value.booking.holder.name;
booking.HolderSurName = value.booking.holder.surname;
booking.invoiceCompany = value.booking.invoiceCompany.company;
booking.invoiceCompanyCode = value.booking.invoiceCompany.code;
booking.modificationPolicy = value.booking.modificationPolicies.modification.ToString();
booking.PendingAmount = value.booking.pendingAmount.ToString();
booking.Reference = value.booking.reference;
booking.RegistrationNumber = value.booking.invoiceCompany.registrationNumber;
booking.SessionID = SessionID;
booking.Status = value.booking.status;
booking.supplier = value.booking.hotel.supplier.name;
booking.totalAmount = value.booking.totalNet.ToString();
booking.response = Newtonsoft.Json.JsonConvert.SerializeObject(value.booking);
var hotel = db.SearchHotelDatas.FirstOrDefault(a => a.SessionID == SessionID);
booking.HotelSearchID = hotel.Id;
db.BookingConfirmations.Add(booking);
db.SaveChanges();
foreach (var item in value.booking.hotel.rooms)
{
foreach (var rate in item.rates)
{
BookingRoom searchRoom = new BookingRoom();
searchRoom.Adult = rate.adults;
searchRoom.rateComments = rate.rateComments;
searchRoom.boardCode = rate.boardCode;
searchRoom.boardName = rate.boardName;
searchRoom.Child = rate.children;
searchRoom.hotelMandatory = rate.hotelMandatory.ToString();
searchRoom.Net = rate.net;
searchRoom.packaging = rate.packaging.ToString();
searchRoom.paymentType = rate.paymentType;
searchRoom.rateClass = rate.rateClass;
searchRoom.rooms = rate.rooms;
searchRoom.code = item.code;
searchRoom.Name = item.name;
searchRoom.rooms = rate.rooms;
searchRoom.BookingID = booking.ID;
searchRoom.SearchId = SessionID;
searchRoom.sellingRate = rate.sellingRate;
db.BookingRooms.Add(searchRoom);
db.SaveChanges();
foreach (var P in item.paxes)
{
Pax pa = new Pax();
pa.Name = P.name;
pa.RoomID = searchRoom.ID;
pa.SurName = P.surname;
pa.type = P.type;
db.Paxes.Add(pa);
}
foreach (var policy in rate.cancellationPolicies)
{
PolicyBooking policyBooking = new PolicyBooking();
policyBooking.Amount = policy.amount;
policyBooking.BookingRoomID = searchRoom.ID;
policyBooking.FromDate = policy.from.ToString();
db.PolicyBookings.Add(policyBooking);
}
db.SaveChanges();
}
}
}
catch (Exception ex)
{
var requestData = JsonConvert.SerializeObject(ex);
LogData.WriteToFile("c:/HotelsB2C/Logs/HBLogs/BookingException", "BookingException_" + SessionID, "BookingException", requestData);
}
}
public static void MapResponseToDB(HotelBedsIntegration.Models.Hotels value, string SessionID)
{
try {
HotelBedEntities db = new HotelBedEntities();
foreach (var item in value.hotels)
{
SearchHotelData searchHotel = new SearchHotelData();
searchHotel.CategoryCode = item.categoryCode;
searchHotel.CategoryName = item.categoryName;
searchHotel.checkIn = value.checkIn;
searchHotel.checkOut = value.checkOut;
searchHotel.Code = item.code;
searchHotel.currency = item.currency;
searchHotel.destinationCode = item.destinationCode;
searchHotel.DestinationName = item.destinationName;
searchHotel.latitude = item.latitude;
searchHotel.longitude = item.longitude;
searchHotel.maxRate = item.maxRate;
searchHotel.minRate = item.minRate;
searchHotel.Name = item.name;
searchHotel.SessionID = SessionID;
searchHotel.total = value.total.ToString();
searchHotel.ZoneCode = item.zoneCode.ToString();
searchHotel.ZoneName = item.zoneName;
searchHotel.Request = Newtonsoft.Json.JsonConvert.SerializeObject(value);
db.SearchHotelDatas.Add(searchHotel);
db.SaveChanges();
foreach (var room in item.rooms)
{
foreach (var rate in room.rates)
{
SearchRoom searchRoom = new SearchRoom();
searchRoom.adults = rate.adults;
searchRoom.allotment = rate.allotment;
searchRoom.boardCode = rate.boardCode;
searchRoom.boardName = rate.boardName;
searchRoom.children = rate.children;
searchRoom.childrenAges = rate.childrenAges;
searchRoom.hotelMandatory = rate.hotelMandatory.ToString();
searchRoom.netPrice = rate.net;
searchRoom.packaging = rate.packaging.ToString();
searchRoom.paymentType = rate.paymentType;
searchRoom.rateClass = rate.rateClass;
searchRoom.rateKey = rate.rateKey;
searchRoom.rateType = rate.rateType;
searchRoom.ResponseType = "search";
searchRoom.RoomCode = room.code;
searchRoom.RoomName = room.name;
searchRoom.rooms = rate.rooms;
searchRoom.SearchHotelID = searchHotel.Id;
searchRoom.sessionID = SessionID;
searchRoom.sellingRate = rate.sellingRate;
db.SearchRooms.Add(searchRoom);
db.SaveChanges();
foreach (var tax in rate.taxes.taxes)
{
RoomTax roomTax = new RoomTax();
roomTax.amount = tax.amount;
roomTax.Currency = tax.currency;
roomTax.RoomId = searchRoom.Id;
roomTax.included = tax.included.ToString();
db.RoomTaxes.Add(roomTax);
}
foreach (var policy in rate.cancellationPolicies)
{
RoomPolicy roomPol = new RoomPolicy();
roomPol.amount = policy.amount;
roomPol.CallingType = "Search";
roomPol.Currency = searchHotel.currency;
roomPol.fromDate = policy.from.ToString();
roomPol.RoomID = searchRoom.Id;
}
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
var requestData = JsonConvert.SerializeObject(ex);
LogData.WriteToFile("c:/HotelsB2C/Logs/HBLogs/SearchException", "SearchException_" + SessionID, "SearchException", requestData);
}
}
