public static List <ProductDTO> GetKovki(KovkaFilter filter) { DataTable dt = new DataTable(); List <ProductDTO> ProductsList = new List <ProductDTO>(); using (SqlConnection conn = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("sp_get_kovki", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@kovka_id", filter.ID); cmd.Parameters.AddWithValue("@min_amount", filter.MinPrice); cmd.Parameters.AddWithValue("@max_amount", filter.MaxPrice); cmd.Parameters.AddWithValue("@type", filter.Kovka_type.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 GetKovka(KovkaFilter filter) { var els = DataProvider.GetKovki(filter); return(new JsonResult(els) { }); }