private CatSubCatJoinMast GetDetail(int subcatid)
{
CatSubCatJoinMast query = null;
try
{
query = _auditToolContext.SubCategory.Where(x => x.IsActive == true)
.Join(
_auditToolContext.Category,
subCategories => subCategories.CatgId,
categories => categories.CatgId,
(subCategories, categories) => new
{
CatgID = categories.CatgId,
SubCatID = subCategories.SubCatgId,
categories.CatgDescription,
subCategories.SubCatgDescription
})
.Select(x => new CatSubCatJoinMast
{
CatgID = x.CatgID,
SubCatgID = x.SubCatID,
CatgDescription = x.CatgDescription,
SubCatgDescription = x.SubCatgDescription
}
).Where(a => a.SubCatgID == subcatid).FirstOrDefault();
}
catch (Exception ex)
{
_logger.LogInformation($"Exception in GetDetail method");
_log.WriteErrorLog(new LogItem {
ErrorType = "Error", ErrorSource = "SubCategoryController_GetDetail", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message
});
}
return(query);
}
public IActionResult Details(CatSubCatJoinMast objCatSubCatJoinMast)
{
if (isAdmin)
{
try
{
var draw = HttpContext.Request.Form["draw"].FirstOrDefault();
// Skip number of Rows count
var start = Request.Form["start"].FirstOrDefault();
// Paging Length 10,20
var length = Request.Form["length"].FirstOrDefault();
// Sort Column Name
var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault();
// Sort Column Direction (asc, desc)
var sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault();
// Search Value from (Search box)
var searchValue = Request.Form["search[value]"].FirstOrDefault();
//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;
// getting all Customer data
var customerData = (from tempcustomer in GetDetails()
select tempcustomer);
//Sorting
if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDirection)))
{
switch (sortColumn)
{
case "SubCatgDescription":
if (sortColumnDirection == "desc")
{
customerData = customerData.OrderByDescending(s => s.SubCatgDescription);
}
else
{
customerData = customerData.OrderBy(s => s.SubCatgDescription);
}
break;
}
}
//Search
if (!string.IsNullOrEmpty(searchValue))
{
customerData = customerData.Where(m => m.SubCatgDescription.ToLower().StartsWith(searchValue.ToLower()));
}
//total number of rows counts
recordsTotal = customerData.Count();
//Paging
var jsonData = customerData.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new { draw, recordsFiltered = recordsTotal, recordsTotal, data = jsonData }));
}
catch (Exception ex)
{
_logger.LogInformation($"Exception in Details method");
_log.WriteErrorLog(new LogItem {
ErrorType = "Error", ErrorSource = "SubCategoryController_Details", ErrorDiscription = ex.InnerException != null ? ex.InnerException.ToString() : ex.Message
});
}
}
return(RedirectToAction("Index", "Home"));
}
