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);
}
