namespace SwDAL.DTO.QueryHistory;

public class QueryHistoryDTO
{
    public int      QueryHistoryId { get; set; }
    public string   QueryText      { get; set; } = string.Empty;
    public int?     SavedQueryId   { get; set; }
    public int      RowsReturned   { get; set; }
    public int      ExecutionMs    { get; set; }
    public bool     IsSuccess      { get; set; }
    public string?  ErrorMessage   { get; set; }
    public int      ExecutedById   { get; set; }
    public DateTime ExecutedOn     { get; set; }
    public int      TenantId       { get; set; }
}

public class QueryHistoryListCriteria
{
    public int?    SavedQueryId { get; set; }
    public bool?   IsSuccess    { get; set; }
    public string? SearchText   { get; set; }
}

public class QueryHistoryInsertDTO
{
    public string   QueryText    { get; set; } = string.Empty;
    public int?     SavedQueryId { get; set; }
    public int      RowsReturned { get; set; }
    public int      ExecutionMs  { get; set; }
    public bool     IsSuccess    { get; set; }
    public string?  ErrorMessage { get; set; }
}