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