public static CarInventoryView LoadOnInventoryId(int inventoryId)
{
CarInventoryViewSearch search = new CarInventoryViewSearch
{
InventoryId = inventoryId
};
return Search(search).FirstOrDefault();
}
public static IEnumerable<CarInventoryView> GetOnSearchFields(int? makeId, int? modelId, string state)
{
CarInventoryViewSearch search = new CarInventoryViewSearch
{
MakeId = makeId,
ModelId = modelId,
State = state
};
return Search(search);
}
public static IEnumerable<CarInventoryView> LoadAllActive()
{
CarInventoryViewSearch search = new CarInventoryViewSearch
{
InventoryDeleted= false,
LocationDeleted =false,
MakeDeleted =false,
ModelDeleted = false
};
return Search(search);
}
/// <summary>
/// Searches for CarMake
/// </summary>
/// <param name="item" />
/// <returns>An IEnumerable set of CarMake</returns>
public static IEnumerable<CarInventoryView> Search(CarInventoryViewSearch item)
{
List<SqlParameter> parameters
= new List<SqlParameter>
{
new SqlParameter("@InventoryId", item.InventoryId),
new SqlParameter("@ModelId", item.ModelId),
new SqlParameter("@CarYear", item.CarYear),
new SqlParameter("@Quantity", item.Quantity),
new SqlParameter("@LocationId", item.LocationId),
new SqlParameter("@Color", item.Color),
new SqlParameter("@Price", item.Price),
new SqlParameter("@InventoryDeleted", item.InventoryDeleted),
new SqlParameter("@makeid", item.MakeId),
new SqlParameter("@ModelName", item.ModelName),
new SqlParameter("@ModelDeleted", item.ModelDeleted),
new SqlParameter("@MakeName", item.MakeName),
new SqlParameter("@MakeDeleted", item.MakeDeleted),
new SqlParameter("@Manufacturer", item.Manufacturer),
new SqlParameter("@Address", item.Address),
new SqlParameter("@City", item.City),
new SqlParameter("@State", item.State),
new SqlParameter("@LocationName", item.LocationName),
new SqlParameter("@Zip", item.Zip),
new SqlParameter("@LocationDeleted", item.LocationDeleted)
};
if( item.CarImage != null)
{
parameters.Add(new SqlParameter("@CarImage", item.CarImage));
}
DataSet set = DataManager.ExecuteProcedure(KarzPlusConnectionString, "PKP_GetVKP_CarInventory", parameters);
IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet();
return ConvertToEntityObject(dataRows);
}
/// <summary>
/// Searches for CarInventoryView
/// </summary>
/// <param name="search" />
/// <returns>An IEnumerable set of CarInventoryView</returns>
public static IEnumerable<CarInventoryView> Search(CarInventoryViewSearch search)
{
return search == null ? new List<CarInventoryView>() : CarInventoryViewDao.Search(search);
}