private void btnYes_Click(object sender, EventArgs e) { try { DialogResult dialogResult = MessageBox.Show("Are you sure you want to Save?", "Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dialogResult == DialogResult.OK) { db.dbconnect(); if (this.db.openconnection() == true) { string yes_query = "INSERT INTO paid_customer (Cus_Id,Cus_Name,Num_Sacks,Num_Kilos,Amount_to_Pay,Date_of_Milling,Date_of_Payment) VALUES " + "(NULL,'" + lblCus.Text + "','" + lblSacks.Text + "','" + lblKilos.Text + "','" + pay + "','" + Pass_DateMill + "','" + time.ToString(format) + "')"; MySqlCommand addPaid = new MySqlCommand(yes_query, db.objconn); addPaid.ExecuteNonQuery(); DialogResult dialog = MessageBox.Show("New Record has been Added.", "Added", MessageBoxButtons.OK, MessageBoxIcon.Information); if (dialog == DialogResult.OK) { Add_Data add = new Add_Data(); add.Show(); this.Hide(); } } else { } db.closeconnection(); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void btnCancel_Click(object sender, EventArgs e) { Add_Data display = new Add_Data(); display.Show(); this.Hide(); }
public void log_in() { try { opencon.dbconnect(); { if (this.opencon.openconnection() == true) { string find_user = "******" + encryptusername.Text + "' AND PASSWORD ='******'LIMIT 1"; MySqlDataAdapter objda = new MySqlDataAdapter(find_user, opencon.objconn); DataTable objdt = new DataTable(); objda.Fill(objdt); if (txtUsername.Text == "") { lblPrompt.Text = "Please Enter Username"; txtUsername.Focus(); } else if (txtPassword.Text == "") { lblPrompt.Text = "Please Enter Password"; txtPassword.Focus(); } else if (objdt.Rows.Count == 0) { lblPrompt.Text = "Account does'nt exist"; opencon.closeconnection(); } else if (txtUsername.Text == "operator1") { Add_Data operate = new Add_Data(); operate.Show(); this.Hide(); } else if (txtUsername.Text == "operator2") { Add_Data operate = new Add_Data(); operate.Show(); this.Hide(); } else if (txtUsername.Text == "operator3") { Add_Data operate = new Add_Data(); operate.Show(); this.Hide(); } else if (txtUsername.Text == "watcher") { Add_Data operate = new Add_Data(); operate.Show(); this.Hide(); } else { Manager_Interface admin = new Manager_Interface(); //admin.fileToolStripMenuItem.Visible = false; admin.Show(); this.Hide(); } // lblPrompt.Text = "Successfully Logout"; opencon.closeconnection(); } opencon.closeconnection(); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void addCustomerToolStripMenuItem_Click(object sender, EventArgs e) { Add_Data id = new Add_Data(); id.Show(); }