//
// 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;
}