private void btnLuu_Click(object sender, EventArgs e)
{
if (comboBoxCHNhan.SelectedValue.ToString() == comboBoxCHPP.SelectedValue.ToString())
{
MessageBox.Show("Lỗi! Hai Cửa Hàng Trùng Nhau.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (numericUpDownThemBotSL.Value <= Convert.ToInt32(textBoxSLTonCHPP.Text) && numericUpDownThemBotSL.Value > 0)
{
string id1 = comboBoxCHNhan.SelectedValue.ToString();
string id2 = comboBoxCHPP.SelectedValue.ToString();
string id = textBoxMaKieu.Text;
KhoHangBUS.KiemTraKho_CuaHang_MaKieu(id, id1);
KhoHangBUS.KiemTraKho_CuaHang_MaKieu(id, id2);
int sl = Convert.ToInt32(numericUpDownThemBotSL.Value);
try{
ChiTietSPBUS.PhanChiSP(id, id1, id2, sl);
MessageBox.Show("Thành Công! Sản Phẩm Đã Được Phân Phối.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(id);
}
catch
{
MessageBox.Show("Lỗi! Không Thể Thực Hiện Thao Tác.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Lỗi! Số Lượng Phân Phối Không Phù Hợp.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnThemSPMua_Click(object sender, EventArgs e)
{
IsAdd = true;
textBoxNSX.Visible = false;
textBoxLoaiSP.Visible = false;
textBoxDSP.Visible = false;
textBoxMauKieu.Visible = false;
textBoxMaKieuSP.Visible = false;
textBoxSP.Visible = false;
numericSL.Value = 1;
numericSL.Minimum = 0;
textboxGiaBan.Text = "";
textBoxSLTon.Text = "";
textBoxSLMua.Text = "";
textBoxTenSP.Text = "";
comboBoxMaKieu.DataSource = null;
comboBoxSP.DataSource = null;
comboBoxNSX.DataSource = HSXBUS.GetAllHSX();
comboBoxNSX.ValueMember = "MaHSX";
comboBoxNSX.DisplayMember = "TenHSX";
comboBoxMau.DataSource = ChiTietSPBUS.GetAllMauSP();
comboBoxMau.DisplayMember = "Mau";
comboBoxMau.ValueMember = "MaMau";
comboBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP();
comboBoxLoaiSP.DisplayMember = "TenLSP";
comboBoxLoaiSP.ValueMember = "MaLSP";
}
private void dgvHoaDon_CellClick(object sender, DataGridViewCellEventArgs e)
{
textBoxNSX.Visible = true;
textBoxLoaiSP.Visible = true;
textBoxDSP.Visible = true;
textBoxMauKieu.Visible = true;
textBoxMaKieuSP.Visible = true;
textBoxSP.Visible = true;
int r = dgvHoaDon.CurrentCell.RowIndex;
string id = dgvHoaDon.Rows[r].Cells[1].Value.ToString();
USP_GETAllInfoSPNew_Result sp = ChiTietSPBUS.GetMaSPByMaKieuSP(id);
textBoxNSX.Text = sp.TenHSX;
textBoxLoaiSP.Text = sp.TenLSP;
textBoxDSP.Text = sp.TenDong;
textboxGiaBan.Text = dgvHoaDon.Rows[r].Cells[3].Value.ToString();
textBoxSLTon.Text = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDKieuSP(textBoxMaCH.Text, id).SoluongSP.ToString();
textBoxMaKieuSP.Text = sp.MaKieu;
textBoxTenSP.Text = sp.TenSP;
textBoxSLMua.Text = dgvHoaDon.Rows[r].Cells[2].Value.ToString();
ChiTietSP ct = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id);
textBoxSP.Text = ct.MaSP.ToString();
textBoxMauKieu.Text = ct.MaMau.ToString();
try
{
pictureBox.BackgroundImage = ConverBinaryToImage(ct.Anh);
}
catch
{ pictureBox.BackgroundImage = null; }
}
private void btnHuyKieuSP_Click(object sender, EventArgs e)
{
dgvCTSP.Enabled = true;
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;
cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP();
cmBoxMauSP.ValueMember = "MaMau";
cmBoxMauSP.DisplayMember = "Mau";
textBoxMau.Visible = false;
int r = dgvCTSP.CurrentCell.RowIndex;
textBoxMaKieu.Text = dgvCTSP.Rows[r].Cells[1].Value.ToString();
cmBoxMaKieuSP.SelectedValue = dgvCTSP.Rows[r].Cells[1].Value.ToString();
textBoxMaSP.Text = dgvCTSP.Rows[r].Cells[0].Value.ToString();
cmBoxMaSP.SelectedValue = dgvCTSP.Rows[r].Cells[0].Value.ToString();
txtBoxGiaSP.Text = dgvCTSP.Rows[r].Cells[3].Value.ToString();
txtboxSoLuongAll.Text = dgvCTSP.Rows[r].Cells[4].Value.ToString();
cmBoxMauSP.SelectedValue = dgvCTSP.Rows[r].Cells[2].Value.ToString();
}
private void comboBoxMaKieu_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string id = comboBoxMaKieu.SelectedValue.ToString();
ChiTietSP ct = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDKieuSP(textBoxMaCH.Text, id);
if (ct != null)
{
textBoxSLTon.Text = ct.SoluongSP.ToString();
textboxGiaBan.Text = ct.Gia.ToString();
comboBoxMau.SelectedValue = ct.MaMau;
try
{
pictureBox.BackgroundImage = ConverBinaryToImage(ct.Anh);
}
catch
{
pictureBox.BackgroundImage = null;
}
}
else
{
textBoxSLTon.Text = "";
textboxGiaBan.Text = "";
}
}
catch
{
textBoxSLTon.Text = "";
textboxGiaBan.Text = "";
}
}
private void dgvNhapHang_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
txtboxHSX.Visible = true;
txtBoxLSP.Visible = true;
txtBoxDSP.Visible = true;
txtboxGiaBan.Visible = true;
txtBoxKieuSP.Visible = true;
txtboxSP.Visible = true;
txtboxGiaBan.ReadOnly = true;
txtboxGiaNhap.ReadOnly = true;
txtboxGiaBan.Visible = true;
int r = dgvNhapHang.CurrentCell.RowIndex;
string id = dgvNhapHang.Rows[r].Cells[0].Value.ToString();
USP_GETAllInfoSPNew_Result sp = ChiTietSPBUS.GetMaSPByMaKieuSP(id);
txtboxHSX.Text = sp.TenHSX;
txtBoxLSP.Text = sp.TenLSP;
txtBoxDSP.Text = sp.TenDong;
txtboxGiaBan.Text = sp.Gia.ToString();
txtBoxSLTon.Text = sp.SoluongSP.ToString();
txtBoxKieuSP.Text = sp.MaKieu;
txtboxSP.Text = sp.TenSP;
txtboxGiaNhap.Text = dgvNhapHang.Rows[r].Cells[2].Value.ToString();
textBoxSLNhap.Text = dgvNhapHang.Rows[r].Cells[1].Value.ToString();
}
catch { }
}
void LoadSP()
{
try
{
Sp = ChiTietSPBUS.GetMaSPByIDKieuSP(IDMaKieu);
CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(IDMaKieu);
DSp = DongSanPhamBUS.Get1DongSPByMaSP(Sp.MaDSP);
}
catch { }
}
private void linklbChiTietSP_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (txtboxMaKieuSP.Text == "")
{
return;
}
frmChiTietSanPham ctsp = new frmChiTietSanPham(ChiTietSPBUS.GetMaSPByIDKieuSP(txtboxMaKieuSP.Text).MaSP, User.MaCuaHang, null, false);
ctsp.ShowDialog();
}
private void comboBoxSP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
comboBoxMaKieu.DataSource = null;
string id = comboBoxSP.SelectedValue.ToString();
comboBoxMaKieu.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id);
comboBoxMaKieu.DisplayMember = "MaKieu";
comboBoxMaKieu.ValueMember = "MaKieu";
}
catch { }
}
private void btnXoaKieuSP_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn xóa dòng này không?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
try
{
ChiTietSPBUS.XoaKieuSp(cmBoxMaKieuSP.SelectedValue.ToString());
MessageBox.Show("Xóa 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); }
}
}
private void comboBoxCHPP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
textBoxSLTonCHPP.Text = "";
string id = comboBoxCHPP.SelectedValue.ToString();
ChiTietSP ct = new ChiTietSP();
if (textBoxMaKieu.Text.Trim(' ') != "")
{
ct = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDKieuSP(id, textBoxMaKieu.Text);
}
else
{
ct = null;
}
textBoxSLTonCHPP.Text = ct.SoluongSP.ToString();
}
catch { }
}
private void cmBoxMaKieuSP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string id = cmBoxMaKieuSP.SelectedValue.ToString();
//ChiTietSP sp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id);
if (IDMode == "ts")
{
ChiTietSP sp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id);
cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP();
cmBoxMauSP.ValueMember = "MaMau";
cmBoxMauSP.DisplayMember = "Mau";
cmBoxMauSP.SelectedValue = sp.MaMau;
txtBoxGiaSP.Text = sp.Gia.ToString();
txtboxSoLuongAll.Text = sp.SoluongSP.ToString();
//picBoxKieuSP.Image = null;
picBoxKieuSP.BackgroundImage = null;
textBoxPathAnh.Text = "";
//picBoxKieuSP.Image = ConverBinaryToImage(sp.Anh);
picBoxKieuSP.BackgroundImage = ConverBinaryToImage(sp.Anh);
}
else
{
ChiTietSP sp = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDKieuSP(IDMode, id);
cmBoxMauSP.SelectedValue = sp.MaMau;
txtBoxGiaSP.Text = sp.Gia.ToString();
txtboxSoLuongAll.Text = sp.SoluongSP.ToString();
//picBoxKieuSP.Image = null;
picBoxKieuSP.BackgroundImage = null;
textBoxPathAnh.Text = "";
//picBoxKieuSP.Image = ConverBinaryToImage(sp.Anh);
picBoxKieuSP.BackgroundImage = ConverBinaryToImage(sp.Anh);
}
//cmBoxMauSP.SelectedValue = sp.MaMau;
//txtBoxGiaSP.Text = sp.Gia.ToString();
//txtboxSoLuongAll.Text = sp.SoluongSP.ToString();
//picBoxKieuSP.Image = null;
//textBoxPathAnh.Text = "";
//picBoxKieuSP.Image = ConverBinaryToImage(sp.Anh);
}
catch { }
}
private void cmBoxSP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string id = cmBoxSP.SelectedValue.ToString();
if (ChiTietSPBUS.GetChiTietSPByIDSP(id).Count != 0)
{
cmBoxKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id);
cmBoxKieuSP.DisplayMember = "MaKieu";
cmBoxKieuSP.ValueMember = "MaKieu";
}
else
{
cmBoxKieuSP.DataSource = null;
}
}
catch { cmBoxKieuSP.DataSource = null; }
}
private void comboBoxSP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string id = comboBoxSP.SelectedValue.ToString();
textBoxTenSP.Text = SanPhamBUS.GetSanPhamByID(id).TenSP.ToString();
if (ChiTietSPBUS.GetChiTietSPByIDSP(id).Count != 0)
{
comboBoxMaKieu.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id);
comboBoxMaKieu.DisplayMember = "MaKieu";
comboBoxMaKieu.ValueMember = "MaKieu";
}
else
{
comboBoxMaKieu.DataSource = null;
}
}
catch { comboBoxMaKieu.DataSource = null; }
}
private void btnThemKieuSP_Click(object sender, EventArgs e)
{
NewCTSP = true;
dgvCTSP.Enabled = false;
cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP();
cmBoxMauSP.ValueMember = "MaMau";
cmBoxMauSP.DisplayMember = "Mau";
textBoxMaKieu.Visible = true;
textBoxMaKieu.Text = "";
textBoxMaSP.Visible = true;
txtBoxGiaSP.Text = "0";
txtboxSoLuongAll.Text = "0";
btnLuuKieuSP.Visible = true;
btnHuyKieuSP.Visible = true;
btnThemKieuSP.Visible = false;
btnChinhSuaKieuSP.Visible = false;
btnXoaKieuSP.Visible = false;
textBoxMaSP.Text = cmBoxMaSP.SelectedValue.ToString();
}
private void comboBoxMaKieu_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
textBoxSLTonKieu.Text = "";
pictureBox.BackgroundImage = null;
khoHangBindingSource.DataSource = null;
textBoxMaKieu.Text = "";
string id = comboBoxMaKieu.SelectedValue.ToString();
CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id);
textBoxMaKieu.Text = CtSp.MaKieu;
textBoxSLTonKieu.Text = CtSp.SoluongSP.ToString();
try
{
pictureBox.BackgroundImage = ConverBinaryToImage(CtSp.Anh);
}
catch { pictureBox.BackgroundImage = null; }
khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(CtSp.MaKieu);
}
catch { }
}
private void btnLuuHD_Click(object sender, EventArgs e)
{
HoaDon hd = new HoaDon();
hd.MaHoaDon = textBoxMaHD.Text;
hd.MaKH = comboBoxMaKH.SelectedValue.ToString();
hd.MaNV = textBoxMaNV.Text;
hd.MaCuaHang = textBoxMaCH.Text;
hd.NgayLapHD = dateTimePickerNgayVietHD.Value;
hd.TinhTrang = 0;
if (radioMuaTT.Checked)
{
hd.HTGiaoHang = "Trực Tiếp";
}
else
{
hd.HTGiaoHang = "Giao Hàng";
}
try
{
HoaDonBUS.ThemHoaDon(hd);
MessageBox.Show("Thêm Thành Công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
groupBox2.Enabled = true;
btnLuuTam.Visible = true;
btnThanhToan.Visible = true;
comboBoxNSX.DataSource = HSXBUS.GetAllHSX();
comboBoxNSX.ValueMember = "MaHSX";
comboBoxNSX.DisplayMember = "TenHSX";
comboBoxMau.DataSource = ChiTietSPBUS.GetAllMauSP();
comboBoxMau.DisplayMember = "Mau";
comboBoxMau.ValueMember = "MaMau";
comboBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP();
comboBoxLoaiSP.DisplayMember = "TenLSP";
comboBoxLoaiSP.ValueMember = "MaLSP";
}
catch
{
MessageBox.Show("Không Thể Thực Hiện Thao Tác!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmBoxMaSP_SelectedIndexChanged(object sender, EventArgs e)
{
string id = cmBoxMaSP.SelectedValue.ToString();
//cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id);
//cmBoxMaKieuSP.DisplayMember = "MaKieu";
//cmBoxMaKieuSP.ValueMember = "MaKieu";
//cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP();
//cmBoxMauSP.ValueMember = "MaMau";
//cmBoxMauSP.DisplayMember = "Mau";
if (IDMode == "ts")
{
chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id);
cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id);
cmBoxMaKieuSP.DisplayMember = "MaKieu";
cmBoxMaKieuSP.ValueMember = "MaKieu";
cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP();
cmBoxMauSP.ValueMember = "MaMau";
cmBoxMauSP.DisplayMember = "Mau";
}
else
{
chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode, id);
//cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode,id);
if (ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode, id).Count != 0)
{
cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode, id);
cmBoxMaKieuSP.DisplayMember = "MaKieu";
cmBoxMaKieuSP.ValueMember = "MaKieu";
}
else
{
cmBoxMaKieuSP.DataSource = null;
}
cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP();
cmBoxMauSP.ValueMember = "MaMau";
cmBoxMauSP.DisplayMember = "Mau";
}
}
private void cmBoxSP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (ID != null)
{
string id = cmBoxSP.SelectedValue.ToString();
SanPham sp = SanPhamBUS.GetSanPhamByID(id);
cmBoxMaSP.SelectedValue = id;
cmBoxSP.SelectedValue = id;
txtboxMaSP.Text = sp.MaSP;
txtTenSP.Text = sp.TenSP;
txtNamSX.Text = sp.NămSX;
txtboxCPU.Text = sp.CPU;
txtboxGPU.Text = sp.CardManHinh;
txtCamera.Text = sp.Camera;
txtPort.Text = sp.Port;
txtboxRam.Text = sp.Ram;
txtboxManHinh.Text = sp.ManHinh;
txtboxOS.Text = sp.OS;
txtboxSim.Text = sp.Sim;
txtboxPin.Text = sp.DungLuongPin;
txtBoxTrongLuong.Text = sp.TrongLuong;
txtboxBNngoai.Text = sp.BoNhoNgoai;
txtboxBNtrong.Text = sp.BoNhoTrong;
if (IDMode == "ts")
{
chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id);
}
else
{
chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode, id);
}
//chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(ID);
}
}
catch { }
}
private void btnThayDoiGia_Click(object sender, EventArgs e)
{
if (btnThayDoiGia.Text == "Đổi Giá")
{
btnThayDoiGia.Text = "Lưu";
txtboxGiaBan.ReadOnly = false;
}
else
{
if (btnThayDoiGia.Text == "Lưu")
{
try
{
btnThayDoiGia.Text = "Đổi Giá";
txtboxGiaBan.ReadOnly = true;
string id = cmBoxKieuSP.SelectedValue.ToString();
decimal gia = Convert.ToDecimal(txtboxGiaBan.Text);
ChiTietSPBUS.ThayDoiGiaChiTietSO(id, gia);
}
catch { }
}
}
}
public void LoadChiTietSP()
{
//try
//{
LoadSP();
//}
//catch
//{
//}
comboBoxCHNhan.DataSource = CuaHangBUS.GetAllCuaHang();
comboBoxCHNhan.DisplayMember = "TenCuaHang";
comboBoxCHNhan.ValueMember = "MaCuaHang";
comboBoxCHPP.DataSource = CuaHangBUS.GetAllCuaHang();
comboBoxCHPP.DisplayMember = "TenCuaHang";
comboBoxCHPP.ValueMember = "MaCuaHang";
comboBoxNXS.DataSource = HSXBUS.GetAllHSX();
comboBoxNXS.DisplayMember = "TenHSX";
comboBoxNXS.ValueMember = "MaHSX";
comboBoxNXS.SelectedValue = DSp.MaHSX;
comboBoxDSP.DataSource = DongSanPhamBUS.GetAllDongSPByMaHSX(DSp.MaHSX);
comboBoxDSP.DisplayMember = "TenDong";
comboBoxDSP.ValueMember = "MaDSP";
comboBoxDSP.SelectedValue = DSp.MaDSP;
comboBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(DSp.MaDSP);
comboBoxSP.DisplayMember = "TenSP";
comboBoxSP.ValueMember = "MaSP";
comboBoxSP.SelectedValue = Sp.MaSP;
comboBoxMaKieu.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(Sp.MaSP);
comboBoxMaKieu.DisplayMember = "MaKieu";
comboBoxMaKieu.ValueMember = "MaKieu";
CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(IDMaKieu);
comboBoxMaKieu.SelectedValue = CtSp.MaKieu;
textBoxSLTonKieu.Text = CtSp.SoluongSP.ToString();
pictureBox.BackgroundImage = ConverBinaryToImage(CtSp.Anh);
khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(CtSp.MaKieu);
}
private void cmBoxKieuSP_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string id = cmBoxKieuSP.SelectedValue.ToString();
ChiTietSP ct = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id);
if (ct != null)
{
txtBoxSLTon.Text = ct.SoluongSP.ToString();
txtboxGiaBan.Text = ct.Gia.ToString();
}
else
{
txtBoxSLTon.Text = "";
txtboxGiaBan.Text = "";
}
}
catch
{
txtBoxSLTon.Text = "";
txtboxGiaBan.Text = "";
}
}
void LoadSP()
{
cmBoxDongSP.Enabled = true;
cmBoxDongSP.DataSource = DongSanPhamBUS.GetAllDongSP();
//cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP();
//cmBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP();
cmBoxTenMau.DataSource = ChiTietSPBUS.GetAllMauSP();
cmBoxTenMau.DisplayMember = "Mau";
cmBoxTenMau.ValueMember = "MaMau";
if (IDMode.Trim(' ') != "ts")
{
btnAnh.Visible = false;
btnThemSP.Visible = false;
btnLuuThayDoi.Visible = false;
btnLuuKieuSP.Visible = false;
btnHuyKieuSP.Visible = false;
btnThemKieuSP.Visible = false;
btnChinhSuaKieuSP.Visible = false;
btnXoaKieuSP.Visible = false;
btnThemMau.Visible = false;
btnXoaMau.Visible = false;
btnLuuMau.Visible = false;
}
//Xem Chi tiết
if (ID != null && Ischange == false)
{
btnThemSP.Visible = false;
btnLuuThayDoi.Visible = false;
SanPham sp = BUS.SanPhamBUS.GetSanPhamByID(ID);
cmBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(sp.MaDSP);
cmBoxSP.ValueMember = "MaSP";
cmBoxSP.DisplayMember = "TenSP";
cmBoxSP.SelectedValue = ID;
cmBoxDongSP.DisplayMember = "TenDong";
cmBoxDongSP.ValueMember = "MaDSP";
cmBoxDongSP.SelectedValue = sp.MaDSP;
cmBoxSP.SelectedValue = ID;
txtboxMaSP.Text = sp.MaSP;
txtTenSP.Text = sp.TenSP;
txtNamSX.Text = sp.NămSX;
txtboxCPU.Text = sp.CPU;
txtboxGPU.Text = sp.CardManHinh;
txtCamera.Text = sp.Camera;
txtPort.Text = sp.Port;
txtboxRam.Text = sp.Ram;
txtboxManHinh.Text = sp.ManHinh;
txtboxOS.Text = sp.OS;
txtboxSim.Text = sp.Sim;
txtboxPin.Text = sp.DungLuongPin;
txtBoxTrongLuong.Text = sp.TrongLuong;
txtboxBNngoai.Text = sp.BoNhoNgoai;
txtboxBNtrong.Text = sp.BoNhoTrong;
}
//Thêm Mới
if (ID == null && Ischange == false)
{
cmBoxSP.Enabled = false;
cmBoxDongSP.DisplayMember = "TenDong";
cmBoxDongSP.ValueMember = "MaDSP";
if (IDDSP != null)
{
cmBoxDongSP.SelectedValue = IDDSP;
}
btnThemSP.Visible = false;
btnLuuThayDoi.Visible = true;
cmBoxSP.Visible = false;
txtTenSP.ReadOnly = false;
txtNamSX.ReadOnly = false;
txtboxCPU.ReadOnly = false;
txtboxGPU.ReadOnly = false;
txtCamera.ReadOnly = false;
txtPort.ReadOnly = false;
txtboxRam.ReadOnly = false;
txtboxManHinh.ReadOnly = false;
txtboxOS.ReadOnly = false;
txtboxSim.ReadOnly = false;
txtboxPin.ReadOnly = false;
txtBoxTrongLuong.ReadOnly = false;
txtboxBNngoai.ReadOnly = false;
txtboxBNtrong.ReadOnly = false;
}
//Chỉnh sửa
if (ID != null && Ischange == true)
{
cmBoxSP.Enabled = false;
cmBoxDongSP.DisplayMember = "TenDong";
cmBoxDongSP.ValueMember = "MaDSP";
btnThemSP.Visible = false;
btnLuuThayDoi.Visible = true;
cmBoxSP.Visible = false;
txtboxMaSP.Text = ID;
txtboxMaSP.ReadOnly = true;
txtTenSP.ReadOnly = false;
txtNamSX.ReadOnly = false;
txtboxCPU.ReadOnly = false;
txtboxGPU.ReadOnly = false;
txtCamera.ReadOnly = false;
txtPort.ReadOnly = false;
txtboxRam.ReadOnly = false;
txtboxManHinh.ReadOnly = false;
txtboxOS.ReadOnly = false;
txtboxSim.ReadOnly = false;
txtboxPin.ReadOnly = false;
txtBoxTrongLuong.ReadOnly = false;
txtboxBNngoai.ReadOnly = false;
txtboxBNtrong.ReadOnly = false;
SanPham sp = BUS.SanPhamBUS.GetSanPhamByID(ID);
cmBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(sp.MaDSP);
cmBoxSP.ValueMember = "MaSP";
cmBoxSP.DisplayMember = "MaSP";
cmBoxSP.SelectedValue = sp.MaSP;
cmBoxDongSP.DisplayMember = "TenDong";
cmBoxDongSP.ValueMember = "MaDSP";
cmBoxDongSP.SelectedValue = sp.MaDSP;
txtboxMaSP.Text = sp.MaSP;
txtTenSP.Text = sp.TenSP;
txtNamSX.Text = sp.NămSX;
txtboxCPU.Text = sp.CPU;
txtboxGPU.Text = sp.CardManHinh;
txtCamera.Text = sp.Camera;
txtPort.Text = sp.Port;
txtboxRam.Text = sp.Ram;
txtboxManHinh.Text = sp.ManHinh;
txtboxOS.Text = sp.OS;
txtboxSim.Text = sp.Sim;
txtboxPin.Text = sp.DungLuongPin;
txtBoxTrongLuong.Text = sp.TrongLuong;
txtboxBNngoai.Text = sp.BoNhoNgoai;
txtboxBNtrong.Text = sp.BoNhoTrong;
}
}
public ActionResult Detail(int id)
{
return(View(ChiTietSPBUS.LoadSP(id)));
}
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;
}
