public IHttpActionResult updateTimeTable(timetable_details update)
{
Boolean bb = new TimeTableRelated().updateTimeTable(update);
if (bb)
{
rs.code = 200;
rs.message = "succesfully data has been updated";
return(Content(HttpStatusCode.OK, rs));
}
else
{
rs.code = 100;
rs.message = "failed to update";
return(Content(HttpStatusCode.OK, rs));
}
}
public IHttpActionResult deleteTimetable(timetable_details tdel)
{
Boolean del = new TimeTableRelated().deleteTimeTbles(tdel);
if (del)
{
rs.code = 200;
rs.message = "succesfully data has been deleted";
return(Content(HttpStatusCode.OK, rs));
}
else
{
rs.code = 100;
rs.message = "failed to delete data";
return(Content(HttpStatusCode.OK, rs));
}
}
public ResponseMessage timeTableList(timetable_details slist)
{
var entryPoint = (from ep in entt.timetable_details
//join e in entt.school_details on slist.school_id equals e.school_id
//join esub in entt.subject_details on slist.school_id equals esub.school_id
//join eteach in entt.teacher_details on slist.school_id equals eteach.school_id
//join eclass in entt.class_details on eteach.teacher_id equals eclass.teacher_id
where ep.timetable_day == slist.timetable_day
where ep.school_id == slist.school_id
where ep.section_id == slist.section_id
where ep.class_id == slist.class_id
select new
{
ep.timetable_day,
ep.timetable_end_time,
ep.timetable_section,
ep.timetable_start_time,
ep.timetable_id,
ep.subject_id,
ep.teacher_id,
perticularTeacher = (from et in entt.teacher_details
//join ee in entt.timetable_details on et.teacher_id equals ee.teacher_id
where et.teacher_id == ep.teacher_id
select new
{
teacher_name = et.teacher_first_name + "" + et.teacher_last_name
}),
perticularSubject = (from sub in entt.subject_details
where sub.teacher_id == ep.teacher_id
select new
{
sub.subject_name,
sub.subject_type
}),
ep.class_id,
ep.school_id
});
rs.Data = entryPoint;
rs.code = 200;
rs.message = "Data success";
return(rs);
}
public IHttpActionResult addingTimeTable(timetable_details addings)
{
Boolean sd = new TimeTableRelated().addingTimeTable(addings);
if (sd)
{
addings.insert_date = DateTime.Now;
entt.timetable_details.Add(addings);
entt.SaveChanges();
rs.code = 200;
rs.message = "succesfully data has inserted";
return(Content(HttpStatusCode.OK, rs));
}
else
{
rs.code = 100;
rs.message = "failed to insert data";
return(Content(HttpStatusCode.OK, rs));
}
}
