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 GetListClass()
{
using (var ctx = new QLHSEntities())
{
var pu = ctx.Classes
.Join(ctx.ClassLevels
, u => u.ClassLevel, uir => uir.ID, (u, uir) => new { u, uir })
.Where(m => 1 == 1)
.OrderBy(m => m.u.ClassLevel)
.Select(m => new
{
ID = m.u.ID,
ClassName = m.u.ClassName,
Total = m.u.Total,
MaxTotal = m.u.MaxTotal,
Level = m.uir.LevelName
}).ToList();
//var pu = ctx.Classes.GroupJoin(ctx.ClassLevels,
// c => c.ClassLevel,
// le => l.ID,
// (c, le) => new
// {
// ID = c.ID,
// ClassName = c.ClassName,
// LevelName=
// }).ToList();
return(Json(pu, 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 Login(string username, string password)
{
//string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLHS;Integrated Security=True";
//var con = new SqlConnection(path);
//var cmd = new SqlCommand("checklogin", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@fusername", username));
//cmd.Parameters.Add(new SqlParameter("@fpassword", password));
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = cmd;
//DataTable dt = new DataTable();
//da.Fill(dt);
//con.Close();
using (QLHSEntities dt = new QLHSEntities())
{
string EncryptPassword = StringUtils.MD5(password);
User us = dt.Users
.Where(p => p.username == username && p.password == EncryptPassword)
.FirstOrDefault();
if (us != null)
{
Session["isLogin"] = 1;
Session["user"] = us;
Session["IdUser"] = us.id;
Session["username"] = us.username;
Session["role"] = us.Role;
return(RedirectToAction("Index", "Home"));
}
}
ViewBag.Login = 2;
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 GetListStudent()
{
using (var ctx = new QLHSEntities())
{
var list = ctx.Students
.Join(ctx.Classes
, u => u.Class, uir => uir.ID, (u, uir) => new { u, uir })
.Where(m => m.u.State != -1)
.OrderBy(m => m.u.Class)
.Select(m => new
{
StudentID = m.u.StudentID,
FullName = m.u.FullName,
Class = m.u.Class,
ClassName = m.uir.ClassName,
BirthDay = m.u.BirthDay,
Gender = m.u.Gender,
Address = m.u.Address,
Email = m.u.Email,
PhoneNumber = m.u.PhoneNumber,
}).ToList();
//var list = ctx.Students.Where(ss => ss.State!=-1).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
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 GetStudents()
{
using (var ctx = new QLHSEntities())
{
var list = ctx.Students.Where(p => p.State != -1).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
//string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLHS;Integrated Security=True";
//int i = 1;
//var students = new List<Students>();
//using (var con = new SqlConnection(path))
//{
// var cmd = new SqlCommand("getStudents", con) { CommandType = CommandType.StoredProcedure };
// con.Open();
// var dr = cmd.ExecuteReader();
// while (dr.Read())
// {
// var student = new Students
// {
// STT = i,
// StudentID = dr[0].ToString(),
// FullName = dr[1].ToString(),
// BirthDay = Convert.ToDateTime(dr[2].ToString()),
// Gender = Convert.ToInt32(dr[3].ToString()),
// Email = dr[4].ToString(),
// PhoneNumber = dr[5].ToString(),
// Address = dr[6].ToString()
// };
// students.Add(student);
// i++;
// }
//}
//return Json(students, JsonRequestBehavior.AllowGet);
}
public ActionResult getListSubject()
{
using (var ctx = new QLHSEntities())
{
var list = ctx.Subjects.Where(p => p.Flag != -1).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetAllStudent()
{
using (var ctx = new QLHSEntities())
{
var list = ctx.Students.Where(p => p.State != -1).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public ActionResult getStudentByID(string id)
{
using (var ctx = new QLHSEntities())
{
var student = ctx.Students
.Join(ctx.Classes, s => s.Class, c => c.ID, (s, c) => new { s, c })
.Where(p => p.s.StudentID == id)
.FirstOrDefault();
return(Json(student, JsonRequestBehavior.AllowGet));
}
//var list = ctx.Students
// .Join(ctx.Classes
// , u => u.Class, uir => uir.ID, (u, uir) => new { u, uir })
// .Where(m => m.u.State != -1)
// .OrderBy(m => m.u.Class)
// .Select(m => new
// {
// StudentID = m.u.StudentID,
// FullName = m.u.FullName,
// Class = m.u.Class,
// ClassName = m.uir.ClassName,
// BirthDay = m.u.BirthDay,
// Gender = m.u.Gender,
// Address = m.u.Address,
// Email = m.u.Email,
// PhoneNumber = m.u.PhoneNumber,
// }).ToList();
//string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLHS;Integrated Security=True";
//var students = new List<Students>();
//using (var con = new SqlConnection(path))
//{
// var cmd = new SqlCommand("getStudentByID", con);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add(new SqlParameter("@id", id));
// con.Open();
// var dr = cmd.ExecuteReader();
// while (dr.Read())
// {
// var student = new Students
// {
// StudentID = dr[1].ToString(),
// FullName = dr[2].ToString(),
// BirthDay = Convert.ToDateTime(dr[3].ToString()),
// Gender = Convert.ToInt32(dr[4].ToString()),
// Email = dr[5].ToString(),
// PhoneNumber = dr[6].ToString(),
// Address = dr[7].ToString(),
// ClassLevel = Convert.ToInt32(dr[8].ToString()),
// Class = Convert.ToInt32(dr[9].ToString())
// };
// students.Add(student);
// }
//}
//return Json(students, JsonRequestBehavior.AllowGet);
}
public ActionResult getTotalInClass(int ID)
{
var result = new ArrayList();
using (var ctx = new QLHSEntities())
{
var cl = ctx.Classes.Where(c => c.ID == ID).FirstOrDefault();
return(Json(cl, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetSubject()
{
using (var ctx = new QLHSEntities())
{
var rx = ctx.Subjects
.Where(p => 1 == 1)
.ToList();
return(Json(rx, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetClassByID(int ID)
{
using (var ctx = new QLHSEntities())
{
var rx = ctx.Classes
.Where(r => r.ID == ID)
.FirstOrDefault();
return(Json(rx, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetRuleTotalStudent()
{
using (var ctx = new QLHSEntities())
{
var rx = ctx.Classes
.Where(r => r.Flag == 1)
.ToList();
return(Json(rx, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetSubjectByID(int ID)
{
using (var ctx = new QLHSEntities())
{
var rx = ctx.Subjects
.Where(p => p.ID == ID)
.FirstOrDefault();
return(Json(rx, JsonRequestBehavior.AllowGet));
}
}
public ActionResult getClassByLevel(int idLevel)
{
using (var ctx = new QLHSEntities())
{
if (idLevel == 0)
{
var list = ctx.Classes
.Where(m => 1 == 1)
.OrderBy(m => m.ClassName)
.Select(m => new
{
value = m.ID,
text = m.ClassName
}).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
else
{
var list = ctx.Classes
.Where(m => m.ClassLevel == idLevel)
.OrderBy(m => m.ClassName)
.Select(m => new
{
value = m.ID,
text = m.ClassName
}).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
//var result = new ArrayList();
//var con = new SqlConnection(path);
//var cmd = new SqlCommand("getClassByLevel", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@iDLevel", idLevel));
//con.Open();
//SqlDataAdapter da = new SqlDataAdapter();
//da.SelectCommand = cmd;
//DataTable dt = new DataTable();
//da.Fill(dt);
//con.Close();
//foreach (DataRow dr in dt.Rows)
//{
// result.Add(
// new
// {
// value = Convert.ToInt32(dr[0].ToString()),
// text = dr[1].ToString()
// });
//}
//return Json(result, JsonRequestBehavior.AllowGet);
}
public ActionResult GetRuleScore()
{
var result = new ArrayList();
using (var ctx = new QLHSEntities())
{
var rx = ctx.RuleStandardScores
.Where(r => r.Flag == "1")
.FirstOrDefault();
return(Json(rx, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetMaxTotalSubject()
{
var result = new ArrayList();
using (var ctx = new QLHSEntities())
{
var rx = ctx.RuleSubjects
.Where(r => 1 == 1)
.FirstOrDefault();
return(Json(rx, JsonRequestBehavior.AllowGet));
}
}
public bool checkTotalSubject()
{
var ctx = new QLHSEntities();
var current_total = ctx.Subjects.Where(p => p.Flag != -1).ToList().Count;
var max_total = ctx.RuleSubjects.Where(p => 1 == 1).FirstOrDefault().MaxTotal;
if (current_total < max_total)
{
return(true);
}
return(false);
}
public bool checkAge(int year)
{
var ctx = new QLHSEntities();
var ruleage = ctx.RuleAges.Where(p => p.Flag == "1").FirstOrDefault();
var date = DateTime.Now;
var age = date.Year - year;
if (ruleage.MinAge <= age && age <= ruleage.MaxAge)
{
return(true);
}
return(false);
}
public static User GetCurUser()
{
string id = ((User)HttpContext.Current.Session["user"]).username;
using (var ctx = new QLHSEntities())
{
var user = ctx.Users.Where(u => u.username == id).FirstOrDefault();
HttpContext.Current.Session["user"] = null;
if (user != null)
{
HttpContext.Current.Session["user"] = user;
}
}
return((User)HttpContext.Current.Session["user"]);
}
public bool CheckMaxClass(int classlevel)
{
using (var ctx = new QLHSEntities())
{
//var level = ctx.Classes.Where(c => c.ID == classid).FirstOrDefault().ClassLevel;
var currenttotal = ctx.Classes.Where(c => c.ClassLevel == classlevel).ToList();
var maxtotal = ctx.ClassLevels.Where(l => l.ID == classlevel).FirstOrDefault().MaxTotal;
if (currenttotal.Count >= maxtotal)
{
return(false);
}
return(true);
}
}
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 ViewDetail(string? ID)
public ActionResult ViewDetail(string ID)
{
if (ID == null)
{
return(RedirectToAction("Index", "Home"));
}
using (var ctx = new QLHSEntities())
{
var s = ctx.Students.Where(p => p.StudentID == ID.ToString());
if (s == null)
{
return(RedirectToAction("Index", "Home"));
}
ViewBag.Id = ID;
return(View());
}
}
public bool checkTotalClass(int classID, string studentID)
{
var ctx = new QLHSEntities();
var student = ctx.Students.Where(p => p.StudentID == studentID).FirstOrDefault();
if (student != null && student.Class == classID)
{
return(true);
}
var classInfo = ctx.Classes.Where(p => p.ID == classID).FirstOrDefault();
if (classInfo.Total < classInfo.MaxTotal)
{
return(true);
}
return(false);
}
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 GetRuleAge()
{
var result = new ArrayList();
using (var ctx = new QLHSEntities())
{
var rx = ctx.RuleAges
.Where(r => r.Flag == "1")
.FirstOrDefault();
result.Add(
new
{
ruleage = rx
});
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
