// GET: Fabricant/Create
public ActionResult Create()
{
Fabricant niouFab = new Fabricant();
InitDropDownAdresses();
return(View(niouFab));
}
public Boolean ModifierPa(Materiel m, string refe)
{
try
{
string reference = m.getReference();
string des = m.getDescription();
string prix = m.getPrix();
string quantite = m.getQuantite();
string lien = m.getLien();
Fabricant fab = m.getFabricant();
Cassier c = m.getCassier();
cn.Open();
cmd.Connection = cn;
cmd.CommandText = "update Materiel set ref= @reference, description = @des, prix = @prix, quantite = @quantite, lien = @lien, nomFab = @nomFab, nomCasier=@nomCasier where ref=@refe";
cmd.Parameters.Add(new SqlParameter("@reference", reference));
cmd.Parameters.Add(new SqlParameter("@des", des));
cmd.Parameters.Add(new SqlParameter("@prix", prix));
cmd.Parameters.Add(new SqlParameter("@quantite", quantite));
cmd.Parameters.Add(new SqlParameter("@lien", lien));
cmd.Parameters.Add(new SqlParameter("@nomFab", fab.getNom()));
cmd.Parameters.Add(new SqlParameter("@nomCasier", c.getNom()));
cmd.Parameters.Add(new SqlParameter("@refe", refe));
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Console.WriteLine("error :" + ex);
return(false);
}
finally
{
cn.Close();
}
}
public Boolean AjouterP(Materiel m)
{
try
{
string reference = m.getReference();
string des = m.getDescription();
string prix = m.getPrix();
string quantite = m.getQuantite();
string lien = m.getLien();
Fabricant fab = m.getFabricant();
Cassier c = m.getCassier();
cn.Open();
cmd.Connection = cn;
cmd.CommandText = "insert into Materiel values (@reference,@des,@prix,@quantite,@lien,@fab,@casier)";
cmd.Parameters.Add(new SqlParameter("@reference", reference));
cmd.Parameters.Add(new SqlParameter("@des", des));
cmd.Parameters.Add(new SqlParameter("@prix", prix));
cmd.Parameters.Add(new SqlParameter("@quantite", quantite));
cmd.Parameters.Add(new SqlParameter("@lien", lien));
cmd.Parameters.Add(new SqlParameter("@fab", fab.getNom()));
cmd.Parameters.Add(new SqlParameter("@casier", c.getNom()));
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Console.WriteLine("error :" + ex);
return(false);
}
finally
{
cn.Close();
}
}
public Boolean Ajout(Materiel m)
{
try
{
string reference = m.getReference();
string des = m.getDescription();
string prix = m.getPrix();
string quantite = m.getQuantite();
string lien = m.getLien();
Fabricant fab = m.getFabricant();
Cassier c = m.getCassier();
string req = string.Format("insert into Materiel values ('" + reference + "','" + des + "','" + prix + "','" + quantite + "','" + lien + "','" + fab.getNom() + "','" + c.getNom() + "')");
cmd.Connection = cn;
cn.Open();
cmd.CommandText = req;
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Console.WriteLine("error :" + ex.Message);
return(false);
}
finally
{
cn.Close();
}
}
public Boolean modifier(Materiel m, string refe)
{
try
{
string reference = m.getReference();
string des = m.getDescription();
string prix = m.getPrix();
string quantite = m.getQuantite();
string lien = m.getLien();
Fabricant fab = m.getFabricant();
Cassier c = m.getCassier();
string req = string.Format("update Materiel set ref='" + reference + "', description='" + des + "' , prix='" + prix + "' , quantite='" + quantite + "' , lien='" + lien + "' , nomFab='" + fab.getNom() + "' , nomCasier='" + c.getNom() + "' where ref='" + refe + "'");
cmd.Connection = cn;
cn.Open();
cmd.CommandText = req;
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
System.Console.WriteLine("error :" + ex.Message);
return(false);
}
finally
{
cn.Close();
}
}
public ActionResult DeleteConfirmed(int id)
{
Fabricant fabricant = db.Fabricants.Find(id);
db.Fabricants.Remove(fabricant);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Nom")] Fabricant fabricant)
{
if (ModelState.IsValid)
{
db.Entry(fabricant).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fabricant));
}
public Materiel(string r, string d, string p, string q, string l, Fabricant fab, Cassier c)
{
reference = r;
description = d;
prix = p;
quantite = q;
lien = l;
f = fab;
cas = c;
}
public ActionResult Delete(Fabricant fabricant)
{
try {
_repository.Delete(fabricant);
return(RedirectToAction(nameof(Index)));
}
catch {
return(View());
}
}
public ActionResult Create([Bind(Include = "ID,Nom")] Fabricant fabricant)
{
if (ModelState.IsValid)
{
db.Fabricants.Add(fabricant);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(fabricant));
}
public ActionResult Edit(Fabricant fabricant)
{
try
{
repoFabricant.UpdateItem(fabricant);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Create(Fabricant fabricant)
{
try
{
repoFabricant.InsertItem(fabricant);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Create(Fabricant fab, FormCollection collection)
{
if (ModelState.IsValid)
{
repFabricants.Creer(fab);
return(RedirectToAction("Liste"));
}
else
{
return(View());
}
}
// GET: Fabricants/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Fabricant fabricant = db.Fabricants.Find(id);
if (fabricant == null)
{
return(HttpNotFound());
}
return(View(fabricant));
}
public ActionResult Edit(Fabricant fab, FormCollection collection)
{
try
{
if (ModelState.IsValid)
{
repFabricants.Editer(fab, fab.id);
return(RedirectToAction("Liste"));
}
else
{
return(View());
}
}
catch
{
throw new Exception();
return(View());
}
}
public Boolean ajouter(Fabricant f)
{
try
{
string nom = f.getNom();
cn.Open();
cmd.Connection = cn;
cmd.CommandText = "insert into Fabricant values (@nom)";
cmd.Parameters.Add(new SqlParameter("@nom", nom));
cmd.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Console.WriteLine("error :" + ex);
return(false);
}
finally
{
cn.Close();
}
}
// GET: Fabricants/Edit/5
public ActionResult Edit(int id)
{
Fabricant Fabricant = _repository.GetById(id);
return(View(Fabricant));
}
