/// <summary>
/// this function will update a bank account
/// </summary>
/// <param name="bankAccount">the given bank account</param>
public void UpdateBankAccountByAccount(BankAccount bankAccount)
{
#region ActionLog
//we initialy generate the action log and command
String LogAction = $"S-a actualizat contul bancar cu ID: {bankAccount.ID}";
String LogCommand = "UPDATE seller.conturi_bancare_furnizori " +
$"SET banca = {bankAccount.Bank} " +
$"WHERE cont = {bankAccount.Account}";
//before retrieving the ip of the current instance
String IP = MentorBilling.Miscellaneous.IPFunctions.GetWANIp();
#endregion
ConturiBancareFurnizori contBancarFurnizor = base.ConturiBancareFurnizori.Where(element => element.Cont == bankAccount.Account).FirstOrDefault();
contBancarFurnizor.Banca = bankAccount.Bank;
contBancarFurnizor.Cont = bankAccount.Account;
contBancarFurnizor.Activ = true;
base.Update(contBancarFurnizor);
base.LogActiuni.Add(ActionLog.LogAction(LogAction, IP, LogCommand));
base.SaveChanges();
}
/// <summary>
/// this function will add a bew bank account for the given seller to the database
/// </summary>
/// <param name="seller">the given seller</param>
/// <param name="bankAccount">the new bank account</param>
void AddNewBankAccountForSellerWithoutSave(ObjectStructures.Invoice.Seller seller, BankAccount bankAccount)
{
#region ActionLog
//we generate the log action
String LogAction = $"Adaugat un nou cont bancar la banca {bankAccount.Bank} pentru societatea {seller.Name}";
//and the log command
String LogCommand = "INSERT INTO seller.conturi_bancare_furnizori(furnizor_id,cont,banca) " +
$"VALUES({seller.ID}, {bankAccount.Account}, {bankAccount.Bank}) " +
"ON CONFLICT(cont) " +
$"DO UPDATE SET banca= {bankAccount.Bank} RETURNING id";
//before retriving the ip
String IP = Miscellaneous.IPFunctions.GetWANIp();
#endregion
ConturiBancareFurnizori contBancarFurnizor = new ConturiBancareFurnizori
{
FurnizorId = seller.ID,
Cont = bankAccount.Account,
Banca = bankAccount.Bank
};
base.ConturiBancareFurnizori.Add(contBancarFurnizor);
base.LogActiuni.Add(ActionLog.LogAction(LogAction, IP, LogCommand));
bankAccount.ID = contBancarFurnizor.Id;
}
