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

namespace FrameworkDAL.Query.EIPService.Contact
{
    public static class EIPContactQB
    {
        public const string GET_EIPCONTACT_VIA_PHONENUMBER = @"
SELECT 
    CONTACTID           AS ContactId,
    OBJECTTYPEID        AS ObjectTypeId,
    OBJECTID            AS ObjectId,
    CONTACTNATURE       AS ContactNature,
    NAME                AS Name,
    FIRSTNAME           AS FirstName,
    MIDDLENAME          AS MiddleName,
    LASTNAME            AS LastName,
    SALUTATION          AS Salutation,
    SEX                 AS Sex,
    DOB                 AS Dob,
    MAILID              AS MailId,
    SORTORDER           AS SortOrder,
    VERSION             AS Version,
    STATUS              AS Status,
    SOURCETYPE          AS SourceType,
    CREATEDBYID         AS CreatedById,
    CREATEDON           AS CreatedOn,
    MODIFIEDBYID        AS ModifiedById,
    MODIFIEDON          AS ModifiedOn,
    PHONENO             AS PhoneNo,
    MOBILENO            AS MobileNo,
    RELATIONSHIP        AS Relationship,
    DESIGNATION         AS Designation,
    COMPANY             AS Company,
    DEFAULTIMAGEID      AS DefaultImageId,
    LINKTYPE            AS LinkType,
    REPORTINGTOID       AS ReportingToId,
    USERLINKID          AS UserLinkId,
    THUMBNAIL           AS Thumbnail
FROM MContact
WHERE PHONENO LIKE '%' + @PhoneNumber + '%'
   OR MOBILENO LIKE '%' + @PhoneNumber + '%';
";

    }
}