public Transaction_effectuee supprimer(Transaction_effectuee u)
{
if (u == null)
{
u = new Transaction_effectuee();
}
try
{
if (db.Transaction_effectuee.First(x => x.codeTRANSACTION_EFFECTUEE == u.codeTRANSACTION_EFFECTUEE) != null)
{
//sauvegarde des nouvelles informations
db.supprimerTransaction_effectuee(u.codeTRANSACTION_EFFECTUEE, u.codeCOMPTE_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 Transaction_effectuee rechercher(string code)
{
Transaction_effectuee u = new Transaction_effectuee();
try
{
u = db.Transaction_effectuee.First(x => x.codeTRANSACTION_EFFECTUEE == 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 ActionResult Edit(Transaction_effectuee x)
{
try
{
dao.modifier(x);
// TODO: Add update logic here
return(RedirectToAction("afficherTous"));
}
catch
{
return(View());
}
}
public Transaction_effectuee rechercherUnique(Transaction_effectuee m)
{
Transaction_effectuee u = new Transaction_effectuee();
try
{
u = db.Transaction_effectuee.First(x => x.libelle == m.libelle);
}
catch (Exception ex)
{
u.libelle = ex.StackTrace;
}
return(u);
}
public Transaction_effectuee ajouter(Transaction_effectuee u)
{
if (u == null)
{
u = new Transaction_effectuee();
}
try
{
db.creerTransaction_effectuee(u.libelle, u.montant_transaction, u.codeCOMPTE_MARKETER, u.codeU);
}
catch (Exception ex)
{
u.libelle = ex.StackTrace;
}
return(u);
}
public List <Transaction_effectuee> rechercherTous()
{
List <Transaction_effectuee> us = new List <Transaction_effectuee>();
try
{
us = db.Transaction_effectuee.ToList();
}
catch (Exception ex)
{
Transaction_effectuee p = new Transaction_effectuee();
p.libelle = ex.StackTrace;
us.Add(p);
}
return(us);
}
public List <Transaction_effectuee> rechercherParMC(Func <Transaction_effectuee, bool> predicate)
{
List <Transaction_effectuee> us = new List <Transaction_effectuee>();
try
{
us = db.Transaction_effectuee.Where(predicate).ToList();
}
catch (Exception ex)
{
Transaction_effectuee p = new Transaction_effectuee();
p.libelle = ex.StackTrace;
us.Add(p);
}
return(us);
}
// GET: Transaction_effectuee/Edit/5
public ActionResult Edit(string code)
{
Transaction_effectuee x = dao.rechercher(code);
TransactionEffectueeModel pm = new TransactionEffectueeModel
{
codeTRANSACTION_EFFECTUEE = x.codeTRANSACTION_EFFECTUEE,
libelle = x.libelle,
montant_transaction = x.montant_transaction,
///*******
///
codeU = x.codeU,
codeCOMPTE_MARKETER = x.codeCOMPTE_MARKETER
};
return(View(pm));
}
// GET: Transaction_effectuee/Details/5
public ActionResult Details(string code)
{
Transaction_effectuee x = dao.rechercher(code);
TransactionEffectueeModel pm = new TransactionEffectueeModel
{
codeTRANSACTION_EFFECTUEE = x.codeTRANSACTION_EFFECTUEE,
libelle = x.libelle,
montant_transaction = x.montant_transaction,
codeCOMPTE_MARKETER = x.codeCOMPTE_MARKETER,
codeU = x.codeU
};
if (x == null)
{
return(HttpNotFound());
}
return(View(pm));
}
public ActionResult Create(FormCollection collection)
{
try
{
string s = "";
s = collection["montant_transaction"];
char decimalSymbol = ',';
var curr = System.Windows.Forms.Application.CurrentCulture.NumberFormat.NumberDecimalSeparator;
s = s.Replace(".", curr).Replace(decimalSymbol.ToString(), curr);
// TODO: Add insert logic here
Transaction_effectuee x = new Transaction_effectuee
{
libelle = collection["libelle"],
date_transaction = DateTime.Now,
montant_transaction = decimal.Parse(s),
//*******
codeCOMPTE_MARKETER = collection["codeCOMPTE_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: Transaction_effectuee/Create
public ActionResult Create(Transaction_effectuee m)
{
TransactionEffectueeModel pm = new TransactionEffectueeModel();
return(View("Create", pm));
}
