public ActionResult Modifier(ComVendCli cvc)
{
IEnumerable <Commandes> commandes = null;
Commandes com = new Commandes();
try
{
// utilisation possible de Request
// String s= Request["Societe"];
com.NoCommande = Request["NoCommande"];
com.NoClient = Clientel.getClientById(Request["NoClient"]);
com.NoVendeur = Vendeur.getVendeurById(Request["NoVendeur"]);
com.DateCde = Request["DateCde"];
com.Facture = Request["Facture"];
Commandes.updateCommande(com);
commandes = Commandes.getCommandes();
return(View("Index", commandes));
}
catch (MonException e)
{
return(HttpNotFound());
}
}
public CommandeViewModel()
{
Vendeur = new Vendeur();
Clientel = new ClientelViewModel();
Vendeurs = new List <SelectListItem>();
Clients = new List <SelectListItem>();
}
public IActionResult Edit(int id, Vendeur vendeur)
{
if (id != vendeur.VendeurID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
MyDb.Vendeurs.Update(vendeur);
MyDb.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!VendeurExists(vendeur.VendeurID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(vendeur));
}
public ActionResult Modifier(Vendeur unVend)
{
List <SelectListItem> items = new List <SelectListItem>();
foreach (String no in Vendeur.LectureNoVendeurs())
{
items.Add(new SelectListItem {
Text = "Vendeur N°" + no, Value = no
});
}
ViewBag.NoVendeurs = items;
if (!ModelState.IsValid)
{
// Si le client modifié n'est pas valide, on affiche un message d'erreur à l'utilisateur
return(View(unVend));
}
try
{
// utilisation possible de Request
// String s= Request["Societe"];
Vendeur.updateVendeur(unVend);
ViewBag.Title = "Modifier";
return(RedirectToAction("Index"));
}
catch (MonException e)
{
return(HttpNotFound());
}
}
/// <summary>
/// Initialisation
/// </summary>
public Fvendeur()
{
InitializeComponent();
lbl_nom.Text = "";
lbl_prenom.Text = "";
lbl_dtEmb.Text = "";
lbl_ville.Text = "";
lbl_sal.Text = "";
lbl_com.Text = "";
lbl_sup.Text = "";
btn_details.Visible = false;
// on essaie d'aller chercher la liste des vendeurs dans la base de données
List <String> mesNumeros;
try
{
Vendeur unVendeur = new Vendeur();
mesNumeros = unVendeur.LectureNoVendeur();
foreach (String item in mesNumeros)
{
cb_listeven.Items.Add(item);
}
}
catch (MonException exception)
{
MessageBox.Show(exception.MessageApplication(), exception.Message);
}
}
public GestionPDF(Commande commande)
{
this.commande = commande;
vendeur = db.vendeurs.Values.Find(x => x.NoVendeur == commande.NoVendeur);
client = db.clients.Values.Find(x => x.NoClient == commande.NoClient);
detailsCommande = db.detailsCommandes.Values.Where(x => x.NoCommande == commande.NoCommande).ToList();
}
public async Task <IActionResult> Edit(int id, [Bind("VendeurId,VendeurNom,VendeurAddress,VendeurNoTel")] Vendeur vendeur)
{
if (id != vendeur.VendeurId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vendeur);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VendeurExists(vendeur.VendeurId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(vendeur));
}
/// <summary>
/// Charger les données pour les listes déroulantes de clients et vendeurs
/// </summary>
private void ChargerDonnees()
{
List <String> mesNumeros;
try
{
Clientel unClient = new Clientel();
mesNumeros = unClient.LectureNoClient();
foreach (String item in mesNumeros)
{
cb_noclient.Items.Add(item);
}
Vendeur unVendeur = new Vendeur();
mesNumeros = unVendeur.LectureNoVendeur();
foreach (String item in mesNumeros)
{
cb_novendeur.Items.Add(item);
}
}
catch (MonException exception)
{
MessageBox.Show(exception.MessageApplication(), exception.Message);
}
}
public ActionResult Ajouter(Commande uneCom)
{
List <SelectListItem> items = new List <SelectListItem>();
foreach (String no in Vendeur.LectureNoVendeurs())
{
if (int.Parse(no) == uneCom.NoVendeur)
{
items.Add(new SelectListItem {
Text = "Vendeur N°" + no, Value = no, Selected = true
});
}
else
{
items.Add(new SelectListItem {
Text = "Vendeur N°" + no, Value = no
});
}
}
ViewBag.NoVendeurs = items;
items = new List <SelectListItem>();
foreach (String no in Clientel.LectureNoClients())
{
if (int.Parse(no) == uneCom.NoClient)
{
items.Add(new SelectListItem {
Text = "Client N°" + no, Value = no, Selected = true
});
}
else
{
items.Add(new SelectListItem {
Text = "Client N°" + no, Value = no
});
}
}
ViewBag.NoClients = items;
items = new List <SelectListItem>();
foreach (Article art in Article.getArticles())
{
items.Add(new SelectListItem {
Text = art.NoArticle + "/;/" + art.Libelle + "/;/" + art.Prix, Value = art.NoArticle.ToString()
});
}
ViewBag.Articles = items;
try
{
int id = Commande.insertCommande(uneCom);
return(RedirectToAction("Modifier", new { id = id }));
}
catch (MonException e)
{
ViewBag.Title = "Ajouter une commande";
return(View());
}
}
public ActionResult Ajouter()
{
try
{
//dropdown list de client
List <String> noClientList = new List <String>();
noClientList = (Clientel.LectureNoClient());
ViewBag.ListOfNoClient = noClientList;
//dropdown list de Vendeur
List <String> noVendeurList = new List <String>();
noVendeurList = (Vendeur.LectureNoVendeur());
ViewBag.ListOfNoVendeur = noVendeurList;
//dropdown list des articles
List <String> noArticleList = new List <String>();
noArticleList = (Commandes.LectureNoArticle());
ViewBag.ListOfNoArticle = noArticleList;
return(View(""));
}
catch (MonException e)
{
return(HttpNotFound());
}
}
public async Task <ActionResult <Vendeur> > PostTodoItem(Vendeur item)
{
_context.Vendeur.Add(item);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetTodoItem), new { id = item.Id }, item));
}
private Vente creerVenteFromView()
{
Vente vente = null;
if (typePaiement_comboBox != null && typePaiement_comboBox.SelectedIndex >= 0)
{
List <Prestation> listPrestation = new List <Prestation>();
List <Produit> listProduit = new List <Produit>();
Client client = null;
Vendeur vendeur = null;
if (comboBox_client.SelectedIndex != -1 && comboBox_vendeur.SelectedIndex != -1)
{
client = listClients[comboBox_client.SelectedIndex];
vendeur = listVendeurs[comboBox_vendeur.SelectedIndex];
}
foreach (Element elem in dataGrid_Element.Items)
{
if (elem is Prestation)
{
listPrestation.Add((Prestation)elem);
}
else if (elem is Produit)
{
listProduit.Add((Produit)elem);
}
}
float prixTotal;
if (float.TryParse(textBox_prixTotal.Text, out prixTotal))
{
if (client != null && vendeur != null)
{
string typePaiement = "";
string test = ((ComboBoxItem)typePaiement_comboBox.SelectedItem).Content.ToString();
if (test == "Carte bancaire")
{
typePaiement = "cb";
}
else if (test == "Espèces")
{
typePaiement = "especes";
}
else if (test == "Chèque")
{
typePaiement = "cheque";
}
if (typePaiement != "")
{
vente = new Vente(prixTotal, client, vendeur, listProduit, listPrestation, typePaiement, DateTime.Now);
}
}
}
if (utiliserFideliteCheckBox.IsChecked == true)
{
controller.viderFidelite(client);
}
}
return(vente);
}
public ActionResult Modifier(int id)
{
try
{
Commande uneCom = Commande.getCommande(id);
ViewBag.Title = "Modifier commande N°" + id;
List <SelectListItem> items = new List <SelectListItem>();
foreach (String no in Vendeur.LectureNoVendeurs())
{
if (int.Parse(no) == uneCom.NoVendeur)
{
items.Add(new SelectListItem {
Text = "Vendeur N°" + no, Value = no, Selected = true
});
}
else
{
items.Add(new SelectListItem {
Text = "Vendeur N°" + no, Value = no
});
}
}
ViewBag.NoVendeurs = items;
items = new List <SelectListItem>();
foreach (String no in Clientel.LectureNoClients())
{
if (int.Parse(no) == uneCom.NoClient)
{
items.Add(new SelectListItem {
Text = "Client N°" + no, Value = no, Selected = true
});
}
else
{
items.Add(new SelectListItem {
Text = "Client N°" + no, Value = no
});
}
}
ViewBag.NoClients = items;
items = new List <SelectListItem>();
foreach (Article art in Article.getArticles())
{
items.Add(new SelectListItem {
Text = art.NoArticle + "/;/" + art.Libelle + "/;/" + art.Prix, Value = art.NoArticle.ToString()
});
}
ViewBag.Articles = items;
return(View(uneCom));
}
catch (MonException e)
{
return(HttpNotFound());
}
}
//Add vendor
public IActionResult Add()
{
Vendeur v = new Vendeur();
IEnumerable <Ville> villes = MyDb.Villes.ToList();
ViewBag.villes = villes;
return(View(v));
}
public async Task <IActionResult> CreateVendeurManufacturierss(int vendeurId)
{
ViewBag.Manufacturier = _context.Manufacturier;
Vendeur vendeur = await _context.Vendeur.FirstOrDefaultAsync(v => v.VendeurId == vendeurId);
TempData["idV"] = vendeur.VendeurId;
return(View(vendeur));
}
public async Task <IActionResult> AjouterTelephone(int vendeurId)
{
ViewBag.VendeurManufacturier = _context.VendeurManufacturier.Include(v => v.Manufacturier).Include(v => v.Vendeur).Where(v => v.VendeurId == vendeurId);
ViewBag.Telephone = _context.Telephone;
Vendeur vendeur = await _context.Vendeur.FirstOrDefaultAsync(v => v.VendeurId == vendeurId);
TempData["idV"] = vendeur.VendeurId;
return(View(vendeur));
}
protected void getVariablesGET(int nbArticlesParPage)
{
String noVendeur = Request.QueryString["NoVendeur"];
String cat = Request.QueryString["NoCategorie"];
int intPage = 1;
int TypeRecherche = 0;
string strRecherche = "";
bool effectuerUneRecherche = false;
if (Request.QueryString["NbArticles"] != null)
{
if (!Request.QueryString["NbArticles"].Trim().Equals(""))
{
int.TryParse(Request.QueryString["NbArticles"], out nbArticlesParPage);
}
}
if (Request.QueryString["Page"] != null)
{
int.TryParse(Request.QueryString["Page"], out intPage);
}
if (Request.QueryString["TypeRecherche"] != null)
{
if (int.TryParse(Request.QueryString["TypeRecherche"], out TypeRecherche))
{
if (TypeRecherche >= 0 && TypeRecherche <= 3)
{
if (Request.QueryString["Recherche"] != null)
{
strRecherche = Request.QueryString["Recherche"];
effectuerUneRecherche = true;
}
}
}
}
Vendeur vendeur = null;
foreach (Vendeur vend in vendeurs.Values)
{
if (vend.NoVendeur.ToString().Equals(noVendeur))
{
vendeur = vend;
}
}
panelTable.Controls.Clear();
pagination.Controls.Clear();
//Response.Write(nbArticlesParPage.ToString());
if (effectuerUneRecherche)
{
PageVendeur(panelTable, vendeur, cat, nbArticlesParPage, intPage, TypeRecherche, strRecherche, true);
}
else
{
PageVendeur(panelTable, vendeur, cat, nbArticlesParPage, intPage);
}
}
public async Task <IActionResult> Register(RegisterViewModel model, string returnUrl = null)
{
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
//var user = new ApplicationUser { Nom = model.Nom,Prenom=model.Prenom, UserName = model.Email, Email = model.Email };
var user = new Vendeur {
UserName = model.Email, Email = model.Email
}; //SB: mis comme vendeur maintenant il peut créer un enchère
user.DateInscription = DateTime.Now;
var result = await _userManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
_logger.LogInformation("User created a new account with password.");
// SB: Pour ne pas exiger une validation par email SendGrid dans l'environnement de développement (pour accélérer) :
if (HttpContext.Connection.RemoteIpAddress.Equals(HttpContext.Connection.LocalIpAddress) || System.Net.IPAddress.IsLoopback(HttpContext.Connection.RemoteIpAddress))
{
// si en local (env. de dév.) :
user.EmailConfirmed = true;
user.Nom = "MonNom";
user.Prenom = "MonPrénom";
user.Civilite = new Civilite {
Abbreviation = CiviliteAbbreviation.M.ToString(), Name = CiviliteName.Monsieur.ToString()
}.Abbreviation; //user.Civilite = "Monsieur";
user.Langue = new Language {
Abbreviation = LanguageAbbreviation.fr.ToString(), Name = LanguageName.FR.ToString()
}.Abbreviation; // TODO SASHA ajouter langue//user.Langue = "en";
await _userManager.UpdateAsync(user); // MAJ
await _userManager.AddToRoleAsync(user, "Member"); // ajout Role
await _signInManager.SignInAsync(user, isPersistent : false);
_logger.LogInformation("User created a new account with password.");
}
else
{
// si sur Serveur
// envoie de courriel SendGrid si on s'authentifie sur serveur..
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
var callbackUrl = Url.EmailConfirmationLink(user.Id, code, Request.Scheme);
await _emailSender.SendEmailConfirmationAsync(model.Email, callbackUrl);
}
return(RedirectToLocal(returnUrl));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public async Task <IActionResult> Create([Bind("VendeurId,VendeurNom,VendeurAddress,VendeurNoTel")] Vendeur vendeur)
{
if (ModelState.IsValid)
{
_context.Add(vendeur);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(vendeur));
}
public ActionResult AjouterVendeur(Vendeur v)
{
Vendeur cli = new Vendeur();
cli.identifiant = v.identifiant;
cli.nom = v.nom;
cli.prenom = v.prenom;
bd.Vendeur.Add(cli);
bd.SaveChanges();
return(View("InscrireVendeur"));
}
public CommandeViewModel(int noCommande, Vendeur vendeur, Clientel clientel, string date, bool facture)
{
NoCommande = noCommande;
Vendeur = vendeur;
Clientel = new ClientelViewModel(clientel);
Date = date;
Facture = facture;
Vendeurs = new List <SelectListItem>();
Clients = new List <SelectListItem>();
}
public ActionResult ajoutVendeur(Vendeur vendeur)
{
Vendeur v = new Vendeur();
v.identifiant = vendeur.identifiant;
v.nom = vendeur.nom;
v.prenom = vendeur.prenom;
bd.Vendeur.Add(v);
bd.SaveChanges();
return(View("Vend"));
}
public int addVendeur(Vendeur vendeur)
{
string query = "INSERT INTO vendeur('nom','prenom', 'type_contrat') VALUES(";
StringBuilder stringBuilder = new StringBuilder(query);
stringBuilder.Append("'" + vendeur.Nom.Replace("'", "''") + "'" + ",");
stringBuilder.Append("'" + vendeur.Prenom.Replace("'", "''") + "'" + ",");
stringBuilder.Append("'" + vendeur.TypeContrat.Replace("'", "''") + "'" + ")");
int res = sqliteAccess.ExecuteComandWOReturn(stringBuilder.ToString());
return(res);
}
public ActionResult FicheVendeur(int id)
{
try
{
Vendeur unVend = Vendeur.getVendeur(id);
ViewBag.Title = "Vendeur";
return(View(unVend));
}
catch (MonException e)
{
return(HttpNotFound());
}
}
public IActionResult Add(Vendeur vendeur)
{
if (ModelState.IsValid)
{
MyDb.Vendeurs.Add(vendeur);
MyDb.SaveChanges();
return(RedirectToAction("Index"));
}
IEnumerable <Ville> villes = MyDb.Villes.ToList();
ViewBag.villes = villes;
return(View("Add", vendeur));
}
private Vendeur creerVendeurFromView()
{
Vendeur res = null;
try
{
return(new Vendeur(textBoxNom.Text, textBoxPrenom.Text, textBoxTypeContrat.Text));
}
catch
{
}
return(res);
}
public static Vendeur ToVendeur(this DefaultVendeur defaultVendeur, Vendeur vendeur = null)
{
if (vendeur == null)
{
vendeur = new Vendeur();
}
vendeur.Nom = defaultVendeur.Nom;
vendeur.Email = defaultVendeur.Email;
vendeur.Telephone = defaultVendeur.Telephone;
vendeur.Num = defaultVendeur.Num;
return(vendeur);
}
public ActionResult Detail(int id)
{
Vendeur vendeur = new Vendeur();
using (Models.KartinaDotNetFrameworkEntities1 context = new KartinaDotNetFrameworkEntities1())
{
//var query = from item in context.Vendeur
// where item.Id == id
// select item;
vendeur = context.Vendeur.First(item => item.Id == id);
}
this.ViewBag.MonVendeur = vendeur;
return(View());
}
//GET: Vendeur
public ActionResult Index()
{
IEnumerable <Vendeur> vendeurs = null;
try
{
vendeurs = Vendeur.getVendeurs();
}
catch (MonException e)
{
ModelState.AddModelError("Erreur", "Erreur lors de la récupération des vendeurs : " + e.Message);
return(View("Error"));
}
return(View(vendeurs));
}
private static void InsertData()
{
using (var _context = new MyDbContext())
{
// Creates the database if not exists
_context.Database.EnsureCreated();
Categorie cat = new Categorie
{
Name = "Tomates",
Famille = "Fruit",
};
_context.Categorie.Add(cat);
Adresse adr = new Adresse
{
numero = "2",
codePostal = "59200",
rue = "rue d'anzin",
ville = "Tourcoing"
};
_context.Adresse.Add(adr);
// Create a new TodoItem if collection is empty,
// which means you can't delete all TodoItems.
Vendeur v = new Vendeur
{
adresse = adr,
Name = "Vendeur test",
Description = "ceuci est un vendeur autogenerer"
};
_context.Vendeur.Add(v);
// Create a new TodoItem if collection is empty,
// which means you can't delete all TodoItems.
_context.Produit.Add(
new Produit
{
Description = "ceci sont des des tomates bio de chez vendeur test",
Name = "tomate bio",
vendeur = v,
categorie = cat,
Prix = 10.10
});
_context.SaveChanges();
}
}
