/// <summary>
/// Retorna uma lista de registro
/// </summary>
/// <returns></returns>
public List<StatusBE> Listar()
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("SELECT * FROM Status");
List<StatusBE> Lista = new List<StatusBE>();
using (IDataReader dr = db.ExecuteReader(command))
{
while (dr.Read())
{
StatusBE statusBE = new StatusBE();
statusBE.ID = Convert.ToInt32(dr["ID"]);
statusBE.Nome = Convert.ToString(dr["Nome"]);
Lista.Add(statusBE);
}
}
return Lista;
}
/// <summary>
/// Obtem dados do registro passando o ID
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public StatusBE Obter(int ID)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("SELECT * FROM Status WHERE id = " + ID);
using (IDataReader dr = db.ExecuteReader(command))
{
StatusBE statusBE = new StatusBE();
if (dr.Read())
{
statusBE.ID = Convert.ToInt32(dr["ID"]);
statusBE.Nome = Convert.ToString(dr["Nome"]);
}
return statusBE;
}
}
/// <summary>
/// Innclui um novo registro
/// </summary>
/// <param name="usuarioBE"></param>
public void Incluir(StatusBE statusBE)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("INSERT INTO Status (Nome) VALUES (" + statusBE.Nome + ")");
db.ExecuteNonQuery(command);
}
/// <summary>
/// Altera o cadastro
/// </summary>
/// <param name="usuarioBE"></param>
public void Alterar(StatusBE statusBE)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand command = db.GetSqlStringCommand("UPDATE Status SET Nome = " + statusBE.Nome + " Where id = " + statusBE.ID);
db.ExecuteNonQuery(command);
}