/// <summary>
/// Delete the shift from shift staging table.
/// </summary>
/// <param name="request">The request.</param>
/// <returns>A null response.</returns>
private NullResponse DeleteShiftStagingTable(DeleteShiftDataRequest request)
{
ThrowIf.Null(request, "request");
ThrowIf.Null(request.Shift, "request.Shift");
Shift shift = request.Shift;
ParameterSet parameters = new ParameterSet();
parameters[DatabaseAccessor.ChannelIdVariableName] = request.RequestContext.GetPrincipal().ChannelId;
parameters[TerminalIdVariableName] = shift.TerminalId;
parameters[ShiftIdVariableName] = shift.ShiftId;
parameters[RowVersionViarableName] = shift.RowVersion;
int errorCode;
using (var sqlServerDatabaseContext = new SqlServerDatabaseContext(request))
{
errorCode = sqlServerDatabaseContext.ExecuteStoredProcedureNonQuery(DeleteShiftStagingSprocName, parameters);
}
if (errorCode != (int)DatabaseErrorCodes.Success)
{
throw new StorageException(
StorageErrors.Microsoft_Dynamics_Commerce_Runtime_CriticalStorageError,
errorCode,
string.Format("Unable to execute the stored procedure {0}.", DeleteShiftStagingSprocName));
}
return(new NullResponse());
}
private NullResponse DeleteShiftStagingTable(DeleteShiftDataRequest request)
{
var databaseAccessor = new ShiftsSqliteDatabaseAccessor(request.RequestContext);
databaseAccessor.DeleteShiftStaging(request.Shift);
return(new NullResponse());
}