//
        // GET: /Appraiser/Find
        public ActionResult Find(int id = 0)
        {
            Appraiser appraiserModel = new Appraiser();

            if (id != 0)
            {
                appraiserModel = _appraisalServiceModel.Get_Appraiser(id);
            }

            return View(appraiserModel);
        }
        /// <summary>
        /// Gets an individual Appraiser based on the appraiser's appraiserId
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public virtual Appraiser GetAppraiserById(int id)
        {
            var appraiser = new Appraiser();

            // Build the parameter for the database call
            var parameters = new List<SqlParameter> { new SqlParameter { ParameterName = "@id", Value = id, SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input } };

            // Get data from the database
            DataTable dataTable = GetDataFromStoredProc("GetAppraiserById", parameters);

            // Popluate the appraiser object
            if (dataTable.Rows.Count > 0)
            {
                appraiser = PopulateAppraiserFromDataTable(dataTable);
            }

            return appraiser;
        }