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