public LoiModel(CMT cmt, GIAYKHAISINH giaykhaisinh, BANGTOTNGHIEP bangtotnghiep, HOCBA hocba)
{
this.cmt = cmt;
this.giaykhaisinh = giaykhaisinh;
this.bangtotnghiep = bangtotnghiep;
this.hocba = hocba;
}
public JsonResult ChinhSuaLoiDanToc(List <string> listKey)
{
LoiModel chitietLoi = new LoiModel();
int idLoi = Int32.Parse(listKey[0]);
string DanTocGKS = listKey[1];
string DanTocBTN = listKey[2];
string DanTocHB = listKey[3];
TABLE_LOI tableLoi = db.TABLE_LOI.Find(idLoi);
string typeLoi = tableLoi.TypeLOI;
if (DanTocGKS != null)
{
GIAYKHAISINH gks = db.GIAYKHAISINHs.Find(tableLoi.id_GKS);
gks.DanToc = DanTocGKS;
db.Entry(gks).State = System.Data.Entity.EntityState.Modified;
}
if (DanTocBTN != null)
{
BANGTOTNGHIEP btn = db.BANGTOTNGHIEPs.Find(tableLoi.id_BTN);
btn.DanToc = DanTocBTN;
db.Entry(btn).State = System.Data.Entity.EntityState.Modified;
}
if (DanTocHB != null)
{
HOCBA hocba = db.HOCBAs.Find(tableLoi.id_HB);
hocba.DanToc = DanTocHB;
db.Entry(hocba).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult DetailHB()
{
ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;
if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
{
int id_hs = (int)Session["id_hsDetail"];
HOCSINH hocsinh = db.HOCSINHs.Find(id_hs);
if (hocsinh.id_HB > 0)
{
ViewBag.ThongbaoHB = "OK";
HOCBA hb = db.HOCBAs.Find(hocsinh.id_HB);
List <NAMHOC> listNamHoc = db.NAMHOCs.Where(n => n.id_HB == hocsinh.id_HB).ToList();
ViewBag.listNamHoc = listNamHoc; //load nam hoc
List <DiemKyHoc> listDiem = new List <DiemKyHoc>();
if (listNamHoc.Count > 0)
{
foreach (var item in listNamHoc)
{
List <KIHOC> listKH = db.KIHOCs.Where(n => n.id_NAMHOC == item.id).ToList();
if (listKH.Count > 0)
{
DiemKyHoc a = new DiemKyHoc(item, listKH);
listDiem.Add(a);
}
}
}
ViewBag.listKiHoc = listDiem;
return(View(hb));
}
ViewBag.ThongbaoHB = "NO";
return(View());
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult SuaHB(int id)
{
ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;
if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
{
HOCBA hb = db.HOCBAs.Find(id);
HOCSINH hs = db.HOCSINHs.SingleOrDefault(n => n.id_HB == id);
ViewBag.id_hs = hs.id;
Session["chuyenTab"] = 5;
return(View(hb));
}
return(RedirectToAction("Index", "Home"));
}
public JsonResult ChinhSuaLoiNgaySinh(List <string> listKey)
{
try
{
LoiModel chitietLoi = new LoiModel();
int idLoi = Int32.Parse(listKey[0]);
TABLE_LOI tableLoi = db.TABLE_LOI.Find(idLoi);
string typeLoi = tableLoi.TypeLOI;
if (listKey[1] != null)
{
DateTime NgaySinhCMT = DateTime.Parse(listKey[1]);
CMT cmt = db.CMTs.Find(tableLoi.So_CMT);
cmt.NgaySinh = NgaySinhCMT;
db.Entry(cmt).State = EntityState.Modified;
}
if (listKey[2] != null)
{
DateTime NgaySinhGKS = DateTime.Parse(listKey[2]);
GIAYKHAISINH gks = db.GIAYKHAISINHs.Find(tableLoi.id_GKS);
gks.NgaySinh = NgaySinhGKS;
db.Entry(gks).State = EntityState.Modified;
}
if (listKey[3] != null)
{
DateTime NgaySinhBTN = DateTime.Parse(listKey[3]);
BANGTOTNGHIEP btn = db.BANGTOTNGHIEPs.Find(tableLoi.id_BTN);
btn.NgaySinh = NgaySinhBTN;
db.Entry(btn).State = EntityState.Modified;
}
if (listKey[4] != null)
{
DateTime NgaySinhHB = DateTime.Parse(listKey[4]);
HOCBA hocba = db.HOCBAs.Find(tableLoi.id_HB);
hocba.NgaySinh = NgaySinhHB;
db.Entry(hocba).State = EntityState.Modified;
}
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(e, JsonRequestBehavior.AllowGet));
}
}
public JsonResult ChinhSuaLoiHoTen(List <string> listKey)
{
LoiModel chitietLoi = new LoiModel();
int idLoi = Int32.Parse(listKey[0]);
string TenHS = listKey[1];
string TenCMT = listKey[2];
string TenGKS = listKey[3];
string TenBTN = listKey[4];
string TenHB = listKey[5];
TABLE_LOI tableLoi = db.TABLE_LOI.Find(idLoi);
string typeLoi = tableLoi.TypeLOI;
if (TenHS != null)
{
HOCSINH hocsinh = db.HOCSINHs.Find(tableLoi.id_HS);
hocsinh.TenHS = TenHS;
db.Entry(hocsinh).State = System.Data.Entity.EntityState.Modified;
}
if (TenCMT != null)
{
CMT cmt = db.CMTs.Find(tableLoi.So_CMT);
cmt.HoTen = TenCMT;
db.Entry(cmt).State = System.Data.Entity.EntityState.Modified;
}
if (TenGKS != null)
{
GIAYKHAISINH gks = db.GIAYKHAISINHs.Find(tableLoi.id_GKS);
gks.HoTen = TenGKS;
db.Entry(gks).State = System.Data.Entity.EntityState.Modified;
}
if (TenBTN != null)
{
BANGTOTNGHIEP btn = db.BANGTOTNGHIEPs.Find(tableLoi.id_BTN);
btn.HoTen = TenBTN;
db.Entry(btn).State = System.Data.Entity.EntityState.Modified;
}
if (TenHB != null)
{
HOCBA hocba = db.HOCBAs.Find(tableLoi.id_HB);
hocba.HoTen = TenHB;
db.Entry(hocba).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult SuaHB(HOCBA hb)
{
ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;
if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
{
if (ModelState.IsValid)
{
HOCSINH hs = db.HOCSINHs.SingleOrDefault(n => n.id_HB == hb.id);
db.Entry(hb).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
Session["chuyenTab"] = 5;
return(RedirectToAction("DetailChung/" + hs.id, "HocSinh"));
}
return(View(hb));
}
return(RedirectToAction("Index", "Home"));
}
public JsonResult XulyHocba(HOCBA hocba)
{
if (ModelState.IsValid)
{
db.HOCBAs.Add(hocba);
db.SaveChanges();
//Tự động add thêm thông tin hocba vào bảng HOCSINH
int id_hs = (int)Session["id_hs"];
HOCSINH hs = db.HOCSINHs.SingleOrDefault(n => n.id == id_hs);
HOCBA NewH = db.HOCBAs.ToList().Last();
hs.id_HB = NewH.id;
//Lưu lại dữ liệu bảng Học Sinh
db.Entry(hs).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(Json(hocba, JsonRequestBehavior.AllowGet));
}
return(Json(hocba, JsonRequestBehavior.AllowGet));
}
public string ReturnHoten(int id_loi)
{
TABLE_LOI tb_loi = db.TABLE_LOI.Find(id_loi);
if (tb_loi.id_HS > 0)
{
HOCSINH hs = db.HOCSINHs.Find(tb_loi.id_HS);
return(hs.TenHS);
}
else
{
if (tb_loi.So_CMT != null)
{
CMT cmt = db.CMTs.Find(tb_loi.So_CMT);
return(cmt.HoTen);
}
else
{
if (tb_loi.id_GKS > 0)
{
GIAYKHAISINH gks = db.GIAYKHAISINHs.Find(tb_loi.id_GKS);
return(gks.HoTen);
}
else
{
if (tb_loi.id_BTN > 0)
{
BANGTOTNGHIEP btn = db.BANGTOTNGHIEPs.Find(tb_loi.id_BTN);
return(btn.HoTen);
}
else
{
if (tb_loi.id_HB > 0)
{
HOCBA hb = db.HOCBAs.Find(tb_loi.id_HB);
return(hb.HoTen);
}
}
}
}
}
return(null);
}
public JsonResult Themmoi(HOCBA hocba)
{
if (ModelState.IsValid)
{
if (Session["file"] != null)
{
hocba.fileHB = (string)Session["file"];
}
db.HOCBAs.Add(hocba);
db.SaveChanges();
//Cập nhật lại bảng học sinh
int id_HS = (int)Session["id_HS"];
HOCSINH hocsinh = db.HOCSINHs.Find(id_HS);
hocsinh.id_HB = hocba.id;
db.Entry(hocsinh).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
//dùng để khi tiến hành thêm mới năm học
Session["id_hocba"] = hocba.id;
return(Json("Thêm mới thành công", JsonRequestBehavior.AllowGet));
}
return(Json("Thêm mới thất bại", JsonRequestBehavior.AllowGet));
}
// GET: GiayTo
public ActionResult Giaynhaphoc(int id)
{
ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;
if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyHoSo" || quyenNguoiDung.Quyen.Ten == "Admin"))
{
Session["chuyenTab"] = null;
HOCSINH hs = db.HOCSINHs.Find(id);
ViewBag.id_hsss = hs.id;
ViewBag.sdt = hs.sdt;
CMT cmt = db.CMTs.Find(hs.SoCMT);
HOCBA hb = db.HOCBAs.Find(hs.id_HB);
if (cmt != null)
{
ViewBag.tenhs = dich.ReplaceUnicode(cmt.HoTen);
ViewBag.noisinh = dich.ReplaceUnicode(cmt.QueQuan);
ViewBag.noithuongtru = dich.ReplaceUnicode(cmt.NoiThuongTru);
}
if (hb != null)
{
ViewBag.noisonghientai = dich.ReplaceUnicode(hb.NoiSongHienTai);
ViewBag.gioiTinh = hb.GioiTinh;
ViewBag.ngaySinh = hb.NgaySinh;
}
// dua ra danh sach thanh vien gia dinh
List <HoKhau> listHK = db.HoKhaus.Where(n => n.id_hs == id).ToList();
ViewBag.dstv = listHK;
//giay nhap hoc
GiayNhapHoc giaynhaphoc = db.GiayNhapHocs.SingleOrDefault(n => n.id_hs == hs.id);
if (giaynhaphoc != null)
{
View(giaynhaphoc);
}
return(View());
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult XoaHocSinh(int id)
{
//xóa dữ liệu trong bảng học sinh
HOCSINH hocsinh = db.HOCSINHs.Find(id);
db.HOCSINHs.Remove(hocsinh);
TABLE_LOI tble = db.TABLE_LOI.SingleOrDefault(n => n.id_HS == id);
if (tble != null)
{
db.TABLE_LOI.Remove(tble);
}
//xóa các dữ liệu liên quan
string socmt = hocsinh.SoCMT;
if (socmt != null)
{
CMT cmt = db.CMTs.Find(socmt);
TABLE_LOI tble1 = db.TABLE_LOI.SingleOrDefault(n => n.So_CMT == socmt);
if (tble1 != null)
{
db.TABLE_LOI.Remove(tble1);
}
db.CMTs.Remove(cmt);
}
int id_gks = hocsinh.id_GKS == null ? 0 :(int)hocsinh.id_GKS;
if (id_gks != 0)
{
GIAYKHAISINH gks = db.GIAYKHAISINHs.Find(id_gks);
TABLE_LOI tble2 = db.TABLE_LOI.SingleOrDefault(n => n.id_GKS == id_gks);
if (tble2 != null)
{
db.TABLE_LOI.Remove(tble2);
}
db.GIAYKHAISINHs.Remove(gks);
}
int id_btn = hocsinh.id_BTN == null ? 0 : (int)hocsinh.id_BTN;
if (id_btn != 0)
{
BANGTOTNGHIEP btn = db.BANGTOTNGHIEPs.Find(id_btn);
TABLE_LOI tble3 = db.TABLE_LOI.SingleOrDefault(n => n.id_BTN == id_btn);
if (tble3 != null)
{
db.TABLE_LOI.Remove(tble3);
}
db.BANGTOTNGHIEPs.Remove(btn);
}
int id_hb = hocsinh.id_HB == null ? 0 : (int)hocsinh.id_HB;
if (id_hb != 0)
{
HOCBA hocba = db.HOCBAs.Find(id_hb);
TABLE_LOI tble4 = db.TABLE_LOI.SingleOrDefault(n => n.id_HB == id_hb);
if (tble4 != null)
{
db.TABLE_LOI.Remove(tble4);
}
db.HOCBAs.Remove(hocba);
}
string socmtNGH = hocsinh.id_NgGiamHo;
if (socmtNGH != null)
{
NGUOIGIAMHO nggiamho = db.NGUOIGIAMHOes.Find(socmtNGH);
db.NGUOIGIAMHOes.Remove(nggiamho);
}
db.SaveChanges();
return(RedirectToAction("Index", "HocSinh"));
}
