public JsonResult BindProjects([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, int CompanyContactId = 0, int StatusId = 0, string StartDate = "", string EndDate = "", int DateType = 0) { try { int totalRecord = 0; int filteredRecord = 0; ProjectSession.ProjectsCompanyContactID = CompanyContactId; ProjectSession.ProjectsStatusId = StatusId; ProjectSession.ProjectsDateType = DateType; ProjectSession.ProjectsStartDate = StartDate; ProjectSession.ProjectsEndDate = EndDate; PageParam pageParam = new PageParam(); pageParam.Offset = requestModel.Start; pageParam.Limit = requestModel.Length; string Search = requestModel.Search.Value; pageParam.SortBy = requestModel.Columns.ElementAt(requestModel.OrderColumn).Data; pageParam.SortDirection = requestModel.OrderDir.ToUpper() == "DESC" ? "Descending" : "Ascending"; var model = abstractProjectsServices.ProjectsSelectAll(pageParam, Search, CompanyContactId, StatusId, StartDate, EndDate, DateType); totalRecord = (int)model.TotalRecords; filteredRecord = (int)model.TotalRecords; return(Json(new DataTablesResponse(requestModel.Draw, model.Values, filteredRecord, totalRecord), JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new object[] { Enums.MessageType.danger.GetHashCode(), Enums.MessageType.danger.ToString(), "Something Went Wrong" }, JsonRequestBehavior.AllowGet)); } }
public IList <SelectListItem> BindProjectDropdown() { PageParam pageParam = new PageParam(); pageParam.Offset = 0; pageParam.Limit = 0; var model = abstractProjectsServices.ProjectsSelectAll(pageParam, ""); List <SelectListItem> items = new List <SelectListItem>(); foreach (var category in model.Values) { items.Add(new SelectListItem() { Text = category.Name.ToString(), Value = category.Id.ToString() }); } return(items); }