public bool updateteach(TEACH Teach)
{
var teach = db.TEACHES.First(x => x.COURSE_ID == Teach.COURSE_ID);
teach.USER_ID = Teach.USER_ID;
db.SaveChanges();
return(true);
}
public bool addteach(TEACH Teach, COURSE Course)
{
TEACH tea = new TEACH();
tea.COURSE_ID = Course.ID;
tea.USER_ID = Teach.USER_ID;
db.TEACHES.Add(tea);
db.SaveChanges();
return(true);
}
public List <TOPIC> GetAllTopicOfTeacherCourse(string userId, string semId, string courseId)
{
//var topicsInSubTeachedByTeacher = db.C_USER.Where(x => x.ID == userId)
// .Select(x => x.SUBJECTs1.Where(s => s.COURSE_ID == courseId && s.ID == subjectId)
// .Select(s => s.TOPICs)).ToList();
C_USER teacher = db.C_USER.Where(u => u.ID == userId).First();
TEACH teach = teacher.TEACHES.Where(t => t.COURSE.ID == courseId).Select(t => new TEACH {
COURSE = t.COURSE
}).First();
List <TOPIC> topics = teach.COURSE.TOPICs.Select(t => new TOPIC
{
ID = t.ID,
TITLE = t.TITLE,
DESCRIPTION = t.DESCRIPTION,
COURSE_ID = t.COURSE_ID,
DOCUMENTs = t.DOCUMENTs
.Select(d => new DOCUMENT
{
ID = d.ID,
TITLE = d.TITLE,
DESCRIPTION = d.DESCRIPTION,
LINK = d.LINK
})
.ToList(),
EVENTs = t.EVENTs
.Select(e => new EVENT
{
ID = e.ID,
TITLE = e.TITLE,
DESCRIPTION = e.DESCRIPTION,
STARTDATE = e.STARTDATE,
DEADLINE = e.DEADLINE
})
.ToList()
}).ToList();
return(topics);
}
public JsonResult Save(HttpPostedFileBase file, string ID, string NAME, string DESCRIPTION, string SEMESTER_ID, string SUBJECT_ID, string USER_ID, string COURSE_ID)
{
COURSE Course = new COURSE();
Course.ID = ID;
Course.NAME = NAME;
Course.DESCRIPTION = DESCRIPTION;
Course.SEMESTER_ID = SEMESTER_ID;
Course.SUBJECT_ID = SUBJECT_ID;
TEACH Teach = new TEACH();
Teach.USER_ID = USER_ID;
Teach.COURSE_ID = COURSE_ID;
bool status = false;
string message = string.Empty;
var course = new CourseDAO().CheckCouseIDExists(Course.ID);
if (course == 1)
{
try
{
var model = new TeachDAO().updateteach(Teach);
var cour = new CourseDAO().updatecourse(Course);
if (file != null)
{
UploadExcel(file);
}
status = true;
}
catch (Exception ex)
{
status = false;
message = ex.Message;
}
}
else
{
try
{
//Course.ID = createID("COUR");
var cour = new CourseDAO().addcourse(Course);
var teach = new TeachDAO().addteach(Teach, Course);
UploadExcel(file);
status = true;
}
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
}));
}
