public async Task <int> PayoffPkzpAsync(Guid pkzpPositionId, decimal amount, PkzpPositionType pkzpPositionType, Guid workerId, Guid periodId, bool closed = false)
{
return(await Context.Database.ExecuteSqlRawAsync(
"BEGIN KADRY.PKZP_PACK.PKZP_SPLATY(:PKZP_POSITION_GUID, :AMOUNT, :TYPE, :WORKER, :PERIOD, :CLOSED, :INSTALLMENT_AMOUNT); END;",
new object[]
{
new OracleParameter("PKZP_POSITION_GUID", pkzpPositionId.ToByteArray()),
new OracleParameter("AMOUNT", amount),
new OracleParameter("TYPE", pkzpPositionType),
new OracleParameter("PERIOD", periodId.ToByteArray()),
new OracleParameter("WORKER", workerId.ToByteArray()),
new OracleParameter("CLOSED", closed),
}));
}
public PkzpCreateCommand(
PkzpPositionType pkzpPositionType,
Guid periodId,
Guid workerId,
decimal amount,
int?installmentsCount,
decimal?installmentAmount)
{
PkzpPositionType = pkzpPositionType;
PeriodId = periodId;
WorkerId = workerId;
Amount = amount;
InstallmentsCount = installmentsCount ?? 0;
InstallmentAmount = installmentAmount ?? 0;
}
public async Task <int> CreateAsync(Guid pkzpPositionId, PkzpPositionType pkzpPositionType, Guid periodId, Guid workerId, decimal amount, int installmentsCount,
decimal installmentAmount)
{
return(await Context.Database.ExecuteSqlRawAsync(
"BEGIN KADRY.PKZP_PACK.PKZP_INSERT(:PKZP_POSITION_GUID, :TYPE, :PERIOD, :WORKER, :AMOUNT, :INSTALLMENTS_COUNT, :INSTALLMENT_AMOUNT); END;",
new object[]
{
new OracleParameter("PKZP_POSITION_GUID", pkzpPositionId.ToByteArray()),
new OracleParameter("TYPE", (int)pkzpPositionType),
new OracleParameter("PERIOD", periodId.ToByteArray()),
new OracleParameter("WORKER", workerId.ToByteArray()),
new OracleParameter("AMOUNT", amount),
new OracleParameter("INSTALLMENTS_COUNT", installmentsCount),
new OracleParameter("INSTALLMENT_AMOUNT", installmentAmount)
}));
}
