internal static List <tp_sala> Busca(SqlConnection conexaoSql) { string sql = "SELECT * FROM " + NOME_TABELA; SqlCommand cmd = conexaoSql.CreateCommand(); cmd.CommandText = sql; List <tp_sala> tiposSala = new List <tp_sala>(); using (DbDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { tp_sala tpSala = new tp_sala(); tpSala.cd_tp_sala = DBUtils.buscaValor <int>(tp_sala.CD_TP_SALA, reader); tpSala.nm_tp_sala = DBUtils.buscaValor <string>(tp_sala.NM_TP_SALA, reader); tpSala.tamanho = DBUtils.buscaValor <int>(tp_sala.TAMANHO, reader); tiposSala.Add(tpSala); } } } return(tiposSala); }
public void AddTipoSala(tp_sala novoTpSala = null) { if (_debug) { _preencheBancoUtils.AddTiposSalas(_conexaoSql); } else { TipoSalaDAO.Add(novoTpSala, _conexaoSql); } }
public static void Add(tp_sala novoTpSala, SqlConnection conexaoSql) { string sql = "INSERT INTO tp_sala (cd_tp_sala, nm_tp_sala, tamanho) " + " values (@" + tp_sala.CD_TP_SALA + ", @" + tp_sala.NM_TP_SALA + ", @" + tp_sala.TAMANHO + ") "; SqlCommand cmd = conexaoSql.CreateCommand(); cmd.CommandText = sql; cmd.Parameters.Add(DBUtils.criaParametro <int>(tp_sala.CD_TP_SALA, novoTpSala.cd_tp_sala, SqlDbType.Int)); cmd.Parameters.Add(DBUtils.criaParametro <string>(tp_sala.NM_TP_SALA, novoTpSala.nm_tp_sala, SqlDbType.VarChar)); cmd.Parameters.Add(DBUtils.criaParametro <int>(tp_sala.TAMANHO, novoTpSala.tamanho, SqlDbType.Int)); int rowCount = cmd.ExecuteNonQuery(); AcessoBanco.comandosSqlExecutados += DBUtils.MontaComandoSql(cmd) + "\r\n"; Debug.Write("Linhas afetadas: " + rowCount); }
internal void AddTiposSalas(SqlConnection conexaoSql) { tp_sala tpSala1 = new tp_sala() { cd_tp_sala = 1, nm_tp_sala = "Sala 1", tamanho = 1 }; tp_sala tpSala2 = new tp_sala() { cd_tp_sala = 2, nm_tp_sala = "Sala 2", tamanho = 2 }; tp_sala tpSala3 = new tp_sala() { cd_tp_sala = 3, nm_tp_sala = "Sala 3", tamanho = 3 }; tp_sala tpSala4 = new tp_sala() { cd_tp_sala = 4, nm_tp_sala = "Sala 4", tamanho = 4 }; TipoSalaDAO.Add(tpSala1, conexaoSql); TipoSalaDAO.Add(tpSala2, conexaoSql); TipoSalaDAO.Add(tpSala3, conexaoSql); TipoSalaDAO.Add(tpSala4, conexaoSql); }