public DataSet CheckUserType(Entities.tblSchoolId p1, Entities.Campus c1) { DataSet ds; using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectUserType]")) { dbCom.AddParameter("@ID", System.Data.SqlDbType.NVarChar, p1.schoolId); dbCom.AddParameter("@campus", System.Data.SqlDbType.NVarChar, c1.campusName); ds = new DataSet(); ds = dbCom.Execute(); } return(ds); }
protected void Loginc(object sender, EventArgs e) { user = username.Value; data = user.Split('@')[0]; data2 = user.Split('@')[1]; DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.tblSchoolId t1 = new Entities.tblSchoolId() { schoolId = data, }; Entities.Campus c1 = new Entities.Campus() { campusName = data2, }; DataSet ds = new DataSet(); ds = db.CheckUserType(t1, c1); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { usertype = ds.Tables[0].Rows[0]["userType"].ToString(); passcode = ds.Tables[0].Rows[0]["passCode"].ToString(); session = ds.Tables[0].Rows[0]["pKId"].ToString(); } else { Label1.Text = "Invalid Username or Password"; } if (usertype == "admin" || usertype == "Admin") { if (password.Value == passcode) { Session["School"] = session; Response.Redirect("Admin.aspx"); } else { Label1.Text = "Invalid Username or Password"; } } else if (usertype == "teacher" || usertype == "Teacher") { if (password.Value == passcode) { Session["School"] = session; Response.Redirect("Teacher.aspx"); } else { Label1.Text = "Invalid Username or Password"; } } else if (usertype == "student" || usertype == "Student") { if (password.Value == passcode) { Session["School"] = session; Response.Redirect("Students.aspx"); } else { Label1.Text = "Invalid Username or Password"; } } }
protected void Loginc(object sender, EventArgs e) { user = username.Value; data = user.Split('@')[0]; data2 = user.Split('@')[1]; DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.tblSchoolId t1 = new Entities.tblSchoolId() { schoolId = data, }; Entities.Campus c1 = new Entities.Campus() { campusName = data2, }; DataSet ds = new DataSet(); ds = db.CheckUserType(t1,c1); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { usertype = ds.Tables[0].Rows[0]["userType"].ToString(); passcode = ds.Tables[0].Rows[0]["passCode"].ToString(); session = ds.Tables[0].Rows[0]["pKId"].ToString(); } else { Label1.Text = "Invalid Username or Password"; } if (usertype == "admin" || usertype=="Admin") { if (password.Value == passcode) { Session["School"] = session; Response.Redirect("Admin.aspx"); } else { Label1.Text = "Invalid Username or Password"; } } else if (usertype == "teacher" || usertype=="Teacher") { if (password.Value == passcode) { Session["School"] = session; Response.Redirect("Teacher.aspx"); } else { Label1.Text = "Invalid Username or Password"; } } else if (usertype == "student" || usertype == "Student") { if (password.Value == passcode) { Session["School"] = session; Response.Redirect("Students.aspx"); } else { Label1.Text = "Invalid Username or Password"; } } }