public ActionResult _GetTeachers(string selectedSchool)
{
var svm = new SubstituteViewModel();
var selectedTeachers = _db.SchoolTeachersWithADLogins.Where(i => i.Organization_Name == selectedSchool && i.COURSE_TITLE.Contains("PS") == false && i.COURSE_TITLE.Contains("Kind") == false).OrderBy(i => i.TeacherLastName).ToList();
foreach (var item in selectedTeachers)
{
var tl = new TeachList
{
SchoolName = item.Organization_Name,
TeacherName = item.TeacherLastName + ", " + item.TeacherFirstName,
BadgeNumber = item.BADGE_NUM
};
svm.TeacherList.Add(tl);
}
svm.TeacherList = svm.TeacherList.ToList();
return(PartialView("partials/_getTeachers", svm));
}
protected void EditDepartment_Click(object sender, EventArgs e)
{
Panel1.Visible = true;
maindiv.Visible = false;
Session["AccountT"] = "ChairPerson";
int DId = Convert.ToInt32((sender as Button).CommandArgument);
string TId = "";
/// Session["DId"] = DId;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
string query = "Select * from Department where DId='" + DId + "'";
SqlCommand com = new SqlCommand(query, con);
SqlDataReader dr = com.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
Dname.InnerText = dr["DepartmentName"].ToString();
Session["Dname"] = dr["DepartmentName"].ToString();
TId = dr["TId"].ToString();
Session["Prev_TID"] = TId;
Session["listId"] = TId;
}
con.Close();
}
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
string query = "Select * from Teacher where Department='" + DId + "'";
SqlDataAdapter sda = new SqlDataAdapter(query, con);
DataTable dt = new DataTable();
sda.Fill(dt);
TeachList.DataSource = dt;
TeachList.DataBind();
TeachList.DataTextField = "TName";
TeachList.DataValueField = "TId";
TeachList.DataBind();
TeachList.Items.Insert(0, new ListItem("Select", "NA"));
con.Close();
con.Open();
string q = "Select * from Teacher where Department='" + DId + "' and TId= '" + TId + "'";
SqlCommand com = new SqlCommand(q, con);
SqlDataReader dr = com.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
TeachList.SelectedIndex = TeachList.Items.IndexOf(TeachList.Items.FindByText(dr["TName"].ToString()));
email.InnerText = dr["Email"].ToString();
Img.ImageUrl = dr["Image"].ToString();
contact.InnerText = dr["Conatact"].ToString();
}
con.Close();
con.Open();
string q1 = "Select * from Login where AccoutType='" + "ChairPerson" + "' and UserId= '" + DId + "'";
SqlCommand c = new SqlCommand(q1, con);
SqlDataReader d = c.ExecuteReader();
d.Read();
{
uname.InnerText = d["UserName"].ToString();
Session["Log_Id"] = d["Id"].ToString();
Session["DId"] = d["UserId"].ToString();
}
con.Close();
}
// Response.Redirect("DepartmentReg.aspx");
}
