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); }