using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Gapso.GAPP.Config.Lib.DB;
using Gapso.GAPP.Commons.Config.Resources;
using PROResources = Gapso.GAPP.CustomApplication.Resources;
using Gapso.GAPP.Config.Builders;
using Gapso.GAPP.Config;
using Align = Gapso.GAPP.Config.Builders.Section.Columns.Column.Format.Align;
using Type = Gapso.GAPP.Config.Builders.Section.Columns.Column.Field.Type;
using TriggedFieldType = Gapso.GAPP.Config.Builders.Section.Columns.Column.Field.TriggedFieldType;
using Gapso.GAPP.Commons.Config.Builders;

namespace Gapso.GAPP.CustomApplication.Config
{
    public static class SectionMasterModal
    {
        public static Section GetSectionMasterModal()
        {
            return Section.Create("modal")
                .Titles(Section.Titles.Create()
                    .Index("Modal Master")
                    .SubIndex(":")
                    .Create("Novo Registro")
                    .Edit("Editar Registro"))
                .Menu("Modais")
                .Sqls(Section.Sqls.Create()
                    .List(@"SELECT id, codigo, descricao
                             FROM dbo.modal
                             WHERE scenario_id = @masterDataId
                             ORDER BY codigo ASC;")
                    .Remove("DELETE FROM dbo.modal WHERE id = @id AND scenario_id = @masterDataId;")
                    .Form(@"SELECT id, codigo, descricao
                            FROM dbo.modal
                            WHERE id = @id AND scenario_id = @masterDataId;")
                    .Update("UPDATE modal SET descricao = @descricao WHERE id = @id AND scenario_id = @masterDataId;")
                    .Insert("INSERT INTO modal (codigo,descricao) VALUES (@codigo,@descricao);"))

                .Columns(Section.Columns.Create()
                    .Column(GSCPColumns.Id())
                    .Column(GSCPColumns.generalCreation("codigo", "Modal", Type.STRING, Align.CENTER, "", "", TriggedFieldType.NULL, "", true))
                    .Column(GSCPColumns.generalCreation("descricao", "Descrição", Type.STRING, Align.CENTER, "", "", TriggedFieldType.NULL, "", true))
                    );
        }

    }
}