using System; namespace FrameworkDAL.DTO.MessageHub.MessageHubGenerator { /// /// Generic DTO used by MessageHub for all templates. /// SQL aliases MUST match property names exactly. /// public class MessageHubContextDTO { /* ========================= MUSER ========================= */ public int? UserId { get; set; } public string UserCode { get; set; } public string UserName { get; set; } public string UserLoginName { get; set; } public DateTime? UserDateOfBirth { get; set; } public int? UserType { get; set; } public int? UserNature { get; set; } public int? UserSecurityLevel { get; set; } public string UserPrimaryMail { get; set; } public string UserPrimaryMobile { get; set; } public string UserPrimaryPhone { get; set; } public int? UserWorkOUId { get; set; } public int? UserWorkPeriodId { get; set; } public int? UserWorkPartyBranchId { get; set; } public DateTime? UserWorkDate { get; set; } public DateTime? UserLastSuccessLoginOn { get; set; } public DateTime? UserLastFailureAttemptOn { get; set; } public int? TimeZoneId { get; set; } public string LanguageId { get; set; } public int? TenantId { get; set; } public int? UserStatus { get; set; } public string UserThumbnail { get; set; } /* ========================= MEMPLOYEE ========================= */ public int? EmployeeId { get; set; } public string EmployeeCode { get; set; } public string EmployeeName { get; set; } public string EmployeeFirstName { get; set; } public string EmployeeMiddleName { get; set; } public string EmployeeLastName { get; set; } public int? EmployeeDepartmentId { get; set; } public int? EmployeeDesignationId { get; set; } public int? EmployeeTypeId { get; set; } public DateTime? EmployeeDateOfBirth { get; set; } public DateTime? EmployeeDateOfJoining { get; set; } public string EmployeePrimaryEmail { get; set; } public string EmployeePrimaryMobile { get; set; } public int? ReportingToEmployeeId { get; set; } public int? EmployeeWorkOUId { get; set; } public int? EmployeeContactId { get; set; } public int? EmployeeStatus { get; set; } /* ========================= MCONTACT ========================= */ public int? ContactId { get; set; } public string ContactName { get; set; } public string ContactMailId { get; set; } public string ContactMobileNo { get; set; } public string ContactPhoneNo { get; set; } /* ========================= ORGANIZATION UNIT ========================= */ public int? OUId { get; set; } public string OUCode { get; set; } public string OUName { get; set; } public string OUShortName { get; set; } public int? OUCompanyId { get; set; } public int? OUBranchId { get; set; } public int? OUDivisionId { get; set; } public int? OUCurrencyId { get; set; } public int? OUColorId { get; set; } public int? OUCalendarId { get; set; } public int? OUDefaultAddressId { get; set; } public int? OUStatus { get; set; } /* ========================= ORGANIZATION GROUP ========================= */ public int? OrganizationGroupId { get; set; } public string OrganizationGroupCode { get; set; } public string OrganizationGroupName { get; set; } public int? OrganizationGroupStatus { get; set; } /* ========================= PARTY ========================= */ public int? PartyId { get; set; } public string PartyCode { get; set; } public string PartyName { get; set; } public string PartyShortName { get; set; } public bool? IsVendor { get; set; } public bool? IsCustomer { get; set; } public bool? IsAccount { get; set; } public int? PartyCurrencyId { get; set; } public int? PartyStatus { get; set; } /* ========================= PARTY BRANCH ========================= */ public int? PartyBranchId { get; set; } public string PartyBranchCode { get; set; } public string PartyBranchName { get; set; } public string PartyBranchShortName { get; set; } public int? PartyBranchType { get; set; } public int? PartyBranchCurrencyId { get; set; } public int? PartyBranchCreditDays { get; set; } public int? PartyBranchNoOfBills { get; set; } public int? PartyBranchDefaultAddressId { get; set; } public int? PartyBranchStatus { get; set; } /* ========================= PERIOD ========================= */ public int? PeriodId { get; set; } public string PeriodCode { get; set; } public string PeriodName { get; set; } public DateTime? PeriodFromDate { get; set; } public DateTime? PeriodToDate { get; set; } public int? PeriodStatus { get; set; } /* ========================= ADDRESS ========================= */ public int? AddressId { get; set; } public string AddressLine1 { get; set; } public string AddressLine2 { get; set; } public string AddressLine3 { get; set; } public string ZipCode { get; set; } public string AddressPhone { get; set; } public string AddressMobile { get; set; } public string AddressGSTIN { get; set; } public string AddressPAN { get; set; } public string AddressGeoLocation { get; set; } /* ========================= LOCATION ========================= */ public int? LocationId { get; set; } public string LocationCode { get; set; } public string LocationName { get; set; } public string LocationGeoCode { get; set; } public string LocationGeoLocation { get; set; } public string LocationShapeType { get; set; } public decimal? LocationRadius { get; set; } /* ========================= CITY ========================= */ public int? CityId { get; set; } public string CityCode { get; set; } public string CityName { get; set; } /* ========================= STATE ========================= */ public int? StateId { get; set; } public string StateCode { get; set; } public string StateName { get; set; } /* ========================= COUNTRY ========================= */ public int? CountryId { get; set; } public string CountryCode { get; set; } public string CountryName { get; set; } public string CountryISDCode { get; set; } public string CountryGSTCountryCode { get; set; } /* ========================= LATEST CALL ========================= */ // Core Fields public int? CallId { get; set; } public string? CallNumber { get; set; } public DateTime? CallDate { get; set; } public int? CallStatus { get; set; } public bool? CallIsClosed { get; set; } public DateTime? CallCompletedOn { get; set; } // Basic Info public int? CallOUId { get; set; } public int? CallBizTransactionTypeId { get; set; } public int? CallPeriodId { get; set; } public string? CallReferenceNumber { get; set; } public DateTime? CallReferenceDate { get; set; } public int? CallObjectTypeId { get; set; } public int? CallObjectId { get; set; } public int? CallPartyId { get; set; } public int? CallPartyBranchId { get; set; } public int? CallEmployeeId { get; set; } public int? CallContactId { get; set; } public int? CallAddressId { get; set; } // Reporting Info public string? CallReportedBy { get; set; } public int? CallReportedById { get; set; } public int? CallReceivedById { get; set; } public int? CallReceivedMode { get; set; } public int? CallTypeId { get; set; } public int? CallGenerationType { get; set; } // Contract Info public int? CallContractId { get; set; } public int? CallContractCycleNumber { get; set; } // Problem Info public int? CallNatureId { get; set; } public int? CallPriorityId { get; set; } public DateTime? CallProblemDate { get; set; } public int? CallProblemTime { get; set; } public DateTime? CallPromisedDate { get; set; } // Allocation Info public int? CallAllotedToType { get; set; } public int? CallAllotedToEmployeeId { get; set; } public int? CallAllotedToContactId { get; set; } public int? CallAllotedToPartyId { get; set; } public int? CallAllotedMode { get; set; } public string? CallAllotedToNumber { get; set; } // Object Info public int? CallOnObjectTypeId { get; set; } public int? CallOnObjectId { get; set; } public string? CallOnName { get; set; } public int? CallOnObjectStatus { get; set; } // Coverage & Description public int? CallCoverageStatus { get; set; } public string? CallReportedProblem { get; set; } public string? CallActionTaken { get; set; } public string? CallCustomerRemarks { get; set; } public int? CallProblemNatureId { get; set; } // Planning public DateTime? CallPlanDate { get; set; } public DateTime? CallPossibleDate { get; set; } // Estimated Amounts public decimal? CallEstimatedLabourAmount { get; set; } public decimal? CallEstimatedSparesAmount { get; set; } public decimal? CallEstimatedOthersAmount { get; set; } public decimal? CallEstimatedTotalAmount { get; set; } public int? CallEstimatedById { get; set; } // Actual Amounts public decimal? CallLabourAmount { get; set; } public decimal? CallSpareAmount { get; set; } public decimal? CallOtherAmount { get; set; } public decimal? CallTotalAmount { get; set; } // Misc public int? CallPersonId { get; set; } public int? CallIndoorOutdoor { get; set; } // Item Handling public bool? CallIsItemReceived { get; set; } public string? CallItemReceivedRemarks { get; set; } public bool? CallIsStandbyGiven { get; set; } public int? CallStandbyItemId { get; set; } public string? CallStandbyRemarks { get; set; } // Completion & Closure public int? CallCompletedById { get; set; } public bool? CallCompletedOnTime { get; set; } public string? CallCustomerFeedback { get; set; } public int? CallClosedById { get; set; } public DateTime? CallClosedOn { get; set; } public bool? CallClosedOnTime { get; set; } // Accounting & Status public int? CallReasonId { get; set; } public bool? CallIsAccounted { get; set; } public int? CallRecordStatus { get; set; } public int? CallVersion { get; set; } // Audit Fields public int? CallCreatedById { get; set; } public DateTime? CallCreatedOn { get; set; } public int? CallModifiedById { get; set; } public DateTime? CallModifiedOn { get; set; } // Root Cause public int? CallAllocationId { get; set; } public int? CallRootCauseId { get; set; } public string? CallRootCauseDescription { get; set; } // Serial & Template public string? CallManufacturerSlNo { get; set; } public string? CallTemplateData { get; set; } /* ========================= LATEST VISITOR PASS ========================= */ public int? VisitorPassId { get; set; } public string VisitorPassNumber { get; set; } public DateTime? VisitorPassDate { get; set; } public string VisitorName { get; set; } /* ========================= VISITOR PUNCH ========================= */ public DateTime? VisitorPunchInDate { get; set; } public DateTime? VisitorPunchOutDate { get; set; } } }