public FacturationMarketer supprimer(FacturationMarketer u)
{
if (u == null)
{
u = new FacturationMarketer();
}
try
{
if (db.FacturationMarketers.First(x => x.codeFACTURATION_MARKETER == u.codeFACTURATION_MARKETER) != null)
{
//sauvegarde des nouvelles informations
db.supprimerFacturationMarketer(u.codeFACTURATION_MARKETER, u.codeCOMMANDE_MARKETER, u.codeU);
}
else
{
u.libelle = "Cet enregistrement n'existe pas dans la base de donnees.";
}
}
catch (Exception ex)
{
u.libelle = ex.StackTrace;
}
return(u);
}
public FacturationMarketer rechercher(string code)
{
FacturationMarketer u = new FacturationMarketer();
try
{
u = db.FacturationMarketers.First(x => x.codeFACTURATION_MARKETER == code);
//verification de l'existence de l'objet dans la bd
if (u != null)
{
return(u);
}
else
{
u.libelle = "Aucun enregistrement trouve.";
return(null);
}
}
catch (Exception ex)
{
u.libelle = ex.StackTrace;
}
return(u);
}
public FacturationMarketer modifier(FacturationMarketer u)
{
if (u == null)
{
u = new FacturationMarketer();
}
try
{
//verification de l'existence de l'objet dans la bd
if (db.FacturationMarketers.First(x => x.codeFACTURATION_MARKETER == u.codeFACTURATION_MARKETER) != null)
{
//sauvegarde des nouvelles informations
db.modifierFacturationMarketer(u.codeFACTURATION_MARKETER, u.libelle, u.montant_paye, u.montant_restant, u.montant_total, u.codeCOMMANDE_MARKETER, u.codeU);
}
else
{
u.libelle = "Cet enregistrement n'existe pas dans la base de donnees.";
}
}
catch (Exception ex)
{
u.libelle = ex.StackTrace;
}
return(u);
}
public ActionResult Edit(FacturationMarketer x)
{
try
{
dao.modifier(x);
// TODO: Add update logic here
return(RedirectToAction("afficherTous"));
}
catch
{
return(View());
}
}
public FacturationMarketer ajouter(FacturationMarketer u)
{
if (u == null)
{
u = new FacturationMarketer();
}
try
{
db.creerFacturationMarketer(u.libelle, u.montant_paye, u.montant_restant, u.montant_total, u.codeCOMMANDE_MARKETER, u.codeU);
}
catch (Exception ex)
{
u.libelle = ex.StackTrace;
}
return(u);
}
//public FacturationMarketer rechercherUnique(FacturationMarketer m)
//{
// FacturationMarketer u = new FacturationMarketer();
// try
// {
// u = db.FacturationMarketers.First(x => x.adresse == m.adresse && x.email == m.email && x.localisation == m.localisation && x.nom == m.nom && x.pays == m.pays && x.telephone == m.telephone && x.ville == m.ville);
// }
// catch (Exception ex)
// {
// u.adresse = ex.StackTrace;
// }
// return u;
//}
public List <FacturationMarketer> rechercherTous()
{
List <FacturationMarketer> us = new List <FacturationMarketer>();
try
{
us = db.FacturationMarketers.ToList();
}
catch (Exception ex)
{
FacturationMarketer p = new FacturationMarketer();
p.libelle = ex.StackTrace;
us.Add(p);
}
return(us);
}
public List <FacturationMarketer> rechercherParMC(Func <FacturationMarketer, bool> predicate)
{
List <FacturationMarketer> us = new List <FacturationMarketer>();
try
{
us = db.FacturationMarketers.Where(predicate).ToList();
}
catch (Exception ex)
{
FacturationMarketer p = new FacturationMarketer();
p.libelle = ex.StackTrace;
us.Add(p);
}
return(us);
}
public ActionResult Create(FormCollection collection)
{
try
{
string s, t, u = "";
s = collection["montant_paye"];
t = collection["montant_restant"];
u = collection["montant_total"];
char decimalSymbol = ',';
var curr = System.Windows.Forms.Application.CurrentCulture.NumberFormat.NumberDecimalSeparator;
s = s.Replace(".", curr).Replace(decimalSymbol.ToString(), curr);
t = t.Replace(".", curr).Replace(decimalSymbol.ToString(), curr);
u = u.Replace(".", curr).Replace(decimalSymbol.ToString(), curr);
// TODO: Add insert logic here
FacturationMarketer x = new FacturationMarketer
{
libelle = collection["libelle"],
montant_paye = decimal.Parse(s),
montant_restant = decimal.Parse(t),
montant_total = decimal.Parse(u),
//*******
codeCOMMANDE_MARKETER = collection["codeCOMMANDE_MARKETER"],
codeU = collection["codeU"],
date_c = DateTime.Now
//codePRODUIT = "PDT20192208"
};
dao.ajouter(x);
return(RedirectToAction("afficherTous"));
}
catch (Exception ex)
{
ViewBag.Erreur = ex.Message;
return(View());
}
}
// GET: FacturationMarketer/Details/5
public ActionResult Details(string code)
{
FacturationMarketer x = dao.rechercher(code);
FacturationMarketerModel pm = new FacturationMarketerModel
{
codeFACTURATION_MARKETER = x.codeFACTURATION_MARKETER,
libelle = x.libelle,
montant_paye = x.montant_paye,
montant_restant = x.montant_restant,
montant_total = x.montant_total,
codeCOMMANDE_MARKETER = x.codeCOMMANDE_MARKETER,
};
if (x == null)
{
return(HttpNotFound());
}
return(View(pm));
}
// GET: FacturationMarketer/Edit/5
public ActionResult Edit(string code)
{
FacturationMarketer x = dao.rechercher(code);
FacturationMarketerModel pm = new FacturationMarketerModel
{
libelle = x.libelle,
montant_paye = x.montant_paye,
montant_restant = x.montant_restant,
montant_total = x.montant_total,
///*******
///
codeU = x.codeU,
codeCOMMANDE_MARKETER = x.codeCOMMANDE_MARKETER,
codeFACTURATION_MARKETER = x.codeFACTURATION_MARKETER
};
return(View(pm));
}
// GET: CompteMarketer/Create
public ActionResult Create(FacturationMarketer m)
{
FacturationMarketerModel pm = new FacturationMarketerModel();
return(View("Create", pm));
}
