//
// 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<CHARGERMENT> GetList()
{
List<CHARGERMENT> _list= new List<CHARGERMENT>();
SqlDataReader dr = null;
CHARGERMENT var = null;
SqlParameter id_auto=new SqlParameter ("@ID_AUTO","0");
try
{
dr = SqlHelper.ExecuteReader(Connexion.Cnx,
"SPGETLIST_CHARGERMENT" ,id_auto);
while (dr.Read())
{
var=new CHARGERMENT();
var.SetId(dr.GetInt32(dr.GetOrdinal("ID_AUTO")));
if(!(dr.IsDBNull(dr.GetOrdinal("INTITULE"))))
{
var.INTITULE = dr.GetString(dr.GetOrdinal("INTITULE"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("ID_ZONE"))))
{
var.ID_ZONE = dr.GetInt32(dr.GetOrdinal("ID_ZONE"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("PRIX_ACHAT_TOTAL"))))
{
var.PRIX_ACHAT_TOTAL = dr.GetInt32(dr.GetOrdinal("PRIX_ACHAT_TOTAL"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("QTE_TOTAL_ACHAT"))))
{
var.QTE_TOTAL_ACHAT = dr.GetInt32(dr.GetOrdinal("QTE_TOTAL_ACHAT"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("QTE_TOTAL_SORTIE"))))
{
var.QTE_TOTAL_SORTIE = dr.GetInt32(dr.GetOrdinal("QTE_TOTAL_SORTIE"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("QTE_TOTAL_VENDU"))))
{
var.QTE_TOTAL_VENDU = dr.GetInt32(dr.GetOrdinal("QTE_TOTAL_VENDU"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("PRIX_REVIENT"))))
{
var.PRIX_REVIENT = dr.GetInt32(dr.GetOrdinal("PRIX_REVIENT"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("DATE_OPERATION"))))
{
var.DATE_OPERATION = dr.GetDateTime(dr.GetOrdinal("DATE_OPERATION"));
}
if(!(dr.IsDBNull(dr.GetOrdinal("ID_UTILISATEUR"))))
{
var.ID_UTILISATEUR = dr.GetInt32(dr.GetOrdinal("ID_UTILISATEUR"));
}
var.SetSYS_UTILISATEUR(dr.GetString(dr.GetOrdinal("SYS_UTILISATEUR")));
var.SetZONE(dr.GetString(dr.GetOrdinal("ZONE")));
_list.Add(var);
}
return _list;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
dr.Close();
}
}
//
// 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);
}
