protected CollectionBase GenerateMilestoneCollectionFromReader(IDataReader returnData)
{
MilestoneCollection mlsCollection = new MilestoneCollection();
while (returnData.Read())
{
Milestone newMilestone = new Milestone((int)returnData["MilestoneId"], (int)returnData["ProjectId"], (string)returnData["MilestoneName"], (string)returnData["MilestoneImageUrl"]);
mlsCollection.Add(newMilestone);
}
return(mlsCollection);
}
public static MilestoneCollection GetMilestonesByCaseID(Int64 CaseID)
{
MilestoneCollection c = new MilestoneCollection();
DataTable dt = Execute.FillDataTable(StoredProcedures.GetMilestonesByCaseID, new System.Data.SqlClient.SqlParameter("CaseID", CaseID));
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Milestone o = new Milestone();
LoadMilestoneByReader(row, o);
c.Add(o);
}
}
return(c);
}