public IEnumerable <Student> Get()
{
String[] list = new String[4];
List <Student> studentList = new List <Student>();
try
{
String connectionString = DatabaseConnections.getConnectionString("NARAYANA_CLIENT");
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
String sqlQuery = "SELECT * FROM [dbo].[student]";
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.Write(reader.GetString(1));
Student student = StudentUtility.getStudentFormReader(reader);
studentList.Add(student);
}
}
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
list[1] = e.ToString();
}
return(studentList);
}
public static Object getStudentForId(int id)
{
Student student = null;
try
{
String connectionString = DatabaseConnections.getConnectionString("NARAYANA_CLIENT");
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
String sqlQuery = "SELECT * FROM [dbo].[student] WHERE ID = " + id;
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.Write(reader.GetString(1));
student = StudentUtility.getStudentFormReader(reader);
}
}
}
}
}
catch (SqlException e)
{
return(e);
}
catch (InvalidOperationException e)
{
return(e);
}
catch (InvalidCastException e)
{
return(e);
}
catch (Exception e) {
return(e);
}
if (null != student)
{
return(student);
}
else
{
return(new Exception("Student Not Found"));
}
}
public static Object getStudents()
{
String connectionString = DatabaseConnections.getConnectionString("NARAYANA_CLIENT");
List <Student> studentList = null;
using (SqlConnection connection = new SqlConnection(connectionString)) {
String sqlQuery = "SELECT * FROM [dbo].[student]";
try
{
connection.Open();
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
studentList = new List <Student>();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.Write(reader.GetString(1));
Student student = StudentUtility.getStudentFormReader(reader);
studentList.Add(student);
}
}
}
}
catch (InvalidOperationException e)
{
return(e);
}
catch (SqlException e)
{
return(e);
}
catch (Exception e)
{
return(e);
}
}
return(studentList);
}
public ActionResult Put([FromBody] Student student)
{
String error;
if (StudentUtility.checkForValidStudent(out error, student))
{
Object result = StudentTable.updateStudent(student);
Student student1 = result as Student;
if (null != student1)
{
return(Ok(result));
}
else
{
return(NotFound(result));
}
}
else
{
return(NotFound(new ErrorText(error)));
}
}
public ActionResult Get(int id)
{
Student student = null;
try
{
String connectionString = DatabaseConnections.getConnectionString("NARAYANA_CLIENT");
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
String sqlQuery = "SELECT * FROM [dbo].[student] WHERE ID = " + id;
using (SqlCommand command = new SqlCommand(sqlQuery, connection))
{
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Console.Write(reader.GetString(1));
student = StudentUtility.getStudentFormReader(reader);
}
}
}
}
}
catch (SqlException e)
{
Console.WriteLine(e.ToString());
}
if (null != student)
{
return(Ok(student));
}
else
{
return(NotFound(new ErrorText("Student Not Found")));
}
}
