public XElement DeleteActivity(int activityid) { XElement x = new XElement("activities"); DBHelper db = new DBHelper(dbcstring); db.DeleteActivity(activityid); return x; }
public XElement DeleteProject(int projectid) { XElement x = new XElement("projects"); DBHelper db = new DBHelper(dbcstring); db.DeleteProject(projectid); return x; }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] != null) { DBHelper db = new DBHelper(AgentUtileries.dbcstring); CurrentUser = (AUser)Session["user"]; CurrentUser = db.GetUser(CurrentUser.ID); Session["user"] = CurrentUser; Projects = db.GetProjects(CurrentUser.ID); Page.Title = CurrentUser.Name; } }
public void ProcessRequest(HttpContext context) { string id = context.Request.QueryString["id"]; AImage image = new DBHelper(AgentUtileries.dbcstring).GetImage(int.Parse(id)); char[] sep = { '.' }; string[] splittedName = image.FileName.Split(sep); string type = splittedName[splittedName.Length - 1]; context.Response.ContentType = "image/" + type; context.Response.OutputStream.Write(image.FileData, 0, image.FileData.Length); }
protected void BLogin_Click(object sender, EventArgs e) { string email = TBEmail.Text, password = TBPassword.Text; DBHelper db = new DBHelper(AgentUtileries.dbcstring); int id = db.Authenticate(email, password); if (id > 0) { AUser user = db.GetUser(id); Session["user"] = user; Response.Redirect("~/Default.aspx"); } else { Response.Redirect("~/User/Login.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] != null) { CurrentUser = (AUser)Session["user"]; DBHelper db = new DBHelper(AgentUtileries.dbcstring); DateTime today = DateTime.Today, end; string sdate = Request.QueryString["for"]; switch (sdate) { case "today": end = today.AddDays(1); TimeText = "hoy"; break; case "week": end = today.AddDays(7); TimeText = "esta semana"; break; case "month": end = today.AddMonths(1); TimeText = "este mes"; break; case "year": end = today.AddYears(1); TimeText = "este año"; break; default: end = today.AddDays(7); TimeText = "esta semana"; break; } List<AActivity> all = db.GetAllActivities(CurrentUser.ID); Projects = db.GetProjects(CurrentUser.ID); ActivityList = new List<AActivity>(); foreach (AActivity activity in all) { if (activity.Date.Value.Ticks > today.Ticks && activity.Date.Value.Ticks < end.Ticks) ActivityList.Add(activity); } Title = "Actividades para " + TimeText; } }
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); }
public XElement Authenticate(string email, string password) { XElement x = new XElement("users"); DBHelper db = new DBHelper(AgentUtileries.dbcstring); int result = db.Authenticate(email, password); if (result > 0) { AUser user = db.GetUser(result); XElement xuser = new XElement("user"); xuser.Add(new XElement("ID", user.ID)); xuser.Add(new XElement("Email", user.Email)); xuser.Add(new XElement("Name", user.Name)); x.Add(xuser); } 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; } }
protected void Page_Load(object sender, EventArgs e) { // Comprobar que hay una sesión de usuario activa. if (Session["user"] != null) { CurrentUser = (AUser)Session["user"]; DBHelper db = new DBHelper(AgentUtileries.dbcstring); Projects = db.GetProjects(CurrentUser.ID); Reminders = new List<AActivity>(); List<AActivity> all = db.GetAllActivities(CurrentUser.ID); DateTime today = DateTime.Today, tomorrow = today.AddDays(1); foreach (AActivity activity in all) { if (activity.Reminder.Value.Ticks > today.Ticks && activity.Reminder.Value.Ticks < tomorrow.Ticks) Reminders.Add(activity); } } }
public XElement GetChildActivities(int activity) { XElement x = new XElement("activities"); DBHelper db = new Model.DBHelper(dbcstring); List <AActivity> activities = db.GetChildActivities(activity); foreach (AActivity aactivity in activities) { 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)); xproject.Add(new XElement("parent", aactivity.Parent)); x.Add(xproject); } return(x); }
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 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 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 UpdateUser(int userid, string name) { XElement x = new XElement("users"); DBHelper db = new DBHelper(AgentUtileries.dbcstring); db.UpdateName(userid, name); AUser user = db.GetUser(userid); if (user != null) { XElement xuser = new XElement("user"); xuser.Add(new XElement("ID", user.ID)); xuser.Add(new XElement("Email", user.Email)); xuser.Add(new XElement("Name", user.Name)); x.Add(xuser); } 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; }
public XElement UpdateProjectTitle(int projectid, string title) { XElement x = new XElement("projects"); DBHelper db = new DBHelper(dbcstring); db.UpdateProjectTitle(projectid, title); 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())); x.Add(xproject); } return x; }
public XElement RegisterUser(string email, string password, string name) { XElement x = new XElement("users"); DBHelper db = new DBHelper(AgentUtileries.dbcstring); db.RegisterUser(email, password, name); 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; } } }
public XElement RegisterProject(int user, string title) { XElement x = new XElement("projects"); DBHelper db = new DBHelper(dbcstring); int registeredId = db.RegisterProject(user, title); AProject project = db.GetProject(registeredId); if (project != null) { XElement xproject = new XElement("project"); xproject.Add(new XElement("id", project.ID.ToString())); xproject.Add(new XElement("title", project.Title.Trim())); 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; }