public ActionResult Create(Entity.Open_Subjects model) { var teacher = (Entity.ProfileTeacher)Session["Teacher"]; var id = teacher.Teacher_id; if (ModelState.IsValid) { var dal = new DAL.OpensubDAL(); var chk = dal.ChkSub(model); if (chk != null) { Response.Write("<script> alert('รหัสวิชานี้ถูกเปิดสอนเเล้ว')</script>"); } else { var result = dal.Create(model, id); if (result) { if (result) { Response.Write("<script> alert('เปิดวิชาเรียนสำเร็จ')</script>"); } } return(RedirectToAction("Subject", "RegisterSub")); } } return(View(model)); }
public Entity.Open_Subjects ChkSub(Entity.Open_Subjects model) { var Sub = new Entity.Open_Subjects(); using (var db = new Entity.Entities()) { Sub = db.Open_Subjects.Where(a => a.Sub_id == model.Sub_id).FirstOrDefault(); } return(Sub); }
public Entity.Open_Subjects Search(int id) { var sub = new Entity.Open_Subjects(); using (var db = new Entity.Entities()) { sub = db.Open_Subjects.Where(a => a.Sub_id == id).FirstOrDefault(); sub.ProfileTeacher = sub.ProfileTeacher; } return(sub); }
public List <Entity.Register_Subjects> SubGradList() { var model = new Entity.Open_Subjects(); var Sub = new List <Entity.Register_Subjects>(); using (var db = new Entity.Entities()) { Sub = db.Register_Subjects.ToList(); foreach (var s in Sub) { s.Open_Subjects = s.Open_Subjects; } } return(Sub); }
internal bool Create(Entity.Open_Subjects model, string id) { try { string tecger = id; using (var db = new Entity.Entities()) { model.Teacher_id = tecger; db.Entry(model).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }