public void AddBienLai(BienLai bl)
{
QLTTDayThem db = new QLTTDayThem();
db.BienLais.Add(bl);
db.SaveChanges();
}
public List <giaovien> GetListGiaoVien(string hoten)
{
QLTTDayThem db = new QLTTDayThem();
List <giaovien> gv = new List <giaovien>();
var l = from p in db.GiaoViens
where p.HoTen.Contains(hoten)
select new { p.MaGV, p.HoTen, p.NamSinh, p.GioiTinh, p.DiaChi, p.SDT, p.ChuyenMon, p.TrinhDo };
foreach (var i in l)
{
gv.Add(new giaovien
{
MaGV = i.MaGV,
HoTen = i.HoTen,
NamSinh = Convert.ToDateTime(i.NamSinh),
GioiTinh = Convert.ToBoolean(i.GioiTinh),
DiaChi = i.DiaChi,
SDT = i.SDT,
TrinhDo = i.TrinhDo,
ChuyenMon = i.ChuyenMon
});
}
return(gv);
}
public DataTable GetBienLai(string mahv, int hp)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[]
{
new DataColumn("TenLop", typeof(string)),
new DataColumn("HoTen", typeof(string)),
new DataColumn("HocPhi", typeof(int)),
});
QLTTDayThem db = new QLTTDayThem();
BienLai bl = db.BienLais.Find(mahv);
bl.HocPhi = hp;
db.SaveChanges();
// get dữ liệu vào datatable
DataRow dr = dt.NewRow();
dr["TenLop"] = bl.LopHoc.TenLop;
dr["HoTen"] = bl.HocVien.HoTen;
dr["HocPhi"] = Convert.ToInt32(bl.HocPhi);
dt.Rows.Add(dr);
return(dt);
}
public string XulyMaLH()
{
QLTTDayThem db = new QLTTDayThem();
// tìm mh cuối cùng của danh sách
LopHoc lh = db.LopHocs.OrderByDescending(x => x.MaLH).Take(1).Single();
return(LopHoc.TangMaLH(lh.MaLH));
}
public void DoiMatKhau(string tk, string mkmoi)
{
QLTTDayThem db = new QLTTDayThem();
Adminn a = db.Adminns.Find(tk);
a.MatKhau = mkmoi;
db.SaveChanges();
}
// tăng MaHV lên 1 đơn vị
public string XulyMaGV()
{
QLTTDayThem db = new QLTTDayThem();
// tìm gv cuối cùng của danh sách
GiaoVien gv = db.GiaoViens.OrderByDescending(x => x.MaGV).Take(1).Single();
return(GiaoVien.TangMaGV(gv.MaGV));
}
// tăng MaHV lên 1 đơn vị
public string XulyMaHV()
{
QLTTDayThem db = new QLTTDayThem();
// tìm hv cuối cùng của danh sách
HocVien hv = db.HocViens.OrderByDescending(x => x.MaHV).Take(1).Single();
return(HocVien.TangMaHV(hv.MaHV));
}
public string XulyMaMH()
{
QLTTDayThem db = new QLTTDayThem();
// tìm mh cuối cùng của danh sách
MonHoc mh = db.MonHocs.OrderByDescending(x => x.MaMH).Take(1).Single();
return(MonHoc.TangMaMH(mh.MaMH));
}
public void ChangeState(string mahv)
{
QLTTDayThem db = new QLTTDayThem();
BienLai bl = db.BienLais.Find(mahv);
bl.TinhTrang = "Đã nộp";
db.SaveChanges();
}
public void XoaTK(List <string> tk)
{
QLTTDayThem db = new QLTTDayThem();
for (int i = 0; i < tk.Count; i++)
{
Adminn ad = db.Adminns.Find(tk[i]);
db.Adminns.Remove(ad);
db.SaveChanges();
}
}
public void XoaMonHoc(List <string> mamh)
{
QLTTDayThem db = new QLTTDayThem();
for (int i = 0; i < mamh.Count; i++)
{
MonHoc mh = db.MonHocs.Find(mamh[i]);
db.MonHocs.Remove(mh);
db.SaveChanges();
}
}
public void XoaLop(string malop)
{
QLTTDayThem db = new QLTTDayThem();
// xóa all học viên thuộc lớp
BLL_HocVien.Instance.XoaAllHVbyLop(malop);
LopHoc lh = db.LopHocs.Find(malop);
db.SaveChanges();
}
public void XoaGV(List <string> magv)
{
QLTTDayThem db = new QLTTDayThem();
for (int i = 0; i < magv.Count; i++)
{
GiaoVien gv = db.GiaoViens.Find(magv[i]);
db.GiaoViens.Remove(gv);
db.SaveChanges();
}
}
public void XoaListHV(List <string> mahv)
{
QLTTDayThem db = new QLTTDayThem();
for (int i = 0; i < mahv.Count; i++)
{
HocVien hv = db.HocViens.Find(mahv[i]);
LopHoc lh = db.LopHocs.Find(hv.MaLH);
lh.SiSo = lh.GetSiSo() - 1;
db.HocViens.Remove(hv);
db.SaveChanges();
}
}
public bool CheckTK(string tk)
{
QLTTDayThem db = new QLTTDayThem();
Adminn ad = db.Adminns.Find(tk);
if (ad != null)
{
return(true);
}
else
{
return(false);
}
}
public List <hocvien> GetListHocVien(string malop, string hoten)
{
QLTTDayThem db = new QLTTDayThem();
List <hocvien> h = new List <hocvien>();
if (malop == "0")
{
var l = from p in db.HocViens
select new { p.MaHV, p.LopHoc.TenLop, p.LopHoc.SiSo, p.HoTen, p.NamSinh, p.GioiTinh, p.DiaChi, p.SDT, p.TinhTrang };
foreach (var i in l)
{
h.Add(new hocvien
{
MaHV = i.MaHV,
TenLop = i.TenLop,
SiSo = Convert.ToInt32(i.SiSo),
HoTen = i.HoTen,
NamSinh = Convert.ToDateTime(i.NamSinh),
GioiTinh = Convert.ToBoolean(i.GioiTinh),
DiaChi = i.DiaChi,
SDT = i.SDT,
TinhTrang = i.TinhTrang
});
}
}
///
else
{
var l = from p in db.HocViens
where p.MaLH == malop && p.HoTen.Contains(hoten)
select new { p.MaHV, p.LopHoc.TenLop, p.LopHoc.SiSo, p.HoTen, p.NamSinh, p.GioiTinh, p.DiaChi, p.SDT, p.TinhTrang };
foreach (var i in l)
{
h.Add(new hocvien
{
MaHV = i.MaHV,
TenLop = i.TenLop,
SiSo = Convert.ToInt32(i.SiSo),
HoTen = i.HoTen,
NamSinh = Convert.ToDateTime(i.NamSinh),
GioiTinh = Convert.ToBoolean(i.GioiTinh),
DiaChi = i.DiaChi,
SDT = i.SDT,
TinhTrang = i.TinhTrang
});
}
}
return(h);
}
public void ThemLop(string tenlop)
{
QLTTDayThem db = new QLTTDayThem();
LopHoc lh = db.LopHocs.OrderByDescending(x => x.MaLH).Take(1).Single();
LopHoc l = new LopHoc
{
MaLH = LopHoc.TangMaLH(lh.MaLH),
TenLop = tenlop,
SiSo = 0
};
db.LopHocs.Add(l);
db.SaveChanges();
}
public List <CbbItem> GetCbbLopHoc()
{
QLTTDayThem db = new QLTTDayThem();
List <CbbItem> s = new List <CbbItem>();
var a = from p in db.LopHocs select new { p.MaLH, p.TenLop };
foreach (var i in a)
{
s.Add(new CbbItem {
value = i.MaLH, text = i.TenLop
});
}
return(s);
}
public Adminn CheckTK(string tk, string pw)
{
QLTTDayThem db = new QLTTDayThem();
Adminn a = db.Adminns.Find(tk);
if (a != null && a.MatKhau == pw)
{
return(a);
}
else
{
return(null);
}
}
public List <CbbItem> GetCbbGiaoVien(string monhoc)
{
QLTTDayThem db = new QLTTDayThem();
List <CbbItem> s = new List <CbbItem>();
var a = from p in db.GiaoViens where p.ChuyenMon.Contains(monhoc) select new { p.MaGV, p.HoTen };
foreach (var i in a)
{
s.Add(new CbbItem {
value = i.MaGV, text = i.HoTen
});
}
return(s);
}
public List <Adminn> GetListAdmin(string cv)
{
QLTTDayThem db = new QLTTDayThem();
if (cv == "All")
{
var l = from p in db.Adminns select p;
return(l.ToList());
}
else
{
var l = from p in db.Adminns where p.ChucVu == cv select p;
return(l.ToList());
}
}
public void ExecuteDB(Adminn a)
{
QLTTDayThem db = new QLTTDayThem();
Adminn ad = db.Adminns.Find(a.TaiKhoan);
if (ad != null)
{
ad.MatKhau = a.MatKhau;
ad.ChucVu = a.ChucVu;
db.SaveChanges();
}
else
{
db.Adminns.Add(a);
db.SaveChanges();
}
}
public void ExecuteDB(HocVien h)
{
QLTTDayThem db = new QLTTDayThem();
HocVien hv = db.HocViens.Find(h.MaHV);
if (hv != null)
{
string malh = hv.MaLH;
// set lại dữ liệu
hv.HoTen = h.HoTen;
hv.MaLH = h.MaLH;
hv.NamSinh = h.NamSinh;
hv.GioiTinh = h.GioiTinh;
hv.DiaChi = h.DiaChi;
hv.SDT = h.SDT;
hv.TinhTrang = h.TinhTrang;
db.SaveChanges();
// set lại sĩ số
if (malh != h.MaLH)
{
LopHoc lh1 = db.LopHocs.Find(h.MaLH);
lh1.SiSo = lh1.GetSiSo();
LopHoc lh2 = db.LopHocs.Find(malh);
lh2.SiSo = lh2.GetSiSo();
db.SaveChanges();
}
}
else
{
db.HocViens.Add(h);
LopHoc lh = db.LopHocs.Find(h.MaLH);
lh.SiSo = lh.GetSiSo();
db.SaveChanges();
// add biên lai
BienLai bl = new BienLai()
{
MaHV = h.MaHV,
MaLH = h.MaLH,
TinhTrang = "Chưa nộp",
HocPhi = 0
};
BLL_BienLai.Instance.AddBienLai(bl);
}
}
public List <bienlai> GetListBienLai(string malop, string tinhtrang, string hoten)
{
QLTTDayThem db = new QLTTDayThem();
List <bienlai> h = new List <bienlai>();
var l = from p in db.BienLais
where p.MaLH == malop && p.TinhTrang == tinhtrang && p.HocVien.HoTen.Contains(hoten)
select new { p.MaHV, p.LopHoc.TenLop, p.HocVien.HoTen, p.TinhTrang, p.HocPhi };
foreach (var i in l)
{
h.Add(new bienlai
{
MaHV = i.MaHV,
TenLH = i.TenLop,
HoTen = i.HoTen,
TinhTrang = i.TinhTrang,
HocPhi = Convert.ToInt32(i.HocPhi)
});
}
return(h);
}
public void ExecuteDB(MonHoc mh)
{
QLTTDayThem db = new QLTTDayThem();
MonHoc m = db.MonHocs.Find(mh.MaMH);
if (m != null)
{
m.MaLH = mh.MaLH;
m.TenMon = mh.TenMon;
m.MaGV = mh.MaGV;
m.ThoiGianHoc = mh.ThoiGianHoc;
m.NgayBatDau = mh.NgayBatDau;
m.NgayKetThuc = mh.NgayKetThuc;
db.SaveChanges();
}
else
{
db.MonHocs.Add(mh);
db.SaveChanges();
}
}
public void ExecuteDB(GiaoVien g)
{
QLTTDayThem db = new QLTTDayThem();
GiaoVien gv = db.GiaoViens.Find(g.MaGV);
if (gv != null)
{
gv.HoTen = g.HoTen;
gv.NamSinh = g.NamSinh;
gv.GioiTinh = g.GioiTinh;
gv.DiaChi = g.DiaChi;
gv.TrinhDo = g.TrinhDo;
gv.ChuyenMon = g.ChuyenMon;
gv.SDT = g.SDT;
db.SaveChanges();
}
else
{
db.GiaoViens.Add(g);
db.SaveChanges();
}
}
public void XoaAllHVbyLop(string malop)
{
List <string> s = new List <string>();
QLTTDayThem db = new QLTTDayThem();
var l = from p in db.HocViens
where p.MaLH == malop
select p;
// get list MaHV
foreach (var i in l)
{
s.Add(i.MaHV);
}
// Xóa học viên
for (int i = 0; i < s.Count; i++)
{
HocVien hv = db.HocViens.Find(s[i]);
LopHoc lh = db.LopHocs.Find(hv.MaLH);
lh.SiSo = lh.GetSiSo() - 1;
db.HocViens.Remove(hv);
db.SaveChanges();
}
}
public LopHoc GetLHbyMaLH(string malh)
{
QLTTDayThem db = new QLTTDayThem();
return(db.LopHocs.Find(malh));
}
// Lấy danh sách lớp học phần
public List <lophocphan> GetListLHP(string malh, string mon)
{
List <lophocphan> l = new List <lophocphan>();
QLTTDayThem db = new QLTTDayThem();
// get all lop học
if (malh == "0")
{
var a = from p in db.MonHocs
where p.TenMon.Contains(mon)
select new
{
p.MaLH,
p.MaMH,
p.LopHoc.TenLop,
p.LopHoc.SiSo,
p.TenMon,
p.GiaoVien.HoTen,
p.ThoiGianHoc,
p.NgayBatDau,
p.NgayKetThuc
};
foreach (var i in a)
{
l.Add(new lophocphan
{
MaLH = i.MaLH,
MaMH = i.MaMH,
TenLop = i.TenLop,
SiSo = Convert.ToInt32(i.SiSo),
TenMon = i.TenMon,
HoTenGV = i.HoTen,
ThoiGianHoc = i.ThoiGianHoc,
NgayBatDau = Convert.ToDateTime(i.NgayBatDau),
NgayKetThuc = Convert.ToDateTime(i.NgayKetThuc)
});
}
}
////
else
{
var a = from p in db.MonHocs
where p.MaLH == malh && p.TenMon.Contains(mon)
select new
{
p.MaLH,
p.MaMH,
p.LopHoc.TenLop,
p.LopHoc.SiSo,
p.TenMon,
p.GiaoVien.HoTen,
p.ThoiGianHoc,
p.NgayBatDau,
p.NgayKetThuc
};
foreach (var i in a)
{
l.Add(new lophocphan
{
MaLH = i.MaLH,
MaMH = i.MaMH,
TenLop = i.TenLop,
SiSo = Convert.ToInt32(i.SiSo),
TenMon = i.TenMon,
HoTenGV = i.HoTen,
ThoiGianHoc = i.ThoiGianHoc,
NgayBatDau = Convert.ToDateTime(i.NgayBatDau),
NgayKetThuc = Convert.ToDateTime(i.NgayKetThuc)
});
}
}
return(l);
}
public GiaoVien GetGVbyMaGV(string magv)
{
QLTTDayThem db = new QLTTDayThem();
return(db.GiaoViens.Find(magv));
}
