//Done
public JsonResult GetTeacher(string name, int page, int pageSize)
{
var ListTeacher = new InfoTeacherDAO().getteacher().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,
MAIL = x.MAIL,
FACULTY = new
{
ID = x.FACULTY.ID,
NAME = x.FACULTY.NAME
}
});
if (!string.IsNullOrEmpty(name))
{
ListTeacher = ListTeacher.Where(x => (x.LAST_NAME == name) || (x.MIDDLE_NAME == name) || (x.FIRST_NAME == name) || (x.FACULTY.NAME == name));
}
int TotalRow = ListTeacher.Count();
var lstTeacher = ListTeacher.Skip((page - 1) * pageSize).Take(pageSize);
return(Json(new
{
total = TotalRow,
data = lstTeacher,
status = true
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCoursebyID(string idteacher)
{
var sub = new InfoTeacherDAO().getcoursebyID(idteacher).Select(x => new
{
ID = x.ID,
FIRST_NAME = x.FIRST_NAME,
MIDDLE_NAME = x.MIDDLE_NAME,
LAST_NAME = x.LAST_NAME,
TEACHES = x.TEACHES.Select(b => new
{
COURSE = new COURSE
{
ID = b.COURSE.ID,
NAME = b.COURSE.NAME,
DESCRIPTION = b.COURSE.DESCRIPTION,
SEMESTER = new SEMESTER
{
ID = b.COURSE.SEMESTER.ID,
TITLE = b.COURSE.SEMESTER.TITLE,
}
}
})
});
return(Json(new
{
data = sub,
status = true
}, JsonRequestBehavior.AllowGet));
}
public JsonResult CountTeacher()
{
var cntTeacher = new InfoTeacherDAO().CountTeacher();
return(Json(new
{
data = cntTeacher
}, JsonRequestBehavior.AllowGet));
}
//Done
public JsonResult Delete(string id)
{
var model = new InfoTeacherDAO().deleteteacher(id);
return(Json(new
{
status = true
}));
}
public JsonResult GetPieData()
{
int male = new InfoTeacherDAO().GetMaleTeacher();
int female = new InfoTeacherDAO().GetFemaleTeacher();
int total = male + female;
float MalePercent = (float)male / total;
float FemalePercent = (float)female / total;
return(Json(new
{
male = Math.Round(MalePercent, 2),
female = Math.Round(FemalePercent, 2)
}, JsonRequestBehavior.AllowGet));
}
//Done
public JsonResult Detail(string idnameteacher)
{
var model = new InfoTeacherDAO().detailteacher(idnameteacher).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, NAME = x.FACULTY.NAME }
}).ToList();
return(Json(new
{
data = model,
status = true
}));
}
public JsonResult Save(C_USER infoteacher)
{
bool status = false;
string message = string.Empty;
if (infoteacher.ID != null)
{
try
{
var model = new InfoTeacherDAO().updateteacher(infoteacher);
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
return(Json(new
{
status = status,
message = message
}));
}
