public ActionResult EditRole(string Id, string Name) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { Employer.Employer employer = new Employer.Employer(); DataTable dt = employer.FetchViews(userkey, uid); dt.TableName = "AdminViews"; dt.Columns.ToString(); var adminViews = (from DataRow dr in dt.Rows select new AdminViews() { ID = dr["MenuID"].ToString(), MenuName = dr["MenuName"].ToString(), ControllerName = dr["Controller"].ToString(), ActionName = dr["Action"].ToString(), }).ToList(); ViewData.Model = adminViews; ViewBag.ParentId = adminViews; return(View()); } catch (Exception ex) { LogError logerror = new LogError(); logerror.ErrorLog("", LoginUser, "", "AdminViews/EditRole", "AdminViews", "EditRole", "FetchViews Error", ex.Message.ToString(), 0); TempData["error"] = ex.Message.ToString(); ViewBag.Error = TempData["error"]; return(View()); } }
public JsonResult GetAllViews() { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; Employer.Employer employer = new Employer.Employer(); DataTable dt = employer.FetchViews(userkey, uid); dt.TableName = "AdminViews"; dt.Columns.ToString(); var adminViews = (from DataRow dr in dt.Rows select new AdminViews() { ID = dr["MenuID"].ToString(), MenuName = dr["MenuName"].ToString(), ControllerName = dr["Controller"].ToString(), ActionName = dr["Action"].ToString(), }).ToList(); return(Json(new { data = adminViews }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAdminViews([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { Employer.Employer employer = new Employer.Employer(); DataTable dt = employer.FetchViews(userkey, uid); dt.TableName = "AdminViews"; dt.Columns.ToString(); List <AdminViews> adminViews = new List <AdminViews>(); int startRec = requestModel.Start; int pageSize = requestModel.Length; List <AdminViews> viewsCount = (from DataRow dr in dt.Rows select new AdminViews() { MenuName = dr["MenuName"].ToString() }).ToList(); adminViews = (from DataRow dr in dt.Rows select new AdminViews() { MenuName = dr["MenuName"].ToString(), ControllerName = dr["Controller"].ToString(), ActionName = dr["Action"].ToString(), }).Skip(startRec).Take(pageSize).ToList(); var totalCount = viewsCount.Count(); var filteredCount = adminViews.Count(); /*if (requestModel.Search.Value != string.Empty) * { * var value = requestModel.Search.Value.Trim(); * * employeeCount = (from DataRow dr in dt.Rows * where dr["P_I_N"].ToString().ToString().Contains(value) || dr["First Name"].ToString().Contains(value) || dr["Last Name"].ToString().Contains(value) || dr["Phone No"].ToString().Contains(value) || dr["E-mail"].ToString().Contains(value) || select new CompanyEmployee() || { || PIN = dr["P_I_N"].ToString() || }).ToList(); || || companyEmployee = (from DataRow dr in dt.Rows || where dr["P_I_N"].ToString().ToString().Contains(value) || dr["First Name"].ToString().Contains(value) || dr["Last Name"].ToString().Contains(value) || dr["Phone No"].ToString().Contains(value) || dr["E-mail"].ToString().Contains(value) || select new CompanyEmployee() || { || PIN = dr["P_I_N"].ToString(), || FirstName = dr["First Name"].ToString(), || LastName = dr["Last Name"].ToString(), || MiddleName = dr["Middle Names"].ToString(), || PhoneNo = dr["Mobile 1"].ToString(), || DateOfBirth = dr["Date Of Birth"].ToString(), || DateOfEmployment = dr["Date Of Employment"].ToString(), || Email = dr["E-mail"].ToString(), || }).Skip(startRec).Take(pageSize).ToList(); || || totalCount = employeeCount.Count(); || filteredCount = companyEmployee.Count(); ||}*/ var sortedColumns = requestModel.Columns.GetSortedColumns(); var orderByString = String.Empty; foreach (var column in sortedColumns) { orderByString += orderByString != String.Empty ? "," : ""; orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc"); } var data = adminViews.Select(emList => new { MenuName = emList.MenuName, ControllerName = emList.ControllerName, ActionName = emList.ActionName }).ToList(); return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { LogError logerror = new LogError(); logerror.ErrorLog("", LoginUser, "", "AdminViewsController/GetAdminViews", "AdminViewsController", "GetAdminViews", "FetchViews Error", ex.Message.ToString(), 0); throw new Exception(ex.Message.ToString()); } }