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

namespace PayRollDAL.Query.Contact
{
    internal class ContactQB
    {
        public const string SAVE_CONTACT = @"INSERT INTO MCONTACT
(
    CONTACTID,
    OBJECTTYPEID,
    OBJECTID,
    CONTACTNATURE,
    NAME,
    FIRSTNAME,
    MIDDLENAME,
    LASTNAME,
    SALUTATION,
    SEX,
    DOB,
    MAILID,
    SORTORDER,
    VERSION,
    STATUS,
    SOURCETYPE,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON,
    PHONENO,
    MOBILENO,
    RELATIONSHIP,
    DESIGNATION,
    COMPANY,
    DEFAULTIMAGEID,
    LINKTYPE,
    REPORTINGTOID,
    USERLINKID
)
VALUES
(
    @ContactId,
    @ObjectTypeId,
    @ContactObjectId,
    @ContactContactNature,
    @ContactName,
    @ContactFirstName,
    @ContactMiddleName,
    @ContactLastName,
    @ContactSalutation,
    @ContactSex,
    @ContactDOB,
    @ContactMailId,
    @ContactSortOrder,
    @ContactVersion,
    @ContactStatus,
    @ContactSourceType,
    @ContactCreatedById,
    @ContactCreatedOn,
    @ContactModifiedById,
    @ContactModifiedOn,
    @ContactPhoneNo,
    @ContactMobileNo,
    @ContactRelationShip,
    @ContactDesignation,
    @ContactCompany,
    @ContactDefaultImageId,
    @ContactLinkType,
    @ReportingToId,
    @UserLinkId
);
";

        public const string UPDATE_CONTACT = @"UPDATE MCONTACT
SET
    OBJECTTYPEID      = @ObjectTypeId,
    OBJECTID          = @ContactObjectId,
    CONTACTNATURE     = @ContactContactNature,
    NAME              = @ContactName,
    FIRSTNAME         = @ContactFirstName,
    MIDDLENAME        = @ContactMiddleName,
    LASTNAME          = @ContactLastName,
    SALUTATION        = @ContactSalutation,
    SEX               = @ContactSex,
    DOB               = @ContactDOB,
    MAILID            = @ContactMailId,
    SORTORDER         = @ContactSortOrder,
    VERSION           = @ContactVersion,
    STATUS            = @ContactStatus,
    SOURCETYPE        = @ContactSourceType,
    CREATEDBYID       = @ContactCreatedById,
    CREATEDON         = @ContactCreatedOn,
    MODIFIEDBYID      = @ContactModifiedById,
    MODIFIEDON        = @ContactModifiedOn,
    PHONENO           = @ContactPhoneNo,
    MOBILENO          = @ContactMobileNo,
    RELATIONSHIP      = @ContactRelationShip,
    DESIGNATION       = @ContactDesignation,
    COMPANY           = @ContactCompany,
    DEFAULTIMAGEID    = @ContactDefaultImageId,
    LINKTYPE          = @ContactLinkType,
    REPORTINGTOID     = @ReportingToId,
    USERLINKID        = @UserLinkId
WHERE
    CONTACTID = @ContactId;
";
    }
}