private void Deletebtn_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("DELETE FROM PRODUCT WHERE PID = @pid", con);
cmd.Parameters.AddWithValue("@pid", ProductID.Text);
int i = cmd.ExecuteNonQuery();
con.Close();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Product Deletion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Product Deletion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
ProductName.Clear();
ProductID.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//MessageBox.Show("Product Not found", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Clear_Click(object sender, EventArgs e)
{
ProductName.Clear();
productID.Clear();
VendorID.Clear();
Amount.Clear();
}
private void Clear_textBoxes()
{
FirstName.Clear();
LastName.Clear();
ProductName.Clear();
wholesalecost.Clear();
SaleCost.Clear();
}
private void Submit_Click(object sender, EventArgs e)
{
if (ProductName.Text == "" || VendorID.Text == "" || Amount.Text == "" || ProductID.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Insert into PRODUCT (PID,PNAME,AMOUNT,VID) values(@pid,@pname,@amount,@vid);", con);
cmd.Parameters.AddWithValue("@pid", ProductID.Text);
cmd.Parameters.AddWithValue("@pname", ProductName.Text);
cmd.Parameters.AddWithValue("@vid", VendorID.Text);
cmd.Parameters.AddWithValue("@amount", Amount.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Product Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Product Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
con.Close();
ProductName.Clear();
VendorID.Clear();
Amount.Clear();
ProductID.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void SaveProductButton_Click(object sender, RoutedEventArgs e)
{
Product product = new Product();
product.Name = ProductName.Text;
product.Kcal = float.Parse((ProductKCAL.Text).ToString());
product.Quantity = int.Parse((Quan.Text).ToString());
product.Unit = Unit.Text;
DataBaseSolution.AddProduct(product);
ProductName.Clear();
ProductKCAL.Clear();
Unit.ClearValue(NameProperty);
Quan.Clear();
}
private void btnClear_Click(object sender, EventArgs e)
{
id = 0;
FName.Clear();
Surname.Clear();
Email.Clear();
City.Clear();
ProductCategory.Clear();
ProductCode.Clear();
ProductName.Clear();
ProductVolume.Clear();
ProductUnit.Clear();
comboBox1.Items.Clear();
ProductCost.Clear();
}
private void Add_Click(object sender, EventArgs e)
{
if (ProductID.Text == "" || Quantity.Text == "" || ProductName.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("Insert into STOCK (PID,QUANTITY) values(@pID,@quantity);", con);
cmd.Parameters.AddWithValue("@pid", ProductID.Text);
cmd.Parameters.AddWithValue("@quantity", Quantity.Text);
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Stock Insertion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Stock Insertion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
//Clear all the fields
ProductID.Clear();
Quantity.Clear();
ProductName.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void Update_Click(object sender, EventArgs e)
{
if (ProductName.Text == "" || productID.Text == "" || VendorID.Text == "" || Amount.Text == "")
{
MessageBox.Show("Please provide all the details", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
Connect conObj = new Connect();
con = conObj.connect();
SqlCommand cmd = new SqlCommand("UPDATE PRODUCT SET pname = @pname,amount = @amount,vid = @vid WHERE pid = @id;", con);
cmd.Parameters.AddWithValue("@id", productID.Text);
cmd.Parameters.AddWithValue("@pname", ProductName.Text);
cmd.Parameters.AddWithValue("@vid", VendorID.Text);
cmd.Parameters.AddWithValue("@amount", Amount.Text);
//cid += 1;
int i = cmd.ExecuteNonQuery();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Product Updation Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Product Updation Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
ProductName.Clear();
productID.Clear();
VendorID.Clear();
Amount.Clear();
}
private void BtnRefesh_Click(object sender, RoutedEventArgs e)
{
ProductName.Clear();
ProductPrice.Clear();
ProductDescription.Clear();
ProductDate.Text = null;
ProductInitialAmount.Clear();
ProductCapital.Clear();
comboProductTypes.SelectedIndex = -1;
BitmapImage image = new BitmapImage();
image.BeginInit();
image.UriSource = new Uri("pack://application:,,/Images/Image.png");
image.EndInit();
imgProduct.Source = image;
imgProduct.Tag = null;
}
private void addToBasket_Click(object sender, EventArgs e)
{
string prodPrice = Price.Text;
string prodQuant = Quantity.Text;
string product = ProductName.Text;
decimal quan = Convert.ToDecimal(prodQuant);
decimal price = Convert.ToDecimal(prodPrice);
string quan2 = Convert.ToString(quan);
string price2 = Convert.ToString(price);
var item = new ListViewItem(product);
item.SubItems.Add(quan2);
item.SubItems.Add(price2);
basket.Items.Add(item);
ProductName.Clear();
Quantity.Value = 0;
Price.Clear();
}
private void searchButton_Click(object sender, RoutedEventArgs e)
{
UserControl usc = null;
GridResult.Children.Clear();
Product product = new Product();
product = DataBaseSolution.SearchProduct((ProductName.Text).ToString());
if (product.Name != null)
{
ProductName.Clear();
usc = new UserControlPositiveSearchResult(product);
GridResult.Children.Add(usc);
}
else
{
usc = new UserControlNegativeSearchResult();
GridResult.Children.Add(usc);
}
}
private void clear_Click(object sender, EventArgs e)
{
ProductID.Clear();
Quantity.Clear();
ProductName.Clear();
}
