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()));
}
