public OrderListForCust(string username, MenuCustomer f1)
{
InitializeComponent();
this.lbluser.Text = username;
//this.lbltype.Text = type;
this.F1 = f1;
OracleConnection con = new OracleConnection(constr);
con.Open();
string q1 = "select * from customer where cust_uname ='" + username + "'";
OracleCommand oc = new OracleCommand(q1, con);
OracleDataReader odr = oc.ExecuteReader();
if (odr.Read())
{
lblfullname.Text = (odr["cust_fname"].ToString());
lblid.Text = (odr["cust_id"].ToString());
lblphone.Text = (odr["cust_phone"].ToString());
lbladdress.Text = (odr["cust_address"].ToString());
}
con.Close();
loadGridview();
}
private void log()
{
string userName = txtUser.Text.ToString();
string password = txtpassword.Text.ToString();
string cmbType = cmbUsertype.Text.ToString();
OracleConnection con = new OracleConnection(constr);
con.Open();
/* string query = "Select count(*) From login where username ='******' and password ='******'and usertype ='" + cmbType + "'";
* string query2 = "Select usertype From login where username='******' and password ='******'";
*
* OracleDataAdapter oda = new OracleDataAdapter(query,con);
* DataTable dt = new DataTable();
* oda.Fill(dt);
*
*
* if (dt.Rows[0][0].ToString() == "1")
* {
* OracleDataAdapter oda1 = new OracleDataAdapter(query2, con);
* DataTable dt1 = new DataTable();
* oda1.Fill(dt1);
* if (dt1.Rows[0][0].ToString() == "Delivery Boy")
* {
* this.Hide();
* MenuDeliveryBoy m = new MenuDeliveryBoy(this.txtUser.Text, this.cmbUsertype.Text, this);
* m.Show();
* }
* }
*/
string q11 = "select count(*) from manager where mgr_uname ='" + userName + "' and password ='******'";
OracleDataAdapter oda22 = new OracleDataAdapter(q11, con);
DataTable dt22 = new DataTable();
oda22.Fill(dt22);
//OracleCommand cmd = new OracleCommand("select mgr_uname from manager",con);
// OracleDataReader dr = cmd.ExecuteReader();
// AutoCompleteStringCollection mycollection = new AutoCompleteStringCollection();
// while (dr.Read())
// {
// mycollection.Add(dr.GetString(0));
// }
if (dt22.Rows[0][0].ToString() == "1")
{
this.Hide();
MenuManager m = new MenuManager(this.txtUser.Text, this.cmbUsertype.Text, this);
m.Show();
}
// else if (dt22.Rows[0][0].ToString() == "0")
// {
// MessageBox.Show("Not Correct");
// }
string q1 = "select count(*) from shopkeeper where shpkper_uname ='" + userName + "' and password ='******'";
OracleDataAdapter oda2 = new OracleDataAdapter(q1, con);
DataTable dt2 = new DataTable();
oda2.Fill(dt2);
if (dt2.Rows[0][0].ToString() == "1")
{
this.Hide();
MenuShopkeepers m = new MenuShopkeepers(this.txtUser.Text, this);
m.Show();
}
string q2 = "select count(*) from Customer where cust_uname ='" + userName + "' and password ='******'";
OracleDataAdapter oda3 = new OracleDataAdapter(q2, con);
DataTable dt3 = new DataTable();
oda3.Fill(dt3);
if (dt3.Rows[0][0].ToString() == "1")
{
this.Hide();
MenuCustomer m = new MenuCustomer(this.txtUser.Text, this.cmbUsertype.Text, this);
m.Show();
}
string q5 = "select count(*) from DELIVERYBOY where DELBOY_UNAME ='" + userName + "' and password ='******'";
OracleDataAdapter oda5 = new OracleDataAdapter(q5, con);
DataTable dt5 = new DataTable();
oda5.Fill(dt5);
if (dt5.Rows[0][0].ToString() == "1")
{
this.Hide();
MenuDeliveryBoy m = new MenuDeliveryBoy(this.txtUser.Text, this.cmbUsertype.Text, this);
m.Show();
}
con.Close();
}