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