public void update(DTO_PhieuBaoHanh obj) { using (CellphoneComponentEntities db = new CellphoneComponentEntities()) { var resultMaNhanVien = db.Database .SqlQuery <String>("select MaNhanVien from dbo.NhanVien where TenNhanVien = N'" + obj.TenNhanVien + "'") .FirstOrDefault(); var resultMaHangHoa = db.Database .SqlQuery <String>("select MaHangHoa from dbo.HangHoa where TenHangHoa = N'" + obj.TenHangHoa + "'") .FirstOrDefault(); PhieuBaoHanh item = new PhieuBaoHanh(); item.MaPhieuBaoHanh = obj.MaPhieuBaoHanh; item.NgayLap = obj.NgayLap; item.NgayGiao = obj.NgayGiao; item.MaNhanVien = resultMaNhanVien; item.TenKhachHang = obj.TenKhachHang; item.SoDienThoai = obj.SoDienThoai; item.TongTien = obj.TongTien; item.GhiChu = obj.GhiChu; item.DaGiao = obj.DaGiao; item.NgayChinhSua = obj.NgayChinhSua; item.MaHangHoa = resultMaHangHoa; db.PhieuBaoHanhs.Attach(item); db.Entry(item).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void delete(String id) { using (CellphoneComponentEntities db = new CellphoneComponentEntities()) { PhieuBaoHanh pbh = (from item in db.PhieuBaoHanhs where item.MaPhieuBaoHanh == id select item).SingleOrDefault(); db.PhieuBaoHanhs.Remove(pbh); db.SaveChanges(); } }
public void XoaPhieuBaoHanh(PhieuBaoHanh ex) { KetNoi.ExecuteReader(@"Update PhieuBaoHanh Set TrangThai=N'0' Where MaPBH=N'" + ex.MaPBH + "'"); }
public void Update_PBH(PhieuBaoHanh ex) { KetNoi.ExecuteReader(@"update PhieuBaoHanh Set Where MaPBH=N'" + ex.MaPBH + "'"); }
public void ThemPBH(PhieuBaoHanh ex) { KetNoi.ExecuteReader(@"Insert Into PhieuBaoHanh Values(N'" + ex.MaPBH + "',N'" + ex.MaKH + "',N'" + ex.MaNV + "','" + ex.NgayLap + "','" + ex.NgayLayHang + "',N'" + ex.TrangThai + "')"); }