protected void newEvent(object sender, EventArgs e) { HttpCookie userCookie; userCookie = Request.Cookies["UserID"]; User_Class myUser = new User_Class(); myUser = myUser.getUser(userCookie.Value); myUser.getFriends(); Events_Class events = new Events_Class(); //events.Date = TextBoxDate.Text; //TextBoxDate.Text = "disabled"; events.Date = Calendar1.SelectedDate.ToString(); events.Location = TextBoxLocation.Text; events.Description = TextBoxDescription.Text; int indice = 0; events.Users.Add(myUser); foreach (ListItem li in ListBox2.Items) { indice = Int32.Parse(li.Value); events.Users.Add(myUser.Friends[indice]); } events.addEvent(); Response.Redirect("Events.aspx", true); }
public bool addEvent(Events_Class item) { bool añadido=false; try { if(item.Description.Length>=50) item.Description=item.Description.ToString().Substring(0,50); if (item.Location.Length >= 50) item.Location=item.Location.ToString().Substring(0, 50); SqlConnection con = new SqlConnection(connection); string sql = "INSERT INTO EVENTS (DATE,DESCRIPTION,LOCATION) OUTPUT INSERTED.ID VALUES ('" + item.Date.ToString() + "', '" + item.Description.ToString() + "', '" + item.Location.ToString()+ "')"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { item.Id = Int32.Parse(reader["ID"].ToString()); } cmd.Connection.Close(); SqlCommand cmd1; String sql2; foreach (User_Class user in item.Users) { sql2 = "INSERT INTO US_EV_REL(UID, EID) VALUES (" + user.Id + "," + item.Id + ")"; cmd1 = new SqlCommand(sql2, con); cmd1.Connection.Open(); cmd1.ExecuteNonQuery(); cmd1.Connection.Close(); } añadido = true; } catch (Exception ex) { añadido = false; } finally { } return añadido; }
protected void Page_Load(object sender, EventArgs e) { HttpCookie userCookie; HttpCookie passCookie; userCookie = Request.Cookies["UserID"]; passCookie = Request.Cookies["UserPass"]; if (userCookie == null || passCookie == null) { Response.Redirect("../Account/Login.aspx"); } else { User_Class usuario_sesion = new User_Class(); usuario_sesion = usuario_sesion.getUser(userCookie.Value); if (usuario_sesion.Pass == passCookie.Value) { String s; s = Request.QueryString["ID"]; if (s != null) { int id = Int32.Parse(s); User_Class myUser = new User_Class(); myUser = myUser.getUser(userCookie.Value); Events_Class events = new Events_Class(); events = events.getEvent(id); events.addUser(myUser); Label1.Text = events.ToString(); Response.Redirect("..//Asp_forms/Events.aspx"); } } else { Response.Redirect("../Account/Login.aspx"); } } }
protected void Search(object sender, EventArgs e) { HttpCookie userCookie; userCookie = Request.Cookies["UserID"]; User_Class myUser = new User_Class(); myUser = myUser.getUser(userCookie.Value); Events_Class events = new Events_Class(); List<Events_Class> eventsList = new List<Events_Class>(); eventsList = events.searchEvents(TextBox1.Text, myUser.Id); int totalEvents = eventsList.Count(); int counter = 0; Panel p = new Panel(); Label t = new Label(); HyperLink le = new HyperLink(); while (counter < totalEvents) { string id = eventsList[counter].Id.ToString(); p = new Panel(); t = new Label(); le = new HyperLink(); p.ID = "panel" + id; t.ID = "t" + id; le.ID = "le" + id; t.Text = eventsList[counter].ToString()+ "<BR>"; le.Text = "ADD"; le.NavigateUrl = "~/Asp_forms/AddToEvents.aspx?ID=" + eventsList[counter].Id; p.Controls.Add(t); p.Controls.Add(le); Panel2.Controls.Add(p); counter++; } }
protected void Page_Load(object sender, EventArgs e) { HttpCookie userCookie; HttpCookie passCookie; userCookie = Request.Cookies["UserID"]; passCookie = Request.Cookies["UserPass"]; if (userCookie == null || passCookie == null) { Response.Redirect("../Account/Login.aspx"); } else { User_Class usuario_sesion = new User_Class(); usuario_sesion = usuario_sesion.getUser(userCookie.Value); if (usuario_sesion.Pass == passCookie.Value) { User_Class myUser = new User_Class(); myUser = myUser.getUser(userCookie.Value); Events_Class events = new Events_Class(); List<Events_Class> eventsList = new List<Events_Class>(); eventsList = events.userEvents(myUser.Id); int totalEvents = eventsList.Count(); int counter = 0; Panel p = new Panel(); Label t = new Label(); HyperLink le = new HyperLink(); Panel header = new Panel(); Panel content = new Panel(); Panel footer = new Panel(); Panel cal = new Panel(); Panel textcontent = new Panel(); Label texto2 = new Label(); while (counter < totalEvents) { string id = eventsList[counter].Id.ToString(); p = new Panel(); t = new Label(); Label t2 = new Label(); Label t3 = new Label(); le = new HyperLink(); ImageButton removeButton = new ImageButton(); p.ID = "panel" + id; t.ID = "t" + id; le.ID = "le" + id; t3.Text = "<BR><BR>" + eventsList[counter].Date.ToString(); t2.Text = "<BR>" + eventsList[counter].Description.ToString() + "<BR><BR>"; t.Text = eventsList[counter].Location.ToString() + "<BR>"; t.CssClass = "cal_location"; t2.CssClass = "cal_description"; t3.CssClass = "cal_date"; removeButton.ToolTip = "Remove"; removeButton.ImageUrl = "../Images/deleteButton.png"; removeButton.PostBackUrl = "~/Asp_forms/RemoveUserFromEvents.aspx?ID=" + eventsList[counter].Id; removeButton.Width = 20; header = new Panel(); content = new Panel(); footer = new Panel(); cal = new Panel(); textcontent = new Panel(); texto2 = new Label(); header.ID = "header" + id; content.ID = "content" + id; footer.ID = "footer" + id; cal.ID = "cal" + id; footer.CssClass = "calfooter"; header.CssClass = "calheader"; header.HorizontalAlign = HorizontalAlign.Center; content.CssClass = "calcontent"; textcontent.CssClass = "caldefault"; cal.CssClass = "cal"; content.BackColor = System.Drawing.Color.White; header.Height = 82; header.Width = 300; footer.Height = 50; header.Controls.Add(t3); textcontent.Controls.Add(t); textcontent.Controls.Add(t2); textcontent.Controls.Add(le); textcontent.Controls.Add(removeButton); content.Controls.Add(textcontent); cal.Controls.Add(header); cal.Controls.Add(content); cal.Controls.Add(footer); cal.Width = 300; Panel2.Controls.Add(cal); counter++; } } else { Response.Redirect("../Account/Login.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { //When the page reloads keeps the cursor on the same position Page.MaintainScrollPositionOnPostBack = true; HttpCookie userCookie; HttpCookie passCookie; userCookie = Request.Cookies["UserID"]; passCookie = Request.Cookies["UserPass"]; if (userCookie == null || passCookie == null) { Response.Redirect("../Account/Login.aspx"); } else { User_Class usuario_sesion = new User_Class(); usuario_sesion = usuario_sesion.getUser(userCookie.Value); if (usuario_sesion.Pass == passCookie.Value) { if (!IsPostBack) { User_Class myUser = new User_Class(); myUser = myUser.getUser(userCookie.Value); Events_Class events = new Events_Class(); myUser.getFriends(); ListBox1.Items.Clear(); ListBox1.Width = 100; ListBox2.Width = 100; int i = 0; ListItem l = new ListItem(); while (i < myUser.Friends.Count) { l = new ListItem(); l.Text = myUser.Friends[i].Name; l.Value = i.ToString(); ListBox1.Items.Add(l); i++; } } } else { Response.Redirect("../Account/Login.aspx"); } } }
public List<Events_Class> userNewEvents(int userID) { SqlConnection con = new SqlConnection(connection); List<Events_Class> eventsList = new List<Events_Class>(); try { string sql = "SELECT * FROM EVENTS WHERE ID NOT IN(SELECT EID FROM US_EV_REL WHERE UID = " + userID + ")"; SqlCommand cmd = new SqlCommand(sql, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); Events_Class events = new Events_Class(); while (reader.Read()) { events = new Events_Class(); events.Id = int.Parse(reader["ID"].ToString()); events.Date = reader["DATE"].ToString(); events.Description = reader["DESCRIPTION"].ToString(); events.Location = reader["LOCATION"].ToString(); eventsList.Add(events); } } catch (Exception ex) { } finally { con.Close(); } return eventsList; }
public void updateEvent(Events_Class item) { SqlConnection con = new SqlConnection(connection); string sql = "UPDATE EVENTS SET DATE = " + item.Date + ", DESCRIPTION = " + item.Description + ", LOCATION = " + item.Location + "WHERE ID = " + item.Id; SqlCommand cmd = new SqlCommand(sql, con); try { con.Open(); cmd.ExecuteNonQuery(); } catch { } finally { con.Close(); } }
public Events_Class obtainEvent(int id) { SqlConnection con = new SqlConnection(connection); string sql = "SELECT * FROM EVENTS WHERE ID = " + id; Events_Class events = new Events_Class(); try { SqlCommand cmd = new SqlCommand(sql, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { events = new Events_Class(); events.Id = int.Parse(reader["ID"].ToString()); events.Date = DateTime.Parse(reader["DATE"].ToString()).ToShortDateString(); events.Description = reader["DESCRIPTION"].ToString(); events.Location = reader["LOCATION"].ToString(); } } catch (Exception ex) { } finally { con.Close(); } return events; }
public bool deleteEvent(Events_Class item) { bool borrado; SqlConnection con = new SqlConnection(connection); string sql = "DELETE FROM EVENTS WHERE ID = " + item.Id; SqlCommand cmd = new SqlCommand(sql, con); try { con.Open(); cmd.ExecuteNonQuery(); borrado = true; } catch (Exception ex) { borrado = false; } finally { con.Close(); } return borrado; }
public void unirEvento(Events_Class ec) { events.Add(ec); this.updateUser(); }