Example #1
0
        public bool insert(DTO_PhieuDatHang obj)
        {
            using (CellphoneComponentEntities db = new CellphoneComponentEntities())
            {
                var resultMaNhanVien = db.Database
                                       .SqlQuery <String>("select MaNhanVien from dbo.NhanVien where TenNhanVien = N'" + obj.TenNhanVien + "'")
                                       .FirstOrDefault();
                var resultMaNhaCungCap = db.Database
                                         .SqlQuery <String>("select MaNhaCungCap from dbo.NhaCungCap where TenNhaCungCap = N'" + obj.TenNhaCungCap + "'")
                                         .FirstOrDefault();
                PhieuDatHang phieuDatHang = new PhieuDatHang();
                phieuDatHang.MaPhieuDatHang = obj.MaPhieuDatHang;
                phieuDatHang.MaNhaCungCap   = resultMaNhaCungCap;
                phieuDatHang.MaNhanVien     = resultMaNhanVien;
                phieuDatHang.NgayChinhSua   = obj.NgayChinhSua;
                phieuDatHang.NgayDat        = obj.NgayDat;
                phieuDatHang.TongTien       = obj.TongTien;
                phieuDatHang.GhiChu         = obj.GhiChu;

                db.PhieuDatHangs.Add(phieuDatHang);

                if (db.SaveChanges() > 0)
                {
                    return(true);
                }
                return(false);
            }
        }
Example #2
0
        public bool delete(String id)
        {
            using (CellphoneComponentEntities db = new CellphoneComponentEntities())
            {
                PhieuDatHang phieuDatHang = (from item in db.PhieuDatHangs
                                             where item.MaPhieuDatHang == id
                                             select item).SingleOrDefault();
                db.PhieuDatHangs.Remove(phieuDatHang);

                if (db.SaveChanges() > 0)
                {
                    return(true);
                }
                return(false);
            }
        }