using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace AdminDAL.Query.Division
{
    public class DivisionQB
    {
        public const string GET_DIVISION = @"SELECT
                            D.DIVISIONID AS DivisionId,
                            D.DIVISIONCODE AS DivisionCode,
                            D.DIVISIONNAME AS DivisionName,
                            D.DIVISIONSHORTNAME AS DivisionShortName,
                            D.SORTORDER AS  DivisionSortOrder,
                            D.STATUS AS DivisionStatus,
                            D.VERSION AS DivisionVersion,
                            D.CREATEDBYID AS DivisionCreatedById,
                            D.CREATEDON AS DivisionCreatedOn,
                            D.MODIFIEDBYID AS DivisionModifiedById,
                            D.MODIFIEDON AS DivisionModifiedOn,
                            D.SOURCETYPE AS SourceType,
                            D.TENANTID AS TenantId,
                            D.DEPARTMENTHEADID AS DepartmentHeadId
                            FROM MDIVISION D
                            WHERE D.DIVISIONID = @divisionid;";

        public const string GET_SELECTLIST_DIVISION= @"SELECT
                            DIVISIONID AS Id,
                            DIVISIONCODE AS Code,
                            DIVISIONNAME AS Name,
                            DIVISIONSHORTNAME AS ShortName
                            FROM MDIVISION";

        public const string SAVE_DIVISION = @"INSERT INTO MDIVISION (
                                DIVISIONID,
                                DIVISIONCODE,
                                DIVISIONNAME,
                                DIVISIONSHORTNAME,
                                STATUS,
                                VERSION,
                                CREATEDBYID,
                                CREATEDON,
                                MODIFIEDBYID,
                                MODIFIEDON
                            )
                            VALUES (
                            @DivisionId,
                            @DivisionCode,
                            @DivisionName,
                            @DivisionShortName,
                            @DivisionStatus,
                            @DivisionVersion,
                            @DivisionCreatedById,
                            @DivisionCreatedOn,
                            @DivisionModifiedById,
                            @DivisionModifiedOn);";


        public const string UPDATE_DIVISION = @"UPDATE MDIVISION SET
                                DIVISIONID = @DivisionId,
                                DIVISIONCODE = @DivisionCode,
                                DIVISIONNAME = @DivisionName,
                                DIVISIONSHORTNAME = @DivisionShortName,
                                STATUS = @DivisionStatus,
                                VERSION = @DivisionVersion,
                                MODIFIEDBYID = @DivisionModifiedById,
                                MODIFIEDON = @DivisionModifiedOn,
                                WHERE DIVISIONID = @DivisionId;";


        public const string DELETE_DIVISION = @"DELETE FROM MDIVISION
                                WHERE DIVISIONID = @divisionid;";   
    }
}