public void LapTheDocGia(TheDocGia TheDocGia) { Data.LapPhieu Temp = new Data.LapPhieu(); Data.DocGia Temp2 = new Data.DocGia(); Temp.IdNguoiLap = TheDocGia.IdNguoiLap; Temp.MaPhieu = TheDocGia.MaVe; Temp2.IdDocGia = TheDocGia.IdDocGia; Temp2.TenDocGia = TheDocGia.HoTen; Temp2.NgaySinh = TheDocGia.NgaySinh; Temp2.CMND = TheDocGia.CMND; Temp2.GioiTinh = TheDocGia.GioiTinh; Temp2.DiaChi = TheDocGia.DiaChi; Temp2.SDT = TheDocGia.Phone; Temp2.Email = TheDocGia.Mail; Temp2.LoaiDocGia = TheDocGia.LoaiDocGia; Temp2.NgayLap = TheDocGia.NgayLapThe; Temp2.MaPhieu = TheDocGia.MaVe; KetNoi = new Data.QuanLyThuVienDataContext(); KetNoi.LapPhieus.InsertOnSubmit(Temp); KetNoi.DocGias.InsertOnSubmit(Temp2); KetNoi.SubmitChanges(); }
public void XoaTheDocGia(int IdDocGia) { KetNoi = new Data.QuanLyThuVienDataContext(); Data.DocGia Temp2 = new Data.DocGia(); Data.LapPhieu Temp1 = new Data.LapPhieu(); Temp2 = KetNoi.DocGias.Where(s => s.IdDocGia == IdDocGia).Single(); Temp1 = KetNoi.LapPhieus.Where(s => s.MaPhieu == IdDocGia.ToString()).Single(); KetNoi.DocGias.DeleteOnSubmit(Temp2); KetNoi.LapPhieus.DeleteOnSubmit(Temp1); KetNoi.SubmitChanges(); }
// public void SuaTheDocGia(TheDocGia TheDocGia, int IdDocGia) { KetNoi = new Data.QuanLyThuVienDataContext(); Data.DocGia Temp2 = new Data.DocGia(); Temp2 = KetNoi.DocGias.Where(s => s.IdDocGia == IdDocGia).Single(); Temp2.TenDocGia = TheDocGia.HoTen; Temp2.NgaySinh = TheDocGia.NgaySinh; Temp2.CMND = TheDocGia.CMND; Temp2.GioiTinh = TheDocGia.GioiTinh; Temp2.DiaChi = TheDocGia.DiaChi; Temp2.SDT = TheDocGia.Phone; Temp2.Email = TheDocGia.Mail; Temp2.LoaiDocGia = TheDocGia.LoaiDocGia; KetNoi.SubmitChanges(); }