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.NewMemberRequest.Models
{
    public class NewMemberDatabase : Database<NewMemberContext>
    {
        public NewMemberDatabase()
            : base(new NewMemberContext())
        {

        }

        #region GetNewMemberRequest
        public NewMemberRequestDetail GetNewMemberRequest(long NewMemberRequestDetailId, long userID)
        {
            if (NewMemberRequestDetailId == -1)
            {
                return new NewMemberRequestDetail()
                {
                    NewMemberRequestDetailID = NewMemberRequestDetailId,
                    CreatedByID = userID,
                    CreatedDate = DateTime.Now,
                    UpdatedByID = userID,
                    UpdatedDate = DateTime.Now,
                    SurnameOrCompanyName = "",
                    FirstNames = "",
                    IDTypeID = null,
                    IDTypeDescription = "",
                    IDNumberOrBusinessRegistrationNo ="",
                    PostalAddress = "",
                    PostalAddressCode = "",
                    PhysicalAddress = "",
                    PhysicalAddressCode = "",
                    TelPhone = "",
                    TelCell = "",
                    TelFax = "",
                    Email = "",
                    SARSIncomeTaxNumber = "",
                    SARSReasonIfNoTaxNumber = "",
                    MemberStatusID = null,
                    OlasID = null,
                    LtpsID = null,
                    VerifiedMemberID = null,
                    VerifiedAssociationID = 0,
                    NewMemberRequestTypeID = (short)Common.MemberRequestType.New
                };
            }

            var details = (from q in Context.NewMemberRequestDetails
                           where q.NewMemberRequestDetailID == NewMemberRequestDetailId
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        //#region SearchNewMemberRequestDetails
        //public IEnumerable<Vw_NewMemberRequestDetails> SearchNewMemberRequestDetails(long NewMemberRequestDetailID, short workflowInstanceStatusID)
        //{
        //    return Context.Pr_NewMemberRequestDetailsSearch(NewMemberRequestDetailID, workflowInstanceStatusID).ToList();
        //} 
        //#endregion
    }
}