using Pilotfish.Afx.ComponentModel;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;

namespace AffectedApplicationWebServices.Database
{

    public partial class AffectedApplicationsEntities
    {
        public AffectedApplicationsEntities(string connectionString)
            : base(connectionString)
        {
        }
    }

    public partial class AffectedapplicationsDatabase : Database<AffectedApplicationsEntities>
    {
        public AffectedapplicationsDatabase() : base(new AffectedApplicationsEntities())
        {
        }

        public AffectedapplicationsDatabase(string connectionString)
            : base(new AffectedApplicationsEntities(connectionString))
        {

        }


        public AffectedApplication AffectedApplicationSearch(string applicationNumber)
        {
            if (!string.IsNullOrEmpty(applicationNumber))
            {
                if (applicationNumber.Substring(0, 3) == "APP")
                {
                    return Context.AffectedApplications.Where(a => a.IsAffected == true && a.ApplicationNumber == applicationNumber).FirstOrDefault();
                }
                else {
                    var applicationRequestDetailID = Convert.ToInt32(applicationNumber);
                    return Context.AffectedApplications.Where(a => a.IsAffected == true && a.ApplicationRequestDetailID == applicationRequestDetailID).FirstOrDefault();
                }                
            }
            else {
                throw new Exception("No reference number specified");
            }

            
        }

        public List<string> GetApplicationRequiredDocuments(long applicationRequestDetailID)
        {
            return Context.Pr_GetRequiredDocumentList(applicationRequestDetailID).ToList();
        }

        public void FlagFileAsFound(long applicationRequestDetailID, long userID)
        {
            Context.Pr_FlagFileAsFound(applicationRequestDetailID, userID);
        }

        public void FlagScanningComplete(long applicationRequestDetailID, long userID)
        {
            Context.Pr_FlagScanningComplete(applicationRequestDetailID, userID);
        }

        public void FlagCapturingComplete(long applicationRequestDetailID, long userID)
        {
            Context.Pr_FlagCapturingComplete(applicationRequestDetailID, userID);
        }

        public void FlagDocumentUploadComplete(long applicationRequestDetailID, long userID)
        {
            Context.Pr_FlagDocumentUploadComplete(applicationRequestDetailID, userID);
        }

        public void FlagProcessingFinalised(long applicationRequestDetailID, long userID)
        {
            Context.Pr_FlagProcessingFinalised(applicationRequestDetailID, userID);
        }

        public void RaiseException(long applicationRequestDetailID, string exceptionDetails, long userID)
        {
            Context.Pr_RaiseException(applicationRequestDetailID, exceptionDetails, userID);
        }

        public void ClearException(long applicationRequestDetailID, string comments, long userID)
        {
            Context.Pr_ClearException(applicationRequestDetailID, comments, userID);
        }

        public long GetUserID(string password)
        {
            var bytes = new UTF8Encoding().GetBytes(password);
            var hashBytes = System.Security.Cryptography.MD5.Create().ComputeHash(bytes);
            var passwordhash = Convert.ToBase64String(hashBytes);
            var user = Context.Users.Where(a => a.PasswordHash == passwordhash).FirstOrDefault();

            if (user != null)
            {
                return user.UserID;
            }
            else {
                return 0;
            }
        }
    }
}