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

namespace PayRollDAL.Query.User
{
    public static class UserQB
    {
        public const string SAVE_USER = @"INSERT INTO Muser (
                                USERID, USERCODE, USERNAME, USERLOGINNAME, PASSWORD, DOB, USERTYPE, NATURE, 
                                REMARKS, ISEMPLOYEE, ISPARTNER, PARTNERID, PARTNERUSERID, VALIDFROM, VALIDTO,
                                PRIMARYMAIL, PRIMARYMOBILE, PRIMARYPHONE, PASSWORDPOLICYID, WORKOUID,
                                WORKPERIODID, WORKPARTYBRANCHID, WORKSTOREID, WORKDATE, LASTSUCCESSLOGINON,
                                LASTFAILUREATTEMPTON, PREVIOUSPASSWORD1, PREVIOUSPASSWORD2, PREVIOUSPASSWORD3,
                                PASSWORDCHANGEDON, PREVIOUSLOGIN, WORKREGIONID, SECURITYLEVEL, SECURITYQUESTIONID,
                                SECURITYANSWER, ROLEID, SORTORDER, STATUS, VERSION, SOURCETYPE, MODEOFOPERATION,
                                USERCRITERIACONFIGID, DEFAULTIMAGEID, CREATEDBYID, CREATEDON, MODIFIEDBYID,
                                MODIFIEDON, DEFAULTCMSID, USERDATEFORMAT, USERCURRENCYFORMAT, USERTIMEFORMAT,
                                USERQUANTITYFORMAT, THEMEOPTION, TIMEZONEID, DEFAULTDEVICEID, DELIMITER,
                                LOGINMACHINE, LOGINIP, DIGITALSIGNEDFILE, DIGITALFILEPASSWORD, DEFAULTMENUID,
                                WORKFINANCEBOOKID
                            )
                            VALUES (
                                @UserId, @UserCode, @UserName, @UserLoginName, @UserPassword, @UserDOB, @UserType, @UserNature,
                                @UserRemarks, @UserIsEmployee, @UserIsPartner, @UserPartnerId, @PartnerUserId, @UserValidFrom, @UserValidTo,
                                @UserPrimaryMail, @UserPrimaryMobile, @UserPrimaryPhone, @PasswordPolicyId, @UserWorkOuId, @UserWorkPeriodId, @UserWorkPartyBranchId,
                                @UserWorkStoreId, @UserWorkDate, @UserLastSuccessLoginOn, @UserLastFailureAttemptOn, @UserPreviousPassword1, @UserPreviousPassword2,
                                @UserPreviousPassword3, @UserPasswordChangedOn, @UserPreviousLogin, @UserWorkRegionId, @UserSecurityLevel, @SecurityQuestionId,
                                @UserSecurityAnswer, @RoleId, @UserSortOrder, @UserStatus, @UserVersion, @UserSourceType, @UserModeofOperation,
                                @UserCriteriaConfigId, @ImageId, @UserCreatedById, @UserCreatedOn, @UserModifiedById, @UserModifiedOn, @UserDefaultCMSId,
                                @UserDateFormat, @UserCurrencyFormat, @UserTimeFormat, @UserQuantityFormat, @UserThemeOption, @TimeZoneId, @DefaultDeviceId,
                                @UserDelimiter, @UserLoginMachine, @UserLoginIp, @UserDigitalSignedFile, @UserDigitalFilePassword, @DefaultMenuId, @WorkFinanceBookId
                            );";

        public const string UPDATE_USER = @"UPDATE Muser
                      SET
                          USERCODE = @UserCode,
                          USERNAME = @UserName,
                          USERLOGINNAME = @UserLoginName,
                          PASSWORD = @UserPassword,
                          DOB = @UserDOB,
                          USERTYPE = @UserType,
                          NATURE = @UserNature,
                          REMARKS = @UserRemarks,
                          ISEMPLOYEE = @UserIsEmployee,
                          ISPARTNER = @UserIsPartner,
                          PARTNERID = @UserPartnerId,
                          PARTNERUSERID = @PartnerUserId,
                          VALIDFROM = @UserValidFrom,
                          VALIDTO = @UserValidTo,
                          PRIMARYMAIL = @UserPrimaryMail,
                          PRIMARYMOBILE = @UserPrimaryMobile,
                          PRIMARYPHONE = @UserPrimaryPhone,
                          PASSWORDPOLICYID = @PasswordPolicyId,
                          WORKOUID = @UserWorkOuId,
                          WORKPERIODID = @UserWorkPeriodId,
                          WORKPARTYBRANCHID = @UserWorkPartyBranchId,
                          WORKSTOREID = @UserWorkStoreId,
                          WORKDATE = @UserWorkDate,
                          LASTSUCCESSLOGINON = @UserLastSuccessLoginOn,
                          LASTFAILUREATTEMPTON = @UserLastFailureAttemptOn,
                          PREVIOUSPASSWORD1 = @UserPreviousPassword1,
                          PREVIOUSPASSWORD2 = @UserPreviousPassword2,
                          PREVIOUSPASSWORD3 = @UserPreviousPassword3,
                          PASSWORDCHANGEDON = @UserPasswordChangedOn,
                          PREVIOUSLOGIN = @UserPreviousLogin,
                          WORKREGIONID = @UserWorkRegionId,
                          SECURITYLEVEL = @UserSecurityLevel,
                          SECURITYQUESTIONID = @SecurityQuestionId,
                          SECURITYANSWER = @UserSecurityAnswer,
                          ROLEID = @RoleId,
                          SORTORDER = @UserSortOrder,
                          STATUS = @UserStatus,
                          VERSION = @UserVersion,
                          SOURCETYPE = @UserSourceType,
                          MODEOFOPERATION = @UserModeofOperation,
                          USERCRITERIACONFIGID = @UserCriteriaConfigId,
                          DEFAULTIMAGEID = @ImageId,
                          CREATEDBYID = @UserCreatedById,
                          CREATEDON = @UserCreatedOn,
                          MODIFIEDBYID = @UserModifiedById,
                          MODIFIEDON = @UserModifiedOn,
                          DEFAULTCMSID = @UserDefaultCMSId,
                          USERDATEFORMAT = @UserDateFormat,
                          USERCURRENCYFORMAT = @UserCurrencyFormat,
                          USERTIMEFORMAT = @UserTimeFormat,
                          USERQUANTITYFORMAT = @UserQuantityFormat,
                          THEMEOPTION = @UserThemeOption,
                          TIMEZONEID = @TimeZoneId,
                          DEFAULTDEVICEID = @DefaultDeviceId,
                          DELIMITER = @UserDelimiter,
                          LOGINMACHINE = @UserLoginMachine,
                          LOGINIP = @UserLoginIp,
                          DIGITALSIGNEDFILE = @UserDigitalSignedFile,
                          DIGITALFILEPASSWORD = @UserDigitalFilePassword,
                          DEFAULTMENUID = @DefaultMenuId,
                          WORKFINANCEBOOKID = @WorkFinanceBookId
                      WHERE USERID = @UserId;";
    }
}