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