public JsonResult GetEndMileage(String Reg) { List <CarMileage> list = new List <CarMileage>(); VelogDataContext dbContext = new VelogDataContext(); var testlist = dbContext.VeLogDatas.Where(p => p.VehicleRego == Reg); testlist = testlist.OrderByDescending(p => p.Id); var rec = testlist.FirstOrDefault(); if (rec != null) { list.Add(new CarMileage { startMileage = rec.StartMileage, endMileage = rec.EndMileage, rego = rec.VehicleRego }); } else { list.Add(new CarMileage { startMileage = 0, endMileage = 0, rego = "xxx" }); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateNewLoaction() { VelogDataContext dbContext = new VelogDataContext(); ViewBag.Division = new SelectList(dbContext.tblvelogDivisions, "Division", "Division"); ViewBag.Course = new SelectList(dbContext.tblvelogCourses, "Courses", "Courses"); ViewBag.Campus = new SelectList(dbContext.tblvelogCampus, "Campus", "Campus"); return(PartialView("~/Views/Shared/EditorTemplates/AddLocation.cshtml")); }
public JsonResult GetMakeModel(String Reg) { List <CarSpec> list = new List <CarSpec>(); VelogDataContext dbContext = new VelogDataContext(); tblVelogCar rec = dbContext.tblVelogCars.First(x => x.Registration == Reg); list.Add(new CarSpec { make = rec.Make, model = rec.Model, color = rec.Colour }); return(Json(list, JsonRequestBehavior.AllowGet)); }
public JsonResult GetCourses(String Division) { List <SelectListItem> list = new List <SelectListItem>(); VelogDataContext dbContext = new VelogDataContext(); list = dbContext.tblvelogCourses.Where(d => d.Division == Division).Select(c => new SelectListItem { Value = c.Courses, Text = c.Courses }).ToList(); return(Json(new SelectList(list, "Value", "Text"), JsonRequestBehavior.AllowGet)); }
public ActionResult Create(string message = "") { VelogDataContext dbContext = new VelogDataContext(); ViewBag.Division = new SelectList(dbContext.tblvelogDivisions, "Division", "Division"); ViewBag.Course = new SelectList(dbContext.tblvelogCourses, "Courses", "Courses"); ViewBag.Campus = new SelectList(dbContext.tblvelogCampus, "Campus", "Campus"); ViewBag.VehicleRego = new SelectList(dbContext.tblVelogCars, "Registration", "Registration"); ViewBag.result = message; return(View()); }
public ActionResult Login(User userRec) { VelogDataContext dbContext = new VelogDataContext(); bool Exist = dbContext.tblvelogUsers.Any(x => x.Username == userRec.Username && x.Password == userRec.Password && x.Role == "User"); if (Exist) { FormsAuthentication.SetAuthCookie(userRec.Username, false); return(RedirectToAction("Create", "VeLogData")); } return(View(userRec)); }
public ActionResult Create(VeLogDataView VeLogDataRec) { VelogDataContext dbContext = new VelogDataContext(); int maxId; VeLogDataClient VC = new VeLogDataClient(); if (dbContext.VeLogDatas.Any()) { maxId = dbContext.VeLogDatas.Max(item => item.Id); } else { maxId = 0; } if (ModelState.IsValid) { Double MileageAvg = VeLogDataRec.EndMileage - VeLogDataRec.StartMileage; if (VeLogDataRec.LocationList != null) { MileageAvg = MileageAvg / (VeLogDataRec.LocationList.Count() + 1); } VeLogData DataToSubmit = new VeLogData(); DataToSubmit.Comment = VeLogDataRec.Comment; DataToSubmit.CreationDate = DateTime.Now;; DataToSubmit.Distance = MileageAvg; DataToSubmit.DriverName = VeLogDataRec.DriverName; DataToSubmit.EndMileage = VeLogDataRec.EndMileage; DataToSubmit.StartMileage = VeLogDataRec.StartMileage; DataToSubmit.VehicleRego = VeLogDataRec.VehicleRego; DataToSubmit.TripId = VeLogDataRec.VehicleRego + "--" + maxId; DataToSubmit.Campus = VeLogDataRec.Campus; DataToSubmit.Division = VeLogDataRec.Division; DataToSubmit.Course = VeLogDataRec.Course; // VC.Create(DataToSubmit); dbContext.VeLogDatas.Add(DataToSubmit); dbContext.SaveChanges(); if (VeLogDataRec.LocationList != null) { for (int i = 0; i < VeLogDataRec.LocationList.Count(); i++) { VeLogData DataToSubmit1 = new VeLogData(); DataToSubmit1.Comment = VeLogDataRec.Comment; DataToSubmit1.CreationDate = DateTime.Now;; DataToSubmit1.Distance = MileageAvg; DataToSubmit1.DriverName = VeLogDataRec.DriverName; DataToSubmit1.EndMileage = VeLogDataRec.EndMileage; DataToSubmit1.StartMileage = VeLogDataRec.StartMileage; DataToSubmit1.VehicleRego = VeLogDataRec.VehicleRego; DataToSubmit1.TripId = VeLogDataRec.VehicleRego + "--" + maxId; DataToSubmit1.Campus = VeLogDataRec.LocationList[i].Campus; DataToSubmit1.Division = VeLogDataRec.LocationList[i].Division; DataToSubmit1.Course = VeLogDataRec.LocationList[i].Course; dbContext.VeLogDatas.Add(DataToSubmit1); dbContext.SaveChanges(); //VC.Create(DataToSubmit1); } } return(RedirectToAction("Create", new { message = "Mileage Details added successfully!!!" })); } else { ViewBag.Division = new SelectList(dbContext.tblvelogDivisions, "Division", "Division"); ViewBag.Course = new SelectList(dbContext.tblvelogCourses, "Courses", "Courses"); ViewBag.Campus = new SelectList(dbContext.tblvelogCampus, "Campus", "Campus"); ViewBag.VehicleRego = new SelectList(dbContext.tblVelogCars, "Registration", "Registration"); if (VeLogDataRec.VehicleRego != null) { tblVelogCar rec = dbContext.tblVelogCars.First(x => x.Registration == VeLogDataRec.VehicleRego); VeLogDataRec.MakeCmb = rec.Model + "--" + rec.Make + "--" + rec.Colour; } return(View("Create", VeLogDataRec)); } }