public void updateContent()
{
String query = "update StickyNotes set Content_of_Notes = '" + Content + "',Categories_ID=" + Categoryid + " where Title = '" + Title + "';";
try
{
dbconnection.Manipulate(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void Update()
{
string query;
query = "Update Users set Usertype_ID=" + UsertypeID + ",FirstName='" + Firstname + "',LastName='" + Lastname + "',Address_Name='" + Addrss + "',Phone_No='" + Phone + "',Email='" + Email + "',Gender='" + Gender + "',Username='******',Passcode='" + Password + "' where Users_ID=" + Userid;
try
{
user.Manipulate(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void addSticky()
{
string query;
query = "insert into StickyNotes(Users_ID,Categories_ID,Date_Created,Title,Content_Of_Notes,Isstickied,Iscompleted)values('" + Userid + "'," + Categoriesid + ",'" + Date + "','" + Title + "','" + Content + "'," + Isstickied + "," + Iscompleted + ");";
try
{
stick.Manipulate(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void Addcategory()
{
string query;
query = "insert into Categories(Categories_Name)values('" + Category + "')";
try
{
categ.Manipulate(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public void addusertype()
{
string query;
query = "insert into Usertype(Usertype_Name) values('" + Usertype + "')";
try
{
conn.Manipulate(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
