/// <summary>
/// Effectue une transaction
/// </summary>
/// <param name="motif">Motif de la transaction</param>
/// <param name="montant">Montant de la transaction</param>
/// <param name="idCategorie">id de la catégorie</param>
/// <param name="idPorteMonnaie">id du porte-monnaie concerné</param>
/// <param name="type">type de transaction (Débit, Cérdit)</param>
public static void AddTransaction(string motif, decimal montant, int idCategorie, int idPorteMonnaie, string type)
{
Transactions transaction = new Transactions();
transaction.IdTransaction = CountRowTransaction(idPorteMonnaie) + 1;
transaction.Motif = motif;
transaction.Montant = montant;
transaction.IdCategorie = idCategorie;
transaction.IdPorteMonnaie = idPorteMonnaie;
transaction.Type = type;
if (type == "Débit")
montant = -montant;
UpdateMontant(idPorteMonnaie, montant);
PorteMonnaieDb.Transactions.InsertOnSubmit(transaction);
try
{
PorteMonnaieDb.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void detach_Transactions(Transactions entity)
{
this.SendPropertyChanging();
entity.Categories = null;
}
partial void DeleteTransactions(Transactions instance);
partial void UpdateTransactions(Transactions instance);
partial void InsertTransactions(Transactions instance);
private void detach_Transactions(Transactions entity)
{
this.SendPropertyChanging();
entity.PorteMonnaies = null;
}
