// GET: api/Time/5
public TimeBindingModel Get(int id)
{
SqlConnection();
TimeBindingModel Time = new TimeBindingModel();
using (SqlCommand sqlCommand = new SqlCommand("GetTimeById", sqlConnection))
{
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Id", id);
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
Time = new TimeBindingModel()
{
Id = Convert.ToInt32(sqlDataReader["Id"]),
Nome = Convert.ToString(sqlDataReader["Name"])
};
}
sqlConnection.Close();
}
return(Time);
}
// GET: api/Time
public IEnumerable <TimeBindingModel> Get()
{
SqlConnection();
List <TimeBindingModel> times = new List <TimeBindingModel>();
using (SqlCommand sqlCommand = new SqlCommand("GetAllTimes", sqlConnection))
{
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlConnection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
if (sqlDataReader.HasRows)
{
TimeBindingModel time = new TimeBindingModel()
{
Id = Convert.ToInt32(sqlDataReader["Id"]),
Nome = Convert.ToString(sqlDataReader["Name"])
};
times.Add(time);
}
}
sqlConnection.Close();
}
return(times);
}
// POST: api/Time
public IHttpActionResult Post(TimeBindingModel Time)
{
SqlConnection();
using (SqlCommand sqlCommand = new SqlCommand("InsertTime", sqlConnection))
{
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Name", Time.Nome);
sqlConnection.Open();
int execute = sqlCommand.ExecuteNonQuery();
}
sqlConnection.Close();
return(Ok(Time));
}
