public ActionResult _getListProduct(string Stat02 = "", string Famille = "", int page = 1) { string arref = Stat02.Replace('_', '/'); var sys = new GestionSys(mb); IPagedList <Produit> liste_perso = sys.TousAllProductByCat(arref, Famille, page) .Where(x => x.QteEnCommande + x.StockDisponible > 0 && x.Prix > 0) .ToPagedList(page, 25); var user = Security.DeSerialize <Utilisateur>(Session["user"].ToString() != null ? Session["user"].ToString() : null); if (user == null) { return(RedirectToAction("Index", "Home")); } sys.RemiseToListProduit(liste_perso.ToList(), user); ViewBag.Category = arref; ViewBag.famille = Famille; ViewBag.liste = liste_perso; //ViewBag.count = sys.CountGetAllProductByCat(Stat02, Famille); //ViewBag.current = page > 0 ? page : 1; return(PartialView()); }
public ActionResult Menu() { var sys = new GestionSys(mb); List <string> menu = sys.FamillePourMenu(); return(PartialView(menu)); }
public JsonResult AddPanier(string AR_Ref, int Qte) { //string reference=Sanitizer.GetSafeHtml(AR_Ref); var sys = new GestionSys(mb); Produit p = sys.FindAndCheckProduitByRef(AR_Ref, Qte); var panier = Security.DeSerialize <Panier>(Session["Panier"].ToString()); var user = Security.DeSerialize <Utilisateur>(Session["user"].ToString()); if (Qte == 0) { return(Json("Fail", JsonRequestBehavior.AllowGet)); } if (p != null) { //try //{ panier.AddToPanier(p); Session["Panier"] = Security.Serialize(panier); return(Json("Success", JsonRequestBehavior.AllowGet)); //} //catch (Exception e) //{ //return Json("Fail", JsonRequestBehavior.AllowGet); //} } return(Json("Fail", JsonRequestBehavior.AllowGet)); }
public ActionResult _fam(String Stat02 = "") { var sys = new GestionSys(mb); List <string> fam = sys.FamilleParCat(Stat02); ViewBag.fam = fam; ViewBag.Stat02 = Stat02; return(PartialView()); }
private void Ticker_Elapsed(object sender, ElapsedEventArgs e) { var maDB = new Database(); var maSys = new GestionSys(maDB); //List<entetedocument> commandeAchat = maSys.recupererEnteteDocumentByType(12); //List<lignedocument> ligneCommandeAchat = maSys.recupererLigneDocumentByListe(commandeAchat); Achats = maSys.recupererLigneDocumentByType(12); }
//[Route("Commander")] public ActionResult CreerCommande() { var user = Security.DeSerialize <Utilisateur>(Session["user"].ToString()); GestionSys sys = new GestionSys(mb, user); Panier panier = Security.DeSerialize <Panier>(Session["panier"].ToString()); string a = sys.CreeCommande(panier, user, 1); ViewBag.a = a; return(View()); }
public ActionResult Details(string id) { string arref = HttpUtility.UrlDecode(id.Replace('!', '%')); if (arref.Equals("")) { return(PartialView("~/Views/Shared/_blank.cshtml")); } var sys = new GestionSys(mb); Produit p = sys.ProductParRef(arref); return(PartialView("_Details", p)); }
public ActionResult Index() { db = new Database(); Session.Add("maDB", db); var masys = new GestionSys(db); List <Produit> liste_arrivage = masys.ProductByEvent(1).Where(x => x.QteEnCommande + x.StockDisponible > 0 && x.Prix > 0).ToList(); List <Produit> liste_promotions = masys.ProductByEvent(2).Where(x => x.QteEnCommande + x.StockDisponible > 0 && x.Prix > 0).ToList(); List <Produit> liste_destockage = masys.ProductByEvent(3).Where(x => x.QteEnCommande + x.StockDisponible > 0 && x.Prix > 0).ToList(); ViewBag.arrivage = liste_arrivage; ViewBag.promo = liste_promotions; ViewBag.destock = liste_destockage; return(View()); }
public ActionResult Search(string Search, int page = 1) { String search_propre = Sanitizer.GetSafeHtmlFragment(Search); var sys = new GestionSys(mb); IPagedList <Produit> list_search = sys.SearchProduitsByUser(search_propre).Where(x => x.QteEnCommande + x.StockDisponible > 0 && x.Prix > 0) .ToPagedList(page, 25); var user = Security.DeSerialize <Utilisateur>(Session["user"].ToString()); sys.RemiseToListProduit(list_search.ToList(), user); ViewBag.search = search_propre; ViewBag.liste = list_search; return(View()); }
public FileResult DownloadFicheArticle(string Stat02 = "", string Famille = "") { var sys = new GestionSys(mb); var fiche_article = new List <ArticleSto>(); List <Produit> produit = sys.getAllProduitByRefAndFamille(Stat02, Famille); foreach (Produit item in produit) { if (item.StockDisponible + item.QteEnCommande > 0 && item.Prix > 0) { var At = new ArticleSto(); At.Reference = item.Reference; At.Description = item.Designation; At.Qte_denis = item.StockDispo_denis > 0 ? item.StockDispo_denis : 0; At.Qte_pierre = item.StockDispo_pierre > 0 ? item.StockDispo_pierre : 0; At.Stockdisponible = item.StockDisponible; At.prix = item.Prix; if (item.QteEnCommande > 0) { At.arrivage = item.QteEnCommande + " le " + item.Disponibilite; } else { At.arrivage = ""; } fiche_article.Add(At); } } var outputFileDescription = new CsvFileDescription { SeparatorChar = ';', // tab delimited FirstLineHasColumnNames = true, // no column names in first record FileCultureName = "fr-FR" // use formats used in The Netherlands }; var cc = new CsvContext(); string chemin = Server.MapPath("~/CSVFileTemp/temp_csv.csv"); cc.Write( fiche_article, chemin, outputFileDescription); return(File(chemin, "text/csv", "MC3_Export_" + Stat02 + DateTime.Now + ".csv")); }
public ActionResult MonCompte() { var monUser = Security.DeSerialize <Utilisateur>(Session["user"].ToString());; Database maDB = Session["maDB"] as Database; GestionSys maSys = new GestionSys(maDB, monUser); if (monUser != null && monUser.Factures == null) { monUser = maSys.GetMyAccountInfos(monUser); monUser.Statisitques = maSys.GetStatAtToday(monUser); } List <lignedocument> dernier_commande = maSys.RecupererLignedocumentsByTypeAndNum(1, monUser.CodeClient); ViewBag.monUser = monUser; ViewBag.historique = dernier_commande; //AjaxPassword form_pass= new AjaxPassword(); return(View()); }
public ActionResult SignIn(UserViewModel user, string returnUrl) { if (ModelState.IsValid) { Utilisateur monUser = null; ; var maDB = new Database(); var sys = new GestionSys(maDB); string username = user.CodeClient; string password = user.Password; const string statement = "SELECT * FROM F_CONTACTT WHERE CT_Num = @user AND CT_Prenom = @password AND (CT_Fonction = 'ACCES WEB2' OR CT_Fonction = 'ACCES WEB RESTREINT2' OR CT_Fonction='ACCES WEB')"; var myCommand = new SqlCommand(statement, maDB.myConnection); myCommand.Parameters.Add("@user", SqlDbType.NVarChar).Value = username; myCommand.Parameters.Add("@password", SqlDbType.NVarChar).Value = password; maDB.open(); SqlDataReader myReader = null; myReader = myCommand.ExecuteReader(); if (myReader.HasRows) { FormsAuthentication.SetAuthCookie(username, user.RememberMe); while (myReader.Read()) { monUser = new Utilisateur(username); monUser.Email = myReader["CT_Email"].ToString(); monUser.Password = password; monUser.NomPre = myReader["CT_Nom"].ToString(); } myReader.Close(); sys.RecupererListeFamilleRemise(monUser); Panier panier = new Panier(); Session.Add("Panier", Security.Serialize(panier)); Session.Add("user", Security.Serialize(monUser)); //Session["user"] = monUser; return(RedirectToAction("Index", "Home")); } ModelState.AddModelError("", "Le nom d'utilisateur et/ou le mot de passe ne correspond pas"); maDB.close(); } return(View(user)); }