public IActionResult GetStudent()
{
/*var list = new List<Student>();
*
* using (SqlConnection con = new SqlConnection(conString))
* using (SqlCommand com = new SqlCommand())
* {
* com.Connection = con;
* com.CommandText = "select * from Student";
*
* con.Open();
* SqlDataReader dr = com.ExecuteReader();
* while (dr.Read())
* {
* var st = new Student();
* st.IndexNumber = dr["IndexNumber"].ToString();
* st.FirstName = dr["FirstName"].ToString();
* st.LastName = dr["LastName"].ToString();
* list.Add(st);
* }
*
* }*/
SqlServerDbService sql = new SqlServerDbService();
return(Ok(sql.GetStudents()));
}
public IActionResult GetStudents()
{
var sql = new SqlServerDbService();
var result = sql.GetStudents();
if (result.Count() > 0)
{
return(Ok(result));
}
return(NotFound("Database is empty!!!"));
}
public IActionResult GetStudent()
{
return(Ok(_dbService.GetStudents()));
}