public CadastroModel SearchForCpf(string cpf) { string sql = @"SELECT * FROM soue_tb_register_client WHERE cpf = @Cpf ORDER BY id ASC LIMIT 1"; MySqlCommand Command = new MySqlCommand(); DalModel objDAL = new DalModel(); Command.CommandText = sql; Command.Parameters.AddWithValue("@Cpf", cpf); DataTable dt = objDAL.ReturnDataTable(Command); objDAL.CloseConnection(); if (dt.Rows.Count > 0) { CadastroModel RegisterClient = new CadastroModel() { Id = Convert.ToInt32(dt.Rows[0]["id"]), Name = dt.Rows[0]["name"].ToString(), Cpf = dt.Rows[0]["cpf"].ToString(), Email = dt.Rows[0]["email"].ToString(), PhoneNumber = dt.Rows[0]["phonenumber"].ToString(), Address = dt.Rows[0]["address"].ToString() }; return(RegisterClient); } return(null); }
public bool Validate() { CadastroModel cadastroModel = new CadastroModel(); cadastroModel = cadastroModel.SearchForCpf(Cpf); return(false); }
private object ConvertAccessUserJSON(CadastroModel cadastro) { return(JsonConvert.SerializeObject(cadastro)); }