public ActionResult EditerSelections(String Id)
{
SelectionTable table = new SelectionTable(Session["Database"]);
table.SelectByID(Id);
BieresTable bieres = new BieresTable(Session["Database"]);
bieres.SelectByID(table.Selection.IdBiere);
table.Selection.ListeBieres = new List<BieresRecord>();
table.Selection.ListeBieres.Add(bieres.biere);
return View(table.Selection);
}
public ActionResult SupprimerBar(String id)
{
BarsTable barsTable = new BarsTable(Session["Database"]);
barsTable.DeleteRecordByID(id);
SelectionTable selectionTable = new SelectionTable(Session["Database"]);
selectionTable.DeleteAllRecordByFieldName("IdBar", id);
return RedirectToAction("ListerBars", "Bars");
}
public ActionResult AjouterSelections(SelectionsRecord selection)
{
selection.IdBar = ((BarsTable)Session["Bar"]).bar.Id;
if (ModelState.IsValid)
{
SelectionTable table = new SelectionTable(Session["Database"]);
table.Selection = selection;
table.Insert();
return RedirectToAction("AfficherSelections/" + ((BarsTable)Session["Bar"]).bar.Id.ToString());
}
else
{
BieresTable bieres = new BieresTable(Session["Database"]);
bieres.SelectAll("Brasserie, NomBiere");
selection.ListeBieres = bieres.ToList();
return View(selection);
}
}
public ActionResult AfficherSelections(string Id)
{
if (!String.IsNullOrEmpty(Id))
{
String orderby = "";
if (Session["SortBy_Selection"] != null)
orderby = (String)Session["SortBy_Selection"] + " " + (String)Session["SortOrder"];
BieresTable bieres = new BieresTable(Session["Database"]);
bieres.SelectFromSelection(Id, orderby);
BarsTable bars = new BarsTable(Session["Database"]);
bars.SelectByID(Id);
Session["Bar"] = bars;
SelectionTable selection = new SelectionTable(Session["Database"]);
Session["ListePrix"] = selection.ListPrix(Id,orderby);
return View(bieres.ToList());
}
else
return RedirectToAction("ListerBars", "Bars");
}
public ActionResult EditerSelections(SelectionsRecord selection)
{
if (ModelState.IsValid)
{
SelectionTable table = new SelectionTable(Session["Database"]);
table.Selection = selection;
table.Update();
return RedirectToAction("AfficherSelections", "Selections", new { Id = ((BarsTable)Session["Bar"]).bar.Id });
}
else
{
BieresTable bieres = new BieresTable(Session["Database"]);
bieres.SelectByID(selection.IdBiere);
selection.ListeBieres = new List<BieresRecord>();
selection.ListeBieres.Add(bieres.biere);
return View(selection);
}
}
public ActionResult SupprimerSelections(String id)
{
SelectionTable table = new SelectionTable(Session["Database"]);
table.DeleteRecordByID(id);
return RedirectToAction("AfficherSelections", ((BarsTable)Session["Bar"]).bar.Id);
}
public void DeleteAllByType(String IdType)
{
SelectByFieldName("IdType", long.Parse(IdType));
SelectionTable selection = new SelectionTable(connexionString);
while (Next())
{
selection.DeleteAllRecordByFieldName("IdBiere", biere.Id);
DeleteRecordByID(biere.Id);
}
}
