private void removeSupplierBtn_Click(object sender, EventArgs e)
{
try
{
string query1 = "SELECT * FROM SUPPLIER WHERE supplier_id= '" + removeSupplierId.Text.ToString() + "' ";
int count1 = DatabaseHandler.returnRowCountWithoutParams(query1);
Console.WriteLine("Selected supplier " + removeSupplierId.Text.ToString());
Console.WriteLine("Row count" + count1);
if (count1 == 0)
{
MessageBox.Show("Error! Supplier doesn't exist! ");
return;
}
string query = "DELETE FROM SUPPLIER WHERE supplier_id=@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 setproductlbl()
{
string querry = "SELECT * FROM item WHERE qty<50 ";
int count = DatabaseHandler.returnRowCountWithoutParams(querry);
products_lbl.Text = count.ToString();
}
private void setmateriallbl()
{
string querry = "SELECT * FROM raw_material WHERE qty<10 ";
int count = DatabaseHandler.returnRowCountWithoutParams(querry);
material_lbl.Text = count.ToString();
}
private void populate_item_order()
{
int pending = DatabaseHandler.returnRowCountWithoutParams("SELECT * from itemorder WHERE approval='Pending'");
int declined = DatabaseHandler.returnRowCountWithoutParams("SELECT * from itemorder WHERE approval='Declined'");
itemOrder_lbl.Text = pending.ToString();
declinedOrders_lbl.Text = declined.ToString();
}
private void addItemBtn_Click(object sender, EventArgs e)
{
string itemSupplierCode = itemSupplierCodeTxt.Text;
string itemId = itemIdTxt.Text;
string itemName = itemNameTxt.Text;
string unitPrice = unitPriceText.Text;
string lead_time = leadTime_txt.Text;
if (String.IsNullOrEmpty(itemSupplierCode) || String.IsNullOrEmpty(itemId) || String.IsNullOrEmpty(itemName) || String.IsNullOrEmpty(unitPrice))
{
MessageBox.Show("One or more feilds are empty!");
}
else if (!String.IsNullOrEmpty(itemSupplierCode) && !String.IsNullOrEmpty(itemId) && !String.IsNullOrEmpty(itemName) && !String.IsNullOrEmpty(unitPrice))
{
if (DatabaseHandler.returnRowCountWithoutParams("SELECT * FROM raw_material where material_id='" + itemIdTxt.Text + "'") != 0)
{
try
{
// MessageBox.Show("Such material exists, it will be added to the supplier mentioned");
string query = "INSERT INTO supplier_material(material_id,supplier_id,unit_price,lead_time) VALUES (@itemId,@itemSupplierCode,@unitPrice,@leadTime)";
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@itemSupplierCode", itemSupplierCode));
paramList.Add(new MySqlParameter("@itemId", itemId));
paramList.Add(new MySqlParameter("@unitPrice", unitPrice));
paramList.Add(new MySqlParameter("@leadTime", lead_time));
int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList);
if (rowsAffected != 0)
{
MessageBox.Show("Item Added Successfully!");
itemSupplierCodeTxt.Text = "";
itemIdTxt.Text = "";
itemNameTxt.Text = "";
unitPriceText.Text = "";
leadTime_txt.Text = "";
populateGrid();
}
else
{
MessageBox.Show("Error Occured! Please check the Info entered!");
}
}
catch (Exception)
{
MessageBox.Show("Error Occured! Please check if the Item already exists with the mentioned supplier!");
}
}
else
{
MessageBox.Show("Error Occured! No such material exists!");
}
}
}
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 itemIdTxt_Leave(object sender, EventArgs e)
{
if (DatabaseHandler.returnRowCountWithoutParams("SELECT * FROM raw_material where material_id='" + itemIdTxt.Text + "'") != 0)
{
String matrialName;
matrialName = DatabaseHandler.returnOneValueWithoutParams("SELECT name FROM raw_material WHERE material_id='" + itemIdTxt.Text + "'", "name").ToString();
itemNameTxt.Text = matrialName;
itemNameTxt.Enabled = false;
addNewMaterial_btn.Enabled = false;
addItemBtn.Enabled = true;
}
else
{
itemNameTxt.Enabled = true;
addNewMaterial_btn.Enabled = true;
addItemBtn.Enabled = false;
}
}
private void removeBtn_Click(object sender, EventArgs e)
{
if (removeUsername.Text == GlobalLoginData.username)
{
MessageBox.Show("Sorry, you cannot remove the account in use.");
return;
}
else
{
try
{
string query1 = "SELECT * FROM USER WHERE username= '******' ";
int count1 = DatabaseHandler.returnRowCountWithoutParams(query1);
Console.WriteLine("Selected user " + removeUsername.Text.ToString());
Console.WriteLine("Row count" + count1);
if (count1 == 0)
{
MessageBox.Show("Error! User doesn't exist! ");
return;
}
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!");
return;
}
}
catch (Exception)
{
MessageBox.Show("User has had interations with System! Cannot Remove!");
}
}
}
private void Add_btn_Click(object sender, EventArgs e)
{
string bomId;
bomId = bomId_txt.Text;
if (bomId == null)
{
MessageBox.Show("Invalid Selection!");
return;
}
int rowcount = DatabaseHandler.returnRowCountWithoutParams("select id from material_dispatch where bom_id='" + bomId + "'");
if (rowcount == 1)
{
MessageBox.Show("MATERIAL DISPATCH ORDER EXISTS FOR THE SELECTED BOM ID!!!");
return;
}
else
{
string selectStatement = "SELECT bom_item.material_id as 'Material ID', bom_item.qty as 'Quantity', raw_material.name as 'Material Name' FROM raw_material INNER JOIN bom_item ON bom_item.material_id = raw_material.material_id WHERE bom_item.bom_id = '" + bomId + "' ";
DatabaseHandler.populateGridViewWithBinding(selectStatement, dataGridView4);
}
}
private void RemoveBtn_Click(object sender, EventArgs e)
{
try
{
string query1 = "SELECT * FROM client WHERE client_id= '" + removeClient.Text.ToString() + "' ";
int count1 = DatabaseHandler.returnRowCountWithoutParams(query1);
Console.WriteLine("Selected client " + removeClient.Text.ToString());
Console.WriteLine("Row count" + count1);
if (count1 == 0)
{
MessageBox.Show("Error! Client doesn't exist! ");
return;
}
string query = "DELETE FROM CLIENT WHERE client_id=@ClientCode";
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@clientCode", removeClient.Text.ToString()));
int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList);
paramList.Clear();
if (rowsAffected != 0)
{
MessageBox.Show("Client Removed Successfully!");
populateGrid();
}
else
{
MessageBox.Show("Error! Client has already intracted with the system! Cannot remove!");
}
}
catch (Exception)
{
MessageBox.Show("Error! Client has already intracted with the system! Cannot remove!");
}
}
private void fill_materialDispatch_order()
{
int pending = DatabaseHandler.returnRowCountWithoutParams("SELECT * from material_dispatch WHERE approval='Pending'");
materialDispatch_lbl.Text = pending.ToString();
}
private void fill_production_order()
{
int pending = DatabaseHandler.returnRowCountWithoutParams("SELECT * from productionorder WHERE approval='Pending'");
productionOrder_lbl.Text = pending.ToString();
}