public bool insertClient(String fname, String lname, String phon, String country)
{
MySqlCommand command = new MySqlCommand();
String insertQuery = "INSERT INTO `clientperson`( `first_name`, `last_name`, `phone`, `country`) VALUES (@fnm,@lfm,@phn,@cnt)";
command.CommandText = insertQuery;
command.Connection = conn.getConnection();
command.Parameters.Add("@fnm", MySqlDbType.VarChar).Value = fname;
command.Parameters.Add("@lfm", MySqlDbType.VarChar).Value = lname;
command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phon;
command.Parameters.Add("@cnt", MySqlDbType.VarChar).Value = country;
conn.openConnection();
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.openConnection();
return(false);
}
}
public bool editPassword(String username, String password, String passwordnew)
{
MySqlCommand command = new MySqlCommand();
String editQuery = "UPDATE `users` SET `password`= @passnew WHERE `username`=@uname AND `password`=@pass";
command.CommandText = editQuery;
command.Connection = conn.getConnection();
command.Parameters.Add("@uname", MySqlDbType.VarChar).Value = username;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = password;
command.Parameters.Add("@passnew", MySqlDbType.VarChar).Value = passwordnew;
conn.openConnection();
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.openConnection();
return(false);
}
}
private void Listorder_Load(object sender, EventArgs e)
{
comboadditem();
String username = textBoxUsername.Text;
labelDateTime.Text = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
MySqlCommand command = new MySqlCommand("SELECT name,price,time,status FROM `order` WHERE `username` = @username", conn.getConnection());
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
command.Parameters.Add("@username", MySqlDbType.VarChar).Value = username;
adapter.SelectCommand = command;
adapter.Fill(table);
dataGridView1.DataSource = table;
DataGridViewColumn column0 = dataGridView1.Columns[0];
column0.Width = 370;
DataGridViewColumn column1 = dataGridView1.Columns[1];
column1.Width = 60;
column1.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.AllowUserToAddRows = false;
int i = 0;
while (i < table.Rows.Count)
{
all += Convert.ToDouble(table.Rows[i]["price"]);
i++;
}
textBoxSum.Text = all.ToString();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string qurey = "SELECT * FROM `order` WHERE CONCAT(`orderid`) LIKE'%" + comboBox1.Text + "%'";
MySqlCommand command1 = new MySqlCommand(qurey, conn.getConnection());
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
adapter.SelectCommand = command1;
adapter.Fill(table);
dataGridView1.DataSource = table;
}
private void buttonlogin_Click(object sender, EventArgs e)
{
CONNECT conn = new CONNECT();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand();
String query = "SELECT * FROM `users` WHERE `username`=@usn AND `password`=@pass";
command.CommandText = query;
command.Connection = conn.getConnection();
command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = textBoxUsername.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBoxPassword.Text;
adapter.SelectCommand = command;
adapter.Fill(table);
if (textBoxUsername.Text.Trim().Equals("admin".ToLower()) & textBoxPassword.Text.Trim().Equals("12123"))
{
// show the admain form
this.Hide();
AdminMainForm mform = new AdminMainForm(textBoxUsername.Text);
mform.Show();
}
else if (table.Rows.Count > 0)
{
// show the main form
this.Hide();
MemberMainForm m1form = new MemberMainForm(textBoxUsername.Text);
m1form.Show();
}
else
{
if (textBoxUsername.Text.Trim().Equals(""))
{
MessageBox.Show("Enter Your Username to Login", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPassword.Text.Trim().Equals(""))
{
MessageBox.Show("Enter Your Password to Login", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("This Username Or Password Doesn't Exists", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void comboadditem()
{
CONNECT conn = new CONNECT();
MySqlCommand command1 = new MySqlCommand("SELECT * FROM `count`", conn.getConnection());
MySqlDataAdapter adapterr = new MySqlDataAdapter();
MySqlDataReader myReader;
try
{
conn.openConnection();
myReader = command1.ExecuteReader();
while (myReader.Read())
{
string sName = myReader.GetString("id");
comboBox1.Items.Add(sName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool insertProducts(String name, String cate, String price, MemoryStream picture)
{
MySqlCommand command = new MySqlCommand();
String insertProducts = "INSERT INTO `product`(`name`,`category`, `price`, `image`) VALUES (@name,@cate,@price,@image)";
command.CommandText = insertProducts;
command.Connection = conn.getConnection();
command.Parameters.Add("@name", MySqlDbType.VarChar).Value = name;
command.Parameters.Add("@cate", MySqlDbType.VarChar).Value = cate;
command.Parameters.Add("@price", MySqlDbType.VarChar).Value = price;
command.Parameters.Add("@image", MySqlDbType.LongBlob).Value = picture.ToArray();
conn.openConnection();
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.closeConnection();
return(false);
}
}
// check if the username already exists
public Boolean checkUsername()
{
CONNECT db = new CONNECT();
String username = textBoxUsername.Text;
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand("SELECT * FROM `users` WHERE `username` = @usn", db.getConnection());
command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = username;
adapter.SelectCommand = command;
adapter.Fill(table);
// check if this username already exists in the database
if (table.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
private void buttonsignup_Click(object sender, EventArgs e)
{
CONNECT conn = new CONNECT();
MySqlCommand command = new MySqlCommand("INSERT INTO `users`(`username`, `password`) VALUES (@usn, @pass)", conn.getConnection());
command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = textBoxUsername.Text;
command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBoxPassword.Text;
conn.openConnection();
if (textBoxUsername.Text.Trim().Equals(""))
{
MessageBox.Show("Enter Your Username to Register", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPassword.Text.Trim().Equals(""))
{
MessageBox.Show("Enter Your Password to Register", "Empty Password", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (textBoxPasswordConfirm.Text.Trim().Equals(""))
{
MessageBox.Show("Enter Your Confirm Password to Register", "Empty Data", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (!checkTextBoxesValues())
{
// check if the password equal the confirm password
if (textBoxPassword.Text.Equals(textBoxPasswordConfirm.Text))
{
// check if this username already exists
if (checkUsername())
{
MessageBox.Show("This Username Already Exists, Select A Different One", "Duplicate Username", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
else
{
// execute the query
if (command.ExecuteNonQuery() == 1)
{
this.Close();
MessageBox.Show("Your Account Has Been Created", "Account Created", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("ERROR");
}
}
}
else
{
MessageBox.Show("Wrong Confirmation Password", "Password Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Enter Your Informations First", "Empty Data", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
}
// close the connection
conn.closeConnection();
}
private void bigpic_Load(object sender, EventArgs e)
{
dataGridView1.RowTemplate.Height = 600;
String id = textBoxID.Text;
MySqlCommand command = new MySqlCommand("SELECT * FROM `statistics` WHERE `id` = @id", conn.getConnection());
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
command.Parameters.Add("@id", MySqlDbType.VarChar).Value = id;
adapter.SelectCommand = command;
adapter.Fill(table);
dataGridView1.DataSource = table;
//dataGridView1.ReadOnly = true;
DataGridViewColumn column0 = dataGridView1.Columns[0];
column0.Width = 1;
DataGridViewColumn column1 = dataGridView1.Columns[1];
column1.Width = 1;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
public void comboadditem()
{
String username = textBoxUsername.Text;
CONNECT conn = new CONNECT();
MySqlCommand command1 = new MySqlCommand("SELECT * FROM `count` WHERE `username` = @username", conn.getConnection());
MySqlDataAdapter adapterr = new MySqlDataAdapter();
MySqlDataReader myReader;
command1.Parameters.Add("@username", MySqlDbType.VarChar).Value = username;
try
{
conn.openConnection();
myReader = command1.ExecuteReader();
while (myReader.Read())
{
string sName = myReader.GetString("id");
comboBox1.Items.Add(sName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void last_Load(object sender, EventArgs e)
{
String username = textBoxUsername.Text;
MySqlCommand command = new MySqlCommand("SELECT name,price FROM `bag` WHERE `username` = @username", conn.getConnection());
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
command.Parameters.Add("@username", MySqlDbType.VarChar).Value = username;
adapter.SelectCommand = command;
adapter.Fill(table);
dataGridView1.DataSource = table;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void CartForm_Load(object sender, EventArgs e)
{
Random random = new Random();
randomNumber = random.Next(1000000, 10000000);
labelTimeDate.Text = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString();
MySqlDataAdapter adp = new MySqlDataAdapter("SELECT * FROM `bag` WHERE CONCAT(`username`) LIKE '%" + textBoxUsername.Text + "%'", conn.getConnection());
DataTable table1 = new DataTable();
adp.Fill(table1);
int i = 0;
while (i < table1.Rows.Count)
{
all += Convert.ToDouble(table1.Rows[i]["price"]);
i++;
}
textBoxSum.Text = all.ToString();
String username = textBoxUsername.Text;
MySqlCommand command = new MySqlCommand("SELECT id,name,price FROM `bag` WHERE `username` = @username", conn.getConnection());
MySqlDataAdapter adapter = new MySqlDataAdapter();
DataTable table = new DataTable();
command.Parameters.Add("@username", MySqlDbType.VarChar).Value = username;
adapter.SelectCommand = command;
adapter.Fill(table);
dataGridView1.DataSource = table;
//dataGridView1.ReadOnly = true;
DataGridViewColumn column0 = dataGridView1.Columns[0];
column0.Width = 20;
DataGridViewColumn column1 = dataGridView1.Columns[1];
column1.Width = 500;
DataGridViewColumn column2 = dataGridView1.Columns[2];
column2.Width = 50;
column2.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
column0.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
