private WineVarieties GetWineVariety(string varietyName)
{
if (varietyName == null)
{
return(null);
}
var fixedName = varietyName.Replace("What's in the Bottle", String.Empty);
var wineVarieties = _context.WineVarieties.ToList();
foreach (var wineVariety in wineVarieties)
{
var internalName = wineVariety.Name.ToLower().Replace(" ", Empty);
var externalName = fixedName.ToLower().Replace(" ", Empty);
if (externalName.Contains(internalName))
{
_processLog.WriteLine("Found Variety: " + internalName);
return(wineVariety);
}
}
WineVarieties grapes = new WineVarieties()
{
Name = fixedName
};
_context.WineVarieties.Add(grapes);
_context.SaveChanges();
_processLog.WriteLine("Adding Variety: " + grapes.Name);
return(grapes);
}
private WineList SaveWineItem(UpcDbModel wineInfo, WineVarieties wineVariety)
{
var wineData = new WineList()
{
Upc = wineInfo.UpcCode,
AlchoholLevel = (int?)wineInfo.AlchoholLevel,
WineVarietiesVarietyId = wineVariety.VarietyId,
Region = wineInfo.Region,
Producer = wineInfo.Winery ?? "N/A",
Vintage = wineInfo.Year,
Size = wineInfo.Size,
};
if (wineData.Upc.IsNullOrEmpty())
{
wineData.Upc = GetInternalBarCode();
}
if (wineData.Region.IsNullOrEmpty())
{
wineData.Region = string.Empty;
}
if (wineData.Size == 0)
{
wineData.Size = 750;
}
wineData.CreatedDate = DateTime.UtcNow;
_context.WineList.Add(wineData);
_context.SaveChanges();
_processLog.WriteLine("UPC: " + wineData.Upc + " Saving item: " + wineInfo.WineName + " - " + wineInfo.Varietal + ", " + wineInfo.Winery);
Console.Write(".");
return(wineData);
}
