public void UpdateTask(Task task)
{
using (SqlConnection cn = new SqlConnection(_connectionString))
{
cn.Open();
cn.Execute("update Tasks set TaskName = @TaskName, PromptForDetails = @PromptForDetails where TaskID = @TaskID",
new { task.TaskName, task.PromptForDetails, task.TaskID });
cn.Close();
}
}
public void CreateTask(Task task)
{
using (SqlConnection cn = new SqlConnection(_connectionString))
{
cn.Open();
cn.Execute("insert into Tasks (TaskName, PromptForDetails) values (@TaskName, @PromptForDetails)",
new { task.TaskName, task.PromptForDetails });
cn.Close();
}
}
public ActionResult Edit(Task task)
{
try
{
new TaskDB().UpdateTask(task);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult Delete(Task task)
{
try
{
new TaskDB().DeleteTask(task);
return RedirectToAction("Index");
}
catch (Exception e)
{
ViewBag.ErrorText = e.Message;
return View(task);
}
}
public ActionResult Create(Task task)
{
try
{
new TaskDB().CreateTask(task);
return RedirectToAction("Index");
}
catch
{
return View(task);
}
}
public void DeleteTask(Task task)
{
using (SqlConnection cn = new SqlConnection(_connectionString))
{
cn.Open();
//check to make sure the task is not used.
if (cn.Query("select * from TaskLogEntries where TaskID = @TaskID", new { task.TaskID }).Any())
{
cn.Close();
throw new Exception(String.Format("Unable to delete the task, {0} because it is used by task log entries.", task.TaskName));
}
//delete the task
cn.Execute("delete from Tasks where TaskID = @TaskID", new { task.TaskID });
cn.Close();
}
}