public async Task <HttpResponseMessage> GetResult(int userID, string batchCode) { try { ResultDAL dal = new ResultDAL(); ResultInfo data = await dal.GetResult(userID, batchCode); if (data != null) { return(Request.CreateResponse <ResultInfo>(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
public async Task <HttpResponseMessage> GetStudentDashboard(int userID, int batchID, string role, int currentIndex, int maxRows) { try { MIUEntities db = new MIUEntities(); StudentDashboardInfo data = new StudentDashboardInfo(); EventCalendarDAL dal = new EventCalendarDAL(); NewsDAL newsDAL = new NewsDAL(); ResultDAL resultDAL = new ResultDAL(); AnnouncementDAL announcementDAL = new AnnouncementDAL(); ReportAttendanceDAL reportAttendanceDAL = new ReportAttendanceDAL(); data.EventCalendar = await dal.GetAllEventCalendar(userID, role); data.News = await newsDAL.GetNews(userID, currentIndex, maxRows); string batchCode = db.Batches.Where(x => x.ID == batchID).Select(x => x.BatchCode).SingleOrDefault(); data.StudentDashboard = await resultDAL.GetResult(userID, batchCode); data.Announcement = await announcementDAL.GetLatestAnnouncement(); //data.AttRateAndPercent = await reportAttendanceDAL.GetAttRateAndPercent(batchID, userID); if (data != null) { return(Request.CreateResponse <StudentDashboardInfo>(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
public DataSet GetResult(DateTime time, string flightno, string depAir, string arrAir) { ResultDAL dal = new ResultDAL(); return(dal.GetResult(time, flightno, depAir, arrAir)); }