static void Main(string[] args) { A a = new A(0); B b = new B(1); Legume carotte = new Legume(); Console.WriteLine(carotte); Console.WriteLine(carotte.Murir()); Console.WriteLine(carotte.Fleurir()); Console.ReadLine(); }
public ActionResult Legume() { using (var _db = new OracleConnection("User Id=APP_DEV;Password=appDev2018!;Data Source=54.38.230.175/orcldev")) { _db.Open(); String sql = "SELECT * " + "" + " FROM JC_PRODUCT P INNER JOIN JC_PRODUCT_CATEGORY PC " + "" + " ON P.PRODUCT_ID = PC.PRODUCT_ID " + "" + "INNER JOIN JC_CATEGORY C " + "" + "ON PC.CATEGORY_ID = C.CATEGORY_ID WHERE PC.CATEGORY_ID = 10"; OracleCommand cmd = new OracleCommand(sql, _db); var model = new List <Legume>(); try { OracleDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Legume legume = new Legume(); legume.Nom = Convert.ToString(rdr["PRODUCT_NAME"]); legume.Description = Convert.ToString(rdr["PRODUCT_DESCRIPTION"]); legume.Masse = Convert.ToInt32(rdr["PRODUCT_WEIGHT"]); legume.Prix = Convert.ToDouble(rdr["PRODUCT_PRICE"]); model.Add(legume); } } catch (Exception ex) { Console.WriteLine(ex.Message); } _db.Close(); return(View(model)); } }