private void button2_Click_1(object sender, EventArgs e)
{
MySqlConnection myconn = new MySqlConnection(connection);
try
{
myconn.Open();
MySqlCommand mycomm = new MySqlCommand("insert into resturant.sells_bill (Total_price,Customer_id,bill_Date,bill_Time,shift) values ('" + totalText.Text + "','" + customer_id.Text + "','" + Date.Text + "','" + time.Text + "','" + shift.Text + "')", myconn);
logfile log = new logfile();
bool result = log.logfilee("insert into resturant.sells_bill (Total_price,Customer_id,bill_Date,bill_Time,shift) values ('" + totalText.Text + "','" + customer_id.Text + "','" + Date.Text + "','" + time.Text + "','" + shift.Text + "')");
mycomm.ExecuteNonQuery();
MessageBox.Show("Bill Saved");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
myconn.Close();
}
}
private void button4_Click(object sender, EventArgs e)
{
myconn = new MySqlConnection(connection);
MySqlDataReader mdr;
string select = "select * from items where Item_id = '" + int.Parse(textBoxID.Text) + "'";
MySqlCommand command = new MySqlCommand(select, myconn);
openConnection();
mdr = command.ExecuteReader();
logfile log = new logfile();
bool result = log.logfilee("select * from items where Item_id = '" + int.Parse(textBoxID.Text) + "'");
if (mdr.Read())
{
textBoxName.Text = mdr.GetString("Item_name");
textBoxPrice.Text = mdr.GetString("Price");
textBoxQuantity.Text = mdr.GetString("Quantity");
textBoxCat.Text = mdr.GetString("Category_id");
}
else
{
MessageBox.Show("Item Not Found");
}
closeConnection();
}
private void button1_Click(object sender, EventArgs e)
{
string insertQuery = "Insert into items (Item_name , Price , Quantity , Category_id) value ('" + textBoxName.Text + "','" + textBoxPrice.Text + "','" + textBoxQuantity.Text + "','" + textBoxCat.Text + "');";
executeMyQuery(insertQuery);
logfile log = new logfile();
bool result = log.logfilee("Insert into items (Item_name , Price , Quantity , Category_id) value ('" + textBoxName.Text + "','" + textBoxPrice.Text + "','" + textBoxQuantity.Text + "','" + textBoxCat.Text + "')");
populateDGV();
}
private void button3_Click(object sender, EventArgs e)
{
string deleteQuery = "delete from items where Item_id = '" + int.Parse(textBoxID.Text) + "'";
executeMyQuery(deleteQuery);
logfile log = new logfile();
bool result = log.logfilee("delete from items where Item_id = '" + int.Parse(textBoxID.Text) + "'");
populateDGV();
}
private void button2_Click(object sender, EventArgs e)
{
string updateQuery = "update items set Item_name='" + textBoxName.Text + "' , Price= '" + textBoxPrice.Text + "', Quantity='" + textBoxQuantity.Text + "' , Category_id='" + textBoxCat.Text + "' where Item_id = '" + int.Parse(textBoxID.Text) + "'";
executeMyQuery(updateQuery);
logfile log = new logfile();
bool result = log.logfilee("update items set Item_name='" + textBoxName.Text + "' , Price= '" + textBoxPrice.Text + "', Quantity='" + textBoxQuantity.Text + "' , Category_id='" + textBoxCat.Text + "' where Item_id = '" + int.Parse(textBoxID.Text) + "'");
populateDGV();
}
private void Browse_Button_Click(object sender, EventArgs e)
{
MySqlConnection myconn = new MySqlConnection(connection);
try
{
myconn.Open();
MySqlCommand mycomm = new MySqlCommand("employee", myconn);
mycomm.CommandType = CommandType.StoredProcedure;
mycomm.Parameters.AddWithValue("@k", "delete");
mycomm.Parameters.AddWithValue("@Id_par1", txt_employeename.Text);
mycomm.Parameters.AddWithValue("@Name_par2", "None");
mycomm.Parameters.AddWithValue("@Job_par3", "None");
mycomm.Parameters.AddWithValue("@Phone_par4", 0);
mycomm.Parameters.AddWithValue("@Address_par5", "None");
mycomm.Parameters.AddWithValue("@User_par6", "None");
mycomm.Parameters.AddWithValue("@Pass_par7", "None");
mycomm.Parameters.AddWithValue("@Salary_par8", 0);
mycomm.Parameters.AddWithValue("@Shift_par9", 0);
mycomm.ExecuteNonQuery();
MessageBox.Show("The data Deleted");
logfile log = new logfile();
bool result = log.logfilee("delete from employee where Employee_id = Id_par1");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
myconn.Close();
}
}
private void Browse_Button_Click(object sender, EventArgs e)
{
MySqlConnection myconn = new MySqlConnection(connection);
try
{
myconn.Open();
MySqlCommand mycomm = new MySqlCommand("employee", myconn);
mycomm.CommandType = CommandType.StoredProcedure;
mycomm.Parameters.AddWithValue("@k", "update");
mycomm.Parameters.AddWithValue("@Id_par1", txt_employeename.Text);
mycomm.Parameters.AddWithValue("@Name_par2", "None");
mycomm.Parameters.AddWithValue("@Job_par3", "None");
mycomm.Parameters.AddWithValue("@Phone_par4", txt_Phone.Text);
mycomm.Parameters.AddWithValue("@Address_par5", txt_Address.Text);
mycomm.Parameters.AddWithValue("@User_par6", txt_User.Text);
mycomm.Parameters.AddWithValue("@Pass_par7", txt_Password.Text);
mycomm.Parameters.AddWithValue("@Salary_par8", txt_Salary.Text);
mycomm.Parameters.AddWithValue("@Shift_par9", txt_shift.Text);
mycomm.ExecuteNonQuery();
MessageBox.Show("The data Updated");
logfile log = new logfile();
bool result = log.logfilee("UPDATE employee SET Phone =Phone_par4, Address=Address_par5, user=User_par6, pass=Pass_par7, salary=Salary_par8, shift=Shift_par9 WHERE Employee_name=Name_par2");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
myconn.Close();
}
}
private void Browse_Button_Click(object sender, EventArgs e)
{
Regex regex_Name = new Regex("^[a-zA-Z]{1,20}$");
Regex regex_Numbers = new Regex("^[0-9]*$");
// Regex regex_Address = new Regex("^[1-zA-Z0-9]{1,20}$");
Regex regex_Salary = new Regex("^[0-9]");
Regex regex_User = new Regex("^[a-zA-Z]{1,20}$");
Regex regex_Job = new Regex("^[a-zA-Z]{1,20}$");
Regex regex_Time = new Regex("^[0-9]");
// Regex regex_Password = new Regex("^[1-zA-Z0-9$]{1,20}$");
if (!regex_Name.IsMatch(txt_employeename.Text))
{
MessageBox.Show("Please Enter the First name with Alpha A-Z no number accpted");
return;
}
if (!regex_Numbers.IsMatch(txt_Phone.Text))
{
MessageBox.Show("Please Enter the Phone with 0-9 number no Alpha A-Z accpted");
return;
}
if (!regex_Salary.IsMatch(txt_Salary.Text))
{
MessageBox.Show("Please Enter the Salary with Alpha A-Z No 0-9 number accpted");
return;
}
if (!regex_User.IsMatch(txt_User.Text))
{
MessageBox.Show("Please Enter the User with with Alpha A-Z no number accpted ");
return;
}
if (!regex_Job.IsMatch(txt_Job.Text))
{
MessageBox.Show("Please Enter the User with with Alpha A-Z no number accpted ");
return;
}
if (!regex_Time.IsMatch(txt_shift.Text))
{
MessageBox.Show("Please Enter the Salary with 0-9 number no Alpha A-Z accpted");
return;
}
if (txt_employeename.Text == "" || txt_Phone.Text == "" || txt_Address.Text == "" || txt_Salary.Text == "" || txt_User.Text == "" || txt_Job.Text == "" || txt_shift.Text == "" || txt_Password.Text == "")
{
MessageBox.Show("Please Complete the data");
}
MySqlConnection myconn = new MySqlConnection(connection);
try
{
myconn.Open();
MySqlCommand mycomm = new MySqlCommand("employee", myconn);
mycomm.CommandType = CommandType.StoredProcedure;
mycomm.Parameters.AddWithValue("@k", "insert");
mycomm.Parameters.AddWithValue("@Id_par1", 0);
mycomm.Parameters.AddWithValue("@Name_par2", txt_employeename.Text);
mycomm.Parameters.AddWithValue("@Job_par3", txt_Job.Text);
mycomm.Parameters.AddWithValue("@Phone_par4", txt_Phone.Text);
mycomm.Parameters.AddWithValue("@Address_par5", txt_Address.Text);
mycomm.Parameters.AddWithValue("@User_par6", txt_User.Text);
mycomm.Parameters.AddWithValue("@Pass_par7", txt_Password.Text);
mycomm.Parameters.AddWithValue("@Salary_par8", txt_Salary.Text);
mycomm.Parameters.AddWithValue("@Shift_par9", txt_shift.Text);
mycomm.ExecuteNonQuery();
MessageBox.Show("The data inserted");
logfile log = new logfile();
bool result = log.logfilee("insert into employee (Employee_name, Job, Phone, Address, user, pass, salary, shift) values (Name_par2, Job_par3, Phone_par4, Address_par5, User_par6, Pass_par7, Salary_par8, Shift_par9)");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
myconn.Close();
}
}