private void btnBill_Click(object sender, EventArgs e)
{
string orderid = "";
SqlCommand cmd1 = con.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "insert into orderUser values('" + txtFirstName.Text + "','" + txtLastName.Text + "','" + cbbillType.Text + "','" + dtpBillDate.Value.ToString("dd/mm/yyyy") + "')";
cmd1.ExecuteNonQuery();
// To Make order to the corresponding ID
SqlCommand cmd2 = con.CreateCommand();
cmd2.CommandType = CommandType.Text;
cmd2.CommandText = "select top 1 * from orderUser order by id desc";
cmd2.ExecuteNonQuery();
DataTable dt2 = new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
da2.Fill(dt2);
foreach (DataRow dr2 in dt2.Rows)
{
orderid = dr2["id"].ToString();
}
foreach (DataRow dr in dt.Rows)
{
int qty = 0;
string pname = "";
SqlCommand cmd3 = new SqlCommand("insert into items(order_id,product,price,qty,total) values('" + orderid.ToString() + "', '" + dr["Product"].ToString() + "' , '" + dr["Price"].ToString() + "' , '" + dr["Qty"].ToString() + "', '" + dr["Total"].ToString() + "')", con);
cmd3.ExecuteNonQuery();
qty = Convert.ToInt32(dr["Qty"].ToString());
pname = dr["Product"].ToString();
SqlCommand cmd4 = new SqlCommand("update stock set product_qty = product_qty - " + qty + " where product_name = '" + pname + "' ", con);
cmd4.ExecuteNonQuery();
}
txtFirstName.Text = "";
txtLastName.Text = "";
txtPrice.Text = "";
txtQty.Text = "";
txtTotal.Text = "";
cbShowProducts.Text = "";
cbbillType.Text = "";
dt.Clear();
dgvShowAll.DataSource = dt;
MessageBox.Show("Records Inserted Successfully");
frmGenerateBill gbl = new frmGenerateBill();
gbl.get_value(Convert.ToInt32(orderid.ToString()));
gbl.Show();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
if (textBox2.Text != "")
{
if ((textBox1.Text == "admin" || textBox1.Text == "Admin" || textBox1.Text == "ADMIN") && textBox2.Text == "admin786")
{
frmAdminPanel admin = new frmAdminPanel();
this.Hide();
admin.Show();
}
else
{
bool isval;
bool isvalpass;
localhost.Service1 ser = new localhost.Service1();
ser.isvaliduser(textBox1.Text, textBox2.Text, out isval, out isvalpass);
if (isval)
{
//frmEmployee emp = new frmEmployee();
frmGenerateBill gb = new frmGenerateBill();
gb.Show();
//emp.Show();
this.Hide();
}
else
{
MessageBox.Show("Invalid User");
}
}
}
else
{
MessageBox.Show("Please Enter Password");
}
}
else
{
MessageBox.Show("Please Enter User Name");
}
}