public void DeleteFare(int PaperFareId)
{
PaperFareRules obj = ent.PaperFareRules.Where(x => x.PaperFareId == PaperFareId).FirstOrDefault();
ent.DeleteObject(obj);
ent.SaveChanges();
}
public void EditPaperFlightFareRule(PaperFareRules obj)
{
var res = ent.PaperFareRules.Where(x => x.PaperFareId == obj.PaperFareId).FirstOrDefault();
ent.ApplyCurrentValues(res.EntityKey.EntitySetName, obj);
ent.SaveChanges();
}
public bool IfPaperFareExist(int AirlineId, int FlightClassId, DateTime From, int DepartureCity, int DestinationCity)
{
PaperFareRules result = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId && x.FlightClassId == FlightClassId && x.DepartureCityId == DepartureCity && x.DestinationCityId == DestinationCity && x.EffectiveFrom == From).FirstOrDefault();
if (result == null)
{
return(true);
}
else
{
return(false);
}
}
public bool CheckClassNameExist(int AirlineId, int FlightClassId, int DepartureCityId, int DestinationCityId)
{
// PaperFareRules result = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId && x.FlightClassId == FlightClassId && x.DepartureCityId==DepartureCityId && x.DestinationCityId == DestinationCityId).FirstOrDefault();
PaperFareRules result = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId).Where(x => x.FlightClassId == FlightClassId).Where(x => x.DepartureCityId == DepartureCityId).Where(x => x.DestinationCityId == DestinationCityId).FirstOrDefault();
if (result == null)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult Edit(int id)
{
SetValueForDropdownlist();
PaperFareRules item = new PaperFareRules();
DefaultPaperFareRules defaultPaperFairRule = new DefaultPaperFareRules();
item = _tfareprovider.GetPaperFlightFareRuleById(id);
defaultPaperFairRule = _tfareprovider.GetDefaultPaperFairRule();
TravelFareModel model = new TravelFareModel();
model.PaperFareId = item.PaperFareId;
model.AirlineId = item.AirlineId;
model.FlightSeasonId = item.FlightSeasonId;
model.DepartureCityId = item.DepartureCityId;
model.DestinationCityId = item.DestinationCityId;
model.FlightClassId = item.FlightClassId;
model.OneWayFareBasis = item.OneWayFareBasis;
model.OneWayFare = item.OneWayFare;
model.GoingFare = item.RoundWayGoing;
model.RoundWayFare = item.RoundWayReturn;
model.FuelCharge = item.FC;
model.RoundWayFareBasis = item.RoundWayFareBasis;
model.TotalRoundTripFare = item.RoundWayFare;
model.EffectiveFrom = item.EffectiveFrom;
model.ExpireOn = item.ExpireOn;
model.FlightTypeId = item.FlightTypeId;
model.ChildFare = item.ChildFare;
model.ChildFareUSD = item.ChildFareUSD;
model.ChildFareType = item.ChildFareType;
model.ChildFareOn = item.ChildFareOn;
model.InfantFare = item.InfantFare;
model.InfantFareUSD = item.InfantFareUSD;
model.InfantFareType = item.InfantFareType;
model.InfantFareOn = item.InfantFareOn;
model.RefundFee = item.RefundFee;
model.RefundFeeDollar = item.RefundFeeUSD;
model.ReissueFee = item.ReissueFee;
model.ReissueFeeDollar = item.ReissueFeeUSD;
model.TermsAndConditions = defaultPaperFairRule.TermsAndConditions;
model.RoundWayGoingUSD = item.RoundWayGoingUSD;
model.OneWayFareUSD = item.OneWayFareUSD;
model.RoundWayReturnUSD = item.RoundWayReturnUSD;
model.RoundWayFareUSD = item.RoundWayFareUSD;
model.ValidTillFurtherNotice = Convert.ToBoolean(item.ValidUntilNextNotic);
model.TourCode = item.TourCode;
return(View(model));
}
public ActionResult Details(int id)
{
PaperFareRules item = new PaperFareRules();
item = _tfareprovider.GetPaperFlightFareRuleById(id);
TravelFareModel model = new TravelFareModel();
model.PaperFareId = item.PaperFareId;
model.AirlineNmae = item.Airlines.AirlineName;
model.FlightSeasonName = item.FlightSeasons.FlightSeasonName;
model.DepartureCityName = _provider.GetCityName(item.DepartureCityId);
model.DestinationCityName = _provider.GetCityName(item.DestinationCityId);
//model.DepartureCityName = item.AirlineCities.CityName;
//model.DepartureCityName = item.AirlineCities.CityName;
// model.FlightClassName = item.FlightClasses.ClassName;
model.OneWayFareBasis = item.OneWayFareBasis;
model.OneWayFare = item.OneWayFare;
model.RoundWayFareBasis = item.RoundWayFareBasis;
model.GoingFare = item.RoundWayGoing;
model.RoundWayFare = item.RoundWayReturn;
model.EffectiveFrom = item.EffectiveFrom;
model.ExpireOn = item.ExpireOn;
model.FlightTypes = item.FlightTypes.FlightTypeName;
model.ChildFare = item.ChildFare;
model.ChildFareType = item.ChildFareType;
model.ChildFareOn = item.ChildFareOn;
model.InfantFare = item.InfantFare;
model.InfantFareType = item.InfantFareType;
model.InfantFareOn = item.InfantFareOn;
model.RefundFee = item.RefundFee;
model.ReissueFee = item.ReissueFee;
model.TermsAndConditions = item.TermsAndConditions;
model.TourCode = item.TourCode;
model.FuelCharge = item.FC;
model.TotalRoundTripFare = item.RoundWayFare;
model.RoundWayGoingUSD = item.RoundWayGoingUSD;
model.OneWayFareUSD = item.OneWayFareUSD;
model.RoundWayReturnUSD = item.RoundWayReturnUSD;
model.RoundWayFareUSD = item.RoundWayFareUSD;
model.ValidTillFurtherNotice = Convert.ToBoolean(item.ValidUntilNextNotic);
return(View(model));
}
public ActionResult Create()
{
SetValueForDropdownlist();
DefaultPaperFareRules defaultPaperFairRule = new DefaultPaperFareRules();
defaultPaperFairRule = _tfareprovider.GetDefaultPaperFairRule();
PaperFareRules rule = new PaperFareRules();
TravelFareModel model = new TravelFareModel();
model.TermsAndConditions = defaultPaperFairRule.TermsAndConditions;
model.ChildFareType = defaultPaperFairRule.ChildFareType;
model.ChildFareOn = defaultPaperFairRule.ChildFareOn;
model.ChildFare = defaultPaperFairRule.ChildFare;
model.InfantFare = defaultPaperFairRule.InfantFare;
model.InfantFareOn = defaultPaperFairRule.InfantFareOn;
model.InfantFareType = defaultPaperFairRule.InfantFareType;
TempData["Error"] = " ";
return(View(model));
}
public bool CheckPaperFareExist(int AirlineId, int FlightClassId, DateTime From, DateTime ExpireOn, int DepartureCity, int DestinationCity)
{
//PaperFareRules result = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId).Where(x => x.FlightClassId == FlightClassId).Where(x => x.EffectiveFrom >= From).Where(x => x.ExpireOn <= ExpireOn).Where(x=>x.DepartureCityId==DepartureCity).Where(x=>x.DestinationCityId == DestinationCity).FirstOrDefault() ;
PaperFareRules result = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId).Where(x => x.FlightClassId == FlightClassId).Where(x => x.DepartureCityId == DepartureCity).Where(x => x.DestinationCityId == DestinationCity).Where(x => x.EffectiveFrom <= From && x.ExpireOn >= From).FirstOrDefault();
PaperFareRules item = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId).Where(x => x.FlightClassId == FlightClassId).Where(x => x.DepartureCityId == DepartureCity).Where(x => x.DestinationCityId == DestinationCity).Where(x => x.ExpireOn >= ExpireOn && x.EffectiveFrom <= ExpireOn).FirstOrDefault();
if (result == null && item == null)
{
PaperFareRules check = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId).Where(x => x.FlightClassId == FlightClassId).Where(x => x.DepartureCityId == DepartureCity).Where(x => x.DestinationCityId == DestinationCity).Where(x => x.EffectiveFrom >= From && x.ExpireOn >= From && x.ExpireOn <= ExpireOn).FirstOrDefault();
if (check == null)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public void SavePaperFareRule(PaperFareRules obj)
{
ent.AddToPaperFareRules(obj);
ent.SaveChanges();
}
public ActionResult Create(TravelFareModel model, FormCollection collection)
{
DefaultPaperFareRules defaultPaperFairRule = new DefaultPaperFareRules();
var ts = (TravelSession)Session["TravelPortalSessionInfo"];
model.TermsAndConditions = defaultPaperFairRule.TermsAndConditions;
SetValueForDropdownlist();
bool checkPaperFare = true;
if (model.DepartureCityId == model.DestinationCityId)
{
ModelState.AddModelError("City", "Please Review the Cities");
TempData["City"] = "please Review the cities";
}
if (model.ExpireOn == null)
{
checkPaperFare = _tfareprovider.IfPaperFareExist(model.AirlineId, model.FlightClassId, model.EffectiveFrom, model.DepartureCityId, model.DepartureCityId);
}
else
{
checkPaperFare = _tfareprovider.CheckPaperFareExist(model.AirlineId, model.FlightClassId, model.EffectiveFrom, Convert.ToDateTime(model.ExpireOn), model.DepartureCityId, model.DestinationCityId);
}
bool checkClassName = _tfareprovider.CheckClassNameExist(model.AirlineId, model.FlightClassId, model.DepartureCityId, model.DestinationCityId);
if (checkPaperFare == false)
{
TempData["Error"] = "Fare already exists";
ModelState.AddModelError("Fare", "Unable to Save the values");
}
else if (checkClassName == true)
{
SetValueForDropdownlist();
PaperFareRules _obj = new PaperFareRules();
_obj.AirlineId = model.AirlineId;
_obj.FlightSeasonId = model.FlightSeasonId;
_obj.DepartureCityId = model.DepartureCityId;
_obj.DestinationCityId = model.DestinationCityId;
_obj.FlightClassId = model.FlightClassId;
//_obj.OneWayFareBasis = "sda";//
_obj.OneWayFareBasis = model.OneWayFareBasis;
_obj.OneWayFare = model.OneWayFare;
_obj.RoundWayGoing = model.GoingFare;
//_obj.RoundWayFareBasis = "sad"; //model.RoundWayFareBasis;
_obj.RoundWayFareBasis = model.RoundWayFareBasis;
_obj.RoundWayFare = model.TotalRoundTripFare;
_obj.RoundWayReturn = model.RoundWayFare;
_obj.EffectiveFrom = model.EffectiveFrom;
_obj.ExpireOn = model.ExpireOn;
_obj.FlightTypeId = model.FlightTypeId;
_obj.ChildFare = model.ChildFare;
_obj.ChildFareUSD = model.ChildFareUSD;
_obj.ChildFareType = model.ChildFareType;
_obj.ChildFareOn = model.ChildFareOn;
_obj.InfantFare = model.InfantFare;
_obj.InfantFareUSD = model.InfantFareUSD;
_obj.InfantFareType = model.InfantFareType;
_obj.InfantFareOn = model.InfantFareOn;
_obj.RefundFee = model.RefundFee;
_obj.RefundFeeUSD = model.RefundFeeDollar;
_obj.ReissueFee = model.ReissueFee;
_obj.ReissueFeeUSD = model.ReissueFeeDollar;
_obj.TourCode = model.TourCode;
_obj.FC = model.FuelCharge;
_obj.ValidUntilNextNotic = model.ValidTillFurtherNotice;
_obj.RoundWayGoingUSD = model.RoundWayGoingUSD;
_obj.OneWayFareUSD = model.OneWayFareUSD;
_obj.RoundWayReturnUSD = model.RoundWayReturnUSD;
_obj.RoundWayFareUSD = model.RoundWayFareUSD;
_obj.TermsAndConditions = collection["Information"];
_tfareprovider.SavePaperFareRule(_obj);
return(RedirectToAction("Index"));
}
//else
//{
// if (ModelState.IsValid)
// {
// SetValueForDropdownlist();
// PaperFareRules _obj = new PaperFareRules();
// _obj.AirlineId = model.AirlineId;
// _obj.FlightSeasonId = model.FlightSeasonId;
// _obj.DepartureCityId = model.DepartureCityId;
// _obj.DestinationCityId = model.DestinationCityId;
// _obj.FlightClassId = model.FlightClassId;
// //_obj.OneWayFareBasis = "sda";//
// _obj.OneWayFareBasis = model.OneWayFareBasis;
// _obj.OneWayFare = model.OneWayFare;
// _obj.RoundWayGoing = model.GoingFare;
// //_obj.RoundWayFareBasis = "sad"; //model.RoundWayFareBasis;
// _obj.RoundWayFareBasis = model.RoundWayFareBasis;
// _obj.RoundWayFare = model.TotalRoundTripFare;
// _obj.RoundWayReturn = model.RoundWayFare;
// _obj.EffectiveFrom = model.EffectiveFrom;
// _obj.ExpireOn = model.ExpireOn;
// _obj.FlightTypeId = model.FlightTypeId;
// _obj.ChildFare = model.ChildFare;
// _obj.ChildFareUSD = model.ChildFareUSD;
// _obj.ChildFareType = model.ChildFareType;
// _obj.ChildFareOn = model.ChildFareOn;
// _obj.InfantFare = model.InfantFare;
// _obj.InfantFareUSD = model.InfantFareUSD;
// _obj.InfantFareType = model.InfantFareType;
// _obj.InfantFareOn = model.InfantFareOn;
// _obj.RefundFee = model.RefundFee;
// _obj.RefundFeeUSD = model.RefundFeeDollar;
// _obj.ReissueFee = model.ReissueFee;
// _obj.ReissueFeeUSD = model.ReissueFeeDollar;
// _obj.TourCode = model.TourCode;
// _obj.FC = model.FuelCharge;
// _obj.ValidUntilNextNotic = model.ValidTillFurtherNotice;
// _obj.RoundWayGoingUSD = model.RoundWayGoingUSD;
// _obj.OneWayFareUSD = model.OneWayFareUSD;
// _obj.RoundWayReturnUSD = model.RoundWayReturnUSD;
// _obj.RoundWayFareUSD = model.RoundWayFareUSD;
// _obj.TermsAndConditions = collection["Information"];
// _tfareprovider.SavePaperFareRule(_obj);
// return RedirectToAction("Index");
// }
else
{
TempData["classname"] = "Class Name already exists";
defaultPaperFairRule = _tfareprovider.GetDefaultPaperFairRule();
model.TermsAndConditions = defaultPaperFairRule.TermsAndConditions;
return(View(model));
}
// }
defaultPaperFairRule = _tfareprovider.GetDefaultPaperFairRule();
model.TermsAndConditions = defaultPaperFairRule.TermsAndConditions;
return(View(model));
}
public ActionResult Edit(int id, TravelFareModel obj, FormCollection collection)
{
DefaultPaperFareRules defaultPaperFairRule = new DefaultPaperFareRules();
if (obj.DepartureCityId == obj.DestinationCityId)
{
ModelState.AddModelError("City", "Please Review the Cities");
TempData["City"] = "please Review the cities";
}
//Checking If that Id contains all the values
bool CheckId = _tfareprovider.CheckValuesForAParticularID(obj.AirlineId, obj.DepartureCityId, obj.DestinationCityId, obj.FlightClassId, id);
bool checkPaperFare = true;
if (CheckId == false)
{
if (obj.ExpireOn == null)
{
checkPaperFare = _tfareprovider.IfPaperFareExist(obj.AirlineId, obj.FlightClassId, obj.EffectiveFrom, obj.DepartureCityId, obj.DepartureCityId);
}
else
{
checkPaperFare = _tfareprovider.CheckPaperFareExist(obj.AirlineId, obj.FlightClassId, obj.EffectiveFrom, Convert.ToDateTime(obj.ExpireOn), obj.DepartureCityId, obj.DestinationCityId);
}
}
bool checkClassName = _tfareprovider.CheckClassNameExist(obj.AirlineId, obj.FlightClassId, obj.DepartureCityId, obj.DestinationCityId);
if (checkPaperFare == false)
{
TempData["Error"] = "Fare already exists";
ModelState.AddModelError("Fare", "Unable to Save the values");
}
else if (checkClassName == true)
{
PaperFareRules _obj = new PaperFareRules();
_obj.PaperFareId = id;
_obj.AirlineId = obj.AirlineId;
_obj.FlightSeasonId = obj.FlightSeasonId;
_obj.DepartureCityId = obj.DepartureCityId;
_obj.DestinationCityId = obj.DestinationCityId;
_obj.FlightClassId = obj.FlightClassId;
_obj.OneWayFareBasis = obj.OneWayFareBasis;
_obj.OneWayFare = obj.OneWayFare;
_obj.RoundWayGoing = obj.GoingFare;
_obj.RoundWayReturn = obj.RoundWayFare;
_obj.RoundWayFare = obj.TotalRoundTripFare;
_obj.RoundWayFareBasis = obj.RoundWayFareBasis;
_obj.FC = obj.FuelCharge;
_obj.EffectiveFrom = obj.EffectiveFrom;
_obj.ExpireOn = obj.ExpireOn;
_obj.FlightTypeId = obj.FlightTypeId;
_obj.ChildFare = obj.ChildFare;
_obj.ChildFareUSD = obj.ChildFareUSD;
_obj.ChildFareType = obj.ChildFareType;
_obj.ChildFareOn = obj.ChildFareOn;
_obj.InfantFare = obj.InfantFare;
_obj.InfantFareUSD = obj.InfantFareUSD;
_obj.InfantFareType = obj.InfantFareType;
_obj.InfantFareOn = obj.InfantFareOn;
_obj.RefundFee = obj.RefundFee;
_obj.RefundFeeUSD = obj.RefundFeeDollar;
_obj.ReissueFee = obj.ReissueFee;
_obj.ReissueFeeUSD = obj.ReissueFeeDollar;
_obj.TourCode = obj.TourCode;
_obj.TermsAndConditions = collection["Information"];
_obj.ValidUntilNextNotic = obj.ValidTillFurtherNotice;
_obj.RoundWayGoingUSD = obj.RoundWayGoingUSD;
_obj.OneWayFareUSD = obj.OneWayFareUSD;
_obj.RoundWayReturnUSD = obj.RoundWayReturnUSD;
_obj.RoundWayFareUSD = obj.RoundWayFareUSD;
_tfareprovider.EditPaperFlightFareRule(_obj);
return(RedirectToAction("Index"));
}
//if (ModelState.IsValid)
//{
// PaperFareRules _obj = new PaperFareRules();
// _obj.PaperFareId = id;
// _obj.AirlineId = obj.AirlineId;
// _obj.FlightSeasonId = obj.FlightSeasonId;
// _obj.DepartureCityId = obj.DepartureCityId;
// _obj.DestinationCityId = obj.DestinationCityId;
// _obj.FlightClassId = obj.FlightClassId;
// _obj.OneWayFareBasis = obj.OneWayFareBasis;
// _obj.OneWayFare = obj.OneWayFare;
// _obj.RoundWayGoing = obj.GoingFare;
// _obj.RoundWayReturn = obj.RoundWayFare;
// _obj.RoundWayFare = obj.TotalRoundTripFare;
// _obj.RoundWayFareBasis = obj.RoundWayFareBasis;
// _obj.FC = obj.FuelCharge;
// _obj.EffectiveFrom = obj.EffectiveFrom;
// _obj.ExpireOn = obj.ExpireOn;
// _obj.FlightTypeId = obj.FlightTypeId;
// _obj.ChildFare = obj.ChildFare;
// _obj.ChildFareUSD = obj.ChildFareUSD;
// _obj.ChildFareType = obj.ChildFareType;
// _obj.ChildFareOn = obj.ChildFareOn;
// _obj.InfantFare = obj.InfantFare;
// _obj.InfantFareUSD = obj.InfantFareUSD;
// _obj.InfantFareType = obj.InfantFareType;
// _obj.InfantFareOn = obj.InfantFareOn;
// _obj.RefundFee = obj.RefundFee;
// _obj.RefundFeeUSD = obj.RefundFeeDollar;
// _obj.ReissueFee = obj.ReissueFee;
// _obj.ReissueFeeUSD = obj.ReissueFeeDollar;
// _obj.TourCode = obj.TourCode;
// _obj.TermsAndConditions = collection["Information"];
// _obj.ValidUntilNextNotic = obj.ValidTillFurtherNotice;
// _obj.RoundWayGoingUSD = obj.RoundWayGoingUSD;
// _obj.OneWayFareUSD = obj.OneWayFareUSD;
// _obj.RoundWayReturnUSD = obj.RoundWayReturnUSD;
// _obj.RoundWayFareUSD = obj.RoundWayFareUSD;
// _tfareprovider.EditPaperFlightFareRule(_obj);
// return RedirectToAction("Index");
//}
else
{
TempData["classname"] = "Class Name already exists";
SetValueForDropdownlist();
defaultPaperFairRule = _tfareprovider.GetDefaultPaperFairRule();
obj.TermsAndConditions = defaultPaperFairRule.TermsAndConditions;
return(View(obj));
}
defaultPaperFairRule = _tfareprovider.GetDefaultPaperFairRule();
obj.TermsAndConditions = defaultPaperFairRule.TermsAndConditions;
return(View(obj));
}
