public void Home_Load(object sender, EventArgs e)
{
//Low Quantity Store items
string query = "SELECT * FROM store WHERE qty < 100";
int lowQyItemCount = DatabaseHandler.returnRowCountWithoutParams(query);
storeLowQty.Text = lowQyItemCount.ToString();
//Unapproved Purchase Orders
string query1 = "SELECT * FROM purchaseorder WHERE approval='Pending'";
int pendingPOCount = DatabaseHandler.returnRowCountWithoutParams(query1);
unapprovedPurchaseOrders.Text = pendingPOCount.ToString();
//uncommited recieving Orders
string query2 = "SELECT * FROM purchaseorder WHERE approval='Approved' AND recieved='No'";
int pendingrecievingsCount = DatabaseHandler.returnRowCountWithoutParams(query2);
uncommitedRecieving.Text = pendingrecievingsCount.ToString();
//Unapproved Dispatch Orders
string query3 = "SELECT * FROM requestorder WHERE approval='Pending'";
int unapprovedDispatchOrdersCount = DatabaseHandler.returnRowCountWithoutParams(query3);
unapprovedDispatchOrders.Text = unapprovedDispatchOrdersCount.ToString();
//undreleased Dispatch Orders
string query4 = "SELECT * FROM requestorder WHERE approval='Approved' AND released='No'";
int undispatchedDispatchOrdersCount = DatabaseHandler.returnRowCountWithoutParams(query4);
undispatchedOrders.Text = undispatchedDispatchOrdersCount.ToString();
}
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)
{
}
}
