private void button3_Click(object sender, EventArgs e)
{
connect1();
OracleCommand cm = new OracleCommand();
cm.Connection = conn;
cm.CommandText = "delete from po_details where porder_id=" + oid + "";
cm.CommandType = CommandType.Text;
cm.ExecuteNonQuery();
OracleCommand cm1 = new OracleCommand();
for (int i = 0; i < len; i++)
{
cm1.Connection = conn;
cm1.CommandText = "update product set stock=" + pqty[i + 1] + " where prod_id=" + (i + 1) + "";
cm1.CommandType = CommandType.Text;
cm1.ExecuteNonQuery();
}
emp f2 = new emp();
f2.Show();
this.Dispose();
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
connect1();
OracleCommand cm1 = new OracleCommand();
cm1.Connection = conn;
String s = extract_date();
Console.WriteLine(s + Form1.cust_id1);
cm1.CommandText = "insert into purchase_order values(" + oid + "," + Form1.cust_id1 + ",'" + s + "'," + ((oid % 4) + 1) + ")";
cm1.CommandType = CommandType.Text;
cm1.ExecuteNonQuery();
conn.Close();
emp f2 = new emp();
f2.Show();
this.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
String s = "";
if (radioButton2.Checked == true)
{
connect1();
comm = new OracleCommand();
comm.CommandText = "select* from employee";
comm.CommandType = CommandType.Text;
ds = new DataSet();
da = new OracleDataAdapter(comm.CommandText, conn);
da.Fill(ds, "employee");
dt = ds.Tables["employee"];
int t = dt.Rows.Count;
dr = dt.Rows[i];
String s1, s2;
int len = t;
int j = 0;
String user;
user = textBox1.Text;
pass = textBox2.Text;
int flag = 0;
while (j < len)
{
dr = dt.Rows[j];
s1 = dr["emp_ID"].ToString();
s2 = dr["password"].ToString();
if (s1.Equals(user) && s2.Equals(pass))
{
// MessageBox.Show("Logged In!");
flag = 1;
cust_id1 = Int32.Parse(s1);
cust_name = dr["emp_name"].ToString();
Console.WriteLine(cust_name);
address = dr["address"].ToString();
comm.CommandText = "select* from emp_phone where emp_id=" + s1 + "";
comm.CommandType = CommandType.Text;
ds = new DataSet();
da = new OracleDataAdapter(comm.CommandText, conn);
da.Fill(ds, "emp_phone");
dt = ds.Tables["emp_phone"];
dr = dt.Rows[i];
phone = dr["phone"].ToString();
emp f2 = new emp();
f2.Show();
this.Hide();
break;
}
j++;
}
if (flag == 0)
{
MessageBox.Show("Wrong Username/Password");
//new Form1().Show();
}
//comm.ExecuteNonQuery();
conn.Close();
}
else
{
connect1();
comm = new OracleCommand();
comm.CommandText = "select* from customer";
comm.CommandType = CommandType.Text;
ds = new DataSet();
da = new OracleDataAdapter(comm.CommandText, conn);
da.Fill(ds, "customer");
dt = ds.Tables["customer"];
int t = dt.Rows.Count;
dr = dt.Rows[i];
String s1, s2;
int len = t;
int j = 0;
String user;
user = textBox1.Text;
pass = textBox2.Text;
int flag = 0;
while (j < len)
{
dr = dt.Rows[j];
s1 = dr["cust_ID"].ToString();
s2 = dr["password"].ToString();
if (s1.Equals(user) && s2.Equals(pass))
{
// MessageBox.Show("Logged In!");
flag = 1;
cust_id1 = Int32.Parse(s1);
cust_name = dr["cus_name"].ToString();
Console.WriteLine(cust_name);
address = dr["address"].ToString();
comm.CommandText = "select* from cust_phone where cust_id=" + s1 + "";
comm.CommandType = CommandType.Text;
ds = new DataSet();
da = new OracleDataAdapter(comm.CommandText, conn);
da.Fill(ds, "cust_phone");
dt = ds.Tables["cust_phone"];
dr = dt.Rows[i];
phone = dr["phone"].ToString();
Form2 f2 = new Form2();
f2.Show();
this.Hide();
break;
}
j++;
}
if (flag == 0)
{
MessageBox.Show("Wrong Username/Password");
//new Form1().Show();
}
//comm.ExecuteNonQuery();
conn.Close();
}
}
