/// <summary> /// Get ToDo List Against Current User /// </summary> /// <returns></returns> public ActionResult GetUserToDoList() { try { var userId = User.Identity.GetUserId(); using (UserToDoAppDBEntities et = new UserToDoAppDBEntities()) { var data = et.UserToDoLists .Where(x => x.utd_created_by == userId) .Select(x => new UserToDoListVm { utd_id = x.utd_id, utd_order = x.utd_order, utd_title = x.utd_title, utd_priority = x.utd_priority, utd_date = x.utd_date }).OrderBy(x => x.utd_order).ToList() .Select(x => new UserToDoListVm { utd_id = x.utd_id, utd_order = x.utd_order, utd_title = x.utd_title, utd_priority = x.utd_priority, date = (x.utd_date.HasValue) ? x.utd_date.Value.ToString("yyyy-MM-dd") : null }); return Json(new { key = true, message = "Success", data }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(new { key = false, message = ex.Message }, JsonRequestBehavior.AllowGet); } }
public ActionResult AddToDoInList(UserToDoListVm vm) { try { var userId = User.Identity.GetUserId(); using (UserToDoAppDBEntities et = new UserToDoAppDBEntities()) { var model = new UserToDoList { utd_order = vm.utd_order, utd_title = vm.utd_title, utd_priority = vm.utd_priority, utd_date = vm.utd_date, utd_created_date = System.DateTime.Now, utd_created_by = userId }; et.UserToDoLists.Add(model); et.SaveChanges(); } return Json(new { key = true, message = "Success", }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(new { key = false, message = ex.Message }, JsonRequestBehavior.AllowGet); } }
public JsonResult DeleteToDoFromList(int id) { try { var userId = User.Identity.GetUserId(); using (UserToDoAppDBEntities et = new UserToDoAppDBEntities()) { var data = et.UserToDoLists.FirstOrDefault(c => c.utd_id == id); if (data != null) { et.UserToDoLists.Remove(data); et.SaveChanges(); } var userToDos = et.UserToDoLists.Where(x => x.utd_created_by == userId); if (userToDos != null) { var userToDoIds = userToDos.OrderBy(x => x.utd_order).Select(x => x.utd_id); var order = 1; foreach (var item in userToDoIds) { var toDo = et.UserToDoLists.Where(x => x.utd_id == item).FirstOrDefault(); toDo.utd_order = order++; et.Entry(toDo).State = System.Data.Entity.EntityState.Modified; } } et.SaveChanges(); } return Json(new { key = true, message = "Success", }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { return Json(new { key = false, message = ex.Message }, JsonRequestBehavior.AllowGet); } }
public JsonResult UpdateRowsOrderOnDownKey(int curId, int curOrder, int nextId, int nextOrder) { try { using (UserToDoAppDBEntities et = new UserToDoAppDBEntities()) { var curData = et.UserToDoLists.Where(x => x.utd_id == curId); if (curData != null) { var data = curData.FirstOrDefault(); curOrder = curOrder + 1; data.utd_order = curOrder; et.Entry(data).State = System.Data.Entity.EntityState.Modified; et.SaveChanges(); } var prevData = et.UserToDoLists.Where(x => x.utd_id == nextId); if (prevData != null) { var data = prevData.FirstOrDefault(); nextOrder = nextOrder - 1; data.utd_order = nextOrder; et.Entry(data).State = System.Data.Entity.EntityState.Modified; et.SaveChanges(); } return Json(new { key = true, message = "Success", }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { return Json(new { key = false, message = ex.Message }, JsonRequestBehavior.AllowGet); } }
//public object ModulePermission; private DataAccess() { var tmp = new ConnectionStringBuilder(System.Configuration.ConfigurationManager.ConnectionStrings["UserToDoAppConnection"].ConnectionString); _ctx = new UserToDoAppDBEntities(tmp.UserToDoAPPString); // temporarily dissabling the EF entity validation - it should be removed in the next code sync. _ctx.Configuration.ValidateOnSaveEnabled = false; }
public void Dispose() { if (self != null) { //DataAccess.Instance.Dispose(); const string kApplicationSettings = "ApplicationObject"; var context = HttpContext.Current; if (context != null && context.Items[kApplicationSettings] != null) { context.Items[kApplicationSettings] = null; } _ctx.Dispose(); _ctx = null; GC.SuppressFinalize(this); self = null; } }