Tutorial C#: come leggere un report di Perfetto4

Esempio C#: esempio di instanziazione dei client dei servizi

 AppSession.BaseUrl = $"{protocol.Trim()}://{server.Trim()}:{port.Trim()}/{instance.Trim()}"; // Nella Solution i valori vengono presi dalla schermata di Login iniziale
 
 using var loginManagerClient = new MicroareaLoginManagerSoapClient(
                      MicroareaLoginManagerSoapClient.EndpointConfiguration.MicroareaLoginManagerSoap,
                      $"{AppSession.BaseUrl.TrimEnd('/')}/LoginManager/LoginManager.asmx");
 
 using var tbServicesClient = new TbServicesSoapClient(
                      TbServicesSoapClient.EndpointConfiguration.TbServicesSoap,
                      $"{AppSession.BaseUrl.TrimEnd('/')}/TbServices/TbServices.asmx");

Esempio C#: logica di connessione al server e login ad un'azienda

//--------------------------------------------------------------------------
private async void buttonConnect_Click(object? sender, EventArgs e)
{
    string protocol = comboBoxProtocol.SelectedItem?.ToString() ?? "http";
    string server = textBoxServer.Text;
    string port = string.IsNullOrWhiteSpace(textBoxPort.Text) ? "80" : textBoxPort.Text;
    string instance = textBoxInstanceFolder.Text;

    toolStripStatusLoginConnectedColor.BackColor = Color.Orange;
    toolStripStatusLoginConnectedLabel.Text = "Connecting...";
    Cursor.Current = Cursors.WaitCursor;

    var result = await _connectionService.TestConnectionAsync(protocol, server, port, instance);

    if (result.Success)
    {
        AppSession.BaseUrl = $"{protocol.Trim()}://{server.Trim()}:{port.Trim()}/{instance.Trim()}";
        groupBoxLogin.Enabled = true;
        LoadCompanies(false);

        Cursor.Current = Cursors.Default;
        toolStripStatusLoginConnectedColor.BackColor = Color.Green;
        toolStripStatusLoginConnectedLabel.Text = "Connected    ";
        MessageBox.Show(result.Message, "Connected    ", MessageBoxButtons.OK, MessageBoxIcon.Information);

        groupBoxConnection.Enabled = false;
        buttonDisconnect.Enabled = true;
    }
    else
    {
        groupBoxLogin.Enabled = false;
        Cursor.Current = Cursors.Default;
        MessageBox.Show(result.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
}

//--------------------------------------------------------------------------
private void buttonLogin_Click(object? sender, EventArgs e)
{
    Cursor.Current = Cursors.WaitCursor;

    if (!groupBoxLogin.Enabled)
    {
        MessageBox.Show("Connect first.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
        return;
    }

    if (string.IsNullOrWhiteSpace(textBoxUser.Text) || string.IsNullOrWhiteSpace(textBoxPwd.Text))
    {
        MessageBox.Show("Username and password are required.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
        return;
    }

    AppSession.Username = textBoxUser.Text.Trim();
    Password = textBoxPwd.Text.Trim();
    AppSession.ProducerKey = textBoxProducerKey.Text.Trim();

    if (!PerformLogin())
        return;

    Cursor.Current = Cursors.Default;

    DialogResult = DialogResult.OK;
    Close();
}

//--------------------------------------------------------------------------
private bool PerformLogin()
{
    string authToken = string.Empty;
    if (string.IsNullOrEmpty(textBoxUser.Text) || string.IsNullOrEmpty(comboBoxCompany.Text))
    {
        MessageBox.Show("Select a company.");
        return false;
    }

    string user = textBoxUser.Text;
    string company = comboBoxCompany.Text;

    using var client = new MicroareaLoginManagerSoapClient(
        MicroareaLoginManagerSoapClient.EndpointConfiguration.MicroareaLoginManagerSoap,
        $"{AppSession.BaseUrl.TrimEnd('/')}/LoginManager/LoginManager.asmx");

    int result = client.LoginCompact(ref user, ref company, Password, AppSession.ProducerKey, false, out authToken);

    if (result == 14)
    {
        var force = MessageBox.Show(
            "Session already exists. Do you want to force the login?",
            "Simultaneous login",
            MessageBoxButtons.YesNo,
            MessageBoxIcon.Warning);

        if (force == DialogResult.Yes)
        {
            result = client.LoginCompact(ref user, ref company, Password, AppSession.ProducerKey, true, out authToken);
        }
    }

    if (result == 0)
    {
        AppSession.AuthenticationToken = authToken;
        AppSession.Company = company;
        AppSession.Username = textBoxUser.Text;
        AppSession.ProducerKey = textBoxProducerKey.Text.Trim();
        return true;
    }

    MessageBox.Show($"Failed login. Code: {result}", "Login Failed", MessageBoxButtons.OK, MessageBoxIcon.Error);
    return false;
}

public class Employee
{
    public string Code { get; set; } = null!;
    public string Name { get; set; } = null!;
    public string Hours { get; set; } = null!;
}

 ...
 try
 {
        string easyLookUrl = $"{AppSession.BaseUrl.TrimEnd('/')}/EasyLook/EasyLookService.asmx";
        AppendLog2($"Endpoint EasyLook: {easyLookUrl}");
        AppendLog2($"Request XML:{Environment.NewLine}{repParams}");

        using var aEasyLook = new EasyLookServiceSoapClient(
            EasyLookServiceSoapClient.EndpointConfiguration.EasyLookServiceSoap,
            easyLookUrl);

        DateTime applicationDate = DateTime.Now;
        Stopwatch sw = Stopwatch.StartNew();

        EasyLookService.ArrayOfString getDataTextResult = aEasyLook.XmlExecuteReport(
            AppSession.AuthenticationToken,
            repParams,
            applicationDate,
            "Standard",
            false);

        sw.Stop();
        AppendLog2($"XmlExecuteReport completato in {sw.ElapsedMilliseconds} ms.");

        if (getDataTextResult == null || getDataTextResult.Count == 0)
        {
            AppendLog2("Nessuna risposta ricevuta da XmlExecuteReport.");
            MessageBox.Show("Nessuna risposta ricevuta da XmlExecuteReport.");
            return;
        }

        string xmlReport = getDataTextResult[0];

        if (string.IsNullOrWhiteSpace(xmlReport))
        {
            AppendLog2("XML report vuoto.");
            return;
        }

        AppendLog2($"Lunghezza XML report: {xmlReport.Length} caratteri.");

        var emplList = new List<Data.Employee>();
        var emplMap = new Dictionary<string, int>();

        var doc = new XmlDocument();
        doc.LoadXml(xmlReport);

        var xmlNsManager = new XmlNamespaceManager(doc.NameTable);
        xmlNsManager.AddNamespace("maxs", xmlNs);

        var rows = doc.SelectNodes("//maxs:EmployeeHoursByJob/maxs:ReportData/maxs:Table15/maxs:Row", xmlNsManager);
        int rowsCount = rows?.Count ?? 0;
        AppendLog2($"Righe trovate nel report: {rowsCount}");

        if (rows != null)
        {
            foreach (XmlNode node in rows)
            {
                string code = node.SelectSingleNode("maxs:Dipendente", xmlNsManager)?.InnerText ?? string.Empty;
                string name = node.SelectSingleNode("maxs:Nome", xmlNsManager)?.InnerText ?? string.Empty;
                string totSecondsText = node.SelectSingleNode("maxs:OTotale", xmlNsManager)?.InnerText ?? "0";

                int.TryParse(totSecondsText, out int totalSeconds);

                if (emplMap.ContainsKey(code))
                {
                    emplMap[code] += totalSeconds;
                }
                else
                {
                    emplMap.Add(code, totalSeconds);
                    emplList.Add(new Data.Employee { Code = code, Name = name });
                }
            }
        }

        foreach (var empl in emplList)
        {
            if (emplMap.TryGetValue(empl.Code, out int mapValue))
            {
                int nH = mapValue / 3600;
                int nM = (mapValue % 3600) / 60;
                empl.Hours = $"{nH}:{nM:00}";
            }
        }

        dataGridViewChartHours.Rows.Clear();
        dataGridViewChartHours.Columns.Clear();
        dataGridViewChartHours.AutoGenerateColumns = false;

        dataGridViewChartHours.Columns.Add("Code", "Codice dipendente");
        dataGridViewChartHours.Columns.Add("Name", "Nome dipendente");
        dataGridViewChartHours.Columns.Add("Hours", "Ore");

        foreach (var empl in emplList)
        {
            dataGridViewChartHours.Rows.Add(empl.Code, empl.Name, empl.Hours);
        }

        AppendLog2($"DataGrid popolata con {emplList.Count} dipendenti.");
    }
    catch (Exception ex)
    {
        AppendLog2($"EXCEPTION: {ex.GetType().Name} - {ex.Message}");
        MessageBox.Show($"Exception caught in XmlExecuteReport: {ex.Message}");
    }
}

private void LogoutCurrentUser()
{
    try
    {
        if (!string.IsNullOrEmpty(AppSession.AuthenticationToken))
        {
            using var client = new MicroareaLoginManagerSoapClient(
                                        MicroareaLoginManagerSoapClient.EndpointConfiguration.MicroareaLoginManagerSoap,
                                        $"{AppSession.BaseUrl.TrimEnd('/')}/LoginManager/LoginManager.asmx");
            client.LogOff(AppSession.AuthenticationToken);
        }
    }
    catch { }
}