protected void Page_Load(object sender, EventArgs e) { HttpCookie userCookie; userCookie = Request.Cookies["UserID"]; if (userCookie == null) { Response.Redirect("../Account/Login.aspx"); } else { Party_Class party = new Party_Class(); List<Party_Class> partyList = new List<Party_Class>(); User_Class myUser = new User_Class(); myUser = myUser.getUser(userCookie.Value); partyList = party.userGroups(myUser.Id); HyperLink link = new HyperLink(); Panel p = new Panel(); int i = partyList.Count() - 1; while(i>=0) { string id = partyList[i].Id.ToString(); link = new HyperLink(); link.CssClass = "button white"; link.Width=300; link.Height = 30; p = new Panel(); link.ID = "link" + id; p.ID = "panel" + id; link.Text = partyList[i].Name; link.NavigateUrl = "~/Asp_forms/Groups_Notes.aspx?ID=" + id; p.Controls.Add(link); Panel2.Controls.Add(p); i--; } } }
protected void Delete(object sender, EventArgs e) { string s = Request.QueryString["ID"]; if (s != null) { Party_Class party = new Party_Class(); party.Id = Int32.Parse(s); if (party.deleteParty()) { Response.Redirect("~/Asp_forms/Groups.aspx"); } else { Label l = new Label(); l.Text = "An error has occurred. Please clean up the cork table before perform this action."; Panel2.Controls.Add(l); } } }
protected void Create_Note(object sender, EventArgs e) { HttpCookie userCookie; userCookie = Request.Cookies["UserID"]; if (userCookie == null) { Response.Redirect("../Account/Login.aspx"); } else { string s = Request.QueryString["ID"]; if (s != null) { Party_Class party = new Party_Class(); party.Id = Int32.Parse(s); User_Class user = new User_Class(); user = user.getUser(userCookie.Value); Note_Class note = new Note_Class(); note.Text = DescripcionNota.Text; note.Date = DateTime.Now.ToShortDateString(); if (party.addNote(note, user.Id)) { Page.MaintainScrollPositionOnPostBack = true; Response.Redirect("~/Asp_forms/Groups_Notes.aspx?ID=" + party.Id); } else Label2.Text = "An error has occurred"; } } /* Create note with the button 'New Note' */ }
public bool createParty(Party_Class party) { bool creada=false; SqlConnection con = new SqlConnection(connection); try { //con.Open(); Console.WriteLine("hola"); string sql = "INSERT INTO PARTY (NAME) OUTPUT INSERTED.ID VALUES ('" + party.Name + "')"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); int id = -1; if (reader.Read()) { id = int.Parse(reader["ID"].ToString()); } cmd.Connection.Close(); SqlCommand cmd1; String sql2; foreach (User_Class user in party.Users) { sql2 = "INSERT INTO US_PA_REL(UID, PID) VALUES (" + user.Id + "," + id + ")"; cmd1 = new SqlCommand(sql2, con); cmd1.Connection.Open(); cmd1.ExecuteNonQuery(); cmd1.Connection.Close(); } creada = true; } catch (Exception ex) { creada = false; } finally { con.Close(); } return creada; }
//Devuelve una lista con los grupos de un usuario public List<Party_Class> userGroups(int id) { SqlConnection con = new SqlConnection(connection); List<Party_Class> partyList = new List<Party_Class>(); try { con.Open(); string sql = "SELECT * FROM PARTY WHERE ID IN (SELECT PID FROM US_PA_REL WHERE UID=" + id + ")"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader reader = cmd.ExecuteReader(); Party_Class party = new Party_Class(); while (reader.Read()) { party = new Party_Class(); party.Id = int.Parse(reader["ID"].ToString()); party.Name = reader["NAME"].ToString(); partyList.Add(party); } } catch (Exception ex) { } finally { con.Close(); } return partyList; }
public bool update(Party_Class myParty) { bool actualizado; SqlConnection con = new SqlConnection(connection); string sql = "UPDATE PARTY SET NAME = " + myParty.Name + "WHERE ID = " + myParty.Id; SqlCommand cmd = new SqlCommand(sql,con); try { con.Open(); cmd.ExecuteNonQuery(); actualizado = true; } catch (Exception ex) { actualizado = false; } finally { con.Close(); } return actualizado; }
public bool deleteParty(Party_Class myParty) { bool borrado; SqlConnection con = new SqlConnection(connection); try { string sql1 = "DELETE FROM PARTY WHERE ID =" + myParty.Id.ToString(); string sql2 = "DELETE FROM US_PA_REL WHERE PID =" + myParty.Id.ToString(); string sql3 = "DELETE FROM NOTES WHERE PARTY_ID =" + myParty.Id.ToString(); SqlCommand cmd2 = new SqlCommand(sql2, con); SqlCommand cmd1 = new SqlCommand(sql1, con); SqlCommand cmd3 = new SqlCommand(sql3, con); cmd3.Connection.Open(); cmd3.ExecuteNonQuery(); cmd3.Connection.Close(); cmd2.Connection.Open(); cmd2.ExecuteNonQuery(); cmd2.Connection.Close(); cmd1.Connection.Open(); cmd1.ExecuteNonQuery(); cmd2.Connection.Close(); borrado = true; } catch (Exception ex) { borrado = false; } finally { con.Close(); } return borrado; }
protected void SendGroup(object sender, EventArgs e) { HttpCookie userCookie; userCookie = Request.Cookies["UserID"]; user = new User_Class(); user = user.getUser(userCookie.Value); user.getFriends(); Party_Class newParty = new Party_Class(); newParty.Name = TextBox1.Text; Label3.Text = ListBox2.Items.Count.ToString(); int indice=0; newParty.Users.Add(user); foreach (ListItem li in ListBox2.Items) { indice = Int32.Parse(li.Value); newParty.Users.Add(user.Friends[indice]); } if (ListBox2.Items.Count == 0 || TextBox1.Text == "") { Label3.Text = "Add users and set Name."; } else { if (newParty.createParty()) Response.Redirect("..//Asp_forms/Groups.aspx"); else Label3.Text = "error"; } }
protected void Page_Load(object sender, EventArgs e) { Page.MaintainScrollPositionOnPostBack = true; HttpCookie userCookie; userCookie = Request.Cookies["UserID"]; if (userCookie == null) { Response.Redirect("../Account/Login.aspx"); } else { string s = Request.QueryString["ID"]; if (s != null && s!="") { Party_Class party = new Party_Class(); party.Id = Int32.Parse(s); party.obtainNotes(); party.getName(); Label1.Text = party.Name; HyperLink3.NavigateUrl = "~/Asp_forms/Groups_Notes.aspx?ID=" + party.Id; HyperLink3.Text = party.Name; Panel p = new Panel(); Label t = new Label(); Label f = new Label(); Label a = new Label(); Button b = new Button(); ImageButton imgbuttone = new ImageButton(); ImageButton imgbuttonb = new ImageButton(); Panel psub = new Panel(); User_Class userTemp = new User_Class(); userTemp = userTemp.getUser(userCookie.Value); User_Class userNote = new User_Class(); foreach (Note_Class note in party.Notes) { p = new Panel(); a = new Label(); userNote = new User_Class(); psub = new Panel(); t = new Label(); f = new Label(); imgbuttone = new ImageButton(); imgbuttonb = new ImageButton(); imgbuttone.ImageUrl = "../Images/editButton.png"; imgbuttone.PostBackUrl = "~/Asp_forms/Editnotes.aspx?ID=" + note.Id.ToString(); imgbuttone.Width = 30; imgbuttonb.ImageUrl = "../Images/deleteButton.png"; imgbuttonb.PostBackUrl = "~/Asp_forms/Deletenote.aspx?ID=" + note.Id.ToString(); imgbuttonb.Width = 30; imgbuttonb.ToolTip = "Delete"; imgbuttone.ToolTip = "Edit"; psub.CssClass = "default_panel"; psub.HorizontalAlign = HorizontalAlign.Right; psub.Controls.Add(imgbuttonb); psub.Controls.Add(imgbuttone); string id = note.Id.ToString(); p.ID = "p" + id; p.CssClass = "postitnotesblue"; t.ID = "t" + id; f.ID = "f" + id; t.Text = note.Text.ToString() + "<BR><BR>"; a.Text = "<BR>"+userNote.getUser(note.Author).Nick; a.CssClass = "noteauthor"; p.Controls.Add(t); p.Controls.Add(f); psub.Controls.Add(a); p.Controls.Add(psub); Panel1.Controls.Add(p); } } else Response.Redirect("~/Asp_forms/Groups.aspx"); } }