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(); }