public IHttpActionResult updatings(exam_results eresults) { Boolean mm = new ExamResultsRelated().updateExamResults(eresults); if (mm) { rss.code = 200; rss.message = "succesfully data has been updated"; return(Content(HttpStatusCode.OK, rss)); } else { rss.code = 100; rss.message = "failed to update"; return(Content(HttpStatusCode.OK, rss)); } }
public IHttpActionResult addingExams(exam_results eresults) { Boolean gg = new ExamResultsRelated().addingExamResults(eresults); if (gg) { eresults.insert_date = DateTime.Now.ToString(); entitys.exam_results.Add(eresults); entitys.SaveChanges(); rss.code = 200; rss.message = "succesfully data has been inserted"; return(Content(HttpStatusCode.OK, rss)); } else { rss.code = 100; rss.message = "failed to insert data"; return(Content(HttpStatusCode.OK, rss)); } }
public ResponseMessage examResulList(exam_results sdetails) { var query = (from staff in entitys.exam_results join section in entitys.exam_details on sdetails.exam_id equals section.exam_id where sdetails.student_id == staff.student_id where sdetails.exam_id == staff.exam_id where sdetails.teacher_id == staff.teacher_id select new { staff.examresult_marks, staff.examresult_subjects, staff.examresult_total_marks, staff.examresult_unit, staff.exam_id, staff.teacher_id, staff.student_id } ); rss.Data = query; rss.code = 200; rss.message = "Data success"; return(rss); }