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)
{
}
}
