unit uFrmConfigDB;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.UITypes, System.Classes,
  Vcl.Graphics, Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Vcl.ExtCtrls,
  uSecurityCrypto, uDMMain;

type
  TfrmConfigDB = class(TForm)
    pnlHeader: TPanel;
    lblTitulo: TLabel;
    lblSubtitulo: TLabel;
    grpServer: TGroupBox;
    lblHost: TLabel;
    lblPort: TLabel;
    lblDatabase: TLabel;
    lblUsername: TLabel;
    lblPassword: TLabel;
    lblVendorLib: TLabel;
    edtHost: TEdit;
    edtPort: TEdit;
    edtDatabase: TEdit;
    edtUsername: TEdit;
    edtPassword: TEdit;
    chkMostrarPassword: TCheckBox;
    edtVendorLib: TEdit;
    btnBuscarLib: TButton;
    grpSeguridad: TGroupBox;
    lblInactividad: TLabel;
    lblArchivoCifrado: TLabel;
    lblHuellaSHA256: TLabel;
    edtInactividad: TEdit;
    chkModoPrivacidad: TCheckBox;
    edtArchivoCifrado: TEdit;
    edtHuellaSHA256: TEdit;
    pnlFooter: TPanel;
    lblEstadoConexion: TLabel;
    btnProbar: TButton;
    btnGuardar: TButton;
    btnCancelar: TButton;
    OpenDialogLib: TOpenDialog;
    procedure FormShow(Sender: TObject);
    procedure chkMostrarPasswordClick(Sender: TObject);
    procedure btnBuscarLibClick(Sender: TObject);
    procedure btnProbarClick(Sender: TObject);
    procedure btnGuardarClick(Sender: TObject);
  private
    function BuildConfigFromUI: TDBConnectionConfig;
    procedure RefreshCryptoFingerprint;
  public
  end;

implementation

{$R *.dfm}

procedure TfrmConfigDB.FormShow(Sender: TObject);
var
  LCfg: TDBConnectionConfig;
begin
  LCfg := dmMain.Config;
  edtHost.Text := LCfg.Host;
  edtPort.Text := IntToStr(LCfg.Port);
  edtDatabase.Text := LCfg.Database;
  edtUsername.Text := LCfg.Username;
  edtPassword.Text := LCfg.Password;
  edtVendorLib.Text := LCfg.VendorLib;
  edtInactividad.Text := IntToStr(LCfg.InactivityMinutes);
  chkModoPrivacidad.Checked := LCfg.PrivacyMaskDefault;
  RefreshCryptoFingerprint;
end;

procedure TfrmConfigDB.RefreshCryptoFingerprint;
begin
  edtArchivoCifrado.Text := dmMain.ConfigFilePath;
  edtHuellaSHA256.Text := TSecurityCrypto.GetFileSHA256Hex(dmMain.ConfigFilePath);
end;

function TfrmConfigDB.BuildConfigFromUI: TDBConnectionConfig;
begin
  Result.Host := Trim(edtHost.Text);
  Result.Port := StrToIntDef(Trim(edtPort.Text), 3306);
  Result.Database := Trim(edtDatabase.Text);
  Result.Username := Trim(edtUsername.Text);
  Result.Password := edtPassword.Text;
  Result.VendorLib := Trim(edtVendorLib.Text);
  Result.InactivityMinutes := StrToIntDef(Trim(edtInactividad.Text), 10);
  if Result.InactivityMinutes < 1 then
    Result.InactivityMinutes := 10;
  Result.PrivacyMaskDefault := chkModoPrivacidad.Checked;
end;

procedure TfrmConfigDB.chkMostrarPasswordClick(Sender: TObject);
begin
  if chkMostrarPassword.Checked then
    edtPassword.PasswordChar := #0
  else
    edtPassword.PasswordChar := '*';
end;

procedure TfrmConfigDB.btnBuscarLibClick(Sender: TObject);
begin
  if edtVendorLib.Text <> '' then
    OpenDialogLib.FileName := edtVendorLib.Text;
  if OpenDialogLib.Execute then
    edtVendorLib.Text := OpenDialogLib.FileName;
end;

procedure TfrmConfigDB.btnProbarClick(Sender: TObject);
var
  LCfg: TDBConnectionConfig;
  LInfo, LErr: string;
begin
  LCfg := BuildConfigFromUI;
  Screen.Cursor := crHourGlass;
  try
    if dmMain.TestConnectionConfig(LCfg, LInfo, LErr) then
    begin
      lblEstadoConexion.Font.Color := $00287D1E;
      lblEstadoConexion.Caption := 'Conexión verificada correctamente';
      MessageDlg('Conexión exitosa con la base de datos clínica Santías Salud:' + sLineBreak + sLineBreak + LInfo,
        mtInformation, [mbOK], 0);
    end
    else
    begin
      lblEstadoConexion.Font.Color := clRed;
      lblEstadoConexion.Caption := 'Error al conectar con el servidor';
      MessageDlg('No se pudo conectar con la base de datos:' + sLineBreak + LErr,
        mtError, [mbOK], 0);
    end;
  finally
    Screen.Cursor := crDefault;
  end;
end;

procedure TfrmConfigDB.btnGuardarClick(Sender: TObject);
var
  LCfg: TDBConnectionConfig;
  LErr: string;
begin
  LCfg := BuildConfigFromUI;
  if (LCfg.Host = '') or (LCfg.Database = '') or (LCfg.Username = '') then
  begin
    MessageDlg('Por favor complete Servidor, Base de Datos y Usuario.', mtWarning, [mbOK], 0);
    Exit;
  end;

  Screen.Cursor := crHourGlass;
  try
    dmMain.SaveAndApplyConfig(LCfg);
    RefreshCryptoFingerprint;
    if dmMain.ConnectDatabase(LErr) then
    begin
      dmMain.RegistrarAuditoria(ACCION_CONFIG_SEGURIDAD,
        Format('CFG_CIFRADA HOST=%s DB=%s SHA256=%s',
          [LCfg.Host, LCfg.Database, Copy(edtHuellaSHA256.Text, 1, 16)]));
      ModalResult := mrOk;
    end
    else
    begin
      MessageDlg('Configuración cifrada guardada en disco, pero falló la conexión activa:' +
        sLineBreak + LErr, mtWarning, [mbOK], 0);
    end;
  finally
    Screen.Cursor := crDefault;
  end;
end;

end.
