private void AddItemBtn_Click(object sender, EventArgs e)
{
Console.WriteLine("In Add Btn: Current Index1: " + composition_dataGridView.Rows.Count);
string itemCode = addmaterialCodeTxt.Text;
string itemQty = addmaterialQty.Text;
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@itemCode", itemCode));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT*FROM raw_material WHERE material_id=@itemCode", paramList);
if (returnedRowCount != 0)
{
//Get Item Name from DB
paramList.Clear();
paramList.Add(new MySqlParameter("@itemCode", itemCode));
string itemName = DatabaseHandler.returnOneValue("SELECT name as 'Material Name' from raw_material where material_id=@itemCode", paramList, "Material Name");
//Add to composition_dataGridView
// int index = composition_dataGridView.DisplayedRowCount(true);
composition_dataGridView.Rows.Add(itemCode, itemName, itemQty);
// composition_dataGridView.Rows[index - 1].Cells[0].Value = itemCode;
// composition_dataGridView.Rows[index - 1].Cells[1].Value = itemName;
//composition_dataGridView.Rows[index - 1].Cells[2].Value = itemQty;
}
else
{
MessageBox.Show("Invalid Material Code!");
}
Console.WriteLine("In Add Btn: Current Index2: " + composition_dataGridView.Rows.Count);
}
private void loginBtn_Click(object sender, EventArgs e)
{
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@username", usernameTxt.Text));
paramList.Add(new MySqlParameter("@password", passwordTxt.Text));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT*FROM USER WHERE username=@username and password=@password", paramList);
if (returnedRowCount == 1)
{
GlobalLoginData.username = usernameTxt.Text;
paramList.Clear();
paramList.Add(new MySqlParameter("@username", usernameTxt.Text));
GlobalLoginData.userRole = DatabaseHandler.returnOneValue("SELECT role FROM USER WHERE username = @username", paramList, "role");
GlobalLoginData.Name = DatabaseHandler.returnOneValue("SELECT member_name FROM USER WHERE username = @username", paramList, "member_name");
this.Hide();
Dashboard dash = new Dashboard();
dash.Show();
}
else
{
MessageBox.Show("Invalid Credentials, Please Try Again!");
}
}
private void addItemBtn_Click(object sender, EventArgs e)
{
string itemCode = addItemCodeTxt.Text;
string itemQty = addItemQty.Text;
int i = dataGridView4.Rows.Count;
for (int row = 0; row < i - 1; row++)
{
if (dataGridView4.Rows[row].Cells[0].Value.ToString() == itemCode)
{
MessageBox.Show("Item already entered !!!");
return;
}
}
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@itemCode", itemCode));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT * FROM raw_material WHERE material_id = @itemCode", paramList);
int returnedRowCount2 = DatabaseHandler.returnRowCountWithoutParams("SELECT * FROM supplier_material WHERE material_id='" + itemCode + "' AND supplier_id='" + selectedSupplier + "'");
if (returnedRowCount != 0 && returnedRowCount2 != 0)
{
//Get Item Name from DB
paramList.Clear();
paramList.Add(new MySqlParameter("@itemCode", itemCode));
string itemName = DatabaseHandler.returnOneValue("SELECT name as 'Material Name' from raw_material where material_id=@itemCode", paramList, "Material Name");
String unitPrice = DatabaseHandler.returnOneValueWithoutParams("SELECT unit_price as 'Material Price' from supplier_material where material_id='" + itemCode + "' AND supplier_id='" + selectedSupplier + "'", "Material Price");
//Add to dataViewGrid4
int index = dataGridView4.Rows.Count;
dataGridView4.Rows.Add(itemCode, itemName, itemQty, unitPrice);
Console.WriteLine("In Add Btn: Current Index: " + index);
supplierComboBox.Enabled = false;
}
else if (returnedRowCount == 0)
{
MessageBox.Show("Invalid Item Code!");
}
else
{
MessageBox.Show("Selected supplier doesn't offer that item!");
}
Console.WriteLine("In Add Btn: Current Index2: " + dataGridView4.DisplayedRowCount(true));
}
private void addItemBtn_Click(object sender, EventArgs e)
{
string itemCode = addItemCodeTxt.Text;
string itemQty = addItemQty.Text;
int i = dataGridView4.Rows.Count;
for (int row = 0; row < i - 1; row++)
{
if (dataGridView4.Rows[row].Cells[0].Value.ToString() == itemCode)
{
MessageBox.Show("Item already entered !!!");
return;
}
}
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@itemCode", itemCode));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT*FROM item WHERE item_id=@itemCode", paramList);
if (returnedRowCount != 0)
{
//Get Item Name from DB
paramList.Clear();
paramList.Add(new MySqlParameter("@itemCode", itemCode));
string itemName = DatabaseHandler.returnOneValue("SELECT name as 'Item Name' from item where item_id=@itemCode", paramList, "Item Name");
//Add to dataViewGrid4
int index = dataGridView4.DisplayedRowCount(true);
dataGridView4.Rows.Add(itemCode, itemName, itemQty);
Console.WriteLine("In Add Btn: Current Index: " + index);
}
else
{
MessageBox.Show("Invalid Item Code!");
}
}
private void ApplyBtn_Click(object sender, EventArgs e)
{
setPoNum();
string poNum = poText.Text;
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@poNum", poNum));
paramList.Add(new MySqlParameter("@recieved", "No"));
paramList.Add(new MySqlParameter("@approval", "Approved"));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT * FROM productionorder WHERE pro_id = @poNum AND recieved=@recieved AND approval=@approval", paramList);
List <MySqlParameter> paramList2 = new List <MySqlParameter>();
paramList2.Add(new MySqlParameter("@poNum", poNum));
int returnedRowCount2 = DatabaseHandler.returnRowCount("SELECT * FROM bom WHERE pro_id = @poNum", paramList2);
if (returnedRowCount == 1 && returnedRowCount2 == 0)
{
// poText.Enabled = false;
string select = "SELECT productionorder_item.pro_id as 'Order #', productionorder_item.item_id as 'Item Code', item.name as 'Item Name', productionorder_item.qty as 'Qty' FROM productionorder_item INNER JOIN item ON productionorder_item.item_id = item.item_id WHERE productionorder_item.pro_id = '" + poNum + "'";
DatabaseHandler.populateGridViewWithBinding(select, dataGridView2);
setPoNum();
}
else if (returnedRowCount2 == 1)
{
MessageBox.Show("BOM already created for that production order. Please Try again..");
}
else
{
poText.Enabled = true;
MessageBox.Show("No such production order exists or the Order may not be approved. Please Try again..");
poText.Clear();
dataGridView2.DataSource = null;
dataGridView2.Refresh();
}
}
private void applyBtn_Click(object sender, EventArgs e)
{
string poNum = poNumTxt.Text;
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@poNum", poNum));
paramList.Add(new MySqlParameter("@recieved", "No"));
paramList.Add(new MySqlParameter("@approval", "Approved"));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT*FROM purchaseorder WHERE po_id = @poNum AND recieved=@recieved AND approval=@approval", paramList);
if (returnedRowCount == 1)
{
poNumTxt.Enabled = false;
string select = "select supplier.name from purchaseorder inner join supplier on purchaseorder.supplier_id = supplier.supplier_id where purchaseorder.po_id ='" + poNum + "'";
string returnedSupplierName = DatabaseHandler.returnOneValueWithoutParams(select, "name");
supplierNameLbl.Text = returnedSupplierName;
string query = "SELECT purchaseorder_item.material_id as 'Item Code', raw_material.name as 'Item', purchaseorder_item.qty as 'Qty' FROM purchaseorder_item INNER JOIN raw_material ON purchaseorder_item.material_id = raw_material.material_id WHERE purchaseorder_item.po_id = '" + poNum + "'";
DatabaseHandler.populateGridViewWithBinding(query, dataGridView3);
string selectedPo = "SELECT purchaseorder.po_id as 'Order #', supplier.name as 'Supplier', purchaseorder.creation_time as 'Order Creation Time', purchaseorder.postedUser as 'Posted By' FROM purchaseorder INNER JOIN supplier ON purchaseorder.supplier_id = supplier.supplier_id WHERE purchaseorder.approval = 'Approved' AND purchaseorder.po_id='" + poNum + "'";
DatabaseHandler.populateGridViewWithBinding(selectedPo, dataGridView1);
commitBtn.Enabled = true;
}
else
{
poNumTxt.Enabled = true;
MessageBox.Show("No such uncommited Purchase Order or the Order may not be approved. Please Try again..");
poNumTxt.Clear();
dataGridView3.DataSource = null;
dataGridView3.Refresh();
supplierNameLbl.Text = "";
}
}
private void manualAddBtn_Click(object sender, EventArgs e)
{
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Clear();
paramList.Add(new MySqlParameter("@itemCode", manualProductId.Text));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT * FROM item WHERE item_id = @itemCode", paramList);
int returnedRowCount2 = DatabaseHandler.returnRowCount("SELECT * FROM raw_material WHERE material_id = @itemCode", paramList);
if (returnedRowCount == 1)
{
try
{
List <MySqlParameter> paramList2 = new List <MySqlParameter>();
paramList2.Clear();
paramList2.Add(new MySqlParameter("@itemQty", manualQty.Text));
paramList2.Add(new MySqlParameter("@itemCode", manualProductId.Text));
int responseChange = DatabaseHandler.insertOrDeleteRow("UPDATE item SET qty = qty + @itemQty WHERE item_id = @itemCode", paramList2);
if (responseChange == 1)
{
MessageBox.Show("Update Successful");
}
else
{
MessageBox.Show("Error Occured!");
}
}
catch (Exception)
{
MessageBox.Show("Error Occured!");
}
}
else if (returnedRowCount2 == 1)
{
try
{
List <MySqlParameter> paramList2 = new List <MySqlParameter>();
paramList2.Clear();
paramList2.Add(new MySqlParameter("@itemQty", manualQty.Text));
paramList2.Add(new MySqlParameter("@itemCode", manualProductId.Text));
int responseChange = DatabaseHandler.insertOrDeleteRow("UPDATE raw_material SET qty = qty + @itemQty WHERE material_id = @itemCode", paramList2);
if (responseChange == 1)
{
MessageBox.Show("Update Successful");
}
else
{
MessageBox.Show("Error Occured!");
}
}
catch (Exception)
{
MessageBox.Show("Error Occured!");
}
}
else
{
MessageBox.Show("Sorry, Invalid item Code");
}
populateGrid();
}
private void manualSubstractBtn_Click(object sender, EventArgs e)
{
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Clear();
paramList.Add(new MySqlParameter("@itemCode", manualProductId.Text));
int returnedRowCount = DatabaseHandler.returnRowCount("SELECT * FROM item WHERE item_id = @itemCode", paramList);
int returnedRowCount2 = DatabaseHandler.returnRowCount("SELECT * FROM raw_material WHERE material_id = @itemCode", paramList);
if (returnedRowCount == 1)
{
try
{
List <MySqlParameter> paramList3 = new List <MySqlParameter>();
paramList3.Clear();
paramList3.Add(new MySqlParameter("@itemCode", manualProductId.Text));
paramList3.Add(new MySqlParameter("@value", manualQty.Text));
string queryGetQtyCondition = "SELECT IF(qty >= @value,'Yes','No') AS possibility FROM item WHERE item_id = @itemCode";
string possibility = DatabaseHandler.returnOneValue(queryGetQtyCondition, paramList3, "possibility");
Console.WriteLine("String Possibility " + possibility);
if (string.Compare(possibility, "Yes") == 0)
{
Console.WriteLine("String Possibility Inside If ");
try
{
List <MySqlParameter> paramList2 = new List <MySqlParameter>();
paramList2.Clear();
paramList2.Add(new MySqlParameter("@itemQty", manualQty.Text));
paramList2.Add(new MySqlParameter("@itemCode", manualProductId.Text));
int responseChange = DatabaseHandler.insertOrDeleteRow("UPDATE item SET qty = qty - @itemQty WHERE item_id = @itemCode", paramList2);
if (responseChange == 1)
{
MessageBox.Show("Update Successful");
}
else
{
MessageBox.Show("Error Occured!");
}
}
catch (Exception)
{
MessageBox.Show("Error Occured!");
}
}
else
{
MessageBox.Show("INSUFFICIANT ITEMS!");
}
}
catch (Exception)
{
MessageBox.Show("Sorry, Invalid Item Code");
}
}
else if (returnedRowCount2 == 1)
{
try
{
List <MySqlParameter> paramList3 = new List <MySqlParameter>();
paramList3.Clear();
paramList3.Add(new MySqlParameter("@itemCode", manualProductId.Text));
paramList3.Add(new MySqlParameter("@value", manualQty.Text));
string queryGetQtyCondition = "SELECT IF(qty >= @value,'Yes','No') AS possibility FROM raw_material WHERE material_id = @itemCode";
string possibility = DatabaseHandler.returnOneValue(queryGetQtyCondition, paramList3, "possibility");
Console.WriteLine("String Possbility " + possibility);
if (string.Compare(possibility, "Yes") == 0)
{
Console.WriteLine("String Possibility Inside If ");
try
{
List <MySqlParameter> paramList2 = new List <MySqlParameter>();
paramList2.Clear();
paramList2.Add(new MySqlParameter("@itemQty", manualQty.Text));
paramList2.Add(new MySqlParameter("@itemCode", manualProductId.Text));
int responseChange = DatabaseHandler.insertOrDeleteRow("UPDATE raw_material SET qty = qty - @itemQty WHERE material_id = @itemCode", paramList2);
if (responseChange == 1)
{
MessageBox.Show("Update Successful");
}
else
{
MessageBox.Show("Error Occured!");
}
}
catch (Exception)
{
MessageBox.Show("Error Occured!");
}
}
else
{
MessageBox.Show("INSUFFICIANT ITEMS!");
}
}
catch (Exception)
{
MessageBox.Show("Sorry, Invalid Item Code");
}
}
else
{
MessageBox.Show("Sorry, Invalid Item Code");
}
populateGrid();
}