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