public List<Category_Class> Categories()
{
List<Category_Class> list = new List<Category_Class>();
SqlConnection c = new SqlConnection(conection);
try
{
c.Open();
SqlCommand com = new SqlCommand("SELECT * FROM CATEGORY", c);
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Category_Class category = new Category_Class();
category.Id = int.Parse(reader["ID"].ToString());
category.Nombre = reader["NAME"].ToString();
list.Add(category);
}
}
catch (Exception ex) { }
finally
{
c.Close();
}
return list;
}
public bool addCategoria(Category_Class categoria)
{
bool añadido;
SqlConnection con = new SqlConnection(conection);
try
{
con.Open();
string sql = "INSERT INTO CATEGORIES (NAME) VALUES (" + categoria.Nombre + ")";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
añadido = true;
}
catch (Exception ex)
{
añadido = false;
}
finally
{
con.Close();
}
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)
{
List<Category_Class> lista = new List<Category_Class>();
Category_Class category = new Category_Class();
if (Request.QueryString["cadena"] != null)
lista = filterCategories(Request.QueryString["cadena"], category.Categories());
else
lista = category.Categories();
if (lista.Count() == 0)
{
Label label = new Label();
label.ID = "LabelX";
label.Text = "<h2> No categories found! </h2>";
Panel2.Controls.Add(label);
}
for (int j = 0; j < lista.Count(); j++)
{
Panel2.Controls.Add(createNotesButton(lista.ElementAt(j).Id, lista.ElementAt(j).Nombre));
}
}
else
{
Response.Redirect("../Account/Login.aspx");
}
}
}
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)
{
int categoryid = int.Parse(Request.QueryString["id"]);
Category_Class category = new Category_Class();
category = category.getCategoria(categoryid);
CategoryLabel.Text = category.Nombre + " Notes";
Panel p = new Panel();
Label t = new Label();
Label f = new Label();
Image ie = new Image();
ie.ImageUrl = "../Images/editButton.png";
ImageButton imgbuttone = new ImageButton();
ImageButton imgbuttonb = new ImageButton();
Panel psub = new Panel();
Note_CAD notaTemp = new Note_CAD();
List<Note_Class> notes = new List<Note_Class>();
User_Class userTemp = new User_Class();
userTemp = userTemp.getUser(userCookie.Value);
notes = notaTemp.notesCategory(userTemp.Id, category.Id);
int i = notes.Count() - 1;
if (notes.Count() == 0)
{
noCategories.Text = "No " + category.Nombre + " notes found. Start creating one up here!";
}
else
{
while (i >= 0)
{
p = new Panel();
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=" + notes[i].Id.ToString();
imgbuttone.Width = 30;
imgbuttone.ToolTip = "Edit";
imgbuttonb.ImageUrl = "../Images/deleteButton.png";
imgbuttonb.PostBackUrl = "~/Asp_forms/Deletenote.aspx?ID=" + notes[i].Id.ToString();
imgbuttonb.Width = 30;
imgbuttonb.ToolTip = "Delete";
psub.CssClass = "default_panel";
psub.HorizontalAlign = HorizontalAlign.Right;
psub.Controls.Add(imgbuttonb);
psub.Controls.Add(imgbuttone);
string id = notes[i].Id.ToString();
p.ID = "p" + id;
p.CssClass = "postitnotes";
t.ID = "t" + id;
f.ID = "f" + id;
t.Text = notes[i].Text.ToString() + "<BR>";
p.Controls.Add(t);
p.Controls.Add(f);
p.Controls.Add(psub);
Panelnota.Controls.Add(p);
i--;
}
}
}
else
{
Response.Redirect("../Account/Login.aspx");
}
}
}
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";
}
public Category_Class obtainCategoria(int id)
{
Category_Class categoria = new Category_Class();
SqlConnection con = new SqlConnection(conection);
try
{
con.Open();
string sql = "SELECT * FROM CATEGORY WHERE ID = " + id;
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
categoria.Id = id;
categoria.Nombre = reader["NAME"].ToString();
}
}
catch (Exception ex) { }
finally
{
con.Close();
}
return categoria;
}
