//busca evento por nome public Attraction Find(int AttractionName) { try { OpenConnection(); Cmd = new SqlCommand("select * from Attraction where AttractionName = @v1 ", Con); Cmd.Parameters.AddWithValue("@v1", AttractionName); Dr = Cmd.ExecuteReader(); if (Dr.Read()) { Attraction f = new Attraction(); f.PkAttraction = Convert.ToInt32(Dr["PkAttraction"]); f.AttractionName = Convert.ToString(Dr["AttractionName"]); return f; } else { return null; } } catch (Exception ex) { throw new Exception("Erro ao obter Eventos. " + ex.Message); } finally { CloseConnection(); } }
//inserir atração no banco public void Insert(Attraction a) { try { OpenConnection(); Cmd = new SqlCommand("insert into Attraction(AttractionName,AttractionDate,AttractionDescription,AttractionAddress,AttractionImage,TicketPriceQuantity) values(@v1,@v2,@v3,@v4,@v5,@v5@v6,@v7)", Con); Cmd.Parameters.AddWithValue("@v1", a.AttractionName); Cmd.Parameters.AddWithValue("@v2", a.AttractionDate); Cmd.Parameters.AddWithValue("@v3", a.AttractionDescription); Cmd.Parameters.AddWithValue("@v4", a.AttractionAddress); Cmd.Parameters.AddWithValue("@v5", a.AttractionImage); Cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Erro ao cadastrar Evento. " + ex.Message); } finally { CloseConnection(); } }
//lista todos os eventos public List<Attraction> FindAll() { try { OpenConnection(); Cmd = new SqlCommand("select * from Attraction order by AttractionName"); Cmd.Connection = Con; Dr = Cmd.ExecuteReader(); List<Attraction> list = new List<Attraction>(); while (Dr.Read()) { Attraction f = new Attraction(); f.PkAttraction = Convert.ToInt32(Dr["PkAttraction"]); f.AttractionName = Convert.ToString(Dr["AttractionName"]); f.AttractionDate = Convert.ToString(Dr["AttractionDate"]); f.AttractionAddress = Convert.ToString(Dr["AttractionAddress"]); f.AttractionDescription = Convert.ToString(Dr["AttractionDescription"]); f.AttractionImage = Convert.ToString(Dr["AttractionImage"]); list.Add(f); } return list; } catch { throw; } finally { CloseConnection(); } }