public BalanceFileImportProcess(IFileAccessor fileAccessor, IConfiguration configuration, IApplicationDbFactory applicationDbFactory)
{
_fileAccessor = fileAccessor;
_configuration = configuration;
_applicationDbFactory = applicationDbFactory;
}
public static async Task SeedAsync(IApplicationDbFactory applicationDbFactory)
{
using (var uow = await applicationDbFactory.BeginUnitOfWorkAsync())
{
var admin = uow.Users.GetAll().FirstOrDefault(u => u.UserName == "Admin");
if (admin == null)
{
admin = new User
{
UserName = "******",
Role = new Role
{
RoleName = "Admin",
Discription = "Admin"
},
Password = "******".Sha256()
};
uow.Users.Insert(admin);
var otherUser = new User
{
UserName = "******",
Role = new Role
{
RoleName = "OtherUser",
Discription = "Other User"
},
Password = "******".Sha256()
};
uow.Users.Insert(otherUser);
await uow.SaveAsync();
}
var accountRandD = uow.Accounts.GetAll().FirstOrDefault(a => a.AccountName == "R&D");
if (accountRandD == null)
{
accountRandD = new Account
{
AccountName = "R&D",
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now
};
uow.Accounts.Insert(accountRandD);
var accountCanteen = new Account
{
AccountName = "Canteen",
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now
};
uow.Accounts.Insert(accountCanteen);
var accountCeosCar = new Account
{
AccountName = "CEO's car",
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now
};
uow.Accounts.Insert(accountCeosCar);
var accountMarketing = new Account
{
AccountName = "Marketing",
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now
};
uow.Accounts.Insert(accountMarketing);
var accountParkingsFines = new Account
{
AccountName = "Parkings Fines",
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now
};
uow.Accounts.Insert(accountParkingsFines);
var periodJan = new Period
{
Discription = "January 2017",
PeriodDate = new DateTime(2017, 01, 01),
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
};
uow.Periods.Insert(periodJan);
var periodFeb = new Period
{
Discription = "February 2017",
PeriodDate = new DateTime(2017, 02, 01),
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
};
uow.Periods.Insert(periodFeb);
var periodMarch = new Period
{
Discription = "March 2017",
PeriodDate = new DateTime(2017, 03, 01),
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
};
uow.Periods.Insert(periodMarch);
await uow.SaveAsync();
uow.AccountPeriodBalances.Insert(new AccountPeriodBalance
{
AccountId = accountRandD.AccountId,
Balance = 10.56M,
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
PeriodId = periodMarch.PeriodId
});
uow.AccountPeriodBalances.Insert(new AccountPeriodBalance
{
AccountId = accountCanteen.AccountId,
Balance = 98000M,
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
PeriodId = periodMarch.PeriodId
});
uow.AccountPeriodBalances.Insert(new AccountPeriodBalance
{
AccountId = accountCeosCar.AccountId,
Balance = 24000M,
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
PeriodId = periodMarch.PeriodId
});
uow.AccountPeriodBalances.Insert(new AccountPeriodBalance
{
AccountId = accountMarketing.AccountId,
Balance = -19112M,
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
PeriodId = periodMarch.PeriodId
});
uow.AccountPeriodBalances.Insert(new AccountPeriodBalance
{
AccountId = accountParkingsFines.AccountId,
Balance = 11000M,
CreatedBy = admin.UserId,
CreatedDate = DateTimeOffset.Now,
PeriodId = periodMarch.PeriodId
});
await uow.SaveAsync();
}
}
}
public AccountService(IApplicationDbFactory applicationDbFactory)
{
_applicationDbFactory = applicationDbFactory;
}
public AccountPeriodBalanceService(IApplicationDbFactory applicationDbFactory, IFileAccessor fileAccessor, IImportProcess importProcess)
{
_applicationDbFactory = applicationDbFactory;
_fileAccessor = fileAccessor;
_importProcess = importProcess;
}
public PeriodService(IApplicationDbFactory applicationDbFactory)
{
_applicationDbFactory = applicationDbFactory;
}
public DatabaseInitializerService(IApplicationDbFactory identityDbFactory)
{
_identityDbFactory = identityDbFactory;
}
