public async Task <IActionResult> Edit(int id, [Bind("VineyardID,Dimension,Humidity,VineGrowerID,WineID")] Vineyard vineyard)
{
if (id != vineyard.VineyardID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vineyard);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VineyardExists(vineyard.VineyardID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["VineGrowerID"] = new SelectList(_context.VineGrowers, "ID", "ID", vineyard.VineGrowerID);
ViewData["WineID"] = new SelectList(_context.Wines, "WineID", "WineID", vineyard.WineID);
return(View(vineyard));
}
public async Task <IActionResult> Create([Bind("VineyardID,Dimension,Humidity,VineGrowerID,WineID")] Vineyard vineyard)
{
if (ModelState.IsValid)
{
_context.Add(vineyard);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["VineGrowerID"] = new SelectList(_context.VineGrowers, "ID", "ID", vineyard.VineGrowerID);
ViewData["WineID"] = new SelectList(_context.Wines, "WineID", "WineID", vineyard.WineID);
return(View(vineyard));
}
public async Task UpdateVineyardAsync(string id, Vineyard vineyardIn) => await _vineyards.ReplaceOneAsync(vineyard => vineyard.Id == id, vineyardIn).ConfigureAwait(false);
public async Task <Vineyard> CreateVineyardAsync(Vineyard vineyard)
{
await _vineyards.InsertOneAsync(vineyard);
return(vineyard);
}
public void AddToVineyards(Vineyard vineyard)
{
base.AddObject("Vineyards", vineyard);
}
public static Vineyard CreateVineyard(string ID)
{
Vineyard vineyard = new Vineyard();
vineyard.Id = ID;
return vineyard;
}
private void Seed()
{
using var context = new DataContext(ContextOptions);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
var region = new Region
{
Id = 1,
Region1 = "Yarra valley"
};
var wineType = new Winetype
{
Id = 1,
Winetype1 = "Shiraz"
};
var vineyard = new Vineyard
{
Id = 1,
Vineyard1 = "Mark's vineyard"
};
var box = new Box
{
Boxno = 101,
Size = "Tiny"
};
var wineList = new Winelist
{
Id = 50,
Winetype = new Winetype
{
Winetype1 = "Sav Blanc"
},
Region = new Region
{
Region1 = "My Region"
},
Vineyard = new Vineyard
{
Vineyard1 = "My vineyard"
},
Locations = new List <Location>
{
new Location
{
BoxNavigation = new Box
{
Boxno = 55,
Size = "big"
},
No = 2
}
}
};
context.AddRange(region, wineType, vineyard, box, wineList);
context.SaveChanges();
}
public static void Initialize(VineyardContext context)
{
context.Database.EnsureCreated();
if (context.Vineyards.Any())
{
return;
}
// Tabella viticoltori
var vinegrowers = new VineGrower[]
{
new VineGrower {
FullName = "Marco Zucchini"
},
new VineGrower {
FullName = "Alex Costea"
},
new VineGrower {
FullName = "Kristian Hristov"
},
new VineGrower {
FullName = "Florin Mocanu"
},
new VineGrower {
FullName = "Salin Kumar"
},
new VineGrower {
FullName = "Danielle Cutilli"
},
new VineGrower {
FullName = "Artenis Molla"
},
new VineGrower {
FullName = "Riccardo Sibio"
},
new VineGrower {
FullName = "Alex Toghe"
},
new VineGrower {
FullName = "Max Pancini"
},
new VineGrower {
FullName = "Morgan"
}
};
// Aggiunta dei valori da "vinegrowers" nella rispettiva tabella
foreach (var v in vinegrowers)
{
context.VineGrowers.Add(v);
}
context.SaveChanges();
// Tabella vini
var wines = new Wine[]
{
new Wine {
Type = TypeW.Barricato
},
new Wine {
Type = TypeW.Bianco
},
new Wine {
Type = TypeW.Passito
},
new Wine {
Type = TypeW.Rosato
},
new Wine {
Type = TypeW.Arancione
},
new Wine {
Type = TypeW.Novello
},
new Wine {
Type = TypeW.Rosso
},
new Wine {
Type = TypeW.Spumante
}
};
foreach (var w in wines)
{
context.Wines.Add(w);
}
context.SaveChanges();
// Tabella vigneti
var vineyards = new Vineyard[]
{
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 1, WineID = 1
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 2, WineID = 2
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 5, WineID = 3
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 1, WineID = 4
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 5, WineID = 5
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 5, WineID = 6
},
new Vineyard {
Dimension = 180, Humidity = 23, VineGrowerID = 1, WineID = 7
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 8, WineID = 8
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 9, WineID = 1
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 11, WineID = 2
},
new Vineyard {
Dimension = 80, Humidity = 13, VineGrowerID = 11, WineID = 3
}
};
foreach (var y in vineyards)
{
context.Vineyards.Add(y);
}
context.SaveChanges();
}
