public JsonResult GetCourseInSubject(string idsub)
{
var model = new SubjectsDAO().getcourseinsubjects(idsub).Select(a => new
{
ID = a.ID,
NAME = a.NAME,
COURSE = a.COURSEs.Select(b => new
{
IDCOURSE = b.ID,
NAMECOURSE = b.NAME,
DESCRIPTION = b.DESCRIPTION,
TEACH = new TEACH
{
C_USER = new C_USER
{
ID = b.TEACH.C_USER.ID,
FIRST_NAME = b.TEACH.C_USER.FIRST_NAME,
LAST_NAME = b.TEACH.C_USER.LAST_NAME,
MIDDLE_NAME = b.TEACH.C_USER.MIDDLE_NAME
}
},
})
});
return(Json(new
{
data = model,
status = true
}, JsonRequestBehavior.AllowGet));
}
public JsonResult CountSubjects()
{
var cntSubjects = new SubjectsDAO().countsubjects();
return(Json(new
{
data = cntSubjects
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetNameSubject()
{
var model = new SubjectsDAO().getsubject().Select(x => new { ID = x.ID, NAME = x.NAME });
return(Json(new
{
data = model
}, JsonRequestBehavior.AllowGet));
}
public JsonResult Save(SUBJECT subjects)
{
bool status = false;
string message = string.Empty;
int sub = new SubjectsDAO().CheckSubjects(subjects.NAME);
if (subjects.ID != "0")
{
try
{
var model = new SubjectsDAO().update(subjects);
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
else
{
try
{
if (sub == 0)
{
subjects.ID = createID("SUBJ");
db.SUBJECTs.Add(subjects);
db.SaveChanges();
status = true;
}
else
{
status = false;
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
}
return(Json(new
{
status = status,
message = message
}));
}
public JsonResult Delete(string id)
{
var model = new SubjectsDAO().delete(id);
var sub = new SubjectsDAO().getsubject().Select(a => new
{
ID = a.ID,
NAME = a.NAME,
DESCRIPTION = a.DESCRIPTION
});
int totalRow = sub.Count();
return(Json(new
{
total = totalRow,
status = true
}));
}
public JsonResult Detail(string id)
{
var model = new SubjectsDAO().getdetail(id).Select(x => new {
ID = x.ID,
NAME = x.NAME,
DESCRIPTION = x.DESCRIPTION,
FACULTY = new FACULTY
{
ID = x.FACULTY.ID,
NAME = x.FACULTY.NAME,
}
});
return(Json(new
{
data = model,
status = true
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSubjects(string name, int page, int pageSize)
{
var ListSubjects = new SubjectsDAO().getsubject().Select(a => new
{
ID = a.ID,
NAME = a.NAME,
DESCRIPTION = a.DESCRIPTION
});
if (!string.IsNullOrEmpty(name))
{
ListSubjects = ListSubjects.Where(x => x.NAME.Contains(name));
}
int TotalRow = ListSubjects.Count();
var lstSubjects = ListSubjects.Skip((page - 1) * pageSize).Take(pageSize);
return(Json(new
{
total = TotalRow,
data = lstSubjects,
status = true
}, JsonRequestBehavior.AllowGet));
}
