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