示例#1
0
 public ActionResult EditerBar(String id)
 {
     BarsTable table = new BarsTable(Session["Database"]);
     if (table.SelectByID(id))
         return View(table.bar);
     else
         return RedirectToAction("ListerBars", "Bars");
 }
示例#2
0
        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");
        }
示例#3
0
        public ActionResult ListerBars()
        {
            BarsTable bars = new BarsTable(Session["Database"]);
            String orderBy = "";

            if (Session["SortBy_Bar"] != null)
                orderBy = (String)Session["SortBy_Bar"] + " " + (String)Session["SortOrder"];

            bars.SelectAll(orderBy);

            return View(bars.ToList());
        }
示例#4
0
 public ActionResult AjouterBars(BarsRecord bar)
 {
     if (ModelState.IsValid)
     {
         BarsTable table = new BarsTable(Session["Database"]);
         table.bar = bar;
         table.bar.UploadLogo(Request);
         table.Insert();
         return RedirectToAction("ListerBars", "Bars");
     }
     return View(bar);
 }
        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");
        }