// // 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); }