public bool Update_Htl_Deals(HotelDealViewModel model)
{
Edit_HTL_Deals(model.HotelDealId, model.UpdatedBy.Value);
HTL_Deals objToUpdate = new HTL_Deals();
objToUpdate = entity.HTL_Deals.Where(x => x.HotelDealId == model.HotelDealId).FirstOrDefault();
objToUpdate.DealMasterId = model.DealMasterId;
objToUpdate.HotelId = model.HotelId;
objToUpdate.DealIdentifier = model.DealIdentifierText;
objToUpdate.MarkupOnPerRoom = model.MarkupOnPerRoom;
objToUpdate.isPercentMarkupOnPerRoom = model.isPercentMarkupOnPerRoom;
objToUpdate.MarkupOnExtraGuestCharge = model.MarkupOnExtraGuestCharge;
objToUpdate.isPercentMarkupOnExtraGuestCharge = model.isPercentMarkupOnExtraGuestCharge;
objToUpdate.CommissionOnPerRoom = model.CommissionOnPerRoom;
objToUpdate.isPercentCommissionOnPerRoom = model.isPercentCommissionOnPerRoom;
objToUpdate.CommissionOnExtraGuestCharge = model.CommissionOnExtraGuestCharge;
objToUpdate.isPercentCommissionOnExtraGuestCharge = model.isPercentCommissionOnExtraGuestCharge;
objToUpdate.CurrencyId = model.CurrencyId;
objToUpdate.UpdatedBy = model.UpdatedBy;
objToUpdate.UpdatedDate = model.UpdatedDate;
entity.ApplyCurrentValues(objToUpdate.EntityKey.EntitySetName, objToUpdate);
entity.SaveChanges();
return(true);
}
public HotelDealViewModel GetDealDetail(int?dealId)
{
List <HotelDealViewModel> dealViewList = new List <HotelDealViewModel>();
List <HTL_Deals> deals = entity.HTL_Deals.Where(xx => xx.HotelDealId == dealId).ToList();
HotelDealViewModel dealViewModel = new HotelDealViewModel();
foreach (HTL_Deals deal in deals)
{
dealViewModel.HotelDealId = deal.HotelDealId;
dealViewModel.DealMasterId = deal.DealMasterId;
dealViewModel.DealMaserText = "";
dealViewModel.HotelId = deal.HotelId;
dealViewModel.HotelName = deal.HTL_Hotels != null ? deal.HTL_Hotels.HotelName : null;
dealViewModel.DealIdentifier = deal.DealIdentifier;
dealViewModel.MarkupOnPerRoom = deal.MarkupOnPerRoom;
dealViewModel.isPercentMarkupOnPerRoom = deal.isPercentMarkupOnPerRoom;
dealViewModel.MarkupOnExtraGuestCharge = deal.MarkupOnExtraGuestCharge;
dealViewModel.isPercentMarkupOnExtraGuestCharge = deal.isPercentMarkupOnExtraGuestCharge;
dealViewModel.CommissionOnPerRoom = deal.CommissionOnPerRoom;
dealViewModel.isPercentCommissionOnPerRoom = deal.isPercentCommissionOnPerRoom;
dealViewModel.CommissionOnExtraGuestCharge = deal.CommissionOnExtraGuestCharge;
dealViewModel.isPercentCommissionOnExtraGuestCharge = deal.isPercentCommissionOnExtraGuestCharge;
dealViewModel.CurrencyId = deal.CurrencyId;
dealViewModel.Currency = deal.Currencies.CurrencyCode;
dealViewModel.MakerId = deal.MakerId;
dealViewModel.MakerDate = deal.MakerDate;
dealViewModel.isVerified = deal.isVerified;
dealViewModel.VerifiedBy = deal.VerifiedBy;
dealViewModel.VerifiedDate = deal.VerifiedDate;
dealViewModel.UpdatedBy = deal.UpdatedBy;
dealViewModel.UpdatedDate = deal.UpdatedDate;
}
return(dealViewModel);
}
public int Save_HTL_Deals(HotelDealViewModel model)
{
HTL_Deals objToSave = new HTL_Deals();
objToSave.DealMasterId = model.DealMasterId;
objToSave.HotelId = model.HotelId;
objToSave.DealIdentifier = model.DealIdentifierText;
objToSave.MarkupOnPerRoom = model.MarkupOnPerRoom;
objToSave.isPercentMarkupOnPerRoom = model.isPercentMarkupOnPerRoom;
objToSave.MarkupOnExtraGuestCharge = model.MarkupOnExtraGuestCharge;
objToSave.isPercentMarkupOnExtraGuestCharge = model.isPercentMarkupOnExtraGuestCharge;
objToSave.CommissionOnPerRoom = model.CommissionOnPerRoom;
objToSave.isPercentCommissionOnPerRoom = model.isPercentCommissionOnPerRoom;
objToSave.CommissionOnExtraGuestCharge = model.CommissionOnExtraGuestCharge;
objToSave.isPercentCommissionOnExtraGuestCharge = model.isPercentCommissionOnExtraGuestCharge;
objToSave.CurrencyId = model.CurrencyId;
objToSave.VersionNo = 1;
objToSave.MakerId = model.MakerId;
objToSave.MakerDate = model.MakerDate;
objToSave.isVerified = model.isVerified;
objToSave.VerifiedBy = model.VerifiedBy;
objToSave.VerifiedDate = model.VerifiedDate;
entity.AddToHTL_Deals(objToSave);
entity.SaveChanges();
return(objToSave.HotelDealId);
}
public ActionResult Index(HotelDealViewModel model)
{
TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"];
model.MakerId = obj.AppUserId;
model.MakerDate = DateTime.Now;
model.isVerified = false;
hotelDealRepository.Update_Htl_Deals(model);
HotelDealViewModel viewmodel = new HotelDealViewModel()
{
CurrencyList = masterDealProvider.GetCurrencyList().Where(x => x.Value == "1"),
HotelList = hotelDealRepository.GetAllHotelList(),
DealMasterList = mDealProvider.GetAllDealMasterList(2),
DealIdentifierList = hotelDealRepository.GetDealIdentifiers(hotelDealRepository.GetDealMasterById(model.DealMasterId, 2).DealTypeId),
DealList = hotelDealRepository.GetAllDeals(model.DealMasterId, null, null, null, null, null, null)
};
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("DisplayDealTemplate", viewmodel));
}
else
{
return(View(viewmodel));
}
}
public IEnumerable <HotelDealViewModel> GetAllDeals(int?dealMasterId, string filterCountryCode, int?filterCategory, int?filterCityId, int?filterHotelId, string filterDealIdentifier, int?filterCurrency)
{
List <HotelDealViewModel> dealViewList = new List <HotelDealViewModel>();
IEnumerable <HTL_Deals> deals = new List <HTL_Deals>();
if (dealMasterId != null)
{
deals = entity.HTL_Deals.Where(xx => xx.DealMasterId == dealMasterId);
}
if (filterHotelId != null)
{
deals = deals.Where(x => x.HotelId == filterHotelId);
}
if (!string.IsNullOrEmpty(filterDealIdentifier))
{
deals = deals.Where(x => x.DealIdentifier == filterDealIdentifier);
}
if (filterCurrency != null)
{
deals = deals.Where(x => x.CurrencyId == filterCurrency);
}
foreach (HTL_Deals deal in deals)
{
HotelDealViewModel dealViewModel = new HotelDealViewModel();
dealViewModel.HotelDealId = deal.HotelDealId;
dealViewModel.DealMasterId = deal.DealMasterId;
dealViewModel.DealMaserText = "";
dealViewModel.HotelId = deal.HotelId;
dealViewModel.HotelName = deal.HTL_Hotels != null ? deal.HTL_Hotels.HotelName : null;
dealViewModel.DealIdentifier = deal.DealIdentifier;
dealViewModel.MarkupOnPerRoom = deal.MarkupOnPerRoom;
dealViewModel.isPercentMarkupOnPerRoom = deal.isPercentMarkupOnPerRoom;
dealViewModel.MarkupOnExtraGuestCharge = deal.MarkupOnExtraGuestCharge;
dealViewModel.isPercentMarkupOnExtraGuestCharge = deal.isPercentMarkupOnExtraGuestCharge;
dealViewModel.CommissionOnPerRoom = deal.CommissionOnPerRoom;
dealViewModel.isPercentCommissionOnPerRoom = deal.isPercentCommissionOnPerRoom;
dealViewModel.CommissionOnExtraGuestCharge = deal.CommissionOnExtraGuestCharge;
dealViewModel.isPercentCommissionOnExtraGuestCharge = deal.isPercentCommissionOnExtraGuestCharge;
dealViewModel.CurrencyId = deal.CurrencyId;
dealViewModel.Currency = deal.Currencies.CurrencyCode;
dealViewModel.MakerId = deal.MakerId;
dealViewModel.MakerDate = deal.MakerDate;
dealViewModel.isVerified = deal.isVerified;
dealViewModel.VerifiedBy = deal.VerifiedBy;
dealViewModel.VerifiedDate = deal.VerifiedDate;
dealViewModel.UpdatedBy = deal.UpdatedBy;
dealViewModel.UpdatedDate = deal.UpdatedDate;
dealViewList.Add(dealViewModel);
}
return(dealViewList.OrderBy(x => x.HotelId));
}
public ActionResult AjaxDealCancel(int id)
{
HotelDealViewModel viewModel = new HotelDealViewModel();
viewModel = hotelDealRepository.GetDealDetail(id);
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("VUC_DealDetail", viewModel));
}
else
{
return(View(viewModel));
}
}
public ActionResult AjaxDealDetail(int id)
{
HotelDealViewModel viewModel = new HotelDealViewModel();
viewModel = hotelDealRepository.GetDealDetail(id);
viewModel.CurrencyList = masterDealProvider.GetCurrencyList().Where(x => x.Value == "1");
viewModel.HotelList = hotelDealRepository.GetAllHotelList();
viewModel.DealMasterList = mDealProvider.GetAllDealMasterList(2);
viewModel.DealIdentifierList = hotelDealRepository.GetDealIdentifiers(hotelDealRepository.GetDealMasterById(viewModel.DealMasterId, 2).DealTypeId);
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("VUC_DealEdit", viewModel));
}
else
{
return(View(viewModel));
}
}
public ActionResult AjaxDealEdit(HotelDealViewModel model)
{
TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"];
model.UpdatedBy = obj.AppUserId;
model.UpdatedDate = DateTime.UtcNow;
hotelDealRepository.Update_Htl_Deals(model);
HotelDealViewModel viewModel = new HotelDealViewModel();
viewModel = hotelDealRepository.GetDealDetail(model.HotelDealId);
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("VUC_DealDetail", viewModel));
}
else
{
return(View(viewModel));
}
}
public ActionResult Create(HotelDealViewModel model)
{
HotelDealViewModel viewmodel = new HotelDealViewModel()
{
CurrencyList = masterDealProvider.GetCurrencyList().Where(x => x.Value == "1"),
HotelList = hotelDealRepository.GetAllHotelList(),
DealMasterList = mDealProvider.GetAllDealMasterList(2),
DealIdentifierList = hotelDealRepository.GetDealIdentifiers(hotelDealRepository.GetDealMasterById(model.DealMasterId, 2).DealTypeId),
DealMaserText = hotelDealRepository.GetDealMasterById(model.DealMasterId, 2).DealName
};
TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"];
model.MakerId = obj.AppUserId;
model.MakerDate = DateTime.UtcNow;
model.isVerified = true;
model.VerifiedBy = obj.AppUserId;
model.VerifiedDate = DateTime.UtcNow;
int dealId = hotelDealRepository.Save_HTL_Deals(model);
HotelDealViewModel viewModel = new HotelDealViewModel();
viewModel = hotelDealRepository.GetDealDetail(dealId);
viewModel.CurrencyList = masterDealProvider.GetCurrencyList().Where(x => x.Value == "1");
viewModel.HotelList = hotelDealRepository.GetAllHotelList();
viewModel.DealMasterList = mDealProvider.GetAllDealMasterList(2);
viewModel.DealIdentifierList = hotelDealRepository.GetDealIdentifiers(hotelDealRepository.GetDealMasterById(model.DealMasterId, 2).DealTypeId);
viewModel.DealMaserText = hotelDealRepository.GetDealMasterById(model.DealMasterId, 2).DealName;
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("VUC_DealDetail", viewModel));
}
else
{
return(View(viewModel));
}
}
public ActionResult Index(int?id, string filterCountryCode, int?filterCategory, int?filterCityId, int?filterHotelId, string filterDealIdentifier, int?filterCurrency)
{
var dealtype = hotelDealRepository.GetDealMasterById(id ?? 0, 2);
HotelDealViewModel viewmodel = new HotelDealViewModel()
{
CurrencyList = masterDealProvider.GetCurrencyList().Where(x => x.Value == "1"),
HotelList = hotelDealRepository.GetAllHotelList(),
DealMasterList = mDealProvider.GetAllDealMasterList(2),
DealIdentifierList = hotelDealRepository.GetDealIdentifiers(dealtype != null ? dealtype.DealTypeId : 0),
DealList = hotelDealRepository.GetAllDeals(id, filterCountryCode, filterCategory, filterCityId, filterHotelId, filterDealIdentifier, filterCurrency)
};
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("VUC_DealDetailList", viewmodel));
}
else
{
return(View(viewmodel));
}
}
public ActionResult Create(int id)
{
HotelDealViewModel viewmodel = new HotelDealViewModel()
{
CurrencyList = masterDealProvider.GetCurrencyList().Where(x => x.Value == "1"),
HotelList = hotelDealRepository.GetAllHotelList(),
DealMasterList = mDealProvider.GetAllDealMasterList(2),
DealIdentifierList = hotelDealRepository.GetDealIdentifiers(hotelDealRepository.GetDealMasterById(id, 2).DealTypeId),
DealMasterId = id,
DealMaserText = hotelDealRepository.GetDealMasterById(id, 2).DealName
};
if (Request != null && Request.IsAjaxRequest())
{
return(PartialView("CreateDealTemplate", viewmodel));
}
else
{
return(View(viewmodel));
}
}
