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));
}
