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

namespace MMDAL.Query.ItemModel
{
    public static class ItemModelQB
    {
        public const string GET_ITEMMODEL = @"SELECT
                            M.MODELID AS ModelId,
                            M.MODELCODE AS ModelCode,
                            M.MODELNAME AS ModelName,
                            M.SHORTNAME AS ModelShortName,
                            M.ITEMCATEGORYID AS ItemCategoryId,
                            IC.ITEMCATEGORYCODE AS ItemCategoryCode,
                            IC.ITEMCATEGORYNAME AS ItemCategoryName,
                            M.ITEMBRANDID AS ItemBrandId,
                            IB.ITEMBRANDCODE AS ItemBrandCode,
                            IB.ITEMBRANDNAME AS ItemBrandName,
                            M.ISSELECTED AS ModelIsSelected,
                            M.SORTORDER AS ModelSortOrder,
                            M.STATUS AS ModelStatus,
                            M.VERSION AS ModelVersion,
                            M.CREATEDBYID AS ModelCreatedById,
                            M.CREATEDON AS ModelCreatedOn,
                            M.MODIFIEDBYID AS ModelModifiedById,
                            M.MODIFIEDON AS ModelModifiedOn,
                            M.ISASSET AS ModelIsAsset,
                            M.ISITEM AS ModelIsItem,
                            M.DEFAULTCMSID AS ModelDefaultCmsId
                            FROM MMODEL M
                            LEFT JOIN MITEMCATEGORY IC ON M.ITEMCATEGORYID = IC.ITEMCATEGORYID
                            LEFT JOIN MITEMBRAND IB ON M.ITEMBRANDID = IB.ITEMBRANDID
                            WHERE M.MODELID = @modelid;
                            ";

        public const string GET_SELECTLIST_ITEMMODEL = @"SELECT
                            MODELID AS Id,
                            MODELCODE AS Code,
                            MODELNAME AS Name,
                            SHORTNAME AS ShortName
                            FROM MMODEL
                            ";

        public const string SAVE_ITEMMODEL = @"INSERT 
                            INTO MMODEL (
                                 MODELID,
                                 MODELCODE,
                                 MODELNAME,
                                 SHORTNAME,
                                 ITEMCATEGORYID,
                                 ITEMBRANDID,
                                 ISSELECTED,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 ISASSET,
                                 ISITEM,
                                 DEFAULTCMSID
                            ) VALUES (
                                 @ModelId,
                                 @ModelCode,
                                 @ModelName,
                                 @ModelShortName,
                                 @ItemCategoryId,
                                 @ItemBrandId,
                                 @ModelIsSelected,
                                 @ModelSortOrder,
                                 @ModelStatus,
                                 @ModelVersion,
                                 @ModelCreatedById,
                                 @ModelCreatedOn,
                                 @ModelModifiedById,
                                 @ModelModifiedOn,
                                 @ModelIsAsset,
                                 @ModelIsItem,
                                 @ModelDefaultCmsId
                            );
                            ";

        public const string UPDATE_ITEMMODEL = @"UPDATE 
                            MMODEL SET
                            MODELCODE = @ModelCode,
                            MODELNAME = @ModelName,
                            SHORTNAME = @ModelShortName,
                            ITEMCATEGORYID = @ItemCategoryId,
                            ITEMBRANDID = @ItemBrandId,
                            ISSELECTED = @ModelIsSelected,
                            SORTORDER = @ModelSortOrder,
                            STATUS = @ModelStatus,
                            VERSION = @ModelVersion,
                            MODIFIEDBYID = @ModelModifiedById,
                            MODIFIEDON = @ModelModifiedOn,
                            ISASSET = @ModelIsAsset,
                            ISITEM = @ModelIsItem,
                            DEFAULTCMSID = @ModelDefaultCmsId
                            WHERE MODELID = @ModelId;
                            ";

        public const string DELETE_ITEMMODEL = @"DELETE 
                            FROM MMODEL
                            WHERE MODELID = @modelid;
                            ";
    }
}