public Result<Transaction> CreateTransaction(CreateTransactionCommand newTransactionCommand)
{
return Result<Transaction>.SafeExecute<TransactionService>(result =>
{
using (datacontext = new RmmDataContext(RmmDataContext.CONNECTIONSTRING))
{
var transaction = new Transaction();
Category attachedCategoryEntity;
Account attachedAccountEntity;
if (newTransactionCommand.categoryId.HasValue)
{
attachedCategoryEntity = datacontext.Category.Where(c => c.ID == newTransactionCommand.categoryId).First();
transaction.Category = attachedCategoryEntity;
}
if (newTransactionCommand.accountId != 0)
{
attachedAccountEntity = datacontext.Account.Where(c => c.ID == newTransactionCommand.accountId).First();
attachedAccountEntity.Balance += newTransactionCommand.Amount;
transaction.Account = attachedAccountEntity;
}
transaction.Amount = newTransactionCommand.Amount;
transaction.Description = newTransactionCommand.Description;
transaction.Name = newTransactionCommand.Name;
transaction.CreatedDate = DateTime.Now;
datacontext.Transaction.InsertOnSubmit(transaction);
datacontext.SubmitChanges();
var AddedTransac = datacontext.Transaction.Where(a => a.CreatedDate == transaction.CreatedDate).First();
result.Value = AddedTransac;
}
}, () => "erreur");
}
public static void ProcessDatasOnDB(IAccountService AccountService, ICategoryService CategoryService, ITransactionService TransactionService, IOptionService OptionService)
{
#region Categories
var c1 = new Category();
c1.Balance = 7.0;
c1.Color = "FFA640";
c1.Name = "Vacances";
var c2 = new Category();
c2.Balance = 7.0;
c2.Color = "FFA640";
c2.Name = "Profesionnel";
#endregion
#region Accounts
var na1 = new Account();
na1.Balance = 7.0;
na1.BankName = "Credit Agricole";
na1.Name = "Mon compte courant";
var na2 = new Account();
na2.Balance = 7.0;
na2.BankName = "HSBC";
na2.Name = "Mon compte courant";
var na3 = new Account();
na3.Balance = 7.0;
na3.BankName = "HSBC";
na3.Name = "Mon compte epargne HSBC";
#endregion
#region DB Cleaner
var Categories = CategoryService.GetAllCategories(true);
var Accounts = AccountService.GetAllAccounts(true);
if (Categories.Value.Count > 0)
{
foreach (var entity in Categories.Value)
{
CategoryService.DeleteCategorieById(entity.ID);
}
}
if (Accounts.Value.Count > 0)
{
foreach (var entity in Accounts.Value)
{
AccountService.DeleteAccountById(entity.ID);
}
}
var transactions =
#endregion
#region Ajout Données
na1 = AccountService.CreateAccount(new CreateAccountCommand() { BankName = na1.BankName, Name = na1.Name }).Value;
na2 = AccountService.CreateAccount(new CreateAccountCommand() { BankName = na2.BankName, Name = na2.Name }).Value;
na3 = AccountService.CreateAccount(new CreateAccountCommand() { BankName = na3.BankName, Name = na3.Name }).Value;
c1 = CategoryService.CreateCategory(new CreateCategoryCommand() { Name = c1.Name, Color = c1.Color }).Value;
c2 = CategoryService.CreateCategory(new CreateCategoryCommand() { Name = c2.Name, Color = c2.Color }).Value;
#endregion
#region Ajout 26 transactions
var listDeTransaction = new List<Transaction>();
listDeTransaction.Add(new Transaction() { Name = "redevance tv", Account = na1, Amount = -100, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "les courses", Account = na1, Amount = -80, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "restau", Account = na2, Category = c2, Amount = -40, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "piscine", Account = na1, Amount = -10, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "ciné", Account = na1, Amount = -5, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "bar", Account = na1, Category = c1, Amount = -10.5, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "club", Account = na1, Category = c1, Amount = -15.5, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "lotto", Account = na1, Amount = 7, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "la biere", Account = na1, Amount = -10, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "bouquet de fleur", Account = na1, Amount = -20, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "medicaments", Account = na1, Amount = -5, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "pizza tv", Account = na1, Amount = -10, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "moulin de la forge tv", Account = na1, Category = c1, Amount = -150, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "licence MS", Account = na2, Category = c2, Amount = -35, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "James", Account = na2, Category = c2, Amount = 500, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "Ian", Account = na2, Category = c2, Amount = 1000, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "Villa", Account = na2, Category = c1, Amount = -200, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "Telephone", Account = na2, Category = c2, Amount = -30, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "park d'actraction", Account = na2, Amount = -20, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "enfants", Account = na2, Amount = 46.7, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "nouvelle maison", Account = na3, Amount = -33.6, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "epargne taux fixe", Account = na3, Amount = 10, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "epargne sur montpellier", Account = na3, Amount = 60, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "epargne de Paris", Account = na3, Amount = -20, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "investissement", Account = na3, Amount = 250, Description = "test de la description" });
listDeTransaction.Add(new Transaction() { Name = "import maman", Account = na1, Amount = 700, Description = "test de la description" });
#endregion
listDeTransaction.ForEach(transac =>
{
var newtransaction = new CreateTransactionCommand()
{
Name = transac.Name,
accountId = transac.Account.ID,
Amount = transac.Amount,
Description = transac.Description
};
if (transac.Category != null)
{
newtransaction.categoryId = transac.Category.ID;
}
TransactionService.CreateTransaction(newtransaction);
});
OptionService.SetFirstTimeOption();
}
