public XElement GetProject(int projectid)
{
XElement x = new XElement("projects");
DBHelper db = new Model.DBHelper(dbcstring);
AProject project = db.GetProject(projectid);
if (project != null)
{
XElement xproject = new XElement("project");
xproject.Add(new XElement("id", project.ID.ToString()));
xproject.Add(new XElement("title", project.Title.Trim()));
int actCount = db.GetActivities(project.ID).Count;
xproject.Add(new XElement("activitycount", actCount.ToString()));
x.Add(xproject);
}
return(x);
}
public XElement GetProjects(int user)
{
XElement x = new XElement("projects");
DBHelper db = new Model.DBHelper(dbcstring);
List <AProject> projects = db.GetProjects(user);
foreach (AProject project in projects)
{
XElement xproject = new XElement("project");
xproject.Add(new XElement("id", project.ID.ToString()));
xproject.Add(new XElement("title", project.Title.Trim()));
int actCount = db.GetActivities(project.ID).Count;
xproject.Add(new XElement("activitycount", actCount.ToString()));
x.Add(xproject);
}
return(x);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] != null)
{
CurrentUser = (AUser)Session["user"];
DBHelper db = new DBHelper(AgentUtileries.dbcstring);
Projects = db.GetProjects(CurrentUser.ID);
string sid = Request.QueryString["view"];
int id;
int.TryParse(sid, out id);
CurrentProject = db.GetProject(id);
ActivityList = db.GetActivities(id);
foreach(AActivity a in ActivityList) {
if (a.Completed) Completed++;
}
Title = CurrentProject.Title;
}
}
public XElement GetActivities(int project)
{
XElement x = new XElement("activities");
DBHelper db = new Model.DBHelper(dbcstring);
List <AActivity> activities = db.GetActivities(project);
foreach (AActivity activity in activities)
{
XElement xproject = new XElement("activity");
xproject.Add(new XElement("id", activity.ID.ToString()));
xproject.Add(new XElement("title", activity.Title.Trim()));
xproject.Add(new XElement("date", activity.Date));
xproject.Add(new XElement("created", activity.Created));
xproject.Add(new XElement("reminder", activity.Reminder));
xproject.Add(new XElement("priority", activity.Priority));
xproject.Add(new XElement("completed", activity.Completed));
xproject.Add(new XElement("parent", activity.Parent));
x.Add(xproject);
}
return(x);
}
public XElement GetActivities(int project)
{
XElement x = new XElement("activities");
DBHelper db = new Model.DBHelper(dbcstring);
List<AActivity> activities = db.GetActivities(project);
foreach (AActivity activity in activities)
{
XElement xproject = new XElement("activity");
xproject.Add(new XElement("id", activity.ID.ToString()));
xproject.Add(new XElement("title", activity.Title.Trim()));
xproject.Add(new XElement("date", activity.Date));
xproject.Add(new XElement("created", activity.Created));
xproject.Add(new XElement("reminder", activity.Reminder));
xproject.Add(new XElement("priority", activity.Priority));
xproject.Add(new XElement("completed", activity.Completed));
xproject.Add(new XElement("parent", activity.Parent));
x.Add(xproject);
}
return x;
}
public XElement GetProjects(int user)
{
XElement x = new XElement("projects");
DBHelper db = new Model.DBHelper(dbcstring);
List<AProject> projects = db.GetProjects(user);
foreach (AProject project in projects)
{
XElement xproject = new XElement("project");
xproject.Add(new XElement("id", project.ID.ToString()));
xproject.Add(new XElement("title", project.Title.Trim()));
int actCount = db.GetActivities(project.ID).Count;
xproject.Add(new XElement("activitycount", actCount.ToString()));
x.Add(xproject);
}
return x;
}
public XElement GetProject(int projectid)
{
XElement x = new XElement("projects");
DBHelper db = new Model.DBHelper(dbcstring);
AProject project = db.GetProject(projectid);
if (project != null)
{
XElement xproject = new XElement("project");
xproject.Add(new XElement("id", project.ID.ToString()));
xproject.Add(new XElement("title", project.Title.Trim()));
int actCount = db.GetActivities(project.ID).Count;
xproject.Add(new XElement("activitycount", actCount.ToString()));
x.Add(xproject);
}
return x;
}
