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

namespace DMSDAL.Query.Project
{
    public class ProjectQB
    {
        public const string GET_PROJECT = @"SELECT
                                            SPACEPROJECTID          AS SpaceProjectId,
                                            SPACEPROJECTNAME        AS SpaceProjectName,
                                            SPACEPROJECTDESCRIPTION AS SpaceProjectDescription,
                                            SPACEID                 AS SpaceId,
                                            STARTDATE               AS ProjectStartDate,
                                            ENDDATE                 AS ProjectEndDate,
                                            SPACEPROJECTSTATUS      AS SpaceProjectStatus,
                                            CREATEDBYID             AS ProjectCreatedById,
                                            CREATEDON               AS ProjectCreatedOn,
                                            MODIFIEDBYID            AS ProjectModifiedById,
                                            MODIFIEDON              AS ProjectModifiedOn,
                                            SORTORDER               AS ProjectSortOrder,
                                            STATUS                  AS Status,
                                            VERSION                 AS Version,
                                            SOURCETYPE              AS SourceType,
                                            TENANTID                AS TenantId
                                        FROM MSPACEPROJECT
                                        WHERE SPACEPROJECTID = @spaceprojectid;;";

        public const string SAVE_PROJECT = @"INSERT INTO MSPACEPROJECT 
                                                (
                                                    SPACEPROJECTID,
                                                    SPACEPROJECTNAME,
                                                    SPACEPROJECTDESCRIPTION,
                                                    SPACEID,
                                                    STARTDATE,
                                                    ENDDATE,
                                                    SPACEPROJECTSTATUS,
                                                    CREATEDBYID,
                                                    CREATEDON,
                                                    MODIFIEDBYID,
                                                    MODIFIEDON,
                                                    SORTORDER,
                                                    STATUS,
                                                    VERSION,
                                                    SOURCETYPE,
                                                    TENANTID
                                                )
                                                VALUES
                                                (
                                                    @SpaceProjectId,
                                                    @SpaceProjectName,
                                                    @SpaceProjectDescription,
                                                    @SpaceId,
                                                    @ProjectStartDate,
                                                    @ProjectEndDate,
                                                    @SpaceProjectStatus,
                                                    @ProjectCreatedById,
                                                    @ProjectCreatedOn,
                                                    @ProjectModifiedById,
                                                    @ProjectModifiedOn,
                                                    @ProjectSortOrder,
                                                    @Status,
                                                    @Version,
                                                    @SourceType,
                                                    @TenantId
                                                );";

        public const string UPDATE_PROJECT = @"UPDATE MSPACEPROJECT
                                            SET
                                                SPACEPROJECTNAME        = @SpaceProjectName,
                                                SPACEPROJECTDESCRIPTION = @SpaceProjectDescription,
                                                SPACEID                 = @SpaceId,
                                                STARTDATE               = @ProjectStartDate,
                                                ENDDATE                 = @ProjectEndDate,
                                                SPACEPROJECTSTATUS      = @SpaceProjectStatus,
                                                MODIFIEDBYID            = @ProjectModifiedById,
                                                MODIFIEDON              = @ProjectModifiedOn,
                                                SORTORDER               = @ProjectSortOrder,
                                                STATUS                  = @Status,
                                                VERSION                 = @Version,
                                                SOURCETYPE              = @SourceType,
                                                TENANTID                = @TenantId
                                            WHERE SPACEPROJECTID        = @SpaceProjectId;";

        public const string DELETE_PROJECT = @"DELETE FROM MSPACEPROJECT
                                            WHERE SPACEPROJECTID = @spaceprojectid;";
    }
}