public IEnumerable <Featured_Item> GetRecent()
{
List <Featured_Item> list = new List <Featured_Item>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("MobileSuitSelectRecent", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
Featured_Item row = new Featured_Item();
row.InventoryNumber = (int)rdr["InventoryNumber"];
row.Make = rdr["MakeName"].ToString();
row.Model = rdr["ModelName"].ToString();
row.Name = rdr["Name"].ToString();
row.SalePrice = (int)rdr["SalePrice"];
if (rdr["Image"] != DBNull.Value)
{
row.Image = rdr["Image"].ToString();
}
list.Add(row);
}
}
}
return(list);
}
public IEnumerable <Featured_Item> SaleSearch(MobileSuitSearchParametersSales parameters)
{
List <Featured_Item> listings = new List <Featured_Item>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
string query = "SELECT TOP 12 InventoryNumber,[Name],MA.MakeName,MO.ModelName,SerialNumber,UserID,MS.MakeModelID,TypeID,[BodyStyleID],[Year],[CenturyID],WeaponID,ColorID,Interior,MSRP,SalePrice, [Description], [Image], [Creation Date], Featured FROM [Mobile Suit] MS Inner Join MakeModel MM on MS.MakeModelID = MM.MakeModelID INNER JOIN Make MA on MM.MakeID = MA.MakeID INNER JOIN Model MO on MM.ModelID = MO.ModelID Where 1=1";
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
if (parameters.MinRate.HasValue)
{
query += "AND SalePrice >= @MinRate ";
cmd.Parameters.AddWithValue("@MinRate", parameters.MinRate.Value);
}
if (parameters.MaxRate.HasValue)
{
query += "AND SalePrice <= @MaxRate ";
cmd.Parameters.AddWithValue("@MaxRate", parameters.MaxRate.Value);
}
if (!string.IsNullOrEmpty(parameters.Make))
{
query += "AND MA.MakeId= @Make ";
cmd.Parameters.AddWithValue("@Make", parameters.Make);
}
if (!string.IsNullOrEmpty(parameters.Model))
{
query += "AND MO.ModelId = @Model ";
cmd.Parameters.AddWithValue("@Model", parameters.Model);
}
query += "ORDER BY [Creation Date] DESC";
cmd.CommandText = query;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Featured_Item row = new Featured_Item();
row.InventoryNumber = (int)dr["InventoryNumber"];
row.Make = dr["MakeName"].ToString();
row.Model = dr["ModelName"].ToString();
row.SalePrice = (int)dr["SalePrice"];
row.Name = dr["Name"].ToString();
if (dr["Image"] != DBNull.Value)
{
row.Image = dr["Image"].ToString();
}
listings.Add(row);
}
}
}
return(listings);
}
