public void GetItemsBuy(string connectionString, RequestItemsBuy req)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
Items = new List <ITEMS_BUY>();
string sqlExpression = @"SELECT
ID_ITEMS_BUY,
ID_ITEMS_SHOP,
NAME_IB,
NOTE_IB,
IMG_URL,
PRICE
FROM SPAVREMONT.ITEMS_BUY
WHERE id_items_shop='" + req.id_items_shop + @"'
";
connection.Open();
SqlCommand command = new SqlCommand();
command.CommandText = sqlExpression;
command.Connection = connection;
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows) // если есть данные
{
int ID_ITEMS_BUY_Index = reader.GetOrdinal("ID_ITEMS_BUY");
int ID_ITEMS_SHOP_Index = reader.GetOrdinal("ID_ITEMS_SHOP");
int NAME_IB_Index = reader.GetOrdinal("NAME_IB");
int NOTE_IB_Index = reader.GetOrdinal("NOTE_IB");
int IMG_URL_Index = reader.GetOrdinal("IMG_URL");
int PRICE_Index = reader.GetOrdinal("PRICE");
while (reader.Read()) // построчно считываем данные
{
ITEMS_BUY Item = new ITEMS_BUY
{
ID_ITEMS_BUY = reader.GetString(ID_ITEMS_BUY_Index),
IMG_URL = reader.GetString(IMG_URL_Index),
ID_ITEMS_SHOP = reader.GetString(ID_ITEMS_SHOP_Index),
NAME_IB = reader.GetString(NAME_IB_Index),
NOTE_IB = reader.GetString(NOTE_IB_Index),
PRICE = reader.GetInt32(PRICE_Index)
};
Items.Add(Item);
}
}
}
}
// GET
public string Get([FromQuery] RequestItemsBuy req)
{
string json = "";
if (req.id_items_shop == null || req.id_items_shop == "")
{
return("items is null");
}
try
{
ResponseItems_buy resp = new ResponseItems_buy();
resp.GetItemsBuy(Constants.connectDB, req);
json = JsonConvert.SerializeObject(resp); //, Formatting.Indented
}
catch (Exception ex)
{
json += " err " + ex.Message;
}
return(json);
}
