public ActionResult AddSubject(Subject s) { var result = new ArrayList(); if (!checkTotalSubject()) { result.Add( new { value = -1, message = "Số lượng môn học đã đạt tối đa" }); return(Json(result, JsonRequestBehavior.AllowGet)); } using (var ctx = new QLHSEntities()) { ctx.Subjects.Add(s); ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddClass(Class c) { int t = int.Parse(c.ClassLevel.ToString()); var result = new ArrayList(); if (!CheckMaxClass(t)) { result.Add( new { value = -1, message = "Khối đã đạt số lượng tối đa" }); return(Json(result, JsonRequestBehavior.AllowGet)); } c.MaxTotal = 40; c.Total = 0; c.Flag = 1; using (var ctx = new QLHSEntities()) { ctx.Classes.Add(c); ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult Register(string fname, string fusername, string fpassword, string fcpassword, string femail) { using (QLHSEntities dt = new QLHSEntities()) { var u = dt.Users.Where(p => p.email == femail).FirstOrDefault(); if (u != null) { ViewBag.Message = "Email đã tồn tại trong hệ thống"; ViewBag.Register = 2; return(View()); } User us = new User(); us.FullName = fname; us.email = femail; us.username = fusername; us.password = StringUtils.MD5(fpassword); dt.Users.Add(us); dt.SaveChanges(); ViewBag.Message = "Tạo tài khoản mới thành công"; ViewBag.Register = 3; return(View()); } }
public ActionResult UpdateProfile(User user) { var result = new ArrayList(); try { var a = CurrentContext.GetCurUser(); var ctx = new QLHSEntities(); var u = ctx.Users.Where(p => p.username == a.username).FirstOrDefault(); u.FullName = user.FullName; u.address = user.address; u.birthday = user.birthday; u.gender = user.gender; u.phonenumber = user.phonenumber; u.email = user.email; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception) { result.Add( new { value = -1, message = "lỗi" }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateInfo(Student s) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var user = ctx.Students.Where(u => u.StudentID == s.StudentID).FirstOrDefault(); user.FullName = s.FullName; user.BirthDay = s.BirthDay; user.Gender = s.Gender; user.Address = s.Address; user.Class = s.Class; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } result.Add( new { value = 0 }); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult UpdateStudentPoint(Point p) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var pu = ctx.Points .Where(u => u.StudentID == p.StudentID && u.SubjectID == p.SubjectID && u.Semester == p.Semester) .FirstOrDefault(); if (pu == null) { var point = new Point(); point.StudentID = p.StudentID; point.SubjectID = p.SubjectID; point.Test15Minutes = p.Test15Minutes; point.Test45Minutes = p.Test45Minutes; point.TestSemester = p.TestSemester; point.Semester = p.Semester; ctx.Points.Add(point); ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } pu.Test15Minutes = p.Test15Minutes; pu.Test45Minutes = p.Test45Minutes; pu.TestSemester = p.TestSemester; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateInfoStudent(Student s) { var result = new ArrayList(); if (!checkAge(s.BirthDay.Value.Year)) { result.Add( new { value = -1, message = "Độ tuổi không thỏa quy định." }); return(Json(result, JsonRequestBehavior.AllowGet)); } if (!checkTotalClass(s.Class.Value, s.StudentID)) { result.Add( new { value = -1, message = "Lớp đã đạt sĩ số tối đa." }); return(Json(result, JsonRequestBehavior.AllowGet)); } using (var ctx = new QLHSEntities()) { var user = ctx.Students.Where(u => u.StudentID == s.StudentID).FirstOrDefault(); user.FullName = s.FullName; user.BirthDay = s.BirthDay; user.Gender = s.Gender; user.Address = s.Address; user.Class = s.Class; user.Email = s.Email; user.PhoneNumber = s.PhoneNumber; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeletePoint(string studentid, string subjectid) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var s = ctx.Points.Where(ss => ss.StudentID == studentid && ss.SubjectID == subjectid).FirstOrDefault(); s.Flag = -1; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteClass(Class c) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var classx = ctx.Classes.Where(cl => cl.ID == c.ID).FirstOrDefault(); classx.Flag = -1; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetProfile() { var result = new ArrayList(); try { var a = CurrentContext.GetCurUser(); var ctx = new QLHSEntities(); var u = ctx.Users.Where(p => p.username == a.username).FirstOrDefault(); ctx.SaveChanges(); return(Json(u, JsonRequestBehavior.AllowGet)); } catch (Exception) { throw; } }
public ActionResult UpdateProfile(string password, string npassword) { var result = new ArrayList(); try { string EncryptOldPassword = StringUtils.MD5(npassword); string EncryptNewPassword = StringUtils.MD5(npassword); var a = CurrentContext.GetCurUser(); var ctx = new QLHSEntities(); var u = ctx.Users.Where(p => p.username == a.username && p.password == EncryptOldPassword).FirstOrDefault(); if (u == null) { result.Add( new { value = -1, message = "Mật khẩu cũ chưa đúng" }); return(Json(result, JsonRequestBehavior.AllowGet)); } u.password = EncryptNewPassword; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception e) { result.Add( new { value = -1, message = "Lỗi " + e.ToString() }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
//[HttpPost] public ActionResult DeleteStudent(string id) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var student = ctx.Students.Where(u => u.StudentID == id).FirstOrDefault(); student.State = -1; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult updateRuleScore(RuleStandardScore r) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var rx = ctx.RuleStandardScores .Where(rxs => r.ID == r.ID) .FirstOrDefault(); rx.StandardScore = r.StandardScore; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateRuleTotalBlock(ClassLevel c) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var rx = ctx.ClassLevels .Where(r => r.ID == c.ID) .FirstOrDefault(); rx.MaxTotal = c.MaxTotal; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateSubjectTotal(int maxtotal) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var rx = ctx.RuleSubjects .Where(r => 1 == 1) .FirstOrDefault(); rx.MaxTotal = maxtotal; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateSubject(Subject s) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var subject = ctx.Subjects.Where(sub => sub.SubjectID == s.SubjectID).FirstOrDefault(); subject.SubjectName = s.SubjectName; subject.Period = s.Period; subject.Type = s.Type; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult UpdateRuleAge(RuleAge ruleage) { var result = new ArrayList(); using (var ctx = new QLHSEntities()) { var rx = ctx.RuleAges .Where(r => r.ID == ruleage.ID) .FirstOrDefault(); rx.MaxAge = ruleage.MaxAge; rx.MinAge = ruleage.MinAge; ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddNewStudent(Student s) { var result = new ArrayList(); if (!checkAge(s.BirthDay.Value.Year)) { result.Add( new { value = -1, message = "Độ tuổi không thỏa quy định." }); return(Json(result, JsonRequestBehavior.AllowGet)); } if (!checkTotalClass(s.Class.Value, s.StudentID)) { result.Add( new { value = -1, message = "Lớp đã đạt sĩ số tối đa." }); return(Json(result, JsonRequestBehavior.AllowGet)); } using (var ctx = new QLHSEntities()) { ctx.Students.Add(s); ctx.SaveChanges(); result.Add( new { value = 1 }); return(Json(result, JsonRequestBehavior.AllowGet)); } }