public decimal GetIngredientCategoryBID(decimal?MID)
{
IngredientCategory IngC = new IngredientCategory();
IngC.ICID = db.INGREDIENT_CATEGORY.First(A => A.MANUFACTURER_ID == MID).ID;
return(IngC.ICID);
}
public ActionResult DeleteConfirmed(int id)
{
IngredientCategory ingredientCategory = _ingredientCategoryService.GetById(id);
_ingredientCategoryService.Delete(ingredientCategory);
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Edit(int id, [Bind("IngredientId,CategoryId")] IngredientCategory ingredientCategory)
{
if (id != ingredientCategory.CategoryId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(ingredientCategory);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IngredientCategoryExists(ingredientCategory.CategoryId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoryId"] = new SelectList(_context.Categories, "CategoryId", "CategoryId", ingredientCategory.CategoryId);
ViewData["IngredientId"] = new SelectList(_context.Ingredients, "IngredientId", "IngredientId", ingredientCategory.IngredientId);
return(View(ingredientCategory));
}
public async Task <IEnumerable <Ingredient> > GetIngredientsForCategory(IngredientCategory ingredientType)
{
IEnumerable <Ingredient> result = await _context.Ingredients
.Where(x => x.Type == (int)ingredientType)
.ToListAsync();
return(result);
}
private static void ReadIngredientCategory(string filename, FlavorNetworkContext context)
{
var ingredientCategoryCsvSchema = new CsvSchema();
ingredientCategoryCsvSchema.Properties.Add(new SchemaProperty("Id"));
ingredientCategoryCsvSchema.Properties.Add(new SchemaProperty("Name"));
ingredientCategoryCsvSchema.Properties.Add(new SchemaProperty("Category"));
var ingredientCategoryCsvReader = new CsvReader <IngredientAndCategory>();
ingredientCategoryCsvReader.CsvDelimiter = "\t";
ingredientCategoryCsvReader.UseSingleLineHeaderInCsv = true;
ingredientCategoryCsvReader.Schema = ingredientCategoryCsvSchema;
var list = ingredientCategoryCsvReader.Read(File.OpenRead(filename));
int id = 1;
foreach (var item in list.Distinct(new CategoryEqualityComparer()))
{
var category = new IngredientCategory();
category.Id = id;
category.Name = item.Category;
category.Ingredients = new List <Ingredient>();
context.IngredientCategories.Add(category);
id++;
}
foreach (var item in list)
{
item.Id = item.Id + 1;
var ingredient = new Ingredient();
ingredient.Id = item.Id;
ingredient.Name = GetIngredientName(item.Name);
ingredient.IngredientCompounds = new List <IngredientCompound>();
ingredient.IngredientContributions = new List <IngredientContribution>();
ingredient.RecipeIngredients = new List <RecipeIngredient>();
var category = context.IngredientCategories.Local.SingleOrDefault(r => r.Name.Equals(item.Category));
if (category != null)
{
ingredient.IngredientCategory = category;
ingredient.IngredientCategoryId = category.Id;
category.Ingredients.Add(ingredient);
context.Ingredients.Add(ingredient);
}
else
{
Console.WriteLine($"Category '{item.Category}' not found!!!");
}
//Console.WriteLine($"Id: '{item.Id}', N: '{item.Name}', C: '{item.Category}'");
}
}
public ActionResult Edit([Bind(Include = "IngredientCategoryId,Name,Id")] IngredientCategory ingredientCategory)
{
if (ModelState.IsValid)
{
_ingredientCategoryService.Update(ingredientCategory);
return(RedirectToAction("Index"));
}
return(View(ingredientCategory));
}
public Ingredient(string ingredientName, decimal ingredientPrice, bool isAddOn, bool isDairyFree, bool isGlutenFree, bool isVegan, int stockLevel, IngredientCategory ingredientType)
{
IngredientName = ingredientName;
IngredientPrice = ingredientPrice;
IsAddOn = isAddOn;
IsDairyFree = isDairyFree;
IsGlutenFree = isGlutenFree;
IsVegan = isVegan;
StockLevel = stockLevel;
IngredientType = ingredientType;
}
public void AddIngredientCategory(IngredientCategory IC)
{
INGREDIENT_CATEGORY ict = new INGREDIENT_CATEGORY();
ict.ID = IC.ICID;
ict.NAME = IC.Name;
ict.FRONTEND_ID = IC.FrontendID;
ict.MANUFACTURER_ID = IC.ManufacturerID;
db.INGREDIENT_CATEGORY.Add(ict);
db.SaveChanges();
}
internal static IngredientCategoryModel Create(IngredientCategory obj)
{
if (obj == null)
{
return(null);
}
return(new IngredientCategoryModel()
{
Id = obj.Id,
Name = obj.Name
});
}
public async Task <IActionResult> Create([Bind("IngredientId,CategoryId")] IngredientCategory ingredientCategory)
{
if (ModelState.IsValid)
{
_context.Add(ingredientCategory);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoryId"] = new SelectList(_context.Categories, "CategoryId", "CategoryId", ingredientCategory.CategoryId);
ViewData["IngredientId"] = new SelectList(_context.Ingredients, "IngredientId", "IngredientId", ingredientCategory.IngredientId);
return(View(ingredientCategory));
}
/// <summary>
/// Creates an <see cref="IngredientCategoryModel"/> instance from the given <see cref="IngredientCategory"/>.
/// </summary>
/// <param name="ingredientCategory">An ingredient category.</param>
/// <returns>A read-only view of the given ingredient category.</returns>
public static IngredientCategoryModel From(IngredientCategory ingredientCategory)
{
if (ingredientCategory == null)
{
return(null);
}
return(new IngredientCategoryModel()
{
Id = ingredientCategory.Id,
Name = ingredientCategory.Name
});
}
// GET: IngredientCategories/Delete/5
public ActionResult Delete(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
IngredientCategory ingredientCategory = _ingredientCategoryService.GetById(id);
if (ingredientCategory == null)
{
return(HttpNotFound());
}
return(View(ingredientCategory));
}
public static IEnumerable <IngredientCategory> GetDefaultCategories()
{
List <IngredientCategory> categories = new List <IngredientCategory>
{
IngredientCategory.Create("First Category"),
IngredientCategory.Create("Second Category"),
IngredientCategory.Create("Third Category"),
IngredientCategory.Create("4th Category"),
IngredientCategory.Create("5th Category"),
IngredientCategory.Create("other-ingredients")
};
return(categories);
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
IngredientCategory = await _context.IngredientCategories.FirstOrDefaultAsync(m => m.IngredientCategoryID == id);
if (IngredientCategory == null)
{
return(NotFound());
}
return(Page());
}
public void Valid_IngredientCategory_Create()
{
//Arrange
IngredientCategory c = new IngredientCategory()
{
Name = "test1"
};
//Act
var result = (RedirectToRouteResult)objController.Create(c);
//Assert
_ingredientCategoryServiceMock.Verify(m => m.Create(c), Times.Once);
Assert.AreEqual("Index", result.RouteValues["action"]);
}
public void DeleteItemFromDataStore()
{
IngredientCategory removing = Context.IngredientCategories.First();
Context.IngredientCategories.Delete(removing.Id);
Context.SaveChanges();
//Check save successful by opening new context and inspecting data
NachoMaticContext newContext = new NachoMaticContext();
bool itemGone = newContext.IngredientCategories.All(i => i.Name != removing.Name);
Assert.IsTrue(itemGone);
}
public IHttpActionResult PostGroceryCategory(IngredientCategoryModel ingredientCategoryModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var ingredientCategory = new IngredientCategory();
ObjectFactory.Parse(ingredientCategoryModel, ingredientCategory);
_ingredientCategoryService.Add(ingredientCategory);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = ingredientCategory.Id }, ingredientCategory));
}
public void Invalid_IngredientCategory_Create()
{
// Arrange
IngredientCategory c = new IngredientCategory()
{
Name = ""
};
objController.ModelState.AddModelError("Error", "Something went wrong");
//Act
var result = (ViewResult)objController.Create(c);
//Assert
_ingredientCategoryServiceMock.Verify(m => m.Create(c), Times.Never);
Assert.AreEqual("", result.ViewName);
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
IngredientCategory = await _context.IngredientCategories.FindAsync(id);
if (IngredientCategory != null)
{
_context.IngredientCategories.Remove(IngredientCategory);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public static IngredientCategory Parse(IngredientCategoryModel model, IngredientCategory obj)
{
if (model == null)
{
return(null);
}
if (obj == null)
{
return(null);
}
obj.Id = model.Id;
obj.Name = model.Name;
return(obj);
}
public async Task AddIngredientCustom(Guid recipeId, string categoryName, string measureUnit, string name,
double quantity, double cost, double weight)
{
Ingredient ingredient;
if (!await Exists(name, measureUnit))
{
Guid categoryId;
if (!await _ingredientsCategoryRepository.Exists(categoryName))
{
IngredientCategory igCat = IngredientCategory.Create(categoryName);
await _ingredientsCategoryRepository.Add(igCat);
categoryId = igCat.Id;
}
else
{
categoryId = (await _ingredientsCategoryRepository.GetByName(categoryName)).Id;
}
double scale = IngredientsRepository.MapMeasurement["undefined"];
if (IngredientsRepository.MapMeasurement.ContainsKey(measureUnit))
{
scale = IngredientsRepository.MapMeasurement[measureUnit];
}
ingredient = Ingredient.Create(categoryId, name, measureUnit, cost * scale * weight / 10000000);
await Add(ingredient);
await UpdateIngredientsCategory(name, await GetSpecificCategory(name));
}
else
{
if (!categoryName.Equals("other-ingredients"))
{
if (!await _ingredientsCategoryRepository.Exists(categoryName))
{
IngredientCategory igCat = IngredientCategory.Create(categoryName);
await _ingredientsCategoryRepository.Add(igCat);
}
await UpdateIngredientsCategory(name, (await _ingredientsCategoryRepository.GetByName(categoryName)).Id);
}
ingredient = await GetByNameAndMeasure(name, measureUnit);
}
await _fridgeRepository.Add(PairItem.Create(ingredient.Id, recipeId, quantity));
}
public Boolean UpdateIngredientsCategory(IngredientCategory IC)//IngredientCategory Object
{
INGREDIENT_CATEGORY result = (from p in db.INGREDIENT_CATEGORY
where p.ID == IC.ICID
select p).SingleOrDefault();
result.NAME = IC.Name;
result.FRONTEND_ID = IC.FrontendID;
result.MANUFACTURER_ID = IC.ManufacturerID;
try
{
db.SaveChanges();
return(true);
}
catch (DbUpdateException ex)
{
return(false);
}
}
public void GetByName_Should_Work_Ok()
{
RunOnDatabase(async s =>
{
DestroyDatabase();
// Arrange
var categoryRepo = new IngredientsCategoryRepository(s);
IEnumerable <IngredientCategory> categories = GetDefaultCategories();
// Act
foreach (var ingredientCategory in categories)
{
await categoryRepo.Add(ingredientCategory);
}
// Assert
IngredientCategory ic = categoryRepo.GetByName("First Category").Result;
Assert.AreEqual(ic.Id, categories.First().Id);
});
}
public static void Seed(this ModelBuilder modelBuilder)
{
// Camps
var straddy = new Camp {
ID = Guid.NewGuid(), Name = "Stradbroke Cup"
};
var annual = new Camp {
ID = Guid.NewGuid(), Name = "Annual Camp"
};
modelBuilder.Entity <Camp>().HasData(new List <Camp> {
straddy, annual
});
// Equipment
var pot = new Equipment {
ID = Guid.NewGuid(), Name = "Pot (Large)"
};
modelBuilder.Entity <Equipment>().HasData(new List <Equipment> {
pot
});
// Ingredient Categories
var dairy = new IngredientCategory {
IngredientCategoryID = Guid.NewGuid(), Name = "Dairy"
};
var pantry = new IngredientCategory {
IngredientCategoryID = Guid.NewGuid(), Name = "Pantry"
};
var bakery = new IngredientCategory {
IngredientCategoryID = Guid.NewGuid(), Name = "Bakery"
};
var meat = new IngredientCategory {
IngredientCategoryID = Guid.NewGuid(), Name = "Meat"
};
var fresh = new IngredientCategory {
IngredientCategoryID = Guid.NewGuid(), Name = "Fresh"
};
modelBuilder.Entity <IngredientCategory>().HasData(new List <IngredientCategory> {
dairy, pantry, bakery, meat, fresh
});
// Recipes
var hotC = new Recipe {
ID = Guid.NewGuid(), Name = "Hot Chocolate"
};
var hotD = new Recipe {
ID = Guid.NewGuid(), Name = "Hot Dogs"
};
modelBuilder.Entity <Recipe>().HasData(new List <Recipe> {
hotC, hotD
});
// Menus
var peckers = new Menu {
ID = Guid.NewGuid(), CampID = straddy.ID, MenuName = "Peckers Patrol Menu", StartDate = new DateTime(2020, 3, 18), EndDate = new DateTime(2020, 3, 20)
};
modelBuilder.Entity <Menu>().HasData(new List <Menu> {
peckers
});
// Meals
var friSup = new Meal {
ID = Guid.NewGuid(), Day = DayOfWeek.Friday, MealType = MealType.Supper, MenuID = peckers.ID
};
var satLunch = new Meal {
ID = Guid.NewGuid(), Day = DayOfWeek.Saturday, MealType = MealType.Lunch, MenuID = peckers.ID
};
modelBuilder.Entity <Meal>().HasData(new List <Meal> {
friSup, satLunch
});
// Ingredients
var fcMilk = new Ingredient {
ID = Guid.NewGuid(), Name = "Milk - Full Cream (UHT)", IngredientCategoryID = dairy.IngredientCategoryID, Unit = "Litre", UnitQuantity = 2, Perishable = true, Standard = true, Vegetarian = true, GlutenFree = true, LactoseFree = false, UnitCost = 2.00
};
var lfMilk = new Ingredient {
ID = Guid.NewGuid(), Name = "Milk - Lactose Free (UHT) (LF)", IngredientCategoryID = dairy.IngredientCategoryID, Unit = "Litre", UnitQuantity = 2, Perishable = false, Standard = false, Vegetarian = false, GlutenFree = false, LactoseFree = true, UnitCost = 2.00
};
var hcPowder = new Ingredient {
ID = Guid.NewGuid(), Name = "Hot Chocolate Powder", IngredientCategoryID = pantry.IngredientCategoryID, Unit = "Kilogram", UnitQuantity = 0.4, Perishable = false, Standard = true, Vegetarian = true, GlutenFree = true, LactoseFree = true, UnitCost = 4.00
};
var snags = new Ingredient {
ID = Guid.NewGuid(), Name = "Sausages", IngredientCategoryID = meat.IngredientCategoryID, Unit = "Each", UnitQuantity = 1, Perishable = true, Standard = true, Vegetarian = false, GlutenFree = true, LactoseFree = true, UnitCost = 1.16
};
var veggieSnags = new Ingredient {
ID = Guid.NewGuid(), Name = "Vegetarian Sausages", IngredientCategoryID = pantry.IngredientCategoryID, Unit = "Packet", UnitQuantity = 0.33, Perishable = true, Standard = false, Vegetarian = true, GlutenFree = false, LactoseFree = false, UnitCost = 6.00
};
var hotDogBuns = new Ingredient {
ID = Guid.NewGuid(), Name = "Hot Dog Buns", IngredientCategoryID = bakery.IngredientCategoryID, Unit = "Each", UnitQuantity = 1, Perishable = true, Standard = true, Vegetarian = true, GlutenFree = false, LactoseFree = true, UnitCost = 2.00
};
var gfBread = new Ingredient {
ID = Guid.NewGuid(), Name = "Gluten Free Bread (GF)", IngredientCategoryID = bakery.IngredientCategoryID, Unit = "Loaf", UnitQuantity = 1, Perishable = false, Standard = false, Vegetarian = false, GlutenFree = true, LactoseFree = false, UnitCost = 7.00
};
var tomatoSauce = new Ingredient {
ID = Guid.NewGuid(), Name = "Tomato Sauce", IngredientCategoryID = pantry.IngredientCategoryID, Unit = "Bottle", UnitQuantity = 1, Perishable = false, Standard = true, Vegetarian = true, GlutenFree = true, LactoseFree = true, UnitCost = 4.00
};
var mustard = new Ingredient {
ID = Guid.NewGuid(), Name = "Mustard", IngredientCategoryID = pantry.IngredientCategoryID, Unit = "Bottle", UnitQuantity = 1, Perishable = false, Standard = true, Vegetarian = true, GlutenFree = true, LactoseFree = true, UnitCost = 4.15
};
var bbq = new Ingredient {
ID = Guid.NewGuid(), Name = "BBQ Sauce", IngredientCategoryID = pantry.IngredientCategoryID, Unit = "Bottle", UnitQuantity = 1, Perishable = false, Standard = true, Vegetarian = true, GlutenFree = true, LactoseFree = true, UnitCost = 4.00
};
modelBuilder.Entity <Ingredient>().HasData(new List <Ingredient> {
fcMilk, lfMilk, hcPowder, snags, veggieSnags, hotDogBuns, gfBread, tomatoSauce, mustard, bbq
});
// Ingredient Entries
modelBuilder.Entity <IngredientEntry>().HasData(new List <IngredientEntry>
{
new IngredientEntry {
IngredientID = fcMilk.ID, RecipeID = hotC.ID, QuantityNeeded = 0.20
},
new IngredientEntry {
IngredientID = lfMilk.ID, RecipeID = hotC.ID, QuantityNeeded = 0.20
},
new IngredientEntry {
IngredientID = hcPowder.ID, RecipeID = hotC.ID, QuantityNeeded = 0.045
},
new IngredientEntry {
IngredientID = snags.ID, RecipeID = hotD.ID, QuantityNeeded = 1.75
},
new IngredientEntry {
IngredientID = veggieSnags.ID, RecipeID = hotD.ID, QuantityNeeded = 1.75
},
new IngredientEntry {
IngredientID = hotDogBuns.ID, RecipeID = hotD.ID, QuantityNeeded = 2
},
new IngredientEntry {
IngredientID = gfBread.ID, RecipeID = hotD.ID, QuantityNeeded = 0.1
},
new IngredientEntry {
IngredientID = tomatoSauce.ID, RecipeID = hotD.ID, QuantityNeeded = 0.02
},
new IngredientEntry {
IngredientID = mustard.ID, RecipeID = hotD.ID, QuantityNeeded = 0.01
},
new IngredientEntry {
IngredientID = bbq.ID, RecipeID = hotD.ID, QuantityNeeded = 0.01
},
});
// Meal Recipes
modelBuilder.Entity <MealRecipe>().HasData(new List <MealRecipe>
{
new MealRecipe {
MealID = friSup.ID, RecipeID = hotC.ID
},
new MealRecipe {
MealID = satLunch.ID, RecipeID = hotD.ID
}
});
// Recipe Equipments
modelBuilder.Entity <RecipeEquipment>().HasData(new List <RecipeEquipment>
{
new RecipeEquipment {
RecipeID = hotC.ID, EquipmentID = pot.ID
}
});
}
private Ingredient(EnumIngredients aliment, string name, IngredientCategory category,
string backgroundSpriteName, string ingredientSpriteName, string ingredientBottomSpriteName)
{
this.Aliment = aliment;
m_name = name;
m_category = category;
m_backgroundSpriteName = backgroundSpriteName;
m_ingredientSpriteName = ingredientSpriteName;
m_ingredientShadowSpriteName = m_ingredientSpriteName.Replace(".png", "_shadow.png"); ;
m_ingredientBottomSpriteName = ingredientBottomSpriteName ?? ingredientSpriteName;
}
public void Update(IngredientCategory ingredientCategory)
{
_db.Entry(ingredientCategory).State = EntityState.Modified;
}
public void Add(IngredientCategory ingredientCategory)
{
_db.IngredientCategories.Add(ingredientCategory);
}
private void InputDbContent()
{
bool success = false;
Customer cust;
Ingredient ingr;
IngredientCategory ic;
Order order;
OrderItem oi;
Product prod;
SharedLibrary.Models.Recipe rec;
//Package pack;
//ReciepeIngredients ri;
//SharedLibrary.Models.Rule rule;
//RuleCategory rc;
//SharedLibrary.Models.Shape shape;
Console.WriteLine("Start DB Input");
if (productInfo.TableList.Count > 0)
{
Console.WriteLine("Start input Product\nCount: " + productInfo.TableList.Count);
foreach (var item in productInfo.TableList)
{
prod = new Product();
if (item.BackendID == null)
{
prod.Product_ID = (decimal)item.ProduktID;
prod.Product_Name = item.Name;
prod.Product_Description = item.Description;
prod.Category = item.Category;
prod.Product_Avail = item.Availability;
prod.List_Price = (decimal?)item.ListPrice;
prod.Product_Image = null;
prod.MIMETYPE = "";
prod.Filename = "";
prod.Tags = "";
if (item.SalePrice != null)
{
prod.Sale_Price = (decimal?)item.SalePrice;
}
if (item.SaleBegin != null)
{
prod.Sale_Begin = item.SaleBegin;
}
if (item.SaleEnd != null)
{
prod.Sale_End = item.SaleEnd;
}
prod.Filename = item.Filename;
if (item.ProduktID != null)
{
prod.Manufaturer_ID = item.ProduktID;
}
if (item.FrontEndID != null)
{
prod.Frontend_ID = item.FrontEndID;
}
bdh.AddProduct(prod);
Console.WriteLine("Insert Product in DB");
}
else
{
prod.Product_ID = (decimal)item.BackendID;
prod.Product_Name = item.Name;
prod.Product_Description = item.Description;
prod.Category = item.Category;
prod.Product_Avail = item.Availability;
prod.List_Price = (decimal?)item.ListPrice;
prod.Product_Image = null;
prod.MIMETYPE = "";
prod.Filename = "";
prod.Tags = "";
if (item.SalePrice != null)
{
prod.Sale_Price = (decimal?)item.SalePrice;
}
if (item.SaleBegin != null)
{
prod.Sale_Begin = item.SaleBegin;
}
if (item.SaleEnd != null)
{
prod.Sale_End = item.SaleEnd;
}
prod.Filename = item.Filename;
if (item.ProduktID != null)
{
prod.Manufaturer_ID = item.ProduktID;
}
if (item.FrontEndID != null)
{
prod.Frontend_ID = item.FrontEndID;
}
success = bdh.UpdateProduct(prod, "MANUFACTURER");
if (success)
{
Console.WriteLine("DB Update Product executed");
}
else
{
Console.WriteLine("DB Update Product failed");
}
}
}
}
if (customers.TableList.Count > 0)
{
Console.WriteLine("Start input Customers\nCount: " + customers.TableList.Count);
foreach (var item in customers.TableList)
{
cust = new Customer();
if (item.BackendID == null)
{
cust.CustomerId = (decimal)item.Customer_ID;
cust.FirstName = item.FirstName;
cust.LastName = item.LastName;
cust.Address = item.StreetAdress1;
cust.City = item.City;
cust.State = "";
cust.Zip = item.PostalCode;
cust.Email = item.Email;
cust.PhoneNumber = item.PhoneNumber1;
cust.Url = "";
cust.CreditLimit = null;
cust.Tags = "";
if (item.Customer_ID != null)
{
cust.Manufaturer_ID = item.Customer_ID;
}
if (item.FrontEndID != null)
{
cust.Frontend_ID = item.FrontEndID;
}
bdh.AddCustomer(cust);
}
else
{
cust.CustomerId = (decimal)item.BackendID;
cust.FirstName = item.FirstName;
cust.LastName = item.LastName;
cust.Address = item.StreetAdress1;
cust.City = item.City;
cust.State = "";
cust.Zip = item.PostalCode;
cust.Email = item.Email;
cust.PhoneNumber = item.PhoneNumber1;
cust.Url = "";
cust.CreditLimit = null;
cust.Tags = "";
if (item.Customer_ID != null)
{
cust.Manufaturer_ID = item.Customer_ID;
}
if (item.FrontEndID != null)
{
cust.Frontend_ID = item.FrontEndID;
}
success = bdh.UpdateCustomer(cust, "MANUFACTURER");
if (success)
{
Console.WriteLine("DB Update Customer executed");
}
else
{
Console.WriteLine("DB Update Customer failed");
}
}
}
}
if (ingredientCategory.TableList.Count > 0)
{
Console.WriteLine("Start input IngredientCategory\nCount: " + ingredientCategory.TableList.Count);
foreach (var item in ingredientCategory.TableList)
{
ic = new IngredientCategory();
if (item.BackendID == null)
{
ic.ICID = (decimal)item.Id;
ic.Name = item.Name;
if (item.Id != null)
{
ic.ManufacturerID = item.Id;
}
if (item.FrontEndID != null)
{
ic.FrontendID = item.FrontEndID;
}
bdh.AddIngredientCategory(ic);
}
else
{
ic.ICID = (decimal)item.BackendID;
ic.Name = item.Name;
if (item.Id != null)
{
ic.ManufacturerID = item.Id;
}
if (item.FrontEndID != null)
{
ic.FrontendID = item.FrontEndID;
}
success = bdh.UpdateIngredientsCategory(ic);
if (success)
{
Console.WriteLine("DB Update IngredientsCategory executed");
}
else
{
Console.WriteLine("DB Update IngredientsCategory failed");
}
}
}
}
if (ingredients.TableList.Count > 0)
{
Console.WriteLine("Start input Ingredients\nCount: " + ingredients.TableList.Count);
foreach (var item in ingredients.TableList)
{
ingr = new Ingredient();
if (item.BackendID == null)
{
ingr.IID = (decimal)item.Id;
ingr.Price = (decimal)item.Price;
ingr.Filename = "";
ingr.MIMETYPE = "";
ingr.Ingredient_Image = null;
ingr.Description = item.Description;
ingr.Location_Top = item.LocationTop;
ingr.Location_Bottom = item.LocationBottom;
ingr.Location_Choc = item.LocationChoc;
ingr.Name = item.Name;
ingr.Quantity = item.Quantity;
ingr.CategoryId = (decimal)item.CategoryId;
if (item.Id != null)
{
ingr.ManufacturerID = item.Id;
}
if (item.FrontEndID != null)
{
ingr.FrontendID = item.FrontEndID;
}
bdh.AddIngredient(ingr);
}
else
{
ingr.IID = (decimal)item.BackendID;
ingr.Price = (decimal)item.Price;
ingr.Filename = "";
ingr.MIMETYPE = "";
ingr.Ingredient_Image = null;
ingr.Description = item.Description;
ingr.Location_Top = item.LocationTop;
ingr.Location_Bottom = item.LocationBottom;
ingr.Location_Choc = item.LocationChoc;
ingr.Name = item.Name;
ingr.Quantity = item.Quantity;
ingr.CategoryId = (decimal)item.CategoryId;
if (item.Id != null)
{
ingr.ManufacturerID = item.Id;
}
if (item.FrontEndID != null)
{
ingr.FrontendID = item.FrontEndID;
}
success = bdh.UpdateIngredients(ingr);
if (success)
{
Console.WriteLine("DB Update Ingredients executed");
}
else
{
Console.WriteLine("DB Update Ingredients failed");
}
}
}
}
if (orders.TableList.Count > 0)
{
Console.WriteLine("Start input Orders\nCount: " + orders.TableList.Count);
foreach (var item in orders.TableList)
{
order = new Order();
if (item.BackendID == null)
{
order.OrderId = (decimal)item.OrdersID;
order.CustomerID = bdh.GetOrderBID(item.CustomerID);
order.OrderTotal = (decimal?)item.OrderTotal;
order.OrderTimeStamp = item.OrderTimeStamp;
order.UserName = item.UserName;
order.Tags = "";
if (item.OrdersID != null)
{
order.Manufaturer_ID = item.OrdersID;
}
if (item.FrontEndID != null)
{
order.Frontend_ID = item.FrontEndID;
}
bdh.AddOrder(order);
}
//else
//{
// //ToDo: UpdateOrder?
//}
}
}
if (orderItems.TableList.Count > 0)
{
Console.WriteLine("Start input OrdersItems\nCount: " + orderItems.TableList.Count);
foreach (var item in orderItems.TableList)
{
oi = new OrderItem();
if (item.BackendID == null)
{
oi.OrderItemID = (decimal)item.OrderItemID;
oi.OrderID = bdh.GetOrderBID(item.OrderID);
oi.ProductID = bdh.GetProductBID(item.ProductID);
oi.UnitPrice = (decimal)item.UnitPrice;
oi.Quantity = (int)item.Quantity;
if (item.OrderID != null)
{
oi.ManufacturerID = item.OrderItemID;
}
if (item.FrontEndID != null)
{
oi.FrontEndID = item.FrontEndID;
}
bdh.AddOrderItem(oi);
}
//else
//{
// //ToDo: UpdateOrderItem?
//}
}
}
if (recipe.TableList.Count > 0)
{
Console.WriteLine("Start input Recipes\nCount: " + recipe.TableList.Count);
foreach (var item in recipe.TableList)
{
rec = new SharedLibrary.Models.Recipe();
if (item.BackendID == null)
{
rec.RID = (decimal)item.Id;
rec.ProductID = bdh.GetProductBID(item.ProductId);
rec.Description = item.Description;
if (item.Id != null)
{
rec.ManufacturerID = item.Id;
}
if (item.FrontEndID != null)
{
rec.FrontendID = item.FrontEndID;
}
rec.Last_Updated = DateTime.Now;
rec.Last_Updated_By = "MANUFACTURER";
bdh.AddRecipe(rec);
}
else
{
rec.RID = (decimal)item.BackendID;
rec.ProductID = bdh.GetProductBID(item.ProductId);
rec.Description = item.Description;
if (item.Id != null)
{
rec.ManufacturerID = item.Id;
}
if (item.FrontEndID != null)
{
rec.FrontendID = item.FrontEndID;
}
success = bdh.UpdateRecipe(rec, "MANUFACTURER");
if (success)
{
Console.WriteLine("DB Update Recipe executed");
}
else
{
Console.WriteLine("DB Update Recipe failed");
}
}
}
}
//ToDo: DB fuctions for Package, RecipeIngedients, Rule, RuleCategory, Shape
Console.WriteLine("DB Input finished");
}
