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.NewVehicleRequest.Models
{
    public class NewVehicleDatabase : Database<NewVehicleContext>
    {
        public NewVehicleDatabase()
            : base(new NewVehicleContext())
        {

        }

        #region GetNewVehicleRequest
        public NewVehicleRequestDetail GetNewVehicleRequest(long NewVehicleRequestDetailId, long userID)
        {
            if (NewVehicleRequestDetailId == -1)
            {
                return new NewVehicleRequestDetail()
                {
                    NewVehicleRequestDetailID = NewVehicleRequestDetailId,
                    CreatedByID = userID,
                    CreatedDate = DateTime.Now,
                    UpdatedByID = userID,
                    UpdatedDate = DateTime.Now,                    
                    VehicleTypeID = null,
                   

                };
            }

            var details = (from q in Context.NewVehicleRequestDetails
                           where q.NewVehicleRequestDetailID == NewVehicleRequestDetailId
                           select q).FirstOrDefault();

            return details;
        }
        #endregion

        //#region SearchNewVehicleRequestDetails
        //public IEnumerable<Vw_NewVehicleRequestDetails> SearchNewVehicleRequestDetails(long NewVehicleRequestDetailID, short workflowInstanceStatusID)
        //{
        //    return Context.Pr_NewVehicleRequestDetailsSearch(NewVehicleRequestDetailID, workflowInstanceStatusID).ToList();
        //} 
        //#endregion
    }
}