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