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