public new GeneralLedgerSetting GetGeneralLedgerSetting()
{
GeneralLedgerSetting glSetting = null;
glSetting = _glSettingRepo.Table.FirstOrDefault();
return(glSetting);
}
public IActionResult SaveSettings(GeneralLedgerSetting model)
{
if (ModelState.IsValid)
{
}
ViewBag.Accounts = Models.SelectListItemHelper.Accounts();
ViewBag.PageContentHeader = "Setup and Configuration";
return(RedirectToAction(nameof(AdministrationController.Settings)));
}
public void SaveGeneralLedgerSetting(GeneralLedgerSetting setting)
{
if (setting.Id == 0)
{
_glSettingRepo.Insert(setting);
}
else
{
_glSettingRepo.Update(setting);
}
}
public IActionResult Settings()
{
ViewBag.PageContentHeader = "Setup and Configuration";
ViewBag.Accounts = Models.SelectListItemHelper.Accounts();
var model = GetAsync <GeneralLedgerSetting>("administration/settings").Result;
if (model == null)
{
model = new GeneralLedgerSetting();
}
return(View(model));
}
GeneralLedgerSetting InitGeneralLedgerSetting()
{
var glSetting = new GeneralLedgerSetting()
{
GoodsReceiptNoteClearingAccount = _coa.Where(a => a.AccountCode == AccountCodes.GoodsReceiptNoteClearing_10810).FirstOrDefault(),
ShippingChargeAccount = _coa.Where(a => a.AccountCode == AccountCodes.ShippingCharge_40500).FirstOrDefault(),
SalesDiscountAccount = _coa.Where(a => a.AccountCode == AccountCodes.SalesDiscount_40400).FirstOrDefault(),
};
_context.GeneralLedgerSettings.Add(glSetting);
_context.SaveChanges();
return(glSetting);
}
public GeneralLedgerSetting GetGeneralLedgerSetting(int?companyId = null)
{
GeneralLedgerSetting glSetting = null;
if (companyId == null)
{
glSetting = _glSettingRepo.Table.FirstOrDefault();
}
else
{
glSetting = _glSettingRepo.Table.Where(s => s.CompanyId == companyId).FirstOrDefault();
}
return(glSetting);
}
public static GeneralLedgerSetting InitGeneralLedgerSetting()
{
var glSetting = new GeneralLedgerSetting()
{
Company = _context.Companies.FirstOrDefault(),
GoodsReceiptNoteClearingAccount = _context.Accounts.Where(a => a.AccountCode == "10810").FirstOrDefault(),
ShippingChargeAccount = _context.Accounts.Where(a => a.AccountCode == "40500").FirstOrDefault(),
SalesDiscountAccount = _context.Accounts.Where(a => a.AccountCode == "40400").FirstOrDefault(),
};
_context.GeneralLedgerSettings.Add(glSetting);
_context.SaveChanges();
return(glSetting);
}
public void DoIt()
{
if (_context.AuditableEntities.Count() == 0)
{
InitEntityToAudit();
}
if (_context.AccountClasses.Count() == 0)
{
InitAccountClasses();
}
if (_context.SecurityGroups.Count() == 0)
{
InitSecurityGroupAndSecurityRole();
}
var companies = InitCompanies();
foreach (var company in companies)
{
//MockAppPrincipal(0, company.Id, "Joe", "Blog", "JoeBlog");
_context.AppPrincipal.SetPrincipal(_appPrincipal.UserId, _appPrincipal.Username, _appPrincipal.Firstname, _appPrincipal.Surname, company.Id);
InitUsers();
FinancialYear fy = InitFiscalYear();
List <PaymentTerm> paymentTerms = InitPaymentTerms(company.Id);
_coa = InitChartOfAccounts();
GeneralLedgerSetting glSetting = InitGeneralLedgerSetting();
_taxGroups = InitTaxGroup();
List <Bank> banks = InitBanks();
_vendors = InitVendors();
_customers = InitCustomer();
_items = InitItems();
}
_context.AppPrincipal = _appPrincipal;
}
private void InitGeneralLedgerSetting()
{
var glSetting = new GeneralLedgerSetting()
{
Company = _context.Companies.FirstOrDefault(),
GoodsReceiptNoteClearingAccount = _context.Accounts.Where(a => a.AccountCode == "10810").FirstOrDefault(),
ShippingChargeAccount = _context.Accounts.Where(a => a.AccountCode == "40500").FirstOrDefault(),
SalesDiscountAccount = _context.Accounts.Where(a => a.AccountCode == "40400").FirstOrDefault(),
CreatedBy = "System",
CreatedOn = DateTime.Now,
ModifiedBy = "System",
ModifiedOn = DateTime.Now
};
_context.GeneralLedgerSettings.Add(glSetting);
_context.SaveChanges();
}
public void UpdateGeneralLedgerSetting(GeneralLedgerSetting setting)
{
_glSettingRepo.Update(setting);
}
public static void Initialize()
{
try
{
using (_context = new ApplicationContext())
{
if (_context.AuditableEntities.Count() == 0)
{
InitializeEntityToAudit();
}
if (string.IsNullOrEmpty(_filename))
{
_filename = AppDomain.CurrentDomain.BaseDirectory + "/App_Data/coa.csv";
}
//DbInitializerHelper.InsertAdminUser();
if (_context.Users.Count() == 0)
{
DbInitializerHelper.InitialUserAndSecurityModel();
}
Company company = null;
if (_context.Companies.Count() == 0)
{
company = DbInitializerHelper.CreateDefaultCompany();
}
else
{
company = _context.Companies.FirstOrDefault();
}
FinancialYear fy = null;
if (_context.FiscalYears.Count() == 0)
{
fy = InitFiscalYear();
}
List <PaymentTerm> paymentTerms = null;
if (_context.PaymentTerms.Count() == 0)
{
paymentTerms = InitPaymentTerms();
}
if (_context.AccountClasses.Count() == 0)
{
DbInitializerHelper.InitializeAccountClasses();
}
if (_context.Accounts.Count() == 0)
{
DbInitializerHelper.LoadChartOfAccountsFromFile(_filename, company.Id);
DbInitializerHelper.UpdateAccountsParentCodes(_filename);
}
GeneralLedgerSetting glSetting = null;
if (_context.GeneralLedgerSettings.Count() == 0)
{
glSetting = InitGeneralLedgerSetting();
}
if (_context.Taxes.Count() == 0)
{
DbInitializerHelper.InitTax();
}
List <Bank> banks = null;
if (_context.Banks.Count() == 0)
{
banks = InitBanks();
}
Vendor vendor = null;
if (_context.Vendors.Count() == 0)
{
vendor = DbInitializerHelper.InitVendor();
}
Customer customer = null;
if (_context.Customers.Count() == 0)
{
customer = DbInitializerHelper.InitCustomer();
}
List <Item> items = null;
if (_context.Items.Count() == 0)
{
items = InitItems();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_context.Dispose();
}
}
