public StudentInsertWindow()
{
InitializeComponent();
//Student = item;
Student = new StudentItem();
Groups = new GroupRepository().GetAll();
//SelectedGroup = new GroupItem(item.GroupId, item.GroupName);
DataContext = this;
}
public StudentEditWindow(StudentItem item)
{
InitializeComponent();
Student = item;
Groups = new GroupRepository().GetAll();
SelectedGroup = Groups[0];
//SelectedGroup = new DeaneryLibrary.GroupItem();
//SelectedGroup.Id = item.GroupId; SelectedGroup.Name = item.GroupName;
DataContext = this;
}
public List <GradeItem> GetGradeBySheetId(int id)
{
List <GradeItem> result = new List <GradeItem>();
try
{
StudentRepository _repo = new StudentRepository();
SqlCommand com = base._cnn.CreateCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select top 1000 * from get_grade_by_sheet_id(" + id + ")";
SqlDataReader dr = com.ExecuteReader();
/*
* g.GradeId, t.TypeOfGradeName as [Type],
* g.GradeValue,
* s.StudentId, s.StudentFirstName, s.StudentMiddleName, s.StudentLastName
* int id, string type, int value, StudentItem student
*/
while (dr.Read())
{
StudentItem s = _repo.GetOneById((int)dr["StudentId"]);
result.Add(
new GradeItem(
(int)dr["GradeId"],
dr["Type"].ToString(),
(int)dr["GradeValue"],
s
)
);
}
}
catch (Exception e) { throw e; }
return(result);
}
public GradeItem(int id, string type, int value, StudentItem student)
: base(id, type)
{
this.Value = value;
this.Student = student;
}
public GradeItem(int id, string type, int value, StudentItem student)
: base(id, type)
{
this.Value = value;
this.Student = student;
}