static public void Update(Contact c) { using (ModelCoursContainer entities = new ModelCoursContainer()) { entities.Contact.Attach(c); foreach (PropertyInfo item in c.GetType().GetProperties()) { if (!item.Name.StartsWith("Id")) { Console.WriteLine("{0} :", item.Name); if (item.GetValue(c, null) != null && item.GetValue(c, null).GetType() == typeof(DateTime)) { item.SetValue(c, Convert.ToDateTime(Console.ReadLine(), new CultureInfo("fr-FR")), null); continue; } item.SetValue(c, Console.ReadLine(), null); } } entities.SaveChanges(); } }
static public void DeleteContact(int idContact) { using (ModelCoursContainer entities = new ModelCoursContainer()) { Contact c = entities.Contact.Where(co => co.IdContact == idContact).First(); Contact c1 = (from co in entities.Contact where co.IdContact == idContact select co).First(); entities.Contact.Remove(c1); entities.SaveChanges(); } }
static public void InsertRead() { using (ModelCoursContainer entities = new ModelCoursContainer()) { Contact c = new Contact("GASQUET", "NICOLAS", Convert.ToDateTime("21/06/1981", new CultureInfo("fr-FR"))); //Console.WriteLine(Convert.ToDateTime("21/06/1981", new CultureInfo("fr-FR"))); DateTime t = new DateTime(); if (t.GetType() == typeof(DateTime)) { Console.WriteLine("oo"); } try { entities.Contact.Add(c); if (entities.SaveChanges() == 0) { Console.WriteLine("Erreur de validation"); } foreach (Contact item in entities.Contact) { Console.WriteLine("{0} {1} {2}", item.Nom, item.Prenom, item.DateNaiss); } } catch (DbEntityValidationException e) { Console.WriteLine(e.Message); } Console.WriteLine("Id a supprimer"); DeleteContact(int.Parse(Console.ReadLine())); } }