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