/// <summary>
/// 1. Used to work out what DB File records need to be removed post ATM changes
/// 2. Used to get list of Files to associate with Job by WIS (JobRequestProcessor)
/// </summary>
/// <returns></returns>
public FileAssociationCollection GetFileAssociations()
{
FileAssociationCollection fileAssociations = null;
DataTable dtResults = null;
FinalBuild.DataAccess objADO = Domain.GetADOInstance(Domain.eConnectionName.Metadata);
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
string strStoredProcedure = "selActivityFileAssociations";
// Assemble Parameters
colParameters.Add(new SqlParameter("@ActivityID", mintID));
dtResults = objADO.GetDataTable(strStoredProcedure, "FileAssociations", (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
if (dtResults != null && dtResults.Rows.Count > 0)
{
FileAssociation fileMetadata = null;
fileAssociations = new FileAssociationCollection();
foreach (DataRow drFile in dtResults.Rows)
{
fileMetadata = new FileAssociation();
fileMetadata.Populate(drFile);
fileAssociations.Add(fileMetadata);
}
}
return fileAssociations;
}
public void LoadFileAssociations()
{
DataTable dtData = null;
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
string strStoredProcedure = "selJobAssociatedFiles";
colParameters.Add(new SqlParameter("@WMSourceID", mintID));
colParameters.Add(new SqlParameter("@WMSourceSystem", mobjSourceSystem.ToString()));
dtData = objADO.GetDataTable(strStoredProcedure, "FileAssociations", (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
objADO = null;
if (dtData != null && dtData.Rows.Count > 0)
{
mColFileAssociations = new FileAssociationCollection();
FileAssociation fileMetadata = null;
foreach (DataRow drMember in dtData.Rows)
{
fileMetadata = new FileAssociation();
fileMetadata.Populate(drMember);
mColFileAssociations.Add(fileMetadata);
}
}
}
public static FileAssociationCollection LoadByUser(string userID)
{
FileAssociationCollection collection = null;
DataTable dtData = null;
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
string strStoredProcedure = "selUserAssociatedFiles";
colParameters.Add(new SqlParameter("@UserID", userID));
dtData = objADO.GetDataTable(strStoredProcedure, "FileAssociations", (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
objADO = null;
if (dtData != null && dtData.Rows.Count > 0)
{
collection = new FileAssociationCollection();
FileAssociation fileMetadata = null;
foreach (DataRow drMember in dtData.Rows)
{
fileMetadata = new FileAssociation();
fileMetadata.Populate(drMember);
collection.Add(fileMetadata);
}
}
return collection;
}