public JsonResult GetPaints(PaintFilter filter)
{
var els = DataProvider.GetPaints(filter);
return(new JsonResult(els)
{
});
}
public static List <ProductDTO> GetPaints(PaintFilter filter)
{
DataTable dt = new DataTable();
List <ProductDTO> ProductsList = new List <ProductDTO>();
using (SqlConnection conn = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("sp_get_paints", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@paint_id", filter.ID);
cmd.Parameters.AddWithValue("@min_amount", filter.MinPrice);
cmd.Parameters.AddWithValue("@max_amount", filter.MaxPrice);
cmd.Parameters.AddWithValue("@type", filter.Paint_type.ConvertToSqlArr());
cmd.Parameters.AddWithValue("@volume", filter.Volumes.ConvertToSqlArr());
cmd.Parameters.AddWithValue("@color", filter.Colors.ConvertToSqlArr());
cmd.Parameters.AddWithValue("@country", filter.Countries.ConvertToSqlArr());
cmd.Parameters.AddWithValue("@manufact", filter.Manufacturers.ConvertToSqlArr());
cmd.Parameters.AddWithValue("@start", filter.Start);
cmd.Parameters.AddWithValue("@end", filter.End);
conn.Open();
dt.Load(cmd.ExecuteReader());
foreach (DataRow dr in dt.Rows)
{
ProductsList.Add(dr.ConvertToProductDTO());
}
return(ProductsList);
}
}
public JsonResult GetPaints(PaintFilter filter)
{
return new JsonResult() { };
}
public IEnumerable <CarPaintEntity> GetMany(PaintFilter filter)
{
throw new NotImplementedException();
}
public CarPaintEntity Get(PaintFilter filter)
{
return(Context.Paints
.Where(x => x.Name == filter.Name)
.FirstOrDefault());
}
