public ActionResult AddItem(string Task, string date, bool priority) { try { string check = ""; Nullable<System.DateTime> datetime; using (DatabaseEntities2 context = new DatabaseEntities2()) { int myID = context.Users.First(x => x.login == HttpContext.User.Identity.Name).Id; if (Task != check) { if (date != "") datetime = DateTime.Parse(date); else datetime = null; ToDoItem item = new ToDoItem(Task, datetime, priority, myID); context.ToDoItems.Add(item); context.SaveChanges(); } } return RedirectToAction("ActiveItemList"); } catch { return RedirectToAction("ActiveItemList"); } }
public PartialViewResult AddInerTask(int itemid, string tasktext) { List<AddTask> tasks; AddTask item; using (DatabaseEntities2 context = new DatabaseEntities2()) { item = new AddTask(itemid, tasktext); context.AddTasks.Add(item); context.SaveChanges(); tasks = context.AddTasks.Where(i => i.itemID == itemid).ToList(); } if (tasks.Count > 0) return PartialView("AddTasks", tasks); else return PartialView("AddTasks"); }
public ActionResult UploadFile(int id) { using (DatabaseEntities2 context = new DatabaseEntities2()) { HttpPostedFileBase file = Request.Files["upl"]; //bool isUploaded = false; string message = "File upload failed"; int length = file.ContentLength; string name = file.FileName; string type = file.ContentType; try { using (BinaryReader reader = new BinaryReader(file.InputStream)) { context.Files.Add(new Models.File(id, reader.ReadBytes(file.ContentLength), name, type, DateTime.Now)); context.SaveChanges(); } //isUploaded = true; message = "File uploaded successfully!"; } catch (Exception ex) { message = string.Format("File upload failed: {0}", ex.Message); } return RedirectToAction("Files", new { id = id }); } }
public void RingTime(int itemid, string time) { using (DatabaseEntities2 context = new DatabaseEntities2()) { if (time != "") context.ToDoItems.First(i => i.Id == itemid).RememberTime = DateTime.Parse(time); else context.ToDoItems.First(i => i.Id == itemid).RememberTime = null; context.SaveChanges(); } }
public void UnfinishTask(int id) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = false; context.SaveChanges(); } } catch { return; } }
public JsonResult Mark(int id, bool check) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { if (check) context.ToDoItems.FirstOrDefault(i => i.Id == id).Mark = false; else context.ToDoItems.FirstOrDefault(i => i.Id == id).Mark = true; context.SaveChanges(); } return Json(new { marked = !check }); } catch { return Json(new { marked = check }); } }
public void NoteEdit(int itemid, string notext) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { context.ToDoItems.First(i => i.Id == itemid).Note = notext; context.SaveChanges(); } } catch { return; } }
public PartialViewResult FinishTask(int id) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = true; context.SaveChanges(); } return PartialView("_Item"); } catch { return PartialView("_Item"); } }
public void FinishTime(int itemid, string time) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { if (time != "") context.ToDoItems.First(i => i.Id == itemid).FinishTime = DateTime.Parse(time); else context.ToDoItems.First(i => i.Id == itemid).FinishTime = null; context.SaveChanges(); } } catch { return; } }
public void DeleteInerTask(int id) { using (DatabaseEntities2 context = new DatabaseEntities2()) { context.AddTasks.Remove(context.AddTasks.First(i => i.Id == id)); context.SaveChanges(); } }
public void DeleteFile(int id) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { context.Files.Remove(context.Files.First(i => i.Id == id)); context.SaveChanges(); } } catch { return; } }
public void Delete(int id) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { context.ToDoItems.Remove(context.ToDoItems.First(itemId => itemId.Id == id)); context.SaveChanges(); } } catch { return; } }
public void CompleteInerTask(string taskid, bool completed) { int id; try { id = int.Parse(taskid); using (DatabaseEntities2 context = new DatabaseEntities2()) { if (completed) context.AddTasks.First(i => i.Id == id).isComplete = false; else context.AddTasks.First(i => i.Id == id).isComplete = true; context.SaveChanges(); } } catch { return; } }
public JsonResult Complete(int id, bool check) { try { using (DatabaseEntities2 context = new DatabaseEntities2()) { if (check) context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = false; else { context.ToDoItems.FirstOrDefault(i => i.Id == id).isComplete = true; foreach (var item in context.AddTasks.Where(i => i.itemID == id)) { if (item!=null) item.isComplete = true; } } context.SaveChanges(); } return Json(new { id = id, complete = !check }); } catch { return Json(new { }); } }