public List <KhoaHocDTO> get_KhoaHocDAO(string MaKH)
{
List <KhoaHocDTO> lst_KhoaHoc = new List <KhoaHocDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string query = "select KH.MaKH, KH.TenKH, KH.MoTa, KH.HocPhi, CT.MaPhong, CT.MaCa, CT.NgayBatDau from KhoaHoc KH, ChiTietKhoaHoc CT where KH.MaKH = CT.MaKH AND KH.MaKH = @MaKH";
SqlParameter par = new SqlParameter("@MaKH", MaKH);
SqlDataReader sdr = DataProvider.ThucHienTruyVan(query, par, conn);
while (sdr.Read())
{
KhoaHocDTO item = new KhoaHocDTO();
item.MaKH = sdr["MaKH"].ToString();
item.MaPhong = sdr["MaPhong"].ToString();
item.TenKH = sdr["TenKH"].ToString();
item.MaCa = sdr["MaCa"].ToString();
item.MoTa = sdr["MoTa"].ToString();
item.HocPhi = double.Parse(sdr["HocPhi"].ToString());
item.Ngaybatdau = DateTime.Parse(sdr["Ngaybatdau"].ToString());
item.STT = int.Parse(sdr["STT"].ToString());
lst_KhoaHoc.Add(item);
}
sdr.Close();
conn.Close();
return(lst_KhoaHoc);
}
private void dgv_khoahoc_SelectionChanged(object sender, EventArgs e)
{
if (dgv_khoahoc.SelectedRows.Count > 0)
{
_KhoaHocDangChon = (KhoaHocDTO)dgv_khoahoc.SelectedRows[0].DataBoundItem;
}
else
{
_KhoaHocDangChon = null;
}
ThongTinChiTiet();
}
private void load_KhoaHoctheomakh()
{
if (txt_tim.Text == "")
{
load_KhoaHocVaChiTiet();
}
else
{
_KhoaHocDangChon = _LstKhoaHoc.Find(o => o.MaKH == txt_tim.Text);
if (_KhoaHocDangChon != null)
{
dgv_khoahoc.DataSource = null;
dgv_khoahoc.DataSource = _LstKhoaHoc.FindAll(o => o.MaKH == txt_tim.Text);
}
else
{
MessageBox.Show("Không tìm thấy", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public List <KhoaHocDTO> load_ChiTietKhoaHocDAO()
{
List <KhoaHocDTO> lst_KhoaHoc = new List <KhoaHocDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string query = "Select * From ChiTietKhoaHoc Where STT=1";
SqlDataReader sdr = DataProvider.ThucHienTruyVan(query, conn);
while (sdr.Read())
{
KhoaHocDTO item = new KhoaHocDTO();
item.MaKH = sdr["MaKH"].ToString();
item.MaPhong = sdr["MaPhong"].ToString();
item.MaCa = sdr["MaCa"].ToString();
item.Ngaybatdau = DateTime.Parse(sdr["Ngaybatdau"].ToString());
item.STT = int.Parse(sdr["STT"].ToString());
lst_KhoaHoc.Add(item);
}
sdr.Close();
conn.Close();
return(lst_KhoaHoc);
}
public List <KhoaHocDTO> load_KhoaHocDAO()
{
List <KhoaHocDTO> lst_KhoaHoc = new List <KhoaHocDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string query = "Select * From KhoaHoc Where STT=1";
SqlDataReader sdr = DataProvider.ThucHienTruyVan(query, conn);
while (sdr.Read())
{
KhoaHocDTO item = new KhoaHocDTO();
item.MaKH = sdr["MaKH"].ToString();
item.TenKH = sdr["TenKH"].ToString();
item.MoTa = sdr["MoTa"].ToString();
item.HocPhi = double.Parse(sdr["HocPhi"].ToString());
item.STT = int.Parse(sdr["STT"].ToString());
lst_KhoaHoc.Add(item);
}
sdr.Close();
conn.Close();
return(lst_KhoaHoc);
}