public static void Update(Nguoi nguoi)
{
using (var db = new tourEntities())
{
db.Entry(nguoi).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void Insert(Nguoi nguoi)
{
using (var db = new tourEntities())
{
db.Nguois.Add(nguoi);
db.SaveChanges();
}
}
public static void Delete(Nguoi nguoi)
{
using (var db = new tourEntities())
{
var result = (from c in db.Nguois where c.Id == nguoi.Id select c).First();
db.Nguois.Remove(result);
db.SaveChanges();
}
}
public static List <DoanDL> getDoanDaDi(Nguoi nguoi)
{
using (var db = new tourEntities())
{
List <CTDoan> result = (from c in db.CTDoans where c.MaNguoiThamGia == nguoi.Id select c).ToList();
List <DoanDL> kq = new List <DoanDL>();
foreach (CTDoan ct in result)
{
kq.Add((from c in db.DoanDLs where c.Id == ct.MaDoan select c).FirstOrDefault());
}
return(kq.Distinct().ToList <DoanDL>());
}
}
