public static int LoginFun(string account, string pwd) { StudentInfoManagementEntities se = new StudentInfoManagementEntities(); var modelID = se.StudentInfo.FirstOrDefault(m => m.StudentAlias == account); var AdminModelID = se.AdminInfo.FirstOrDefault(m => m.AdminName == account); //管理员mmm if (modelID != null && AdminModelID == null) { if (modelID.Password == pwd) { return(1); } else { return(0); } } else if (modelID == null && AdminModelID != null) { if (AdminModelID.Password == pwd) { return(2); } else { return(0); } } else { return(0); } }
public void Save() { using (StudentInfoManagementEntities se = new StudentInfoManagementEntities()) { var Student01 = new StudentInfo() { StudentID = this.Account, Password = this.Password }; se.StudentInfo.Add(Student01); se.SaveChanges(); } }
public ActionResult Delete(string id) { try { StudentInfoManagementEntities se = new StudentInfoManagementEntities(); var Student01 = se.StudentInfo.FirstOrDefault(m => m.StudentID == id); if (Student01 != null) { se.StudentInfo.Remove(Student01); se.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); } return(View()); }
public ActionResult Edit(string id, FormCollection collection) { try { if (ModelState.IsValid) { StudentInfoManagementEntities se = new StudentInfoManagementEntities(); var model = se.StudentInfo.FirstOrDefault(m => m.StudentID == id); string[] strArr = collection.AllKeys; TryUpdateModel(model, strArr); se.SaveChanges(); return(RedirectToAction("Index")); } } catch (Exception ex) { ModelState.AddModelError("", ex.Message); } return(View()); }
public static StudentInfo LogFunction(Vm001 model) { StudentInfoManagementEntities se = new StudentInfoManagementEntities(); return(se.StudentInfo.FirstOrDefault(m => m.StudentID == model.account && m.Password == model.pwd)); }
public static StudentInfo GetById(string id) { StudentInfoManagementEntities se = new StudentInfoManagementEntities(); return(se.StudentInfo.FirstOrDefault(m => m.StudentID == id)); }
public static IEnumerable <StudentInfo> GetAll() { StudentInfoManagementEntities se = new StudentInfoManagementEntities(); return(se.StudentInfo); }