public IActionResult Get()
{
try
{
if (String.IsNullOrEmpty(Authorize(Request)))
{
throw new Exception();
}
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();
MySqlCommand comm = connection.CreateCommand();
comm.CommandText = "SELECT * FROM STORE_T ";
// List to return to the user
List<Store> stores = new List<Store>();
// This while loop reads all of the results
MySqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
Store store = new Store();
store.StoreId = reader.GetInt32(0);
store.StoreName = reader.GetString(1);
store.ZipCode = reader.GetInt32(2);
stores.Add(store);
}
connection.Close();
return new ObjectResult(stores);
}
catch (Exception)
{
return HttpBadRequest();
}
}
public IActionResult Get(int id)
{
try
{
if (String.IsNullOrEmpty(Authorize(Request)))
{
throw new Exception();
}
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();
MySqlCommand comm = connection.CreateCommand();
comm.CommandText = "SELECT * FROM STORE_T WHERE PK_STORE_ID = @id";
comm.Parameters.AddWithValue("@id", id);
// List to return to the user
Store store = new Store();
// This while loop reads all of the results
MySqlDataReader reader = comm.ExecuteReader();
if (reader.Read())
{
store.StoreId = reader.GetInt32(0);
store.StoreName = reader.GetString(1);
store.ZipCode = reader.GetInt32(2);
}
connection.Close();
return new ObjectResult(store);
}
catch (Exception)
{
return HttpBadRequest();
}
}