public ActionResult ViewDetails(int id) { FMS_tbl_BonusMilesDEtails obj = new FMS_tbl_BonusMilesDEtails(); obj = db.FMS_tbl_BonusMilesDEtails.Find(id); return(View(obj)); }
public ActionResult DeleteBonusMilesById(int id) { TempData["id"] = id; FMS_tbl_BonusMilesDEtails obj = new FMS_tbl_BonusMilesDEtails(); obj = db.FMS_tbl_BonusMilesDEtails.Find(id); return(View(obj)); }
public ActionResult ViewBonusMilesById(FormCollection fc) { int id1 = int.Parse(fc["BonusMilesId"]); FMS_tbl_BonusMilesDEtails obj = new FMS_tbl_BonusMilesDEtails(); obj = db.FMS_tbl_BonusMilesDEtails.FirstOrDefault(x => x.BonusMilesId == id1); if (obj != null) { return(RedirectToAction("ViewDetails", new { id = id1 })); } else { ViewBag.message = "Entered id is not correct"; return(View()); } }
public ActionResult DeleteBonusMilesById(FormCollection fc) { int id1 = (int)TempData["id"]; FMS_tbl_BonusMilesDEtails obj = new FMS_tbl_BonusMilesDEtails(); obj = db.FMS_tbl_BonusMilesDEtails.FirstOrDefault(x => x.BonusMilesId == id1); db.Entry(obj).State = EntityState.Deleted; try { int i = db.SaveChanges(); TempData["Message"] = "Delete successful"; return(RedirectToAction("ViewBonusMiles")); } catch (Exception) { ViewBag.messag = "Could not delete."; return(View(obj)); } }
public ActionResult AddBonusMiles(FormCollection fc, string create) { FMS_tbl_BonusMilesDEtails obj = new FMS_tbl_BonusMilesDEtails(); if (create == null) { int distance = 0; obj.FlightScheduleId = int.Parse(fc["FlightScheduleId"].ToString()); List <FMS_tbl_FlightScheduleDetails> list = db.FMS_tbl_FlightScheduleDetails.ToList(); foreach (FMS_tbl_FlightScheduleDetails items in list) { if (items.FlightScheduleId.Equals(obj.FlightScheduleId)) { distance = (int)items.Distance; } } ViewBag.list = getFlightName(); obj.BonusMiles = Convert.ToInt32(distance * 0.25); TempData["BonusMiles"] = obj.BonusMiles; return(View(obj)); } else { try { obj.FlightScheduleId = int.Parse(fc["FlightScheduleId"].ToString()); obj.BonusMiles = int.Parse(fc["BonusMiles"].ToString()); } catch (Exception) { ViewBag.Messag = "Flight Name or Bonus Miles Shouldn't be Empty."; ViewBag.list = getFlightName(); return(View()); } List <FMS_tbl_BonusMilesDEtails> li = db.FMS_tbl_BonusMilesDEtails.ToList(); foreach (FMS_tbl_BonusMilesDEtails item in li) { if (obj.FlightScheduleId.Equals(item.FlightScheduleId)) { ViewBag.Msg = "Already Added Miles For this Flight"; ViewBag.list = getFlightName(); return(View()); } } if (obj.BonusMiles > (int)TempData["BonusMiles"]) { ViewBag.Msg = "Value of Bonus Miles should be below the value which is populated."; ViewBag.list = getFlightName(); return(View()); } else { db.FMS_tbl_BonusMilesDEtails.Add(obj); db.SaveChanges(); int id = obj.BonusMilesId; if (id > 1) { ViewBag.Msg = "Miles added Sucessfully"; ViewBag.list = getFlightName(); return(View()); } else { ViewBag.Msg = "Error while adding Miles"; ViewBag.list = getFlightName(); return(View()); } } } }