public async Task <JsonResult> Index(int Id = 0) { AssessmentStructureAssessmentTypeMappingViewModel collection = new AssessmentStructureAssessmentTypeMappingViewModel(); var draw = HttpContext.Request.Form["draw"].FirstOrDefault(); // Skiping number of Rows count var start = Request.Form["start"]; // Paging Length 10,20 var length = Request.Form["length"]; // Sort Column Name var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"]; // Sort Column Direction ( asc ,desc) var sortColumnDirection = Request.Form["order[0][dir]"]; // Search Value from (Search box) // var searchValue = Request.Form["search[value]"]; //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; collection.PageNo = skip; collection.PageSize = pageSize; collection.SortOrder = sortColumnDirection; collection.SortColumn = sortColumn; collection.AssessmentStructureID = Id; var stringContent = new StringContent(JsonConvert.SerializeObject(collection).ToString(), Encoding.UTF8, "application/json"); var list = await service.GetAssessmentStructureData(stringContent); if (list.Count > 0) { recordsTotal = list[0].RowCount; } // var data = list.Skip(skip).Take(pageSize).ToList(); return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = list })); }
/// <summary> /// Get All RoomMaster Data /// </summary> /// <param name="objAssessmentStructureAssessmentTypeMappingModel"></param> /// <returns></returns> public List <AssessmentStructureAssessmentTypeMappingViewModel> GetAssessmentStructureData(AssessmentStructureAssessmentTypeMappingViewModel objAssessmentStructureAssessmentTypeModel) { List <AssessmentStructureAssessmentTypeMappingViewModel> TableModelList = new List <AssessmentStructureAssessmentTypeMappingViewModel>(); GEEDbContext context = new GEEDbContext(); List <AssessmentStructureAssessmentTypeMappingViewModel> _roomMasterTableData = new List <AssessmentStructureAssessmentTypeMappingViewModel>(); var _data = (from ast in context.AssessmentTYPEs join mtl in context.MasterTables on ast.AssessmentGroup_ID equals mtl.MasterTable_id where ast.IsDeleted != true select new { AssessmentType_Id = ast.AssessmentType_Id, AssessmentType_code = ast.AssessmentType_code, AssessmentType_Name = ast.AssessmentType_Name, MinMarks = ast.MinMarks, MaxMarks = ast.MaxMarks, PassingMarks = ast.PassingMarks, Weightage = ast.Weightage, AssessmentGroup = mtl.Name }).ToList(); var _allddata = context.AssessmentStructureAssessmentTypeMappings.Where(f => f.IsDeleted == false && f.AssessmentStructureID == objAssessmentStructureAssessmentTypeModel.AssessmentStructureID); foreach (var itm in _data) { AssessmentStructureAssessmentTypeMappingViewModel model = new AssessmentStructureAssessmentTypeMappingViewModel(); model.AssessmentType_Id = itm.AssessmentType_Id; model.AssessmentType_code = itm.AssessmentType_code; model.AssessmentType_Name = itm.AssessmentType_Name; model.MinMarks = itm.MinMarks; model.MaxMarks = itm.MaxMarks; model.PassingMarks = itm.PassingMarks; model.Weightage = itm.Weightage; model.AssessmentGroup = itm.AssessmentGroup; var _modelcheck = _allddata.Where(g => g.AssessmentTypeID == itm.AssessmentType_Id); if (_modelcheck != null && _modelcheck.Count() > 0) { if (_modelcheck != null && _modelcheck.Count() > 0) { model.AssessmentStructureAssessmentTypeMapping_Id = _modelcheck.FirstOrDefault().AssessmentStructureAssessmentTypeMapping_Id; } } _roomMasterTableData.Add(model); } //Sorting if (!(string.IsNullOrEmpty(objAssessmentStructureAssessmentTypeModel.SortColumn) && string.IsNullOrEmpty(objAssessmentStructureAssessmentTypeModel.SortOrder))) { _roomMasterTableData = _roomMasterTableData.OrderBy(objAssessmentStructureAssessmentTypeModel.SortColumn + " " + objAssessmentStructureAssessmentTypeModel.SortOrder).ToList(); } int recordsTotal = _roomMasterTableData.Count(); var data = _roomMasterTableData.Skip(objAssessmentStructureAssessmentTypeModel.PageNo).Take(objAssessmentStructureAssessmentTypeModel.PageSize).ToList(); foreach (var item in data) { AssessmentStructureAssessmentTypeMappingViewModel AssessmentStructureAssessmentTypeModel = new AssessmentStructureAssessmentTypeMappingViewModel(); AssessmentStructureAssessmentTypeModel.AssessmentStructureAssessmentTypeMapping_Id = item.AssessmentStructureAssessmentTypeMapping_Id; AssessmentStructureAssessmentTypeModel.AssessmentType_Id = item.AssessmentType_Id; AssessmentStructureAssessmentTypeModel.AssessmentType_code = item.AssessmentType_code; AssessmentStructureAssessmentTypeModel.AssessmentType_Name = item.AssessmentType_Name; AssessmentStructureAssessmentTypeModel.MinMarks = item.MinMarks; AssessmentStructureAssessmentTypeModel.MaxMarks = item.MaxMarks; AssessmentStructureAssessmentTypeModel.PassingMarks = item.PassingMarks; AssessmentStructureAssessmentTypeModel.Weightage = item.Weightage; AssessmentStructureAssessmentTypeModel.AssessmentGroup = item.AssessmentGroup; AssessmentStructureAssessmentTypeModel.RowCount = recordsTotal; TableModelList.Add(AssessmentStructureAssessmentTypeModel); } return(TableModelList); }
public JsonResult <List <AssessmentStructureAssessmentTypeMappingViewModel> > GetAssessmentStructureData(AssessmentStructureAssessmentTypeMappingViewModel objAssessmentStructureAssessmentTypeMappingViewModel) { try { var record = _iAssessmentStructureAssessmentTypeMapping.GetAssessmentStructureData(objAssessmentStructureAssessmentTypeMappingViewModel); return(Json(record)); } catch (Exception ex) { Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString()); return(null); } }