public void Them_SLCTSP_Into_KhoHang_(string idMa, string ch, int sl)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
db.USP_ThemSL_KhoHangByMaKieuByMaCH(idMa, ch, sl);
}
}
public void ThemSL_SP_Kho_ByCuaHangBy_MaKieu(string idhdnhap, string idch)
{
using (GalaxyMobileEntities db = new GalaxyMobileEntities())
{
List <ChiTietHDNhapHang> hdn = db.ChiTietHDNhapHangs.Where(p => p.MaHoaDonNH == idhdnhap).ToList();
foreach (ChiTietHDNhapHang ct in hdn)
{
db.USP_ThemSL_KhoHangByMaKieuByMaCH(ct.MaKieu, idch, ct.SoLuongNhap);
}
}
}
public void TraHangHoaDon(string idhd, string idch)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var ct = dbs.ChiTietHoaDons.Where(p => p.MaHoaDon == idhd && p.MaCuaHang == idch).ToList();
foreach (ChiTietHoaDon c in ct)
{
dbs.USP_ThayDoiSoLuongChiTietSP(c.MaKieu, c.SoluongSP);
dbs.USP_ThemSL_KhoHangByMaKieuByMaCH(c.MaKieu, idch, c.SoluongSP);
}
}
}
public void ThanhToanHoaDon(string idhd, string idch)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
var ct = dbs.ChiTietHoaDons.Where(p => p.MaHoaDon == idhd && p.MaCuaHang == idch).ToList();
foreach (ChiTietHoaDon c in ct)
{
dbs.USP_ThayDoiSoLuongChiTietSP(c.MaKieu, -c.SoluongSP);
dbs.USP_ThemSL_KhoHangByMaKieuByMaCH(c.MaKieu, idch, -c.SoluongSP);
}
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();
}
}
