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

namespace Neo.LegitimateLicences.BusinessRuleBypassRequest.Models.Database
{
    public class BusinessRuleBypassRequestDatabase : Database<BusinessRuleBypassContext>
    {
        #region GetNewRouteRequestView
        public Vw_BusinessRuleBypassRequestDetails GetBusinessRuleBypassRequestView(long businessRuleBypassRequestDetailID, long userID)
        {
            var details = (from q in Context.Vw_BusinessRuleBypassRequestDetails
                           where q.BusinessRuleBypassRequestDetailID == businessRuleBypassRequestDetailID
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        #region BusinessRuleBypassRequestDatabase
        public BusinessRuleBypassRequestDatabase() : base(new BusinessRuleBypassContext())
        {

        }
        #endregion

        #region GetBusinessRuleBypassRequestForm
        public BusinessRuleBypassRequestDetail GetBusinessRuleBypassRequestForm(long businessRuleBypassRequestDetailId, long userID)
        {
            if (businessRuleBypassRequestDetailId == -1)
            {
                return new BusinessRuleBypassRequestDetail()
                {
                    BusinessRuleBypassRequestDetailID = businessRuleBypassRequestDetailId,
                    CreatedByID = userID,
                    CreatedDate = DateTime.Now,
                    UpdatedByID = userID,
                    UpdatedDate = DateTime.Now
                };
            }

            var details = (from q in Context.BusinessRuleBypassRequestDetails
                           where q.BusinessRuleBypassRequestDetailID == businessRuleBypassRequestDetailId
                           select q).FirstOrDefault();           
            return details;
        }
        #endregion

        #region PrecheckBusinessRuleBypassRequest
        public Pr_BusinessRuleBypassRequestPrecheck_Result PrecheckBusinessRuleBypassRequest(short businessRuleBypassRequestTypeID, string referenceNumber, long userID)
        {
            return Context.Pr_BusinessRuleBypassRequestPrecheck(businessRuleBypassRequestTypeID, referenceNumber, userID).FirstOrDefault();
        }
        #endregion

        #region CreateBusinessRuleBypassRequest
        public Vw_BusinessRuleBypassRequestDetails CreateBusinessRuleBypassRequest(short businessRuleBypassRequestTypeID, string referenceNumber, string reason, int entityID, long itemID, long userID)
        {
            return Context.Pr_BusinessRuleBypassRequestCreate(businessRuleBypassRequestTypeID, referenceNumber, reason, entityID, itemID, userID).FirstOrDefault();
        }
        #endregion
    }
}