public static void Show() { using (ConnectDbDataContext db = new ConnectDbDataContext()) { var data = db.Grades.ToList(); foreach (var item in data) { Console.WriteLine("ID: {0} - Name: {1}", item.id, item.name); } } }
public static int Add() { using (ConnectDbDataContext db = new ConnectDbDataContext()) { var item = new Grade(); item.name = String.Format("Lop {0}", GenerateTime()); db.Grades.InsertOnSubmit(item); db.SubmitChanges(); return(item.id); } }
public static void Delete(int id) { using (ConnectDbDataContext db = new ConnectDbDataContext()) { var item = db.Grades.FirstOrDefault(o => o.id == id); if (item != null) { db.Grades.DeleteOnSubmit(item); db.SubmitChanges(); } } }
public static void Edit(int id) { using (ConnectDbDataContext db = new ConnectDbDataContext()) { var item = db.Grades.FirstOrDefault(o => o.id == id); if (item != null) { Console.WriteLine("nhap name moi:"); item.name = Console.ReadLine(); db.SubmitChanges(); } } }