public static System.Xml.XmlDocument GetSerializedContent(int jobID, eJobFailureType failureType, DateTime failureDate) { System.Xml.XmlDocument serializedContent = null; DataTable dtResults = null; FinalBuild.DataAccess objADO = Domain.GetADOInstance(); System.Collections.ArrayList colParameters = new System.Collections.ArrayList(); string strStoredProcedure = "selFailedJobSerializedContent"; colParameters.Add(new SqlParameter("@WMSourceID", jobID)); colParameters.Add(new SqlParameter("@FailureType", failureType.ToString())); if (failureDate != DateTime.MinValue) { colParameters.Add(new SqlParameter("@FailureDate", failureDate)); } dtResults = objADO.GetDataTable(strStoredProcedure, "FailedJobs", (SqlParameter[])colParameters.ToArray(typeof(SqlParameter))); foreach (DataRow drSerializedContent in dtResults.Rows) { if (!drSerializedContent["Serialized"].Equals(DBNull.Value)) { serializedContent = new System.Xml.XmlDocument(); serializedContent.LoadXml(drSerializedContent["Serialized"].ToString()); //.Replace(" xmlns=\"http://FinalBuild.co.uk/BusinessObjects.WorkManagement\"", string.Empty)); return serializedContent; } } return serializedContent; }
public static bool Remove(int jobID, eJobFailureType failureType, DateTime failureDate) { DataAccess objADO = new DataAccess(); ArrayList colParameters = new ArrayList(); string strStoredProcedure = "delFailedJobAudit"; colParameters.Add(new SqlParameter("@WMSourceID", jobID)); colParameters.Add(new SqlParameter("@FailureType", failureType.ToString())); if (failureDate != DateTime.MinValue) { colParameters.Add(new SqlParameter("@FailureDate", failureDate)); } int intReturn = objADO.ExecuteSQL(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter))); objADO = null; return (intReturn > 0); }
public static System.Xml.XmlDocument GetSerializedContent(int jobID, eJobFailureType failureType) { return GetSerializedContent(jobID, failureType, DateTime.MinValue); }
public static bool Remove(int jobID, eJobFailureType failureType) { return Remove(jobID, failureType, DateTime.MinValue); }