Ejemplo n.º 1
0
        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();
        }
Ejemplo n.º 2
0
        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();
        }