public override async Task AddBillingHistorizationAsync(Guid billId, BillActivityType billActivityType, DateTime serverDate, Guid userId)
        {
            SqlCommandHelper commandHelper = new SqlCommandHelper(_connectionString);

            SqlParameter[] parameters = new SqlParameter[4]
            {
                new SqlParameter("@billId", System.Data.SqlDbType.UniqueIdentifier)
                {
                    Value = billId
                },
                new SqlParameter("@billActivityType", System.Data.SqlDbType.Int)
                {
                    Value = (int)billActivityType
                },
                new SqlParameter("@date", System.Data.SqlDbType.SmallDateTime)
                {
                    Value = serverDate
                },
                new SqlParameter("@userId", System.Data.SqlDbType.UniqueIdentifier)
                {
                    Value = userId
                }
            };
            await commandHelper.ExecuteNonQueryAsync(_addBillingHistorizationCmdTxt, false, parameters);
        }
Example #2
0
 public abstract Task AddBillingHistorizationAsync(Guid billId, BillActivityType billActivityType, DateTime serverDate, Guid userId);