public string GetCategory(GlAccountManagement gl)
{
var acctcode = gl.AccCode.ToString();
if (acctcode.StartsWith("1"))
{
return("Asset");
}
else if (acctcode.StartsWith("2"))
{
return("Liability");
}
else if (acctcode.StartsWith("3"))
{
return("Capital");
}
else if (acctcode.StartsWith("4"))
{
return("Income");
}
else if (acctcode.StartsWith("5"))
{
return("Expenses");
}
else
{
return("");
}
}
public ActionResult Create(TellerManagement teller)
{
teller.userId = Convert.ToInt32(Request.Form["Users"]);
teller.AccountManagementId = Convert.ToInt32(Request.Form["Account"]);
teller.Date = DateTime.Now.ToString();
var user = new User();
var glAccount = new GlAccountManagement();
var id = Convert.ToInt32(teller.userId);
var userInDb = _user.Get(id);
var glAccountInDb = Accountcontext.Get(teller.AccountManagementId);
//Updating userassigned
userInDb.UserAssigned = true;
_user.Update(user);
//Updating AccountAssigned
glAccountInDb.AccountAssigned = true;
Accountcontext.Update(glAccount);
//Adding into database
TellerContext.Add(teller);
//saving for teller
TellerContext.Save(teller);
return(RedirectToAction("Index", "TellerManagement"));
//return View(viewmodel);
}
public bool CreditGlAccount(decimal amount, GlAccountManagement account)
{
var acctCode = GetFirstAcc(account);
switch (acctCode)
{
case "1":
case "5":
account.AccountBalance -= amount;
_context.Entry(account).State = EntityState.Modified;
_context.SaveChanges();
break;
case "2":
case "3":
case "4":
account.AccountBalance += amount;
_context.Entry(account).State = EntityState.Modified;
_context.SaveChanges();
break;
}
//Logging Values
_transaction.Log(account, amount, TransactionType.Credit);
return(true);
}
public void Log(GlAccountManagement gl, decimal amount, TransactionType type)
{
var transaction = new TransactionsLog
{
Name = gl.Name,
Amount = amount,
Type = type,
AccountCode = gl.AccCode,
date = DateTime.Now,
MainAccountCategory = GetCategory(gl)
};
_context.Add(transaction);
_context.Save(transaction);
}
public List <GlAccountManagement> GetAllCapitalAccounts()
{
var capitalAccounts = _glAccount.GetMainAccountCat("Capital").ToList();
var totalIncomeGl = _glAccount.GetMainAccountCat("Income").Sum(a => a.AccountBalance);
var toatlExpenseGl = _glAccount.GetMainAccountCat("Expenses").Sum(a => a.AccountBalance);
var CapitalAcctSum = new GlAccountManagement
{
Name = "Reserve Capital Accounts",
AccountBalance = totalIncomeGl - toatlExpenseGl
};
capitalAccounts.Add(CapitalAcctSum);
return(capitalAccounts);
}
public List <GlAccountManagement> GetAllAssetAccounts()
{
var assetAccounts = _glAccount.GetMainAccountCat("Asset").ToList();
var loanAssetAcct = new GlAccountManagement
{
Name = "Loan Accounts"
};
var loanAccounts = _customerAccount.GetLoanAccounts();
foreach (var account in loanAccounts)
{
loanAssetAcct.AccountBalance += account.Balance;
}
assetAccounts.Add(loanAssetAcct);
return(assetAccounts);
}
public bool DebitPost(decimal amount, GlAccountManagement account, string acctcode)
{
switch (acctcode)
{
case "1":
case "5":
account.AccountBalance += amount;
break;
case "2":
case "3":
case "4":
account.AccountBalance -= amount;
break;
}
return(true);
}
public List <GlAccountManagement> GetAllLiabilityAccounts()
{
var liabilityAccounts = _glAccount.GetMainAccountCat("Liability").ToList();
var totalSavingsAccount = _customerAccount.GetByAccountType(AccountType.Savings).Sum(a => a.Balance);
var totalCurrentAccount = _customerAccount.GetByAccountType(AccountType.Current).Sum(a => a.Balance);
var SavingsLiabilityAccount = new GlAccountManagement
{
Name = "Savings Liability Account",
AccountBalance = totalSavingsAccount
};
var CurrentLiabilityAccount = new GlAccountManagement
{
Name = "Current Liability Account",
AccountBalance = totalCurrentAccount
};
liabilityAccounts.Add(SavingsLiabilityAccount);
liabilityAccounts.Add(CurrentLiabilityAccount);
return(liabilityAccounts);
}
public string GetFirstAcc(GlAccountManagement gl)
{
var result = gl.AccCode.ToString()[0].ToString();
return(result);
}
