public ActionResult Buddy()
{
//BikesEntities db = new BikesEntities();
//var retrieve = (from a in db.Registrations
// join u in db.CycleRequestedByUsers on a.StudentID equals u.StudentID
// select a).Include(c => c.CycleRequestedByUsers);
Registration reg = new Registration();
CycleRequestedByUser cbru = new CycleRequestedByUser();
UserProfileAndCycleDetailsViewModel upvm = new UserProfileAndCycleDetailsViewModel();
//upvm.Fullname = reg.Fullname;
//upvm.StudentID = reg.StudentID;
//upvm.UserRequest = cbru.UserRequest;
//upvm.RequestID = cbru.RequestID;
// var userDetails1 = upvm.Registrations.Include(c => c.CycleRequestedByUsers).Single(c => c.Username == User.Identity.Name);
//var userDetails2 = db.Registrations.Single(c => c.Username == User.Identity.Name);
// Session["ViewRequest"] = userDetails1;
//Session["ViewUsername"] = userDetails2;
//return View(userDetails1);
return(View());
}
public ActionResult DD()
{
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();
//{
CycleRequestedByUser task = new CycleRequestedByUser();
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;
task.Username = ((Dec_21_ASP_Bikes.Models.Registration)userddreq).Username;
be.CycleRequestedByUsers.Add(task);
//}
be.SaveChanges();
return(View());
//}
}
public ActionResult ReturnCycle(CycleRequestedByUser cbru)
{
// var ddreq = Session["ViewRequest"];
//var ddreq = Session["ViewRequest"];
BikesEntities1 db = new BikesEntities1();
//CycleRequestedByUser task = new CycleRequestedByUser();
//var updateStatus = db.CycleRequestedByUsers.SingleOrDefault(w => w.Username == User.Identity.Name && w.RequestID == id);
var updateStatus = db.CycleRequestedByUsers.Where(a => a.Username == User.Identity.Name).OrderByDescending(x => x.UserRequest).Take(1).Single();
updateStatus.Status = false;
updateStatus.CheckDate = DateTime.Now.Date;
db.Entry(updateStatus).State = EntityState.Modified;
db.SaveChanges();
ViewBag.ReturnedCycle = "Hi " + User.Identity.Name +
" 😎" + " You have successfully returned the 🚲 ." +
" Please click the below link to request for a new 🚲";
ViewBag.link = "👉👉👉👉";
return(View());
}
public ActionResult RequestName(CycleRequestedByUser rbu)
{
// try
//{
BikesEntities1 db = new BikesEntities1();
// List<RequestCycle> rc = db.rc.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(rbu);
db.SaveChanges();
// }
//catch (Exception ex)
// {
//throw ex;
//int RequestedCycleFromViewID = crbu.RequestID;
return(View(rbu));
}
public ActionResult NavigateToRequestPage(CycleRequestedByUser crbu)
{
if (ModelState.IsValid)
{
db.CycleRequestedByUsers.Add(crbu);
db.SaveChanges();
return(RedirectToAction("DisplayImage", "Image"));
}
//ViewBag.dropdownlist = new SelectList(db.CycleDetails, "CycleID", "CycleID");
return(View(crbu));
}
public ActionResult Index1(CycleRequestedByUser crbu)
{
if (ModelState.IsValid)
{
db.CycleRequestedByUsers.Add(crbu);
//db.Entry(crbu).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("DisplayImage", "Image"));
}
//ViewBag.dropdownlist = new SelectList(db.CycleDetails, "CycleID", "CycleID");
return(View(crbu));
}
public ActionResult RegisterCycle(CycleRequestedByUser U)
{
if (ModelState.IsValid)
{
using (BikesEntities1 db = new BikesEntities1())
{
//you should check duplicate registration here
db.CycleRequestedByUsers.Add(U);
db.SaveChanges();
ModelState.Clear();
U = null;
ViewBag.registrationSuccess = "Registration was Successfull. Welcome ";
// return RedirectToAction("Index", "Home");
}
}
return(View(U));
}
public ActionResult ReturnCycle(CycleRequestedByUser cbru, int id)
{
// var ddreq = Session["ViewRequest"];
//var ddreq = Session["ViewRequest"];
BikesEntities1 db = new BikesEntities1();
//CycleRequestedByUser task = new CycleRequestedByUser();
var updateStatus = db.CycleRequestedByUsers.SingleOrDefault(w => w.Username == User.Identity.Name && w.RequestID == id);
updateStatus.Status = false;
db.Entry(updateStatus).State = EntityState.Modified;
db.SaveChanges();
return(View());
}
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());
//}
}
