// GET: TaskList/Details/5
public ActionResult Details(int id)
{
List <myTask> taskList = TaskDB.getAllTasks();
myTask selectedTask = taskList.Find(x => x.Id == id);
return(View(selectedTask));
}
public IHttpActionResult DeleteTask(int id)
{
myTask task = db.myTasks.Find(id);
if (task == null)
{
return(NotFound());
}
db.myTasks.Remove(task);
db.SaveChanges();
return(Ok(task));
}
public async Task <bool> InsertTask(TaskRequest task)
{
var myTask = new myTask
{
taskDescription = task.taskDescription,
Status = task.Status
};
_db.Task.Add(myTask);
await _db.SaveChangesAsync();
return(true);
}
//class to add tasks to the list
public static bool AddTask(myTask taskItem)
{
try
{
SqlConnection conn = new SqlConnection(ConnectionString);
conn.Open();
string sql = $"insert into Task (Name,DueDate,Status) values ('{taskItem.Name}','{taskItem.DueDate}','{taskItem.Status}')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();// closes the connection with database
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Create(FormCollection collection)
{
try
{
// TODO: Add insert logic here
myTask taskItem = new myTask();
taskItem.Name = collection["Name"];
taskItem.DueDate = Convert.ToDateTime(collection["DueDate"]);
taskItem.Status = collection["Status"];
TaskDB.AddTask(taskItem);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
// PUT api/Task/5
public IHttpActionResult PutTask(int id, myTask task)
{
db.Entry(task).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!myTaskExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Edit(int id, FormCollection collection)
{
try
{
// TODO: Add update logic here
//Creates object mytask and adds task information
myTask taskItem = new myTask();
taskItem.Name = collection["Name"];
taskItem.DueDate = Convert.ToDateTime(collection["DueDate"]);
taskItem.Status = collection["Status"];
TaskDB.AddTask(taskItem);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public IHttpActionResult PostTask(myTask task)
{
db.myTasks.Add(task);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = task.taskId }, task));
}
