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