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