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