public List <Modelo.hDisponivel> SelectAll()
{
Modelo.hDisponivel aArea;
List <Modelo.hDisponivel> aListAreas = new List <Modelo.hDisponivel>();
SqlConnection conn = new SqlConnection(connectionstring);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from horario_Disponivel";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
aArea = new Modelo.hDisponivel(
Alternadores.AlternadorI(dr["dia_semana"].ToString()),
dr["hora_inicio"].ToString(),
dr["hora_fim"].ToString(),
Alternadores.AlternadorI(dr["id_AreaPoliesportiva"].ToString())
);
aListAreas.Add(aArea);
}
}
dr.Close();
conn.Close();
return(aListAreas);
}
public void Delete(Modelo.hDisponivel obj)
{
SqlConnection conn = new SqlConnection(connectionstring);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("DELETE FROM horario_Disponivel WHERE ID = @id", conn);
cmd.Parameters.AddWithValue("@id", obj.id);
cmd.ExecuteNonQuery();
}
public bool Insert(Modelo.hDisponivel obj)
{
try
{
SqlConnection conn = new SqlConnection(connectionstring);
conn.Open();
SqlCommand com = conn.CreateCommand();
SqlCommand cmd = new SqlCommand("INSERT INTO horario_Disponivel (dia_semana,hora_inicio,hora_fim,id_AreaPoliesportiva) VALUES(@dia,@hinit,@hfim,@idArea)", conn);
cmd.Parameters.AddWithValue("@dia", obj.diaSemana);
cmd.Parameters.AddWithValue("@hinit", obj.horaInicio);
cmd.Parameters.AddWithValue("@hfim", obj.horaFim);
cmd.Parameters.AddWithValue("@idArea", obj.idAreaEsportiva);
cmd.ExecuteNonQuery();
return(true);
}
catch { return(false); }
}