/// <summary> /// Update Sales Order Number Sequence /// </summary> /// <param name="salesOrderNumberSequence"></param> /// <returns></returns> public async Task UpdateSalesOrderNumberSequence(SalesOrderNumberSequence salesOrderNumberSequence) { await Task.Delay(0); DateTime dateUpdated = DateTime.UtcNow; salesOrderNumberSequence.DateUpdated = dateUpdated; }
/// <summary> /// Create Sales Order Number Sequence /// </summary> /// <param name="salesOrderNumberSequence"></param> /// <returns></returns> public async Task CreateSalesOrderNumberSequence(SalesOrderNumberSequence salesOrderNumberSequence) { DateTime dateCreated = DateTime.UtcNow; salesOrderNumberSequence.DateCreated = dateCreated; salesOrderNumberSequence.DateUpdated = dateCreated; await dbConnection.SalesOrderNumberSequences.AddAsync(salesOrderNumberSequence); }
/// <summary> /// Get Sales Order Number Sequence /// </summary> /// <param name="accountId"></param> /// <returns></returns> public async Task <SalesOrderNumberSequence> GetSalesOrderNumberSequence(int accountId) { string sqlStatement = "SELECT * FROM SalesOrderNumberSequences WITH (UPDLOCK) WHERE AccountId = @AccountId"; DbParameter accountIdParameter = new SqlParameter("AccountId", accountId); SalesOrderNumberSequence salesOrderNumberSequence = await dbConnection.SalesOrderNumberSequences.FromSql(sqlStatement, accountIdParameter).FirstOrDefaultAsync(); return(salesOrderNumberSequence); }