public static void Save(XmlImportIngredient ingredient, string menuitemguid, string menuitemname)
{
var db = new Database("RedRobin");
var records = db.Fetch<XmlIngredientsXref>(" where xmlguid=@0 and xmlmenuitemguid=@1", ingredient.ItemIngredientGuid, menuitemguid);
if (records.Count >= 1) return;
var insert = new XmlIngredientsXref();
insert.xmlguid = new Guid(ingredient.ItemIngredientGuid);
insert.xmlingredientname = ingredient.ItemIngredientName;
insert.xmlmenuitemguid = new Guid(menuitemguid);
insert.xmlmenuitemname = menuitemname;
insert.Save();
}
public static void Save(XmlImportIngredient ingredient, string menuitemguid, string menuitemname)
{
var db = new Database("RedRobin");
var records = db.Fetch <XmlIngredientsXref>(" where xmlguid=@0 and xmlmenuitemguid=@1", ingredient.ItemIngredientGuid, menuitemguid);
if (records.Count >= 1)
{
return;
}
var insert = new XmlIngredientsXref();
insert.xmlguid = new Guid(ingredient.ItemIngredientGuid);
insert.xmlingredientname = ingredient.ItemIngredientName;
insert.xmlmenuitemguid = new Guid(menuitemguid);
insert.xmlmenuitemname = menuitemname;
insert.Save();
}
public IngredientCandidates GetIngredientCandidates(XmlImportIngredient ingredient)
{
var candidates = new IngredientCandidates();
candidates.ByNameCandidates = GetIngredientCandidatesByName(ingredient.ItemIngredientName);
var xmlmenuitem = GetXmlImportMenuItemByMenuItemId(ingredient.XmlImportMenuItemId.ToString());
if (xmlmenuitem != null)
{
var menuxref = GetMenuCrossReference(xmlmenuitem.ItemGuid);
if (menuxref != null)
{
candidates.ByPreviousCandidates = GetIngredientCandidatesByPrevious(menuxref.menuitemguid.ToString());
}
}
return(candidates);
}
private string GetFactValueFromImport(XmlImportIngredient xmlimport, int factid)
{
switch (factid)
{
case 1:
return(xmlimport.Calories);
case 3:
return(xmlimport.Quantity);
case 4:
return(xmlimport.Fat);
case 5:
return(xmlimport.SaturatedFat);
case 6:
return(xmlimport.Sodium);
case 7:
return(xmlimport.Carbohydrates);
case 8:
return(xmlimport.Protein);
case 9:
return(xmlimport.Sugar);
case 10:
return(xmlimport.Cholesterol);
case 11:
return(xmlimport.FatCalories);
case 12:
return(xmlimport.Fiber);
case 13:
return(xmlimport.TransFat);
default:
return("");
}
}
private string GetFactValueFromImport( XmlImportIngredient xmlimport, int factid )
{
switch (factid)
{
case 1:
return xmlimport.Calories;
case 3:
return xmlimport.Quantity;
case 4:
return xmlimport.Fat;
case 5:
return xmlimport.SaturatedFat;
case 6:
return xmlimport.Sodium;
case 7:
return xmlimport.Carbohydrates;
case 8:
return xmlimport.Protein;
case 9:
return xmlimport.Sugar;
case 10:
return xmlimport.Cholesterol;
case 11:
return xmlimport.FatCalories;
case 12:
return xmlimport.Fiber;
case 13:
return xmlimport.TransFat;
default:
return "";
}
}
public IngredientCandidates GetIngredientCandidates(XmlImportIngredient ingredient)
{
var candidates = new IngredientCandidates();
candidates.ByNameCandidates = GetIngredientCandidatesByName(ingredient.ItemIngredientName);
var xmlmenuitem = GetXmlImportMenuItemByMenuItemId(ingredient.XmlImportMenuItemId.ToString());
if (xmlmenuitem != null)
{
var menuxref = GetMenuCrossReference(xmlmenuitem.ItemGuid);
if (menuxref != null)
candidates.ByPreviousCandidates = GetIngredientCandidatesByPrevious(menuxref.menuitemguid.ToString());
}
return candidates;
}
