protected override void ProcessRecord() { WriteVerbose("Start Opening Database."); if (HamRadioDeluxeDatabase.CheckDatabaseOpen()) { WriteVerbose("Closing database, because it was open."); HamRadioDeluxeDatabase.DisconnectFromDatabase(); } if (!HamRadioDeluxeDatabase.ConnectToDatabase(Server, Port, User, Password, Database)) { WriteVerbose("Database open, checking for existing hrd table."); try { if (!HamRadioDeluxeDatabase.ExistsTableHrdContacts()) { WriteVerbose("Hrd table not found."); throw new TABLEHRDCONTACTSException("Could not find table : TABLE_HRD_CONTACTS_V01"); } } catch (TABLEHRDCONTACTSException ex) { WriteError(new ErrorRecord(ex, "Hrd Database Disconnected", ErrorCategory.ObjectNotFound, "TABLE_HRD_CONTACTS_V01")); HamRadioDeluxeDatabase.DisconnectFromDatabase(); } } }
protected override void ProcessRecord() { if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } WriteVerbose("Show database info."); HamRadioDeluxeDatabase.DatabaseInfo(); StringBuilder sb = new StringBuilder(); var version = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version; var modulename = System.Reflection.Assembly.GetExecutingAssembly().GetName().Name; sb.AppendLine("Module name (dll) : " + modulename); sb.Append("Module version : " + version.Major + "." + version.Minor + "." + version.Build + "." + version.Revision); //if (version.Build > 0) //{ // sb.Append(" [patch " + version.Build + "]"); // sb.Append("Revision " + version.Revision); // sb.Append(version.Build + "." + version.Revision); //} sb.AppendLine(); Console.WriteLine(); Console.Write(sb.ToString()); //WriteObject("jolo"); }
protected override void ProcessRecord() { if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } WriteVerbose("Fill the list."); HamRadioDeluxeDatabase.IndexDatabaseStatistics(); //WriteObject(new HrdUtils.HrdIndexObjectUtils //{ // INDEX_NAME = HrdUtils.HrdIndexen.INDEX_NAME, // INDEX_COLUMNS = HrdUtils.HrdIndexen.INDEX_COLUMNS, // CARDINALITY = HrdUtils.HrdIndexen.CARDINALITY //}); WriteVerbose("Reading list."); foreach (HRDProperties.HrdIndexObjects IndexList in HamRadioDeluxeDatabase.HrdIndexList) { WriteObject(new HRDProperties.HrdIndexObjects { INDEX_NAME = IndexList.INDEX_NAME, INDEX_COLUMNS = IndexList.INDEX_COLUMNS, CARDINALITY = IndexList.CARDINALITY }); // Console.WriteLine(IndexList.INDEX_NAME); // Console.WriteLine(IndexList.INDEX_COLUMNS); // Console.WriteLine(IndexList.CARDINALITY); } }
protected override void ProcessRecord() { if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } WriteVerbose("StartDate : '" + StartDate + "'"); object LowestDate = null; if (StartDate != "" && StartDate != null) { LowestDate = HamRadioDeluxeDatabase.ConvertToDate(StartDate); if (LowestDate == null) { WriteWarning("The entered StartDate (" + StartDate + ") is not the correct format (yyyyMMdd)."); return; } } WriteVerbose("EndDate : '" + EndDate + "'"); object HighestDate = null; if (EndDate != "" && EndDate != null) { HighestDate = HamRadioDeluxeDatabase.ConvertToDate(EndDate); if (LowestDate == null) { WriteWarning("The entered EndDate (" + EndDate + ") is not the correct format (yyyyMMdd)."); return; } } WriteVerbose("Fill the list."); HamRadioDeluxeDatabase.ReportYearBandMode(LowestDate, HighestDate); // todo https://stackoverflow.com/questions/29224905/powershell-output-formatting-from-c-sharp-using-defaultdisplaypropertyset //string[] DefaultProperties = { "Name", "Property2", "Property4" }; //base.WriteObject(SetDefaultProperties(myObject, DefaultProperties)); string[] DefaultProperties = { "YEAR", "BAND", "Property4" }; WriteVerbose("Reading list."); foreach (HRDProperties.ReportYearBandModeObjects YearBandModeList in HamRadioDeluxeDatabase.HrdYearBandModeList) { WriteObject(new HRDProperties.ReportYearBandModeObjects { YEAR = YearBandModeList.YEAR, BAND = YearBandModeList.BAND, MODE = YearBandModeList.MODE, SUBMODE = YearBandModeList.SUBMODE, WORKED = YearBandModeList.WORKED }, true); } }
protected override void ProcessRecord() { if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } WriteVerbose("Start Analyze Database."); HamRadioDeluxeDatabase.AnalyzeHrdTable(); }
protected override void ProcessRecord() { // Get-HrdSearch -Call pa3djy | Update-HrdQso if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } Boolean ToTitleCase = false; if (TitleCase) { ToTitleCase = true; } WriteVerbose("Start Update Qso."); RowsCounter = RowsCounter + HamRadioDeluxeDatabase.UpdateHrdOperator(Call, Operator, ToTitleCase); }
protected override void ProcessRecord() { if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } WriteVerbose("Fill the list."); HamRadioDeluxeDatabase.ReportBand(); WriteVerbose("Reading list."); foreach (HRDProperties.ReportBandObjects BandList in HamRadioDeluxeDatabase.HrdBandList) { WriteObject(new HRDProperties.ReportBandObjects { BAND = BandList.BAND, WORKED = BandList.WORKED }); } }
protected override void ProcessRecord() { WriteVerbose("Disconnecting Database."); HamRadioDeluxeDatabase.DisconnectFromDatabase(); //WriteObject("jolo"); }
static void Main(string[] args) { HamRadioDeluxeDatabase.ConnectToDatabase("192.168.64.200", 3307, "PA1REG", "dC7K68zUdGx6FKEu", "PA1REG"); HamRadioDeluxeDatabase //HamRadioDeluxeDatabase.ConnectToDatabase("localhost", 3307, "PA1REG", "MyPassword", "PA1REG"); //HamRadioDeluxeDatabase.DatabaseInfo(); //Console.ReadLine(); //// CsvUtils.ReadBandList(); // CsvUtils.ReadBandList(); //CsvUtils.CsvReaderQso(@"Z:\Repos\HamRadioLibrary\src\eQsl.ccWithComment.csv",true,true,false); //CsvUtils.AdiWriteQso(@"Z:\Repos\HamRadioLibrary\src\Test.Adi"); //string StartDate = "2011-05-02"; //DateTime postingDate = Convert.ToDateTime(StartDate); //object StDate = CheckDate("20031007"); //object EnDate = CheckDate("20070624"); //object LowestDate = HrdUtils.ConvertToDate("20110623"); //object HighestDate = HrdUtils.ConvertToDate("20151030"); //HrdUtils.ReportYearBandMode(LowestDate,HighestDate ); ////string FileName = @"Z:\Repos\HamRadioLibrary\src\Eqsl.ccInbox_25122020.adi"; //AdifUtils.AdifReadFile(FileName); //foreach (string AdifLine in AdifUtils.AdifArray) //{ // // Access your properties using item.NazivProizvoda, etc. here // var AdifElementsObj = AdifUtils.GetAllAdifElements(AdifLine); // if (AdifElementsObj.QSLMSG_INTL != null || AdifElementsObj.QSLMSG != null) // { // Console.Write(AdifElementsObj.CALL); // Console.Write(" : "); // //QSO_DATE = AdifElementsObj.QSO_DATE, // //TIME_ON = AdifElementsObj.TIME_ON, // //BAND = AdifElementsObj.BAND, // //MODE = AdifElementsObj.MODE, // //RST_SENT = AdifElementsObj.RST_SENT, // //RST_RCVD = AdifElementsObj.RST_RCVD, // //QSL_SENT = AdifElementsObj.QSL_SENT, // //QSL_SENT_VIA = AdifElementsObj.QSL_SENT_VIA, // //APP_EQSL_AG = AdifElementsObj.APP_EQSL_AG, // //GRIDSQUARE = AdifElementsObj.GRIDSQUARE, // //TIME_OFF = AdifElementsObj.TIME_OFF, // //STATION_CALLSIGN = AdifElementsObj.STATION_CALLSIGN, // //FREQ = AdifElementsObj.FREQ, // //CONTEST_ID = AdifElementsObj.CONTEST_ID, // //FREQ_RX = AdifElementsObj.FREQ_RX, // //OPERATOR = AdifElementsObj.OPERATOR, // //CQZ = AdifElementsObj.CQZ, // //STX = AdifElementsObj.STX, // //APP_N1MM_POINTS = AdifElementsObj.APP_N1MM_POINTS, // //APP_N1MM_RADIO_NR = AdifElementsObj.APP_N1MM_RADIO_NR, // //APP_N1MM_CONTINENT = AdifElementsObj.APP_N1MM_CONTINENT, // //APP_N1MM_RUN1RUN2 = AdifElementsObj.APP_N1MM_RUN1RUN2, // //APP_N1MM_RADIOINTERFACED = AdifElementsObj.APP_N1MM_RADIOINTERFACED, // //APP_N1MM_ISORIGINAL = AdifElementsObj.APP_N1MM_ISORIGINAL, // //APP_N1MM_NETBIOSNAME = AdifElementsObj.APP_N1MM_NETBIOSNAME, // //APP_N1MM_ISRUNQSO = AdifElementsObj.APP_N1MM_ISRUNQSO, // //APP_N1MM_ID = AdifElementsObj.APP_N1MM_ID, // //APP_N1MM_CLAIMEDQSO = AdifElementsObj.APP_N1MM_CLAIMEDQSO, // //SWL = AdifElementsObj.SWL, // //Console.Write(AdifElementsObj.QSLMSG_INTL); // if (AdifElementsObj.QSLMSG_INTL != null) { Console.Write(AdifElementsObj.QSLMSG_INTL); }; // Console.Write(" : "); // if (AdifElementsObj.QSLMSG != null) { Console.Write(AdifElementsObj.QSLMSG); }; // //QSLMSG = AdifElementsObj.QSLMSG, // //TX_PWR = AdifElementsObj.TX_PWR // Console.WriteLine(); // } //} //Console.ReadLine(); // Boolean a = CountryList.ReadCountryList(); //AdifUtils.AdifReadFile(".\test.adi"); ////The first step is to create a new instance of the PowerShell class //using (PowerShell powerShellInstance = PowerShell.Create()) //PowerShell.Create() creates an empty PowerShell pipeline for us to use for execution. //{ // // use "AddScript" to add the contents of a script file to the end of the execution pipeline. // // use "AddCommand" to add individual commands/cmdlets to the end of the execution pipeline. // powerShellInstance.AddScript("param($param1) $d = get-date; $s = 'test string value'; $d; $s; $param1; get-service"); // // use "AddParameter" to add a single parameter to the last command/script on the pipeline. // powerShellInstance.AddParameter("param1", "parameter 1 value!"); // //Result of the script with Invoke() // Collection<PSObject> result = powerShellInstance.Invoke(); // //output example : @{yourProperty=value; yourProperty1=value1; yourProperty2=StoppedDeallocated; PowerState=Stopped; OperationStatus=OK}} // foreach (PSObject r in result) // { // //access to values // //string r1 = r.Properties["yourProperty"].Value.ToString(); // Console.WriteLine(r.BaseObject.GetType().FullName); // Console.WriteLine(r.BaseObject.ToString() + "\n"); // } //} ////AdifUtils AdifElement = new AdifUtils(); ////string test = "<CALL:6>SV1PMR <QSO_DATE:8>20201024 <TIME_ON:6>062928<APP_N1MM_ID:32>82239d1b45a44d9eb5cc71118cdf7e7d"; ////string returntest = AdifUtils.GetAdifElement(test, "CALL"); ////string AdifLine = "<CALL:5>DK6JM<QSO_DATE:8:D>19980411<TIME_ON:4>1711<BAND:3>40M<MODE:3>SSB<RST_SENT:2>59<RST_RCVD:0><QSL_SENT:1>Y<QSL_SENT_VIA:1>E<APP_EQSL_AG:1>Y<GRIDSQUARE:6>jo31jg<EOR>"; ////var AdifElementsObj = AdifUtils.GetAllAdifElements(AdifLine); ////Console.WriteLine("CALL : {0} QSO_DATE : {1} TIME_ON : {2} BAND : {3} MODE : {4} RST_SENT : {5} RST_RCVD : {6} QSL__SENT : {7} QSL_SENT_VIA : {8} APP_EQSL_AG : {9} GRIDSQUARE : {10}",AdifElementsObj.CALL, AdifElementsObj.QSO_DATE, AdifElementsObj.TIME_ON, AdifElementsObj.BAND, AdifElementsObj.MODE,AdifElementsObj.RST_SENT, AdifElementsObj.RST_RCVD,AdifElementsObj.QSL_SENT, AdifElementsObj.QSL_SENT_VIA, AdifElementsObj.APP_EQSL_AG, AdifElementsObj.GRIDSQUARE ); //Console.WriteLine("end of exec"); //Console.ReadLine(); }
protected override void ProcessRecord() { if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } WriteVerbose("StartDate : '" + StartDate + "'"); object LowestDate = null; if (StartDate != "" && StartDate != null) { LowestDate = HamRadioDeluxeDatabase.ConvertToDate(StartDate); if (LowestDate == null) { WriteWarning("The entered StartDate (" + StartDate + ") is not the correct format (yyyyMMdd)."); return; } } WriteVerbose("EndDate : '" + EndDate + "'"); object HighestDate = null; if (EndDate != "" && EndDate != null) { HighestDate = HamRadioDeluxeDatabase.ConvertToDate(EndDate); if (LowestDate == null) { WriteWarning("The entered EndDate (" + EndDate + ") is not the correct format (yyyyMMdd)."); return; } } WriteVerbose("Fill the list."); HamRadioDeluxeDatabase.ReportQsoYearMode(LowestDate, HighestDate); WriteVerbose("Reading list."); foreach (HRDProperties.ReportYearModeProperty QsoYearModeList in HamRadioDeluxeDatabase.HrdQsoYearModeList) { WriteObject(new HRDProperties.ReportYearModeProperty { YEAR = QsoYearModeList.YEAR, AM = QsoYearModeList.AM, ARDOP = QsoYearModeList.ARDOP, ATV = QsoYearModeList.ATV, C4FM = QsoYearModeList.C4FM, CHIP = QsoYearModeList.CHIP, CLO = QsoYearModeList.CLO, CONTESTI = QsoYearModeList.CONTESTI, CW = QsoYearModeList.CW, DIGITALVOICE = QsoYearModeList.DIGITALVOICE, DOMINO = QsoYearModeList.DOMINO, DSTAR = QsoYearModeList.DSTAR, FAX = QsoYearModeList.FAX, FM = QsoYearModeList.FM, FSK441 = QsoYearModeList.FSK441, FT8 = QsoYearModeList.FT8, HELL = QsoYearModeList.HELL, ISCAT = QsoYearModeList.ISCAT, JT4 = QsoYearModeList.JT4, JT6M = QsoYearModeList.JT6M, JT9 = QsoYearModeList.JT9, JT44 = QsoYearModeList.JT44, JT65 = QsoYearModeList.JT65, MFSK = QsoYearModeList.MFSK, MSK144 = QsoYearModeList.MSK144, MT63 = QsoYearModeList.MT63, OLIVIA = QsoYearModeList.OLIVIA, OPERA = QsoYearModeList.OPERA, PAC = QsoYearModeList.PAC, PAX = QsoYearModeList.PAX, PKT = QsoYearModeList.PKT, PSK = QsoYearModeList.PSK, PSK2K = QsoYearModeList.PSK2K, Q15 = QsoYearModeList.Q15, QRA64 = QsoYearModeList.QRA64, ROS = QsoYearModeList.ROS, RTTY = QsoYearModeList.RTTY, RTTYM = QsoYearModeList.RTTYM, SSB = QsoYearModeList.SSB, SSTV = QsoYearModeList.SSTV, T10 = QsoYearModeList.T10, THOR = QsoYearModeList.THOR, THRB = QsoYearModeList.THRB, TOR = QsoYearModeList.TOR, V4 = QsoYearModeList.V4, VOI = QsoYearModeList.VOI, WINMOR = QsoYearModeList.WINMOR, WSPR = QsoYearModeList.WSPR, AMTORFEC = QsoYearModeList.AMTORFEC, ASCI = QsoYearModeList.ASCI, CHIP64 = QsoYearModeList.CHIP64, CHIP128 = QsoYearModeList.CHIP128, DOMINOF = QsoYearModeList.DOMINOF, FMHELL = QsoYearModeList.FMHELL, FSK31 = QsoYearModeList.FSK31, GTOR = QsoYearModeList.GTOR, HELL80 = QsoYearModeList.HELL80, HFSK = QsoYearModeList.HFSK, JT4A = QsoYearModeList.JT4A, JT4B = QsoYearModeList.JT4B, JT4C = QsoYearModeList.JT4C, JT4D = QsoYearModeList.JT4D, JT4E = QsoYearModeList.JT4E, JT4F = QsoYearModeList.JT4F, JT4G = QsoYearModeList.JT4G, JT65A = QsoYearModeList.JT65A, JT65B = QsoYearModeList.JT65B, JT65C = QsoYearModeList.JT65C, MFSK8 = QsoYearModeList.MFSK8, MFSK16 = QsoYearModeList.MFSK16, PAC2 = QsoYearModeList.PAC2, PAC3 = QsoYearModeList.PAC3, PAX2 = QsoYearModeList.PAX2, PCW = QsoYearModeList.PCW, PSK10 = QsoYearModeList.PSK10, PSK31 = QsoYearModeList.PSK31, PSK63 = QsoYearModeList.PSK63, PSK63F = QsoYearModeList.PSK63F, PSK125 = QsoYearModeList.PSK125, PSKAM10 = QsoYearModeList.PSKAM10, PSKAM31 = QsoYearModeList.PSKAM31, PSKAM50 = QsoYearModeList.PSKAM50, PSKFEC31 = QsoYearModeList.PSKFEC31, PSKHELL = QsoYearModeList.PSKHELL, QPSK31 = QsoYearModeList.QPSK31, QPSK63 = QsoYearModeList.QPSK63, QPSK125 = QsoYearModeList.QPSK125, THRBX = QsoYearModeList.THRBX }); } }
protected override void ProcessRecord() { //if (!HrdUtils.CheckDatabaseOpen()) { WriteWarning(MethodBase.GetCurrentMethod().DeclaringType.Name + " : You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."); return; } if (!HamRadioDeluxeDatabase.CheckDatabaseOpen()) { ThrowTerminatingError(new ErrorRecord(new Exception("You must call the Connect-HrdDatabase cmdlet before calling any other cmdlets."), "NotConnectedToDatabase", ErrorCategory.ConnectionError, this)); return; } WriteVerbose("Date : '" + Date + "'"); object SearchDate = null; if (Date != "" && Date != null) { SearchDate = HamRadioDeluxeDatabase.ConvertToDate(Date); if (SearchDate == null) { WriteWarning("The entered Date (" + Date + ") is not the correct format (yyyyMMdd)."); return; } } bool SwlInclude = false; if (IncludeSwl) { SwlInclude = true; } WriteVerbose("Search database."); if (HamRadioDeluxeDatabase.SearchDatabase(Call, Band, Mode, SearchDate, SwlInclude)) { // T.O.D.O. qso band mode // todo bevestigd qso // todo https://stackoverflow.com/questions/22639083/scripted-cmdlets-and-compiled-cmdlets-in-a-single-module // todo https://www.reddit.com/r/PowerShell/comments/9tb4oi/mixing_scripts_and_cmdlets_in_the_same_module/ //WriteObject("Call Found"); //HrdUtils.HrdFieldsObject HrdFields = new HrdUtils.HrdFieldsObject(); //HrdUtils.HrdFieldsObjectUtils test = new HrdUtils.HrdFieldsObjectUtils(); //WriteVerbose("Filling record."); //WriteObject(new HrdUtils.HrdFieldsObjects //{ // CALL = HrdUtils.HrdFields.CALL, // QSO_DATE = HrdUtils.HrdFields.QSO_DATE, // TIME_ON = HrdUtils.HrdFields.TIME_ON, // TIME_OFF = HrdUtils.HrdFields.TIME_OFF, // BAND = HrdUtils.HrdFields.BAND, // MODE = HrdUtils.HrdFields.MODE, // RST_SENT = HrdUtils.HrdFields.RST_RCVD, // RST_RCVD = HrdUtils.HrdFields.RST_SENT, // QSL_SENT = HrdUtils.HrdFields.QSL_SENT, // QSL_SENT_VIA = HrdUtils.HrdFields.QSL_SENT_VIA, // GRIDSQUARE = HrdUtils.HrdFields.GRIDSQUARE, // STATION_CALLSIGN = HrdUtils.HrdFields.STATION_CALLSIGN, // FREQ = HrdUtils.HrdFields.FREQ, // CONTEST_ID = HrdUtils.HrdFields.CONTEST_ID, // OPERATOR = HrdUtils.HrdFields.OPERATOR, // CQZ = HrdUtils.HrdFields.CQZ, // STX = HrdUtils.HrdFields.STX, // SWL = HrdUtils.HrdFields.SWL //}); WriteVerbose("Reading record."); foreach (HRDProperties.HrdFieldsObjects FieldList in HamRadioDeluxeDatabase.HrdFieldsList) { WriteObject(new HRDProperties.HrdFieldsObjects { CALL = FieldList.CALL, QSO_DATE = FieldList.QSO_DATE, TIME_ON = FieldList.TIME_ON, TIME_OFF = FieldList.TIME_OFF, BAND = FieldList.BAND, FREQ = FieldList.FREQ, MODE = FieldList.MODE, RST_SENT = FieldList.RST_RCVD, RST_RCVD = FieldList.RST_SENT, QSL_SENT = FieldList.QSL_SENT, QSL_SENT_VIA = FieldList.QSL_SENT_VIA, GRIDSQUARE = FieldList.GRIDSQUARE, STATION_CALLSIGN = FieldList.STATION_CALLSIGN, CONTEST_ID = FieldList.CONTEST_ID, OPERATOR = FieldList.OPERATOR, CQZ = FieldList.CQZ, STX = FieldList.STX, SWL = FieldList.SWL, KEY = FieldList.KEY }); } } }
static void Main(string[] args) { Console.WriteLine("Hello World!"); HamRadioDeluxeDatabase.ConnectToDatabase("192.168.64.200", 3307, "PA1REG", "dC7K68zUdGx6FKEu", "PA1REG"); HamRadioDeluxeDatabase.SearchDatabase("op4k", "", "", "", true); }