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);
}
