//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated from a template.
//
//     Manual changes to this file may cause unexpected behavior in your application.
//     Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace BuddyFinance.Model
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;

    public partial class BuddyFinanceDBEntities : DbContext
    {
        public BuddyFinanceDBEntities()
            : base("name=BuddyFinanceDBEntities")
        {
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }

        public virtual DbSet<ActivityLog> ActivityLogs { get; set; }
        public virtual DbSet<AddressType> AddressTypes { get; set; }
        public virtual DbSet<AuthenticationCode> AuthenticationCodes { get; set; }
        public virtual DbSet<BankingDetail> BankingDetails { get; set; }
        public virtual DbSet<CashDeposit> CashDeposits { get; set; }
        public virtual DbSet<CashWithdrawal> CashWithdrawals { get; set; }
        public virtual DbSet<CashWithdrawalStatus> CashWithdrawalStatuses { get; set; }
        public virtual DbSet<Country> Countries { get; set; }
        public virtual DbSet<DocumentType> DocumentTypes { get; set; }
        public virtual DbSet<EmploymentDetail> EmploymentDetails { get; set; }
        public virtual DbSet<EmploymentStatus> EmploymentStatuses { get; set; }
        public virtual DbSet<EmploymentType> EmploymentTypes { get; set; }
        public virtual DbSet<Ethnicity> Ethnicities { get; set; }
        public virtual DbSet<FicaCompliance> FicaCompliances { get; set; }
        public virtual DbSet<FicaComplianceDocument> FicaComplianceDocuments { get; set; }
        public virtual DbSet<FicaStatus> FicaStatuses { get; set; }
        public virtual DbSet<FileData> FileDatas { get; set; }
        public virtual DbSet<Gender> Genders { get; set; }
        public virtual DbSet<GlobalSetup> GlobalSetups { get; set; }
        public virtual DbSet<IdentificationType> IdentificationTypes { get; set; }
        public virtual DbSet<LoanEarningBracket> LoanEarningBrackets { get; set; }
        public virtual DbSet<LoanPayout> LoanPayouts { get; set; }
        public virtual DbSet<LoanRepayment> LoanRepayments { get; set; }
        public virtual DbSet<LoanRepaymentStatus> LoanRepaymentStatuses { get; set; }
        public virtual DbSet<LoanRequestScore> LoanRequestScores { get; set; }
        public virtual DbSet<LoanRequestStatus> LoanRequestStatuses { get; set; }
        public virtual DbSet<LoanSchedule> LoanSchedules { get; set; }
        public virtual DbSet<LoanScheduleFee> LoanScheduleFees { get; set; }
        public virtual DbSet<LoanScheduleStatus> LoanScheduleStatuses { get; set; }
        public virtual DbSet<LoanStatus> LoanStatuses { get; set; }
        public virtual DbSet<LoanTermBracket> LoanTermBrackets { get; set; }
        public virtual DbSet<ManualDeduction> ManualDeductions { get; set; }
        public virtual DbSet<NextOfKin> NextOfKins { get; set; }
        public virtual DbSet<Notification> Notifications { get; set; }
        public virtual DbSet<NotificationType> NotificationTypes { get; set; }
        public virtual DbSet<OfferStatus> OfferStatuses { get; set; }
        public virtual DbSet<PreLoanRequest> PreLoanRequests { get; set; }
        public virtual DbSet<ProfileAddress> ProfileAddresses { get; set; }
        public virtual DbSet<ProfileApproval> ProfileApprovals { get; set; }
        public virtual DbSet<ProfileCreditRatingScore> ProfileCreditRatingScores { get; set; }
        public virtual DbSet<ProfileDocument> ProfileDocuments { get; set; }
        public virtual DbSet<ProfileStatus> ProfileStatuses { get; set; }
        public virtual DbSet<ProfileSuspension> ProfileSuspensions { get; set; }
        public virtual DbSet<ProfileType> ProfileTypes { get; set; }
        public virtual DbSet<Province> Provinces { get; set; }
        public virtual DbSet<RequestLog> RequestLogs { get; set; }
        public virtual DbSet<RobotScore> RobotScores { get; set; }
        public virtual DbSet<SourceOfFund> SourceOfFunds { get; set; }
        public virtual DbSet<SourceOfIncome> SourceOfIncomes { get; set; }
        public virtual DbSet<TaxIdentificationType> TaxIdentificationTypes { get; set; }
        public virtual DbSet<TaxInformation> TaxInformations { get; set; }
        public virtual DbSet<TermType> TermTypes { get; set; }
        public virtual DbSet<Transaction> Transactions { get; set; }
        public virtual DbSet<TransactionFee> TransactionFees { get; set; }
        public virtual DbSet<TransactionStatus> TransactionStatuses { get; set; }
        public virtual DbSet<TransactionType> TransactionTypes { get; set; }
        public virtual DbSet<User> Users { get; set; }
        public virtual DbSet<UserRole> UserRoles { get; set; }
        public virtual DbSet<Loan> Loans { get; set; }
        public virtual DbSet<LoanRequestOffer> LoanRequestOffers { get; set; }
        public virtual DbSet<FeeType> FeeTypes { get; set; }
        public virtual DbSet<LoanOffer> LoanOffers { get; set; }
        public virtual DbSet<LoanRequest> LoanRequests { get; set; }
        public virtual DbSet<Borrower> Borrowers { get; set; }
        public virtual DbSet<Lender> Lenders { get; set; }
        public virtual DbSet<Profile> Profiles { get; set; }

        public virtual ObjectResult<ProfileTransactions_Result> ProfileTransactions(Nullable<int> profileId, string startDate, string endDate)
        {
            var profileIdParameter = profileId.HasValue ?
                new ObjectParameter("profileId", profileId) :
                new ObjectParameter("profileId", typeof(int));

            var startDateParameter = startDate != null ?
                new ObjectParameter("startDate", startDate) :
                new ObjectParameter("startDate", typeof(string));

            var endDateParameter = endDate != null ?
                new ObjectParameter("endDate", endDate) :
                new ObjectParameter("endDate", typeof(string));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<ProfileTransactions_Result>("ProfileTransactions", profileIdParameter, startDateParameter, endDateParameter);
        }
    }
}