public JsonResult DepositSummaryInfo(LoanManagementSystem.Models.sdtoViewReportFilter Filter)
{
Filter.DepositIds = GetList(Filter.DepositIds.FirstOrDefault());
Filter.AccountIds = GetList(Filter.AccountIds.FirstOrDefault());
Filter.LoanIds = GetList(Filter.LoanIds.FirstOrDefault());
Filter.MemberIds = GetList(Filter.MemberIds.FirstOrDefault());
Filter.StatusIds = GetList(Filter.StatusIds.FirstOrDefault());
sdtoUser sessionUser = UtilityHelper.UserSession.GetSession(UtilityHelper.UserSession.LoggedInUser) as sdtoUser;
long CompanyId = 0;
if (sessionUser != null && sessionUser.CompanyId != null)
CompanyId = sessionUser.CompanyId.Value;
DataTable dtRptParams = new DataTable();
dtRptParams.Columns.Add(new DataColumn("EntityId", typeof(long)));
dtRptParams.Columns.Add(new DataColumn("EntityStartDate", typeof(DateTime)));
dtRptParams.Columns.Add(new DataColumn("EntityEndDate", typeof(DateTime)));
dtRptParams.Columns.Add(new DataColumn("EntityIntVal", typeof(int)));
dtRptParams.Columns.Add(new DataColumn("EntityStrVal", typeof(string)));
dtRptParams.Columns.Add(new DataColumn("EntityType", typeof(string)));
foreach (string Id in Filter.MemberIds)
{
DataRow row = dtRptParams.NewRow();
row.ItemArray = new object[] { Id, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, "U" };
dtRptParams.Rows.Add(row);
}
foreach (string Id in Filter.DepositIds)
{
DataRow row = dtRptParams.NewRow();
row.ItemArray = new object[] { Id, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, "L" };
dtRptParams.Rows.Add(row);
}
foreach (string Id in Filter.StatusIds)
{
DataRow row = dtRptParams.NewRow();
row.ItemArray = new object[] { Id, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, "S" };
dtRptParams.Rows.Add(row);
}
DataRow rowDate = dtRptParams.NewRow();
rowDate.ItemArray = new object[] { 0, Filter.StartDate, Filter.EndDate, DBNull.Value, DBNull.Value, "D" };
dtRptParams.Rows.Add(rowDate);
DataRow rowMisc = dtRptParams.NewRow();
rowMisc.ItemArray = new object[] { 0, DBNull.Value, DBNull.Value, DBNull.Value, Filter.MiscFilter, "M" };
dtRptParams.Rows.Add(rowMisc);
bfReport objReport = new bfReport(null);
return Json(objReport.GetRptDepositSummary(CompanyId, dtRptParams), JsonRequestBehavior.AllowGet);
}
