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