private void btnSua_Click(object sender, RoutedEventArgs e)
{
TietHoc th;
if (tietHocSelected is TietHocBu)
{
th = new TietHocBu(this.lopHoc, tietHocSelected.Id, txtTenPhong.Text, ngayHocTxt.SelectedDate.Value, cbxTrangThai.SelectedIndex - 1, txtGhiChu.Text, int.Parse(txtTietBatDau.Text));
}
else
{
th = new TietHoc(tietHocSelected.LopHoc, tietHocSelected.Id, txtTenPhong.Text.ToUpper(), tietHocSelected.NgayHoc, cbxTrangThai.SelectedIndex - 1, txtGhiChu.Text);
}
TietHocDAO.Instance.SuaTietHoc(th);
gridTietHoc.ItemsSource = sortBuoiHoc(TietHocDAO.Instance.DSTietHocTheoLopHoc(this.lopHoc.MaLopHoc + ""));
}
public List <TietHoc> LayDsTietHoc(string query)
{
DataTable dt = DataProvider.Instance.ExcuteQuery(query);
List <TietHoc> dsTietHoc = new List <TietHoc>();
foreach (DataRow item in dt.Rows)
{
if (item["ngayHoc"] != DBNull.Value)
{
LopHoc lh = LopHocDAO.Instance.TimLopHoc(item["maLopHoc"] + "");
TietHoc th = new TietHocBu(lh, int.Parse(item["idTietHoc"].ToString()), item["tenPhong"].ToString(), Convert.ToDateTime(item["ngayHoc"]), int.Parse(item["trangThai"].ToString()), item["ghiChu"].ToString(), int.Parse(item["tietBatDau"].ToString()));
dsTietHoc.Add(th);
}
else
{
LopHoc lh = LopHocDAO.Instance.TimLopHoc(item["maLopHoc"] + "");
TietHoc th = new TietHocBu(lh, int.Parse(item["idTietHoc"].ToString()), item["tenPhong"].ToString(), int.Parse(item["trangThai"].ToString()), item["ghiChu"].ToString());
dsTietHoc.Add(th);
}
}
return(dsTietHoc);
}
