public void DeleteFareClass(int FareClassId) { // FlightClasses obj = ent.FlightClasses.Where(x => x.FlightClassId == FareClassId).FirstOrDefault(); Air_DomesticFlightClasses obj = ent.Air_DomesticFlightClasses.Where(x => x.DomesticFlightClassId == FareClassId).FirstOrDefault(); ent.DeleteObject(obj); ent.SaveChanges(); }
public void UpdatFlightClasses(AirlineFlighClassViewModel modeltosave) { Air_DomesticFlightClasses comm = ent.Air_DomesticFlightClasses.Where(u => u.DomesticFlightClassId == modeltosave.FlightClassId).FirstOrDefault(); comm.DomesticFlightClassId = modeltosave.FlightClassId; comm.FlightClassCode = modeltosave.FlightClassCode; comm.FlightClassType = modeltosave.ClassType; ent.ApplyCurrentValues(comm.EntityKey.EntitySetName, comm); ent.SaveChanges(); ///// }
public void AddFlightClass(AirlineFlighClassViewModel model) { Air_DomesticFlightClasses datamodel = new Air_DomesticFlightClasses { AirlineId = model.AirlineId, FlightClassCode = model.FlightClassCode, FlightClassType = model.ClassType }; ent.AddToAir_DomesticFlightClasses(datamodel); ent.SaveChanges(); }
/////JsonResult Function To AjaxRequestController////////////////// //public JsonResult GetFlightClassCodeByAirline(int id) //{ // var result = new JsonResult(); // var lists = new SelectList(_tfareprovider.GetFlightClassCodeByAirlineID(id), "DomesticFlightClassId", "FlightClassCode"); // result.Data = lists; // result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; // return result; //} //public JsonResult GetAirlines(int AirlineTypeId) //{ // var model = _provider.GetAirlinesList(AirlineTypeId).ToList(); // JsonResult result = new JsonResult(); // result.Data = new SelectList(model, "AirlineId", "AirlineName"); // result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; // return result; //} //public JsonResult GetCities(int AirlineTypeId) //{ // var model = _provider.CityListAsperFlightType(AirlineTypeId).ToList(); // JsonResult result = new JsonResult(); // result.Data = new SelectList(model, "CityID", "CityName"); // result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; // return result; //} #region Custom region public void SetValueForDropdownlist() { var flightclasslist = ent.Air_DomesticFlightClasses.ToList(); Air_DomesticFlightClasses flightclassSelect = new Air_DomesticFlightClasses() { DomesticFlightClassId = -1, FlightClassCode = "--Select--" }; flightclasslist.Insert(0, flightclassSelect); var currencylist = ent.Currencies.ToList(); Currencies currencySelect = new Currencies() { CurrencyId = -1, CurrencyName = "--Select--" }; currencylist.Insert(0, currencySelect); //var flighttypelist = ent.FlightTypes.ToList(); //FlightTypes flighttypeSelect = new FlightTypes() { FlightTypeId = -1, FlightTypeName ="--Select--" }; //flighttypelist.Insert(0, flighttypeSelect); var flightsessionlist = ent.FlightSeasons.ToList(); FlightSeasons flightsessionSelect = new FlightSeasons { FlightSeasonId = -1, FlightSeasonName = "--Select--" }; flightsessionlist.Insert(0, flightsessionSelect); //var airlinelist = ent.Airlines.ToList(); //Airlines airlineSelect = new Airlines() { AirlineId = -1, AirlineName = "--Select--" }; //airlinelist.Insert(0, airlineSelect); //var departurecitylist = ent.AirlineCities.ToList(); //AirlineCities departurecitylistSelect = new AirlineCities() { CityID = -1, CityName = "--Select--" }; //departurecitylist.Insert(0, departurecitylistSelect); //var destinationcitylist = ent.AirlineCities.ToList(); //AirlineCities destinartioncitySelect = new AirlineCities() { CityID = -1, CityName = "--Select--" }; //destinationcitylist.Insert(0, destinartioncitySelect); //ViewData["FlightClasses"] = flightclasslist;//new SelectList(_tfareprovider.GetAllFlightClass(), "FlightClassId", "FlightClassCode"); //ViewData["CurrencyType"] = currencylist;//new SelectList(_tfareprovider.GetAllCurrencyType(), "CurrencyId", "CurrencyCode"); //ViewData["FlightTypes"] = flighttypelist;//new SelectList(_tfareprovider.GetAllFlightType(), "FlightTypeId", "FlightTypeName"); //ViewData["FlightSeasons"] = flightsessionlist;//new SelectList(_tfareprovider.GetAllFlightSeason(), "FlightSeasonId", "FlightSeasonName"); //ViewData["Airline"] = airlinelist;//new SelectList(_tfareprovider.GetAllAirline(), "AirlineId", "AirlineName"); //ViewData["DepartureCity"] = departurecitylist;//new SelectList(_tfareprovider.GetAllAirlineCity(), "CityID", "CityName"); //ViewData["DestinationCity"] = departurecitylist; //new SelectList(_tfareprovider.GetAllAirlineCity(), "CityID", "CityName"); ViewData["FlightClasses"] = new SelectList(_tfareprovider.GetAllFlightClass(), "FlightClassId", "FlightClassCode"); ViewData["CurrencyType"] = new SelectList(_tfareprovider.GetAllCurrencyType(), "CurrencyId", "CurrencyCode"); ViewData["FlightTypes"] = new SelectList(_tfareprovider.GetDomesticFlightType(), "FlightTypeId", "FlightTypeName", 0); ViewData["FlightSeasons"] = new SelectList(_tfareprovider.GetAllFlightSeason(), "FlightSeasonId", "FlightSeasonName"); ViewData["Airline"] = new SelectList(_tfareprovider.GetAllDomesticAirlines(), "AirlineId", "AirlineName", 0); ViewData["DepartureCity"] = new SelectList(_tfareprovider.GetDomesticCities(), "CityID", "CityName", 0); // ViewData["DestinationCity"] = new SelectList(_tfareprovider.GetAllAirlineCity(), "CityID", "CityName"); ViewData["ChildFairTypes"] = new SelectList(ATLTravelPortal.Helpers.ChildFairTypes.GetChildFairType(), "ChildFairTypeID", "ChildFairType", "P"); ViewData["ChildFairOns"] = new SelectList(ATLTravelPortal.Helpers.ChildFairOns.GetChildFairOn(), "ChildFairOnId", "ChildFairOnss", "M"); }