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