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 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 void Save()
{
_ctx.SaveChanges();
}