public static DataTable ReadFromWarehouse(TotMastrActions totMastrAction, string a1ShipRequestStatus)
{
using (DBConnection warehouseDBConnection = WarehouseDatabaseConnectionAdapter.GetDatabaseConnection())
return(warehouseDBConnection.ExecuteDataTableQuery(@"
select
*
from
A1ShipRequest
where
[action] = {0} and
[status] = '{1}' and
[threadName] = '{2}'
order by [createdDate] asc", (short)totMastrAction, a1ShipRequestStatus, Thread.CurrentThread.Name));
}
public static void UpdateWarehouse(string setA1ShipRequestStatus, string currentA1ShipRequestStatus, TotMastrActions totMastrAction)
{
lock (databaseSyncObject)
using (DBConnection warehouseDBConnection = WarehouseDatabaseConnectionAdapter.GetDatabaseConnection())
warehouseDBConnection.ExecuteNonQuery(@"
update
A1ShipRequest
set
[status] = '{0}',
[threadName] = '{1}'
where
[status] = '{2}' and
[action] = {3} and
([threadName] = '{1}' or [threadName] = '' or [threadName] is null)" , setA1ShipRequestStatus, Thread.CurrentThread.Name, currentA1ShipRequestStatus, (short)totMastrAction);
}
public static bool IsRecordInStatus(TotMastrActions totMastrAction, string a1ShipRequestStatus, string uniqueIdentifier)
{
using (DBConnection warehouseDBConnection = WarehouseDatabaseConnectionAdapter.GetDatabaseConnection())
{
int?recordCount = warehouseDBConnection.ExecuteScalar(@"
select
count(id)
from
A1ShipRequest
where
[action] = {0} and
[uniqueIdentifier] = '{1}' and
[status] = '{2}'" , (short)totMastrAction, uniqueIdentifier, a1ShipRequestStatus) as int?;
return(recordCount.HasValue && recordCount > 0);
}
}
public static DataTable InsertToWarehouse(TotMastrActions totMastrAction, string uniqueIdentifier, string status)
{
DataTable warehouseA1ShipRequestRecords = ReadSchemaFromWarehouse();
warehouseA1ShipRequestRecords.Rows.Add(warehouseA1ShipRequestRecords.NewRow());
warehouseA1ShipRequestRecords.Rows[0]["id"] = Guid.NewGuid();
warehouseA1ShipRequestRecords.Rows[0]["action"] = (short)totMastrAction;
warehouseA1ShipRequestRecords.Rows[0]["uniqueIdentifier"] = uniqueIdentifier;
warehouseA1ShipRequestRecords.Rows[0]["status"] = status;
warehouseA1ShipRequestRecords.Rows[0]["threadName"] = Thread.CurrentThread.Name;
warehouseA1ShipRequestRecords.Rows[0]["createdDate"] = DateTime.UtcNow;
lock (databaseSyncObject)
using (DBConnection warehouseDBConnection = WarehouseDatabaseConnectionAdapter.GetDatabaseConnection())
using (DBAdapter a1ShipRequestDBAdapter = new DBAdapter(A1ShipRequestTableSchemaQuery, warehouseDBConnection.SqlConnection))
a1ShipRequestDBAdapter.Update(warehouseA1ShipRequestRecords);
return(warehouseA1ShipRequestRecords);
}
public static DataTable UpdateWarehouse(DataTable warehouseA1ShipRequestRecords, string a1ShipRequestStatus)
{
if (warehouseA1ShipRequestRecords.Rows.Count == 0)
{
throw new Exception("The A1ShipRequest table update failed because the submitted table contains no rows!");
}
foreach (DataRow warehouseA1ShipRequestRecord in warehouseA1ShipRequestRecords.Rows)
{
warehouseA1ShipRequestRecord["status"] = a1ShipRequestStatus;
warehouseA1ShipRequestRecord["threadName"] = string.Empty;
}
lock (databaseSyncObject)
using (DBConnection warehouseDBConnection = WarehouseDatabaseConnectionAdapter.GetDatabaseConnection())
using (DBAdapter a1ShipRequestDBAdapter = new DBAdapter(A1ShipRequestTableSchemaQuery, warehouseDBConnection.SqlConnection))
a1ShipRequestDBAdapter.Update(warehouseA1ShipRequestRecords);
return(warehouseA1ShipRequestRecords);
}
public static DataTable ReadSchemaFromWarehouse()
{
using (DBConnection warehouseDBConnection = WarehouseDatabaseConnectionAdapter.GetDatabaseConnection())
return(warehouseDBConnection.ExecuteDataTableQuery(A1ShipRequestTableSchemaQuery));
}
