public List <WineDataModel> GetAll()
{
string _connectionString = "Server=localhost\\SQLEXPRESS;Database=Wine;Trusted_Connection=True;";
using SqlConnection con = new SqlConnection(_connectionString);
using var command = new SqlCommand("select * from winecellar", con);
con.Open();
DbDataReader reader = command.ExecuteReader();
var WineData = new List <WineDataModel>();
{
while (reader.Read())
{
var Wine = new WineDataModel
{
Id = reader.IsDBNull(reader.GetOrdinal("id")) ? 0 : reader.GetInt32(reader.GetOrdinal("id")),
Name = reader.IsDBNull(reader.GetOrdinal("name")) ? "" : reader.GetString(reader.GetOrdinal("name")),
Color = reader.IsDBNull(reader.GetOrdinal("color")) ? "" : reader.GetString(reader.GetOrdinal("color"))
};
WineData.Add(Wine);
}
};
con.Close();
return(WineData);
}
public void Add(WineDataModel wine)
{
string _connectionString = "Server=localhost\\SQLEXPRESS;Database=Wine;Trusted_Connection=True;";
using SqlConnection con = new SqlConnection(_connectionString);
using var command = new SqlCommand("insert into winecellar values ( '" + wine.Name + "', '" + wine.Color + "')", con);
con.Open();
DbDataReader reader = command.ExecuteReader();
con.Close();
}
private void CreateWines()
{
WineDataModel wineDataModelPinotNoir = new WineDataModel();
wineDataModelPinotNoir.Id = 0;
wineDataModelPinotNoir.Name = "Pinot Noir";
wineDataModelPinotNoir.Color = "Red";
//wineDataModelPinotNoir.Taste = new List<string>() { "Cherry", "Cranberry", "Rose", "Rhubarb" };
//wineDataModelPinotNoir.FoodPairing = new List<string>() { "Chicken", "Pork", "Duck", "Soft Cheese" };
_wineDataModels.Add(wineDataModelPinotNoir);
WineDataModel wineDataModelRiesling = new WineDataModel();
wineDataModelRiesling.Id = 1;
wineDataModelRiesling.Name = "Riesling";
wineDataModelRiesling.Color = "White";
//wineDataModelRiesling.Taste = new List<string>() { "citrus", "nectarine", "floral" };
//wineDataModelRiesling.FoodPairing = new List<string>() { "chicken", "pork", "duck", "indian", "thai", "vietnamese" };
_wineDataModels.Add(wineDataModelRiesling);
}
public void Add(WineDataModel wine)
{
throw new NotImplementedException();
}
public void AddWine(WineDataModel wine)
{
_repository.Add(wine);
}
public ActionResult <WineDataModel> AddWine(WineDataModel wineDataModel)
{
wineItemsProvider.AddWine(wineDataModel);
return(CreatedAtAction(nameof(GetWineById), new { id = wineDataModel.Id }, wineDataModel));
}
