public bool addNote(Note_Class note, int g_id, int author_id)
{
bool insertado = false;
String connection = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\\Database.mdf;User Instance=true";
SqlConnection con = new SqlConnection(connection);
try
{
con.Open();
string sql1 = "INSERT INTO NOTES (KIND,CREATION_DATE,TEXT,PARTY_ID,AUTHOR) VALUES ('G', '" + note.Date.ToString() + "', '" + note.Text + "'," + g_id +", "+author_id+ ")";
SqlCommand cmd1 = new SqlCommand(sql1, con);
cmd1.ExecuteNonQuery();
insertado = true;
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return insertado;
}
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);
Note_Class note = new Note_Class();
note.Id = id;
if (note.deleteNote())
Response.Redirect("..//Asp_forms/Notes.aspx");
else
{
Label l = new Label();
l.Text = "An error has occurred, please try again later.";
Panel1.Controls.Add(l);
}
}
}
else
{
Response.Redirect("../Account/Login.aspx");
}
}
}
public bool addNote(Note_Class notec, int id)
{
bool insertado = false;
String connection = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\\Database.mdf;User Instance=true";
SqlConnection con = new SqlConnection(connection);
try
{
string sql1 = "INSERT INTO NOTES (KIND,CREATION_DATE,TEXT, AUTHOR) OUTPUT INSERTED.ID VALUES (" + "'"+notec.Type+"'" + "," + "'" + notec.Date + "'" + "," + "'" + notec.Text + "'," + id+ ")";
int note_id = 0;
SqlCommand cmd1 = new SqlCommand(sql1, con);
cmd1.Connection.Open();
SqlDataReader reader = cmd1.ExecuteReader();
if (reader.Read())
{
cmd1.Connection.Close();
note_id = Int32.Parse(reader["ID"].ToString());
string sql2 = "INSERT INTO US_NO_REL (UID,NID) VALUES (" + id + "," + note_id + ")";
SqlCommand cmd2 = new SqlCommand(sql2, con);
cmd2.Connection.Open();
cmd2.ExecuteNonQuery();
cmd2.Connection.Close();
}
insertado = true;
}
catch (Exception ex)
{
}
finally
{
}
return insertado;
}
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);
note.Id = id;
note = note.getNote(id);
Label2.Text = note.Text;
}
}
else
{
Response.Redirect("../Account/Login.aspx");
}
}
}
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 addNote(Note_Class note, int author_id)
{
Party_CAD cad = new Party_CAD();
return cad.addNote(note, this.Id, author_id);
}
public List<Note_Class> notesUserPrivate(int id)
{
List<Note_Class> notesList = new List<Note_Class>();
String connection = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\\Database.mdf;User Instance=true";
String sql = "SELECT * FROM NOTES WHERE KIND = 'P' AND ID IN (SELECT NID FROM US_NO_REL WHERE UID = " + id + ")";
SqlConnection con = new SqlConnection(connection);
try
{
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
Note_Class notaTemp = new Note_Class();
while (reader.Read())
{
notaTemp = new Note_Class();
notaTemp.Id = int.Parse(reader["ID"].ToString());
notaTemp.Text = reader["TEXT"].ToString();
notaTemp.Date = reader["CREATION_DATE"].ToString();
notaTemp.Type = Convert.ToChar(reader["KIND"]);
notesList.Add(notaTemp);
}
}
catch (Exception ex) { }
finally
{
con.Close();
}
return notesList;
}
public bool modifyNote(Note_Class notec)
{
bool modificacion = false;
String connection = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\\Database.mdf;User Instance=true";
SqlConnection con = new SqlConnection(connection);
try
{
con.Open();
string sql = "UPDATE NOTES SET TEXT = " + "'" + notec.Text + "'" + "WHERE ID =" + notec.Id;
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
modificacion = true;
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return modificacion;
}
public Note_Class getNote(int id)
{
Note_Class note = new Note_Class();
String connection = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\\Database.mdf;User Instance=true";
SqlConnection con = new SqlConnection(connection);
try
{
con.Open();
SqlCommand com = new SqlCommand("SELECT * FROM NOTES WHERE ID=" + id, con);
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
note.Id = id;
note.Type = Convert.ToChar(dr["KIND"]);
note.Date = dr["CREATION_DATE"].ToString();
note.Text = dr["TEXT"].ToString();
note.Author = Convert.ToInt32(dr["AUTHOR"]);
}
}
catch (Exception ex) { }
finally
{
con.Close();
}
return note;
}
public bool deleteNote(Note_Class notec)
{
bool borrado = false;
String connection = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\\Database.mdf;User Instance=true";
SqlConnection con = new SqlConnection(connection);
try
{
con.Open();
string sql1 = "DELETE FROM US_NO_REL WHERE NID=" + notec.Id;
string sql2 = "DELETE FROM NOTES WHERE ID =" + notec.Id;
SqlCommand cmd1 = new SqlCommand(sql1, con);
SqlCommand cmd = new SqlCommand(sql2, con);
cmd1.ExecuteNonQuery();
cmd.ExecuteNonQuery();
borrado = true;
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return borrado;
}
public List<Note_Class> obtainNotes(int id_party)
{
SqlConnection con = new SqlConnection(connection);
try
{
con.Open();
string sql = "SELECT * FROM NOTES WHERE PARTY_ID =" + id_party;
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Note_Class notaAux = new Note_Class();
notaAux.Id = int.Parse(reader["ID"].ToString());
notaAux.Type = Convert.ToChar(reader["KIND"]);
notaAux.Date = reader["CREATION_DATE"].ToString();
notaAux.Text = reader["TEXT"].ToString();
notaAux.Author = Int32.Parse(reader["AUTHOR"].ToString());
myNotes.Add(notaAux);
}
con.Close();
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
return myNotes;
}
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"];
User_Class user = new User_Class();
int uid = -1;
if (s != null || s == "")
{
uid = Int32.Parse(s);
user=user.getUser(uid);
Name.Text = user.Name + " "+ user.Surname + " |";
Nick.Text = user.Nick;
HyperLink3.NavigateUrl = "~//Asp_forms/UserTable.aspx/?ID=" + uid.ToString();
HyperLink3.Text = user.Nick;
Page.Title = user.Nick;
}
else
Response.Redirect("~//Asp_forms/Friends.aspx");
Panel p = new Panel();
Label t = new Label();
Label f = new Label();
Label a = new Label();
Panel psub = new Panel();
Note_Class note=new Note_Class();
user.Notes=note.getNotesUserOpen(uid);
foreach(Note_Class personalnote in user.Notes)
{
p = new Panel();
psub = new Panel();
t = new Label();
f = new Label();
a = new Label();
psub.CssClass = "default_panel";
psub.HorizontalAlign = HorizontalAlign.Right;
string id = personalnote.Id.ToString();
p.ID = "p" + id;
if (personalnote.Type == 'O')
p.CssClass = "postitnotes";
else if (personalnote.Type == 'P')
p.CssClass = "postitnotespink";
t.ID = "t" + id;
f.ID = "f" + id;
t.Text = personalnote.Text.ToString() + "<BR>";
a.Text = "<br/>" + user.getUser(personalnote.Author).Nick;
a.CssClass = "noteauthor";
psub.Controls.Add(a);
p.Controls.Add(t);
p.Controls.Add(f);
p.Controls.Add(psub);
Panel1.Controls.Add(p);
}
}
else
{
Response.Redirect("../Account/Login.aspx");
}
}
}
//Modify text
public bool modifyNote(Note_Class notec)
{
Note_CAD u = new Note_CAD();
if (u.modifyNote(notec))
{
return true;
}
else
{
return false;
}
}
protected void Send(object sender, EventArgs e)
{
HttpCookie userCookie;
userCookie = Request.Cookies["UserID"];
user = new User_Class();
user = user.getUser(userCookie.Value);
user.getFriends();
Note_Class note = new Note_Class();
note.Text = TextBox1.Text;
note.Date = DateTime.Now.ToShortDateString();
foreach (ListItem li in ListBox1.Items)
{
if (li.Selected == true)
{
if (Int32.Parse(li.Value) == 0)
{
note.Type = 'O';
}
else if (Int32.Parse(li.Value) == 1)
{
note.Type = 'P';
}
}
}
Category_Class category = new Category_Class();
if (TextBox2.Text != null && TextBox2.Text != "")
{
category.Nombre = TextBox2.Text;
note.Category = category.getCategoryId();
}
else
note.Category = -1;
List<User_Class> users = new List<User_Class>();
int indice = 0;
foreach (ListItem li in ListBox2.Items)
{
indice = Int32.Parse(li.Value);
users.Add(user.Friends[indice]);
}
if (note.Type!=' ' && note.addNote(user.Id, users))
Response.Redirect("../Asp_forms/Notes.aspx");
else
Label4.Text = "An error has occurred";
}
