private void Orders_Load(object sender, EventArgs e)
{
FormBorderStyle = FormBorderStyle.None;
WindowState = FormWindowState.Maximized;
TopMost = false;
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Arial", 12);
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
customerdb sdb = new customerdb();
dataGridView1.DataSource = sdb.selectall();
comboBox1.Items.Add("New");
comboBox1.Items.Add("In preparation");
comboBox1.Items.Add("In delivery");
comboBox1.Items.Add("Delivered");
comboBox3.Text = "Factory";
comboBox3.Items.Add("Sales area xyz");
comboBox3.Items.Add("Sales area xyz");
comboBox3.Items.Add("Sales area xyz");
for (int i = 1; i <= 16; i++)
{
productsdb pdb = new productsdb();
pdb.get(i);
comboBox2.Items.Add(pdb.name);
}
}
private void Formulation_Load(object sender, EventArgs e)
{
FormBorderStyle = FormBorderStyle.None;
WindowState = FormWindowState.Maximized;
TopMost = false;
for (int i = 1; i <= 16; i++)
{
productsdb pdb = new productsdb();
pdb.get(i);
comboBox1.Items.Add(pdb.name);
}
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=DESKTOP-GB0LHG2\\MSSQLSERVER01;Database=daudFactoryDB;Integrated Security=True");
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
double resin, uvtax, pack, titanium, dop, chock;
raw_materialdb rmdb = new raw_materialdb();
rmdb.get(1);
resin = rmdb.quantity;
raw_materialdb rmdb2 = new raw_materialdb();
rmdb2.get(2);
uvtax = rmdb2.quantity;
raw_materialdb rmdb3 = new raw_materialdb();
rmdb3.get(4);
pack = rmdb3.quantity;
raw_materialdb rmdb4 = new raw_materialdb();
rmdb4.get(5);
titanium = rmdb4.quantity;
raw_materialdb rmdb5 = new raw_materialdb();
rmdb5.get(6);
dop = rmdb5.quantity;
raw_materialdb rmdb6 = new raw_materialdb();
rmdb6.get(7);
chock = rmdb6.quantity;
int qnt = Int32.Parse(textBox1.Text);
if (comboBox1.Text == "2inch13ft,1.7kg")
{
resin = resin - (qnt * 1.3239);
chock = chock - (qnt * 0.2647);
pack = pack - (qnt * 0.07414);
titanium = titanium - (qnt * 0.02118);
dop = dop - (qnt * 0.0132);
uvtax = uvtax - (qnt * 0.000264);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 1.7);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
string name = comboBox1.Text;
edb.get(1);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "2inch13ft,2kg")
{
resin = resin - (qnt * 1.5576);
uvtax = uvtax - (qnt * 0.0003115);
pack = pack - (qnt * 0.08722);
titanium = titanium - (qnt * 0.02492);
dop = dop - (qnt * 0.01557);
chock = chock - (qnt * 0.31152);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 2);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
string name = comboBox1.Text;
edb.get(2);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "2inch10ft,1.3kg")
{
resin = resin - (qnt * 1.01246);
uvtax = uvtax - (qnt * 0.00020249);
pack = pack - (qnt * 0.0566978);
titanium = titanium - (qnt * 0.016199);
dop = dop - (qnt * 0.01012461);
chock = chock - (qnt * 0.20249);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 1.3);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(3);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "3inch13ft,2.6kg")
{
resin = resin - (qnt * 2.024922);
uvtax = uvtax - (qnt * 0.0004049);
pack = pack - (qnt * 0.113395);
titanium = titanium - (qnt * 0.0323987);
dop = dop - (qnt * 0.020249);
chock = chock - (qnt * 0.404984);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 2.6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(4);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "3inch13ft,3.6kg")
{
resin = resin - (qnt * 2.8037);
uvtax = uvtax - (qnt * 0.00056);
pack = pack - (qnt * 0.157009);
titanium = titanium - (qnt * 0.04485);
dop = dop - (qnt * 0.02803);
chock = chock - (qnt * 0.56074);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 3.6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(5);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "3inch13ft,4kg")
{
resin = resin - (qnt * 3.11526);
uvtax = uvtax - (qnt * 0.000623);
pack = pack - (qnt * 0.17445);
titanium = titanium - (qnt * 0.049844);
dop = dop - (qnt * 0.031152);
chock = chock - (qnt * 0.62305);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 4);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(6);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "3inch10ft,1.8kg")
{
resin = resin - (qnt * 1.401868);
uvtax = uvtax - (qnt * 0.00028036);
pack = pack - (qnt * 0.07850);
titanium = titanium - (qnt * 0.022429);
dop = dop - (qnt * 0.014018);
chock = chock - (qnt * 0.280373);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 1.8);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(7);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "3inch10ft,3.6kg")
{
resin = resin - (qnt * 2.8037);
uvtax = uvtax - (qnt * 0.00056);
pack = pack - (qnt * 0.157009);
titanium = titanium - (qnt * 0.04485);
dop = dop - (qnt * 0.02803);
chock = chock - (qnt * 0.56074);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 3.6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(8);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "4inch13ft,3.6kg")
{
resin = resin - (qnt * 2.8037);
uvtax = uvtax - (qnt * 0.00056);
pack = pack - (qnt * 0.157009);
titanium = titanium - (qnt * 0.04485);
dop = dop - (qnt * 0.02803);
chock = chock - (qnt * 0.56074);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 3.6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(9);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "4inch13ft,4.6kg")
{
resin = resin - (qnt * 3.5825);
uvtax = uvtax - (qnt * 0.0007165);
pack = pack - (qnt * 0.20062);
titanium = titanium - (qnt * 0.057320);
dop = dop - (qnt * 0.035825);
chock = chock - (qnt * 0.716510);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 4.6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(10);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "4inch13ft,6kg")
{
resin = resin - (qnt * 4.672896);
uvtax = uvtax - (qnt * 0.0009345);
pack = pack - (qnt * 0.26168);
titanium = titanium - (qnt * 0.074766);
dop = dop - (qnt * 0.046728);
chock = chock - (qnt * 0.934579);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(11);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "4inch10ft,2.6kg")
{
resin = resin - (qnt * 2.024922);
uvtax = uvtax - (qnt * 0.0004049);
pack = pack - (qnt * 0.113395);
titanium = titanium - (qnt * 0.0323987);
dop = dop - (qnt * 0.020249);
chock = chock - (qnt * 0.404984);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 2.6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(12);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "4inch10ft,3.6kg")
{
resin = resin - (qnt * 2.8037);
uvtax = uvtax - (qnt * 0.00056);
pack = pack - (qnt * 0.157009);
titanium = titanium - (qnt * 0.04485);
dop = dop - (qnt * 0.02803);
chock = chock - (qnt * 0.56074);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 3.6);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(13);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "5inch13ft,5.5kg")
{
resin = resin - (qnt * 4.2834);
uvtax = uvtax - (qnt * 0.00085668);
pack = pack - (qnt * 0.239875);
titanium = titanium - (qnt * 0.06853);
dop = dop - (qnt * 0.04283);
chock = chock - (qnt * 0.85669);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 5.5);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(14);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "5inch13ft,7kg")
{
resin = resin - (qnt * 5.451712);
uvtax = uvtax - (qnt * 0.00109);
pack = pack - (qnt * 0.305291);
titanium = titanium - (qnt * 0.087227);
dop = dop - (qnt * 0.054517);
chock = chock - (qnt * 1.09034);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 7);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(15);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
else if (comboBox1.Text == "6inch13ft,7.5kg")
{
resin = resin - (qnt * 5.84112);
uvtax = uvtax - (qnt * 0.0011682);
pack = pack - (qnt * 0.321702);
titanium = titanium - (qnt * 0.093457);
dop = dop - (qnt * 0.0584112);
chock = chock - (qnt * 1.1682);
cmd.CommandText = "update raw_material set quantity=" + resin + " where name= 'Resin'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + uvtax + " where name= 'UVtax'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + pack + " where name= 'One pack'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + titanium + " where name= 'Titanium'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + dop + " where name= 'DOP'";
cmd.ExecuteNonQuery();
cmd.CommandText = "update raw_material set quantity=" + chock + " where name= 'Chowk powder'";
cmd.ExecuteNonQuery();
double total = (qnt * 7.5);
cmd.CommandText = "INSERT INTO production_inventory (name, quantity, date, weight) values ('" + comboBox1.Text + "','" + textBox1.Text + "','" + dateTimePicker1.Text + "','" + total + "')";
cmd.ExecuteNonQuery();
productsdb edb = new productsdb();
edb.get(16);
int x;
x = edb.quantity + qnt;
cmd.CommandText = "update Products set Ready='" + x + "' where name='" + comboBox1.Text + "'";
cmd.ExecuteNonQuery();
}
}