private void metroButton2_Click_1(object sender, EventArgs e)
{
EditStock e1 = new EditStock();
e1.Visible = true;
this.Dispose();
}
private void metroButton6_Click(object sender, EventArgs e)
{
EditStock e1 = new EditStock();
e1.metroLabel13.Text = metroLabel6.Text;
e1.Visible = true;
}
private void metroButton1_Click(object sender, EventArgs e)
{
String s = metroComboBox1.SelectedItem.ToString();
MySqlConnection con1 = new MySqlConnection("SERVER=localhost;DATABASE=sales;UID=root;PASSWORD=smhs;");
String q1 = "Select * from invent where id='" + s + "';";
MySqlCommand cmd1 = new MySqlCommand(q1, con1);
MySqlDataReader dataReader1;
con1.Open();
dataReader1 = cmd1.ExecuteReader();
if (dataReader1.Read())
{
String re = metroLabel2.Text.ToString();
if (re == "edit")
{
EditStock e1 = new EditStock();
e1.metroLabel13.Text = s;
e1.Visible = true;
Close();
}
else if (re == "Search")
{
Transaction t = new Transaction();
t.Text = "PAYMENT HISTORY";
t.Show();
t.metroButton1.PerformClick();
t.metroComboBox1.SelectedItem = "Unique ID";
t.metroTextBox1.Text = s;
t.metroButton3.PerformClick();
//t.metroButton2.PerformClick();
//this.Dispose();
Application.OpenForms["Mbox_Search"].Dispose();
Application.OpenForms["Home"].BringToFront();
Application.OpenForms["Transaction"].BringToFront();
}
else if (re == "delete")
{
DialogResult d = new DialogResult();
d = MetroMessageBox.Show(this, "\n\nAre Your Sure you want to delete this Entry?\nEntry Once deleted cant be recovered Back..", "WARNING", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (d == DialogResult.OK)
{
MySqlConnection con = new MySqlConnection("SERVER=localhost;DATABASE=Sales;UID=root;PASSWORD=smhs;");
con.Open();
MySqlCommand cmd = new MySqlCommand("Select id, status, bid, netamt from invent,sell where id='" + s + "' and id=sell.specs;", con);
MySqlDataReader dr1 = cmd.ExecuteReader();
double amt = 0;
int bid = 0;
String stat = "";
while (dr1.Read())
{
stat = dr1.GetValue(1).ToString();
amt = Convert.ToDouble(dr1.GetValue(3));
bid = Convert.ToInt32(dr1.GetValue(2));
}
dr1.Close();
double sum = 0;
cmd.CommandText = "Select Sum(amt) from history where pid='" + s + "';";
dr1 = cmd.ExecuteReader();
while (dr1.Read())
{
String s1 = Convert.ToString(dr1.GetValue(0));
if (s1.Length > 0)
{
sum = sum + Convert.ToDouble(s1);
}
}
dr1.Close();
cmd.CommandText = "DELETE from history where pid='" + s + "';";
cmd.ExecuteNonQuery();
cmd.CommandText = "UPDATE buyer set Total=Total-" + amt + ", Deposited=Deposited-" + sum + " where Buyid=" + bid + ";";
cmd.ExecuteNonQuery();
cmd.CommandText = "UPDATE Seller set Total=Total-" + amt + ", Deposited=Deposited-" + sum + " where Selid=10001;";
cmd.ExecuteNonQuery();
cmd.CommandText = "DELETE from sell where specs='" + s + "';";
int result = cmd.ExecuteNonQuery();
cmd.CommandText = "DELETE from invent where id='" + s + "';";
result = cmd.ExecuteNonQuery();
if (result > 0)
{
MetroMessageBox.Show(this, "\n\nEntry Deleted Successfully", "SUCCESS", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
}
else if (re == "balance")
{
}
}
else
{
DialogResult d = new DialogResult();
d = MetroMessageBox.Show(this, "STOCK NOT FOUND!! Please Re-Enter a Valid Stock-Code to proceed Further..", "INVALID STOCK CODE", MessageBoxButtons.RetryCancel, MessageBoxIcon.Exclamation);
if (d.ToString() == "Retry")
{
Application.OpenForms["Home"].BringToFront();
Application.OpenForms["Mbox_Search"].BringToFront();
//metroTextBox1.Select();
}
else
{
Close();
Application.OpenForms["Home"].BringToFront();
}
}
}
