public static string CompruebaPais(string pais, NavisionDB.NavisionDBConnection conn, NavisionDB.NavisionDBUser user) { NavisionDBTable dt = new NavisionDBTable(conn, user); NavisionDBCommand cmd = new NavisionDBCommand(conn); NavisionDBDataReader rd = new NavisionDBDataReader(); cmd = new NavisionDBCommand(conn); if (pais == "") return ""; dt.TableName = "Country"; dt.AddColumn("Code"); dt.AddFilter("Code", pais); cmd.Table = dt; rd = cmd.ExecuteReader(false); return (rd.RecordsAffected != 0) ? rd.GetString(0) : "-1"; }
public static bool CompruebaFormato(string codpais, string dni, NavisionDB.NavisionDBConnection conn, NavisionDB.NavisionDBUser user) { NavisionDBTable dt = new NavisionDBTable(conn, user); //NavisionDBAdapter da = new NavisionDBAdapter(); NavisionDBDataReader rd = new NavisionDBDataReader(); NavisionDBCommand cmd = new NavisionDBCommand(conn); bool resul = false; // if (codpais == "") // codpais = "ES"; // Accedemos a la tabla de formatos de dni por pais para contrastar dt.TableName = "VAT Registration No. Format"; dt.AddColumn("Format"); dt.AddFilter("Country Code", codpais); cmd.Table = dt; rd = cmd.ExecuteReader(false); if (rd.RecordsAffected != 0) { resul = CompruebaCadenas(rd.GetString(0), dni); while (!resul && rd.NextResult()) { resul = CompruebaCadenas(rd.GetString(0), dni); } } else { return true; // no existen formatos para ese pais, se aceptan todos } return resul; }