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 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 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 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 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 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 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(); } }
public void SuaLNV(string ma, string ten) { using (GalaxyMobileEntities dbs = new GalaxyMobileEntities()) { //dbs.spUpdateLNV(ma, ten); LoaiNV l = new LoaiNV(); l.MaLoaiNV = ma; l.TenLoaiNV = ten; dbs.LoaiNVs.Attach(l); dbs.Entry(l).State = System.Data.Entity.EntityState.Modified; dbs.SaveChanges(); } }
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(); } }
private async void btnLuuKieuSP_Click(object sender, EventArgs e) { using (GalaxyMobileEntities db = new GalaxyMobileEntities()) { ChiTietSP sp = new ChiTietSP(); try { // sp.Anh = CovertImageToBinary(picBoxKieuSP.Image); sp.Anh = CovertImageToBinary(picBoxKieuSP.BackgroundImage); } catch { } sp.Gia = 0; sp.SoluongSP = 0; sp.MaKieu = textBoxMaKieu.Text; sp.MaSP = /*textBoxMaSP.Text;*/ cmBoxMaSP.SelectedValue.ToString(); sp.MaMau = cmBoxMauSP.SelectedValue.ToString(); try { if (NewCTSP) { db.ChiTietSPs.Add(sp); db.SaveChanges(); // await db.SaveChangesAsync(); MessageBox.Show("Thêm Thành Công!", "Thông Báo"); ChiTietSPBUS.Them_CTSPMoi_Into_KhoHang_(sp.MaKieu); } else { try { // sp.Anh = CovertImageToBinary(picBoxKieuSP.Image); sp.Anh = CovertImageToBinary(picBoxKieuSP.BackgroundImage); } catch { sp.Anh = ChiTietSPBUS.LayAnhKieuSP(cmBoxMaKieuSP.SelectedValue.ToString(), cmBoxMaSP.SelectedValue.ToString()); } int r = dgvCTSP.CurrentCell.RowIndex; //sp.Gia = Convert.ToDecimal(dgvCTSP.Rows[r].Cells[3].Value.ToString()); sp.Gia = Convert.ToDecimal(txtBoxGiaSP.Text); sp.SoluongSP = Convert.ToInt32(txtboxSoLuongAll.Text); db.ChiTietSPs.Attach(sp); db.Entry(sp).State = System.Data.Entity.EntityState.Modified; await db.SaveChangesAsync(); MessageBox.Show("Thay Đổi Thành Công!", "Thông Báo"); string id = cmBoxMaSP.SelectedValue.ToString(); chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id); } } catch { MessageBox.Show("Không Thể Thực Hiện Thao Tác!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } btnLuuKieuSP.Visible = false; btnHuyKieuSP.Visible = false; btnThemKieuSP.Visible = true; btnChinhSuaKieuSP.Visible = true; btnXoaKieuSP.Visible = true; textBoxMaKieu.ReadOnly = false; textBoxMaSP.ReadOnly = false; textBoxMaKieu.Visible = false; textBoxMaSP.Visible = false; txtBoxGiaSP.ReadOnly = true; textBoxMau.Visible = false; dgvCTSP.Enabled = true; }