using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Net;
using System.Xml.Linq;
using Neo.Afx.ComponentModel;
using Neo.Afx.Services.Documents.Entities;
using Neo.Afx.Services.Audits;

namespace Neo.Afx.Services.Documents
{    
    public partial class DocumentsDatabase 
    {   
        
        #region GetDocumentTypeQuestions

        /// <summary>
        /// Gets a list of document questions 
        /// </summary>        
        /// <returns></returns>
        public List<DocumentTypeQuestion> GetDocumentTypeQuestions()
        {
            return Context.DocumentTypeQuestions.Where(a => !a.IsCancelled).ToList();
        }

        #endregion

        #region GetDocumentsAwaitingVerification
        /// <summary>
        /// Gets a list of documents awaiting verification
        /// </summary>        
        /// <returns></returns>
        public List<Pr_DocumentsAwaitingVerificationGet_Result> GetDocumentsAwaitingVerification(long entityID, long itemID)
        {
            return Context.Pr_DocumentsAwaitingVerificationGet(entityID, itemID).ToList();
        }
        #endregion

        #region GetDocumentsAwaitingVerificationQuestionsResetAndGet
        /// <summary>
        /// Gets a list of documents questions for the documents awaiting verification
        /// </summary>        
        /// <returns></returns>
        public List<Pr_DocumentsAwaitingVerificationQuestionsResetAndGet_Result> GetDocumentsAwaitingVerificationQuestionsResetAndGet(long entityID, long itemID, bool ResetQuestions)
        {
            return Context.Pr_DocumentsAwaitingVerificationQuestionsResetAndGet(entityID, itemID, ResetQuestions).ToList();
        }
        #endregion

        #region UpdateDocumentQuestions
        /// <summary>
        /// Updates a list of document quests, and calculated document verification status
        /// </summary>
        /// <param name="questions"></param>
        public void UpdateDocumentQuestions(List<Pr_DocumentsAwaitingVerificationQuestionsResetAndGet_Result> questions, long userID)
        {
            // Handle null or empty questions list (e.g., for new documents without questions configured)
            if (questions == null || questions.Count == 0)
            {
                return;
            }

            foreach (var question in questions)
            {
                Context.Pr_DocumentQuestionUpdate(question.DocumentQuestionID, question.DocumentID, question.QuestionPassed, userID, question.Comments);
            }
        }

        /// <summary>
        /// Updates a list of document quests, and calculated document verification status
        /// </summary>
        /// <param name="questions"></param>
        /// <param name="userID"></param>
        public void UpdateDocumentQuestions(List<Pr_DocumentVerificationQuestionsGet_Result> questions, long userID)
        {
            // Handle null or empty questions list (e.g., for new documents without questions configured)
            if (questions == null || questions.Count == 0)
            {
                return;
            }

            foreach (var question in questions)
            {
                Context.Pr_DocumentQuestionUpdate(question.DocumentQuestionID, question.DocumentID, question.QuestionPassed, userID, question.Comments);
            }

        }       
        #endregion

        #region GetDocumentQuestions
        /// <summary>
        /// Gets a list of questions for a document
        /// </summary>        
        /// <returns></returns>
        public List<Pr_DocumentVerificationQuestionsGet_Result> GetDocumentQuestions(long documentID, long userID)
        {
            return Context.Pr_DocumentVerificationQuestionsGet(documentID, userID).ToList();
        }
        #endregion

    }
}