private void lvCTDT_SelectedIndexChanged(object sender, EventArgs e) { if (lvCTDT.SelectedItems.Count > 0) { ListViewItem lv = lvCTDT.SelectedItems[0]; string maKhoi = lv.SubItems[1].Text; string MaMon = lv.SubItems[2].Text; string heSo = lv.SubItems[3].Text; tbMaKL_CTDT.Text = maKhoi; tbMaMH_CTDT.Text = MaMon; tbHeSoCTDT.Text = heSo; } KhoiLopBLL lopBll = new KhoiLopBLL(); KhoiLop lop = lopBll.GetKhoiLop(tbMaKL_CTDT.Text); tbTenKhoi_CTDT.Text = lop.TenKhoiLop; MonHocBLL mh = new MonHocBLL(); MonHoc mon = mh.GetMonHoc(tbMaMH_CTDT.Text); tbTenMH_CTDT.Text = mon.TenMonHoc; }
/// <summary> /// add KhoiLop /// </summary> /// <param name="entity">KhoiLop</param> public void Insert(KhoiLop entity) { if (!_KhoiLopRepository.Table.Any(m => m.TenKhoi == entity.TenKhoi)) { _KhoiLopRepository.Insert(entity); } }
public List <KhoiLop> GetAllKhoilop(string namHoc) { OpenConnection(); List <KhoiLop> listKhoiLop = new List <KhoiLop>(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.Text; com.CommandText = "Select * from KHOILOP where MaNamHoc=@namhoc"; com.Parameters.Add("@namhoc", SqlDbType.VarChar).Value = namHoc; com.Connection = conn; SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { string maKL = reader.GetString(0); string tenKL = reader.GetString(1); string ban = reader.GetString(2); string manamhoc = reader.GetString(3); KhoiLop khoilop = new KhoiLop(maKL, tenKL, ban, manamhoc); listKhoiLop.Add(khoilop); } reader.Close(); CloseConnection(); return(listKhoiLop); }
public List <KhoiLop> GetAllKhoilop() { OpenConnection(); List <KhoiLop> listKhoiLop = new List <KhoiLop>(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.Text; com.CommandText = "Select * from KHOILOP"; com.Connection = conn; SqlDataReader reader = com.ExecuteReader(); while (reader.Read()) { string maKL = reader.GetString(0); string tenKL = reader.GetString(1); string ban = reader.GetString(2); string manamhoc = reader.GetString(1); KhoiLop khoilop = new KhoiLop(maKL, tenKL, ban, manamhoc); listKhoiLop.Add(khoilop); } reader.Close(); CloseConnection(); return(listKhoiLop); }
public KhoiLop GetKhoiLop(string maKhoiLop) { OpenConnection(); SqlCommand com = new SqlCommand(); com.CommandType = CommandType.Text; com.CommandText = "Select * from KhoiLOP where MAkhoilop=@ma"; com.Parameters.Add("@ma", SqlDbType.VarChar).Value = maKhoiLop; com.Connection = conn; SqlDataReader reader = com.ExecuteReader(); KhoiLop lop = null; while (reader.Read()) { string ma = reader.GetString(0); String ten = reader.GetString(1); string ban = reader.GetString(2); string manamhoc = reader.GetString(3); lop = new KhoiLop(ma, ten, ban, manamhoc); } reader.Close(); CloseConnection(); return(lop); }
public void HienThiLop() { int khoi = int.Parse(drKhoi.Text); KhoiLop kl = new KhoiLop(); kl.MaKhoi = khoi; gridDSHocSinh.DataSource = gvBLL.LayLopHocTheoKhoi(kl); gridDSHocSinh.DataBind(); }
public void HienThiLop() { int khoi = int.Parse(DrKhoiLop.Text); KhoiLop kl = new KhoiLop(); GiaoVien gv = new GiaoVien(); kl.MaKhoi = khoi; int magv = int.Parse(Session["MaGV"].ToString()); gv.MaGV = magv; GridDSLop.DataSource = gvBLL.LayLopHocTheoKhoi_GV(kl,gv); GridDSLop.DataBind(); }
public void HienThiLop() { int khoi = int.Parse(DrKhoiLop.Text); KhoiLop kl = new KhoiLop(); GiaoVien gv = new GiaoVien(); kl.MaKhoi = khoi; int magv = int.Parse(Session["MaGV"].ToString()); gv.MaGV = magv; GridDSLop.DataSource = gvBLL.LayLopHocTheoKhoi_GV(kl, gv); GridDSLop.DataBind(); }
private void lvDSKL_NH_SelectedIndexChanged(object sender, EventArgs e) { if (lvDSKL_NH.SelectedItems.Count != 0) { string maKhoiLop = lvDSKL_NH.SelectedItems[0].SubItems[1].Text; KhoiLop khoiLop = khoilopbll.GetKhoiLop(maKhoiLop); tbTenKL_DSKL.Text = khoiLop.TenKhoiLop; tbMaKL_DSKL.Text = khoiLop.MaKhoiLop; tbBan_DSKL.Text = khoiLop.Ban; tbNH_DSKL.Text = khoiLop.MaNamHoc; int countKhoiLop = lopBLL.CountSoLuongLopTheoKhoi(khoiLop.MaKhoiLop); tbSoLuongLop_DSKL.Text = countKhoiLop.ToString(); } }
/// <summary> /// update KhoiLop /// </summary> /// <param name="entity">KhoiLop</param> public void Update(KhoiLop entity) { _KhoiLopRepository.Update(entity); }
public DataTable LayLopHocTheoKhoi_GV(KhoiLop kl, GiaoVien gv){ return kn.GetLopTheoKhoi_GV(kl.MaKhoi,gv.MaGV); }
public PairKhoiLop(KhoiLop khoiLop) { value = khoiLop.MaKhoi; text = khoiLop.TenKhoi; }
public DataTable LayLopHocTheoKhoi(KhoiLop kl) { return(kn.GetLopTheoKhoi(kl.MaKhoi)); }
public DataTable LayLopHocTheoKhoi_GV(KhoiLop kl, GiaoVien gv) { return(kn.GetLopTheoKhoi_GV(kl.MaKhoi, gv.MaGV)); }
public DataTable LayLopHocTheoKhoi(KhoiLop kl) { return kn.GetLopTheoKhoi(kl.MaKhoi); }
/// <summary> /// set KhoiLop to unactive /// </summary> /// <param name="entity">KhoiLop</param> public void FakeDelete(KhoiLop entity) { _KhoiLopRepository.FakeDelete(entity); }
/// <summary> /// delete KhoiLop /// </summary> /// <param name="entity">KhoiLop</param> public void Delete(KhoiLop entity) { _KhoiLopRepository.Delete(entity); }