namespace SwDAL.DTO.SavedQuery;

public class SavedQueryDTO
{
    public int      SavedQueryId  { get; set; }
    public string   QueryName     { get; set; } = string.Empty;
    public string?  Description   { get; set; }
    public string   QueryText     { get; set; } = string.Empty;
    public bool     IsShared      { get; set; }
    public int?     DbServerId    { get; set; }
    public int      TenantId      { get; set; }
    public int      Version       { get; set; }
    public byte     Status        { get; set; }
    public int      CreatedById   { get; set; }
    public DateTime CreatedOn     { get; set; }
    public int      ModifiedById  { get; set; }
    public DateTime ModifiedOn    { get; set; }
}

public class SavedQueryListDTO
{
    public int     SavedQueryId { get; set; }
    public string  QueryName    { get; set; } = string.Empty;
    public string? Description  { get; set; }
    public bool    IsShared     { get; set; }
    public int?    DbServerId   { get; set; }
    public DateTime CreatedOn   { get; set; }
}

public class SavedQueryListCriteria
{
    public bool?  IsShared    { get; set; }
    public int?   DbServerId  { get; set; }
    public string? SearchText { get; set; }
}