partial void Deleteadmin_master(admin_master instance);
partial void Insertadmin_master(admin_master instance);
partial void Updateadmin_master(admin_master instance);
protected void Button1_Click(object sender, EventArgs e)
{
string pass = "";
admin_master admin = new admin_master();
canteen_master canteen = new canteen_master();
student_master student = new student_master();
/*int rows;
* string acc_select_SQL;
* SqlCommand acc_select = new SqlCommand();
* SqlConnection con = (SqlConnection)Application["conobj"]; */
var db = new QCDBMLDataContext();
if (RadioButtonList1.SelectedValue.Equals("admin"))
{
admin = db.admin_masters.Single(admin_master => admin_master.uname.Equals(TextBox1.Text));
pass = admin.pass;
/*acc_select_SQL = "SELECT * FROM admin_master WHERE uname = @tb_uname;";
* acc_select.CommandText = acc_select_SQL;
* acc_select.Connection = con;
* acc_select.Parameters.AddWithValue("@tb_uname", TextBox1.Text);*/
}
else if (RadioButtonList1.SelectedValue.Equals("manager"))
{
canteen = db.canteen_masters.Single(canteen_master => canteen_master.uname.Equals(TextBox1.Text));
pass = canteen.pass;
/*acc_select_SQL = "SELECT * FROM canteen_master WHERE uname = @tb_uname;";
* acc_select.CommandText = acc_select_SQL;
* acc_select.Connection = con;*/
//acc_select.Parameters.AddWithValue("@tb_uname", TextBox1.Text);
}
else if (RadioButtonList1.SelectedValue.Equals("student"))
{
student = db.student_masters.Single(student_master => student_master.uname.Equals(TextBox1.Text));
pass = student.pass;
/*acc_select_SQL = "SELECT * FROM student_master WHERE uname = @tb_uname;";
* acc_select.CommandText = acc_select_SQL;
* acc_select.Connection = con;
* acc_select.Parameters.AddWithValue("@tb_uname", TextBox1.Text);*/
}
else
{
Response.Write("Not Valid");
}
/*SqlDataAdapter adapter = new SqlDataAdapter(acc_select);
* DataSet dsAcc = new DataSet();
*
* try
* {
* con.Open();
* rows = adapter.Fill(dsAcc, "accounts");
* con.Close();
* if(rows != 0)
* {
* foreach(DataRow row in dsAcc.Tables["accounts"].Rows)
* {*/
if (TextBox2.Text.Equals(pass))
{
Session["logged_in"] = true;
Session["role"] = RadioButtonList1.SelectedValue;;
switch (RadioButtonList1.SelectedValue)
{
case "admin": Session["id"] = (int)admin.admin_id;
Response.Redirect("admin_dashboard.aspx");
break;
case "manager": Session["id"] = (int)canteen.canteen_id;
Response.Redirect("canteen_dashboard.aspx");
break;
case "student": Session["id"] = (int)student.id;
Response.Redirect("student_dashboard1.aspx");
break;
}
} /*
* }
* }
* else
* {
* Response.Write("Invalid username/password");
* }
* }
* catch(Exception mess)
* {
* Response.Write(mess.Message);
* con.Close();
* } */
}