public bool DeleteTHISINH(int id) { try { THISINH u = dataContext.THISINHs.Single(p => p.ID == id); dataContext.THISINHs.Remove(u); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Debug.WriteLine("- Entity of type \"{0}\", in state \"{1}\" has the following validation errors: ", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return(false); } catch (Exception e) { Debug.WriteLine(e.Message); return(false); } return(true); }
public int AddTHISINH(THISINH THISINH) { try { dataContext.THISINHs.Add(THISINH); dataContext.SaveChanges(); } catch (DbUpdateException e) { Debug.WriteLine(e.ToString()); throw; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Debug.WriteLine("- Entity of type \"{0}\", in state \"{1}\" has the following validation errors: ", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } return(THISINH.ID); }
public bool UpdateActive(THISINH ts) { THISINH x = dataContext.THISINHs.Where(l => l.ID == ts.ID).SingleOrDefault(); if (x != null) { x.DaHoanThanh = true; dataContext.SaveChanges(); return(true); } return(false); }
public ActionResult Logout() { THISINH us = new THISINH(); var dao = new ThiSinhDAO(); ThiSinhLogin THISINH = (ThiSinhLogin)Session[Constants.THISINH_SESSION]; us.ID = THISINH.ThiSinhID; if (!dao.UpdateActive(us)) { ModelState.AddModelError("", "Không thể update dữ liệu"); } Session[Constants.THISINH_SESSION] = null; return(View("Index")); }
public bool UpdateTHISINH(THISINH THISINHDAO) { try { THISINH u = dataContext.THISINHs.Where(p => p.ID == THISINHDAO.ID).SingleOrDefault(); u.MaDuThi = THISINHDAO.MaDuThi; u.HoTen = THISINHDAO.HoTen; u.Password = THISINHDAO.Password; u.SDT = THISINHDAO.SDT; u.NgaySinh = THISINHDAO.NgaySinh; u.DiaChi = THISINHDAO.DiaChi; u.GioiTinh = THISINHDAO.GioiTinh; u.CMND = THISINHDAO.CMND; u.Email = THISINHDAO.Email; u.MaCaThi = THISINHDAO.MaCaThi; u.MaDeThi = THISINHDAO.MaDeThi; u.TrangThai = THISINHDAO.TrangThai; u.SoMay = THISINHDAO.SoMay; u.DaHoanThanh = THISINHDAO.DaHoanThanh; u.ThoiGian = THISINHDAO.ThoiGian; dataContext.SaveChanges(); return(true); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Debug.WriteLine("- Entity of type \"{0}\", in state \"{1}\" has the following validation errors: ", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Debug.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } return(false); } catch (Exception e) { Debug.WriteLine(e.Message); return(false); } }
public THISINH getIDByUserName(string user) { THISINH x = dataContext.THISINHs.SingleOrDefault(p => p.MaDuThi == user); return(x); }