public static JobReferenceCollection GetJobReferences(eJobStatus jobStatus, string sourceSystem, int siteID)
{
DataTable dtResults = null;
FinalBuild.DataAccess objADO = Domain.GetADOInstance();
System.Data.SqlClient.SqlParameter[] arrParameters;
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
string strStoredProcedure = "selJobReferencesByJobStatus";
// Assemble Parameters
colParameters.Add(new SqlParameter("@JobStatus", jobStatus.ToString()));
colParameters.Add(new SqlParameter("@WMSourceSystem", sourceSystem));
if (siteID > 0)
{
colParameters.Add(new SqlParameter("@SiteID", siteID));
}
arrParameters = (SqlParameter[])colParameters.ToArray(typeof(SqlParameter));
dtResults = objADO.GetDataTable(strStoredProcedure, "JobReferences", arrParameters);
return Populate(dtResults);
}
/// <summary>
/// Shorthand method for creating and queuing a JobStatusChange in a one line call
/// </summary>
/// <param name="jobID"></param>
/// <param name="sourceSystem"></param>
/// <param name="jobStatus"></param>
/// <param name="userID"></param>
/// <param name="lastUpdated"></param>
/// <param name="jobInstanceNumber"></param>
/// <param name="service"></param>
/// <param name="windowsIdentity"></param>
/// <param name="isOfficeUser"></param>
/// <param name="incompleteReason"></param>
/// <param name="extendedProperties"></param>
public static void Broadcast(int jobID, eWMSourceSystem sourceSystem, eJobStatus jobStatus, string userID, DateTime lastUpdated, int jobInstanceNumber, string service, string windowsIdentity, bool isOfficeUser, IncompleteReason incompleteReason, SerializableHashTable extendedProperties)
{
JobStatusChange statusChange = new JobStatusChange();
statusChange.ID = jobID;
statusChange.SourceSystem = sourceSystem;
statusChange.Status = jobStatus;
statusChange.UserID = userID;
statusChange.LastUpdated = lastUpdated;
statusChange.Service = service;
statusChange.InstanceNumber = jobInstanceNumber;
if (windowsIdentity == null)
{
statusChange.WindowsIdentity = Environment.UserName;
}
else
{
statusChange.WindowsIdentity = windowsIdentity;
}
statusChange.IsOfficeUser = isOfficeUser;
statusChange.IncompleteReason = incompleteReason;
statusChange.ExtendedProperties = extendedProperties;
statusChange.EnqueueMessage();
}
/// <summary>
/// Shorthand method for creating and queuing a JobStatusChange in a one line call
/// </summary>
/// <param name="jobID"></param>
/// <param name="sourceSystem"></param>
/// <param name="jobStatus"></param>
/// <param name="userID"></param>
/// <param name="lastUpdated"></param>
/// <param name="jobInstanceNumber"></param>
/// <param name="service"></param>
/// <param name="windowsIdentity"></param>
/// <param name="isOfficeUser"></param>
/// <param name="incompleteReason"></param>
public static void Broadcast(int jobID, eWMSourceSystem sourceSystem, eJobStatus jobStatus, string userID, DateTime lastUpdated, int jobInstanceNumber, string service, string windowsIdentity, bool isOfficeUser, IncompleteReason incompleteReason)
{
Broadcast(jobID, sourceSystem, jobStatus, userID, lastUpdated, jobInstanceNumber, service, windowsIdentity, isOfficeUser, incompleteReason);
}
/// <summary>
/// Shorthand method for creating and queuing a JobStatusChange in a one line call
/// </summary>
/// <param name="jobID"></param>
/// <param name="sourceSystem"></param>
/// <param name="jobStatus"></param>
/// <param name="userID"></param>
/// <param name="jobInstanceNumber"></param>
/// <param name="service"></param>
/// <param name="windowsIdentity"></param>
public static void Broadcast(int jobID, eWMSourceSystem sourceSystem, eJobStatus jobStatus, string userID, int jobInstanceNumber, string service, string windowsIdentity)
{
Broadcast(jobID, sourceSystem, jobStatus, userID, DateTime.Now, jobInstanceNumber, service, windowsIdentity, false, null, null);
}
