public static JobReferenceCollection Populate(DataTable collectionMembers)
{
JobReferenceCollection colReferences = new JobReferenceCollection();
foreach (DataRow drMember in collectionMembers.Rows)
{
colReferences.Add(JobReference.Create(drMember));
}
return colReferences;
}
public static JobReferenceCollection GetJobReferences(Customer customer)
{
JobReferenceCollection references = new JobReferenceCollection();
DataTable dtResults = null;
FinalBuild.DataAccess objADO = Domain.GetADOInstance();
System.Data.SqlClient.SqlParameter[] arrParameters;
System.Collections.ArrayList colParameters = new System.Collections.ArrayList();
string strStoredProcedure = "selJobReferencesByCustomer";
// Assemble Parameters
colParameters.Add(new SqlParameter("@CustomerID", customer.ID));
// colParameters.Add(new SqlParameter("@ParentCustomerID", customer.ParentCustomerID));
arrParameters = (SqlParameter[])colParameters.ToArray(typeof(SqlParameter));
dtResults = objADO.GetDataTable(strStoredProcedure, "JobReferences", arrParameters);
for (int index = 0; index < dtResults.Rows.Count; index++)
{
references.Add(new JobReference());
references[index].SourceID = dtResults.Rows[index]["WMSourceID"].ToString();
references[index].ID = int.Parse(references[index].SourceID);
references[index].Region = dtResults.Rows[index]["PostCode"].ToString();
}
return references;
}
public void Populate(DataSet jobReferences)
{
// Note. Ordering of return sets to match FieldData SP selUserWork
if (jobReferences != null && jobReferences.Tables.Count > 0)
{
// New
if (jobReferences.Tables[0].Rows.Count > 0)
{
mColNew = new JobReferenceCollection();
foreach (DataRow drJob in jobReferences.Tables[0].Rows)
{
mColNew.Add(JobReference.Create(drJob,true));
}
}
// Removed
if (jobReferences.Tables.Count > 1 && jobReferences.Tables[1].Rows.Count > 0)
{
mColRemoved = new JobReferenceCollection();
foreach (DataRow drJob in jobReferences.Tables[1].Rows)
{
mColRemoved.Add(JobReference.Create(drJob, true));
}
}
// Modified
if (jobReferences.Tables.Count > 2 && jobReferences.Tables[2].Rows.Count > 0)
{
mColModified = new JobReferenceCollection();
foreach (DataRow drJob in jobReferences.Tables[2].Rows)
{
mColModified.Add(JobReference.Create(drJob, true));
}
}
// Supporing Data
if (jobReferences.Tables.Count > 3 && jobReferences.Tables[3].Rows.Count > 0)
{
mColSupportingDataRequests = SupportingDataRequestCollection.Populate(jobReferences.Tables[3]);
}
}
}