public List <ViewConsultaFliperama> ListarVendasFliperama()
{
string query = "select * from vw_consulta_fliperama";
ProjetoDataBase database = new ProjetoDataBase();
MySqlDataReader reader = database.ExecuteSelect(query);
List <ViewConsultaFliperama> itens = new List <ViewConsultaFliperama>();
while (reader.Read())
{
ViewConsultaFliperama flip = new ViewConsultaFliperama();
flip.Cpf = reader.GetString("ds_cpf");
flip.ValorUnitario = reader.GetFloat("vl_preco");
flip.DataDaCompra = reader.GetDateTime("dt_compra");
flip.QuantidadeDeFixas = reader.GetInt32("nr_fixas");
itens.Add(flip);
}
reader.Close();
return(itens);
}
public int Login(string email, string senha)
{
string query = "select tb_usuario.id_usuario, tb_usuario.nm_nomedoatendente,tb_usuario.ds_email,tb_usuario.ds_senha from tb_usuario left join tb_demitidos on tb_usuario.id_usuario = tb_demitidos.id_usuario WHERE tb_demitidos.id_usuario is null and ds_email = @ds_email AND ds_senha = @ds_senha";
List <MySqlParameter> parameters = new List <MySqlParameter>();
parameters.Add(new MySqlParameter("ds_email", email));
parameters.Add(new MySqlParameter("ds_senha", senha));
ProjetoDataBase sql = new ProjetoDataBase();
MySqlDataReader reader = sql.ExecuteSelectParamters(query, parameters);
if (reader.Read() == true)
{
return(reader.GetInt32("id_usuario"));
}
else
{
return(0);
}
reader.Close();
}
