using System; using System.Collections.Generic; namespace Fab2ApprovalSystem.Models; public class AuditList { public string AuditNo { get; set; } public string AuditTitle { get; set; } public string AuditType { get; set; } public string Auditors { get; set; } public string PendingCAFindingsAIOwners { get; set; } public string PendingCAOwners { get; set; } public DateTime? AuditDate { get; set; } public string FindingCategories { get; set; } public string AuditedAreas { get; set; } public string CADisp { get; set; } public string CorrectiveActions { get; set; } public string AuditScore { get; set; } public string AuditStatus { get; set; } } public class Audit { public int AuditNo { set; get; } public int OriginatorID { get; set; } public string OriginatorName { get; set; } public string AuditTitle { get; set; } public int AuditScore { get; set; } public DateTime? AuditDate { get; set; } public string AuditFindingCategories { get; set; } public int AuditStatus { get; set; } public string NoOfMajorNonConformities { get; set; } public string NoOfMinorNonConformities { get; set; } public string NoOf5SFindings { get; set; } public string NoOfOFIFindings { get; set; } public string Auditees { get; set; } public List AuditorIDs { get; set; } public List AuditTypeIDs { get; set; } public List AuditedAreaIDs { get; set; } public List AuditedStandardIDs { get; set; } public bool RecordLockIndicator { get; set; } public int RecordLockedBy { get; set; } public bool RecordLocked { get; set; } public DateTime RecordLockedDate { get; set; } public DateTime LastUpdateDate { get; set; } public CAFindings CAFindings { get; set; } public Audit() { AuditorIDs = new List(); AuditTypeIDs = new List(); AuditedAreaIDs = new List(); CAFindings = new CAFindings(); } } public class Auditees { private string UserName { get; set; } } public class AuditType { public int AuditTypeID { get; set; } public string AuditTypeName { get; set; } } public class Auditor { public int AuditorID { get; set; } public string AuditorName { get; set; } } /// /// /// public class AuditedArea { public int AuditedAreaID { get; set; } public string AuditedAreaName { get; set; } } public class AuditFindings { public int ID { get; set; } public int AuditNo { get; set; } public string Findings { get; set; } public string ViolatedClause { get; set; } public string FindingType { get; set; } public string AuditFindingCategoryID { get; set; } public string FindingCategories { get; set; } public int CANo { get; set; } public string CANoDisp { get; set; } public string CAStatus { get; set; } public int CAOwnerID { get; set; } public string CAOwner { get; set; } public DateTime AssignedDate { get; set; } public string Title { get; set; } } public class AuditFindingCategory { public int AuditFindingCategoryID { get; set; } public string AuditFindingCategoryName { get; set; } } public class AuditReportAttachment { public int ID { get; set; } public string FileGUID { get; set; } public string FileName { get; set; } public int UploadedByID { get; set; } public int? CAFindingsID { get; set; } public string UploadedByName { get; set; } public DateTime? UploadDateTime { get; set; } public string Title { get; set; } public string RequirementsNotes { get; set; } public string Comments { get; set; } public int AuditNo { get; set; } } public class CorrectiveAction { public int CANo { get; set; } public string CANoDisp { get; set; } public int AuditNo { get; set; } public int RequestorID { get; set; } public string RequestorName { get; set; } public string CATitle { get; set; } public bool D0Completed { get; set; } public DateTime? D0CompleteDate { get; set; } public bool D0Approved { get; set; } public DateTime? D0ApprovedDate { get; set; } public bool TriggerApproval { get; set; } public bool TriggerSectionApproval { get; set; } public string SectionApproval { get; set; } public DateTime? IssueDate { get; set; } public string CAType { get; set; } public bool IsCACompleted { get; set; } public DateTime CACompletedDate { get; set; } public int ApprovalStatus { get; set; } public int WorkFlowNumber { get; set; } public byte CurrentStep { get; set; } public int D1AssigneeID { get; set; } public int CurrentD1AssigneeID { get; set; } public string D1AssigneeName { get; set; } public int CASourceID { get; set; } public string CASource { get; set; } public int ModuleID { get; set; } public int Status { get; set; } public string StatusName { get; set; } public string Stage { get; set; } public int QAID { get; set; } public string PendingApprovers { get; set; } public string PendingAIOwners { get; set; } public string Tools { get; set; } public string RelatedMRB { get; set; } public int RelatedAudit { get; set; } public string D2ProblemDescription { get; set; } public List RiskAssessmentAreaIDs { get; set; } public List ModuleIDs { get; set; } public string D3RiskAssessmentNotes { get; set; } public bool D3Completed { get; set; } public DateTime? D3CompleteDate { get; set; } public bool D3Approved { get; set; } public DateTime? D3ApprovedDate { get; set; } public DateTime? D3DueDate { get; set; } public string D4RootCause1 { get; set; } public string D4RootCause2 { get; set; } public string D4RootCause3 { get; set; } public string D4RootCause4 { get; set; } public DateTime? D4CompleteDate { get; set; } public bool D4Completed { get; set; } public bool D4Approved { get; set; } public DateTime? D4ApprovedDate { get; set; } public DateTime? D5CompleteDate { get; set; } public bool D5Completed { get; set; } public DateTime? D6ValidatedDate { get; set; } public bool D6Validated { get; set; } public DateTime? D7CompleteDate { get; set; } public bool D7Completed { get; set; } public bool D5Approved { get; set; } public DateTime? D5ApprovedDate { get; set; } public DateTime? D5D7DueDate { get; set; } public DateTime? D8DueDate { get; set; } public DateTime? D8CompletedDate { get; set; } public bool D8Completed { get; set; } public DateTime? D8ApprovedDate { get; set; } public bool D8Approved { get; set; } public string D8TeamRecognition { get; set; } public string D8LessonsLearned { get; set; } public string TeamMembers { get; set; } public DateTime? ApprovedDate { get; set; } public bool RecordLockIndicator { get; set; } public int RecordLockedBy { get; set; } public string RecordLockByName { get; set; } public bool RecordLocked { get; set; } public DateTime RecordLockedDate { get; set; } public DateTime LastUpdateDate { get; set; } public List TeamMemberIDs { get; set; } public D5D6CorrectivetAction D5D6CorrectivetAction { get; set; } public D7PreventiveAction D7PreventiveAction { get; set; } public string D0Comments { get; set; } public int TeamCaptainID { get; set; } public string TeamCaptainName { get; set; } public int CASponsorID { get; set; } public string CASponsorName { get; set; } public string CustomerName { get; set; } public string CustomerPartNo { get; set; } public string IFXPartNo { get; set; } public int PartQty { get; set; } public string InvoiceNo { get; set; } public string PurchaseOrderNo { get; set; } public string SalesOrderNo { get; set; } public double DollarImpact { get; set; } public string BackgroundInfo { get; set; } public string Analysis { get; set; } public string VisualVerification { get; set; } public string InterimContainmentAction { get; set; } public string ICAVerificationResults { get; set; } public string ICAValidationActivities { get; set; } public string RootCauseVerification { get; set; } public string EscapePoint { get; set; } public DateTime? NextDueDate { get; set; } public DateTime? FollowUpDate { get; set; } public bool CASubmitted { get; set; } public string CAStandardType { get; set; } public DateTime? ClosedDate { get; set; } public CorrectiveAction() { TeamMemberIDs = new List(); ModuleIDs = new List(); RiskAssessmentAreaIDs = new List(); D5D6CorrectivetAction = new D5D6CorrectivetAction(); D7PreventiveAction = new D7PreventiveAction(); } } public class CASource { public int CASourceID { get; set; } public string CASourceName { get; set; } } public class CAUserList { public int UserID { get; set; } public string UserName { get; set; } } public class CAModule { public int ModuleID { get; set; } public string ModuleName { get; set; } } public class CA_Attachment { public int ID { get; set; } public string FileGUID { get; set; } public string FileName { get; set; } public string FileExtension { get; set; } public string Section { get; set; } public int UploadedByID { get; set; } public string UploadedByName { get; set; } public DateTime? UploadDateTime { get; set; } public string Title { get; set; } public string RequirementsNotes { get; set; } public string Comments { get; set; } public int? CANo { get; set; } public int? D5D6CAID { get; set; } public int? D7PAID { get; set; } public int? CAFindingsID { get; set; } } public class D3ContainmentAction { public int ID { get; set; } public int CANo { get; set; } public string Section { get; set; } public string ContainmentAction { get; set; } public string Result { get; set; } public string ECNLinks { get; set; } public int ResponsibilityOwnerID { get; set; } public int CurrentResponsibilityOwnerID { get; set; } public string ResponsibilityOwnerName { get; set; } public DateTime? ECD { get; set; } public DateTime? ImplementedDate { get; set; } public DateTime AssignedDate { get; set; } } public class RiskAssessmentArea { public int RiskAssessmentAreaID { get; set; } public string RiskAssessmentAreaName { get; set; } } public class D5D6CorrectivetAction { public int ID { get; set; } public int CANo { get; set; } public string CorrectiveAction { get; set; } public string CARequired { get; set; } public string Result { get; set; } public string ECNLinks { get; set; } public string AttachmentLinks { get; set; } public int ResponsibilityOwnerID { get; set; } public int CurrentResponsibilityOwnerID { get; set; } public string ResponsibilityOwnerName { get; set; } public DateTime? ECD { get; set; } public DateTime? ImplementedDate { get; set; } public bool IsImplemented { get; set; } public string ImprovementID { get; set; } public string Improvement { get; set; } public CA_Attachment CA_Attachment { get; set; } public DateTime AssignedDate { get; set; } public bool Approved { get; set; } public D5D6CorrectivetAction() => CA_Attachment = new CA_Attachment(); public string ActionType { get; set; } } public class D5D6Improvement { public int D5D6ImprovementID { get; set; } public string D5D6ImprovementName { get; set; } } public class D7PreventiveAction { public int ID { get; set; } public int CANo { get; set; } public string PreventiveAction { get; set; } public string Result { get; set; } public string ECNLinks { get; set; } public string AttachmentLinks { get; set; } public int ResponsibilityOwnerID { get; set; } public int CurrentResponsibilityOwnerID { get; set; } public string ResponsibilityOwnerName { get; set; } public DateTime? ECD { get; set; } public DateTime? ImplementedDate { get; set; } public CA_Attachment CA_Attachment { get; set; } public DateTime AssignedDate { get; set; } public D7PreventiveAction() => CA_Attachment = new CA_Attachment(); } public class CAFindings { public int ID { get; set; } public int AuditNo { get; set; } public string CAFinding { get; set; } public string CorrectiveAction { get; set; } public string Result { get; set; } public string AttachmentLinks { get; set; } public int? CurrentResponsibilityOwnerID { get; set; } public int? ResponsibilityOwnerID { get; set; } public string ResponsibilityOwnerName { get; set; } public DateTime? ECD { get; set; } public DateTime? ImplementedDate { get; set; } public AuditReportAttachment Audit_Attachment { get; set; } public DateTime AssignedDate { get; set; } public CAFindings() => Audit_Attachment = new AuditReportAttachment(); } public class CASectionApproval { public string DSection { get; set; } public string Fullname { get; set; } public string ApprovalStatus { get; set; } public DateTime? DateAssigned { get; set; } public DateTime? DateCompleted { get; set; } public string Comments { get; set; } } public class CANoList { public int CANo { get; set; } public string CANoDisp { get; set; } } public class CAD3D5D7Due { public int CANo { get; set; } public DateTime DueDate { get; set; } public string ItemDue { get; set; } public string ExpiryType { get; set; } }