private static void SeedSystemLookup(AccountingDatabaseService context)
{
var lookup = new [] {
new SystemLookup {
Id = 10, Type = "Cost center", Value = "Production", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new SystemLookup {
Id = 11, Type = "Cost center", Value = "Manufacturing", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new SystemLookup {
Id = 12, Type = "Cost center", Value = "Maintainance", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new SystemLookup {
Id = 14, Type = "Country", Value = "Ethiopia", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new SystemLookup {
Id = 15, Type = "lookup_category", Value = "Cost center", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new SystemLookup {
Id = 16, Type = "lookup_category", Value = "countries", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
}
};
context.SystemLookup.AddRange(lookup);
context.Save();
}
public Startup(IConfiguration configuration)
{
Configuration = configuration;
using (var context = new AccountingDatabaseService()) {
context.Database.EnsureCreated();
}
}
public static void Initialize(AccountingDatabaseService context)
{
if (context.Ledger.Any())
{
return;
}
SeedLedger(context);
SeedSystemLookup(context);
SeedAccounts(context);
}
private static void SeedLedger(AccountingDatabaseService context)
{
var ledger = new [] {
new Ledger {
Id = 10, Description = "ledger 1", VoucherId = "JV/001", Reference = "CH--001", IsPosted = 1, Date = DateTime.Now, DateUpdated = DateTime.Now,
LedgerEntry = new List <LedgerEntry> ()
{
new LedgerEntry()
{
Id = 20, LedgerId = 10, Credit = 100, Debit = 0, DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new LedgerEntry()
{
Id = 21, LedgerId = 10, Credit = 0, Debit = 100, DateAdded = DateTime.Now, DateUpdated = DateTime.Now
}
}
},
new Ledger {
Id = 11, Description = "ledger 2", VoucherId = "JV/002", Reference = "CH--002", IsPosted = 0, Date = DateTime.Now, DateUpdated = DateTime.Now,
LedgerEntry = new List <LedgerEntry> ()
{
new LedgerEntry()
{
Id = 22, LedgerId = 11, Credit = 100, Debit = 0, DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new LedgerEntry()
{
Id = 23, LedgerId = 11, Credit = 0, Debit = 100, DateAdded = DateTime.Now, DateUpdated = DateTime.Now
}
}
},
new Ledger {
Id = 13, Description = "ledger 3", VoucherId = "JV/003", Reference = "CH--003", IsPosted = 1, Date = DateTime.Now, DateUpdated = DateTime.Now,
LedgerEntry = new List <LedgerEntry> ()
{
new LedgerEntry()
{
Id = 24, LedgerId = 13, Credit = 100, Debit = 0, DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new LedgerEntry()
{
Id = 25, LedgerId = 13, Credit = 0, Debit = 100, DateAdded = DateTime.Now, DateUpdated = DateTime.Now
}
}
},
};
context.Ledger.AddRange(ledger);
context.Save();
}
private static void SeedAccounts(AccountingDatabaseService context)
{
var accounts = new List <AccountType> ()
{
new AccountType()
{
Id = 15, Type = "Asset", TypeOf = 0
},
new AccountType()
{
Id = 12, Type = "Liability", TypeOf = 0
},
new AccountType()
{
Id = 13, Type = "Capital", TypeOf = 0
},
new AccountType()
{
Id = 14, Type = "Revenue", TypeOf = 0
},
new AccountType()
{
Id = 10,
Type = "Asset", TypeOf = 0,
AccountCatagory = new List <AccountCatagory> ()
{
new AccountCatagory()
{
Id = 10, AccountTypeId = 10, Catagory = "Cash Account", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new AccountCatagory()
{
Id = 11, AccountTypeId = 10, Catagory = "COGE", DateAdded = DateTime.Now, DateUpdated = DateTime.Now
},
new AccountCatagory()
{
Id = 4, Catagory = "COGE", AccountTypeId = 10, DateAdded = DateTime.Now, DateUpdated = DateTime.Now,
Account = new List <Account> ()
{
new Account()
{
Id = 10, CatagoryId = 11, AccountId = "5000", AccountName = "Cash", OpeningBalance = 100, DateAdded = DateTime.Now, DateUpdated = DateTime.Now,
CostCenter = new SystemLookup()
{
Id = 30, Type = "Cost Center", Value = "Production"
},
},
new Account()
{
Id = 11, CatagoryId = 11, AccountId = "7000", AccountName = "Cash at Bank", OpeningBalance = 100, DateAdded = DateTime.Now, DateUpdated = DateTime.Now,
CostCenter = new SystemLookup()
{
Id = 50, Type = "Cost Center", Value = "Production"
},
}
}
}
}
},
new AccountType()
{
Id = 6, Type = "Finished Products", TypeOf = 15
},
new AccountType()
{
Id = 7, Type = "COGS (Cost of Goods)", TypeOf = 10
}
};
context.AccountType.AddRange(accounts);
context.SaveChanges();
}
public static void InitializeDbForTests(AccountingDatabaseService context)
{
AccountingDatabaseInitializer.Initialize(context);
}
