public ActionResult RequestCycleAdminInsertion(RequestCycle rc) { if (ModelState.IsValid) { //if (rc.ToDate != null) //{ // rc.Status = true; //} //else //{ // rc.Status = false; //} //var cycleId = db.CycleRequestedByUsers.Where(a => a.Username == User.Identity.Name).Select(a=>a.CycleID); if (rc.CycleID.Equals(null)) { ViewBag.CycleIDError = "Sorry. Currently there are no Cycles available to raise a request."; } else { db.RequestCycles.Add(rc); db.SaveChanges(); return(RedirectToAction("CycleList", "CycleDetailsList")); }// return RedirectToAction("RequestCycleAdminInsertion", "InsertRequestForCycle"); } //ViewBag.dropdownlist = new SelectList(db.CycleDetails, "CycleID", "CycleID"); return(View(rc)); }
// GET: UserRequestCycle public ActionResult userRaisesRequestForCycle(int id) { BikesEntities1 db = new BikesEntities1(); RequestCycle urc = db.RequestCycles.Single(c => c.CycleID == id); return(View(urc)); }
public ActionResult Details(int?id) { BikesEntities1 db = new BikesEntities1(); //We need a single cycle out of the list where the ID of the Cycle should be equal to the ID that we are passing into the dEtails action method RequestCycle singleCycleDetails = db.RequestCycles.Single(c => c.RequestID == id); return(View(singleCycleDetails)); }
public ActionResult New(RequestCycle reg) { if (ModelState.IsValid) { BikesEntities1 db = new BikesEntities1(); db.RequestCycles.Add(reg); db.SaveChanges(); ModelState.Clear(); reg = null; ViewBag.SuccessRegistration = "Registration was successfull"; } return(View()); }
public ActionResult RequestCycleAdminInsertion(RequestCycle rc) { if (ModelState.IsValid) { db.RequestCycles.Add(rc); db.SaveChanges(); return(RedirectToAction("RequestCycleAdminInsertion", "TechnicalSupport")); } //ViewBag.dropdownlist = new SelectList(db.CycleDetails, "CycleID", "CycleID"); return(View(rc)); }
public ActionResult Index3(RequestCycle rbu) { BikesEntities1 db = new BikesEntities1(); List <RequestCycle> rc = db.RequestCycles.ToList(); int rid = rbu.RequestID; int cid = rbu.CycleID; DateTime fd = rbu.FromDate; DateTime td = rbu.ToDate; CycleRequestedByUser crbu = new CycleRequestedByUser(); crbu.RequestID = rbu.RequestID; crbu.CycleID = rbu.CycleID; crbu.FromDate = (DateTime)rbu.FromDate; crbu.ToDate = (DateTime)rbu.ToDate; //select and insert statement db.CycleRequestedByUsers.Add(crbu); db.SaveChanges(); return(View()); }
public ActionResult DisplayRequestedDetails1() { var ddreq = Session["ViewRequest"]; var userddreq = Session["ViewUsername"]; BikesEntities1 be = new BikesEntities1(); //using (var be = new BikesEntities()) //{ //var x = db.RequestCycles.Include(c => c.CycleRequestedByUsers).Single(c => c.RequestID == id); //foreach (var mystep in ddreq) //var mystep = be.RequestCycles.Where(p => p.RequestID == id).FirstOrDefault(); //{ // var currentDate = DateTime.Now; CycleRequestedByUser task = new CycleRequestedByUser(); RequestCycle rc = new RequestCycle(); //var checkDateWithDate = DateTime.Now.AddDays(7); task.RequestID = ((Dec_21_ASP_Bikes.Models.RequestCycle)ddreq).RequestID; task.CycleID = ((Dec_21_ASP_Bikes.Models.RequestCycle)ddreq).CycleID; task.FromDate = ((Dec_21_ASP_Bikes.Models.RequestCycle)ddreq).FromDate; task.ToDate = ((Dec_21_ASP_Bikes.Models.RequestCycle)ddreq).ToDate; var ToDateWithDate = ((Dec_21_ASP_Bikes.Models.RequestCycle)ddreq).ToDate; task.Username = ((Dec_21_ASP_Bikes.Models.Registration)userddreq).Username; task.CheckDate = ToDateWithDate.AddDays(7); if (task.Username != null) { task.Status = true; rc.Status = true; } else { task.Status = false; rc.Status = false; } be.CycleRequestedByUsers.Add(task); db.Entry(rc).State = EntityState.Modified; // db.SaveChanges(); //} be.SaveChanges(); //db.SaveChanges(); ViewBag.InsertedDataToTable4 = "Congtaz 👍👍👍👍" + User.Identity.Name + ". Your 🚲 request was successfull"; ViewBag.navigationToCyclesBorrowed = "🚲"; return(View()); //} }