private void button2_Click_1(object sender, EventArgs e)
{
if (ExitingCoustumer.Customer != "" && CostumerSearch.Text != "" && ExitingCoustumer.Customer == CostumerSearch.Text)
{
MessageBox.Show(Customer, "You have place this customer:", MessageBoxButtons.OK);
this.Close();
Checkout ss = new Checkout();
ss.label4.Text = ExitingCoustumer.Customer;
ss.label6.Text = FindProduct.Product;
ss.label3.Text = FindProduct.Quantity;
ss.label11.Text = FindProduct.Product_name;
if (FindProduct.int_Product_price != 0)
{
ss.label9.Text = FindProduct.int_Product_price.ToString();
}
ss.Show();
}
else
{
MessageBox.Show("You didnt place a customer, please try again", "Error", MessageBoxButtons.OK);
}
}
private void button1_Click(object sender, EventArgs e)
{
Checkout mm = new Checkout();
mm.Show();
}
private void Button2_Click(object sender, EventArgs e)
{
if (label4.Text == "" && label6.Text == "")
{
MessageBox.Show("You didn't place a costumer and Product!");
}
else if (label4.Text == "")
{
MessageBox.Show("You didn't place a costumer!");
}
else if (label6.Text == "")
{
MessageBox.Show("You didn't place a Product!");
}
else
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\PROJECT\TEAM5\TEAM5\TEAM5 PROJECT\DATABASE\STOREMANGE.MDF;Integrated Security=True;Connect Timeout=30");
SqlDataAdapter sda = new SqlDataAdapter("select Price from Inventory where Serialnumber ='" + FindProduct.Product + "'", conn);
DataTable dt = new DataTable();
sda.Fill(dt);
string New_price = dt.Rows[0]["Price"].ToString();
SqlCommand sda2 = new SqlCommand("INSERT INTO Orders (Product_Serial,Price,Quantity,Date,Seller_name,Buyer_Id) VALUES ('" + FindProduct.Product + "','" + FindProduct.int_Product_price + "','" + FindProduct.Quantity + "','" + Login.date + "','" + Login.UserID + "','" + ExitingCoustumer.Customer + "')", conn);
SqlDataAdapter da = new SqlDataAdapter(sda2);
DataTable dt1 = new DataTable();
da.Fill(dt1);
try
{
SqlCommand sda4 = new SqlCommand(" update Inventory set Quantity = '" + FindProduct.int_Update_quaintity + " ' where Serialnumber ='" + FindProduct.Product + "'", conn);
SqlDataAdapter da4 = new SqlDataAdapter(sda4);
DataTable dt4 = new DataTable();
da4.Fill(dt4);
MessageBox.Show("Inventory Updeated", "Ok", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (MessageBox.Show("Greetings, the product was successfully sold.Would you like to choose another product?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
FindProduct.Product = "";
FindProduct.Product_name = "";
FindProduct.Quantity = "";
this.Close();
FindProduct mm = new FindProduct();
mm.Show();
}
else
{
FindProduct.Product = "";
FindProduct.Product_name = "";
FindProduct.Quantity = "";
ExitingCoustumer.Customer = "";
label4.Text = "";
this.Close();
Checkout mm = new Checkout();
mm.label4.Text = "";
mm.label9.Text = "";
mm.label6.Text = "";
mm.label3.Text = "";
mm.label11.Text = "";
mm.Show();
}
}
}
