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 Object GetStatusOptions()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT StatusID, StatusText FROM dbo.Status";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview GetStatusOptions(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
protected void sendOneAlert(object sender, EventArgs e)
{
Button btn = (Button)sender;
List <object[]> data = new List <object[]>();
AlertMessenger aMsgr = new AlertMessenger();
string truckMsg = getTruckIdentifierMessage(btn);
string tankMsg = getTankCapacityMessage(btn);
try
{
int alertID = Convert.ToInt32(btn.CommandArgument);
EventAlertsHelper eaHelper = new EventAlertsHelper();
eaHelper.createAndSendAlertEmail(alertID, truckMsg + tankMsg);
eaHelper.createAndSendAlertSMS(alertID, truckMsg + tankMsg);
}
catch (SqlException excep)
{
string strErr = " SQLException Error in alertsProcessing sendOneAlert(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in alertsProcessing sendOneAlert(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
finally
{
}
}
protected void updateAlertRunsTable(int alertID, DateTime timestamp, int?MSID, string AlertsRunObjectValue)
{
try
{
int runNum = getTimesAlertRan(alertID, MSID, AlertsRunObjectValue);
if (runNum > 0)
{
updateAlertRunsEntry(alertID, timestamp, runNum + 1, MSID, AlertsRunObjectValue);
}
else
{
createAlertRunsEntry(alertID, timestamp, MSID, AlertsRunObjectValue);
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in alertsProcessing updateAlertRunsTable(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in alertsProcessing updateAlertRunsTable(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
}
public static DataSet GetTruckInfoForRejectCustomMessage(int MSID)
{
DataSet TruckData = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT MS.PONumber, MS.PONumber_ZXPOutbound, MS.CustomerID, MS.TrailerNumber, MS.RejectionComment, U.FirstName, U.LastName, " +
"ISNULL(ProdDet.PDCount, 0) AS ProdCount, ProdDet.topProdID, PCMS.ProductName_CMS " +
"FROM dbo.MainSchedule AS MS " +
"INNER JOIN dbo.MainScheduleEvents MSE ON MS.MSID = MSE.MSID " +
"INNER JOIN dbo.Users U ON U.UserID = MSE.UserId " +
"LEFT JOIN (SELECT MSID, COUNT(PODetailsID) AS PDCount, " +
"(SELECT TOP 1 PD_A.ProductID_CMS " +
"FROM dbo.PODetails PD_A " +
"INNER JOIN dbo.ProductsCMS PCMS_A ON PD_A.ProductID_CMS = PCMS_A.ProductID_CMS " +
"WHERE PD_A.MSID = PD.MSID " +
") AS topProdID " +
"FROM dbo.PODetails PD " +
"GROUP BY MSID " +
") ProdDet ON ProdDet.MSID = MS.MSID " +
"LEFT JOIN dbo.ProductsCMS PCMS ON PCMS.ProductID_CMS = ProdDet.topProdID " +
"WHERE MS.MSID = @MSID AND MSE.EventTypeID = 2037";
TruckData = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID));
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck GetTruckInfoForRejectCustomMessage(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(TruckData);
}
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()
public static Object getDockSpotsForVan()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT SpotID, SpotDescription FROM TruckDockSpots Where SpotType = 'Van' AND isDisabled = 0 ORDER BY SpotDescription";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getDockSpotsForVan(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
public static List <vw_LoadAndUnloadRequests> getLoadAndUnloadRequests(int MSID)
{
List <vw_LoadAndUnloadRequests> requestsData = new List <vw_LoadAndUnloadRequests>();
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
string sqlCmdText = "SELECT RequestID, RequestTypeID, TimeRequestStart, TimeRequestEnd FROM dbo.vw_LoadAndUnloadRequests WHERE MSID = @msid";
SqlDataReader reader = SqlHelper.ExecuteReader(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID));
while (reader.Read())
{
int RequestID = reader.GetValueOrDefault <int>("RequestID");
int RequestTypeID = reader.GetValueOrDefault <int>("RequestTypeID");
DateTime?TimeRequestStart = reader.GetValueOrDefault <DateTime>("TimeRequestStart");
DateTime?TimeRequestEnd = reader.GetValueOrDefault <DateTime>("TimeRequestEnd");
TimeRequestStart = TimeRequestStart == default(DateTime) ? null : TimeRequestStart;
TimeRequestEnd = TimeRequestEnd == default(DateTime) ? null : TimeRequestEnd;
vw_LoadAndUnloadRequests request = new vw_LoadAndUnloadRequests(RequestID, MSID, RequestTypeID, TimeRequestStart, TimeRequestEnd);
requestsData.Add(request);
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in loaderMobile getLoadAndUnloadRequests(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile getLoadAndUnloadRequests(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(requestsData);
}
public static Object GetPODetailsFromMSID(int MSID)
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT PD.PODetailsID, PD.ProductID_CMS, PD.QTY, PD.LotNumber, PD.UnitOfMeasure, PCMS.ProductName_CMS " +
"FROM dbo.PODetails PD " +
"LEFT JOIN dbo.ProductsCMS PCMS ON PCMS.ProductID_CMS = PD.ProductID_CMS " +
"WHERE PD.MSID = @MSID ORDER BY PD.ProductID_CMS ";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID));
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview GetPODetailsFromMSID(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
private void createAlertRunsEntry(int alertID, DateTime timestamp, int?MSID, string AlertRunsObjectID)
{
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
using (var scope = new TransactionScope())
{
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.StoredProcedure, "sp_truckschedapp_LogAlertRuns", new SqlParameter("@pALERTID", alertID),
new SqlParameter("@pTIME", timestamp),
new SqlParameter("@pMSID", TransportHelperFunctions.convertStringEmptyToDBNULL(MSID)),
new SqlParameter("@pOBJID", TransportHelperFunctions.convertStringEmptyToDBNULL(AlertRunsObjectID)));
scope.Complete();
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in alertsProcessing createAlertRunsEntry(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in alertsProcessing createAlertRunsEntry(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
finally
{
}
}
public static List <int> getColorCellSettings()
{
List <int> listOfCellColorSettings = new List <int>();
int yellowCellSetting;
int orangeCellSetting;
int redCellSetting;
try
{
yellowCellSetting = Convert.ToInt32(ConfigurationManager.AppSettings["yellowDemurrage"]);
orangeCellSetting = Convert.ToInt32(ConfigurationManager.AppSettings["orangeDemurrage"]);
redCellSetting = Convert.ToInt32(ConfigurationManager.AppSettings["redDemurrage"]);
listOfCellColorSettings.Add(yellowCellSetting);
listOfCellColorSettings.Add(orangeCellSetting);
listOfCellColorSettings.Add(redCellSetting);
}
catch (SqlException excep)
{
string strErr = " SQLException Error in WaitAndDockOverview getColorCellSettings(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getColorCellSettings(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
finally
{
}
return(listOfCellColorSettings);
}
public static Object getTimeDiff()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT * FROM " +
"(SELECT MS.MSID, " +
"(SELECT TOP 1 MSE.Timestamp FROM dbo.MainScheduleEvents MSE WHERE EventTypeID = 1025 AND MSE.MSID = MS.MSID and isHidden = 'false' ORDER BY TimeStamp DESC) As StartTime, " +
"(SELECT TOP 1 MSE.Timestamp FROM dbo.MainScheduleEvents MSE WHERE EventTypeID = 1026 AND MSE.MSID = MS.MSID and isHidden = 'false' ORDER BY TimeStamp DESC) As EndTime " +
"FROM dbo.MainSchedule AS MS " +
"WHERE MS.isOpenInCMS = 'true' " +
") AS DemurrageTime " +
"WHERE StartTime IS NOT NULL AND EndTime IS NULL";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getTimeDiff(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
public static Object getPendSamplesTruckData()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT MS.MSID, MS.PONumber, MS.LocationShort, S.SampleID, S.TestApproved, TrailerNumber, MS.StatusID, isRejected, MS.isOpenInCMS, " +
"DATEDIFF(minute, (SELECT TOP 1 MSE.Timestamp FROM dbo.MainScheduleEvents MSE WHERE EventTypeID = 1025 AND MSE.MSID = MS.MSID and isHidden = 'false' ORDER BY TimeStamp DESC), GETDATE() ) AS DemurrageTime, " +
"PCMS.ProductName_CMS, POD.ProductID_CMS " +
"FROM dbo.MainSchedule AS MS " +
"INNER JOIN dbo.PODetails AS POD ON MS.MSID = POD.MSID " +
"INNER JOIN dbo.Samples AS S ON S.PODetailsID = POD.PODetailsID " +
"LEFT JOIN dbo.ProductsCMS AS PCMS ON POD.ProductID_CMS = PCMS.ProductID_CMS " +
"WHERE S.isHidden = 0 AND MS.isHidden = 0 AND MS.isOpenInCMS = 'true' AND S.TestApproved IS NULL " +
//"WHERE S.isHidden = 0 AND MS.isHidden = 0 AND TestApproved IS NULL AND (MS.LocationShort NOT IN ('NOS')) " +
"ORDER BY MS.MSID";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getPendSamplesTruckData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
public static Object getDockBulkData()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT MS.MSID, MS.PONumber, MS.TrailerNumber, MS.currentDockSpotID, " +
"(SELECT TOP(1) MSE.TimeStamp FROM dbo.MainScheduleEvents AS MSE WHERE MSE.MSID = MS.MSID AND MSE.isHidden = 'false' AND (MSE.EventTypeID = 6)) TimePlacedInDock, MS.isRejected, MS.isOpenInCMS, " +
"DATEDIFF(minute, (SELECT TOP 1 MSE.Timestamp FROM dbo.MainScheduleEvents MSE WHERE EventTypeID = 1025 AND MSE.MSID = MS.MSID and isHidden = 'false' ORDER BY TimeStamp DESC), GETDATE() ) AS DemurrageTime " +
"FROM dbo.MainSchedule AS MS WHERE MS.LocationShort = 'DOCKBULK' AND MS.isHidden = 'false'";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getDockBulkData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
public static Object getWaitingAreaData()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT MS.MSID, MS.PONumber, MS.TrailerNumber, MS.isDropTrailer," +
"(SELECT TOP 1 S.StatusText FROM dbo.Status AS S WHERE S.StatusID = MS.StatusID) AS Status, MS.isEmpty, MS.WaitingAreaComment, " +
"(SELECT TOP 1 MSE.TimeStamp FROM dbo.MainScheduleEvents AS MSE WHERE MSE.EventTypeID = 3074 AND MS.MSID = MSE.MSID AND isHidden = 'false') AS EmptyTime, MS.isOpenInCMS, MS.isRejected, " +
"DATEDIFF(minute, (SELECT TOP 1 MSE.Timestamp FROM dbo.MainScheduleEvents MSE WHERE EventTypeID = 1025 AND MSE.MSID = MS.MSID and isHidden = 'false' ORDER BY TimeStamp DESC), GETDATE() ) AS DemurrageTime, " +
"(SELECT TOP (1) MSE.TimeStamp FROM dbo.MainScheduleEvents AS MSE WHERE MSE.EventTypeID = 4 AND MS.MSID = MSE.MSID AND isHidden = 'false' order by TimeStamp DESC) AS ArrivedAtWaitTime " +
"FROM dbo.MainSchedule AS MS " +
"WHERE MS.LocationShort = 'WAIT' AND MS.isHidden = 'false'";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getWaitingAreaData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
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 int getTimesAlertRan(int alertID, int?MSID, string AlertRunsObjectID)
{
int runNum = 0;
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
using (var scope = new TransactionScope())
{
string sqlCmdText;
sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT TimesRan FROM dbo.AlertRuns WHERE AlertID = @ALERTID";
if (MSID == null && string.IsNullOrEmpty(AlertRunsObjectID))
{
runNum = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@ALERTID", alertID)));
}
else if (MSID != null && string.IsNullOrEmpty(AlertRunsObjectID))
{
sqlCmdText = sqlCmdText + " AND MSID = @MSID";
runNum = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", TransportHelperFunctions.convertStringEmptyToDBNULL(MSID)),
new SqlParameter("@ALERTID", alertID)));
}
else if (!string.IsNullOrEmpty(AlertRunsObjectID) && MSID == null)
{
sqlCmdText = sqlCmdText + " AND ObjectID = @OBJID";
runNum = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@ALERTID", alertID),
new SqlParameter("@OBJID", TransportHelperFunctions.convertStringEmptyToDBNULL(AlertRunsObjectID))));
}
else if (!string.IsNullOrEmpty(AlertRunsObjectID) && MSID != null)
{
sqlCmdText = sqlCmdText + " AND ObjectID = @OBJID AND MSID = @MSID";
runNum = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@ALERTID", alertID),
new SqlParameter("@MSID", TransportHelperFunctions.convertStringEmptyToDBNULL(MSID)),
new SqlParameter("@OBJID", TransportHelperFunctions.convertStringEmptyToDBNULL(AlertRunsObjectID))));
}
scope.Complete();
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in alertsProcessing getTimesAlertRan(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in alertsProcessing getTimesAlertRan(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
finally
{
}
return(runNum);
}
public static Object getTrailerInYardData()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT MS.MSID, MS.PONumber, MS.TrailerNumber, " +
"(SELECT TOP 1 S.StatusText FROM dbo.Status AS S WHERE S.StatusID = MS.StatusID) AS Status, MS.isDropTrailer, " +
"(SELECT TOP 1 MSE.TimeStamp FROM dbo.MainScheduleEvents AS MSE WHERE MSE.EventTypeID = 3070 AND MS.MSID = MSE.MSID AND isHidden = 'false') AS DroppedTime, MS.isEmpty, MS.YardComment, " +
"(SELECT TOP 1 MSE.TimeStamp FROM dbo.MainScheduleEvents AS MSE WHERE MSE.EventTypeID = 3074 AND MS.MSID = MSE.MSID AND isHidden = 'false') AS EmptyTime, MS.isOpenInCMS, " +
"DATEDIFF(minute, (SELECT TOP 1 MSE.Timestamp FROM dbo.MainScheduleEvents MSE WHERE EventTypeID = 1025 AND MSE.MSID = MS.MSID and isHidden = 'false' ORDER BY TimeStamp DESC), GETDATE() ) AS DemurrageTime, " +
"ISNULL(ProdDet.PDCount, 0) AS ProdCount, ProdDet.topProdID, PCMS.ProductName_CMS " +
"FROM dbo.MainSchedule AS MS " +
"LEFT JOIN (SELECT MSID, COUNT(PODetailsID) AS PDCount, " +
"(SELECT TOP 1 PD_A.ProductID_CMS " +
"FROM dbo.PODetails PD_A " +
"INNER JOIN dbo.ProductsCMS PCMS_A ON PD_A.ProductID_CMS = PCMS_A.ProductID_CMS " +
"WHERE PD_A.MSID = PD.MSID " +
") AS topProdID " +
"FROM dbo.PODetails PD " +
"GROUP BY MSID " +
") ProdDet ON ProdDet.MSID = MS.MSID " +
"LEFT JOIN dbo.ProductsCMS PCMS ON PCMS.ProductID_CMS = ProdDet.topProdID " +
"LEFT JOIN dbo.TrailersInYard as TiY ON Tiy.MSID = MS.MSID " +
"WHERE (MS.LocationShort = 'YARD' OR (MS.LocationShort = 'NOS' AND TiY.MSID is not NULL)) AND MS.isRejected = 'false' AND MS.isHidden = 'false' " +
"UNION " +
"SELECT -1 AS MSID, -1 AS PONumber, TiY.TrailerNumber, " +
"'Waiting' AS Status, 'false' AS isDropTrailer, " +
"NULL AS DroppedTime, 'true' AS isEmpty, NULL AS YardComment, " +
"NULL AS EmptyTime, -1 AS isOpenInCMS, NULL AS DemurrageTime, " +
"0 AS ProdCount, NULL AS topProdID, NULL AS ProductName_CMS " +
"FROM dbo.TrailersInYard as TiY " +
"WHERE tiy.MSID is Null";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getTrailerInYardData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
private void updateAlertRunsEntry(int alertID, DateTime timestamp, int newRunNum, int?MSID, string AlertRunsObjectID)
{
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
using (var scope = new TransactionScope())
{
string sqlCmdText;
sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "UPDATE dbo.AlertRuns SET TimeStampAlertLastRan = @TIME, TimesRan = @RUN WHERE AlertID = @ALERTID";
if (MSID == null && string.IsNullOrEmpty(AlertRunsObjectID))
{
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@ALERTID", alertID));
}
else if (MSID != null && string.IsNullOrEmpty(AlertRunsObjectID))
{
sqlCmdText = sqlCmdText + " AND MSID = @MSID";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", TransportHelperFunctions.convertStringEmptyToDBNULL(MSID)),
new SqlParameter("@ALERTID", alertID));
}
else if (!string.IsNullOrEmpty(AlertRunsObjectID) && MSID == null)
{
sqlCmdText = sqlCmdText + " AND ObjectID = @OBJID";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@ALERTID", alertID),
new SqlParameter("@OBJID", TransportHelperFunctions.convertStringEmptyToDBNULL(AlertRunsObjectID)));
}
else if (!string.IsNullOrEmpty(AlertRunsObjectID) && MSID != null)
{
sqlCmdText = sqlCmdText + " AND ObjectID = @OBJID AND MSID = @MSID";
SqlHelper.ExecuteNonQuery(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@ALERTID", alertID),
new SqlParameter("@MSID", TransportHelperFunctions.convertStringEmptyToDBNULL(MSID)),
new SqlParameter("@OBJID", TransportHelperFunctions.convertStringEmptyToDBNULL(AlertRunsObjectID)));
}
scope.Complete();
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in alertsProcessing updateAlertRunsEntry(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in alertsProcessing updateAlertRunsEntry(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
finally
{
}
}
public static Sample getSampleInformationForMSID(int MSID)
{
Sample sampleInfo = new Sample();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = string.Concat("SELECT MSID ,PODetailsID ,PONumber ,ProductID_CMS ,FileID ,Filepath ,FilenameOld ,SampleID, LotusID ,TimeSampleTaken ,TimeSampleSent ",
",TimeSampleReceived ,didLabNotReceived ,Comments ,FilenameNew ,TestApproved ,TrailerNumber ,FirstName ,LastName ,bypassCOFAComment ,SpecificGravity ",
",isOpenInCMS ,isRejected ,ProductName_CMS ",
"FROM dbo.vw_SampleGridData ",
"WHERE MSID = @pMSID ",
"ORDER BY TestApproved, didLabNotReceived, TimeSampleReceived");
SqlDataReader reader = SqlHelper.ExecuteReader(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@pMSID", MSID));
while (reader.Read())
{
sampleInfo.MSID = reader.GetValueOrDefault <int>("MSID");
sampleInfo.PODetailsID = reader.GetValueOrDefault <int>("PODetailsID");
sampleInfo.PONumber = reader.GetValueOrDefault <int>("PONumber");
sampleInfo.ProductID_CMS = reader.GetValueOrDefault <string>("ProductID_CMS");
sampleInfo.FileID = reader.GetValueOrDefault <int>("FileID");
sampleInfo.Filepath = reader.GetValueOrDefault <string>("Filepath");
sampleInfo.FilenameOld = reader.GetValueOrDefault <string>("FilenameOld");
sampleInfo.SampleID = reader.GetValueOrDefault <int>("SampleID");
sampleInfo.LotusID = reader.GetValueOrDefault <string>("LotusID");
DateTime?tempTime = reader.GetValueOrDefault <DateTime>("TimeSampleTaken");
sampleInfo.TimeSampleTaken = tempTime == default(DateTime)? null: tempTime;
DateTime?tempTime2 = reader.GetValueOrDefault <DateTime>("TimeSampleReceived");
sampleInfo.TimeSampleReceived = tempTime == default(DateTime) ? null : tempTime2;
sampleInfo.didLabNotReceived = reader.GetValueOrDefault <int>("didLabNotReceived");
sampleInfo.Comments = reader.GetValueOrDefault <string>("Comments");
sampleInfo.FilenameNew = reader.GetValueOrDefault <string>("FilenameNew");
sampleInfo.TestApproved = reader.GetValueOrDefault <bool>("TestApproved");
sampleInfo.TrailerNumber = reader.GetValueOrDefault <string>("TrailerNumber");
sampleInfo.FirstName = reader.GetValueOrDefault <string>("FirstName");
sampleInfo.LastName = reader.GetValueOrDefault <string>("LastName");
sampleInfo.bypassCOFAComment = reader.GetValueOrDefault <string>("bypassCOFAComment");
sampleInfo.SpecificGravity = reader.GetValueOrDefault <int>("SpecificGravity");
sampleInfo.isOpenInCMS = reader.GetValueOrDefault <bool>("isOpenInCMS");
sampleInfo.isRejected = reader.GetValueOrDefault <bool>("isRejected");
sampleInfo.ProductName_CMS = reader.GetValueOrDefault <string>("ProductName_CMS");
}
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile getSampleGridData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(sampleInfo);
}
public static ICollection <Tuple <string, string> > GetProductInfoRejectCustomMessage(int MSID)
{
DataSet productInfo = new DataSet();
string productName;
string partNum;
ICollection <Tuple <string, string> > listOfProductDetails = new List <Tuple <string, string> >();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT PODetailsID, ProductID_CMS " +
"FROM dbo.PODetails POD " +
"WHERE MSID = @MSID";
productInfo = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID));
foreach (System.Data.DataRow row in productInfo.Tables[0].Rows)
{
if (productInfo.Tables[0].Rows[0]["ProductID_CMS"].Equals(DBNull.Value))
{
productName = "";
}
else
{
productName = Convert.ToString(productInfo.Tables[0].Rows[0]["ProductID_CMS"]);
}
if (productInfo.Tables[0].Rows[0]["PODetailsID"].Equals(DBNull.Value))
{
partNum = "";
}
else
{
partNum = Convert.ToString(productInfo.Tables[0].Rows[0]["PODetailsID"]);
}
listOfProductDetails.Add(Tuple.Create(partNum, productName));
}
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck GetProductInfoRejectCustomMessage(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(listOfProductDetails);
}
public static bool CheckInspectionValidationSetting()
{
bool ValidationSetting = false;
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
ValidationSetting = InspectionsHelperFunctions.CheckInspectionValidationSetting(sql_connStr);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile CheckInspectionValidationSetting(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(ValidationSetting);
}
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 Object GetGridData()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
//gets MSID and other data needed
sqlCmdText = "SELECT MS.MSID, MS.PONumber, MS.TrailerNumber, LS.LocationLong, " +
"(SELECT TOP 1 TimeStamp FROM dbo.MainScheduleEvents MSE WHERE (MSE.MSID = MS.MSID) AND (MS.isRejected = 'true') AND (isHidden = 'false') ORDER BY Timestamp DESC) AS TimeRejected, " +
"MS.RejectionComment, MS.isOpenInCMS, " +
"ISNULL(ProdDet.PDCount, 0) AS ProdCount, ProdDet.topProdID, PCMS.ProductName_CMS " +
"FROM dbo.MainSchedule AS MS " +
"INNER JOIN dbo.Locations LS ON LS.LocationShort = MS.LocationShort " +
"LEFT JOIN (SELECT MSID, COUNT(PODetailsID) AS PDCount, " +
"(SELECT TOP 1 PD_A.ProductID_CMS " +
"FROM dbo.PODetails PD_A " +
"INNER JOIN dbo.ProductsCMS PCMS_A ON PD_A.ProductID_CMS = PCMS_A.ProductID_CMS " +
"WHERE PD_A.MSID = PD.MSID " +
") AS topProdID " +
"FROM dbo.PODetails PD " +
"GROUP BY MSID " +
") ProdDet ON ProdDet.MSID = MS.MSID " +
"LEFT JOIN dbo.ProductsCMS PCMS ON PCMS.ProductID_CMS = ProdDet.topProdID " +
"WHERE isHidden = 0 AND LS.LocationShort != 'NOS' " +
"ORDER BY MSID";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck GetGridData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
private bool loginForAlertProcessing(string userName, string password)
{
ZXPUserData zxpUD = new ZXPUserData();
int rowCount = 0;
bool isValidUser = false;
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
using (var scope = new TransactionScope())
{
string sqlCmdText;
sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT COUNT (*) FROM dbo.Users WHERE [Password] = @UPASS AND UserName = @UNAME AND isDisabled = 0";
rowCount = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@UNAME", userName), new SqlParameter("@UPASS", DataTransformer.PasswordHash(password))));
if (rowCount > 0)
{
isValidUser = true;
}
else
{
isValidUser = false;
throw new Exception("Invalid login.");
}
scope.Complete();
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in alertsProcessing loginForAlertProcessing(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in alertsProcessing loginForAlertProcessing(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
finally
{
}
return(isValidUser);
}
public static Object getScheduledTrucks()
{
List <object[]> data = new List <object[]>();
DataSet dataSet = new DataSet();
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT MS.MSID, PONumber, MS.ETA, MS.Comments, TimeArrived, TimeDeparted, " +
//"(SELECT TOP (1) TimeStamp FROM dbo.MainScheduleEvents MSE LEFT JOIN dbo.EventSubTypes EST ON MSE.EventSubTypeID = EST.EventSubTypeID WHERE MSE.MSID = MS.MSID AND (MSE.EventTypeID = 2 OR (MSE.EventTypeID = 3064 AND EventSubType = 'GSO')) AND isHidden = 'false' ORDER BY TimeStamp DESC) AS CheckIn, " +
//"(SELECT TOP (1) TimeStamp FROM dbo.MainScheduleEvents MSE LEFT JOIN dbo.EventSubTypes EST ON MSE.EventSubTypeID = EST.EventSubTypeID WHERE MSE.MSID = MS.MSID AND (MSE.EventTypeID = 19 OR (MSE.EventTypeID = 3064 AND EventSubType = 'REL')) AND isHidden = 'false' ORDER BY TimeStamp DESC) AS CheckOut, " +
"TrailerNumber, isRejected, MS.LocationShort, MS.StatusID, MS.currentDockSpotID, MS.DockSpotID, MS.isOpenInCMS, " +
"DATEDIFF(minute, (SELECT TOP 1 MSE.Timestamp FROM dbo.MainScheduleEvents MSE WHERE EventTypeID = 1025 AND MSE.MSID = MS.MSID and isHidden = 'false' ORDER BY TimeStamp DESC), GETDATE() ) AS DemurrageTime, " +
"ISNULL(ProdDet.PDCount, 0) AS ProdCount, ProdDet.topProdID, PCMS.ProductName_CMS " +
"FROM dbo.MainSchedule AS MS " +
"LEFT JOIN (SELECT MSID, COUNT(PODetailsID) AS PDCount, " +
"(SELECT TOP 1 PD_A.ProductID_CMS " +
"FROM dbo.PODetails PD_A " +
"INNER JOIN dbo.ProductsCMS PCMS_A ON PD_A.ProductID_CMS = PCMS_A.ProductID_CMS " +
"WHERE PD_A.MSID = PD.MSID " +
") AS topProdID " +
"FROM dbo.PODetails PD " +
"GROUP BY MSID " +
") ProdDet ON ProdDet.MSID = MS.MSID " +
"LEFT JOIN dbo.ProductsCMS PCMS ON PCMS.ProductID_CMS = ProdDet.topProdID " +
"WHERE MS.isHidden = 0 AND ((MS.ETA <= (CONVERT(date, getdate()+ 1))) AND (MS.ETA >= (CONVERT(date, getdate()))))";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText);
//populate return object
foreach (System.Data.DataRow row in dataSet.Tables[0].Rows)
{
data.Add(row.ItemArray);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in WaitAndDockOverview getAvailableDockSpots(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
public static DataSet GetPOdetailsData(int prodDetailID)
{
DataSet dsPODetails = new DataSet();
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
dsPODetails = InspectionsHelperFunctions.GetPOdetailsData(prodDetailID, sql_connStr);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile GetPOdetailsData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(dsPODetails);
}
public static List <vw_LoaderMobileMainGridData> getLoaderMobileGrid()
{
List <vw_LoaderMobileMainGridData> gridData = new List <vw_LoaderMobileMainGridData>();
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
string sqlCmdText = string.Concat("SELECT MSID, StatusID, StatusText, TrailerNumber, SpotID, SpotDescription, ",
"ProdID, ProdName, PODetailsID, PONumber, PONumber_ZXPOutbound, ETA FROM dbo.vw_LoaderMobileGridData");
SqlDataReader reader = SqlHelper.ExecuteReader(sql_connStr, CommandType.Text, sqlCmdText);
while (reader.Read())
{
vw_LoaderMobileMainGridData rowEntry = new vw_LoaderMobileMainGridData();
rowEntry.MSID = reader.GetValueOrDefault <int>("MSID");
rowEntry.StatusID = reader.GetValueOrDefault <int>("StatusID");
rowEntry.StatusName = reader.GetValueOrDefault <string>("StatusText");
rowEntry.TrailerNumber = reader.GetValueOrDefault <string>("TrailerNumber");;
rowEntry.SpotID = reader.GetValueOrDefault <int>("SpotID");;
rowEntry.SpotName = reader.GetValueOrDefault <string>("SpotDescription");
rowEntry.ProductID_CMS = reader.GetValueOrDefault <string>("ProdID");
rowEntry.ProductName_CMS = reader.GetValueOrDefault <string>("ProdName");
rowEntry.PODetailsID = reader.GetValueOrDefault <int>("PODetailsID");
rowEntry.PONumber = reader.GetValueOrDefault <int>("PONumber").ToString();
rowEntry.PONumber_ZXPOutbound = reader.GetValueOrDefault <string>("PONumber_ZXPOutbound");
rowEntry.ETA = reader.GetValueOrDefault <DateTime>("ETA");
gridData.Add(rowEntry);
}
}
catch (SqlException excep)
{
string strErr = " SQLException Error in loaderMobile getLoaderMobileGrid(). Details: " + excep.ToString();
ErrorLogging.LogErrorAndRedirect(2, strErr);
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile getLoaderMobileGrid(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(gridData);
}
public static Object CheckCurrentStatus(int MSID)
{
DataSet dataSet = new DataSet();
List <string> data = new List <string>();
string loc;
string stat;
bool isRejected;
string rejTime;
try
{
string sqlCmdText;
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
sqlCmdText = "SELECT TOP (1) MS.LocationShort, (SELECT S.StatusText FROM dbo.Status AS S WHERE S.StatusID = MS.StatusID) AS Status, MS.isRejected, " +
"(SELECT TOP (1) MSE.TimeStamp FROM dbo.MainScheduleEvents AS MSE WHERE (MSE.MSID = MS.MSID) AND (MSE.isHidden = 'false') AND (MSE.EventTypeID = 2037)) AS RejectTime " +
"FROM dbo.MainSchedule AS MS WHERE MSID = @MSID";
dataSet = SqlHelper.ExecuteDataset(sql_connStr, CommandType.Text, sqlCmdText, new SqlParameter("@MSID", MSID));
loc = Convert.ToString(dataSet.Tables[0].Rows[0]["LocationShort"]);
stat = Convert.ToString(dataSet.Tables[0].Rows[0]["Status"]);
isRejected = Convert.ToBoolean(dataSet.Tables[0].Rows[0]["isRejected"]);
if (dataSet.Tables[0].Rows[0]["RejectTime"].Equals(DBNull.Value))
{
rejTime = "0";
}
else
{
rejTime = dataSet.Tables[0].Rows[0]["RejectTime"].ToString();
}
data.Add(loc);
data.Add(stat.ToString());
data.Add(isRejected.ToString());
data.Add(rejTime.ToString());
}
catch (Exception ex)
{
string strErr = " Exception Error in RejectTruck CheckCurrentStatus(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(data);
}
public static InspectionList getMSInspectionListAndData(int MSID, string ProductID_CMS, int InspectionListID)
{
InspectionList inspList = new InspectionList();
try
{
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
int prodDetailID = InspectionsHelperFunctions.getPOdetailsIDForMSIDandProduct(MSID, ProductID_CMS, sql_connStr);
if (0 != prodDetailID)
{
inspList = InspectionsHelperFunctions.getMSInspectionListAndData(prodDetailID, InspectionListID, sql_connStr);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in loaderMobile getMSInspectionListAndData(). Details: " + ex.ToString();
ErrorLogging.LogErrorAndRedirect(1, strErr);
}
return(inspList);
}
