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