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) })); }