public ActionResult Index(FormCollection fc, int?AirlineType)
{
if (Request.IsAjaxRequest())
{
string airlineCityname = fc["SearchAirline"];
if (airlineCityname != null && airlineCityname != "")
{
var result = new TravelFareModel
{
airlineTravelportalList = _tfareprovider.GetTravelFareByName(airlineCityname)
};
return(PartialView("ListPartial", result));
}
else
{
if (AirlineType == 1)
{
var international = new TravelFareModel
{
airlineTravelportalList = _tfareprovider.GetInternationalTravelFare()
};
return(PartialView("ListPartial", international));
}
else
{
var domestic = new TravelFareModel
{
airlineTravelportalList = _tfareprovider.GetDomesticTravelFare()
};
return(PartialView("ListPartial", domestic));
}
}
}
return(View());
}
public ActionResult Index(int?AirlineType)
{
//return View(_tfareprovider.ListAllPaperFlightFareRule());
ViewData["AirlineType"] = new SelectList(ent.AirlineTypes.OrderBy(x => x.TypeName), "AirineTypeId ", "TypeName ");
if (Request.IsAjaxRequest())
{
if (AirlineType == 1)
{
var international = new TravelFareModel
{
airlineTravelportalList = _tfareprovider.GetInternationalTravelFare().OrderBy(x => x.AirlineNmae)
};
return(PartialView("ListPartial", international));
}
else
{
var domestic = new TravelFareModel
{
airlineTravelportalList = _tfareprovider.GetDomesticTravelFare().OrderBy(x => x.AirlineNmae)
};
return(PartialView("ListPartial", domestic));
}
}
var viewModel = new TravelFareModel
{
airlineTravelportalList = _tfareprovider.GetDomesticTravelFare().OrderBy(x => x.AirlineNmae)
};
return(View(viewModel));
}
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 IEnumerable <TravelFareModel> GetTravelFareByName(string airlineName)
{
//var result = ent.Airlines.Where(x => (x.AirlineName.ToLower().Contains(airlineName.ToLower()) || x.AirlineCode.ToLower().Contains(airlineName.ToLower())));
int AirlineId = ent.Airlines.Where(x => x.AirlineName == airlineName).Select(x => x.AirlineId).FirstOrDefault();
var tempData = ent.PaperFareRules.Where(x => x.AirlineId == AirlineId);
var reviewModel = new List <TravelFareModel>();
foreach (var item in tempData)
{
var viewModel = new TravelFareModel
{
PaperFareId = item.PaperFareId,
AirlineId = item.AirlineId,
AirlineNmae = item.Airlines.AirlineName,
FlightSeasonId = item.FlightSeasonId,
DepartureCityId = item.DepartureCityId,
DestinationCityName = _provider.GetCityName(item.DestinationCityId),
DestinationCityId = item.DepartureCityId,
DepartureCityName = _provider.GetCityName(item.DepartureCityId),
FlightClassId = item.DestinationCityId,
FlightClassName = _provider.GetFlightClassName(item.FlightClassId),
OneWayFareBasis = item.OneWayFareBasis,
OneWayFare = item.OneWayFare,
RoundWayFareBasis = item.RoundWayFareBasis,
RoundWayFare = item.RoundWayFare,
EffectiveFrom = item.EffectiveFrom,
ExpireOn = item.ExpireOn,
FlightTypeId = item.FlightTypeId,
ChildFare = item.ChildFare,
ChildFareType = item.ChildFareType,
ChildFareOn = item.ChildFareOn,
InfantFare = item.InfantFare,
InfantFareType = item.InfantFareType,
InfantFareOn = item.InfantFareOn,
RefundFee = item.RefundFee,
ReissueFee = item.ReissueFee,
TermsAndConditions = item.TermsAndConditions,
TourCode = item.TourCode,
// FlightClassName = item.FlightClasses.ClassName
};
reviewModel.Add(viewModel);
}
return(reviewModel.AsEnumerable());
}
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 IEnumerable <TravelFareModel> GetDomesticTravelFare()
{
var tempData = ent.PaperFareRules.Where(x => x.FlightTypeId == 2).ToList();
var reviewModel = new List <TravelFareModel>();
foreach (var item in tempData)
{
var viewModel = new TravelFareModel
{
PaperFareId = item.PaperFareId,
AirlineId = item.AirlineId,
AirlineNmae = item.Airlines.AirlineName,
FlightSeasonId = item.FlightSeasonId,
DepartureCityId = item.DepartureCityId,
DestinationCityName = _provider.GetCityName(item.DestinationCityId),
DestinationCityId = item.DepartureCityId,
DepartureCityName = _provider.GetCityName(item.DepartureCityId),
FlightClassId = item.FlightClassId,
OneWayFareBasis = item.OneWayFareBasis,
OneWayFare = item.OneWayFare,
RoundWayFareBasis = item.RoundWayFareBasis,
RoundWayFare = item.RoundWayFare,
EffectiveFrom = item.EffectiveFrom,
ExpireOn = item.ExpireOn,
FlightTypeId = item.FlightTypeId,
ChildFare = item.ChildFare,
ChildFareType = item.ChildFareType,
ChildFareOn = item.ChildFareOn,
InfantFare = item.InfantFare,
InfantFareType = item.InfantFareType,
InfantFareOn = item.InfantFareOn,
RefundFee = item.RefundFee,
ReissueFee = item.ReissueFee,
//FlightClassName = _provider.GetFlightClassName(item.FlightClassId),
TermsAndConditions = item.TermsAndConditions,
TourCode = item.TourCode,
FlightClassName = item.Air_DomesticFlightClasses.FlightClassCode + "(" + item.Air_DomesticFlightClasses.FlightClassType + ")"
};
reviewModel.Add(viewModel);
}
return(reviewModel.AsEnumerable());
}
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 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));
}
