private IList <RecipeDetail> Get(OracleConnection connection, Recipe recipe)
{
IList <RecipeDetail> result = new List <RecipeDetail>();
string query = $"SELECT " +
$"{RecipeDetail.ColumnNames.RecipeId}, " +
$"{RecipeDetail.ColumnNames.ProductId}, " +
$"{RecipeDetail.ColumnNames.Count}, " +
$"{RecipeDetail.ColumnNames.Active} " +
$"FROM {RecipeDetail.TableName} " +
$"WHERE {RecipeDetail.ColumnNames.Active} = 1 " +
$"AND {RecipeDetail.ColumnNames.RecipeId} = {recipe.Id}";
OracleCommand cmd = new OracleCommand(query, connection);
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
RecipeDetail recipeDetail = new RecipeDetail()
{
RecipeId = Convert.ToInt32(reader[RecipeDetail.ColumnNames.RecipeId]),
ProductId = Convert.ToInt32(reader[RecipeDetail.ColumnNames.ProductId]),
Count = Convert.ToDecimal(reader[RecipeDetail.ColumnNames.Count]),
Active = Convert.ToBoolean(Convert.ToInt16(reader[RecipeDetail.ColumnNames.Active].ToString()))
};
result.Add(recipeDetail);
}
reader.Dispose();
return(result);
}
public RecipeDetail Get(RestaurantDatabaseSettings ctx, int recipeId, int productId)
{
RecipeDetail result = null;
using (OracleConnection conn = new OracleConnection(ctx.ConnectionString))
{
string query = $"SELECT " +
$"{RecipeDetail.ColumnNames.RecipeId}, " +
$"{RecipeDetail.ColumnNames.ProductId}, " +
$"{RecipeDetail.ColumnNames.Count}, " +
$"{RecipeDetail.ColumnNames.Active} " +
$"FROM {RecipeDetail.TableName} " +
$"WHERE {RecipeDetail.ColumnNames.RecipeId} = {recipeId} " +
$"AND {RecipeDetail.ColumnNames.ProductId} = {productId}";
OracleCommand cmd = new OracleCommand(query, conn);
conn.Open();
OracleDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
result = new RecipeDetail()
{
RecipeId = Convert.ToInt32(reader[RecipeDetail.ColumnNames.RecipeId]),
ProductId = Convert.ToInt32(reader[RecipeDetail.ColumnNames.ProductId]),
Count = Convert.ToDecimal(reader[RecipeDetail.ColumnNames.Count]),
Active = Convert.ToBoolean(Convert.ToInt16(reader[RecipeDetail.ColumnNames.Active].ToString()))
};
}
reader.Dispose();
}
return(result);
}
public override void SetRecipeDetials()
{
RecipeDetail.Add("Boil water");
RecipeDetail.Add("Add water");
RecipeDetail.Add("Steep tea bag in hot water");
RecipeDetail.Add("Add lemon");
}
public Recipe Add(RestaurantDatabaseSettings ctx, Recipe recipe)
{
Recipe result = null;
using (OracleConnection conn = new OracleConnection(ctx.ConnectionString))
{
conn.Open();
OracleTransaction transaction = conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
string query = $"INSERT INTO Receta (" +
$"{Recipe.ColumnNames.Name}, " +
$"{Recipe.ColumnNames.Price}, " +
$"{Recipe.ColumnNames.Details}, " +
$"{Recipe.ColumnNames.PreparationTime}, " +
$"{Recipe.ColumnNames.Active} " +
$") VALUES (" +
$"'{recipe.Name}', " +
$"{recipe.Price}, " +
$"'{recipe.Details}', " +
$"{recipe.PreparationTime}, " +
$"{1} " +
$") RETURNING {Recipe.ColumnNames.Id} INTO :{Recipe.ColumnNames.Id}";
OracleCommand cmd = new OracleCommand(query, conn);
cmd.Transaction = transaction;
cmd.Parameters.Add(new OracleParameter()
{
ParameterName = $":{Recipe.ColumnNames.Id}",
OracleDbType = OracleDbType.Decimal,
Direction = System.Data.ParameterDirection.Output
});
try
{
cmd.ExecuteNonQuery();
recipe.Id = Convert.ToInt32(cmd.Parameters[$":{Recipe.ColumnNames.Id}"].Value.ToString());
if (recipe.RecipeDetails != null)
{
List <RecipeDetail> recipeDetails = new List <RecipeDetail>();
foreach (var recipeDetail in recipe.RecipeDetails)
{
RecipeDetail createdRecipeDetail = this.Add(conn, transaction, recipe.Id, recipeDetail);
recipeDetails.Add(createdRecipeDetail);
}
}
transaction.Commit();
result = recipe;
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
return(result);
}
public async Task <IActionResult> Edit(RecipeDetail recipeDetail)
{
if (ModelState.IsValid)
{
try
{
if (!await _recipeDetailsService.RecipeDetailExists(recipeDetail.Id))
{
return(NotFound());
}
await _recipeDetailsService.Update(recipeDetail);
}
catch (DbUpdateConcurrencyException)
{
if (!await _recipeDetailsService.RecipeDetailExists(recipeDetail.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Details", "Recipes", new { id = recipeDetail.RecipeId }));
}
await FillViewData();
return(View(recipeDetail));
}
public async Task <JsonResult> EditRecipeItem([FromBody] RecipeItemDetail sender)
{
var itemName = sender.itemName;
var unitName = sender.unitName;
var qty = sender.qty;
var recipeDetailId = sender.recipeDetailId;
Item itemObj = new Item();
Unit unitObj = new Unit();
IEnumerable <Item> itemList = await itemRepository.GetItems();
IEnumerable <Unit> unitList = await unitRepository.GetUnits();
if (!itemList.Any(x => x.Name.ToLower() == itemName.ToLower().Trim()))
{
itemObj.Name = itemName.Trim();
await itemRepository.InsertItem(itemObj);
}
else
{
itemObj = itemList.First(x => x.Name.ToLower() == itemName.ToLower().Trim());
}
if (!unitList.Any(x => x.Name.ToLower() == unitName.ToLower().Trim()))
{
unitObj.Name = unitName.Trim();
await unitRepository.InsertUnit(unitObj);
}
else
{
unitObj = unitList.First(x => x.Name.ToLower() == unitName.ToLower().Trim());
}
RecipeDetail recipeDetail = await recipeRepository.GetRecipeDetail(recipeDetailId);
if (recipeDetail == null)
{
HasError = true;
ErrorMessage = "Δεν υπάρχει το είδος στη συνταγή.";
return(new JsonResult(new { result = true, message = ErrorMessage }));
}
recipeDetail.Item = itemObj;
recipeDetail.ItemId = itemObj.Id;
recipeDetail.Unit = unitObj;
recipeDetail.UnitId = unitObj.Id;
recipeDetail.Quantity = qty;
if (!await recipeRepository.UpdateRecipeDetail(recipeDetail))
{
HasError = true;
ErrorMessage = "Δεν μπορέσαμε να ενημερώσουμε την εγγραφή.";
return(new JsonResult(new { result = true, message = ErrorMessage }));
}
HasError = false;
SuccessMessage = "Η ενημέρωση έγινε με επιτυχία.";
return(new JsonResult(new { result = true, message = SuccessMessage }));
}
public RecipeDetail Add(RestaurantDatabaseSettings ctx, RecipeDetail recipeDetail)
{
RecipeDetail result = null;
using (OracleConnection conn = new OracleConnection(ctx.ConnectionString))
{
conn.Open();
string query = $"INSERT INTO {RecipeDetail.TableName} (" +
$"{RecipeDetail.ColumnNames.RecipeId}, " +
$"{RecipeDetail.ColumnNames.ProductId}, " +
$"{RecipeDetail.ColumnNames.Count}, " +
$"{RecipeDetail.ColumnNames.Active} " +
$") VALUES (" +
$"{recipeDetail.RecipeId}, " +
$"{recipeDetail.ProductId}, " +
$"{recipeDetail.Count}, " +
$"{1} " +
$")";
OracleCommand cmd = new OracleCommand(query, conn);
cmd.ExecuteNonQuery();
result = recipeDetail;
}
return(result);
}
public void CookChillYieldDetail(string recipeDetailID, string recipeType)
{
RecipeDetail mealRecipeYield = new RecipeDetail();
YieldDetailRecipeDetailIDHiddenField.Value = recipeDetailID;
YieldDetailRecipeTypeNameHiddenField.Value = recipeType;
mealRecipeYield.RecipeDetailID = recipeDetailID;
mealRecipeYield.GetMealRecipeDetail();
PackageTypeTextBox.Text = mealRecipeYield.PackageTypeName;
PackageTypeLabel.Text = mealRecipeYield.PackageTypeName;
PackageTypeIDHiddenField.Value = mealRecipeYield.PackageTypeID;
ServingSizeTypeIDHiddenField.Value = mealRecipeYield.ServingSizeTypeID;
NumberofPackageTypeTextBox.Text = mealRecipeYield.PackagesPerBatch;
VolumeServingSizeDropDownList.SelectedIndex =
VolumeServingSizeDropDownList.Items.IndexOf(
VolumeServingSizeDropDownList.Items.FindByValue(mealRecipeYield.ServingSize));
CookChillWeightDropDownList.SelectedIndex =
CookChillWeightDropDownList.Items.IndexOf(
CookChillWeightDropDownList.Items.FindByValue(mealRecipeYield.VolumeWeight));
ServingsPerPackageTextBox.Text = mealRecipeYield.ServingsPerPackage;
ServingsPerBatchTextBox.Text = mealRecipeYield.ServingsPerBatch;
BatchYieldInPoundsTextBox.Text = mealRecipeYield.YieldInPounds;
CookchillRoundMealCountTextBox.Text = RoundedCurrentMealCountLabel.Text;
CookChillConversionFactorTextBox.Text = mealRecipeYield.Conversion;
if (mealRecipeYield.IsDefault == "False")
{
mealRecipeYield.GetDefaultRecipeDetail();
}
RecipeOriginalCCYieldHiddenField.Value = mealRecipeYield.YieldInPounds;
OriginalCCVolumeHiddenField.Value = mealRecipeYield.VolumeWeight;
OriginalCCServingSizeHiddenField.Value = mealRecipeYield.ServingSize;
GetCalendarData();
((UpdatePanel)UpdatePanel2.FindControl("UpdatePanel3")).Update();
string DisplayPopup;
DisplayPopup = "launchCookChillYieldPopup=true";
ScriptManager.RegisterStartupScript(this, this.GetType(), "DisplayPopup", DisplayPopup, true);
}
public RecipeDetail GetRecipeDetailByRecipeDetailID(int RecipeDetailID)
{
RecipeDetail recipeDetail = (from RD in context.RecipeDetails
where RD.RecipeDetailID == RecipeDetailID
select RD).SingleOrDefault();
return(recipeDetail);
}
public async Task <int> Save(RecipeDetail recipeDetail)
{
using (var db = _context)
{
db.RecipeDetail.Add(recipeDetail);
return(await db.SaveChangesAsync());
}
}
public override void SetRecipeDetials()
{
RecipeDetail.Add("Boil water");
RecipeDetail.Add("Add sugar");
RecipeDetail.Add("Add coffee granules to cup");
RecipeDetail.Add("Add water");
RecipeDetail.Add("Add milk");
}
public override void SetRecipeDetials()
{
RecipeDetail.Add("Crush Ice");
RecipeDetail.Add("Add ice to blender");
RecipeDetail.Add("Add coffee syrup to blender");
RecipeDetail.Add("Blend ingredients");
RecipeDetail.Add("Add ingredients");
}
public ActionResult DoDeleteRecipeDetail(int RecipeDetailID)
{
RecipeDetail recipedetail = info.GetRecipeDetailByRecipeDetailID(RecipeDetailID);
Recipe rec = info.GetRecipeByRecipeID(recipedetail.RecID);
info.DeleteRecipeDetail(RecipeDetailID);
return(RedirectToAction("ReadRecipe", "Batender", new { FDID = rec.FDID }));
}
public async Task LoadRecipes()
{
var recipes = await RecipeService.GetRecipes();
this.Recipes = new ObservableCollection <RecipeDetail>(recipes);
// new: set top recipes and recipe of the day
this.TopRecipes = recipes.GroupBy(p => p.Rating).OrderByDescending(p => p.Key).First();
this.RecipeOfTheDay = this.TopRecipes.First();
}
public void GetReciepeDetails(string url, Action <RecipeDetail> callback)
{
Task.Run(async() =>
{
RecipeDetail dt = new RecipeDetail();
string requrl = url;
var response = await GetResponse(requrl);
if (response != null)
{
try
{
HtmlDocument htmlDocument = new HtmlDocument();
htmlDocument.LoadHtml(response.Content);
// document.getElementById('recipe-content-wrapper')
var authimage = htmlDocument.DocumentNode.Descendants().Where(x => x.Name == "img" && x.Attributes.Contains("class") && x.Attributes["class"].Value == "author-image").FirstOrDefault().Attributes["src"].Value;
dt.AuthorImg = authimage;
var ingdf = (from n in htmlDocument.DocumentNode.Descendants()
where n.Name == "div" && n.Id != null && (n.Id == "ingredients" || n.Id == "instructions")
select n).ToList();
// nodes.Descendants().FirstOrDefault(x=> x.Name == "div"&& x.Attributes.Contains("Id") && x.Attributes["Id"].Value.Split().Contains("ingredients"));
var ingredients = (from ing in ingdf.FirstOrDefault(y => y.Id == "ingredients").Descendants().Where(x => x.Name == "div" && x.Attributes.Contains("class") && x.Attributes["class"].Value == ("ingredient-wrap"))
select ParseIng(HtmlUtilities.ConvertToText(ing.InnerText))).ToList();
var directions = (from ing in ingdf.FirstOrDefault(y => y.Id == "instructions").Descendants().Where(x => x.Name == "div" && x.Attributes.Contains("class") && x.Attributes["class"].Value == ("instructions-wrap"))
select HtmlUtilities.ConvertToText(ing.InnerText)).ToList();
if (ingredients != null)
{
dt.Ingredients = ingredients;
}
if (directions != null)
{
dt.Directions = directions;
}
}
catch (Exception)
{
// throw;
}
if (callback != null)
{
callback(dt);
}
//<div id="ingredients" class="col-md-4 columns">
//<h3>Ingredients</h3><div class="ingredient-wrap"><div class="ingredient">chicken 1/2kg</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">onion 2</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">tomato 1</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">green chilli 1</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">ginger garlic paste 5 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">mint leaves 1/2 cup</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">red chilli powder 1 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">black pepper 1/4 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">turmeric powder 1 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">salt to taste</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">coriander powder 2 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">chicken masala 1 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">cumin seed powder 1/2 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">coconut paste 1/2 cup</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">oil 6 tsp</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">bay leaf 2</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">cinnamon 1</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">cloves 2</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">aniseed 1</div><div class="clr"></div></div><div class="ingredient-wrap"><div class="ingredient">cardamom 2</div><div class="clr"></div></div></div>)
}
else
{
if (callback != null)
{
callback(null);
}
}
});
}
public ActionResult DeleteRecipeDetail(int RecipeDetailID)
{
RecipeDetail recipedetail = info.GetRecipeDetailByRecipeDetailID(RecipeDetailID);
Ingredient ingre = info.GetIngredientByIngreID(recipedetail.IngreID);
ViewData["IngreID"] = ingre.Name;
Recipe rec = info.GetRecipeByRecipeID(recipedetail.RecID);
ViewData["FDID"] = rec.FDID;
return(View(recipedetail));
}
/*/Helper*/
private void AddResourceToRecipe(string obj)
{
var recipeDetail = new RecipeDetail
{
RecipeId = StaticValues.selectedRecipe,
ResourceId = SelectedResource.Id,
};
db.RecipeDetails.Add(recipeDetail);
db.SaveChanges();
}
public async Task <IActionResult> Create(int recipeId)
{
await FillViewData();
RecipeDetail detail = new RecipeDetail()
{
RecipeId = recipeId
};
return(View(detail));
}
/// <summary>
/// Προσθήκη Object
/// </summary>
/// <param name="recipeDetail"></param>
/// <returns></returns>
public async Task <bool> InsertRecipeDetail(RecipeDetail recipeDetail)
{
context.SC_RecipeDetail.Add(recipeDetail);
if (await context.SaveChangesAsync() <= 0)
{
return(false);
}
return(true);
}
public async Task <ActionResult <RecipeDetail> > Update([FromBody] RecipeDetail _RecipeDetail)
{
RecipeDetail _RecipeDetailq = _RecipeDetail;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_RecipeDetailq = await(from c in _context.RecipeDetail
.Where(x => x.IngredientCode == (Int64)_RecipeDetail.IngredientCode && x.RecipeId == (Int64)_RecipeDetail.RecipeId)
select c
).FirstOrDefaultAsync();
_context.Entry(_RecipeDetailq).CurrentValues.SetValues((_RecipeDetail));
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _RecipeDetailq.IngredientCode,
DocType = "RecipeDetail",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_RecipeDetailq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Actualizar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _RecipeDetailq.UsuarioCreacion,
UsuarioModificacion = _RecipeDetailq.UsuarioModificacion,
UsuarioEjecucion = _RecipeDetailq.UsuarioModificacion,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_RecipeDetailq)));
}
/// <summary>
/// Διαγραφή Object
/// </summary>
/// <param name="recipeDetail"></param>
/// <returns></returns>
public async Task <bool> DeleteRecipeDetail(RecipeDetail recipeDetail)
{
context.SC_RecipeDetail.Remove(recipeDetail);
if (await context.SaveChangesAsync() <= 0)
{
return(false);
}
return(true);
}
public void IgnoreReadOnlyNegative()
{
RecipeDetail detail1 = new RecipeDetail(true, "Toffee");
detail1.Ingredient = "Crunchy Chocolate";
RecipeDetail detail2 = new RecipeDetail(false, "Toffee");
detail2.Ingredient = "Crunchy Chocolate";
Assert.IsFalse(_compare.Compare(detail1, detail2).AreEqual);
}
public async Task Create(RecipeDetail recipeDetail)
{
if (!string.IsNullOrEmpty(recipeDetail.CreateIngredientName) &&
recipeDetail.CreateIngredientStoreId.HasValue)
{
recipeDetail.IngredientId = await _ingredientService.CreateIngredient(recipeDetail.CreateIngredientName, recipeDetail.CreateIngredientStoreId.Value);
}
using MealPlannerContext context = new(_dbOptions);
context.RecipeDetails.Add(recipeDetail);
await context.SaveChangesAsync();
}
public void AddResourceToRecipe()
{
var selectedResource = resourceGrid.SelectedItem as Resource;
var recipeDetail = new RecipeDetail
{
RecipeId = selectedRecipe.Id,
ResourceId = selectedResource.Id,
Quantity = int.Parse(amountTxtbox.Text),
};
db.RecipeDetails.Add(recipeDetail);
db.SaveChanges();
}
public async Task <IActionResult> Create(RecipeDetail recipeDetail)
{
if (ModelState.IsValid)
{
await _recipeDetailsService.Create(recipeDetail);
return(RedirectToAction("Details", "Recipes", new { id = recipeDetail.RecipeId }));
}
await FillViewData();
return(View(recipeDetail));
}
public bool DeleteRecipeDetail(int RecipeDetailID)
{
try
{
RecipeDetail recipedetail = this.context.RecipeDetails.Single(o => o.RecipeDetailID == RecipeDetailID);
context.RecipeDetails.DeleteOnSubmit(recipedetail);
context.SubmitChanges();
return(true);
}
catch (Exception e)
{
throw new Exception("Error delete recipeDetail: " + e.Message);
}
}
public void IgnoreReadOnlyPositive()
{
RecipeDetail detail1 = new RecipeDetail(true, "Toffee");
detail1.Ingredient = "Crunchy Chocolate";
RecipeDetail detail2 = new RecipeDetail(false, "Toffee");
detail2.Ingredient = "Crunchy Chocolate";
_compare.Config.CompareReadOnly = false;
Assert.IsTrue(_compare.Compare(detail1, detail2).AreEqual);
_compare.Config.CompareReadOnly = true;
}
public void PrivatePropertyPositive()
{
RecipeDetail detail1 = new RecipeDetail(true, "Toffee");
detail1.Ingredient = "Crunchy Chocolate";
RecipeDetail detail2 = new RecipeDetail(true, "Toffee");
detail2.Ingredient = "Crunchy Chocolate";
_compare.Config.ComparePrivateProperties = true;
Assert.IsTrue(_compare.Compare(detail1, detail2).AreEqual);
_compare.Config.ComparePrivateProperties = false;
}
public void PrivateFieldNegative()
{
RecipeDetail detail1 = new RecipeDetail(true, "Toffee");
detail1.Ingredient = "Crunchy Chocolate";
RecipeDetail detail2 = new RecipeDetail(true, "Crunchy Frogs");
detail2.Ingredient = "Crunchy Chocolate";
_compare.Config.ComparePrivateFields = true;
Assert.IsFalse(_compare.Compare(detail1, detail2).AreEqual);
_compare.Config.ComparePrivateFields = false;
}
public void PrivateFieldPositive()
{
RecipeDetail detail1 = new RecipeDetail(true, "Toffee");
detail1.Ingredient = "Crunchy Chocolate";
RecipeDetail detail2 = new RecipeDetail(true, "Toffee");
detail2.Ingredient = "Crunchy Chocolate";
_compare.ComparePrivateFields = true;
Assert.IsTrue(_compare.Compare(detail1, detail2));
_compare.ComparePrivateFields = false;
}
