public static List <ProjectCount> GetProjectNoteCounts()
{
List <ProjectCount> projectNoteCountList = new List <ProjectCount>();
string query = @"SELECT projectID, COUNT(*) AS noteCount
FROM notedb.notes
GROUP BY projectID";
MySqlCommand com = new MySqlCommand(query);
com.CommandType = System.Data.CommandType.Text;
DataTable dt = RunNotesQuery(com);
foreach (DataRow r in dt.Rows)
{
ProjectCount pc = new ProjectCount();
if (!DBNull.Value.Equals(r[0]))
{
pc.projectID = Convert.ToInt32(r[0].ToString());
}
else
{
pc.projectID = -1; //No projectID
}
pc.noteCount = Convert.ToInt32(r[1].ToString());
projectNoteCountList.Add(pc);
}
return(projectNoteCountList);
}
// private MobileServiceCollection<, Project> items;
private async void getProjects()
{
items = await projectTable.Where(Project => Project.Owner == Global.GetRepositoryValue("userName").ToString()).ToCollectionAsync();
foreach (var project in items)
{
Debug.Write(project.Id);
bids = await bidTable.Where(Bid => Bid.ProjectId == project.Id.ToString()).ToCollectionAsync();
Debug.Write(" count " + bids.Count + " ");
var count = new ProjectCount {
Project = project, BidCount = (int)bids.Count, Bids = bids.ToList()
};
projectCount.Add(count);
}
//gridView.ItemsSource = items;
// Global.SetRepositoryValue("MyPost", projectCount);
}
private void _ProjectCount_CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)
{
SumAll = ProjectCount.Sum();
}