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)));
}
}
