public async Task <IActionResult> Edit(IngredientEditModel ingredientModel)
{
if (!ModelState.IsValid)
{
return(this.View(ingredientModel));
}
bool?isSuccessfullyEdited = await this.ingredients.Edit(ingredientModel.Id, ingredientModel.Name, ingredientModel.MinStockQuantityThreshold);
if (isSuccessfullyEdited == null)
{
return(this.NotFound());
}
if (isSuccessfullyEdited.Value)
{
this.TempData[SuccessMessageKey] = string.Format(CookConstants.IngredientEditionSuccessMessage, ingredientModel.Name);
}
else
{
this.ModelState.AddModelError("Name", CookConstants.IngredientExistsErrorMessage);
return(this.View(ingredientModel));
}
return(this.RedirectToAction(nameof(IngredientsController.Index)));
}
public IngredientController(IGetIngredient getIngredient, ICreateIngredient createIngredient, IUpdateIngredient updateIngredient, IIngredientService ingredientService, IngredientEditModel ingredientEditModel)
{
this._createIngredient = createIngredient;
this._getIngredient = getIngredient;
this._ingredientService = ingredientService;
this._updateIngredient = updateIngredient;
this.IngredientEditModel = ingredientEditModel;
}
public ActionResult Edit(IngredientEditModel ingredientEditModel)
{
UpdateIngredient updateIngredient = new UpdateIngredient();
string type = "Update";
sqlCommand = new SqlCommand();
sqlCommand = updateIngredient.UpdateIngredientData(ingredientEditModel, type);
return(RedirectToAction("Index", "Home"));
}
public async Task <IActionResult> Edit(int id)
{
IngredientEditModel ingredient = await this.ingredients.GetIngredientToEdit(id);
if (ingredient == null)
{
return(this.NotFound());
}
return(this.View(ingredient));
}
public ActionResult Delete(IngredientEditModel ingredientEditModel)
{
sqlCommand = new SqlCommand();
try
{
string type = "Delete";
sqlCommand = this._updateIngredient.UpdateIngredientData(ingredientEditModel, type);
}
catch (Exception ex)
{
ViewBag.FileStatus = ex;
}
return(RedirectToAction("Index", "Home"));
}
private void AddIngredient(IngredientEditModel ingr,
List<RecipeIngredient> ingredients,
Recipe recipe)
{
if(!this.dbContext
.Measurements
.Any(m => m.Name == ingr.Measurement))
{
this.dbContext
.Measurements
.Add(new Measurement
{
Name = ingr.Measurement
});
this.dbContext.SaveChanges();
}
var measurement = this.dbContext
.Measurements
.FirstOrDefault(m => m.Name == ingr.Measurement);
var quantity = ingr.Quantity;
if (!this.dbContext.Ingredients.Any(i => i.Name == ingr.Name))
{
this.dbContext.Ingredients.Add(new Ingredient
{
Name = ingr.Name
});
this.dbContext.SaveChanges();
}
var ingredient = this.dbContext
.Ingredients
.FirstOrDefault(i => i.Name == ingr.Name);
ingredients.Add(new RecipeIngredient
{
Measurement = measurement,
Quantity = quantity,
Ingredient = ingredient,
Recipe = recipe
});
}
// GET: Ingredient/Delete/5
public ActionResult Delete(int id)
{
this.IngredientEditModel = this._ingredientService.FillData(id);
if (this.IngredientEditModel.Carbohydrate != null &&
this.IngredientEditModel.DescriptionOne != null &&
this.IngredientEditModel.DescriptionSec != null &&
this.IngredientEditModel.Fat != null &&
this.IngredientEditModel.OrderTitle != null &&
this.IngredientEditModel.Protein != null &&
this.IngredientEditModel.Title != null &&
this.IngredientEditModel.TitleOne != null)
{
return(View(this.IngredientEditModel));
}
else
{
return(PartialView("_404"));
}
}
public SqlCommand CreateIngredientData(IngredientEditModel ingredientEditModel)
{
using (sqlConnection = new SqlConnection(SqlConn.ConnectionString))
{
sqlConnection.Open();
sqlCommand = new SqlCommand("SpMasterIngredientsDetail", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@StatementType", "Insert");
sqlCommand.Parameters.AddWithValue("@IngredientTitle", ingredientEditModel.Title);
sqlCommand.Parameters.AddWithValue("@IngredientTitleOne", ingredientEditModel.TitleOne);
sqlCommand.Parameters.AddWithValue("@IngredientDesc", ingredientEditModel.DescriptionOne);
sqlCommand.Parameters.AddWithValue("@IngredientDescSec", ingredientEditModel.DescriptionSec);
sqlCommand.Parameters.AddWithValue("@IngredientProtein", ingredientEditModel.Protein);
sqlCommand.Parameters.AddWithValue("@IngredientCarbohydrate", ingredientEditModel.Carbohydrate);
sqlCommand.Parameters.AddWithValue("@IngredientFat", ingredientEditModel.Fat);
sqlCommand.Parameters.AddWithValue("@IngredientOrderTitle", ingredientEditModel.OrderTitle);
sqlCommand.Parameters.AddWithValue("@IsActive", "1");
sqlCommand.ExecuteNonQuery();
}
return(sqlCommand);
}
public ActionResult Create(IngredientEditModel ingredientEditModel, HttpPostedFileBase Image)
{
sqlCommand = new SqlCommand();
sqlCommand = this._createIngredient.CreateIngredientData(ingredientEditModel);
return(RedirectToAction("Index", "Home"));
}
