public JsonResult GetcoursebyID(string idstudent)
{
var sub = new InfoStudentDAO().getcoursebyID(idstudent).Select(x => new
{
ID = x.ID,
FIRST_NAME = x.FIRST_NAME,
MIDDLE_NAME = x.MIDDLE_NAME,
LAST_NAME = x.LAST_NAME,
COURSE = x.COURSEs.Select(y => new
{
IDCOURSE = y.ID,
NAMECOURSE = y.NAME,
DESCRIPTION = y.DESCRIPTION,
SEMESTER = new SEMESTER
{
ID = y.SEMESTER.ID,
TITLE = y.SEMESTER.TITLE,
}
})
});
return(Json(new
{
data = sub,
status = true
}, JsonRequestBehavior.AllowGet));
}
public JsonResult Delete(string id)
{
var info = new InfoStudentDAO().deletestudent(id);
return(Json(new
{
status = true
}));
}
public JsonResult CountStudent()
{
var cntStudent = new InfoStudentDAO().CountStudent();
return(Json(new
{
data = cntStudent
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetStudent(string name, int page, int pageSize)
{
var ListStudent = new InfoStudentDAO().getstudent().Select(x => new
{
ID = x.ID,
FIRST_NAME = x.FIRST_NAME,
LAST_NAME = x.LAST_NAME,
MIDDLE_NAME = x.MIDDLE_NAME,
PHONE_NO = x.PHONE_NO,
MAIL = x.MAIL,
FACULTY = new
{
ID = x.FACULTY.ID,
NAME = x.FACULTY.NAME
},
CLASS = new
{
ID = x.CLASS.ID,
NAME = x.CLASS.NAME,
MAJOR = x.CLASS.MAJOR
}
});
if (!string.IsNullOrEmpty(name))
{
ListStudent = ListStudent.Where(x => (x.LAST_NAME == name) || (x.MIDDLE_NAME == name) || (x.FIRST_NAME == name) || (x.FACULTY.NAME == name));
}
int TotalRow = ListStudent.Count();
var lstStudent = ListStudent.Skip((page - 1) * pageSize).Take(pageSize);
return(Json(new
{
total = TotalRow,
data = lstStudent,
status = true
}, JsonRequestBehavior.AllowGet));
}
public JsonResult Detail(string idstudent)
{
var model = new InfoStudentDAO().detailstudent(idstudent).Select(x => new
{
ID = x.ID,
FIRST_NAME = x.FIRST_NAME,
LAST_NAME = x.LAST_NAME,
MIDDLE_NAME = x.MIDDLE_NAME,
PHONE_NO = x.PHONE_NO,
DoB = x.DoB,
SEX = x.SEX,
MAIL = x.MAIL,
PASSWORD = x.PASSWORD,
LASTVISITDATE = x.LASTVISITDATE,
FACULTY = new { ID = x.FACULTY.ID, NAMEFACULTY = x.FACULTY.NAME },
CLASS = new { ID = x.CLASS.ID, NAMECLASS = x.CLASS.NAME, MAJOR = x.CLASS.MAJOR }
}).ToList();
return(Json(new
{
data = model,
status = true
}));
}
public JsonResult Save(C_USER infostudent)
{
bool status = false;
string message = string.Empty;
if (infostudent.ID != null)
{
try
{
var model = new InfoStudentDAO().updatestudent(infostudent);
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
return(Json(new
{
status = status,
message = message
}));
}
