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";
}
}
}
