This is my blog for storing and sharing my programming knowledge with all other programmers

 https://www.linkedin.com/pulse/fix-permission-kill-database-connection-supported-sql-silva-rossi-dzcaf

     MarkupTransHistory _markupTransHistory;     Query query;     QueryRun queryRun;     QueryBuildDataSource queryBuildDataSource;     QueryBuildRange queryBuildRangeTableId,queryBuildRangeRecId;     select _purchLine     where  _purchLine.LineNumber == _vendPurchLineAllVersions.LineNumber  &&    _purchLine.PurchId == _vendPurchLineAllVersions.PurchId;     query = new Query();     query.validTimeStateAsOfDateTime(_vendPurchLineAllVersions.VersionDateTime);     queryBuildDataSource = query.addDataSource(tableNum(markupTransHistory));     query.validTimeStateAsOfDateTime(_vendPurchLineAllVersions.VersionDateTime);     queryBuildRangeTableId = queryBuildDataSource.addRange(fieldNum(markupTransHistory,TransTableId));     queryBuildRangeTableId.value(queryValue(_purchLine.TableId));     queryBuildRangeRecId = queryBuildD...

 internal final class BankstatmentRunnableClass {     // Define constants for tag names     #define.Tag20(":20:")     #define.Tag25(":25:")     #define.Tag28C(":28C:")     #define.Tag60F(":60F:")     #define.Tag60M(":60M:")     #define.Tag61(":61:")     #define.Tag62F(":62F:")     #define.Tag62M(":62M:")     #define.Tag64(":64:")     #define.Tag65(":65:")     #define.Tag86(":86:")     private static utcdatetime ExtractDateline( str dateStr)     {         utcdatetime statementdate;                  // Extract date                  int year = 2000 + str2Int(subStr(dateStr, 1, 2)); // 24 → 2024         int month = str2Int(subStr(dateStr, 3, 2));       // 12         int day = str2I...

 internal final class BI_CustInvoiceJournal_EventHandler {     /// <summary>     ///     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>     [FormEventHandler(formStr(CustInvoiceJournal), FormEventType::Activated)]     public static void CustInvoiceJournal_OnActivated(xFormRun sender, FormEventArgs e)     {         //BI_invoicePrint         //ReportButtonGroup        // FormRun formRun = sender.formRun();         FormButtonGroupControl buttonGroup = sender.design().controlName(formControlStr(CustInvoiceJournal, BI_invoicePrint)) as FormButtonGroupControl;         FormButtonGroupControl ReportbuttonGroup = sender.design().controlName(formControlStr(CustInvoiceJournal, ReportButtonGroup)) as FormButtonGroupControl;     ...

  //private void fillByteArrayQRData(int _tag, int _length, System.Byte[] _byteArrStr)  //{  //    int i;  //    byteArray.set_Item(CurarrIndex, System.Convert::ToByte(_tag));  //    CurarrIndex++;  //    byteArray.set_Item(CurarrIndex, System.Convert::ToByte(_length));  //    CurarrIndex++;  //    for (i = 0; i < CLRInterop::getAnyTypeForObject(_byteArrStr.get_Length()); i++)  //    {  //        byteArray.set_Item(CurarrIndex, _byteArrStr.get_Item(i));  //        CurarrIndex++;  //    }  //}  //display container qrcode( CustInvoiceJour _custInvoiceJour)  //{  //    Bindata bindata = new Bindata();  //    Filename                filename;  //    container               ...

  public static Bitmap generateQRCodeFromBase64(str qrCodeText)  {      System.Drawing.Bitmap result;      QRCodeGenerator.ECCLevel eccLevel;      QRCodeGenerator qrGenerator = new QRCodeGenerator();      QRCodeData qrCodeData = qrGenerator.CreateQrCode(qrCodeText, QRCodeGenerator.ECCLevel::M);      QRCode qrCode = new QRCode(qrCodeData);      result = qrCode.GetGraphic(20);      System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();      result.Save(memoryStream, System.Drawing.Imaging.ImageFormat::get_Png());      return Binary::constructFromMemoryStream(memoryStream).getContainer();  }