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