public System.Data.DataTable GetStudents(string schoolid)
{
lstStudentDetails = new ObservableCollection <StudentDetailsViewModelEntity>();
DataTable dt = Common.GetStudents();
foreach (DataRow dr in dt.Rows)
{
StudentDetailsViewModelEntity obj = new StudentDetailsViewModelEntity();
obj.FirstName = dr[0].ToString();
obj.StudentID = dr[1].ToString();
obj.EnrollmentNo = dr[2].ToString();
lstStudentDetails.Add(obj);
}
return(dt);
}
public void AdvanceSearch()
{
ImageConvertor objImageConvertor = new ImageConvertor();
string sql = "exec [SMS].[GetStudentDetails] '" + 0 + "','" + EnrollmentNo + "','" + FirstName + "','" + MiddleName + "','" + LastName + "','" + DateOfBirth1.ToString("yyyyMMdd") + "','" + LeavingDate1.ToString("yyyyMMdd") + "','" + FatherName + "','" + MotherName + "'," + this.Schoolid;
SearchResult = DAL.Select(sql);
if (SearchResult == null || SearchResult.Rows.Count == 0)
{
return;
}
StudentDetailCollection = new ObservableCollection <StudentDetailsViewModelEntity>();
foreach (DataRow dr in SearchResult.Rows)
{
StudentDetailsViewModelEntity obj = new StudentDetailsViewModelEntity();
obj.IUDFlag = "U";
obj.StudentID = dr["StudentID"].ToString();
obj.EnrollmentNo = dr["EnrollmentNo"].ToString();
obj.FirstName = dr["FirstName"].ToString();
obj.MiddleName = dr["MiddleName"].ToString();
obj.LastName = dr["LastName"].ToString();
obj.DateofBirthStr = dr["DateOfBirth"].ToString();
obj.DateOfAdmission = Convert.ToDateTime(dr["DateOfAdmission"]);
obj.Gender = dr["Gender"].ToString();
SetGender();
obj.Address = dr["FullAddress"].ToString();
obj.MobileNumber = dr["MobileNumber"].ToString();
obj.EmergencyContactNo1 = dr["EmergencyContactNo1"].ToString();
obj.EmergencyContactNo2 = dr["EmergencyContactNo2"].ToString();
obj.MotherName = dr["MotherName"].ToString();
obj.FatherName = dr["FatherName"].ToString();
int result = 0;
int.TryParse(dr["MotherOccupation"].ToString(), out result);
obj.SelectedOccupationMother = lstMothersOccupation.First(x => x.StaticID == result);
int.TryParse(dr["FatherOccupation"].ToString(), out result);
obj.SelectedOccupationFather = lstFathersOccupation.First(x => x.StaticID == result);
obj.EmailAddress = dr["EmailAddress"].ToString();
obj.Nationality = dr["Nationality"].ToString();
int.TryParse(dr["Caste"].ToString(), out result);
obj.SelectedReligion = lstReligion.First(x => x.StaticID == result); //new StaticDataModel() { StaticID = result, StaticName = "Islam" }; //result;// int.Parse(dr["Caste"].ToString());
obj.Caste = dr["SubCaste"].ToString();
obj.DateofLeavingStr = dr["LeavingDate"].ToString();
obj.Picture = dr["Picture"].ToString();
obj.PhotoID = dr["PhotoID"].ToString();
obj.PreviousSchool = dr["PreviousSchool"].ToString();
if (!string.IsNullOrEmpty(obj.PhotoID))
{
if (File.Exists(obj.PhotoID))
{
StreamReader sr = new StreamReader(obj.PhotoID);
string photostring = sr.ReadToEnd();
sr.Close();
byte[] bytearr = Convert.FromBase64String(photostring);
objImageConvertor.ConvertByteArrayToPhot(bytearr);
}
}
obj.ImageSource = objImageConvertor.ImageSource;
obj.Age = dr["Age"].ToString();
int.TryParse(dr["ClassRoom"].ToString(), out result);
obj.SelectedClass = lstClassRoom.First(x => x.StaticID == result);// int.Parse(dr["ClassRoom"].ToString());
StudentDetailCollection.Add(obj);
}
}