public ActionResult Create(Entity.ProfileStudent model) { var user = (Entity.User)Session["user"]; var id = user.User_id; if (ModelState.IsValid) { var dal = new DAL.StudentDAL(); var chk = dal.Chkstud(model); if (chk != null) { Response.Write("<script> alert('รหัสนักศึกษานี้ถูกลงทะเบียนเเล้ว')</script>"); } else { var result = dal.Create(model, id); if (result) { Response.Write("<script> alert('ลงทะเบียนสำเร็จ')</script>"); } return(RedirectToAction("index", "User")); } return(View()); } return(View(model)); }
public ActionResult EditStud(Entity.ProfileStudent model, string id) { try { var dal = new DAL.StudentDAL(); var stud = dal.Search(id); stud.Stud_id = model.Stud_id; stud.Pre_Name = model.Pre_Name; stud.FristName = model.FristName; stud.LastName = model.LastName; stud.Group_id = model.Group_id; stud.Branch = model.Branch; stud.Faculty = model.Faculty; var result = dal.EditeStud(stud); if (result) { Response.Write("<script> alert('แก้ไข้ข้อมูลสำเร็จ')</script>"); } return(RedirectToAction("StudentList")); } catch (Exception) { Response.Write("<scrip> aler('ไม่สำเร็จ')</scrip>"); } return(View(model)); }
public Entity.ProfileStudent Chkstud(Entity.ProfileStudent model) { var stud = new Entity.ProfileStudent(); using (var db = new Entity.Entities()) { stud = db.ProfileStudent.Where(a => a.Stud_id == model.Stud_id).FirstOrDefault(); } return(stud); }
public Entity.ProfileStudent Searchstud(int id) { var stud = new Entity.ProfileStudent(); using (var db = new Entity.Entities()) { stud = db.ProfileStudent.Where(a => a.User_id == id).FirstOrDefault(); } return(stud); }
public Entity.ProfileStudent Search(string id) { var stud = new Entity.ProfileStudent(); using (var db = new Entity.Entities()) { stud = db.ProfileStudent.Where(a => a.Stud_id == id).FirstOrDefault(); stud.PreName = stud.PreName; stud.User = stud.User; } return(stud); }
internal bool Delete(Entity.ProfileStudent model) { try { using (var db = new Entity.Entities()) { db.Entry(model).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); return(true); } } catch (Exception) { return(false); } }
internal bool Create(Entity.ProfileStudent model, int id) { try { int user = id; using (var db = new Entity.Entities()) { model.User_id = user; db.Entry(model).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); } return(true); } catch (Exception) { return(false); } }