private void GetDesignTimeData()
{
AllProjects = projects;
Activities = observableCollectionActivities;
SelectedProjects = new ProjectsCollection(projects);
SelectedProjects.Add(projects[0]);
}
/// <summary Get Collection>
/// Get collection of emails. If no records to return, EmailCollection will be null.
/// </summary>
/// <returns></returns>
public static ProjectsCollection GetCollection()
{
ProjectsCollection tempList = null;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_GetProjects", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", SelectTypeEnum.GetCollection);
myConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
tempList = new ProjectsCollection();
while (myReader.Read())
{
tempList.Add(FillDataRecord(myReader));
}
}
myReader.Close();
}
}
}
return tempList;
}
private void AddNewProject(Project project)
{
if (SelectedTile != null)
{
// There is a tile selected so add this new project to it's collection of sub projects
SelectedTile.SubItems.Add(project);
}
else
{
// No selected tile so project must be top level
ProjectsCollection.Add(project);
}
}
private void RefreshData()
{
GetRunTimeData();
var selected = new ProjectsCollection();
foreach (var oldProject in SelectedProjects)
{
//Check if New Project List contains Selected Project
//Check if New Activity List contains Selected Project Activity
if (AllProjects.Contains(oldProject) && Activities.Contains(oldProject.Activity))
{
//Get Project from the server(In case Name or other data were changed)
var newProject = AllProjects[AllProjects.IndexOf(oldProject)];
//Add Project to selected List only if Project and Activity are still available
selected.Add(newProject);
}
}
SelectedProjects = selected;
}
public static ProjectsCollection GetAll() {
resourceSchema.Dal.Projects dbo = null;
try {
dbo = new resourceSchema.Dal.Projects();
System.Data.DataSet ds = dbo.Projects_Select_All();
ProjectsCollection collection = new ProjectsCollection();
if (GlobalTools.IsSafeDataSet(ds)) {
for (int i = 0; (i < ds.Tables[0].Rows.Count); i = (i + 1)) {
Projects obj = new Projects();
obj.Fill(ds.Tables[0].Rows[i]);
if ((obj != null)) {
collection.Add(obj);
}
}
}
return collection;
}
catch (System.Exception ) {
throw;
}
finally {
if ((dbo != null)) {
dbo.Dispose();
}
}
}