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()); }