public JsonResult PostWork(AptWorkVM WorkJson) { ApartmentEntities aptDB = new ApartmentEntities(); Apt_Work work = new Apt_Work(); work.User_ID = WorkJson.Userid; work.Task_ID = WorkJson.TaskId; work.Work_Date = DateTime.Now; aptDB.Apt_Work.Add(work); aptDB.SaveChanges(); return(Json("success")); }
public ActionResult Index() { ApartmentEntities aptDB = new ApartmentEntities(); ViewBag.aptusernames = new SelectList(aptDB.Apt_User, "ID", "User_Name"); ViewBag.apttasknames = new SelectList(aptDB.Apt_Task, "ID", "Task_Name"); List <Work> works = aptDB.Works.ToList(); var analysislist = works.OrderByDescending(g => g.Frequency) .OrderBy(m => m.Task_Name) .ToList(); List <Apt_Work> logworks = aptDB.Apt_Work.ToList(); var loglist = logworks.OrderByDescending(g => g.Work_Date).ToList(); ViewBag.loglist = loglist; return(View(analysislist)); }