using System.Data;
using Neo.Afx.ComponentModel;
using System.Linq;
using System;
using System.Collections.Generic;

namespace Neo.LegitimateLicences.MDApprovalRequest.Models.Database
{
    public class MDApprovalRequestDatabase : Database<MDApprovalRequestContext>
    {
        #region MDApprovalRequestDatabase
        public MDApprovalRequestDatabase()
            : base(new MDApprovalRequestContext())
        {
        }
        #endregion


        #region GetMDApprovalRequest
        public MDApprovalDetail GetMDApprovalRequest(long? entityID, long? itemID, long userID)
        {
            
            var details = (from q in Context.MDApprovalDetails
                           where q.MDApprovalDetailID == itemID
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        #region GetMDApprovalRequestView
        public Vw_MDApprovalDetails GetMDApprovalRequestView(long mdApprovalDetailID)
        {
            return Context.Vw_MDApprovalDetails.Where(a => a.MDApprovalDetailID == mdApprovalDetailID).FirstOrDefault();
        }
        #endregion

        #region GetMDApprovalRequest
        public List<Vw_MDApprovalDetails> GetInProgressMDApprovalRequest()
        {
            var details = (from q in Context.Vw_MDApprovalDetails
                           where q.WorkflowStatus == "In Progress"
                           select q);

            return details.ToList();
        }
        #endregion

    }
}