public List <Task> Delete(Task t) { //delete the selected task n reload the entries DbAccessLayer db = new DbAccessLayer(); Task taskDelete = (from temp in db.Tasks where temp.TaskCode == t.TaskCode select temp).ToList <Task>()[0]; db.Tasks.Remove(taskDelete); db.SaveChanges(); //return refreshed list List <Task> tasks = db.Tasks.ToList <Task>(); return(tasks); }
public ActionResult Register(User u) { DbAccessLayer dal = new DbAccessLayer(); if (ModelState.IsValid) { string RePass = Request.Form["RetypePassword"]; if (RePass == u.Password) { dal.Users.Add(u); dal.SaveChanges(); TempData["RegistrationSucess"] = "User registered sucessfully..";//tempdata to retain the value return(RedirectToAction("Index")); } } return(View("Register", null)); }
public List <Task> Post(Task obj) { obj.AssignedBy = "Admin";//Prnv: hardcoded for the time being //TODO: get username from viewbag and assign here DbAccessLayer dal = new DbAccessLayer(); if (ModelState.IsValid) { dal.Tasks.Add(obj); dal.SaveChanges(); } DbAccessLayer dl = new DbAccessLayer(); List <Task> TaskAll = dl.Tasks.ToList <Task>(); return(TaskAll); }
public ActionResult Submit() { DbAccessLayer dal = new DbAccessLayer(); //created a DataAccessLayer object //TasksVM vm = new TasksVM();//viewModel is no longer required as Jquery post method is used Task obj = new Task(); //created a model object ViewBag.users = dal.Users.Select(m => m.UserName).ToList(); //select all the users and pass it to the view using viewbag obj.TaskCode = Request.Form["Tasks.TaskCode"]; obj.TaskName = Request.Form["Tasks.TaskName"]; obj.TaskDescription = Request.Form["Tasks.TaskDescription"]; // obj.IsComplete = Convert.ToBoolean(Request.Form["Tasks.IsComplete"]); //not returning true obj.IsComplete = Convert.ToBoolean(Request.Form.GetValues("Tasks.IsComplete")[0]); obj.EnteredDate = DateTime.Parse(Request.Form["Tasks.EnteredDate"]); obj.AssignedTo = Request.Form["AssignedTo"]; obj.AssignedBy = "ABC1234"; if (ModelState.IsValid) { dal.Tasks.Add(obj); //in-memory updation dal.SaveChanges(); //physical commit //vm.Tasks = new Task();//no longer required } //no longer required //else //{ // vm.Tasks = obj; //} //Now show list of all the created tasks DbAccessLayer dl = new DbAccessLayer(); List <Task> TaskAll = dl.Tasks.ToList <Task>(); //vm.TaskList = TaskAll; //return View("EnterToDo", vm); //Now we are making jQuery post so no need of vm return(Json(TaskAll, JsonRequestBehavior.AllowGet));//return json result of task collections }