public ActionResult UpdateOpeningBalance(sdtoOpeningBalance OpeningBalance, long PrevDebit, long PrevCredit) { if (ModelState.IsValid) { sdtoUser session = UtilityHelper.UserSession.GetSession(UtilityHelper.UserSession.LoggedInUser) as sdtoUser; if (session != null) OpeningBalance.ModifiedBy = session.UserID; OpeningBalance.ModifiedOn = DateTime.Now; OpeningBalance.ClosingBalance = (OpeningBalance.ClosingBalance - (PrevDebit > 0 ? PrevDebit : PrevCredit)) + (OpeningBalance.CreditOpeningBalance > 0 ? (-1 * OpeningBalance.CreditOpeningBalance) : OpeningBalance.DebitOpeningBalance); // ModelState.AddModelError("ProfileImage", "This field is required"); db.Entry(OpeningBalance).State = EntityState.Modified; db.SaveChanges(); if (User.Identity.IsAuthenticated) return RedirectToAction("Index"); else return RedirectToAction("Login", "Login"); } LoadSelectListOpeningBalance(OpeningBalance.AccountHeadId, OpeningBalance.ScheduleId, OpeningBalance.FinancialYearId); return View(); }
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 { } }