public JsonResult PostAdd(int UserId, string Name, bool Gender, string Phone, string Email, string ImgUrl, int ClassId, int TeacherUserId, string StudentId) { StudentManangeSystemContext db = new StudentManangeSystemContext(); using (var transition = db.Database.BeginTransaction()) { db.User.Add(new User() { Name = StudentId, Password = StudentId, IsEnable = true, PermissionCode = 3 }); if (db.SaveChanges() > 0) { var sUser = db.User.Where(u => u.Name == StudentId).FirstOrDefault(); var student = new StudentDetail() { UserId = UserId, Name = Name, Gender = Gender, Phone = Phone, Email = Email, ImgUrl = ImgUrl, ClassId = ClassId, TeacherUserId = TeacherUserId, StudentId = StudentId }; student.UserId = sUser.Id; db.StudentDetail.Add(student); if (db.SaveChanges() > 0) { transition.Commit(); return(new JsonResult(new { state = true })); } else { transition.Rollback(); return(new JsonResult(new { state = false })); } } else { transition.Rollback(); return(new JsonResult(new { state = false })); } } }
//[HttpPost] public JsonResult PostLogin(string UserName, string Password) { StudentManangeSystemContext db = new StudentManangeSystemContext(); bool state = db.User.Where(u => u.Name == UserName && u.Password == Password && u.PermissionCode == 3).Count() > 0; return(new JsonResult(new { state = state })); }
public JsonResult GetStudentsByTeacherUserId(int UserId) { StudentManangeSystemContext db = new StudentManangeSystemContext(); return(new JsonResult(db.StudentDetail.Where(s => s.TeacherUserId == UserId).ToList())); }
public JsonResult GetTeacherByUserId(int UserId) { StudentManangeSystemContext db = new StudentManangeSystemContext(); return(new JsonResult(db.TeacherDetail.Where(t => t.UserId == UserId).ToList())); }
public JsonResult GetAll() { StudentManangeSystemContext db = new StudentManangeSystemContext(); return(new JsonResult(db.TeacherDetail.ToList())); }