public JsonResult FeesExpenseReport(FormCollection collection)
{
FeesExpenseModel model = new FeesExpenseModel();
this.TryUpdateModel(model, collection);
string error = string.Empty;
ResultModel resultModel = new ResultModel();
FlexigridData flexgridData = new FlexigridData();
int pageIndex = DataTypeHelper.ToInt32(collection["pageIndex"]);
int pageSize = DataTypeHelper.ToInt32(collection["pageSize"]);
string sortName = collection["sortName"];
string sortOrder = collection["sortOrder"];
int totalRows = 0;
if (ModelState.IsValid) {
List<FeesExpenseReportDetail> feesExpenses = ReportRepository.FindFeesExpenseReport(pageIndex, pageSize, sortName, sortOrder, ref totalRows, model.FundId, (model.StartDate ?? Convert.ToDateTime("01/01/1900")), (model.EndDate ?? DateTime.Now));
flexgridData.total = totalRows;
flexgridData.page = 1;
foreach (var feeExpense in feesExpenses) {
flexgridData.rows.Add(new FlexigridRow {
cell = new List<object> {
feeExpense.Date,
feeExpense.Type,
feeExpense.Amount,
feeExpense.Note
}
});
}
}
else {
foreach (var values in ModelState.Values.ToList()) {
foreach (var err in values.Errors.ToList()) {
if (string.IsNullOrEmpty(err.ErrorMessage) == false) {
error += err.ErrorMessage + "\n";
}
}
}
}
return Json(new { Error = error, Data = flexgridData, page = pageIndex, total = totalRows }, JsonRequestBehavior.AllowGet);
}
public ActionResult FeesExpense()
{
ViewData["MenuName"] = "ReportManagement";
ViewData["SubmenuName"] = "FeesExpense";
FeesExpenseModel model = new FeesExpenseModel();
return View(model);
}
