public bool SaveOrUpdate(DTO_ChiTietPhieuBanHang obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
ChiTietPhieuBanHang chiTietPhieuBanHang = new ChiTietPhieuBanHang();
chiTietPhieuBanHang.MaChiTietPhieuBan = obj.MaChiTietPhieuBan;
chiTietPhieuBanHang.MaPhieuBanHang = obj.MaPhieuBanHang;
chiTietPhieuBanHang.MaHangHoa = obj.MaHangHoa;
chiTietPhieuBanHang.SoLuong = obj.SoLuong;
chiTietPhieuBanHang.Gia = obj.Gia;
chiTietPhieuBanHang.ThanhTien = obj.ThanhTien;
if (db.ChiTietPhieuBanHangs.Any(e => e.MaChiTietPhieuBan == chiTietPhieuBanHang.MaChiTietPhieuBan))
{
db.ChiTietPhieuBanHangs.Attach(chiTietPhieuBanHang);
db.Entry(chiTietPhieuBanHang).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
db.ChiTietPhieuBanHangs.Add(chiTietPhieuBanHang);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
}
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 bool update(DTO_HangHoa obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
var resultMaLoaiHangHoa = db.Database
.SqlQuery <String>("select MaLoaiHangHoa from dbo.LoaiHangHoa where TenLoaiHangHoa = N'" + obj.TenLoaiHangHoa + "'")
.FirstOrDefault();
HangHoa hanghoa = new HangHoa();
hanghoa.MaHangHoa = obj.MaHangHoa;
hanghoa.TenHangHoa = obj.TenHangHoa;
hanghoa.GiaBan = obj.GiaBan;
hanghoa.GiamGia = obj.GiamGia;
hanghoa.SoLuongTon = obj.SoLuongTon;
hanghoa.DonViTinh = obj.DonViTinh;
hanghoa.MoTa = obj.MoTa;
hanghoa.ThongSoKyThuat = obj.ThongSoKyThuat;
hanghoa.XuatXu = obj.XuatXu;
hanghoa.ThoiGianBaoHang = obj.ThoiGianBaoHang;
hanghoa.HinhAnh = obj.HinhAnh;
hanghoa.MaLoaiHangHoa = resultMaLoaiHangHoa;
hanghoa.TrangThai = obj.TrangThai;
hanghoa.TenModel = obj.TenModel;
db.HangHoas.Attach(hanghoa);
db.Entry(hanghoa).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
}
public bool update(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.Attach(phieuDatHang);
db.Entry(phieuDatHang).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
}
public void UpdateNCC(DTO_NhaCungCap obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
this.MaNhaCungCap = obj.MaNhaCungCap;
this.TenNhaCungCap = obj.TenNhaCungCap;
this.Email = obj.Email;
this.DiaChi = obj.DiaChi;
this.SoDienThoai = obj.SoDienThoai;
db.NhaCungCaps.Attach(this);
db.Entry(this).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public bool update(DTO_LoaiHangHoa obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
LoaiHangHoa loaiHangHoa = new LoaiHangHoa();
loaiHangHoa.MaLoaiHangHoa = obj.MaLoaiHangHoa;
loaiHangHoa.TenLoaiHangHoa = obj.TenLoaiHangHoa;
loaiHangHoa.PhanTramLoiNhuan = obj.PhanTramLoiNhuan;
db.LoaiHangHoas.Attach(loaiHangHoa);
db.Entry(loaiHangHoa).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
}
public void UpdateNV(DTO_NhanVien obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
var result = db.Database
.SqlQuery <String>("select MaPhanQuyen from dbo.PhanQuyen where TenPhanQuyen = N'" + obj.TenPhanQuyen + "'")
.FirstOrDefault();
NhanVien nhanVien = new NhanVien();
nhanVien.MaNhanVien = obj.MaNhanVien;
nhanVien.TenNhanVien = obj.TenNhanVien;
nhanVien.UserName = obj.UserName;
nhanVien.Password = obj.Password;
nhanVien.MaPhanQuyen = result;
nhanVien.TrangThai = obj.TrangThai;
db.NhanViens.Attach(nhanVien);
db.Entry(nhanVien).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void update(DTO_ChiTietPhieuNhap obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
var resultMaHangHoa = db.Database
.SqlQuery <String>("select MaHangHoa from dbo.HangHoa where TenHangHoa = N'" + obj.TenHangHoa + "'")
.FirstOrDefault();
ChiTietPhieuNhap ctpn = new ChiTietPhieuNhap();
ctpn.MaChiTietPhieuNhap = obj.MaChiTietPhieuNhap;
ctpn.MaHangHoa = resultMaHangHoa;
ctpn.MaPhieuNhap = obj.MaPhieuNhap;
ctpn.SoLuong = obj.SoLuong;
ctpn.GiaNhap = obj.GiaNhap;
ctpn.ThanhTien = obj.ThanhTien;
db.ChiTietPhieuNhaps.Attach(ctpn);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void UpdatePC(DTO_PhieuChi obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
var result = db.Database
.SqlQuery <String>("select MaNhanVien from dbo.NhanVien where TenNhanVien = N'" + obj.TenNhanVien + "'")
.FirstOrDefault();
PhieuChi phieuChi = new PhieuChi();
phieuChi.MaPhieuChi = obj.MaPhieuChi;
phieuChi.NgayChi = obj.NgayChi;
phieuChi.NgayChinhSua = obj.NgayChinhSua;
phieuChi.MaPhieuNhap = obj.MaPhieuNhap;
phieuChi.GhiChu = obj.GhiChu;
phieuChi.TongTienChi = obj.TongTienChi;
phieuChi.MaNhanVien = result;
db.PhieuChis.Attach(phieuChi);
db.Entry(phieuChi).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public bool update(DTO_ChiTietPhieuDatHang obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
var resultMaHangHoa = db.Database
.SqlQuery <String>("select MaHangHoa from dbo.HangHoa where TenHangHoa = N'" + obj.TenHangHoa + "'")
.FirstOrDefault();
ChiTietPhieuDatHang chiTietPhieuDatHang = new ChiTietPhieuDatHang();
chiTietPhieuDatHang.MaChiTietPhieuDat = obj.MaChiTietPhieuDat;
chiTietPhieuDatHang.MaHangHoa = resultMaHangHoa;
chiTietPhieuDatHang.MaPhieuDatHang = obj.MaPhieuDatHang;
chiTietPhieuDatHang.SoLuong = obj.SoLuong;
chiTietPhieuDatHang.Gia = obj.Gia;
chiTietPhieuDatHang.ThanhTien = obj.ThanhTien;
db.ChiTietPhieuDatHangs.Attach(chiTietPhieuDatHang);
db.Entry(chiTietPhieuDatHang).State = System.Data.Entity.EntityState.Modified;
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
}
public void update(DTO_PhieuNhap 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();
PhieuNhap phieuNhap = new PhieuNhap();
phieuNhap.MaPhieuNhap = obj.MaPhieuNhap;
phieuNhap.MaNhaCungCap = resultMaNhaCungCap;
phieuNhap.MaNhanVien = resultMaNhanVien;
phieuNhap.NgayChinhSua = obj.NgayChinhSua;
phieuNhap.NgayNhap = obj.NgayNhap;
phieuNhap.TongTien = obj.TongTien;
phieuNhap.GhiChu = obj.GhiChu;
db.PhieuNhaps.Attach(phieuNhap);
db.Entry(phieuNhap).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
