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