protected void Page_Load(object sender, EventArgs e)
{
try
{
HttpCookie cookie = Request.Cookies[System.Web.Security.FormsAuthentication.FormsCookieName];
if (null != cookie && !string.IsNullOrEmpty(cookie.Value))
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
if (!(zxpUD._isLabAdmin || zxpUD._isLabPersonnel || zxpUD._isGuard || zxpUD._isAdmin)) //make sure this matches whats in Site.Master and Default
{
Response.BufferOutput = true;
Response.Redirect("/ErrorPage.aspx?ErrorCode=5", false);
}
}
else
{
Response.BufferOutput = true;
Response.Redirect("/Account/Login.aspx?ReturnURL=/rejectTruck.aspx", false); //zxp live
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in RejectTruck Page_Load(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck Page_Load(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
}
public static void DeleteFileDBEntry(int SampleID, int MSID)
{
DateTime now = DateTime.Now;
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
using (var scope = new TransactionScope())
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "INSERT INTO dbo.MainScheduleEvents (MSID, EventTypeID, TimeStamp, UserID, isHidden) VALUES (@MSID, 4098, @TSTAMP, @UserID, 'false'); " +
"SELECT SCOPE_IDENTITY()";
int eventID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID),
new SqlParameter("@TSTAMP", now),
new SqlParameter("@UserID", zxpUD._uid)));
ChangeLog cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "Samples", "FileID_COFA", now, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, null, eventID, "SampleID", SampleID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.Samples SET FileID_COFA = NULL, COFAEventID = NULL WHERE SampleID = @SampleID";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@SampleID", SampleID));
scope.Complete();
}
}
catch (Exception ex)
{
string strErr = " Exception Error in COFAUpload DeleteFileDBEntry(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
throw ex;
}
}
public static void SetRejectionComment(int MSID, string COMMENT)
{
DateTime now = DateTime.Now;
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", "RejectionComment", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, TransportHelperFunctions.convertStringEmptyToDBNULL(COMMENT).ToString(), null, "MSID", MSID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.MainSchedule SET RejectionComment = @COMMENT " +
"WHERE (MSID = @MSID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@COMMENT", TransportHelperFunctions.convertStringEmptyToDBNULL(COMMENT)),
new SqlParameter("@MSID", MSID));
scope.Complete();
}
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck SetRejectionComment(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
HttpCookie cookie = Request.Cookies[System.Web.Security.FormsAuthentication.FormsCookieName];
if (null != cookie && !string.IsNullOrEmpty(cookie.Value))
{
System.Web.Security.FormsAuthenticationTicket ticket = System.Web.Security.FormsAuthentication.Decrypt(cookie.Value);
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
zxpUD = ZXPUserData.DeserializeZXPUserData(ticket.UserData);
if (!(zxpUD._isAdmin || zxpUD._isDockManager || zxpUD._isLoader || zxpUD._isYardMule)) //make sure this matches whats in Site.Master and Default
{
Response.BufferOutput = true;
Response.Redirect("ErrorPage.aspx?ErrorCode=5", false); //zxp live url
}
}
else
{
Response.BufferOutput = true;
Response.Redirect("Account/Login.aspx?ReturnURL=~/loaderMobile.aspx", false);//zxp live url
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in loaderMobile Page_Load(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile Page_Load(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
}//page_load()
protected void Page_Load(object sender, EventArgs e)
{
try
{
//HttpCookie cookie = Request.Cookies[System.Web.Security.FormsAuthentication.FormsCookieName];
//if (null != cookie && !string.IsNullOrEmpty(cookie.Value))
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
if (zxpUD._uid != new ZXPUserData()._uid)
{
if (!zxpUD._isAdmin) //make sure this matches whats in Site.Master and Default
{
Response.BufferOutput = true;
Response.Redirect("/ErrorPage.aspx?ErrorCode=5", false);
}
}
else
{
Response.BufferOutput = true;
//Response.Redirect("/Account/Login.aspx?ReturnURL=/AdminMainPage.aspx", false); mi4 url
Response.Redirect("Account/Login.aspx?ReturnURL=~/AdminMainPage.aspx", false);//zxp live url
}
}
catch (Exception ex)
{
string strErr = " Exception Error in AdminMainPage Page_Load(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
}
}
public static void setCOFAComment(int SAMPLEID, string COMMENT)
{
DateTime now = DateTime.Now;
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, "Samples", "COFAComment", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, COMMENT, null, "SampleID", SAMPLEID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.Samples SET COFAComment = @COFAComment " +
"WHERE (SampleID = @SampleID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@COFAComment", COMMENT),
new SqlParameter("@SampleID", SAMPLEID));
scope.Complete();
}
}
catch (Exception ex)
{
string strErr = " Exception Error in COFAUpload setCOFAComment(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//HttpCookie cookie = Request.Cookies[System.Web.Security.FormsAuthentication.FormsCookieName];
//if (null != cookie && !string.IsNullOrEmpty(cookie.Value))
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
if (zxpUD._uid != new ZXPUserData()._uid)
{
//ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
if (zxpUD._isAdmin) //make sure this matches whats in Site.Master and Default
{
sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
if (sql_connStr == String.Empty)
{
throw new Exception("Missing SQLConnectionString in web.config");
}
}
else
{
Response.BufferOutput = true;
Response.Redirect("ErrorPage.aspx?ErrorCode=5", false); //zxp live url
}
}
else
{
Response.BufferOutput = true;
Response.Redirect("Account/Login.aspx?ReturnURL=~/AdminMainPage.aspx", false);//zxp live url
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in Admin_InspectionLists Page_Load(). Details: " + excep.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 2;
ErrorLogging.sendtoErrorPage(2);
}
catch (Exception ex)
{
string strErr = " Exception Error in Admin_InspectionLists Page_Load(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
}
}
public static List <object> canInspectionBeEdited(int prodDetailID, int MSInspectionListID, int MSInspectionID)
{
List <object> returnObj = new List <object>();
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
returnObj = InspectionsHelperFunctions.canInspectionBeEdited(prodDetailID, MSInspectionListID, MSInspectionID, sql_connStr, zxpUD);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile canInspectionBeStarted(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(returnObj);
}
public static void UndoARejectedTruck(int MSID)
{
DateTime now = DateTime.Now;
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
using (var scope = new TransactionScope())
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
//Create an entry in Event Log
sqlCmdText = "INSERT INTO dbo.MainScheduleEvents (MSID, EventTypeID,Timestamp, UserId, isHidden) " +
"VALUES (@MSID, 3037, @TIME, @USER, 'false'); " +
"SELECT SCOPE_IDENTITY()";
int eventID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID),
new SqlParameter("@TIME", now),
new SqlParameter("@USER", zxpUD._uid)));
sqlCmdText = "UPDATE dbo.MainScheduleEvents SET isHidden = 'true' " +
"WHERE (MSID = @MSID) AND EventTypeID = 2037;";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID));
ChangeLog cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "MainSchedule", "isRejected", now, zxpUD._uid, ChangeLog.ChangeLogDataType.BIT, "false", eventID, "MSID", MSID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "MainSchedule", "LastUpdated", now, zxpUD._uid, ChangeLog.ChangeLogDataType.DATETIME, now.ToString(), eventID, "MSID", MSID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.MainSchedule SET isRejected = 'false', LastUpdated = @TIME " +
"WHERE (MSID = @MSID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID),
new SqlParameter("@TIME", now));
scope.Complete();
}
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck UndoARejectedTruck(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
}
public static void CloseOutTruckSchedules(List <int> MSIDs)
{
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
DataTable tvp = new DataTable();
tvp.Columns.Add(new DataColumn("MSID", typeof(int)));
foreach (int id in MSIDs)
{
tvp.Rows.Add(id);
}
using (var scope = new TransactionScope())
{
SqlCommand cmd = new SqlCommand("dbo.sp_truckschedapp_closeOutTruckSchedule");
SqlConnection sqlConn = new SqlConnection(sql_connStr);
if (sqlConn.State != ConnectionState.Open)
{
sqlConn.Open();
}
cmd.Connection = sqlConn;
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter msidarray = cmd.Parameters.AddWithValue("@MSIDList", tvp);
msidarray.SqlDbType = SqlDbType.Structured;
msidarray.TypeName = "dbo.MSIDList";
cmd.Parameters.AddWithValue("@UserID", zxpUD._uid);
cmd.ExecuteNonQuery();
scope.Complete();
}
}
catch (Exception ex)
{
string strErr = " Exception Error in AdminCleanUp CloseOutTruckSchedules(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
throw ex;
}
}
public static List <object> setInspectionResult(int MSInspectionID, int testID, int result, int prodDetailID)
{
List <object> returnData = new List <object>();
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
returnData = InspectionsHelperFunctions.setInspectionResult(MSInspectionID, testID, result, prodDetailID, sql_connStr, zxpUD);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile setInspectionResult(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
//returnData.Add(timestamp);
//returnData.Add(returnMsg);
//returnData.Add(hasEnded);
//returnData.Add(isLastQuestion);
return(returnData);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
HttpCookie cookie = Request.Cookies[System.Web.Security.FormsAuthentication.FormsCookieName];
if (null != cookie && !string.IsNullOrEmpty(cookie.Value))
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
System.Web.Security.FormsAuthenticationTicket ticket = System.Web.Security.FormsAuthentication.Decrypt(cookie.Value);
zxpUD = ZXPUserData.DeserializeZXPUserData(ticket.UserData);
if (!(zxpUD._isGuard || zxpUD._isLabAdmin || zxpUD._isLabPersonnel || zxpUD._isAccountManager || zxpUD._isAdmin)) //make sure this matches whats in Site.Master and Default
{
Response.BufferOutput = true;
Response.Redirect("/ErrorPage.aspx?ErrorCode=5", false);
}
}
else
{
Response.BufferOutput = true;
Response.Redirect("/Account/Login.aspx?ReturnURL=/COFAUpload.aspx", false); //zxp live
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in COFAUpload Page_Load(). Details: " + excep.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 2;
ErrorLogging.sendtoErrorPage(2);
}
catch (Exception ex)
{
string strErr = " Exception Error in COFAUpload Page_Load(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
}
}
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());
}
protected void Page_Load(object sender, EventArgs e)
{
//1- Check if user already authenticated
//2- IF user auth. then show all contents
//else look for query string user/passhash params
// if they exist - attempt to auth.
// if auth. success show all contents
//else show error message and quit
// else show error message and quit
int exceptionErrorCode = 0;
int autotrigger = 0;
try
{
truckReservationEmail = ConfigurationManager.AppSettings["SmtpUser"];
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
if (zxpUD._uid != new ZXPUserData()._uid)
{
sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
if (sql_connStr == String.Empty)
{
throw new Exception("Missing SQLConnectionString in web.config");
}
if (truckReservationEmail == String.Empty)
{
throw new Exception("Missing SmtpUser in web.config");
}
}
else
{
Response.BufferOutput = true;
bool isValidLoginURL = false;
string userName = Request.QueryString["UN"];
string password = Request.QueryString["PS"];
string strAuto = Request.QueryString["AUTOTRIGGER"]; //check if this should trigger all
autotrigger = Convert.ToInt32(strAuto);
if ((userName == null || userName == String.Empty) || (password == null || password == String.Empty))
{
exceptionErrorCode = 6;//error code for unable to validate login
throw new Exception("Unable to validate user: no login provided.");
}
else
{
isValidLoginURL = loginForAlertProcessing(userName, password);
}
if (isValidLoginURL == true)
{
string strUserData = zxpUD.SerializeZXPUserData(zxpUD);
System.Web.Security.FormsAuthenticationTicket ticket = new System.Web.Security.FormsAuthenticationTicket(1, userName, DateTime.Now, DateTime.Now.AddDays(5), true, strUserData);
string enticket = System.Web.Security.FormsAuthentication.Encrypt(ticket);
System.Web.HttpCookie authcookie = new System.Web.HttpCookie(System.Web.Security.FormsAuthentication.FormsCookieName, enticket);
if (ticket.IsPersistent)
{
authcookie.Expires = ticket.Expiration;
}
Response.Cookies.Add(authcookie);
}
else
{
exceptionErrorCode = 6;//error code for unable to validate login
throw new Exception("Unable to validate user.");
}
}
if (1 == autotrigger)
{
sendAllAlertsAutomatically();
}
showContents();
}
catch (SqlException excep)
{
string strErr = " SQLException Error in alertsProcessing Page_Load(). Details: " + excep.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 2;
ErrorLogging.sendtoErrorPage(2);
}
catch (Exception ex)
{
string strErr = " Exception Error in alertsProcessing Page_Load(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
if (exceptionErrorCode > 0)
{
System.Web.HttpContext.Current.Session["ErrorNum"] = exceptionErrorCode;
ErrorLogging.sendtoErrorPage(exceptionErrorCode);
}
else
{
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
}
}
}
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);
}
public static DateTime startRequest(int requestID, int requestTypeID, int MSID)
{
DateTime timeStamp = DateTime.Now;
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
using (var scope = new TransactionScope())
{
string sqlCmdText = string.Empty;
if (requestTypeID == 1) //Load
{
//loader - EventTypeID = 15 --> "Loading Started"
sqlCmdText = "INSERT INTO dbo.MainScheduleEvents (MSID, EventTypeID,Timestamp, UserId, isHidden) " +
"VALUES (@MSID, 15, @TIME, @LOADER, 'false'); " +
"SELECT SCOPE_IDENTITY()";
}
else if (requestTypeID == 2) //Unload
{
//loader - EventTypeID = 13 --> "Unloading Started"
sqlCmdText = "INSERT INTO dbo.MainScheduleEvents (MSID, EventTypeID,Timestamp, UserId, isHidden) " +
"VALUES (@MSID, 13, @TIME, @LOADER, 'false'); " +
"SELECT SCOPE_IDENTITY()";
}
else if (requestTypeID == 3) //Other
{
//loader - EventTypeID = 2030 --> "Loader Assignment Started"
sqlCmdText = "INSERT INTO dbo.MainScheduleEvents (MSID, EventTypeID,Timestamp, UserId, isHidden) " +
"VALUES (@MSID, 2030, @TIME, @LOADER, 'false'); " +
"SELECT SCOPE_IDENTITY()";
}
int eventID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID),
new SqlParameter("@TIME", timeStamp),
new SqlParameter("@LOADER", zxpUD._uid)));
ChangeLog Cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "Requests", "Assignee", timeStamp, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, zxpUD._uid.ToString(), eventID, "RequestID", requestID.ToString(), "RequestID", requestID.ToString());
Cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.Requests SET Assignee = @LOADER WHERE RequestID = @RID";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@LOADER", zxpUD._uid),
new SqlParameter("@RID", requestID));
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();
sqlCmdText = "INSERT INTO dbo.MainScheduleRequestEvents(RequestID, EventID) " +
"VALUES(@RID, @EID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@RID", requestID),
new SqlParameter("@EID", eventID));
scope.Complete();
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in loaderMobile startRequest(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile startRequest(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(timeStamp);
}
public static void AddFileDBEntry(int MSID, string fileType, string filenameOld, string filenameNew, string filepath, string fileDescription, int SampleID)
{
DateTime now = DateTime.Now;
int eventID = 0;
try
{
ZXPUserData zxpUD = ZXPUserData.GetZXPUserDataFromCookie();
using (var scope = new TransactionScope())
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
//First find filetypeID
sqlCmdText = "SELECT FileTypeID FROM dbo.FileTypes WHERE FileType = @FTYPE";
int filetypeID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@FTYPE", fileType)));
//1. create event in Main Schedule Events
sqlCmdText = "INSERT INTO dbo.MainScheduleEvents (MSID, EventTypeID, TimeStamp, UserID, isHidden) VALUES (@PMSID, 4097, @TSTAMP, @UserID, 'false'); " +
"SELECT CAST(scope_identity() AS int)";
eventID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@PMSID", MSID),
new SqlParameter("@TSTAMP", now),
new SqlParameter("@UserID", zxpUD._uid)));
//2. create file data in Main Schedule Files
sqlCmdText = "INSERT INTO dbo.MainScheduleFiles (MSID, FileTypeID, FileDescription, Filepath, FilenameNew, FilenameOld, isHidden) " +
"VALUES (@PMSID, @PFTID, @PDESC, @PFPATH, @PFNEW, @PFOLD, 0);" +
"SELECT SCOPE_IDENTITY()";
int newFileID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@PMSID", MSID),
new SqlParameter("@PFTID", filetypeID),
new SqlParameter("@PDESC", fileDescription),
new SqlParameter("@PFPATH", filepath),
new SqlParameter("@PFNEW", filenameNew),
new SqlParameter("@PFOLD", filenameOld)));
ChangeLog cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleFiles", "MSID", now, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, MSID.ToString(), eventID, "FileID", newFileID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleFiles", "FileTyepID", now, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, filetypeID.ToString(), eventID, "FileID", newFileID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleFiles", "FileDescription", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, fileDescription.ToString(), eventID, "FileID", newFileID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleFiles", "Filepath", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, filepath.ToString(), eventID, "FileID", newFileID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleFiles", "FilenameNew", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, filenameNew.ToString(), eventID, "FileID", newFileID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleFiles", "FilenameOld", now, zxpUD._uid, ChangeLog.ChangeLogDataType.NVARCHAR, filenameOld.ToString(), eventID, "FileID", newFileID.ToString());
cl.CreateChangeLogEntryIfChanged();
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.INSERT, "MainScheduleFiles", "isHidden", now, zxpUD._uid, ChangeLog.ChangeLogDataType.BIT, "0", eventID, "FileID", newFileID.ToString());
cl.CreateChangeLogEntryIfChanged();
//3.Update LastUpdated in MainSchedule
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "MainSchedule", "LastUpdated", now, zxpUD._uid, ChangeLog.ChangeLogDataType.DATETIME, now.ToString(), eventID, "MSID", MSID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.MainSchedule SET LastUpdated = @TSTAMP WHERE (MSID = @PMSID)";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@TSTAMP", now),
new SqlParameter("@PMSID", MSID));
//4. update samples tbl
cl = new ChangeLog(ChangeLog.ChangeLogChangeType.UPDATE, "Samples", "FileID_COFA", now, zxpUD._uid, ChangeLog.ChangeLogDataType.INT, newFileID.ToString(), eventID, "SampleID", SampleID.ToString());
cl.CreateChangeLogEntryIfChanged();
sqlCmdText = "UPDATE dbo.Samples SET FileID_COFA = @FID, COFAEventID = @eventID WHERE SampleID = @SampleID; ";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@FID", newFileID),
new SqlParameter("@eventID", eventID),
new SqlParameter("@SampleID", SampleID));
scope.Complete();
}
}
catch (Exception ex)
{
string strErr = " Exception Error in COFAUpload AddFileDBEntry(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
System.Web.HttpContext.Current.Session["ErrorNum"] = 1;
ErrorLogging.sendtoErrorPage(1);
throw ex;
}
}
public static ZXPUserData GetLoggedInUser()
{
return(ZXPUserData.GetZXPUserDataFromCookie());;
}
