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

namespace FrameworkDAL.Query.Project
{
    public class ProjectQB
    {
        public const string GET_PROJECT = @"
                                       SELECT 
                                        P.PROJECTID      AS ProjectId,
                                        P.PROJECTCODE    AS ProjectCode,
                                        P.PROJECTNAME    AS ProjectName,
                                        P.IMAGEID        AS ImageId,
                                        P.REMARKS        AS ProjectRemarks,
                                        P.SORTORDER      AS ProjectSortOrder,
                                        P.STATUS         AS ProjectStatus,
                                        P.VERSION        AS ProjectVersion,
                                        P.SOURCETYPE     AS ProjectSourceType,
                                        P.CREATEDBYID    AS ProjectCreatedById,
                                        P.CREATEDON      AS ProjectCreatedOn,
                                        P.MODIFIEDBYID   AS ProjectModifiedById,
                                        P.MODIFIEDON     AS ProjectModifiedOn
                                    FROM MPROJECT P
                                    WHERE P.PROJECTID= @projectid;";


        public const string SAVE_PROJECT = @"INSERT INTO MPROJECT 
                                        (
                                            PROJECTID,
                                            PROJECTCODE,
                                            PROJECTNAME,
                                            IMAGEID,
                                            REMARKS,
                                            SORTORDER,
                                            STATUS,
                                            VERSION,
                                            SOURCETYPE,
                                            CREATEDBYID,
                                            CREATEDON,
                                            MODIFIEDBYID,
                                            MODIFIEDON
                                        )
                                        VALUES
                                        (
                                            @ProjectId,
                                            @ProjectCode,
                                            @ProjectName,
                                            @ImageId,
                                            @ProjectRemarks,
                                            @ProjectSortOrder,
                                            @ProjectStatus,
                                            @ProjectVersion,
                                            @ProjectSourceType,
                                            @ProjectCreatedById,
                                            @ProjectCreatedOn,
                                            @ProjectModifiedById,
                                            @ProjectModifiedOn
                                        );";


        public const string UPDATE_PROJECT = @"
                                   UPDATE MPROJECT
                                    SET 
                                        PROJECTCODE   = @ProjectCode,
                                        PROJECTNAME   = @ProjectName,
                                        IMAGEID       = @ImageId,
                                        REMARKS       = @ProjectRemarks,
                                        SORTORDER     = @ProjectSortOrder,
                                        STATUS        = @ProjectStatus,
                                        VERSION       = @ProjectVersion,
                                        SOURCETYPE    = @ProjectSourceType,
                                        MODIFIEDBYID  = @ProjectModifiedById,
                                        MODIFIEDON    = @ProjectModifiedOn
                                    WHERE PROJECTID = @ProjectId;";

        public const string GET_SELECTLIST_PROJECT = @"SELECT 
                                    ProjectId AS Id,
                                    ProjectName AS Name
                                FROM 
                                    MPROJECT
                                WHERE 
                                    Status = 1
                                ORDER BY 
                                    ProjectName;";

        public const string DELETE_PROJECT = @"
                                            DELETE FROM MPROJECT 
                                            WHERE PROJECTID = @ProjectId;";
    }
}