public void StudentName()
{
var StName = (from r in km.Students orderby r.Name select r).ToList();
LstStudentName.DataSource = StName;
LstStudentName.DataTextField = "Name";
LstStudentName.DataValueField = "IdentityNumber";
LstStudentName.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
var lst = new List <Student>();
int schoolId = SchoolInfo.getId();
int semesterId = MyDate.getCurrentSemesterId();
var lststudents = (from k in km.Students where k.SchoolId == schoolId select k).ToList();
ddlName.DataSource = lststudents;
ddlName.DataBind();
if (PlaceHolderStdName.Visible == true)
{
LstStudentName.DataSource = (from k in lststudents where k.IdentityNumber == ddlName.SelectedValue select k).ToList();
}
else
if (PlaceHolderClass.Visible == true)
{
var subjectId = int.Parse(ddlSubject.SelectedValue);
var classId = ddlClass.SelectedValue;
LstStudentName.DataSource = (from k in lststudents
join ss in km.StudentsSubjects on k.IdentityNumber equals ss.StudentId
join s in km.SubjectsInSemesters on ss.SubjectId equals s.Id
where s.ClassId == classId && s.SubjectId == subjectId
orderby k.Name
select k).ToList();
}
else if (PlaceHolderYear.Visible == true)
{
var year = int.Parse(ddlYear.SelectedValue);
LstStudentName.DataSource = (from k in lststudents where k.Id != null && (k.Id / 1000) == year orderby k.Name select k).Distinct().ToList();
}
else if (PlaceHolderStdNumber.Visible == true)
{
LstStudentName.DataSource = (from k in lststudents where k.IdentityNumber == ddlStdNumber.SelectedValue select k).ToList();
}
else if (PlaceHolderSpecification.Visible == true)
{
LstStudentName.DataSource = (from k in lststudents where k.Specification == ddlSpecification.SelectedValue orderby k.Name select k).ToList();
}
LstStudentName.DataBind();
}
