public ActionResult NewAccount(NewAccountModel model)
{
EventLogHandler Logger = new EventLogHandler();
var sessionUser = Session["Username"] as string;
string Normal = "";
if (model.AccountType == "Asset" || model.AccountType == "Liability")
{
Normal = "Debit";
}
else
{
Normal = "Credit";
}
if (ModelState.IsValid)
{
using (IDbConnection db = new SqlConnection(SqlAccess.GetConnectionString()))
{
string sql = $"Insert into dbo.ChartOfAccounts (AccountNumber, AccountName, " +
"AccountType, NormalSide, OriginalBalance, CurrentBalance, AccountDescription, CreatedBy, Active, DateCreated)" +
"values(@AccountNumber, @AccountName, @AccountType,@NormalSide,@OriginalBalance," +
"@CurrentBalance,@AccountDescription,@CreatedBy,@Active,@Date)";
db.Execute(sql, new
{
AccountNumber = model.AccountNumber,
AccountName = model.AccountName,
AccountType = model.AccountType,
NormalSide = Normal,
OriginalBalance = model.OriginalBalance,
CurrentBalance = 0,
AccountDescription = model.AccountDescription,
CreatedBy = sessionUser,
Active = model.Active,
Date = DateTime.Now
});
}
TempData["Message"] = "A new account was successfully created!";
Logger.LogAdminCreateAccount(sessionUser, model.AccountName);
return(RedirectToAction("ChartOfAccounts"));
}
return(View("NewAccount", new NewAccountModel()));
}
