private static OCurrency GetValue(TellerEvent eventItem, ContractAccountingRule rule)
{
OCurrency amount = 0;
if (rule.EventAttribute.Name.ToLower() == "amount")
{
amount = eventItem.Amount;
}
return amount;
}
public void AddTellerEvent(TellerEvent tellerEvent, SqlTransaction sqlTransaction)
{
const string sql =
@"INSERT INTO [dbo].[TellerEvents]
([teller_id]
,[event_code]
,[amount]
,[date]
,[description])
VALUES
(
@teller_id
,@event_code
,@amount
,@date
,@description
)";
using (OpenCbsCommand cmd = new OpenCbsCommand(sql, sqlTransaction.Connection, sqlTransaction))
{
cmd.AddParam("@teller_id", tellerEvent.TellerId);
cmd.AddParam("@event_code", tellerEvent.Code);
cmd.AddParam("@amount", tellerEvent.Amount);
cmd.AddParam("@date", tellerEvent.Date);
cmd.AddParam("@description", tellerEvent.Description);
cmd.ExecuteNonQuery();
}
}
private Booking GetTellerBooking(TellerEvent eventItem, List<Teller> tellers, List<FiscalYear> fiscalYears)
{
if (eventItem is TellerCashInEvent)
{
Teller teller = tellers.Find(i => i.Id == eventItem.TellerId);
return new Booking
{
Amount = eventItem.Amount,
CreditAccount = teller.Account,
DebitAccount = teller.Vault.Account,
ContractId = eventItem.ContracId,
Date = eventItem.Date,
EventId = eventItem.Id,
RuleId = 0,
ExchangeRate = 1,
Currency = eventItem.Currency,
Branch = eventItem.Branch,
EventType = eventItem.Code,
Name = eventItem.Description + " [" + eventItem.Date + "]",
Type = OMovementType.Teller,
FiscalYear = fiscalYears.First(f => f.OpenDate <= eventItem.Date.Date && f.CloseDate == null || f.CloseDate > eventItem.Date.Date)
};
}
if (eventItem is TellerCashOutEvent)
{
Teller teller = tellers.Find(i => i.Id == eventItem.TellerId);
return new Booking
{
Amount = eventItem.Amount,
CreditAccount = teller.Vault.Account,
DebitAccount = teller.Account,
ContractId = eventItem.ContracId,
Date = eventItem.Date,
EventId = eventItem.Id,
RuleId = 0,
ExchangeRate = 1,
Currency = eventItem.Currency,
Branch = eventItem.Branch,
EventType = eventItem.Code,
Name = eventItem.Description + " [" + eventItem.Date + "]",
Type = OMovementType.Teller,
FiscalYear = fiscalYears.First(f => f.OpenDate <= eventItem.Date.Date && f.CloseDate == null || f.CloseDate > eventItem.Date.Date)
};
}
return null;
}