using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using Neo.Legitimate.Common;
using Pilotfish.Afx.ComponentModel;
using System.Linq;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System;

namespace Neo.Legitimate.NewAssociationRequest.Models
{
    public class NewAssociationDatabase : Database<NewAssociationContext>
    {
        public NewAssociationDatabase()
            : base(new NewAssociationContext())
        {

        }

        #region GetNewAssociationRequest
        public NewAssociationRequestDetail GetNewAssociationRequest(long NewAssociationRequestDetailId, long userID)
        {
            if (NewAssociationRequestDetailId == -1)
            {
                return new NewAssociationRequestDetail()
                {
                    NewAssociationRequestDetailID = NewAssociationRequestDetailId,
                    CreatedByID = userID,
                    CreatedDate = DateTime.Now,
                    UpdatedByID = userID,
                    UpdatedDate = DateTime.Now,
                    AssociationModeID = null,
                    AssociationTypeID = null,
                    RegionID = null,
                    AssociationName = "",
                    AssociationNameAbbrev = "",
                    RegistrationNumber = "",
                    PostalAddress = "",
                    PostalAddressCode = "",
                    PhysicalAddress = "",
                    PhysicalAddressCode = "",
                    BusRegNumber = "",
                    TaxNumber = "",
                    MemberCount = null,
                    TelNumber = "",
                    FaxNumber = "",
                    CellNumber = "",
                    EmailAddress = "",
                    OlasID = null,
                    LtpsID = null,
                    VerifiedAssociationID = null,
                    NewAssociationRequestTypeID = (short)Common.AssociationRequestType.New
                };
            }

            var details = (from q in Context.NewAssociationRequestDetails
                           where q.NewAssociationRequestDetailID == NewAssociationRequestDetailId
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        //#region SearchNewAssociationRequestDetails
        //public IEnumerable<Vw_NewAssociationRequestDetails> SearchNewAssociationRequestDetails(long NewAssociationRequestDetailID, short workflowInstanceStatusID)
        //{
        //    return Context.Pr_NewAssociationRequestDetailsSearch(NewAssociationRequestDetailID, workflowInstanceStatusID).ToList();
        //} 
        //#endregion
    }
}