public void controlla_Brews_CreateTest()
{
// Arrange
BrewsController controller = new BrewsController();
//Act
//rilancio la creazione della brews che ha come descrizione "brewsFotTestCreate" e utente SuperUser
Brews brewsFotTestCreate = new Brews()
{
Description = "brewsFotTestCreate",
IdRecipies = 1,
BatchSize = 1,
UserId = "1fe90eaa-4178-4b7f-8cb1-d38daaeadf95"
};
ActionResult result = controller.Create(brewsFotTestCreate);
var idrepciesFotTestCreate = from s in db.Brews
.Where(x => x.Description.Equals("brewsFotTestCreate"))
select s.ID;
// Assert
//mi aspetto, che la selzione in base alla descrizione mi restituisca un ID
Assert.IsNotNull(idrepciesFotTestCreate.FirstOrDefault());
}
public void controlla_Brews_EditTest()
{
// Arrange
BrewsController controller = new BrewsController();
//Act
//id della brews che ha come descrizione "brewsFotTestCreate"
var idbrewsBeforeEdit = from s in db.Brews
.Where(x => x.Description.Equals("brewsFotTestCreate"))
select s.ID;
//modifico il campo Notes
Brews brewsFotTestEdit = new Brews()
{
ID = idbrewsBeforeEdit.FirstOrDefault(),
Description = "brewsFotTestCreate",
BatchSize = 1,
UserId = "1fe90eaa-4178-4b7f-8cb1-d38daaeadf95",
Notes = "notes for brews"
};
//chiamo il controller per modificare
ActionResult result = controller.Edit(brewsFotTestEdit);
//rileggo Notes dopo edit
var notesAfterEdit = from s in db.Brews
.Where(x => x.Description.Equals("brewsFotTestCreate"))
select s.Notes;
// Assert
//mi che Rate=3
Assert.AreEqual("notes for brews", notesAfterEdit.FirstOrDefault());
}
public ActionResult Create([Bind(Include = "ID,Description,IdRecipies,BatchSize,Notes,DateBrew,UserId")] Brews brews)
{
if (ModelState.IsValid)
{
//recupera dal model parametri che mi servono per la spUpdateQuantityIngredients
var recipiesId = brews.IdRecipies;
var batchSize = brews.BatchSize;
//lancia la spUpdateQuantityIngredients
var connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
var command = new SqlCommand("spUpdateQuantityIngredients", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@recipiesId", recipiesId);
command.Parameters.AddWithValue("@batchSize", batchSize);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
//lancia inserimento di un nuovo record per Brews
db.Brews.Add(brews);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", brews.UserId);
ViewBag.IdRecipies = new SelectList(db.Recipies, "ID", "Description", brews.IdRecipies);
return(View(brews));
}
public ActionResult DeleteConfirmed(int id)
{
Brews brews = db.Brews.Find(id);
db.Brews.Remove(brews);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task RefillBrewsAsync(BrewKind?kind = null)
{
CurrentBrewKind = kind ?? CurrentBrewKind;
IsLoading = true;
Brews.Clear();
RaisePropertyChanged(nameof(HasBrews));
(await BrewProvider.Instance.RetrieveDownloadableAsync(CurrentBrewKind)).ForEach(b => Brews.Add(b));
RaisePropertyChanged(nameof(FilteredBrews));
RaisePropertyChanged(nameof(HasBrews));
IsLoading = false;
}
public ActionResult Edit([Bind(Include = "ID,Description,IdRecipies,BatchSize,Notes,DateBrew,UserId")] Brews brews)
{
if (ModelState.IsValid)
{
db.Entry(brews).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", brews.UserId);
ViewBag.IdRecipies = new SelectList(db.Recipies, "ID", "Description", brews.IdRecipies);
return(View(brews));
}
// GET: Brews/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Brews brews = db.Brews.Find(id);
if (brews == null)
{
return(HttpNotFound());
}
return(View(brews));
}
// GET: Brews/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Brews brews = db.Brews.Find(id);
if (brews == null)
{
return(HttpNotFound());
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", brews.UserId);
ViewBag.IdRecipies = new SelectList(db.Recipies, "ID", "Description", brews.IdRecipies);
return(View(brews));
}
