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
}