Example #1
0
        public async Task DeleteLdrepManualAdjustment(LdrepManualAdjustment ldrepManualAdjustment)
        {
            var queryParameters = new DynamicParameters();

            queryParameters.Add("@ManualAdjustments", ToArrayTvp(ldrepManualAdjustment.LdrepManualAdjustmentRecords));
            queryParameters.Add("@CompanyId", ldrepManualAdjustment.Company);

            await ExecuteNonQueryAsync(StoredProcedureNames.DeleteLdrepManualAdjustment, queryParameters);
        }
Example #2
0
        public async Task <LdrepManualAdjustment> CreateUpdateLdrepManualAdjustment(LdrepManualAdjustment ldrepManualAdjustment)
        {
            var queryParameters = new DynamicParameters();

            queryParameters.Add(DataVersionIdParameter, null);
            queryParameters.Add("@CompanyId", ldrepManualAdjustment.Company);
            queryParameters.Add("@ManualAdjustments", ToArrayTvp(ldrepManualAdjustment.LdrepManualAdjustmentRecords));

            LdrepManualAdjustment res = await ExecuteQueryFirstOrDefaultAsync <LdrepManualAdjustment>(StoredProcedureNames.CreateUpdateLdrepManualAdjustments, queryParameters, true);

            return(res);
        }