public int createNewUserAgentStringEntry()
{
int newUserAgentStringID;
SQLDataConnectionHelper sqlConnHelper = new SQLDataConnectionHelper();
try
{
using (var scope = new TransactionScope())
{
sqlConnHelper.setSqlConnectionStringUsingConfiguration();
sqlConnHelper.openConnection();
string sql_connStr = new TruckScheduleConfigurationKeysHelper().sql_connStr;
newUserAgentStringID = Convert.ToInt32(SqlHelper.ExecuteScalar(sql_connStr, CommandType.StoredProcedure, "sp_truckscheduleapp_insertNewUserAgentString", new SqlParameter("@pUserAgentString", this.userAgentString)));
scope.Complete();
}
}
catch (Exception ex)
{
string strErr = " Exception Error in UserAgentString getUserAgentStringID(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
throw ex;
}
finally
{
if (sqlConnHelper.doesConnectionExist())
{
sqlConnHelper.closeConnection();
}
}
return(newUserAgentStringID);
}
public List <InspectionList> getMainscheduleInspectionLists()
{
List <InspectionList> inspList = new List <InspectionList>();
SQLDataConnectionHelper sqlConnHelper = new SQLDataConnectionHelper();
try
{
sqlConnHelper.setSqlConnectionStringUsingConfiguration();
sqlConnHelper.openConnection();
SqlCommand sqlCmd = new SqlCommand("sp_truckschedapp_getMainScheduleInspectionListsForMSID", sqlConnHelper.getConnection());
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter pHidden = new SqlParameter("@pIsHidden", SqlDbType.Bit);
SqlParameter pMSID = new SqlParameter("@pMSID", SqlDbType.Int);
pHidden.Value = 0;
sqlCmd.Parameters.Add(pHidden);
DataSet dsMSILists = new DataSet();
DataTable tblMSILists = new DataTable();
System.Data.SqlClient.SqlDataReader sqlReader = sqlCmd.ExecuteReader();
dsMSILists.Tables.Add(tblMSILists);
dsMSILists.Load(sqlReader, LoadOption.OverwriteChanges, tblMSILists);
//populate return object
foreach (System.Data.DataRow row in dsMSILists.Tables[0].Rows)
{
//InspectionList nIL = new InspectionList();
//nIL.setMSInspectionListID(Convert.ToInt32(row["MSInspectionListID"]));
//nIL.setMSID(Convert.ToInt32(row["MSID"]));
//nIL.setInspectionListID(Convert.ToInt32(row["InspectionListID"]));
//nIL.setInspectionListName(row["InspectionListName"].ToString());
//nIL.setProductID_CMS(row["ProductID_CMS"].ToString());
//nIL.setRunNumber(Convert.ToInt32(row["RunNumber"]));
//inspList.Add(nIL);
}
}
catch (Exception ex)
{
string strErr = " Exception Error in ScheduledTruck getMainscheduleInspectionLists(). Details: " + ex.ToString();
ErrorLogging.WriteEvent(strErr, EventLogEntryType.Error);
throw ex;
}
return(inspList);
}
