private void UpdateMISBalance(IMISAccountBalanceUpdate update)
{
Log.LogInfoMessage($"[Enter] {System.Reflection.MethodBase.GetCurrentMethod().Name}");
//try
//{
// using (IfxConnection connection = EstablishConnection())
// {
// IfxCommand command = connection.CreateCommand();
// command.CommandText = $"UPDATE AccBalances SET Balance = {update.NewBalance} WHERE ac_nr = {update.MISAccountNr} ";
// }
//}
//catch (Exception ex)
//{
// Log.LogTrace(ex.Message + ". Check error log for more details.");
// Log.LogException(ex);
//}
Log.LogInfoMessage($"[Exit] {System.Reflection.MethodBase.GetCurrentMethod().Name}");
}
public void SetSentMISAccountBalanceUpdate(IMISAccountBalanceUpdate update)
{
using (var ctx = new DataImportEntities())
{
var balanceRecord = ctx.StagingMISAccountBalances.FirstOrDefault(x => x.MISAccountNr == update.MISAccountNr);
if (balanceRecord != null)
{
balanceRecord.MISBalance = update.NewBalance;
ctx.SaveChanges();
}
var updateRecord = ctx.StagingMISAccountBalanceUpdates.FirstOrDefault(x => x.Id == update.Id);
if (updateRecord != null)
{
updateRecord.DateSentToMIS = DateTime.Now;
ctx.SaveChanges();
}
}
}
