private void Create_bom_btn_Click(object sender, EventArgs e)
{
setPoNum();
try
{
string query = "insert into bom( postedUser, pro_id) values (@user, @proId);";
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Clear();
paramList.Add(new MySqlParameter("@user", GlobalLoginData.username));
paramList.Add(new MySqlParameter("@proId", poText.Text));
int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList);
if (rowsAffected != 0)
{
//MessageBox.Show("BOM Created Successfully!");
}
else
{
MessageBox.Show("Error Occured! Please check input details!");
}
}
catch (Exception)
{
MessageBox.Show("Error Occured! Please check input details!");
}
int i = dataGridView2.Rows.Count;
Console.WriteLine("Special i Value: " + i);
string itemid;
string qty;
string bomId = bom_lbl.Text;
for (int row = 0; row < i - 1; row++)
{
itemid = dataGridView2.Rows[row].Cells[1].Value.ToString();
qty = dataGridView2.Rows[row].Cells[3].Value.ToString();
string querry = "SELECT material_id as 'material_id', quantity as 'quantity' FROM composition WHERE item_id= '" + itemid + "'";
DatabaseHandler.populatebomDataGridView(querry, dataGridView1, qty);
}
int j = dataGridView1.Rows.Count;
Console.WriteLine("Special j Value: " + j);
int temp = 0;
for (int row = 0; row < j - 1; row++)
{
itemid = dataGridView1.Rows[row].Cells[0].Value.ToString();
qty = dataGridView1.Rows[row].Cells[1].Value.ToString();
Console.WriteLine(itemid + " " + qty);
try
{
string query = "INSERT INTO bom_item VALUES (@material_id, @bom_id, @qty)";
List <MySqlParameter> paramList = new List <MySqlParameter>();
paramList.Add(new MySqlParameter("@material_id", itemid));
paramList.Add(new MySqlParameter("@bom_id", bomId));
paramList.Add(new MySqlParameter("@qty", qty));
int rowsAffected = DatabaseHandler.insertOrDeleteRow(query, paramList);
if (rowsAffected != 0)
{
// MessageBox.Show("BOM Created Successfully!");
temp++;
}
else
{
MessageBox.Show("Error Occured! BOM-material Link Broken!");
return;
}
}
catch (Exception)
{
MessageBox.Show("Error Occured!");
}
}
data = GetDataTableFromDGV(dataGridView1);
if (temp != 0)
{
MessageBox.Show("BOM Created Successfully!");
}
}