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