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);
}
public void InitiateMemberAccounts(LoanManagementSystem.Models.sdtoUser Member)
{
try
{
sdtoSettings settings = AppDb.GeneralSettings.FirstOrDefault();
sdtoAccountType accTypeDebiter = AppDb.AccountTypes.Where(x => x.UniqueName.Equals("Debiter", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
var accHead = new sdtoAccountHead()
{
AccountCode = "ACH_" + Member.Code,
AccountName = "AC_" + Member.Code,
ScheduleId = settings.SundryDebtorAccountId.Value,
AccountTypeId = accTypeDebiter.AccountTypeId,
CreditLimit = 0,
CreditDays = 0,
TIN = string.Empty,
CST = string.Empty,
AddressId = Member.UserAddressId.Value,
ContactId = Member.UserContactId.Value,
CreatedBy = Member.UserID,
CreatedOn = DateTime.Now,
IsDeleted = false
};
AppDb.AccountHeads.Add(accHead);
AppDb.SaveChanges();
Member.AccountHeadId = accHead.AccountHeadId;
Member.ModifiedOn = DateTime.Now;
Member.ModifiedBy = Member.UserID;
AppDb.Entry(Member).State = EntityState.Modified;
AppDb.SaveChanges();
sdtoOpeningBalance memberOpeniningBalance = new sdtoOpeningBalance()
{
AccountHeadId = accHead.AccountHeadId,
ClosingBalance = 0,
CreditOpeningBalance = 0,
DebitOpeningBalance = 0,
FinancialYearId = 1,
ScheduleId = settings.SundryDebtorAccountId.Value,
IsDeleted = false,
CreatedBy = Member.UserID,
CreatedOn = DateTime.Now
};
AppDb.OpeningBalance.Add(memberOpeniningBalance);
AppDb.SaveChanges();
}
catch (Exception)
{
}
finally
{
}
}
