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));
}
