protected void Page_Load(object sender, EventArgs e)
{
if (Session["otherUser"] == null)
{
Id = Session["Id"].ToString();
AccountID = Session["AccountId"].ToString();
}
else
{
Id = Session["otherUser"].ToString();
AccountID = Session["otherAccountId"].ToString();
}
if (!IsPostBack) //check if the webpage is loaded for the first time.
{
ViewState["PreviousPage"] =
Request.UrlReferrer;//Saves the Previous page url in ViewState
}
using (SqlConnection con = new SqlConnection(conString))
{
string cp = "ChairPerson";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT Department.DId,Department.DepartmentName,Department.TId,Teacher.TName,Teacher.TId FROM Department INNER JOIN Teacher ON Department.TId = Teacher.TId ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GVCP.DataSource = dt;
GVCP.DataBind();
con.Close();
}
}
protected void Canel_Click(object sender, EventArgs e)
{
Panel1.Visible = false;
maindiv.Visible = true;
con.Close();
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT Department.DId,Department.DepartmentName,Department.TId,Teacher.TName,Teacher.TId FROM Department INNER JOIN Teacher ON Department.TId = Teacher.TId ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GVCP.DataSource = dt;
GVCP.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!Session["ConfirmReg"].Equals(""))
{
ConfirmMsg.Text = "Account has been created successfully";
}
else
{
ConfirmMsg.Text = "";
}
}
catch (Exception ex)
{
ConfirmMsg.Text = "";
}
if (!IsPostBack) //check if the webpage is loaded for the first time.
{
ViewState["PreviousPage"] =
Request.UrlReferrer;//Saves the Previous page url in ViewState
}
if (!Page.IsPostBack)
{
try
{
if (Session["Index"].Equals("0"))
{
DDSelectUser.SelectedIndex = 0;
stdView.Visible = true;
TeacherView.Visible = false;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("Select * from Student ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GvStudent.DataSource = dt;
GvStudent.DataBind();
con.Close();
}
}
if (Session["Index"].Equals("1"))
{
DDSelectUser.SelectedIndex = 1;
stdView.Visible = false;
CPView.Visible = true;
TeacherView.Visible = false;
Label2.Visible = false;
using (SqlConnection con = new SqlConnection(conString))
{
string cp = "ChairPerson";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT Department.DId,Department.DepartmentName,Department.TId,Teacher.TName,Teacher.TId FROM Department INNER JOIN Teacher ON Department.TId = Teacher.TId ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GVCP.DataSource = dt;
GVCP.DataBind();
con.Close();
}
}
if (Session["Index"].Equals("2"))
{
DDSelectUser.SelectedIndex = 2;
stdView.Visible = false;
CPView.Visible = false;
TeacherView.Visible = true;
Label2.Visible = true;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teacher.Department = Department.DId ";
// string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teaccher.Department = Department.DId ";
SqlDataAdapter sda = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
sda.Fill(dt);
GVTeacher.DataSource = dt;
GVTeacher.DataBind();
con.Close();
}
}
}
catch (Exception ex)
{
// Session["Index"] = "";
DDSelectUser.SelectedIndex = 0;
stdView.Visible = true;
TeacherView.Visible = false;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("Select * from Student ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GvStudent.DataSource = dt;
if (dt.Rows[0][13].ToString().Equals("1"))
{
}
GvStudent.DataBind();
con.Close();
}
}
}
//if(Page.IsPostBack)
//{
//}
}
protected void DDSelectUser_SelectedIndexChanged(object sender, EventArgs e)
{
if (DDSelectUser.SelectedIndex == 0)
{
Session["Index"] = "0";
ConfirmMsg.Text = "";
stdView.Visible = true;
CPView.Visible = false;
TeacherView.Visible = false;
Label2.Visible = true;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("Select * from Student ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GvStudent.DataSource = dt;
if (dt.Rows[0][13].ToString().Equals("1"))
{
}
GvStudent.DataBind();
con.Close();
}
}
else if (DDSelectUser.SelectedIndex == 2)
{
Session["Index"] = "2";
ConfirmMsg.Text = "";
stdView.Visible = false;
CPView.Visible = false;
TeacherView.Visible = true;
Label2.Visible = true;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teacher.Department = Department.DId ";
// string query = "SELECT Department.DId,Department.DepartmentName,Teacher.TName,Teacher.TId,Teacher.Image,Teacher.Conatact,Teacher.Email,Teacher.Degree,Teacher.Department FROM Teacher INNER JOIN Department ON Teaccher.Department = Department.DId ";
SqlDataAdapter sda = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
sda.Fill(dt);
GVTeacher.DataSource = dt;
GVTeacher.DataBind();
con.Close();
}
}
else if (DDSelectUser.SelectedIndex == 1)
{
Session["Index"] = "1";
ConfirmMsg.Text = "";
stdView.Visible = false;
CPView.Visible = true;
TeacherView.Visible = false;
Label2.Visible = false;
using (SqlConnection con = new SqlConnection(conString))
{
string cp = "ChairPerson";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT Department.DId,Department.DepartmentName,Department.TId,Teacher.TName,Teacher.TId FROM Department INNER JOIN Teacher ON Department.TId = Teacher.TId ", con);
DataTable dt = new DataTable();
sda.Fill(dt);
GVCP.DataSource = dt;
GVCP.DataBind();
con.Close();
}
}
}
