public DataTable UserUpdate()
{
DataTable dt = null;
string query;
query = "select * from Users where Users_ID=" + Userid;
//MessageBox.Show(query);
try
{
dt = user.Retrieve(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(dt);
}
public string userIDD()
{
string query = "select Users_ID from Users where Username = '******';";
DataTable datatable = null;
try
{
datatable = dbconnection.Retrieve(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
string userid = datatable.Rows[0][0].ToString();
return(userid);
}
private void Stickynote_Load(object sender, EventArgs e)
{
string query;
query = "select * from Categories";
DataTable dt1 = cate.Retrieve(query);
cmb1.DataSource = dt1;
cmb1.DisplayMember = "Categories_Name";
cmb1.ValueMember = "Categories_ID";
}
private void Userentry_Load(object sender, EventArgs e)
{
DataDisplay();
string query;
query = "select * from Usertype";
DataTable dt1 = user.Retrieve(query);
cmb6.DataSource = dt1;
cmb6.DisplayMember = "Usertype_Name";
cmb6.ValueMember = "Usertype_ID";
}
public DataTable NoteCounttodaydate(string todaydate)
{
DataTable dt = null;
string query;
query = "select Count(IsCompleted) from StickyNotes where Date_Created='" + todaydate + "'and IsCompleted='1' and Users_ID=" + usersss();
MessageBox.Show(query);
try
{
dt = conn.Retrieve(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(dt);
}
public DataTable Categorydgv()
{
DataTable dt = null;
string query;
query = "Select Categories_ID,Categories_Name from Categories";
try
{
dt = categ.Retrieve(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(dt);
}
public DataTable Usertypedgv()
{
DataTable dt = null;
string query;
query = "Select Usertype_ID,Usertype_Name from Usertype";
try
{
dt = conn.Retrieve(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(dt);
}
public DataTable getName(int UserID)
{
String query = "select FirstName,LastName from Users where Users_ID = " + UserID + ";";
DataTable dt = null;
try
{
dt = stick.Retrieve(query);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(dt);
}
public bool checkUser()
{
string query;
query = "select Username from Users where Username='******' and Passcode='" + password + "'";
DataTable dt = null;
try{ dt = conn.Retrieve(query); }
catch (Exception e) { Console.WriteLine(e.Message); }
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
