public PromotionalFareModel GetPromotionalFareCreateModel() { GeneralProvider generalProvider = new GeneralProvider(); PromotionalFareModel model = new PromotionalFareModel(); PromotionalFareSector promotionalFareSector = new PromotionalFareSector(); List <PromotionalFareSegment> segments = new List <PromotionalFareSegment>(); PromotionalFareSegment segment = new PromotionalFareSegment(); var cities = generalProvider.GetAirlineCityList(); segment.FromCityList = cities; segment.ToCityList = cities; segments.Add(segment); promotionalFareSector.PromotionalFareSegment = segments; //promotionalFareSector.CityList = generalProvider.GetAirlineCityList(); promotionalFareSector.AirlinesList = generalProvider.GetInternationAirlinesList(1); var Airlines = generalProvider.GetInternationAirlinesList(1); segment.AirlineList = Airlines; promotionalFareSector.CurrencyList = generalProvider.GetCurrencyList(); model.PromotionalFareSector = promotionalFareSector; return(model); }
public bool EditPromotionalFare(PromotionalFareModel model) { Air_PromotionalFares promotionalFareToEdit = entity.Air_PromotionalFares.Where(x => x.PromotionalFareId == model.PromotionalFareSector.PromotionalFareId).FirstOrDefault(); //promotionalFareToEdit.AirlineId = model.PromotionalFareSector.AirlineId; //promotionalFareToEdit.FromCityId = model.PromotionalFareSector.PromotionalFareSegment.FirstOrDefault().FromCityId; //promotionalFareToEdit.ToCityId = model.PromotionalFareSector.PromotionalFareSegment.LastOrDefault().ToCityId; //promotionalFareToEdit.DepartureDate = model.PromotionalFareSector.PromotionalFareSegment.FirstOrDefault().DepartureDate; //promotionalFareToEdit.ArrivalDate = model.PromotionalFareSector.PromotionalFareSegment.LastOrDefault().ArrivalDate; //promotionalFareToEdit.DepartureTime = model.PromotionalFareSector.PromotionalFareSegment.FirstOrDefault().DepartureDate.Value.TimeOfDay; //promotionalFareToEdit.ArrivalTime = model.PromotionalFareSector.PromotionalFareSegment.LastOrDefault().ArrivalDate.Value.TimeOfDay; //promotionalFareToEdit.TourCode = model.PromotionalFareSector.TourCode; //promotionalFareToEdit.CurrencyId = model.PromotionalFareSector.CurrencyId; //promotionalFareToEdit.BaseFare = (double)model.PromotionalFareSector.BaseFare; //promotionalFareToEdit.OtherCharges = (double)model.PromotionalFareSector.OtherCharges; //promotionalFareToEdit.Class = model.PromotionalFareSector.BICClass; //promotionalFareToEdit.FareBasis = model.PromotionalFareSector.FareBasis; //promotionalFareToEdit.EffectiveFrom = model.PromotionalFareSector.EffectiveFrom; //promotionalFareToEdit.ExpireOn = model.PromotionalFareSector.ExpireOn; //promotionalFareToEdit.NoOfPax = model.PromotionalFareSector.NoOfPax; //promotionalFareToEdit.CreatedBy = 1; //promotionalFareToEdit.CreatedDate = DateTime.UtcNow; //promotionalFareToEdit.isActive = true; entity.ApplyCurrentValues(promotionalFareToEdit.EntityKey.EntitySetName, promotionalFareToEdit); EditPromotionalSegments(model); EditPromotionalFareTaxes(model); entity.SaveChanges(); return(true); }
public ActionResult Create(PromotionalFareModel model) { PromotionalFareSetupProvider promotionalFareSetupProvider = new PromotionalFareSetupProvider(); PromotionalFareModel viewModel = new PromotionalFareModel(); GeneralProvider generalProvider = new GeneralProvider(); try { foreach (var item in model.PromotionalFareSector.PromotionalFareSegment) { item.FromCityList = generalProvider.GetAirlineCityList();; item.ToCityList = generalProvider.GetAirlineCityList();; } viewModel = promotionalFareSetupProvider.GetPromotionalFareSetupCreateModel(); viewModel.PromotionalFareSector.Taxes = model.PromotionalFareSector.Taxes; viewModel.PromotionalFareSector.PromotionalFareSegment = model.PromotionalFareSector.PromotionalFareSegment; promotionalFareSetupProvider.SavePromotionalFare(model); TempData["SuccessMessage"] = "Saved Successfully."; return(View(viewModel)); } catch (Exception ex) { TempData["ActionResponse"] = ex.Message; return(View(viewModel)); } }
public bool SavePromotionalFare(PromotionalFareModel model) { //Save Air_PromotionalFares Air_PromotionalFares promotionalFareToSave = new Air_PromotionalFares { //AirlineId = model.PromotionalFareSector.AirlineId, //FromCityId = model.PromotionalFareSector.PromotionalFareSegment.FirstOrDefault().FromCityId, //ToCityId = model.PromotionalFareSector.PromotionalFareSegment.LastOrDefault().ToCityId, //DepartureDate = model.PromotionalFareSector.PromotionalFareSegment.FirstOrDefault().DepartureDate, //ArrivalDate = model.PromotionalFareSector.PromotionalFareSegment.LastOrDefault().ArrivalDate, //DepartureTime = model.PromotionalFareSector.PromotionalFareSegment.FirstOrDefault().DepartureDate.Value.TimeOfDay, //ArrivalTime = model.PromotionalFareSector.PromotionalFareSegment.LastOrDefault().ArrivalDate.Value.TimeOfDay, //TourCode = model.PromotionalFareSector.TourCode, //CurrencyId = model.PromotionalFareSector.CurrencyId, //BaseFare = (double)model.PromotionalFareSector.BaseFare, //OtherCharges = (double)model.PromotionalFareSector.OtherCharges, //Class = model.PromotionalFareSector.BICClass, //FareBasis = model.PromotionalFareSector.FareBasis, //EffectiveFrom = model.PromotionalFareSector.EffectiveFrom, //ExpireOn = model.PromotionalFareSector.ExpireOn, //NoOfPax = model.PromotionalFareSector.NoOfPax, //CreatedBy = 1, //CreatedDate = DateTime.UtcNow, //isActive = true }; entity.AddToAir_PromotionalFares(promotionalFareToSave); entity.SaveChanges(); SavePromotionalSegments(model, promotionalFareToSave.PromotionalFareId); SavePromotionalFareTaxes(model, promotionalFareToSave.PromotionalFareId); entity.SaveChanges(); return(true); }
public ActionResult Edit(PromotionalFareModel model) { TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"]; model.PromotionalFareSector.CreatedBy = obj.AppUserId; IssueDomesticTicketsModel viewModel = new IssueDomesticTicketsModel(); try { bool isUpdated = false; isUpdated = promotionalFareProvider.UpdatePromotionalFareSegment(model); if (isUpdated) { TempData["SuccessMessage"] = "Record Updated Successfully!"; } return(RedirectToAction("Index")); } catch (Exception ex) { TempData["ActionResponse"] = ex.Message; return(View(viewModel)); } }
//*-******************************************************************************Edit Part***************************************************************************// public PromotionalFareModel GetPromotionalFareSegmentEdit(long id) { var Data = entity.Air_PromotionalFares.Where(x => x.PromotionalFareId == id).FirstOrDefault(); PromotionalFareModel model = new PromotionalFareModel(); PromotionalFareSector single = new PromotionalFareSector() { PromotionalFareId = Data.PromotionalFareId, BaseFare = Data.BaseFare, FareRule = Data.FareRules != null ? Data.FareRules : string.Empty, EffectiveFrom = Data.EffectiveFrom.Date, ExpireOn = Data.ExpireOn.Date, Status = Data.isActive, TotalSeatQuota = Data.Qutota, Note = Data.Notes, PromotionalFareSegment = GetPromotionalFareSegmentList(id), Taxes = GetPromotionalFareTaxesList(id), Currency = Data.Currencies.CurrencyCode, CurrencyId = Data.CurrencyId, CurrencyList = new SelectList(GetAllCurrencyList(), "CurrencyId", "CurrencyCode", Data.CurrencyId) }; model.PromotionalFareSector = single; return(model); }
public ActionResult Edit(long PromotionalfareId) { PromotionalFareModel model = new PromotionalFareModel(); model = promotionalFareProvider.GetPromotionalFareSegmentEdit(PromotionalfareId); return(View(model)); }
public void EditPromotionalFareTaxes(PromotionalFareModel model) { foreach (PromotionalFareTaxes tax in model.PromotionalFareSector.Taxes) { Air_PromotionalFareTaxes promotionalFareTaxToEdit = entity.Air_PromotionalFareTaxes.Where(x => x.PromotionalFareTaxId == tax.PromotionalFareTaxId).FirstOrDefault(); promotionalFareTaxToEdit.PromotionalFareTaxId = tax.PromotionalFareTaxId; promotionalFareTaxToEdit.PromotionalFareId = model.PromotionalFareSector.PromotionalFareId; promotionalFareTaxToEdit.TaxName = tax.TaxName; promotionalFareTaxToEdit.TaxAmount = (double)tax.TaxAmount; entity.ApplyCurrentValues(promotionalFareTaxToEdit.EntityKey.EntitySetName, promotionalFareTaxToEdit); } }
public void SavePromotionalFareTaxes(PromotionalFareModel model, Int64 promotionalFareId) { //Save Air_PromotionalFareTaxes foreach (var tax in model.PromotionalFareSector.Taxes) { Air_PromotionalFareTaxes promotionalFareTaxes = new Air_PromotionalFareTaxes() { PromotionalFareId = promotionalFareId, TaxName = tax.TaxName, TaxAmount = (double)tax.TaxAmount }; entity.AddToAir_PromotionalFareTaxes(promotionalFareTaxes); } }
public ActionResult Create() { PromotionalFareProvider promotionalFareProvider = new PromotionalFareProvider(); PromotionalFareModel model = new PromotionalFareModel(); try { model = promotionalFareProvider.GetPromotionalFareCreateModel(); return(View(model)); } catch (Exception ex) { TempData["ActionResponse"] = ex.Message; return(View(model)); } }
public void EditPromotionalSegments(PromotionalFareModel model) { foreach (PromotionalFareSegment segment in model.PromotionalFareSector.PromotionalFareSegment) { Air_PromotionalFareSegments promotionalFareSegmentsToEdit = entity.Air_PromotionalFareSegments.Where(x => x.PromotionalFareSegmentId == segment.PromotionalFareSegmentId).FirstOrDefault(); //promotionalFareSegmentsToEdit.PromotionalFareSegmentId = segment.PromotionalFareSegmentId; //promotionalFareSegmentsToEdit.PromotionalFareId = model.PromotionalFareSector.PromotionalFareId; //promotionalFareSegmentsToEdit.FromCityId = segment.FromCityId; //promotionalFareSegmentsToEdit.ToCityId = segment.ToCityId; //promotionalFareSegmentsToEdit.DepartureDate = segment.DepartureDate; //promotionalFareSegmentsToEdit.DepartureTime = segment.DepartureDate.Value.TimeOfDay; //promotionalFareSegmentsToEdit.ArrivalDate = segment.ArrivalDate; //promotionalFareSegmentsToEdit.ArrivalTime = segment.ArrivalDate.Value.TimeOfDay; //promotionalFareSegmentsToEdit.FlightNo = segment.FlightNo; entity.ApplyCurrentValues(promotionalFareSegmentsToEdit.EntityKey.EntitySetName, promotionalFareSegmentsToEdit); } }
public void SavePromotionalSegments(PromotionalFareModel model, Int64 promotionalFareId) { //Save Air_PromotionalFareSegments foreach (var segment in model.PromotionalFareSector.PromotionalFareSegment) { Air_PromotionalFareSegments promotionalFareSegmentsToSave = new Air_PromotionalFareSegments() { //PromotionalFareId = promotionalFareId, //FromCityId = segment.FromCityId, //ToCityId = segment.ToCityId, //DepartureDate = segment.DepartureDate, //DepartureTime = segment.DepartureTime, //ArrivalDate = segment.ArrivalDate, //ArrivalTime = segment.ArrivalTime, //FlightNo = segment.FlightNo }; entity.AddToAir_PromotionalFareSegments(promotionalFareSegmentsToSave); } }
public EntityCollection <Air_PromotionalFareTaxes> SaveTax(PromotionalFareModel model) { EntityCollection <Air_PromotionalFareTaxes> segment = new EntityCollection <Air_PromotionalFareTaxes>(); //List<Air_PromotionalFareSegments> collection = new List<Air_PromotionalFareSegments>(); foreach (var item in model.PromotionalFareSector.Taxes) { Air_PromotionalFareTaxes single = new Air_PromotionalFareTaxes() { PromotionalFareId = item.PromotionalFareId, TaxName = item.TaxName, TaxAmount = item.TaxAmount }; segment.Add(single); } return(segment); }
public bool UpdatePromotionalFareSegment(PromotionalFareModel model) { var Data = entity.Air_PromotionalFares.Where(x => x.PromotionalFareId == model.PromotionalFareSector.PromotionalFareId).FirstOrDefault(); Data.CurrencyId = model.PromotionalFareSector.CurrencyId; Data.BaseFare = model.PromotionalFareSector.BaseFare ?? 0; Data.FareRules = model.PromotionalFareSector.FareRule != null ? model.PromotionalFareSector.FareRule : string.Empty; Data.isActive = model.PromotionalFareSector.Status; Data.EffectiveFrom = model.PromotionalFareSector.EffectiveFrom.Value; Data.ExpireOn = model.PromotionalFareSector.ExpireOn.Value; Data.UpdatedBy = model.PromotionalFareSector.CreatedBy; Data.Notes = model.PromotionalFareSector.Note; Data.Qutota = model.PromotionalFareSector.TotalSeatQuota; Data.UpdatedDate = DateTime.Now; int i = 0; foreach (var item in Data.Air_PromotionalFareSegments) { item.FromCityId = model.PromotionalFareSector.PromotionalFareSegment[i].FromCityId; item.ToCityId = model.PromotionalFareSector.PromotionalFareSegment[i].ToCityId; item.AirlineId = model.PromotionalFareSector.PromotionalFareSegment[i].AirlineId; item.DepartureTime = model.PromotionalFareSector.PromotionalFareSegment[i].DepartureTime; item.ArrivalTime = model.PromotionalFareSector.PromotionalFareSegment[i].ArrivalTime; item.Class = model.PromotionalFareSector.PromotionalFareSegment[i].Class; item.FlightNo = model.PromotionalFareSector.PromotionalFareSegment[i].FlightNo; i++; } i = 0; foreach (var item in Data.Air_PromotionalFareTaxes) { item.TaxAmount = model.PromotionalFareSector.Taxes[i].TaxAmount; item.TaxName = model.PromotionalFareSector.Taxes[i].TaxName; i++; } entity.ApplyCurrentValues(Data.EntityKey.EntitySetName, Data); entity.SaveChanges(); return(true); }
//***************************************************************************************************Save Part*************************************************************// public void Save(PromotionalFareModel model) { Air_PromotionalFares ObjToSave = new Air_PromotionalFares() { CurrencyId = model.PromotionalFareSector.CurrencyId, BaseFare = Convert.ToDouble(model.PromotionalFareSector.BaseFare), FareRules = model.PromotionalFareSector.FareRule != null ? model.PromotionalFareSector.FareRule : string.Empty, isActive = model.PromotionalFareSector.Status, EffectiveFrom = model.PromotionalFareSector.EffectiveFrom.Value, ExpireOn = model.PromotionalFareSector.ExpireOn.Value, CreatedBy = model.PromotionalFareSector.CreatedBy, Notes = model.PromotionalFareSector.Note, Qutota = model.PromotionalFareSector.TotalSeatQuota, CreatedDate = DateTime.UtcNow, Air_PromotionalFareSegments = SaveSegments(model), Air_PromotionalFareTaxes = SaveTax(model) }; entity.AddToAir_PromotionalFares(ObjToSave); entity.SaveChanges(); }
public ActionResult Create(PromotionalFareModel model) { PromotionalFareProvider promotionalFareProvider = new PromotionalFareProvider(); PromotionalFareModel viewModel = new PromotionalFareModel(); GeneralProvider generalProvider = new GeneralProvider(); TravelSession obj = (TravelSession)Session["TravelPortalSessionInfo"]; try { model.PromotionalFareSector.CreatedBy = obj.AppUserId; promotionalFareProvider.Save(model); model = promotionalFareProvider.GetPromotionalFareCreateModel(); TempData["SuccessMessage"] = "Record Saved Successfully!"; return(RedirectToAction("Index")); } catch { TempData["ActionResponse"] = "Unsuccessful to Save"; model = promotionalFareProvider.GetPromotionalFareCreateModel(); return(View(model)); } }
public ActionResult Edit(PromotionalFareModel model) { PromotionalFareSetupProvider promotionalFareSetupProvider = new PromotionalFareSetupProvider(); PromotionalFareModel viewModel = new PromotionalFareModel(); try { promotionalFareSetupProvider.EditPromotionalFare(model); viewModel = promotionalFareSetupProvider.GetPromotionalFareSetupEditModel(model.PromotionalFareSector.PromotionalFareId); // viewModel.PromotionalFareSector.Taxes = model.PromotionalFareSector.Taxes; // viewModel.PromotionalFareSector.PromotionalFareSegment = model.PromotionalFareSector.PromotionalFareSegment; TempData["SuccessMessage"] = "Edited Successfully."; return(View(viewModel)); } catch (Exception ex) { TempData["ActionResponse"] = ex.Message; return(View(viewModel)); } }
public EntityCollection <Air_PromotionalFareSegments> SaveSegments(PromotionalFareModel model) { EntityCollection <Air_PromotionalFareSegments> segment = new EntityCollection <Air_PromotionalFareSegments>(); List <Air_PromotionalFareSegments> collection = new List <Air_PromotionalFareSegments>(); foreach (var item in model.PromotionalFareSector.PromotionalFareSegment) { Air_PromotionalFareSegments single = new Air_PromotionalFareSegments() { PromotionalFareId = item.PromotionalFareId, ToCityId = item.ToCityId, FromCityId = item.FromCityId, AirlineId = item.AirlineId, Class = item.Class, DepartureTime = item.DepartureTime, ArrivalTime = item.ArrivalTime, FlightNo = item.FlightNo }; collection.Add(single); segment.Add(single); } return(segment); }
public PromotionalFareModel GetPromotionalFareSetupEditModel(Int64 promotionalFareId) { GeneralProvider generalProvider = new GeneralProvider(); PromotionalFareModel model = new PromotionalFareModel(); PromotionalFareSector promotionalFareSector = new PromotionalFareSector(); Air_PromotionalFares promotionalFares = entity.Air_PromotionalFares.Where(x => x.PromotionalFareId == promotionalFareId).FirstOrDefault(); if (promotionalFares != null) { // promotionalFareSector.CityList = generalProvider.GetAirlineCityList(); //promotionalFareSector.AirlinesList = generalProvider.GetInternationAirlinesList(1); //promotionalFareSector.CurrencyList = generalProvider.GetCurrencyList(); //promotionalFareSector.PromotionalFareId = promotionalFares.PromotionalFareId; //promotionalFareSector.AirlineId = promotionalFares.AirlineId; //promotionalFareSector.TourCode = promotionalFares.TourCode; //promotionalFareSector.CurrencyId = promotionalFares.CurrencyId; //promotionalFareSector.BICClass = promotionalFares.Class; //promotionalFareSector.FareBasis = promotionalFares.FareBasis; //promotionalFareSector.EffectiveFrom = promotionalFares.EffectiveFrom; //promotionalFareSector.ExpireOn = promotionalFares.ExpireOn; //promotionalFareSector.NoOfPax = promotionalFares.NoOfPax; //promotionalFareSector.BaseFare = (decimal)promotionalFares.BaseFare; //promotionalFareSector.OtherCharges = (decimal)promotionalFares.OtherCharges; //promotionalFareSector.NoOfPax = promotionalFares.NoOfPax; var taxes = promotionalFares.Air_PromotionalFareTaxes; List <PromotionalFareTaxes> promotionalFareTaxesList = new List <PromotionalFareTaxes>(); foreach (var tax in taxes) { PromotionalFareTaxes promotionalFareTaxes = new PromotionalFareTaxes() { PromotionalFareId = tax.PromotionalFareId, PromotionalFareTaxId = tax.PromotionalFareTaxId, TaxName = tax.TaxName, TaxAmount = tax.TaxAmount }; promotionalFareTaxesList.Add(promotionalFareTaxes); } promotionalFareSector.Taxes = promotionalFareTaxesList; var segments = promotionalFares.Air_PromotionalFareSegments; List <PromotionalFareSegment> promotionalFareSegmentList = new List <PromotionalFareSegment>(); foreach (var segment in segments) { PromotionalFareSegment promotionalFareSegment = new PromotionalFareSegment() { //PromotionalFareId = segment.PromotionalFareId, //PromotionalFareSegmentId = segment.PromotionalFareSegmentId, //FromCity = entity.Air_PromotionalFares.Where(x =>x.FromCityId== segment.FromCityId).Select(x=>x.AirlineCities.CityCode).FirstOrDefault(), //ToCity = entity.Air_PromotionalFares.Where(x => x.ToCityId == segment.ToCityId).Select(x => x.AirlineCities1.CityCode).FirstOrDefault(), //FromCityId = segment.FromCityId, //ToCityId = segment.ToCityId, //DepartureDate = segment.DepartureDate, //DepartureTime = segment.DepartureTime, //ArrivalDate = segment.ArrivalDate, //ArrivalTime = segment.ArrivalTime, //FlightNo = segment.FlightNo, //FromCityList=new SelectList( generalProvider.GetAirlineCityList(),"Value","Text",segment.FromCityId), //ToCityList = new SelectList(generalProvider.GetAirlineCityList(), "Value", "Text", segment.ToCityId) }; promotionalFareSegmentList.Add(promotionalFareSegment); } promotionalFareSector.PromotionalFareSegment = promotionalFareSegmentList; } model.PromotionalFareSector = promotionalFareSector; return(model); }