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; }