public ActionResult Create([Bind(Include = "maHS,hoTenCha,hoTenMe,hoTen,soDTNha,ngaySinh,email,diaChi,gioiTinh,hinhAnh,maNgheNghiepMe,maNgheNghiepCha,maTonGiao,maDanToc")] Tbl_HocSinh tbl_HocSinh)
{
ViewBag.maDanToc = db.Tbl_DanToc.ToList();
ViewBag.maTonGiao = db.Tbl_TonGiao.ToList();
ViewBag.maNgheNghiepMe = db.Tbl_NgheNghiepMe.ToList();
ViewBag.maNgheNghiepCha = db.Tbl_NgheNghiepCha.ToList();
if (ModelState.IsValid)
{
if (tbl_HocSinh.ngaySinh == null)
{
tbl_HocSinh.maLoai = null;
}
else
{
if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 2 && GetTuoi(tbl_HocSinh.ngaySinh.Value) <= 3)
{
tbl_HocSinh.maLoai = "L01";
}
else if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 4 && GetTuoi(tbl_HocSinh.ngaySinh.Value) < 5)
{
tbl_HocSinh.maLoai = "L02";
}
else if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 5 && GetTuoi(tbl_HocSinh.ngaySinh.Value) <= 6)
{
tbl_HocSinh.maLoai = "L03";
}
}
db.Tbl_HocSinh.Add(tbl_HocSinh);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_HocSinh));
}
public ActionResult Edit([Bind(Include = "maHS,hoTenCha,hoTenMe,hoTen,soDTNha,ngaySinh,email,diaChi,gioiTinh,hinhAnh,maTonGiao,maDanToc,maNgheNghiepMe,maNgheNghiepCha")] Tbl_HocSinh tbl_HocSinh)
{
if (ModelState.IsValid)
{
if (tbl_HocSinh.ngaySinh == null)
{
tbl_HocSinh.maLoai = null;
}
else
{
if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 2 && GetTuoi(tbl_HocSinh.ngaySinh.Value) <= 3)
{
tbl_HocSinh.maLoai = "L01";
}
else if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 4 && GetTuoi(tbl_HocSinh.ngaySinh.Value) < 5)
{
tbl_HocSinh.maLoai = "L02";
}
else if (GetTuoi(tbl_HocSinh.ngaySinh.Value) >= 5 && GetTuoi(tbl_HocSinh.ngaySinh.Value) <= 6)
{
tbl_HocSinh.maLoai = "L03";
}
db.Entry(tbl_HocSinh).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(tbl_HocSinh));
}
// GET: HocSinh/Details/5
public ActionResult Details(int id)
{
Tbl_HocSinh tbl_HocSinh = db.Tbl_HocSinh.Find(id);
if (tbl_HocSinh == null)
{
return(HttpNotFound());
}
return(View(tbl_HocSinh));
}
public JsonResult Delete(int id)
{
var hs = db.Tbl_PhanLop.Where(x => x.maHS == id).FirstOrDefault();
if (hs == null)
{
Tbl_HocSinh Tbl_HocSinh = db.Tbl_HocSinh.Find(id);
db.Tbl_HocSinh.Remove(Tbl_HocSinh);
db.SaveChanges();
return(Json(new { status = 0 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = 1 }, JsonRequestBehavior.AllowGet));
}
}
// GET: HocSinh/Edit/5
public ActionResult Edit(int id)
{
ViewBag.maDanToc = db.Tbl_DanToc.ToList();
ViewBag.maTonGiao = db.Tbl_TonGiao.ToList();
ViewBag.maNgheNghiepMe = db.Tbl_NgheNghiepMe.ToList();
ViewBag.maNgheNghiepCha = db.Tbl_NgheNghiepCha.ToList();
Tbl_HocSinh tbl_HocSinh = db.Tbl_HocSinh.Find(id);
DateTime birth = Convert.ToDateTime(tbl_HocSinh.ngaySinh);
ViewBag.birth = birth.ToString("yyyy-MM-dd");
if (tbl_HocSinh == null)
{
return(HttpNotFound());
}
return(View(tbl_HocSinh));
}
