public void ChinhSua(HSX hsx)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.HSXes.Attach(hsx);
dbs.SaveChanges();
dbs.Entry(hsx).State = System.Data.Entity.EntityState.Modified;
dbs.SaveChanges();
}
}
public void ThemMau(MauSP obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.MauSPs.Add(obj);
db.SaveChanges();
}
}
public void ThemSP(SanPham obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.SanPhams.Add(obj);
db.SaveChanges();
}
}
public void ThemTK(TaiKhoan obj)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.TaiKhoans.Add(obj);
dbs.SaveChanges();
}
}
public void ThemSPintoCTNH(ChiTietHDNhapHang obj)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.ChiTietHDNhapHangs.Add(obj);
dbs.SaveChanges();
}
}
public void ThemHSX(HSX hsx)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.HSXes.Add(hsx);
dbs.SaveChanges();
}
}
public void ThemCH(CuaHang ch)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.CuaHangs.Add(ch);
db.SaveChanges();
}
}
public void ThemHoaDon(HoaDon hd)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.HoaDons.Add(hd);
dbs.SaveChanges();
}
}
public void ThemHSX(HSX obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.HSXes.Add(obj);
db.SaveChanges();
}
}
public void ThemHDNhap(HoaDonNhapHang obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.HoaDonNhapHangs.Add(obj);
db.SaveChanges();
}
}
public void ThemGiaoHang(GiaoHang gh)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.GiaoHangs.Add(gh);
dbs.SaveChanges();
}
}
public void ThemChiTietHoaDon(ChiTietHoaDon ct)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.ChiTietHoaDons.Add(ct);
dbs.SaveChanges();
}
}
public void XoaHoaDon(HoaDon hd)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.HoaDons.Attach(hd);
dbs.HoaDons.Remove(hd);
dbs.SaveChanges();
}
}
public void SuaCH(CuaHang ch)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.CuaHangs.Attach(ch);
db.Entry(ch).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void XoaCH(CuaHang ch)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.CuaHangs.Attach(ch);
db.CuaHangs.Remove(ch);
db.SaveChanges();
}
}
public void ThayDoiMK(TaiKhoan obj)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.TaiKhoans.Attach(obj);
dbs.Entry(obj).State = System.Data.Entity.EntityState.Modified;
dbs.SaveChanges();
}
}
public void XoaHDNhap(HoaDonNhapHang obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.HoaDonNhapHangs.Attach(obj);
db.HoaDonNhapHangs.Remove(obj);
db.SaveChanges();
}
}
public void XoaHSX(HSX obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.HSXes.Attach(obj);
db.HSXes.Remove(obj);
db.SaveChanges();
}
}
public void ThayDoiSLNhap(ChiTietHDNhapHang obj)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.ChiTietHDNhapHangs.Attach(obj);
dbs.Entry(obj).State = System.Data.Entity.EntityState.Modified;
dbs.SaveChanges();
}
}
public void XaoMau(MauSP obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.MauSPs.Attach(obj);
db.MauSPs.Remove(obj);
db.SaveChanges();
}
}
public void ChinhSuaSP(SanPham obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.SanPhams.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void XoaSP(SanPham obj)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.SanPhams.Attach(obj);
db.SanPhams.Remove(obj);
db.SaveChanges();
}
}
public void XoaHSX(HSX hsx)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.HSXes.Attach(hsx);
dbs.HSXes.Remove(hsx);
dbs.SaveChanges();
}
}
public void DaGiaoHangGiaoHang(GiaoHang gh)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
dbs.GiaoHangs.Attach(gh);
dbs.Entry(gh).State = System.Data.Entity.EntityState.Modified;
dbs.SaveChanges();
}
}
public void XoaTK(string User)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var obj = dbs.TaiKhoans.SingleOrDefault(p => p.UserName == User);
dbs.TaiKhoans.Attach(obj);
dbs.TaiKhoans.Remove(obj);
dbs.SaveChanges();
}
}
public void XoaSPfromCTNH(string idhd, string idsp)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var ct = dbs.ChiTietHDNhapHangs.Where(p => p.MaHoaDonNH == idhd && p.MaKieu == idsp).SingleOrDefault();
dbs.ChiTietHDNhapHangs.Attach(ct);
dbs.ChiTietHDNhapHangs.Remove(ct);
dbs.SaveChanges();
}
}
public void XoaChiTietHoaDon(string idhd, string idch, string id)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var ct = dbs.ChiTietHoaDons.Where(p => p.MaCuaHang == idch && p.MaHoaDon == idhd && p.MaKieu == id).SingleOrDefault();
dbs.ChiTietHoaDons.Attach(ct);
dbs.ChiTietHoaDons.Remove(ct);
dbs.SaveChanges();
}
}
public void HuyGiaoHang(string mahd, string mach)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var gh = dbs.GiaoHangs.Where(p => p.MaCuaHang == mach && p.MaHoaDon == mahd).SingleOrDefault();
dbs.GiaoHangs.Attach(gh);
dbs.GiaoHangs.Remove(gh);
dbs.SaveChanges();
}
}
public void XoaLNV(string ma)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var l = dbs.LoaiNVs.Where(p => p.MaLoaiNV == ma).SingleOrDefault();
dbs.LoaiNVs.Attach(l);
dbs.LoaiNVs.Remove(l);
dbs.SaveChanges();
// dbs.spDelLNV(ma);
}
}
public void DaThanhToan(string idhd, string idch)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var hd = dbs.HoaDons.Where(p => p.MaHoaDon == idhd && p.MaCuaHang == idch).SingleOrDefault();
dbs.HoaDons.Attach(hd);
hd.TinhTrang = 1;
dbs.Entry(hd).State = System.Data.Entity.EntityState.Modified;
dbs.SaveChanges();
}
}
