public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblFlightSeat tblFlightSeat = db.tblFlightSeats.Find(id); var config = new MapperConfiguration(x => { x.CreateMap <tblFlightSeat, FlightSeatViewModel>(); }); var _mapper = config.CreateMapper(); FlightSeatViewModel seat = _mapper.Map <FlightSeatViewModel>(tblFlightSeat); seat.ListFlight = (from c in db.tblFlights.ToList() select new SelectListItem { Text = c.FlightNo, Value = c.ID.ToString() }).ToList(); seat.ListClass = (from c in db.tblClasses.ToList() select new SelectListItem { Text = c.Class, Value = c.ID.ToString() }).ToList(); return(View(seat)); }
public ActionResult Create() { FlightSeatViewModel vmFlightSeat = new FlightSeatViewModel(); vmFlightSeat.ListFlight = (from c in db.tblFlights.ToList() select new SelectListItem { Text = c.FlightNo, Value = c.ID.ToString() }).ToList(); vmFlightSeat.ListClass = (from c in db.tblClasses.ToList() select new SelectListItem { Text = c.Class, Value = c.ID.ToString() }).ToList(); return(View(vmFlightSeat)); }
public ActionResult Edit(FlightSeatViewModel seat) { seat.ListFlight = (from c in db.tblFlights.ToList() select new SelectListItem { Text = c.FlightNo, Value = c.ID.ToString() }).ToList(); seat.ListClass = (from c in db.tblClasses.ToList() select new SelectListItem { Text = c.Class, Value = c.ID.ToString() }).ToList(); if (ModelState.IsValid) { try { //insert gar //converting view model to entity model var config = new MapperConfiguration (x => { x.CreateMap <FlightSeatViewModel, tblFlightSeat>(); }); var _mapper = config.CreateMapper(); tblFlightSeat entitymodel = _mapper.Map <tblFlightSeat>(seat); //update database db.Entry(entitymodel).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); } } return(View(seat)); }
public ActionResult Create(FlightSeatViewModel vmFlightSeat) { vmFlightSeat.ListFlight = (from c in db.tblFlights.ToList() select new SelectListItem { Text = c.FlightNo, Value = c.ID.ToString() }).ToList(); vmFlightSeat.ListClass = (from c in db.tblClasses.ToList() select new SelectListItem { Text = c.Class, Value = c.ID.ToString() }).ToList(); if (ModelState.IsValid) { //insert //converting view model to entity model try { tblFlightSeat dbFlightSeat = new tblFlightSeat(); dbFlightSeat.FlightID = vmFlightSeat.FlightID; dbFlightSeat.ClassID = vmFlightSeat.ClassID; dbFlightSeat.NoOfSeat = vmFlightSeat.NoOfSeat; db.tblFlightSeats.Add(dbFlightSeat); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception ex) { ModelState.AddModelError("", "seat and class cannot be duplicated"); } } return(View(vmFlightSeat)); }