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