using AdminDAL.DTO.FormTemplate;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;

namespace AdminDAL.CustomCode.FormTemplate
{
    public interface IFormTemplateDAL
    {
        Task<string> GetFormTemplate(int FormTemplateId, LoginDTO LoginDTO, CancellationToken ct);

        Task<FormTemplateDTO?> GetFormTemplateByCode(string FormTemplateCode, LoginDTO LoginDTO, CancellationToken ct);

        Task<string> GetSelectListFormTemplate(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, CancellationToken ct);

        Task<int> SaveFormTemplate(FormTemplateDTO FormTemplateDTO, LoginDTO LoginDTO, CancellationToken ct);

        Task UpdateFormTemplate(FormTemplateDTO FormTemplateDTO, LoginDTO LoginDTO, CancellationToken ct);

        Task<string> DeleteFormTemplate(int FormTemplateId, LoginDTO LoginDTO, CancellationToken ct);

        // Creates D_<FormTemplateCode> the first time a "Dynamic Table" (genericTable) form is
        // saved, and adds any newly-authored fields as columns on later saves. Every identifier
        // (table name, column name) is validated via DynamicTableSqlHelper before use — see that
        // file's header for why (the legacy GB4 equivalent has a real SQL-injection hole here).
        Task CreateOrAlterDynamicTable(FormTemplateDTO FormTemplateDTO, LoginDTO LoginDTO, CancellationToken ct);
    }
}