private void removeBtn_Click(object sender, EventArgs e) { if (removeUsername.Text == GlobalLoginData.username) { MessageBox.Show("Sorry, you cannot remove the account in use."); } else { try { string query = "DELETE FROM USER WHERE username=@username"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@username", removeUsername.Text)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("User Removed Successfully!"); populateGrid(); } else { MessageBox.Show("No such user found!"); } } catch (Exception) { MessageBox.Show("No such user found!"); } } }
private void dispatchBtn_Click(object sender, EventArgs e) { string val = null; try { val = dataGridView2.SelectedRows[0].Cells["Order #"].Value.ToString(); }catch (Exception) { MessageBox.Show("Nothing Selected"); } string update = "UPDATE requestorder set released='Yes' where ro=@ronum"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@ronum", val)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(update, paramList); if (rowsAffected != 0) { MessageBox.Show("Order Dispatched!"); populateDataGrid(); } else { MessageBox.Show("Error Occured! Please check Selection!"); } }
private void addBtn_Click(object sender, EventArgs e) { string memberName = nameTxt.Text; string username = usernameTxt.Text; string password = passwordTxt.Text; string retypePassword = retypePasswordTxt.Text; string userRole = null; if (adminRadio.Checked) { userRole = "Admin"; } else if (memberRadio.Checked) { if (purchasingRadio.Checked) { userRole = "Purchasing"; } if (recievingRadio.Checked) { userRole = "Recieving"; } if (storekeeperRadio.Checked) { userRole = "Store Keeper"; } } if ((string.Compare(password, retypePassword)) != 0) { MessageBox.Show("Password doesn't match!"); } else if (!String.IsNullOrEmpty(userRole) && !String.IsNullOrEmpty(memberName) && !String.IsNullOrEmpty(username) && !String.IsNullOrEmpty(password) && ((string.Compare(password, retypePassword)) == 0)) { try { string query = "INSERT INTO USER VALUES (@memberName,@username,@password,@role)"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@memberName", memberName)); paramList.Add(new MySqlParameter("@username", username)); paramList.Add(new MySqlParameter("@password", password)); paramList.Add(new MySqlParameter("@role", userRole)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("User Added Successfully!"); } else { MessageBox.Show("Error Occured! Please check if the user already exists!"); } } catch (Exception) { MessageBox.Show("Error Occured! Please check if the user already exists!"); } } }
private void removeItem() { int selectedRowIndex = dataGridView2.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dataGridView2.Rows[selectedRowIndex]; string itemCode = Convert.ToString(selectedRow.Cells["Item Code"].Value); try { string query = "DELETE FROM STORE WHERE item_code=@itemCode"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@itemCode", itemCode)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("Item Removed Successfully!"); populateGrid(); } else { MessageBox.Show("Error!"); } } catch (Exception) { MessageBox.Show("Error!"); } }
private void requestRemovalBtn_Click(object sender, EventArgs e) { int selectedRowIndex = dataGridView2.SelectedCells[0].RowIndex; DataGridViewRow selectedRow = dataGridView2.Rows[selectedRowIndex]; string itemCode = Convert.ToString(selectedRow.Cells["Item Code"].Value); try { string query = "UPDATE STORE SET pending_removal = @state WHERE item_code=@itemCode"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@state", "Yes")); paramList.Add(new MySqlParameter("@itemCode", itemCode)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("Removal Request Added!"); populateGrid(); } else { MessageBox.Show("Error!"); } } catch (Exception) { MessageBox.Show("Error!"); } }
private void removeSupplierBtn_Click(object sender, EventArgs e) { try { string query = "DELETE FROM SUPPLIER WHERE supplier_code=@supplierCode"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@supplierCode", removeSupplierId.Text)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("Supplier Removed Successfully!"); populateGrid(); } else { MessageBox.Show("Error! The supplier may have unremoved items. Remove items first!"); } } catch (Exception) { MessageBox.Show("Error! The supplier may have unremoved items. Remove items first!"); } }
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 STORE WHERE item_code = @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 STORE WHERE item_code = @itemCode"; string possibility = DatabaseHandler.returnOneValue(queryGetQtyCondition, paramList3, "possibility"); Console.WriteLine("String Possobility " + possibility); if (string.Compare(possibility, "Yes") == 0) { Console.WriteLine("String Possobility 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 STORE SET qty = qty - @itemQty WHERE item_code = @itemCode", paramList2); if (responseChange == 1) { MessageBox.Show("Update Successful"); } else { MessageBox.Show("Error Occured!"); } } catch (Exception) { MessageBox.Show("Error Occured!"); } } } catch (Exception err) { MessageBox.Show("Sorry, Invalid Item Code"); } } else { MessageBox.Show("Sorry, Invalid Item Code"); } populateGrid(); }
private void declineBtn_Click(object sender, EventArgs e) { string val = dataGridView1.SelectedRows[0].Cells["Order #"].Value.ToString(); string update = "UPDATE requestorder set approval='Declined' where ro=@ronum"; //string putBack = "" List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@ronum", val)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(update, paramList); if (rowsAffected != 0) { string itemCodeTemp; string putBack; string putBackqty; for (int i = 0; i < dataGridView6.RowCount - 1; i++) { try { itemCodeTemp = dataGridView6.SelectedRows[i].Cells["Item Code"].Value.ToString(); putBackqty = dataGridView6.SelectedRows[i].Cells["Qty"].Value.ToString(); putBack = "UPDATE STORE SET qty = qty + @putbackQty WHERE item_code = @itemCode"; Console.WriteLine("GridView Row Count: " + dataGridView6.RowCount); Console.WriteLine("itemCodeTemp: " + itemCodeTemp); Console.WriteLine("putBackqty " + putBackqty); List <MySqlParameter> paramList2 = new List <MySqlParameter>(); paramList2.Add(new MySqlParameter("@putbackQty", putBackqty)); paramList2.Add(new MySqlParameter("@itemCode", itemCodeTemp)); Console.WriteLine("query :" + putBack); DatabaseHandler.insertOrDeleteRow(putBack, paramList2); }catch (Exception err) { Console.WriteLine(err); } } MessageBox.Show("Purchase Order Declined!"); populateDataGrid(); } else { MessageBox.Show("Error Occured! Please check Selection!"); } }
private void addBtnTxt_Click(object sender, EventArgs e) { string hospital = hospitalTxt.Text; string identifier = identifierTxt.Text; string area = areaTxt.Text; string contactName = contactNameTxt.Text; string contactNum = contactNumTxt.Text; string email = emailTxt.Text; if (!String.IsNullOrEmpty(hospital) && !String.IsNullOrEmpty(identifier) && !String.IsNullOrEmpty(area) && !String.IsNullOrEmpty(contactNum) && !String.IsNullOrEmpty(contactName) && !String.IsNullOrEmpty(email)) { try { string query = "INSERT INTO CLIENT VALUES (@hospital,@identifier,@area,@contactName,@contactNum,@email)"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@hospital", hospital)); paramList.Add(new MySqlParameter("@identifier", identifier)); paramList.Add(new MySqlParameter("@area", area)); paramList.Add(new MySqlParameter("@contactName", contactName)); paramList.Add(new MySqlParameter("@contactNum", contactNum)); paramList.Add(new MySqlParameter("@email", email)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("Supplier Added Successfully!"); hospitalTxt.Text = ""; identifierTxt.Text = ""; areaTxt.Text = ""; contactNameTxt.Text = ""; contactNumTxt.Text = ""; emailTxt.Text = ""; populateGrid(); } else { MessageBox.Show("Error Occured! Please check if the Client already exists!"); } } catch (Exception) { MessageBox.Show("Error Occured! Please check if the Client already exists!"); } } }
private void addSupplierBtn_Click(object sender, EventArgs e) { string supplierName = supplierNameTxt.Text; string supplierCode = supplierCodeTxt.Text; string contactNumber = contactNumberTxt.Text; string contactName = contactNameTxt.Text; string email = emailTxt.Text; if (!String.IsNullOrEmpty(supplierName) && !String.IsNullOrEmpty(supplierCode) && !String.IsNullOrEmpty(contactNumber) && !String.IsNullOrEmpty(contactName) && !String.IsNullOrEmpty(email)) { try { string query = "INSERT INTO SUPPLIER VALUES (@supplierCode,@supplierName,@contactName,@contactNumber,@email)"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@supplierCode", supplierCode)); paramList.Add(new MySqlParameter("@supplierName", supplierName)); paramList.Add(new MySqlParameter("@contactName", contactName)); paramList.Add(new MySqlParameter("@contactNumber", contactNumber)); paramList.Add(new MySqlParameter("@email", email)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("Supplier Added Successfully!"); populateGrid(); supplierNameTxt.Text = ""; supplierCodeTxt.Text = ""; contactNumberTxt.Text = ""; contactNameTxt.Text = ""; emailTxt.Text = ""; } else { MessageBox.Show("Error Occured! Please check if the Supplier already exists!"); } } catch (Exception) { MessageBox.Show("Error Occured! Please check if the Supplier already exists!"); } } }
private void approveBtn_Click(object sender, EventArgs e) { string val = dataGridView1.SelectedRows[0].Cells["Order #"].Value.ToString(); string update = "UPDATE requestorder set approval='Approved' where ro=@ronum"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@ronum", val)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(update, paramList); if (rowsAffected != 0) { MessageBox.Show("Purchase Order Confirmed!"); populateDataGrid(); } else { MessageBox.Show("Error Occured! Please check Selection!"); } }
private void addItemBtn_Click(object sender, EventArgs e) { string itemSupplierCode = itemSupplierCodeTxt.Text; string itemId = itemIdTxt.Text; string itemName = itemNameTxt.Text; string description = descriptionTxt.Text; if (!String.IsNullOrEmpty(itemSupplierCode) && !String.IsNullOrEmpty(itemId) && !String.IsNullOrEmpty(itemName) && !String.IsNullOrEmpty(description)) { try { string query = "INSERT INTO STORE(supplier_code,item_code,item_name,description) VALUES (@itemSupplierCode,@itemId,@itemName,@description)"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@itemSupplierCode", itemSupplierCode)); paramList.Add(new MySqlParameter("@itemId", itemId)); paramList.Add(new MySqlParameter("@itemName", itemName)); paramList.Add(new MySqlParameter("@description", description)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("Item Added Successfully!"); itemSupplierCodeTxt.Text = ""; itemIdTxt.Text = ""; itemNameTxt.Text = ""; descriptionTxt.Text = ""; populateGrid(); } else { MessageBox.Show("Error Occured! Please check if the Item already exists/Info entered!"); } } catch (Exception) { MessageBox.Show("Error Occured! Please check if the Item already exists/Info entered!"); } } }
private void declineBtn_Click(object sender, EventArgs e) { string val = dataGridView3.SelectedRows[0].Cells["Order #"].Value.ToString(); string update = "UPDATE purchaseorder set approval='Declined' where po=@ponum"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@poNum", val)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(update, paramList); if (rowsAffected != 0) { MessageBox.Show("Purchase Order Declined!"); populateGrid(); } else { MessageBox.Show("Error Occured! Please check Selection!"); } populateNonComboGrids(); }
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 STORE WHERE item_code = @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 STORE SET qty = qty + @itemQty WHERE item_code = @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 createPurchaseOrderBtn_Click(object sender, EventArgs e) { setPoNum(); try { string query = "insert into purchaseorder(supplier_code, approval,postedUser) values (@supplierCode,'Pending',@user);"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@supplierCode", selectedSupplier)); paramList.Add(new MySqlParameter("@user", GlobalLoginData.username)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { MessageBox.Show("Purchase Order Created Successfully!"); supplierComboBox.Enabled = true; populateGrid(); } else { MessageBox.Show("Error Occured! Please check input details!"); } } catch (Exception) { MessageBox.Show("Error Occured! Please check input details!"); } int i = dataGridView4.DisplayedRowCount(true); Console.WriteLine("Special i Value: " + i); string itemid; string qty; for (int row = 0; row < i - 1; row++) { string lastPo = DatabaseHandler.returnOneValueWithoutParams("SELECT*FROM purchaseorder", "po"); itemid = dataGridView4.Rows[row].Cells[0].Value.ToString(); qty = dataGridView4.Rows[row].Cells[2].Value.ToString(); Console.WriteLine(itemid + " " + qty); try { string query = "INSERT INTO po_item VALUES (@poNum,@itemCode,@qty)"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Add(new MySqlParameter("@poNum", lastPo)); paramList.Add(new MySqlParameter("@itemCode", itemid)); paramList.Add(new MySqlParameter("@qty", qty)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected != 0) { //populateGrid(); } else { MessageBox.Show("Error Occured! PO-Item Link Broken!"); } } catch (Exception) { MessageBox.Show("Error Occured! Please check if the Client already exists!"); } finally { populateGrid(); } } setPoNum(); addItemCodeTxt.Text = ""; addItemQty.Text = ""; dataGridView4.Rows.Clear(); Console.WriteLine("Current Row Count: " + dataGridView4.RowCount); Console.WriteLine("Current Displayed Row Count: " + dataGridView4.DisplayedRowCount(true)); }
private void commitBtn_Click(object sender, EventArgs e) { try { string updateQuery = "update purchaseorder set recieved = 'Yes' where po=@poNum"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@poNum", poNumTxt.Text)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(updateQuery, paramList); int rows = dataGridView3.RowCount; string itemid = null; string qty = null; for (int i = 0; i < rows - 1; i++) { itemid = dataGridView3.Rows[i].Cells[0].Value.ToString(); qty = dataGridView3.Rows[i].Cells[2].Value.ToString(); Console.WriteLine(itemid + " " + qty); try { string query = "UPDATE STORE SET qty= qty + @qty WHERE item_code=@itemid"; List <MySqlParameter> paramList2 = new List <MySqlParameter>(); paramList2.Add(new MySqlParameter("@qty", qty)); paramList2.Add(new MySqlParameter("@itemid", itemid)); int rowsAffected2 = DatabaseHandler.insertOrDeleteRow(query, paramList2); if (rowsAffected2 != 0) { //populateGrids(); } else { MessageBox.Show("Error Occured! PO-Item Link Broken!"); } } catch (Exception) { MessageBox.Show("Error Occured!"); } } if (rowsAffected != 0) { MessageBox.Show("Commited!"); populateGrids(); } else { MessageBox.Show("Error!"); } } catch (Exception) { MessageBox.Show("Error occured!"); } poNumTxt.Enabled = true; poNumTxt.Clear(); dataGridView3.DataSource = null; dataGridView3.Refresh(); supplierNameLbl.Text = ""; commitBtn.Enabled = false; }
private void dispatchRequestBtn_Click(object sender, EventArgs e) { setReqNum(); try { string query = "insert into requestorder(client_code, approval,postedUser) values (@clientCode,'Pending',@user)"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@clientCode", selectedClient)); paramList.Add(new MySqlParameter("@user", GlobalLoginData.username)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); if (rowsAffected == 1) { try { int i = dataGridView4.DisplayedRowCount(true); string itemid; string qty; for (int row = 0; row < i - 1; row++) { string lastRo = DatabaseHandler.returnOneValueWithoutParams("SELECT*FROM requestorder", "ro"); Console.WriteLine("lastRo: " + lastRo); itemid = dataGridView4.Rows[row].Cells[0].Value.ToString(); qty = dataGridView4.Rows[row].Cells[2].Value.ToString(); Console.WriteLine("itemid: " + itemid + " qty: " + qty); string query2 = "INSERT INTO ro_item VALUES (@roNum,@itemCode,@qty)"; paramList.Clear(); paramList.Add(new MySqlParameter("@roNum", lastRo)); paramList.Add(new MySqlParameter("@itemCode", itemid)); paramList.Add(new MySqlParameter("@qty", qty)); rowsAffected = DatabaseHandler.insertOrDeleteRow(query2, paramList); Console.WriteLine("rows affected: " + rowsAffected); if (rowsAffected == 1) { string updateStore = "UPDATE STORE SET qty = qty - @qty WHERE item_code = @itemCode"; paramList.Clear(); paramList.Add(new MySqlParameter("@qty", qty)); paramList.Add(new MySqlParameter("@itemCode", itemid)); DatabaseHandler.insertOrDeleteRow(updateStore, paramList); itemNameTxt.Clear(); qtyTxt.Clear(); dataGridView4.Rows.Clear(); } else { MessageBox.Show("Update Failed! RO Link Broken"); } } } catch (Exception) { } } else { MessageBox.Show("Update Failed!"); } MessageBox.Show("Purchase Order : Posted!"); populateDataGrid(); } catch (Exception) { } }
private void postRequest_Click(object sender, EventArgs e) { try { string getSupplierCodeQuery = "SELECT supplier_code from STORE WHERE item_code='" + reqProdId.Text + "'"; int rowCountSuppliers = DatabaseHandler.returnRowCountWithoutParams(getSupplierCodeQuery); Console.WriteLine("getSupplierCodeQuery: " + getSupplierCodeQuery + " rowCountSuppliers: " + rowCountSuppliers); if (rowCountSuppliers == 1) { string supplierCode = DatabaseHandler.returnOneValueWithoutParams(getSupplierCodeQuery, "supplier_code"); Console.WriteLine("supplierCode: " + supplierCode); try { string query = "insert into purchaseorder(supplier_code, approval,postedUser) values (@supplierCode,'Pending',@user);"; List <MySqlParameter> paramList = new List <MySqlParameter>(); paramList.Clear(); paramList.Add(new MySqlParameter("@supplierCode", supplierCode)); paramList.Add(new MySqlParameter("@user", GlobalLoginData.username)); int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList); Console.WriteLine("rowsAffected: " + rowsAffected); if (rowsAffected != 0) { string lastPo = DatabaseHandler.returnOneValueWithoutParams("SELECT*FROM purchaseorder", "po"); int lastPoNum; if (lastPo == "Null Data!") { lastPoNum = 0; } else { lastPoNum = Int32.Parse(lastPo); } Console.WriteLine("lastPoNum: " + lastPoNum); string insertQuery = "INSERT INTO po_item VALUES (@poNum,@itemCode,@qty)"; List <MySqlParameter> paramList2 = new List <MySqlParameter>(); paramList2.Add(new MySqlParameter("@poNum", lastPoNum)); paramList2.Add(new MySqlParameter("@itemCode", reqProdId.Text)); paramList2.Add(new MySqlParameter("@qty", reqQty.Text)); int rowsAffected2 = DatabaseHandler.insertOrDeleteRow(insertQuery, paramList2); Console.WriteLine("rowsAffected2: " + rowsAffected2); if (rowsAffected2 != 0) { MessageBox.Show("Purchase Request Created Successfully!"); populateGrid(); } else { MessageBox.Show("Error Occured! PO-Item Link Broken!"); } populateGrid(); } else { MessageBox.Show("Error Occured! Please check input details!"); } } catch (Exception) { MessageBox.Show("Error Occured! Please check input details!"); } } } catch (Exception) { } }