private void button2_Click(object sender, EventArgs e)
{
if (checkBox1.Checked == false)
{
MessageBox.Show("Please check search");
}
else
{
HQ_Product obj = new HQ_Product();
obj.Productid = Convert.ToInt32(comboBox1.SelectedValue);
bool a = obj.ptype();
if (a == true)
{
pnametextBox.Text = obj.ProductName;
expdatetextBox6.Text = obj.ProductExpdate;
mfgdatetextBox7.Text = obj.ProductMfgdate;
supplieridtextBox12.Text = obj.SupplierId.ToString();
quantitytextBox3.Text = obj.Quantity.ToString();
purchasepricetextBox13.Text = obj.PurchasePrice.ToString();
salespricetextBox4.Text = obj.SalesPrice.ToString();
pnametextBox.Text = obj.ProductName;
purchaseddatetextBox8.Text = obj.PurchasedDate;
producttypetextBox2.Text = obj.ProductType;
}
else
{
MessageBox.Show("Please enter Valid ID");
comboBox1.Focus();
}
}
}
public void LoadAll2()
{
string sql = "SELECT * FROM HQ_Product_Inventory";
this.dt = DataAccess.GetDataTable(sql);
this.count = dt.Rows.Count;
this.arr = new HQ_Product[this.count];
for (int i = 0; i < this.count; i++)
{
HQ_Product p = new HQ_Product();
p.Productid = (int)dt.Rows[i]["Product_ID"];
p.ProductType = dt.Rows[i]["Product_Type"].ToString();
p.ProductName = dt.Rows[i]["Product_Name"].ToString();
this.arr[i] = p;
}
}
public void LoadAll()
{
string sql = "SELECT * FROM HQ_Product_Inventory";
this.dt = DataAccess.GetDataTable(sql);
this.count = dt.Rows.Count;
this.arr = new HQ_Product[this.count];
for (int i = 0; i < this.count; i++)
{
HQ_Product p = new HQ_Product();
p.Productid = (int)dt.Rows[i]["Product_ID"];
p.ProductType = dt.Rows[i]["Product_Type"].ToString();
p.ProductExpdate = dt.Rows[i]["Product_EXP_Date"].ToString();
p.ProductMfgdate = dt.Rows[i]["Product_MFG_Date"].ToString();
p.SupplierId = Convert.ToInt16(dt.Rows[i]["Supplier_ID"]);
p.Quantity = Convert.ToInt32(dt.Rows[i]["Product_Quantity"]);
p.PurchasePrice = Convert.ToInt32(dt.Rows[i]["Product_Purchase_Price"]);
p.SalesPrice = Convert.ToInt32(dt.Rows[i]["Product_Sales_Price"]);
p.ProductName = dt.Rows[i]["Product_Name"].ToString();
p.PurchasedDate = dt.Rows[i]["Purchased_Date"].ToString();
this.arr[i] = p;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (pnametextBox.Text.Trim() == "")
{
MessageBox.Show("Please Enter Product Nmae");
}
else if (supplieridtextBox12.Text.Trim() == "")
{
MessageBox.Show("Please enter supplier ID");
}
else if (producttypetextBox2.Text.Trim() == "")
{
MessageBox.Show("Please enter Product Type=");
}
else if (purchasepricetextBox13.Text.Trim() == "")
{
MessageBox.Show("Please enter Purchase price");
}
else if (quantitytextBox3.Text.Trim() == "")
{
MessageBox.Show("Please enter quantity");
}
else if (salespricetextBox4.Text.Trim() == "")
{
MessageBox.Show("Please enter sales price");
}
else if (expdatetextBox6.Text.Trim() == "")
{
MessageBox.Show("Please enter exp date");
}
else if (mfgdatetextBox7.Text.Trim() == "")
{
MessageBox.Show("Please enter mfg date");
}
else if (purchasepricetextBox13.Text.Trim() == "")
{
MessageBox.Show("Please enter purchase price ");
}
else
{
if (checkBox1.Checked == false)
{
HQ_Product obj1 = new HQ_Product();
obj1.ProductType = producttypetextBox2.Text;
obj1.ProductExpdate = expdatetextBox6.Text;
obj1.ProductMfgdate = mfgdatetextBox7.Text;
obj1.SupplierId = Convert.ToInt32(supplieridtextBox12.Text);
obj1.Quantity = Convert.ToInt32(quantitytextBox3.Text);
obj1.PurchasePrice = Convert.ToInt32(purchasepricetextBox13.Text);
obj1.SalesPrice = Convert.ToInt32(salespricetextBox4.Text);
obj1.ProductName = pnametextBox.Text;
obj1.PurchasedDate = purchaseddatetextBox8.Text;
bool b = obj1.newentry();
if (b == true)
{
MessageBox.Show(" New Product Information listed Sucessfully");
}
else
{
MessageBox.Show("This product is already inlisted");
}
}
else
{
HQ_Product obj11 = new HQ_Product();
obj11.ProductExpdate = expdatetextBox6.Text;
obj11.ProductMfgdate = mfgdatetextBox7.Text;
obj11.Quantity = Convert.ToInt32(quantitytextBox3.Text);
obj11.PurchasePrice = Convert.ToInt32(purchasepricetextBox13.Text);
obj11.SalesPrice = Convert.ToInt32(salespricetextBox4.Text);
obj11.PurchasedDate = purchaseddatetextBox8.Text;
obj11.Productid = Convert.ToInt32(comboBox1.SelectedValue);
obj11.proupdate();
MessageBox.Show("Product information updated");
}
}
}
private void Savebutton_Click(object sender, EventArgs e)
{
if (ProductnametextBox1.Text == "")
{
MessageBox.Show("Please Enter Product Nmae");
}
else if (ProductTypetextBox.Text.Trim() == "")
{
MessageBox.Show("Please enter Priduct Type");
}
else if (QuantityTextBox.Text.Trim() == "")
{
MessageBox.Show("Please enter Product Quantity");
}
else if (SalespricetextBox4.Text.Trim() == "")
{
MessageBox.Show("Please enter Sales price");
}
else if (ExpdatetextBox2.Text.Trim() == "")
{
MessageBox.Show("Please enter expiry date");
}
else if (MfgdatetextBox3.Text.Trim() == "")
{
MessageBox.Show("Please enter mfg date");
}
else if (CheckindatetextBox4.Text.Trim() == "")
{
MessageBox.Show("Please enter Check in date");
}
else if (RequestedQuantitytextBox5.Text.Trim() == "")
{
MessageBox.Show("Please enter mfg date");
}
else
{
if (checkBox1.Checked == false)
{
Branch_Product obj1 = new Branch_Product();
obj1.ProductType = ProductTypetextBox.Text;
obj1.ProductExpdate = ExpdatetextBox2.Text;
obj1.ProductMfgdate = MfgdatetextBox3.Text;
if (LoginForm.USERTYPE == "hqmanager")
{
obj1.BranchId = Convert.ToInt32(comboBox1.SelectedValue);
}
else
{
obj1.BranchId = LoginForm.BRCHID;
}
obj1.Quantity = Convert.ToInt32(QuantityTextBox.Text);
obj1.ReqQuantity = Convert.ToInt32(RequestedQuantitytextBox5.Text);
obj1.SalesPrice = Convert.ToInt32(SalespricetextBox4.Text);
obj1.ProductName = ProductnametextBox1.Text;
obj1.CheckInDate = CheckindatetextBox4.Text;
HQ_Product hp = new HQ_Product();
hp.ProductName = obj1.ProductName;
hp.ProductType = obj1.ProductType;
obj1.Productid = hp.pid();
if (obj1.Productid == 0)
{
MessageBox.Show("Product is not listed in HQ");
}
else
{
bool b = obj1.newentry();
MessageBox.Show(" Product Information listed Sucessfully");
}
}
else
{
if (LoginForm.USERTYPE == "hqmanager")
{
MessageBox.Show("You can Only view");
}
else
{
Branch_Product obj11 = new Branch_Product();
obj11.ProductName = ProductnametextBox1.Text;
obj11.ProductType = ProductTypetextBox.Text;
obj11.SalesPrice = Convert.ToInt32(SalespricetextBox4.Text);
obj11.ProductMfgdate = MfgdatetextBox3.Text;
obj11.ProductExpdate = ExpdatetextBox2.Text;
obj11.Quantity = Convert.ToInt32(QuantityTextBox.Text);
obj11.ReqQuantity = Convert.ToInt32(RequestedQuantitytextBox5.Text);
obj11.CheckInDate = CheckindatetextBox4.Text;
HQ_Product hp1 = new HQ_Product();
hp1.ProductName = obj11.ProductName;
hp1.ProductType = obj11.ProductType;
obj11.Productid = hp1.pid();
obj11.proupdate();
MessageBox.Show("Product information updated");
}
}
}
}