private void MyOrders_Load(object sender, EventArgs e)
{
userdetail user = new userdetail();
label9.Text = user.getUname();
FillMyOrdeers();
}
private void Home_Load(object sender, EventArgs e)
{
FillComboBox();
ItemList = "";
TotalPrice = 0;
UpdateQuery = "";
userdetail user = new userdetail();
label9.Text = user.getUname();
}
private void loginButtonClicked(object sender, EventArgs e)
{
try
{
String username = tfUsername.Text.Trim();
String password = Secret.MD5Hash(tfPassword.Text.Trim());
SQLiteConnection conn = new SQLiteConnection(DbConfig.CONNECTION_STRING);
conn.Open();
string query = "select usertype from users where username='******'and password='******'";
SQLiteCommand cmd = new SQLiteCommand(query, conn);
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
String userType = reader.GetString(0);
Console.WriteLine(userType);
conn.Close();
userdetail userdetail = new userdetail();
userdetail.setUname(username);
if (userType.Equals("member"))
{
Home home = new Home();
home.Show();
this.Hide();
}
else if (userType.Equals("manager"))
{
Manager_home manager = new Manager_home();
manager.Show();
this.Hide();
}
else if (userType.Equals("admin"))
{
Admin_home admin = new Admin_home();
admin.Show();
this.Hide();
}
}
}
catch (Exception x)
{
MessageBox.Show(x.ToString());
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
userdetail user = new userdetail();
MySqlConnection conn = new MySqlConnection(@"datasource=127.0.0.1;port=3306;SslMode=none;username=root;password=;database=talight;");
string query = "INSERT INTO `orders`(`user`,`details`,`price`) VALUES('" + user.getUname() + "','" + MyParent.ItemList + "'," + MyParent.TotalPrice + ");" + MyParent.UpdateQuery + "";
MySqlCommand cmd = new MySqlCommand(query, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Success");
button1_Click(sender, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
userdetail user = new userdetail();
//SqliteConnection conn = new SqliteConnection(DbConfig.CONNECTION_STRING);
//string query = "INSERT INTO `orders`(`user`,`details`,`price`) VALUES('"+user.getUname()+"','"+MyParent.ItemList+"',"+MyParent.TotalPrice+");"+MyParent.UpdateQuery+"";
//SqliteCommand cmd = new SqliteCommand(query, conn);
//conn.Open();
//Console.WriteLine(query);
//cmd.ExecuteNonQuery();
//conn.Close();
//MessageBox.Show("Success");
//button1_Click(sender, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void Home_Load(object sender, EventArgs e)
{
userdetail user = new userdetail();
lblUsername.Text = user.getUname();
}
