private void pictureBox2_Click(object sender, EventArgs e)
{
if (Application.OpenForms["AdvancedSearch"] == null)
{
TyreSection adv = new TyreSection();
adv.MdiParent = this;
adv.Size = new System.Drawing.Size(1100, 670);
adv.Location = new System.Drawing.Point(5, 5);
adv.Show();
}
}
private void btn_reduce_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure you want to reduce stock?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int catagory_id = vehical_category_data.get_catagory_id();
bool check;
int a;
check = int.TryParse(txt_qty.Text, out a);
if (txt_qty.Text == "")
{
MessageBox.Show("Enter qty!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (!check)
{
MessageBox.Show("Enter correct qty!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_qty.Text = "";
}
else if (Convert.ToInt32(txt_qty.Text) < 0)
{
MessageBox.Show("Qty can not less than Zero!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_qty.Text = "";
}
else
{
int cat_id = vehical_category_data.get_catagory_id();
string q0 = "SELECT * FROM add_vehical_tyre WHERE t_stok_id =" + cat_id + "";
DataSet ds_qty_table = middle_access.db_access.SelectData(q0);
if (ds_qty_table == null)
{
MessageBox.Show("Can not reduce!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);//show message box with ok button
}
else
{
DataRow row_catagory_id = ds_qty_table.Tables[0].Rows[0];
int available_qty = Convert.ToInt32(row_catagory_id.ItemArray.GetValue(9).ToString());
if (available_qty < Convert.ToInt32(txt_qty.Text))
{
MessageBox.Show("Available stock is insufficient!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);//show message box with ok button
txt_qty.Text = "";
}
else
{
int new_qty = available_qty - Convert.ToInt32(txt_qty.Text);
string q = "SELECT * FROM qty WHERE category_id = " + catagory_id + "";
DataSet ds_catagory_id = middle_access.db_access.SelectData(q);
string date = DateTime.Today.Date.ToString("yyyy-MM-dd");
string time = DateTime.Now.TimeOfDay.Hours.ToString() + ":" + DateTime.Now.TimeOfDay.Minutes.ToString() + ":" + DateTime.Now.TimeOfDay.Seconds.ToString();
string action = "-";
string q1 = "INSERT INTO qty VALUES(" + cat_id + "," + Convert.ToInt32(lbl_Aq.Text) + ",'" + action + "'," + Convert.ToInt32(txt_qty.Text) + ", '" + date + "','" + time + "')";
bool status = middle_access.db_access.InsertData(q1);
if (status == true)
{
string q2 = "UPDATE add_vehical_tyre SET qty = " + new_qty + " WHERE t_stok_id = " + cat_id + " ";
middle_access.db_access.UpdateData(q2);
MessageBox.Show("OK!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);//show message box with ok button
TyreSection s = new TyreSection();
s.set_total_qty();
if (new_qty == 0)
{
lbl_Aq.ForeColor = Color.Red;
}
lbl_Aq.Text = new_qty.ToString();
txt_qty.Text = "";
}
else
{
MessageBox.Show("Error!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
}