public XElement RegisterActivity(int project, string title, int parentActivity, int priority,
string due, string reminder, int completed)
{
XElement x = new XElement("activities");
DBHelper db = new DBHelper(dbcstring);
DateTime ddue = DateTime.Parse(due),
dreminder = DateTime.Parse(reminder);
bool bcompleted = (completed > 0);
int registeredid = db.RegisterActivity(project, title, ddue, parentActivity,
Convert.ToByte(priority), dreminder, bcompleted);
AActivity activity = db.GetActivity(registeredid);
if (activity != null)
{
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));
x.Add(xproject);
}
return x;
}
public XElement UpdateReminder(int activity, string reminder)
{
XElement x = new XElement("activities");
DBHelper db = new DBHelper(dbcstring);
db.UpdateReminder(activity, DateTime.Parse(reminder));
AActivity aactivity = db.GetActivity(activity);
if (aactivity != null)
{
XElement xproject = new XElement("activity");
xproject.Add(new XElement("id", aactivity.ID.ToString()));
xproject.Add(new XElement("title", aactivity.Title.Trim()));
xproject.Add(new XElement("date", aactivity.Date));
xproject.Add(new XElement("created", aactivity.Created));
xproject.Add(new XElement("reminder", aactivity.Reminder));
xproject.Add(new XElement("priority", aactivity.Priority));
xproject.Add(new XElement("completed", aactivity.Completed));
x.Add(xproject);
}
return x;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] != null)
CurrentUser = (AUser)Session["user"];
if (!Page.IsPostBack)
{
string sid = Request.QueryString["view"];
int id;
int.TryParse(sid, out id);
db = new DBHelper(AgentUtileries.dbcstring);
Session["db"] = db;
CurrentActivity = db.GetActivity(id);
// Si hay una actividad actual, obtener sus otros datos.
if (CurrentActivity != null)
{
OwnerProject = db.GetProject(CurrentActivity.ProjectID);
ParentActivity = db.GetActivity(CurrentActivity.Parent);
ChildActivities = db.GetChildActivities(CurrentActivity.ID);
ActivityImages = db.GetImages(CurrentActivity.ID);
Session["activity"] = CurrentActivity;
}
}
else
{
CurrentActivity = (AActivity)Session["activity"];
db = (DBHelper)Session["db"];
if (CurrentActivity != null)
{
OwnerProject = db.GetProject(CurrentActivity.ProjectID);
ParentActivity = db.GetActivity(CurrentActivity.Parent);
ChildActivities = db.GetChildActivities(CurrentActivity.ID);
Title = CurrentActivity.Title;
}
}
}