//
// GET: /VenteDetails/
public ActionResult Index()
{
VENTE_DETAILS _venteDetails = new VENTE_DETAILS();
List<Vente_Details> _list = new List<Vente_Details>(); ;
foreach (VENTE_DETAILS item in VENTE_DETAILS.GetList())
{
Vente_Details ventesDetails = new Vente_Details();
ventesDetails.ID_AUTO = item.ID_AUTO;
ventesDetails.ID_CHARGEMENT = item.ID_CHARGEMENT;
ventesDetails.ID_VENTE = item.ID_VENTE;
VENTE vente = new VENTE();
vente.LoadId(item.ID_VENTE);
ventesDetails.VENTE = vente.ToString();
CHARGERMENT charge = new CHARGERMENT();
charge.LoadId(item.ID_CHARGEMENT);
ventesDetails.CHARGEMENT = charge.ToString();
ventesDetails.PRIX_UNITAIRE= item.PRIX_UNITAIRE;
ventesDetails.QTE = item.QTE;
ventesDetails.TOTAL = item.TOTAL;
_list.Add(ventesDetails);
}
return View(_list);
}
public static List<VENTE_DETAILS> GetListByVente(int idVente,int idChargement)
{
List<VENTE_DETAILS> _list = new List<VENTE_DETAILS>();
SqlDataReader dr = null;
VENTE_DETAILS var = null;
SqlParameter id_vente = new SqlParameter("@ID_VENTE", idVente);
SqlParameter id_chargement = new SqlParameter("@ID_CHARGEMENT", idChargement);
try
{
dr = SqlHelper.ExecuteReader(Connexion.Cnx,
"SPGETLIST_VENTE_DETAILSBY_VENTE", id_vente, id_chargement);
while (dr.Read())
{
var = new VENTE_DETAILS();
var.SetId(dr.GetInt32(dr.GetOrdinal("ID_AUTO")));
var.ID_VENTE = dr.GetInt32(dr.GetOrdinal("ID_VENTE"));
var.ID_CHARGEMENT = dr.GetInt32(dr.GetOrdinal("ID_CHARGEMENT"));
var.PRIX_UNITAIRE = dr.GetInt32(dr.GetOrdinal("PRIX_UNITAIRE"));
var.QTE = dr.GetInt32(dr.GetOrdinal("QTE"));
var.TOTAL = dr.GetInt32(dr.GetOrdinal("TOTAL"));
var.SetCHARGERMENT(dr.GetString(dr.GetOrdinal("CHARGERMENT")));
_list.Add(var);
}
return _list;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dr.Close();
}
}
public static List<VENTE_DETAILS> GetList()
{
List<VENTE_DETAILS> _list= new List<VENTE_DETAILS>();
SqlDataReader dr = null;
VENTE_DETAILS var = null;
SqlParameter id_auto=new SqlParameter ("@ID_AUTO","0");
try
{
dr = SqlHelper.ExecuteReader(Connexion.Cnx,
"SPGETLIST_VENTE_DETAILS" ,id_auto);
while (dr.Read())
{
var=new VENTE_DETAILS();
var.SetId(dr.GetInt32(dr.GetOrdinal("ID_AUTO")));
var.ID_VENTE = dr.GetInt32(dr.GetOrdinal("ID_VENTE"));
var.ID_CHARGEMENT = dr.GetInt32(dr.GetOrdinal("ID_CHARGEMENT"));
var.PRIX_UNITAIRE = dr.GetInt32(dr.GetOrdinal("PRIX_UNITAIRE"));
var.QTE = dr.GetInt32(dr.GetOrdinal("QTE"));
var.TOTAL = dr.GetInt32(dr.GetOrdinal("TOTAL"));
_list.Add(var);
}
return _list;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dr.Close();
}
}
public ActionResult Create(Vente_Details VenteDetailsToCreate)
{
if (!ModelState.IsValid)
return View();
try
{
VENTE_DETAILS _venteDetails = new VENTE_DETAILS();
_venteDetails.ID_CHARGEMENT = VenteDetailsToCreate.ID_CHARGEMENT;
_venteDetails.ID_VENTE = VenteDetailsToCreate.ID_VENTE;
_venteDetails.PRIX_UNITAIRE = VenteDetailsToCreate.PRIX_UNITAIRE;
_venteDetails.QTE = VenteDetailsToCreate.QTE;
_venteDetails.TOTAL = VenteDetailsToCreate.TOTAL;
_venteDetails.Save();
return RedirectToAction("../VenteDetails/Index");
}
catch
{
return View();
}
}
public ActionResult Delete(Vente_Details VenteDetailsToDel)
{
int id = Int32.Parse(RouteData.Values["id"].ToString());
if (!ModelState.IsValid)
return View();
try
{
VENTE_DETAILS _venteDetails = new VENTE_DETAILS();
_venteDetails.SetId(id);
_venteDetails.Delete();
return RedirectToAction("../VenteDetails/Index");//reafficher l liste
}
catch
{
return View();
}
}
//
// GET: /VenteDetails/Delete/5
public ActionResult Delete()
{
int id = Int32.Parse(RouteData.Values["id"].ToString());
Vente_Details ventesDetails = new Vente_Details();
VENTE_DETAILS _venteDetails = new VENTE_DETAILS();
_venteDetails.LoadId(id);
ventesDetails.TOTAL = _venteDetails.TOTAL;
ventesDetails.QTE = _venteDetails.QTE;
ventesDetails.PRIX_UNITAIRE = _venteDetails.PRIX_UNITAIRE;
ventesDetails.ID_VENTE = _venteDetails.ID_VENTE;
ventesDetails.ID_CHARGEMENT = _venteDetails.ID_CHARGEMENT;
VENTE vente = new VENTE();
vente.LoadId(_venteDetails.ID_VENTE);
ventesDetails.VENTE = vente.ToString();
CHARGERMENT charge = new CHARGERMENT();
charge.LoadId(_venteDetails.ID_CHARGEMENT);
ventesDetails.CHARGEMENT = charge.ToString();
IEnumerable<SelectListItem> list = ToSelectListItems();
list.ToList().Find(x => x.Text.Equals(ventesDetails.VENTE)).Selected = true;
ViewData["ID_VENTE"] = list;
IEnumerable<SelectListItem> list1 = ToSelectListItems1();
list1.ToList().Find(x => x.Text.Equals(ventesDetails.CHARGEMENT)).Selected = true;
ViewData["ID_CHARGEMENT"] = list1;
return View(ventesDetails);
}
public ActionResult Edit(Vente_Details ventesDetails)
{
int id = Int32.Parse(RouteData.Values["id"].ToString());
if (!ModelState.IsValid)
return View();
try
{
VENTE_DETAILS _venteDetails = new VENTE_DETAILS();
_venteDetails.TOTAL = ventesDetails.TOTAL;
_venteDetails.PRIX_UNITAIRE = ventesDetails.PRIX_UNITAIRE;
_venteDetails.QTE = ventesDetails.QTE;
_venteDetails.ID_VENTE = ventesDetails.ID_VENTE;
_venteDetails.ID_CHARGEMENT = ventesDetails.ID_CHARGEMENT;
_venteDetails.SetId(id);
_venteDetails.Save();
return RedirectToAction("../VenteDetails/Index");
}
catch
{
return View();
}
}