private static void SendSMS(object sender, DoWorkEventArgs e)
{
TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel();
var unSentSMSList = ent.Core_SMSOutboxPool.Where(x => x.StatusMessage != "SENT" & x.SentAttempt <= 3 & x.MobileNumbers.Length > 0 & x.SMSBody.Length > 0).ToList();
string MobileNo = "", _Message = "", AppName = "ArihantHolidays", AppPrimaryId = "", MessageType = "SMS Notification";
foreach (var item in unSentSMSList)
{
MobileNo = item.MobileNumbers.Trim();
_Message = item.SMSBody.Trim();
AppPrimaryId = item.SMSOutBoxPoolId.ToString();
try
{
string pushUrl = System.Configuration.ConfigurationManager.AppSettings["SMSURL"] + "?MobileNo=" + MobileNo + "&Message=" + _Message + "&AppName=" + AppName + "&AppPrimaryId=" + AppPrimaryId + "&MessageType=" + MessageType;
WebClient client = new WebClient();
var x = client.DownloadString(pushUrl);
UpdateStatus(item.SMSOutBoxPoolId, "SENT");
}
catch (Exception ex)
{
UpdateStatus(item.SMSOutBoxPoolId, ex.Message);
}
}
}
private static void UpdateStatus(int id, string StatusMessage)
{
TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel();
TravelPortalEntity.Core_SMSOutboxPool result = ent.Core_SMSOutboxPool.Where(x => x.SMSOutBoxPoolId == id).FirstOrDefault();
result.StatusMessage = StatusMessage;
result.SentTime = DateTime.UtcNow;
result.SentAttempt = result.SentAttempt + 1;
ent.ApplyCurrentValues(result.EntityKey.EntitySetName, result);
ent.SaveChanges();
}
public static void sendEmial(string RecipientsEmail, string CCEmail, string BCCEmail, string Subject, string Body, string BodyFormat, string EmailImportent)
{
int LoggedAgentId = ATLTravelPortal.Repository.GeneralRepository.LoggedAgentId();
int LoggedUserId = ATLTravelPortal.Repository.GeneralRepository.LoggedUserId();
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
var OutPutHTML = new System.Data.Objects.ObjectParameter("OutputHTML", typeof(string));
_ent.CORE_SendEmails(RecipientsEmail, CCEmail, BCCEmail, Subject, Body, BodyFormat, EmailImportent);
}
public static void sendBookingRequest(string Subject, string Body)
{
int LoggedAgentId = ATLTravelPortal.Repository.GeneralRepository.LoggedAgentId();
int LoggedUserId = ATLTravelPortal.Repository.GeneralRepository.LoggedUserId();
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
string emailAdd = _ent.Agents.Where(x => x.AgentId == LoggedAgentId).FirstOrDefault().Email;
_ent.Core_SendEmailForBookingRequest(emailAdd, Subject, Body, "HTL");
}
public IEnumerable <HotelBookingCancelModel> List()
{
int SNo = 1;
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
var result = _ent.Htl_BookingCancelDetail.Where(x => x.IsProcessed == true).OrderByDescending(x => x.CreatedDate);
List <HotelBookingCancelModel> model = new List <HotelBookingCancelModel>();
foreach (var item in result)
{
HotelBookingCancelModel _booking = new HotelBookingCancelModel();
HotelBookingDetailModel _bookingDtl = new HotelBookingDetailModel();
_booking.BookingCancelId = item.BookingCancelId;
_booking.BookingRecordId = item.BookingRecordId.Value;
_booking.CancelStatus = item.CancellationStatus;
_bookingDtl.HotelName = item.Htl_BookingRecord.HotelName;
var obj = item.Htl_BookingRecord.Htl_BookingGuestDetail.Where(x => x.IsLeadGuest = true).FirstOrDefault();
List <GuestDetailModel> _guests = new List <GuestDetailModel>();
GuestDetailModel _guest = new GuestDetailModel();
_guest.Title = obj.Title;
_guest.FirstName = obj.FirstName;
_guest.MiddleName = obj.FirstName;
_guest.LastName = obj.LastName;
_guests.Add(_guest);
_bookingDtl.Guests = _guests.ToArray();
_booking.BookingDetail = _bookingDtl;
_booking.CreatedOn = item.CreatedDate;
_booking.SNo = SNo++;
//BookingReferenceNo = item.BookingReferenceNo,
//CheckInDate = item.CheckInDate,
//CheckOutDate = item.CheckOutDate,
//CreatedBy = item.CreatedBy,
//CreatedDate = item.CreatedOn,
//CurrencyCode = item.CurrencyCode,
//FlightInfo = item.FlightInfo,
//GDSBookingId = item.GDSBookingId,
//GDSID = item.GDSID,
//BookingRecordId = item.BookingRecordId,
//HotelBookingStatus = item.HotelBookingStatus,
//HotelCode = item.HotelCode,
//HotelName = item.HotelName,
//HotelRating = item.HotelRating,
//NoOfNights = item.NoOfNights,
//NoOfRoom = item.NoOfRoom,
//SearchIndex = item.SearchIndex,
//SearchSessionId = item.SearchSessionId,
//SpecialRequest = item.SpecialRequest,
//TotalAmount = item.TotalAmount
model.Add(_booking);
}
return(model.AsEnumerable());
}
public static string sendQuotation(string Email, string Subject, string Body, string Message, bool IsPreview)
{
int LoggedAgentId = ATLTravelPortal.Repository.GeneralRepository.LoggedAgentId();
int LoggedUserId = ATLTravelPortal.Repository.GeneralRepository.LoggedUserId();
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
var OutPutHTML = new System.Data.Objects.ObjectParameter("OutputHTML", typeof(string));
_ent.Core_SendEmailQuatation(LoggedAgentId, Email, Subject, Message, "HTL", Body, IsPreview, LoggedUserId, OutPutHTML);
return(OutPutHTML.Value.ToString());
}
public static string getQutationTemplate()
{
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
var msg = _ent.Core_EmailTemplates.Where(x => x.TamplateFor == "HTL").FirstOrDefault();
if (msg != null)
{
return(msg.HTMLContains);
}
else
{
return("");
}
}
public HotelBookingCancelModel FillCanceledDetail(long?id)
{
HotelBookDetailRepository _dtlRep = new HotelBookDetailRepository();
HotelBookingCancelModel _model = new HotelBookingCancelModel();
HotelMessageModel _msg = new HotelMessageModel();
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
if (id != null)
{
var obj = _ent.Htl_BookingCancelDetail.Where(x => x.BookingCancelId == id).FirstOrDefault();
if (obj != null)
{
_model.BookingDetail = _dtlRep.GetHotelBooking(obj.BookingRecordId);
_model.CancellationCharge = obj.CancellationCharge == null ? 0 : obj.CancellationCharge.Value;
_model.CancelStatus = obj.CancellationStatus;
_model.CreatedOn = obj.CreatedDate;
_model.RefundableAmount = obj.RefundableAmount;
_model.Remark = obj.Remark;
_model.BookingRecordId = id.Value;
_model.BookingCancelId = obj.BookingCancelId;
_model.IsProcessed = obj.IsProcessed == null ? false : obj.IsProcessed.Value;
_msg.ActionMessage = "Success.";
_msg.MsgNumber = 1;
_msg.MsgStatus = false;
_msg.MsgType = 0;
_model.Message = _msg;
}
else
{
_msg.ActionMessage = "Invalid Opetration.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
_model.Message = _msg;
}
}
else
{
_msg.ActionMessage = "Invalid Opetration.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
_model.Message = _msg;
}
return(_model);
}
public IEnumerable <SelectListItem> ddlBusMasterList()
{
TravelPortalEntity.EntityModel ent = new TravelPortalEntity.EntityModel();
var result = ent.Bus_Master.OrderBy(o => o.BusMasterName);
List <SelectListItem> ddlList = new List <SelectListItem>();
ddlList.Add(new SelectListItem {
Text = "--Select--", Value = ""
});
foreach (var item in result)
{
ddlList.Add(new SelectListItem {
Value = item.BusMasterId.ToString(), Text = item.BusMasterName.ToString()
});
}
return(ddlList);
}
public IEnumerable <HotelBookingCancelModel> DistributorPendingList()
{
int SNo = 1;
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
var ts = SessionStore.GetTravelSession();
var result = from a in _ent.Htl_BookingCancelDetail
join c in _ent.Htl_BookingRecord on a.BookingRecordId equals c.BookingRecordId
join b in _ent.Agents on c.AgentId equals b.AgentId
where b.DistributorId == ts.LoginTypeId
select a;
// var result = _ent.Htl_BookingCancelDetail.Where(x => x.IsProcessed == false && x.IsCancilRequest == true).OrderByDescending(x => x.CreatedDate);
List <HotelBookingCancelModel> model = new List <HotelBookingCancelModel>();
foreach (var item in result.Where(x => x.IsProcessed == false && x.IsCancilRequest == true).OrderByDescending(x => x.CreatedDate))
{
HotelBookingCancelModel _booking = new HotelBookingCancelModel();
HotelBookingDetailModel _bookingDtl = new HotelBookingDetailModel();
_booking.BookingCancelId = item.BookingCancelId;
_booking.BookingRecordId = item.BookingRecordId.Value;
_booking.CancelStatus = item.CancellationStatus;
_bookingDtl.HotelName = item.Htl_BookingRecord.HotelName;
var obj = item.Htl_BookingRecord.Htl_BookingGuestDetail.Where(x => x.IsLeadGuest = true).FirstOrDefault();
List <GuestDetailModel> _guests = new List <GuestDetailModel>();
GuestDetailModel _guest = new GuestDetailModel();
_guest.Title = obj.Title;
_guest.FirstName = obj.FirstName;
_guest.MiddleName = obj.MiddleName;
_guest.LastName = obj.LastName;
_guests.Add(_guest);
_bookingDtl.Guests = _guests.ToArray();
_booking.BookingDetail = _bookingDtl;
_booking.CreatedOn = item.CreatedDate;
_booking.SNo = SNo++;
model.Add(_booking);
}
return(model.AsEnumerable());
}
public HotelItinearyModel CancelEmailFormat(long?id)
{
HotelItinearyModel _model = new HotelItinearyModel();
HotelMessageModel _msg = new HotelMessageModel();
if (id != null)
{
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
var obj = _ent.Htl_BookingCancelDetail.Where(x => x.BookingCancelId == id).FirstOrDefault();
if (obj != null)
{
HotelBookRepository _bookRep = new HotelBookRepository();
_model = _bookRep.GetItineary(obj.BookingRecordId);
_model.BookingRecordId = id.Value;
_msg.ActionMessage = "Success.";
_msg.MsgNumber = 1;
_msg.MsgStatus = false;
_msg.MsgType = 1;
}
else
{
_msg.ActionMessage = "Invalid Operation.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
}
}
else
{
_msg.ActionMessage = "Invalid Operation.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
}
_model.Message = _msg;
return(_model);
}
public HotelBookingProcessModel ProcessPendingBooking(long?id)
{
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
int BaseCurrencyId = 0;
int CurrencyCodeId = 0;
string BaseCurrencyCode = System.Configuration.ConfigurationManager.AppSettings["HotelBaseCurrencyCode"];
string CurrencyCode = System.Configuration.ConfigurationManager.AppSettings["HotelCurrencyCode"];
var _BaseCurrencyCode = _ent.Currencies.Where(x => x.CurrencyCode.Trim() == BaseCurrencyCode).FirstOrDefault();
if (_BaseCurrencyCode != null)
{
BaseCurrencyId = _BaseCurrencyCode.CurrencyId == null ? 0 : _BaseCurrencyCode.CurrencyId;
}
var _CurrencyCode = _ent.Currencies.Where(x => x.CurrencyCode.Trim() == CurrencyCode).FirstOrDefault();
if (_CurrencyCode != null)
{
CurrencyCodeId = _CurrencyCode.CurrencyId == null ? 0 : _CurrencyCode.CurrencyId;
}
var _ExchangeRate = _ent.Core_FXRate.Where(x => x.BaseCurrencyID == BaseCurrencyId && x.CurrencyID == CurrencyCodeId).OrderByDescending(x => x.CreatedDate).FirstOrDefault();
decimal ExchangeRate = 1;
if (_ExchangeRate != null)
{
ExchangeRate = (decimal)(_ExchangeRate.ExchangeRate == null ? 1 : _ExchangeRate.ExchangeRate == 0 ? 1 : _ExchangeRate.ExchangeRate);
}
HotelItinearyModel _itmodel = new HotelItinearyModel();
HotelBookingProcessModel _model = new HotelBookingProcessModel();
HotelMessageModel _msg = new HotelMessageModel();
HotelCore.GetHotelBooking.Request _getBookingReq = new HotelCore.GetHotelBooking.Request();
HotelCore.GetHotelBooking.Response _getBookingRes = new HotelCore.GetHotelBooking.Response();
HotelCore.AddHotelBookingDetail.Request _addBookingReq = new HotelCore.AddHotelBookingDetail.Request();
HotelCore.AddHotelBookingDetail.Response _addBookingRes = new HotelCore.AddHotelBookingDetail.Response();
HotelCore.Book.Request _bookingReq = new HotelCore.Book.Request();
HotelCore.API api = new HotelCore.API();
if (id != null)
{
var obj = _ent.Htl_BookingRecord.FirstOrDefault(x => x.BookingRecordId == id && x.IsProcessed == false);
if (obj != null)
{
if (obj.BookingStatusCode.Trim() == "Pending")
{
_getBookingReq.BookingId = obj.GDSBookingId;
_getBookingRes = api.GetHotelBooking(_getBookingReq);
if (_getBookingRes.Status.StatusNumber == 0)
{
if (_getBookingRes.BookingDetail != null)
{
var _bookRecObj = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
_bookRecObj.BookingStatusCode = _getBookingRes.BookingDetail[0].BookingStatus.ToString();
_bookRecObj.BookingReferenceNo = _getBookingRes.BookingDetail[0].BookingRefNo;
_bookRecObj.BookingConformationNo = _getBookingRes.BookingDetail[0].ConfirmationNo;
_bookRecObj.LastCancilationDate = _getBookingRes.BookingDetail[0].LastCancellationDate;
_bookRecObj.BookingStatusCode = _getBookingRes.BookingDetail[0].BookingStatus.ToString();
_bookRecObj.IsGetBookingDetail = true;
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, _bookRecObj);
_ent.SaveChanges();
var _bookingRecord = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
_bookingReq.SessionId = _bookingRecord.SearchSessionId;
_bookingReq.Index = _bookingRecord.SearchIndex;
_bookingReq.CountryName = _bookingRecord.CountryName;
HotelCore.Utility.PaymentInformation pinfo = new HotelCore.Utility.PaymentInformation();
pinfo.Amount = _bookingRecord.TotalChargeableAmount;
_bookingReq.PaymentInfo = pinfo;
List <HotelCore.Utility.Guest> Guest = new List <HotelCore.Utility.Guest>();
var _guest = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == id);
if (_guest != null)
{
if (_guest.Count() > 0)
{
foreach (var item in _guest)
{
HotelCore.Utility.Guest gu = new HotelCore.Utility.Guest();
gu.Age = item.Age;
gu.Addressline1 = item.Address1;
gu.Addressline2 = item.Address2;
gu.Areacode = item.AreaPhCode;
gu.City = item.City;
gu.Country = item.Country;
gu.Countrycode = item.CountryPhCode;
gu.Email = item.Email;
gu.FirstName = item.FirstName;
gu.GuestType = item.GuestType.Trim() == "Child" ? HotelCore.Utility.HotelGuestType.Child : HotelCore.Utility.HotelGuestType.Adult;
gu.LastName = item.LastName;
gu.LeadGuest = item.IsLeadGuest;
gu.MiddleName = item.MiddleName;
gu.Phoneno = item.PhoneNo;
gu.RoomIndex = item.RoomIndex;
gu.State = item.GuestState;
gu.Title = item.Title;
gu.Zipcode = item.ZipCoade;
Guest.Add(gu);
}
}
}
_bookingReq.Guest = Guest.ToArray();
_bookingReq.CreatedOn = CurrentDateTime;
_bookingReq.DisplayExchangeRate = ExchangeRate;
if (_getBookingRes.BookingDetail[0].BookingStatus.ToString() == "Confirmed")
{
_addBookingReq = api.FillAddBookingRequest(1, _getBookingRes, _bookingReq);
_addBookingRes = api.AddHotelBookingDetail(_addBookingReq);
if (_addBookingRes.Status.StatusNumber == 0)
{
var _bookRecObj1 = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
_bookRecObj.AddBookingRefId = _addBookingRes.ReferenceId;
_bookRecObj.IsBookingAdded = true;
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, _bookRecObj1);
_ent.SaveChanges();
}
}
}
}
}
else if ((obj.IsProcessed == false && obj.IsGetBookingDetail == false && obj.BookingStatusCode.Trim() == "Confirmed") || (obj.IsBookingAdded == false))
{
_getBookingReq.BookingId = obj.GDSBookingId;
_getBookingRes = api.GetHotelBooking(_getBookingReq);
if (_getBookingRes.Status.StatusNumber == 0)
{
if (_getBookingRes.BookingDetail != null)
{
var _bookRecObj = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
_bookRecObj.BookingStatusCode = _getBookingRes.BookingDetail[0].BookingStatus.ToString();
_bookRecObj.BookingReferenceNo = _getBookingRes.BookingDetail[0].BookingRefNo;
_bookRecObj.BookingConformationNo = _getBookingRes.BookingDetail[0].ConfirmationNo;
_bookRecObj.LastCancilationDate = _getBookingRes.BookingDetail[0].LastCancellationDate;
_bookRecObj.IsGetBookingDetail = true;
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, _bookRecObj);
_ent.SaveChanges();
var _bookingRecord = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
_bookingReq.SessionId = _bookingRecord.SearchSessionId;
_bookingReq.Index = _bookingRecord.SearchIndex;
_bookingReq.CountryName = _bookingRecord.CountryName;
HotelCore.Utility.PaymentInformation pinfo = new HotelCore.Utility.PaymentInformation();
pinfo.Amount = _bookingRecord.TotalChargeableAmount;
_bookingReq.PaymentInfo = pinfo;
List <HotelCore.Utility.Guest> Guest = new List <HotelCore.Utility.Guest>();
var _guest = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == id);
if (_guest != null)
{
if (_guest.Count() > 0)
{
foreach (var item in _guest)
{
HotelCore.Utility.Guest gu = new HotelCore.Utility.Guest();
gu.Age = item.Age;
gu.Addressline1 = item.Address1;
gu.Addressline2 = item.Address2;
gu.Areacode = item.AreaPhCode;
gu.City = item.City;
gu.Country = item.Country;
gu.Countrycode = item.CountryPhCode;
gu.Email = item.Email;
gu.FirstName = item.FirstName;
gu.GuestType = item.GuestType.Trim() == "Child" ? HotelCore.Utility.HotelGuestType.Child : HotelCore.Utility.HotelGuestType.Adult;
gu.LastName = item.LastName;
gu.LeadGuest = item.IsLeadGuest;
gu.MiddleName = item.MiddleName;
gu.Phoneno = item.PhoneNo;
gu.RoomIndex = item.RoomIndex;
gu.State = item.GuestState;
gu.Title = item.Title;
gu.Zipcode = item.ZipCoade;
Guest.Add(gu);
}
}
}
_bookingReq.Guest = Guest.ToArray();
_bookingReq.CreatedOn = CurrentDateTime;
_bookingReq.DisplayExchangeRate = ExchangeRate;
_addBookingReq = api.FillAddBookingRequest(1, _getBookingRes, _bookingReq);
_addBookingRes = api.AddHotelBookingDetail(_addBookingReq);
if (_addBookingRes.Status.StatusNumber == 0)
{
var _bookRecObj1 = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
_bookRecObj1.AddBookingRefId = _addBookingRes.ReferenceId;
_bookRecObj1.IsBookingAdded = true;
_ent.ApplyCurrentValues(_bookRecObj1.EntityKey.EntitySetName, _bookRecObj1);
_ent.SaveChanges();
}
}
}
}
else if (obj.IsVouchered == false)
{
_getBookingReq.BookingId = obj.GDSBookingId;
_getBookingRes = api.GetHotelBooking(_getBookingReq);
var _bookRecObj1 = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
_bookRecObj1.IsVouchered = _getBookingRes.BookingDetail[0].VoucherStatus;
_bookRecObj1.IsProcessed = _getBookingRes.BookingDetail[0].VoucherStatus;
_ent.ApplyCurrentValues(_bookRecObj1.EntityKey.EntitySetName, _bookRecObj1);
_ent.SaveChanges();
}
}
var _bookRecObj2 = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == id).FirstOrDefault();
if (_bookRecObj2.IsBookingSuccess == true && _bookRecObj2.IsBookingAdded == true && _bookRecObj2.BookingStatusCode == "Confirmed")
{
_bookRecObj2.IsProcessed = true;
_ent.ApplyCurrentValues(_bookRecObj2.EntityKey.EntitySetName, _bookRecObj2);
_ent.SaveChanges();
}
HotelItinearyModel _itinModel = new HotelItinearyModel();
HotelBookRepository _bookRep = new HotelBookRepository();
HotelBookDetailRepository _bookingDtlRep = new HotelBookDetailRepository();
_model.BookingDetail = _bookingDtlRep.GetHotelBooking(id);
_itinModel = _bookRep.GetItineary(id);
_model.Itineary = _itinModel.Itineary;
if (_itinModel.Itineary.BookingStatusDesc == "Confirmed" || _itinModel.Itineary.IsProcessed == true)
{
_msg.ActionMessage = "Booking Success";
_msg.MsgNumber = 1;
_msg.MsgStatus = true;
_msg.MsgType = 0;
_model.Message = _msg;
}
else
{
_msg.ActionMessage = "Booking can not complete try again.";
_msg.MsgNumber = 1001;
_msg.MsgStatus = true;
_msg.MsgType = 2;
_model.Message = _msg;
}
}
else
{
_msg.ActionMessage = "Invalid Operation.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
_model.Message = _msg;
}
return(_model);
}
public IEnumerable <HotelBookingRecordModel> ListDistributorHotelBookingProcess()
{
int SNO = 0;
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
int GDSID = HotelCore.Utility.AppSetting.TBOHotelAPI;
var ts = SessionStore.GetTravelSession();
var result = from a in _ent.Htl_BookingRecord
join b in _ent.Agents on a.AgentId equals b.AgentId
where b.DistributorId == ts.LoginTypeId
select a;
//var result = _ent.Htl_BookingRecord.Where(x => x.IsProcessed == false && x.IsBookingSuccess == true).OrderByDescending(x => x.CreatedOn);
//&& x.GDSID == GDSID && x.AgentId == LoggedAgentId
List <HotelBookingRecordModel> model = new List <HotelBookingRecordModel>();
foreach (var item in result.Where(x => x.IsProcessed == false && x.IsBookingSuccess == true).OrderByDescending(x => x.CreatedOn))
{
SNO = SNO + 1;
HotelBookingRecordModel _booking = new HotelBookingRecordModel
{
SNo = SNO,
AddBookingRefId = item.AddBookingRefId,
AgentId = item.AgentId,
BookingReferenceNo = item.BookingReferenceNo,
CheckInDate = item.CheckInDate,
CheckOutDate = item.CheckOutDate,
CreatedBy = item.CreatedBy,
CreatedDate = item.CreatedOn,
CurrencyCode = item.CurrencyCode,
FlightInfo = item.FlightInfo,
GDSBookingId = item.GDSBookingId,
GDSID = item.GDSID,
BookingRecordId = item.BookingRecordId,
HotelBookingStatus = item.HotelBookingStatus,
HotelCode = item.HotelCode,
HotelName = item.HotelName,
HotelRating = item.HotelRating,
NoOfNights = item.NoOfNights,
NoOfRoom = item.NoOfRoom,
SearchIndex = item.SearchIndex,
SearchSessionId = item.SearchSessionId,
SpecialRequest = item.SpecialRequest,
TotalAmount = item.TotalChargeableAmount
};
List <GuestDetailModel> _liguest = new List <GuestDetailModel>();
var _guestList = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == item.BookingRecordId);
foreach (var items in _guestList)
{
GuestDetailModel _guest = new GuestDetailModel
{
Address1 = items.Address1,
Address2 = items.Address1,
Age = items.Age,
City = items.City,
Country = items.Country,
Email = items.Email,
FirstName = items.FirstName,
GuestState = items.GuestState,
//GuestType = item.GuestType.,
LastName = items.LastName,
MiddleName = items.MiddleName,
PhoneNo = items.PhoneNo,
RoomIndex = items.RoomIndex,
Title = items.Title,
ZipCoade = items.ZipCoade
};
_booking.CountryName = items.Country;
_booking.CityName = items.City;
_booking.GuestName = items.Title + " " + items.FirstName + " " + items.MiddleName + " " + items.LastName;
_liguest.Add(_guest);
}
_booking.GuestDetails = _liguest.AsEnumerable();
model.Add(_booking);
}
return(model.AsEnumerable());
}
public HotelBookingCancelModel GetCancelRequestStatus(long?id)
{
HotelCore.GetHotelChangeRequestStatus.Response _res = new HotelCore.GetHotelChangeRequestStatus.Response();
HotelCore.GetHotelChangeRequestStatus.Request _req = new HotelCore.GetHotelChangeRequestStatus.Request();
HotelBookingCancelModel model = new HotelBookingCancelModel();
HotelMessageModel _msg = new HotelMessageModel();
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
if (id != null)
{
var obj = _ent.Htl_BookingCancelDetail.Where(x => x.BookingCancelId == id).FirstOrDefault();
if (obj != null)
{
using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required))
{
HotelCore.API _api = new HotelCore.API();
_req.ChangeRequestId = Convert.ToInt32(obj.CancellationReqId);
_res = _api.GetHotelChangeRequestStatus(_req);
obj.CancellationCharge = _res.CancellationCharge;
obj.CancellationStatus = _res.ChangeRequestStatus.ToString();
obj.RefundableAmount = _res.RefundedAmount;
_ent.ApplyCurrentValues(obj.EntityKey.EntitySetName, obj);
_ent.SaveChanges();
if (_res.ChangeRequestStatus.ToString() == "Processed")
{
var obj1 = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == obj.BookingRecordId).FirstOrDefault();
obj1.IsCanceled = true;
_ent.ApplyCurrentValues(obj1.EntityKey.EntitySetName, obj1);
_ent.SaveChanges();
}
ts.Complete();
}
if (_res.ChangeRequestStatus.ToString() == "Processed")
{
_msg.ActionMessage = "Cancellation Success.";
_msg.MsgNumber = 1;
_msg.MsgStatus = true;
_msg.MsgType = 0;
model.Message = _msg;
}
else
{
_msg.ActionMessage = "Cancellation is " + _res.ChangeRequestStatus.ToString();
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
model.Message = _msg;
}
HotelBookDetailRepository _dtlRep = new HotelBookDetailRepository();
var obj3 = _ent.Htl_BookingCancelDetail.Where(x => x.BookingCancelId == id).FirstOrDefault();
model.CancellationCharge = obj3.CancellationCharge == null ? 0 : obj3.CancellationCharge.Value;
model.RefundableAmount = obj3.RefundableAmount;
model.CancelStatus = obj3.CancellationStatus;
var BookingRecordId = _ent.Htl_BookingCancelDetail.Where(x => x.BookingCancelId == id).Select(x => x.BookingRecordId).SingleOrDefault();//
model.BookingDetail = _dtlRep.GetHotelBooking(BookingRecordId);
model.CreatedOn = obj3.CreatedDate;
model.Remark = obj3.Remark;
model.IsProcessed = obj3.IsProcessed == null ? false : obj3.IsProcessed.Value;
}
else
{
_msg.ActionMessage = "Invalid operation.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
model.Message = _msg;
}
}
else
{
_msg.ActionMessage = "Invalid operation.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
model.Message = _msg;
}
return(model);
}
public IEnumerable <HotelBookingRecordModel> DistributorList()
{
int Sno = 1;
int no = 1;
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
var ts = SessionStore.GetTravelSession();
var result = from a in _ent.Htl_BookingRecord
join b in _ent.Agents on a.AgentId equals b.AgentId
where b.DistributorId == ts.LoginTypeId && (a.TicketStatusId == 4 || a.IsProcessed == true)
orderby a.CreatedOn descending
select a;
// var result = _ent.Htl_BookingRecord.Where(x => x.IsProcessed == true ).OrderByDescending(x => x.CreatedOn);
List <HotelBookingRecordModel> model = new List <HotelBookingRecordModel>();
foreach (var item in result)
{
HotelBookingRecordModel _booking = new HotelBookingRecordModel
{
AddBookingRefId = item.AddBookingRefId,
AgentId = item.AgentId,
BookingReferenceNo = item.BookingReferenceNo,
CheckInDate = item.CheckInDate,
CheckOutDate = item.CheckOutDate,
CreatedBy = item.CreatedBy,
CreatedDate = item.CreatedOn,
CurrencyCode = item.CurrencyCode,
FlightInfo = item.FlightInfo,
GDSBookingId = item.GDSBookingId,
GDSID = item.GDSID,
BookingRecordId = item.BookingRecordId,
HotelBookingStatus = item.HotelBookingStatus,
HotelCode = item.HotelCode,
HotelName = item.HotelName,
HotelRating = item.HotelRating,
NoOfNights = item.NoOfNights,
NoOfRoom = item.NoOfRoom,
SearchIndex = item.SearchIndex,
SearchSessionId = item.SearchSessionId,
SpecialRequest = item.SpecialRequest,
TotalAmount = item.TotalChargeableAmount,
TicketStatusId = item.TicketStatusId,
TicketStatus = item.TicketStatusId == null ? "NA" : item.TicketStatus.ticketStatusName
};
List <GuestDetailModel> _liguest = new List <GuestDetailModel>();
var _guestList = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == item.BookingRecordId && x.IsLeadGuest == true);
foreach (var items in _guestList)
{
GuestDetailModel _guest = new GuestDetailModel
{
No = no++,
Address1 = items.Address1,
Address2 = items.Address1,
Age = items.Age,
City = items.City,
Country = items.Country,
Email = items.Email,
FirstName = items.FirstName,
GuestState = items.GuestState,
//GuestType = item.GuestType.,
LastName = items.LastName,
MiddleName = items.MiddleName,
PhoneNo = items.PhoneNo,
RoomIndex = items.RoomIndex,
Title = items.Title,
ZipCoade = items.ZipCoade
};
_booking.SNo = Sno++;
_booking.CountryName = items.Country;
_booking.CityName = items.City;
_booking.GuestName = items.Title + " " + items.FirstName + " " + items.MiddleName + " " + items.LastName;
_liguest.Add(_guest);
}
_booking.GuestDetails = _liguest.AsEnumerable();
model.Add(_booking);
}
return(model.AsEnumerable());
}
public HotelBookingDetailModel GetHotelBooking(long?BookingRecordId)
{
HotelCore.GetHotelBooking.Response _res = new HotelCore.GetHotelBooking.Response();
HotelCore.GetHotelBooking.Request _req = new HotelCore.GetHotelBooking.Request();
HotelBookingDetailModel model = new HotelBookingDetailModel();
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
HotelMessageModel _msg = new HotelMessageModel();
if (BookingRecordId != null)
{
var obj = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == BookingRecordId).FirstOrDefault();
if (obj != null)
{
_req.BookingId = obj.GDSBookingId;
HotelCore.API _api = new HotelCore.API();
//_res = _api.GetHotelBooking(_req);
var _bookingDtl = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == BookingRecordId).FirstOrDefault();
Administrator.Models.AgentModel _agent = new Administrator.Models.AgentModel {
AgentName = _bookingDtl.Agents.AgentName,
Address = _bookingDtl.Agents.Address,
PhoneNo = _bookingDtl.Agents.Phone,
AgentId = _bookingDtl.AgentId
};
model.CheckInDate = _bookingDtl.CheckInDate;
model.CheckOutDate = _bookingDtl.CheckOutDate;
model.CityName = _bookingDtl.CityName;
model.CountryName = _bookingDtl.CountryName;
model.CurrencyCode = _bookingDtl.CurrencyCode;
model.Flightinfo = _bookingDtl.FlightInfo;
model.HotelRating = _bookingDtl.HotelRating;
model.HotelImageUrl = _bookingDtl.HotelImageUrl;
model.TotalChargableAmount = _bookingDtl.TotalChargeableAmount;
model.BookingId = _bookingDtl.GDSBookingId;
model.ConfirmationNo = _bookingDtl.BookingConformationNo;
model.ReferenceNo = _bookingDtl.BookingReferenceNo;
model.AgentDetail = _agent;
var _guests = _ent.Htl_BookingGuestDetail.Where(x => x.BookingRecordId == BookingRecordId);
List <GuestDetailModel> _guestList = new List <GuestDetailModel>();
foreach (var item in _guests)
{
GuestDetailModel _guest = new GuestDetailModel();
_guest.Address1 = item.Address1;
_guest.Address2 = item.Address2;
_guest.Age = item.Age;
_guest.City = item.City;
_guest.Country = item.Country;
_guest.Email = item.Email;
_guest.Title = item.Title;
_guest.FirstName = item.FirstName;
_guest.GuestState = item.GuestState;
_guest.GuestType = item.GuestType;
_guest.IsLeadGuest = item.IsLeadGuest;
_guest.LastName = item.LastName;
_guest.MiddleName = item.MiddleName;
_guest.PhoneNo = item.PhoneNo;
_guest.RoomIndex = item.RoomIndex;
_guest.Title = item.Title;
_guest.ZipCoade = item.ZipCoade;
_guestList.Add(_guest);
}
List <HotelCore.Utility.RoomGuestData> _roomGuestList = new List <HotelCore.Utility.RoomGuestData>();
List <int> _childAge = new List <int>();
var _roomDtl = _ent.Htl_BookingRoomDetail.Where(x => x.BookingRecordId == BookingRecordId);
foreach (var item in _roomDtl)
{
HotelCore.Utility.RoomGuestData _roomGuest = new HotelCore.Utility.RoomGuestData();
_roomGuest.NoOfAdults = item.NoOfAdult;
_roomGuest.NoOfChild = item.NoOfChild;
_roomGuest.RoomTypeName = item.RoomTypeName;
_roomGuestList.Add(_roomGuest);
}
var _roomType = _ent.Htl_BookingRoomDetail.Where(x => x.BookingRecordId == BookingRecordId);
List <HotelCore.Utility.HotelRoomsDetails> RoomList = new List <HotelCore.Utility.HotelRoomsDetails>();
var bookingRoomCode = "";
foreach (var item in _roomType)
{
HotelCore.Utility.HotelRoomsDetails room = new HotelCore.Utility.HotelRoomsDetails();
room.RoomTypeName = item.RoomTypeName;
room.NoOfUnits = 1;
bookingRoomCode = item.BookingRoomCode;
var _nightRate = _ent.Htl_BookingNightRate.Where(x => x.BookingRoomCodeId == item.BookingRoomCodeId);
List <HotelCore.Utility.DayRates> _dayRates = new List <HotelCore.Utility.DayRates>();
foreach (var item1 in _nightRate)
{
HotelCore.Utility.DayRates _dayRate = new HotelCore.Utility.DayRates();
_dayRate.Days = item1.BookingDate;
_dayRate.LowRate = item1.BookingRate;
_dayRates.Add(_dayRate);
}
room.DayRates = _dayRates.ToArray();
var _roomRate = _ent.Htl_BookingRoomRate.Where(x => x.BookingRoomCodeId == item.BookingRoomCodeId);
List <HotelCore.Utility.RoomRate> _roomRateList = new List <HotelCore.Utility.RoomRate>();
HotelCore.Utility.RoomRate RoomRate = new HotelCore.Utility.RoomRate();
RoomRate.TotalRoomRate = _roomRate.Where(x => x.Particular == "Total-Rate").FirstOrDefault().Amount;
RoomRate.ExtraGuestCharges = _roomRate.Where(x => x.Particular == "Extra-Guest-Charge").FirstOrDefault().Amount;
RoomRate.TotalRoomTax = _roomRate.Where(x => x.Particular == "Tax").FirstOrDefault().Amount;
RoomRate.ServiceTax = _roomRate.Where(x => x.Particular == "Service-Tax").FirstOrDefault().Amount;
RoomRate.DisCount = _roomRate.Where(x => x.Particular == "Discount").FirstOrDefault().Amount;
RoomRate.TotalTaxesAndFees = RoomRate.TotalRoomTax + RoomRate.ServiceTax;
//RoomRate.AgentServiceCharge = _roomRate.Where(x => x.Particular == "Agent-Service-Charge").FirstOrDefault().Amount;
RoomRate.CommissionExtraGuestCharge = _roomRate.Where(x => x.Particular == "Commission-Extra-Guest-Charge").FirstOrDefault().Amount;
RoomRate.CommissionRatePerRoom = _roomRate.Where(x => x.Particular == "Commission-Rate-Per-Room").FirstOrDefault().Amount;
RoomRate.DiscountExtraGuestCharge = _roomRate.Where(x => x.Particular == "Discount-Extra-Guest-Charge").FirstOrDefault().Amount;
RoomRate.DiscountRatePerRoom = _roomRate.Where(x => x.Particular == "Discount-Rate-Per-Room").FirstOrDefault().Amount;
RoomRate.MarkupExtraGuestCharge = _roomRate.Where(x => x.Particular == "Markup-Extra-Guest-Charge").FirstOrDefault().Amount;
RoomRate.MarkupRatePerRoom = _roomRate.Where(x => x.Particular == "Markup-Rate-Per-Room").FirstOrDefault().Amount;
room.RoomRate = RoomRate;
RoomList.Add(room);
}
model.RoomDetail = RoomList.ToArray();
model.RoomGuest = _roomGuestList.ToArray();
model.Guests = _guestList.ToArray();
model.HotelAddress = _bookingDtl.HotelAddress;
model.HotelEmail = _bookingDtl.HotelEmail;
model.HotelName = _bookingDtl.HotelName;
model.HotelPhoneNo = _bookingDtl.HotelPhone;
model.NoOfRooms = _bookingDtl.NoOfRoom;
model.SpecialRequest = _bookingDtl.SpecialRequest;
model.BookingDetail = _res.BookingDetail;
_msg.ActionMessage = "Success.";
_msg.MsgNumber = 1;
_msg.MsgStatus = false;
_msg.MsgType = 0;
model.Message = _msg;
}
else
{
_msg.ActionMessage = "Invalid Operation.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
model.Message = _msg;
}
}
else
{
_msg.ActionMessage = "Invalid Operation.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
model.Message = _msg;
}
return(model);
}
public HotelBookingCancelModel Cancel(HotelBookingCancelModel model)
{
HotelCore.SendHotelChangeRequest.Response _res = new HotelCore.SendHotelChangeRequest.Response();
HotelCore.SendHotelChangeRequest.Request _req = new HotelCore.SendHotelChangeRequest.Request();
TravelPortalEntity.EntityModel _ent = new TravelPortalEntity.EntityModel();
HotelMessageModel _msg = new HotelMessageModel();
var obj = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == model.BookingRecordId).FirstOrDefault();
//checked null model.BookingRecordId
var _cancelObj = _ent.Htl_BookingCancelDetail.Where(x => x.BookingRecordId == model.BookingRecordId).FirstOrDefault();
if (_cancelObj == null)
{
TravelPortalEntity.Htl_BookingCancelDetail _objCancel = new TravelPortalEntity.Htl_BookingCancelDetail
{
BookingRecordId = model.BookingRecordId,
GDSBookingID = obj.GDSBookingId,
GDSID = obj.GDSID,
GDSSessionID = obj.SearchSessionId,
CreatedBy = LoggedUserId,
CreatedDate = CurrentDateTime,
Remark = model.Remark
};
_ent.AddToHtl_BookingCancelDetail(_objCancel);
_ent.SaveChanges();
model.BookingCancelId = _objCancel.BookingCancelId;
}
else
{
var _cancel1 = _ent.Htl_BookingCancelDetail.Where(x => x.BookingRecordId == model.BookingRecordId).FirstOrDefault();
model.BookingCancelId = _cancel1.BookingCancelId;
_cancel1.ModifiedBy = LoggedUserId;
_cancel1.ModifiedDate = CurrentDateTime;
_ent.ApplyCurrentValues(_cancel1.EntityKey.EntitySetName, _cancel1);
_ent.SaveChanges();
}
_req.BookingId = obj.GDSBookingId;
_req.GDSID = obj.GDSID;
_req.ConfirmationNo = obj.BookingReferenceNo;
_req.Remarks = model.Remark;
_req.Email = obj.RegEmail;
_req.SessionId = obj.SearchSessionId;
HotelCore.API _api = new HotelCore.API();
_res = _api.SendCancelRequest(_req);
_res.ChangeRequestId = _res.ChangeRequestId == null ? "-1" : _res.ChangeRequestId;
if (_res.IsCancilRequest == true)
{
using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required))
{
TravelPortalEntity.EntityModel _ent1 = new TravelPortalEntity.EntityModel();
var _cancel = _ent1.Htl_BookingCancelDetail.Where(x => x.BookingCancelId == model.BookingCancelId).FirstOrDefault();
_cancel.CancellationReqId = _res.ChangeRequestId;
_cancel.GDSSessionID = obj.SearchSessionId;
_cancel.CancellationStatus = _res.ChangeRequestStatus.ToString();
_cancel.IsCancilRequest = _res.IsCancilRequest;
_cancel.IsProcessed = _res.IsProcessed;
_ent.ApplyCurrentValues(_cancel.EntityKey.EntitySetName, _cancel);
_ent.SaveChanges();
if (_res.ChangeRequestStatus.ToString() == "Processed")
{
var _record = _ent.Htl_BookingRecord.Where(x => x.BookingRecordId == model.BookingRecordId).FirstOrDefault();
_record.IsCanceled = true;
_ent.ApplyCurrentValues(_record.EntityKey.EntitySetName, _record);
_ent.SaveChanges();
}
if (_res.ChangeRequestId != null)
{
if (_res.ChangeRequestId != "")
{
if (_res.IsProcessed == true)
{
_ent.Htl_CancelSalesTransaction(UserTerminalId, model.BookingRecordId, LoggedAgentId, LoggedUserId);
}
}
}
ts.Complete();
}
model.CancelRequestId = _res.ChangeRequestId;
HotelBookDetailRepository _dtlRep = new HotelBookDetailRepository();
model.BookingDetail = _dtlRep.GetHotelBooking(model.BookingRecordId);
model.CreatedOn = CurrentDateTime;
if (_res.IsProcessed == true)
{
_msg.ActionMessage = "Cancel Success";
_msg.MsgNumber = 1;
_msg.MsgStatus = true;
_msg.MsgType = 0;
model.Message = _msg;
}
else if (_res.IsCancilRequest == true)
{
_msg.ActionMessage = "Cancelllation is in process";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
model.Message = _msg;
}
}
else
{
_msg.ActionMessage = "Cancelllation Can not success.";
_msg.MsgNumber = 1000;
_msg.MsgStatus = true;
_msg.MsgType = 2;
model.Message = _msg;
}
model.Message = _msg;
return(model);
}
