public static void Delete(Tour tour)
{
using (var db = new tourEntities())
{
db.Entry(tour).State = EntityState.Deleted;
db.SaveChanges();
}
}
public static void Insert(Gia gia)
{
using (var db = new tourEntities())
{
db.Gias.Add(gia);
db.SaveChanges();
}
}
public static void Insert(CTTour cttour)
{
using (var db = new tourEntities())
{
db.CTTours.Add(cttour);
db.SaveChanges();
}
}
public static void Insert(Nguoi nguoi)
{
using (var db = new tourEntities())
{
db.Nguois.Add(nguoi);
db.SaveChanges();
}
}
public static void Update(CTTour cttour)
{
using (var db = new tourEntities())
{
db.Entry(cttour).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void Update(DoanDL doanDL)
{
using (var db = new tourEntities())
{
db.Entry <DoanDL>(doanDL).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void Delete(DoanDL doanDL)
{
using (var db = new tourEntities())
{
db.Entry(doanDL).State = EntityState.Deleted;
db.SaveChanges();
}
}
public static void Insert(CTDoan ctDoan)
{
using (var db = new tourEntities())
{
db.CTDoans.Add(ctDoan);
db.SaveChanges();
}
}
public static void Insert(DiaDiem diadiem)
{
using (var db = new tourEntities())
{
db.DiaDiems.Add(diadiem);
db.SaveChanges();
}
}
public static void Update(LoaiCP loaiCP)
{
using (var db = new tourEntities())
{
db.Entry(loaiCP).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void Insert(LoaiCP loaiCP)
{
using (var db = new tourEntities())
{
db.LoaiCPs.Add(loaiCP);
db.SaveChanges();
}
}
public static void Insert(ChiPhi chiPhi)
{
using (var db = new tourEntities())
{
db.ChiPhis.Add(chiPhi);
db.SaveChanges();
}
}
public static void Delete(DiaDiem diadiem)
{
using (var db = new tourEntities())
{
db.Entry(diadiem).State = EntityState.Deleted;
db.SaveChanges();
}
}
public static void Update(Nguoi nguoi)
{
using (var db = new tourEntities())
{
db.Entry(nguoi).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void Insert(DoanDL doanDL)
{
using (var db = new tourEntities())
{
db.DoanDLs.Add(doanDL);
db.SaveChanges();
}
}
public static void Delete(CTTour cttour)
{
using (var db = new tourEntities())
{
var result = (from c in db.CTTours where c.MaDiaDiem == cttour.MaDiaDiem && c.MaTour == cttour.MaTour select c).First();
db.CTTours.Remove(result);
db.SaveChanges();
}
}
public static void Delete(LoaiCP loaiCP)
{
using (var db = new tourEntities())
{
var result = (from c in db.LoaiCPs where c.Id == loaiCP.Id select c).First();
db.LoaiCPs.Remove(result);
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 void Delete(CTDoan ctDoan)
{
using (var db = new tourEntities())
{
var result = (from c in db.CTDoans where c.MaDoan == ctDoan.MaDoan && c.MaNguoiThamGia == ctDoan.MaNguoiThamGia select c).First();
db.CTDoans.Remove(result);
db.SaveChanges();
}
}
