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;
}
