//Gets the todo Lists.
public JsonResult GetTodoLists(string ModId, string sidx, string sord, int page, int rows)
{
ASL_MENU aslMenuObj = new ASL_MENU();
aslMenuObj.MODULEID = ModId;
int pageIndex = Convert.ToInt32(page) - 1;
int pageSize = rows;
var todoListsResults = db.AslMenuDbSet
.Where(a => a.MODULEID == ModId )
.Select(
a => new
{
a.Id,
a.MENUID,
a.MENUNM,
});
int totalRecords = todoListsResults.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)rows);
if (sord.ToUpper() == "DESC")
{
todoListsResults = todoListsResults.OrderByDescending(s => s.MENUID);
todoListsResults = todoListsResults.Skip(pageIndex * pageSize).Take(pageSize);
}
else
{
todoListsResults = todoListsResults.OrderBy(s => s.MENUID);
todoListsResults = todoListsResults.Skip(pageIndex * pageSize).Take(pageSize);
}
var jsonData = new
{
total = totalPages,
page,
records = totalRecords,
rows = todoListsResults
};
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
public string Edit(string ModId, string MenuType, ASL_MENU objTodo)
{
string msg;
try
{
var query =
from a in db.AslMenuDbSet
where (a.MENUID == objTodo.MENUID)
select a;
foreach (ASL_MENU a in query)
{
// Insert any additional changes to column values.
a.MENUNM = objTodo.MENUNM;
}
db.SaveChanges();
msg = "" + objTodo.MENUNM + "update Successfully.";
}
catch (Exception ex)
{
msg = "Error occured:" + ex.Message;
}
return msg;
}
