protected void Page_Load(object sender, EventArgs e)
{
try
{
Department();
}
catch (TimeoutException ex)
{
Session.Clear();
Response.Redirect("~/Student/Login.aspx");
}
}
private void Department()
{
CommunityManagement.CommunityManagementSoap deptService = new CommunityManagement.CommunityManagementSoapClient();
GetAllDepartmentRequest deptRequest = new GetAllDepartmentRequest();
deptRequest.Body = new GetAllDepartmentRequestBody();
GetAllDepartmentResponse deptResponse = deptService.GetAllDepartment(deptRequest);
if (deptResponse != null)
{
drpDept.DataSource = deptResponse.Body.GetAllDepartmentResult;
drpDept.DataTextField = "DepartmentName";
drpDept.DataValueField = "DepartmentId";
drpDept.DataBind();
}
}
protected void drpDept_SelectedIndexChanged(object sender, EventArgs e)
{
CommunityManagement.CommunityManagementSoap branchService = new CommunityManagement.CommunityManagementSoapClient();
GetAllBranchesByDeptIdRequest branchRequest = new GetAllBranchesByDeptIdRequest();
branchRequest.Body = new GetAllBranchesByDeptIdRequestBody();
branchRequest.Body.deptId = int.Parse(drpDept.SelectedItem.Value.ToString());
GetAllBranchesByDeptIdResponse branchResponse = branchService.GetAllBranchesByDeptId(branchRequest);
if (branchResponse != null)
{
drpBranch.DataSource = branchResponse.Body.GetAllBranchesByDeptIdResult;
drpBranch.DataTextField = "BranchName";
drpBranch.DataValueField = "BranchId";
drpBranch.DataBind();
//ToogleAdvacneSearch();
}
}
protected void drpBranch_SelectedIndexChanged(object sender, EventArgs e)
{
CommunityManagement.CommunityManagementSoap classService = new CommunityManagement.CommunityManagementSoapClient();
GetAllClassNamesRequest classRequest = new GetAllClassNamesRequest();
classRequest.Body = new GetAllClassNamesRequestBody();
classRequest.Body.branchId = drpBranch.SelectedItem.Value.ToString();
GetAllClassNamesResponse classResponse = classService.GetAllClassNames(classRequest);
if (classResponse != null)
{
drpClass.DataSource = classResponse.Body.GetAllClassNamesResult;
drpClass.DataTextField = "ClassTitle";
drpClass.DataValueField = "ClassId";
drpClass.DataBind();
//ToogleAdvacneSearch();
}
}
protected void drpClass_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void btnSearch_Click(object sender, EventArgs e)
{
CommunityManagement.CommunityManagementSoap searchService = new CommunityManagement.CommunityManagementSoapClient();
GetAllUserNamesByUserTypeRequest searchRequest = new GetAllUserNamesByUserTypeRequest();
searchRequest.Body = new GetAllUserNamesByUserTypeRequestBody();
searchRequest.Body.name = txtName.Text;
searchRequest.Body.userType = int.Parse(drpUserType.SelectedItem.Value);
searchRequest.Body.dept = drpDept.SelectedItem.Value.ToString();
searchRequest.Body.className = drpClass.SelectedItem.Value;
GetAllUserNamesByUserTypeResponse searchResponse = searchService.GetAllUserNamesByUserType(searchRequest);
if (searchResponse != null)
{
lstBoxFriends.Items.Clear();
foreach (Search search in searchResponse.Body.GetAllUserNamesByUserTypeResult)
{
string name = search.FirstName.ToString();
lstBoxFriends.Items.Add(name);
}
}
}
//here is the web services written
[WebMethod]
public List<StaffClasses> GetAllClassNames(string branchId)
{
List<StaffClasses> classList = new List<StaffClasses>();
try
{
string connectionString = ConfigurationSettings.AppSettings["connectionString"];
SqlConnection con = new SqlConnection(connectionString); con.Open();
SqlCommand cmd = new SqlCommand("select distinct c.Title,c.Class_Id from Class_Master c,Branch_Master b where c.Branch_Id =" + branchId.ToString(), con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
StaffClasses className = new StaffClasses();
className.ClassId = dr["Class_Id"].ToString();
className.ClassTitle = dr["Title"].ToString();
classList.Add(className);
}
con.Close();
}
catch (Exception ex)
{
}
return classList;
}
[WebMethod]
public List<Department> GetAllDepartment()
{
List<Department> deptList = new List<Department>();
try
{
string connectionString = ConfigurationSettings.AppSettings["connectionString"];
SqlConnection con = new SqlConnection(connectionString); con.Open();
SqlCommand cmd = new SqlCommand("select * from Department_Master", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Department dept = new Department();
dept.DepartmentId = int.Parse(dr["Department_Id"].ToString());
dept.DepartmentName = dr["Department_Name"].ToString();
deptList.Add(dept);
}
con.Close();
}
catch (Exception ex)
{
}
return deptList;
}
[WebMethod]
public List<Branches> GetAllBranchesByDeptId(int deptId)
{
string connectionString = ConfigurationSettings.AppSettings["connectionString"];
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand("select distinct b.Branch_Id,b.Branch_Name from Branch_Master b,Department_Master d where b.Department_Id =" + deptId.ToString(), con);
SqlDataReader dr = cmd.ExecuteReader();
List<Branches> branchtList = new List<Branches>();
while (dr.Read())
{
Branches branches = new Branches();
branches.BranchId = dr["Branch_Id"].ToString();
branches.BranchName = dr["Branch_Name"].ToString();
branchtList.Add(branches);
// branches.DeptId = int.Parse(dr["Department_Id"].ToString());
}
con.Close();
return branchtList;
}
[WebMethod]
public List<Search> GetAllUserNamesByUserType(int userType, string name, st
Unsolved 
