public static Object getStudentActivitiesForId(int id) { String connectionString = DatabaseConnections.getConnectionString("NARAYANA_CLIENT"); List <StudentActivities> studentActivitiesList = null; using (SqlConnection connection = new SqlConnection(connectionString)) { String sqlQuery = "SELECT * FROM " + STUDENT_ACTIVITIES_TABLE + " WHERE " + STUDENT_ID + " = " + id; try { connection.Open(); using (SqlCommand command = new SqlCommand(sqlQuery, connection)) { studentActivitiesList = new List <StudentActivities>(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { StudentActivities activity = StudentActivitiesUtility.getStudentActivitiesFormReader(reader); studentActivitiesList.Add(activity); } } } } catch (InvalidOperationException e) { return(e); } catch (SqlException e) { return(e); } catch (Exception e) { return(e); } } return(studentActivitiesList); }
public ActionResult Post([FromBody] StudentActivities activity) { String error; if (StudentActivitiesUtility.checkForValidStudent(out error, activity)) { Object result = StudentActivitiesTable.insertStudentActivity(activity); StudentActivities activity1 = result as StudentActivities; if (null != activity1) { return(Ok(activity1)); } else { return(NotFound(result)); } } else { return(NotFound(new ErrorText(error))); } }