public IActionResult LoadLoanTableData()
{
var draw = Request.Form["draw"].FirstOrDefault();
var start = Request.Form["start"].FirstOrDefault();
var length = Request.Form["length"].FirstOrDefault();
var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"].FirstOrDefault();
var sortColumnDir = Request.Form["order[0][dir]"].FirstOrDefault();
var searchValue = Request.Form["search[value]"].FirstOrDefault();
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int recordsTotal = 0;
var AllLoans = db.Loan.GetAll().Where(d => d.IsActive == true && d.IsDeleted == false);
List <vmLoan> LoanList = new List <vmLoan>();
//Sorting
if (!string.IsNullOrEmpty(sortColumn) && !string.IsNullOrEmpty(sortColumnDir))
{
// AllLoans = AllLoans.AsQueryable().OrderBy(sortColumn + " " + sortColumnDir).ToList();
}
else
{
AllLoans = AllLoans.OrderByDescending(model => model.Id).ToList();
}
//Search
if (!string.IsNullOrEmpty(searchValue))
{
AllLoans = AllLoans.Where(model => model.Name.Contains(searchValue) || model.LoanType.Contains(searchValue) ||
model.CalculationMethod.Contains(searchValue) || model.EligiblePerson.Contains(searchValue)).ToList();
}
foreach (var Items in AllLoans)
{
vmLoan getData = new vmLoan();
getData.Id = Items.Id;
getData.Name = Items.Name;
getData.LoanType = Items.LoanType;
getData.CalculationMethod = Items.CalculationMethod;
getData.EligiblePerson = Items.EligiblePerson;
getData.Percentage = Items.Percentage;
getData.SalaryBreakup = Items.SalaryBreakup;
LoanList.Add(getData);
}
//total number of rows count
recordsTotal = LoanList.Count();
//Paging
var data = LoanList.Skip(skip).Take(pageSize).ToList();
//Returning Json Data
return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data }));
}
public IActionResult UpdateLoan(vmLoan modelData)
{
var getLoan = db.Loan.Get(modelData.Id);
if (getLoan != null)
{
getLoan.Name = modelData.Name;
getLoan.LoanType = modelData.LoanType;
getLoan.CalculationMethod = modelData.CalculationMethod;
getLoan.EligiblePerson = modelData.EligiblePerson;
getLoan.Percentage = modelData.Percentage;
getLoan.SalaryBreakup = modelData.SalaryBreakup;
db.Save();
return(Json("success"));
}
return(Json("error"));
}
public IActionResult Create(vmLoan modelData)
{
if (ModelState.IsValid)
{
Loan loan = new Loan
{
Name = modelData.Name,
LoanType = modelData.LoanType,
CalculationMethod = modelData.CalculationMethod,
EligiblePerson = modelData.EligiblePerson,
Percentage = modelData.Percentage,
SalaryBreakup = modelData.SalaryBreakup
};
db.Loan.Add(loan);
db.Save();
ModelState.Clear();
}
return(Json(true));
}
