public static string RejectATruck(int MSID)
{
DateTime now = DateTime.Now;
string nowFormatted;
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
using (var scope = new TransactionScope())
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
ChangeLog cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "MainSchedule", "isRejected", now, zxpUD._uid, ChangeLog.ChangeLogDataType.BIT, "1", null, "MSID", MSID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "MainSchedule", "LastUpdated", now, zxpUD._uid, ChangeLog.ChangeLogDataType.DATETIME, now.ToString(), null, "MSID", MSID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.MainSchedule SET isRejected = 1, LastUpdated = @TIME " +
"WHERE (MSID = @MSID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@TIME", now),
new SqlParameter("@MSID", MSID));
scope.Complete();
}
MainScheduleEventLogger msEventLog = new MainScheduleEventLogger();
MainScheduleEvent msEvent = new MainScheduleEvent(MSID, 2037, null, now, zxpUD._uid, false);
int newEventID = msEventLog.createNewEventLog(msEvent);
string customAlertMsg = CreateCustomRejectTruckMessage(MSID);
msEventLog.TriggerExistingAlertForEvent(newEventID, customAlertMsg);
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck GetGridData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
nowFormatted = now.ToString("ddd MMM dd yyyy HH:mm:ss K");
return(now.ToString());
}
public static DateTime completeRequest(int requestID, int requestTypeID, int MSID)
{
SqlConnection sqlConn = new SqlConnection();
DateTime timeStamp = DateTime.Now;
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
sqlConn = new SqlConnection();
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
string sqlQuery = string.Empty;
int eventID = 0;
MainScheduleEventLogger msEventLog = new MainScheduleEventLogger();
if (requestTypeID == 1) //Load
{
MainScheduleEvent msEvent = new MainScheduleEvent(MSID, 16, null, timeStamp, zxpUD._uid, false);
string newAlertMsg = createCustomMessageForCompletedTask(requestID);
eventID = msEventLog.createNewEventLogAndTriggerExistingAlerts(msEvent, "Loading Finished. " + newAlertMsg);
}
else if (requestTypeID == 2) //Unload
{
MainScheduleEvent msEvent = new MainScheduleEvent(MSID, 14, null, timeStamp, zxpUD._uid, false);
string newAlertMsg = createCustomMessageForCompletedTask(requestID);
eventID = msEventLog.createNewEventLogAndTriggerExistingAlerts(msEvent, "Unloading Finished. " + newAlertMsg);
}
else if (requestTypeID == 3) //Other
{
MainScheduleEvent msEvent = new MainScheduleEvent(MSID, 2031, null, timeStamp, zxpUD._uid, false);
string newAlertMsg = createCustomMessageForCompletedTask(requestID);
eventID = msEventLog.createNewEventLogAndTriggerExistingAlerts(msEvent, newAlertMsg);
}
if (eventID == 0)
{
throw new Exception("Invalid eventID. Error creating new event log.");
}
using (var scope = new TransactionScope())
{
sqlQuery = "INSERT INTO dbo.MainScheduleRequestEvents(RequestID, EventID) " +
"VALUES(@RID, @EID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlQuery, new SqlParameter("@RID", requestID), new SqlParameter("@EID", eventID));
sqlQuery = "UPDATE dbo.MainSchedule SET LastUpdated = @TIME WHERE (MSID = @MSID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlQuery, new SqlParameter("@MSID", MSID), new SqlParameter("@TIME", timeStamp));
sqlConn = new SqlConnection(new TruckScheduleConfigurationKeysHelper().sql_connStr);
ChangeLog Cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleRequestEvents", "RequestID", timeStamp, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, requestID.ToString(), eventID, "RequestID", requestID.ToString(), "EventID", eventID.ToString());
Cl.CreateChangeLogEntryIfChanged();
Cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleRequestEvents", "EventID", timeStamp, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, eventID.ToString(), eventID, "RequestID", requestID.ToString(), "EventID", eventID.ToString());
Cl.CreateChangeLogEntryIfChanged();
Cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "MainSchedule", "LastUpdated", timeStamp, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, timeStamp.ToString(), eventID, "MSID", MSID.ToString());
Cl.CreateChangeLogEntryIfChanged();
scope.Complete();
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in loaderMobile completeRequest(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile completeRequest(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
finally
{
if (sqlConn != null && sqlConn.State != ConnectionState.Closed)
{
sqlConn.Close();
sqlConn.Dispose();
}
}
return(timeStamp);
}
