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

namespace MMDAL.Query.MachineType
{
    public class MachineTypeQB
    {
        public const string GET_MACHINETYPE = @"SELECT
                                                    MT.MACHINETYPEID                     AS MachineTypeId,
                                                    MT.MACHINETYPECODE                   AS MachineTypeCode,
                                                    MT.MACHINETYPENAME                   AS MachineTypeName,
                                                    MT.NATURE                            AS MachineTypeNature,
                                                    MT.STANDARDPRODUCTIONFACTOR          AS MachineTypeStandardProductionFactor,
                                                    MT.PARAMETERSETID                    AS ParameterSetId,
                                                    PS.PARAMETERSETCODE                  AS ParameterSetCode,
                                                    PS.PARAMETERSETNAME                  AS ParameterSetName,
                                                    MT.RESOURCETYPEID                    AS ResourceTypeId,
                                                    RT.RESOURCETYPECODE                  AS ResourceTypeCode,
                                                    RT.RESOURCETYPENAME                  AS ResourceTypeName,
                                                    MT.SORTORDER                         AS MachineTypeSortOrder,
                                                    MT.STATUS                            AS MachineTypeStatus,
                                                    MT.VERSION                           AS MachineTypeVersion,
                                                    MT.CREATEDBYID                       AS MachineTypeCreatedById,
                                                    MT.CREATEDON                         AS MachineTypeCreatedOn,
                                                    CU.USERNAME                          AS MachineTypeCreatedByName,
                                                    MT.MODIFIEDBYID                      AS MachineTypeModifiedById,
                                                    MT.MODIFIEDON                        AS MachineTypeModifiedOn,
                                                    MU.USERNAME                          AS MachineTypeModifiedByName

                                                FROM MMACHINETYPE MT
                                                LEFT JOIN MPARAMETERSET PS ON PS.PARAMETERSETID = MT.PARAMETERSETID
                                                LEFT JOIN MRESOURCETYPE RT ON RT.RESOURCETYPEID = MT.RESOURCETYPEID
                                                LEFT JOIN MUSER CU ON CU.USERID = MT.CREATEDBYID
                                                LEFT JOIN MUSER MU ON MU.USERID = MT.MODIFIEDBYID
                                                WHERE MT.MACHINETYPEID = @machinetypeid;";

        public const string SAVE_MACHINETYPE = @"INSERT INTO MMACHINETYPE
                                                (
                                                    MACHINETYPEID,
                                                    MACHINETYPECODE,
                                                    MACHINETYPENAME,
                                                    NATURE,
                                                    PARAMETERSETID,
                                                    RESOURCETYPEID,
                                                    SORTORDER,
                                                    STANDARDPRODUCTIONFACTOR,
                                                    STATUS,
                                                    VERSION,
                                                    CREATEDBYID,
                                                    CREATEDON,
                                                    MODIFIEDBYID,
                                                    MODIFIEDON
                                                )
                                                VALUES
                                                (
                                                    @MachineTypeId,
                                                    @MachineTypeCode,
                                                    @MachineTypeName,
                                                    @MachineTypeNature,
                                                    @ParameterSetId,
                                                    @ResourceTypeId,
                                                    @MachineTypeSortOrder,
                                                    @MachineTypeStandardProductionFactor,
                                                    @MachineTypeStatus,
                                                    @MachineTypeVersion,
                                                    @MachineTypeCreatedById,
                                                    @MachineTypeCreatedOn,
                                                    @MachineTypeModifiedById,
                                                    @MachineTypeModifiedOn
                                                );";

        public const string UPDATE_MACHINETYPE = @"UPDATE MMACHINETYPE
                                                    SET
                                                        MACHINETYPECODE              = @MachineTypeCode,
                                                        MACHINETYPENAME              = @MachineTypeName,
                                                        NATURE                        = @MachineTypeNature,
                                                        PARAMETERSETID               = @ParameterSetId,
                                                        RESOURCETYPEID               = @ResourceTypeId,
                                                        STANDARDPRODUCTIONFACTOR     = @MachineTypeStandardProductionFactor,
                                                        SORTORDER                    = @MachineTypeSortOrder,
                                                        STATUS                       = @MachineTypeStatus,
                                                        VERSION                      = @MachineTypeVersion,
                                                        MODIFIEDBYID                 = @MachineTypeModifiedById,
                                                        MODIFIEDON                   = @MachineTypeModifiedOn
                                                    WHERE
                                                        MACHINETYPEID = @MachineTypeId;";

        public const string DELETE_MACHINETYPE = @"DELETE FROM MMACHINETYPE
                                                    WHERE MACHINETYPEID = @machinetypeid;";

        public const string GET_SELECTLIST_MACHINETYPE = @"SELECT
                                                            MACHINETYPEID AS MachineTypePicklistId,
                                                            MACHINETYPECODE AS MachineTypePicklistCode,
                                                            MACHINETYPENAME AS MachineTypePicklistName
                                                            FROM MMACHINETYPE";


    }
}