protected void btnCapNhat_Click(object sender, EventArgs e)
{
SanPhamDTO sp = SanPhamBUS.LayDSSanPhamCapNhat(txtmasp.Text);
SanPhamDTO sp2 = SanPhamBUS.LayDSSanPhamCapNhat(txtmasp.Text);
sp.TenSP = txtTenSP.Text;
sp.ThongTin = txtThongTin.Text;
sp.GiaTien = Convert.ToInt32(txtGiaTien.Text);
sp.MaLoaiSp = ddlSanPham.SelectedValue.ToString();
if (imgHinhSanPham.HasFile)
{
string sTenfile;
sTenfile = imgHinhSanPham.FileName;
imgHinhSanPham.SaveAs(MapPath("../images/" + sTenfile));
sp.AnhMinhHoa = sTenfile.ToString();
}
else
{
sp2.AnhMinhHoa = sp.AnhMinhHoa;
}
if (SanPhamBUS.CapNhatSP(sp, txtmasp.Text))
{
load();
Response.Write("<script>alert('Cập nhật sản phẩm thành công!')</script>");
}
else
{
Response.Write("<script>alert('Cập nhật sản phẩm thất bại!')</script>");
}
}
private void FormChiTietThanhVien_Load(object sender, EventArgs e)
{
ThanhVienDTO thanhVienDTO = ThanhVienBUS.SelectThanhVienById(maThanhVien);
labelMaThanhVien.Text = "Mã thành viên: " + maThanhVien;
labelTenThanhVien.Text = "Tên thành viên: " + thanhVienDTO.TenThanhVien;
labelDiaChi.Text = "Địa chỉ: " + thanhVienDTO.DiaChi;
labelTongCV.Text = "Tổng CV: " + thanhVienDTO.CV.ToString();
List <PhieuXuatDTO> listPhieuXuatDTO = PhieuXuatBUS.SelectPhieuXuatByMaThanhVien(maThanhVien);
if (listPhieuXuatDTO != null)
{
dataGridViewChiTiet.Rows.Clear();
List <ChiTietPhieuXuatDTO> listChiTietPhieuXuatDTO = new List <ChiTietPhieuXuatDTO>();
foreach (PhieuXuatDTO itemPhieuXuat in listPhieuXuatDTO)
{
listChiTietPhieuXuatDTO = ChiTietPhieuXuatBUS.SelectChiTietPhieuXuatByMaPhieuXuat(itemPhieuXuat.MaPhieuXuat);
if (listChiTietPhieuXuatDTO != null)
{
foreach (ChiTietPhieuXuatDTO itemCTPX in listChiTietPhieuXuatDTO)
{
dataGridViewChiTiet.Rows.Add(
itemPhieuXuat.MaPhieuXuat,
itemPhieuXuat.NgayBan.ToString("dd/MM/yyyy"),
NhanVienBUS.SelectNhanVienById(itemPhieuXuat.MaNhanVien).TenNhanVien,
SanPhamBUS.SelectSanPhamById(itemCTPX.MaSanPham).TenSanPham,
itemCTPX.SoLuong.ToString(),
string.Format("{0:#,0.##}", itemCTPX.ThanhTien)
);
}
}
}
}
}
void CapNhatSoLuongSanPham(string masp, int sl, int mode)
{
var kq = sp.Where(p => p.MASP == masp).FirstOrDefault();
int sl_ton = Convert.ToInt32(kq.SL_TON);
if (mode == 0)
{
kq.SL_TON = sl_ton - sl;
}
// sl ton =100
// sl trong ct = 50
// sl cap nhat =40
if (mode == 1)
{
if (sl < sl_cthd)
{
kq.SL_TON = sl_ton + (sl_cthd - sl);
}
else if (sl > sl_cthd)
{
kq.SL_TON = sl_ton - (sl - sl_cthd);
}
}
if (mode == 2)
{
kq.SL_TON = sl_ton + sl_cthd;
}
SanPhamBUS.SuaSanPham(kq);
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridView gv = (GridView)sender;
GridViewRow row = GridView1.Rows[e.RowIndex];
string sMaSP = gv.DataKeys[e.RowIndex]["MaSP"].ToString();
SanPhamDTO spDTO = new SanPhamDTO();
spDTO.Ma = int.Parse(sMaSP);
if (gv.Rows.Count == 1)
{
CurrentPage--;
}
string sAvatar = row.Cells[2].Text;
try
{
FileInfo file = new FileInfo(Server.MapPath(sAvatar));
if (file.Exists)
{
File.Delete(Server.MapPath(sAvatar));
}
}
catch
{
}
SanPhamBUS.XoaSanPham(spDTO);
BindItemsList();
}
// sự kiện load khi khởi động chương trình
private void frmMain_Load(object sender, EventArgs e)
{
spBUS = new SanPhamBUS();
showSanPham();
lockControl();
clearData();
}
private void LoadDanhSachSPSP()
{
SanPhamBUS bus = new SanPhamBUS();
lsdto = new List <SanPhamDTO>();
lsdto = bus.LayDSSanPhamTheoLoai(cboLoaiSP.SelectedValue.ToString()).FindAll(o => o.MaLoaiSP == cboLoaiSP.SelectedValue.ToString());
//colBHTenSP.DataSource = lsdto;
//colBHTenSP.DisplayMember = "TenSP";
//colBHTenSP.ValueMember = "MaSP";
for (int i = 0; i < lsdto.Count; i++)
{
ListViewItem lvi = new ListViewItem(lsdto[i].TenSP);
lvi.SubItems.Add(lsdto[i].TenSP);
if (File.Exists(lsdto[i].HinhAnh))
{
byte[] byteHA = File.ReadAllBytes(lsdto[i].HinhAnh);
MemoryStream ms = new MemoryStream(byteHA);
Image img = Image.FromStream(ms);
imgnho.Images.Add(img);
lvi.ImageIndex = imgnho.Images.Count - 1;
}
lsvNhapSP.Items.Add(lvi);
}
}
/// <summary>
/// Tab danh sach san pham
/// </summary>
void LoadDataTabDSSP()
{
lstSanPham = SanPhamBUS.LayDanhSachSanPham();
lstNhaPP = NhaPhanPhoiBUS.LayDanhSachNhaPhanPhoi();
lstAnhMinhHoa = AnhMinhHoaSPBUS.LayDanhSachAnhMinhHoa();
//var kq = from sp in lstSanPham
// select new
// {
// sp.MASP,
// sp.TENSP,
// sp.SL_TON,
// sp.GIABAN,
// sp.DVT,
// sp.LOAISANPHAM.TENLOAI,
// sp.NHAPHANPHOI.TENNPP
// };
var kq = from sp in lstSanPham
join npp in lstNhaPP
on sp.MANPP equals npp.MANPP
select new
{
sp.MASP,
sp.TENSP,
sp.SL_TON,
sp.GIABAN,
sp.DVT,
sp.LOAISANPHAM.TENLOAI,
npp.TENNPP
};
this.dgvDSSanPham.DataSource = kq.ToList();
this.dgvDSSanPham.AutoGenerateColumns = false;
}
public frmDonHangChiTiet()
{
InitializeComponent();
donhangchitietBUS = new DonHangChiTietBUS();
sanphamBUS = new SanPhamBUS();
donhangBUS = new DonHangBUS();
}
private void FormChonSanPham_Load(object sender, EventArgs e)
{
List <SanPhamDTO> sanPhamDTO = new List <SanPhamDTO>();
sanPhamDTO = SanPhamBUS.SelectSanPhamAll();
for (int i = 0; i < sanPhamDTO.Count; i++)
{
dataGridView_ChoSanPham.Rows.Add(i + 1, sanPhamDTO[i].MaSanPham, sanPhamDTO[i].TenSanPham, LoaiSanPhamBUS.SelectLoaiSanPhamById(sanPhamDTO[i].MaLoaiSanPham).TenLoaiSanPham, false);
}
List <LoaiSanPhamDTO> lstcbspDTO = LoaiSanPhamBUS.SelectLoaiSanPhamAll();
LoaiSanPhamDTO all = new LoaiSanPhamDTO();
all.MaLoaiSanPham = "Tất cả";
all.TenLoaiSanPham = "Tất cả";
lstcbspDTO.Insert(0, all);
comboBoxLoaiSanPham.DisplayMember = "TenLoaiSanPham";
comboBoxLoaiSanPham.ValueMember = "TenLoaiSanPham";
comboBoxLoaiSanPham.DataSource = lstcbspDTO;
comboBoxLoaiSanPham.SelectedIndex = 0;
}
private void btnThem_Click(object sender, EventArgs e)
{
SanPhamDTO sp = new SanPhamDTO();
sp.Ten = txtTen.Text;
sp.MoTa = txtMota.Text;
sp.Gia = Convert.ToInt32(txtGia.Text);
sp.HSD = txtHSD.Text;
sp.LoaiSP = Convert.ToInt32(cbLoaiSP.SelectedValue);
sp.NCC = Convert.ToInt32(cbNCC.SelectedValue);
sp.Hinh = "";
sp.TThai = 1;
if (radAn.Checked)
{
sp.TThai = 0;
}
int id = SanPhamBUS.themSanPham(sp);
if (openFileDialog1.Tag != null)
{
string filePath = (string)openFileDialog1.Tag;
string img = id + Path.GetExtension(filePath);
File.Copy(filePath, "images\\" + img, true);
SanPhamBUS.capNhatAnhSP(id, img);
}
MessageBox.Show("Thêm sản phẩm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
//
// Phương thức event khi nhấn Thêm ở tab hoá đơn
// Mỗi lần nhấn thêm 1 sản phẩm vào data grid view
//
private void BtnAdd4_Click(object sender, EventArgs e)
{
try
{
int yeuCau = Convert.ToInt32(txtSoL4.Text);
int thucTe = new SanPhamBUS().GetSoL(txtTenSP4.Text);
int maSP = new SanPhamBUS().GetMaSP(txtTenSP4.Text);
if (yeuCau > thucTe || yeuCau == 0)
{
MessageBox.Show("Sản phẩm không đủ số lượng yêu cầu");
}
else
{
int donGiaBan = new SanPhamBUS().GetDGB(txtTenSP4.Text);
int tong = donGiaBan * Convert.ToInt32(txtSoL4.Text);
int thanhTien = Convert.ToInt32(txtThanhTien4.Text);
gridData4.Rows.Add(txtTenSP4.Text, txtSoL4.Text, donGiaBan.ToString(), tong.ToString());
thanhTien += tong;
txtTenSP4.Text = "";
txtSoL4.Text = "";
txtThanhTien4.Text = thanhTien.ToString();
}
txtTenSP4.Text = "";
txtSoL4.Text = "";
}
catch
{
MessageBox.Show("Kiểm tra lại thông tin vừa nhập");
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (_sp != null)
{
_sp.Ten = txtTen.Text;
_sp.Gia = Convert.ToInt32(txtGia.Text);
_sp.MoTa = txtMota.Text;
_sp.LoaiSP = Convert.ToInt32(cbLoaiSP.SelectedValue);
_sp.NCC = Convert.ToInt32(cbNCC.SelectedValue);
_sp.HSD = txtHSD.Text;
_sp.TThai = 1;
if (radAn.Checked)
{
_sp.TThai = 0;
}
if (openFileDialog1.Tag != null)
{
string filePath = (string)openFileDialog1.Tag;
File.Copy(filePath, "images\\" + _sp.Ma.ToString() + Path.GetExtension(filePath), true);
_sp.Hinh = _sp.Ma.ToString() + Path.GetExtension(filePath);
}
if (SanPhamBUS.suaSanPham(_sp))
{
MessageBox.Show("Sửa sản phẩm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
if (IsValid)
{
SanPhamBUS insertSanPham = new SanPhamBUS();
SanPhamDTO sanPham = new SanPhamDTO();
sanPham.IdDanhMucSanPham = int.Parse(dropDanhMucSanPham.SelectedItem.Value);
sanPham.TenSanPham = txtTenSanPham.Text; // txtTenSanPham là ID của TextBox
sanPham.MoTaSanPham = CKEditorControlMoTa.Text; //txtTenSanPham là ID của TextBox
sanPham.HinhSanPham.LinkSanPham = fileuploadHinhSanPham.FileBytes;
// fileuploadHinhSanPham là ID của điều khiển FileUpLoad
sanPham.GiaSanPham = int.Parse(txtGia.Text); // txtGia là ID của TextBox
insertSanPham._sanPham = sanPham;
try
{
insertSanPham.Insert();
}
catch
{
Response.Redirect("../Trangloi.aspx");
}
// tắt khúc này vì chưa có trang SanPham.aspx nên khi add thành công thì nó chuyển qua trang SanPham sẽ lỗi
//Response.Redirect("SanPham.aspx");
}
}
public void Test_DeleteSP_Success()
{
spBUS = new SanPhamBUS();
Assert.AreEqual(14, spBUS.LoadSPBUS().Count);
spBUS.DeleteSPBUS(17);
Assert.AreEqual(13, spBUS.LoadSPBUS().Count);
}
private void btnTimTheoGia_Click(object sender, EventArgs e)
{
int giaTu = txtTGLonHon.Text != "" ? Convert.ToInt32(txtTGLonHon.Text) : 0;
int giaDen = txtTGNhoHon.Text != "" ? Convert.ToInt32(txtTGNhoHon.Text) : 0;
LoadSanPham(SanPhamBUS.timTheoGiaSP(giaTu, giaDen, Convert.ToInt32(cbbTGLoai.SelectedIndex)));
}
private void btn_Xong_Click(object sender, EventArgs e)
{
bool flag = false;
for (int i = 0; i < dataGridView_ChoSanPham.RowCount; i++)
{
if (dataGridView_ChoSanPham.Rows[i].Cells[clCheck.Index].Value.ToString() == "True")
{
listsanPhamDTO_ChonSanPham.Add(SanPhamBUS.SelectSanPhamById(dataGridView_ChoSanPham.Rows[i].Cells[clMaSanPham.Index].Value.ToString()));
flag = true;
}
}
if (flag == false)
{
DialogResult result = MessageBox.Show("Chưa có sản phẩm nào được chọn, bạn muốn thoát?", "Sản phẩm", MessageBoxButtons.OKCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
if (result == DialogResult.OK)
{
huy = true;
this.Dispose();
}
}
else
{
huy = false;
this.Dispose();
}
}
private void loadtheoten()
{
SanPhamBUS bus = new SanPhamBUS();
lsdto = bus.TimKiemTheoMa(txtTimSP.Text);
lsdto = new List <SanPhamDTO>();
lsdto = bus.TimKiemTheoMa(txtTimSP.Text).FindAll(o => o.TinhTrang == 1);
lsvNhapSP.Items.Clear();
//colBHTenSP.DataSource = lsdto;
//colBHTenSP.DisplayMember = "TenSP";
//colBHTenSP.ValueMember = "MaSP";
for (int i = 0; i < lsdto.Count; i++)
{
ListViewItem lvi = new ListViewItem(lsdto[i].TenSP);
lvi.SubItems.Add(lsdto[i].TenSP);
if (File.Exists(lsdto[i].HinhAnh))
{
byte[] byteHA = File.ReadAllBytes(lsdto[i].HinhAnh);
MemoryStream ms = new MemoryStream(byteHA);
Image img = Image.FromStream(ms);
imgnho.Images.Add(img);
lvi.ImageIndex = imgnho.Images.Count - 1;
}
else
{
lsdto[i].HinhAnh = null;
}
lsvNhapSP.Items.Add(lvi);
}
}
private void frmQuanLySanPham_Load(object sender, EventArgs e)
{
SanPhamBUS SPBUS = new SanPhamBUS();
dgvDanhSachSP.AutoGenerateColumns = false;
dgvDanhSachSP.DataSource = SPBUS.LayDanhSachSanPham();
}
private void btnModeThem_Click(object sender, EventArgs e)
{
if (this.txtMaSp.Text == string.Empty ||
this.txtTenSP.Text == string.Empty ||
this.txtGiaBanSp.Text == string.Empty ||
this.txtSLTonSp.Text == string.Empty ||
this.txtDVT.Text == string.Empty ||
this.txtLoaiSanPham.Text == string.Empty ||
this.txtNhaPhanPhoi.Text == string.Empty ||
this.imgSanPham.Image == null)
{
MessageBox.Show("Bạn chưa điền đủ thông tin !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
SANPHAM sanpham = new SANPHAM();
sanpham.MASP = this.txtMaSp.Text;
sanpham.TENSP = this.txtTenSP.Text;
sanpham.GIABAN = Convert.ToInt32(this.txtGiaBanSp.Text);
sanpham.SL_TON = Convert.ToInt32(this.txtSLTonSp.Text);
sanpham.DVT = this.txtDVT.Text;
sanpham.MALOAI = this.txtLoaiSanPham.Text;
sanpham.MANPP = this.txtNhaPhanPhoi.Text;
sanpham.TRANGTHAI = true;
string maAnh = this.txtMaSp.Text + "_" + DateTime.Now.ToString("dd-MM-yy-h-m-s");
string[] chuoiXuLiTenAnh = this.tenAnhMinhHoa.Split('.');
this.tenAnhMinhHoa = this.txtMaSp.Text + "_" + DateTime.Now.ToString("dd-MM-yy-h-m-s") + "." + chuoiXuLiTenAnh[1];
ANHMINHHOASP anhMH = new ANHMINHHOASP {
MAANH = maAnh, TENANHMINHHOA = this.tenAnhMinhHoa, MASP = sanpham.MASP, TRANGTHAI = true
};
if (!SanPhamBUS.KiemTraMaSPTonTai(sanpham.MASP))
{
try
{
SanPhamBUS.ThemSanPham(sanpham);
AnhMinhHoaSPBUS.ThemAnhMinhHoa(anhMH);
this.imgSanPham.Image.Save(patch + anhMH.TENANHMINHHOA);
MessageBox.Show("Thêm sản phẩm thành công !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset();
LoadDataTabQLSP();
LoadDataTabDSSP();
string lsth = "[" + DateTime.Now.ToString("dd/MM/yyyy-h:m:s") + "] " + this.manv + " đã thêm một sản phẩm (" + sanpham.MASP + ")";
LichSuHeThongBUS.ThemLSHT(new LICHSUHETHONG
{
NGAYTAO = DateTime.Now.Date,
NV_THAOTAC = this.manv,
VITRI_THAOTAC = this.vitrithaotac,
GHICHU = lsth
});
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
private void btnThem_Click(object sender, EventArgs e)
{
int categoryid, Price, userid;
string id, name, des;
id = txtID.Text.Trim();
name = txtTenDT.Text.Trim();
categoryid = int.Parse(txtMaloai.Text.Trim());
des = txtMota.Text.Trim();
Price = int.Parse(txtGia.Text.Trim());
userid = int.Parse(txtUserID.Text.Trim());
SanPhamDTO spo = new SanPhamDTO(id, name, categoryid, des, Price, userid);
try
{
int i = new SanPhamBUS().Add(spo);
dgvSanPham.DataSource = GetProductGUI();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void txtMaSp_Validated(object sender, EventArgs e)
{
if (SanPhamBUS.KiemTraMaSPTonTai(this.txtMaSp.Text))
{
MessageBox.Show("Mã sản phẩm đã tồn tại !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtMaSp.Focus();
return;
}
if (this.txtMaSp.Text == string.Empty)
{
return;
}
if (this.txtMaSp.Text.Length > 10)
{
MessageBox.Show("Mã sản phẩm không được vượt quá 10 kí tự !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtMaSp.Focus();
return;
}
if (!KiemtraDinhDangMASP(this.txtMaSp.Text))
{
MessageBox.Show("Mã sản phẩm không đúng định dạng !!!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtMaSp.Focus();
return;
}
}
//Status=0 Load_Default(), thanhphanNhap và DataGripView khi status = 0
private void Load_Create()
{
Load_Default();
//lamlai thanh phan nhap
txtMaThanhVien.Clear();
txtTenKhachHang.Clear();
txtDiaChi.Clear();
txtTenKhachHang.ReadOnly = false;
txtDiaChi.ReadOnly = false;
//Load Datagripview
int stt = 1;
List <SanPhamDTO> listSanPhamDTO = SanPhamBUS.SelectSanPhamAll();
if (listSanPhamDTO != null)
{
dataGridView_XuatHang.Rows.Clear();
SanPhamDTO sanPhamDTO = new SanPhamDTO();
for (int i = 0; i < listSanPhamDTO.Count; i++)
{
sanPhamDTO = listSanPhamDTO[i];
dataGridView_XuatHang.Rows.Add(stt, sanPhamDTO.MaSanPham, sanPhamDTO.TenSanPham, sanPhamDTO.CV, sanPhamDTO.DonGia, sanPhamDTO.SoLuongTon, 0, 0);
stt++;
}
}
btnTao.Enabled = false;
}
public void LoadDataSanPham()
{
SanPhamBUS sp = new SanPhamBUS();
dataSanPham.DataSource = sp.GetData();
}
private void FrmTongQuan_Load(object sender, EventArgs e)
{
HDBanBUS bus = new HDBanBUS();
HDBanDTO dto = bus.DemMaHDBan();
txtDemHDB.Text = dto.MaHDBan;
//Load SO HD Nhap
HDNhapBUS bus1 = new HDNhapBUS();
HDNhapDTO dto1 = bus1.DemMaHDNhap();
txtDemHDN.Text = dto1.MaHDNhap;
//Load TongSP Da Ban
SanPhamBUS bus2 = new SanPhamBUS();
SP_CTHDBDTO dto2 = bus2.TongSoSPBan();
txtTongSPBan.Text = dto2.SLSP.ToString();
//Load TongSP Da Nhap
SanPhamBUS bus3 = new SanPhamBUS();
SP_CTHDN_LSP_HDN dto3 = bus3.TongSoSPNhap();
txtTongSPDaNhap.Text = dto3.TongSL.ToString();
//Load HD huy
HDBanBUS bus4 = new HDBanBUS();
HDBanDTO dto4 = bus4.DemSoHDHuy();
txtTongSPDaNhap.Text = dto4.MaHDBan.ToString();
//loadTongDoanhThu
HDBanBUS bus5 = new HDBanBUS();
HDBanDTO dto5 = bus5.TongDoanhThuTrongNgay();
txtTongDT.Text = dto5.TongTien.ToString("#.##");
}
private void btnAddAddSanPham_Click(object sender, EventArgs e)
{
try
{
SANPHAM SP = new SANPHAM();
SP.MASP = tbMaSPAddSanPham.Text;
SP.TENSP = tbTenSPAddSanPham.Text;
SP.THUONGHIEU = tbThuongHieuAddSanPham.Text;
SP.THONGTIN = rtbThongTinAddSanPham.Text;
SP.GIANHAP = Convert.ToDecimal(tbGiaAddSanPham.Text);
SP.GIABAN = Convert.ToDecimal((SP.GIANHAP * (decimal)0.05) + SP.GIANHAP);
SP.LOAISP = tbLoaiSP.Text;
SP.IMAGES = tbImages.Text;
SP.SOLUONG = Convert.ToInt32(nudSLuong.Value);
SP.MANK = cbbMaKhoAddSanPham.Text;
SP.MANCC = cbbMaNCCAddSanPham.Text;
SP.TIMENHAP = DateTime.Now;
SanPhamBUS SPBUS = new SanPhamBUS();
SPBUS.insertSP(SP);
pathImage();
this.Dispose();
}
catch { }
}
private void btnLapPhieuMoi_Click(object sender, EventArgs e)
{
i = 0;
Tien = 0;
txtTongtien.Text = "0";
btnLapPhieuMoi.Enabled = false;
btnThemSP.Enabled = true;
cboNCC.Enabled = false;
btnIn.Enabled = true;
txtSoPĐ.Text = DonDatHangBUS.GetIDPhieuDat();
txtMaSP.ResetText();
txtTenSP.ResetText();
txtSoLuong.ResetText();
txtGia.ResetText();
dtkNgayDat.Value = DateTime.Now;
dgvDanhSach.Rows.Clear();
// Thêm vào auto complete.
AutoCompleteStringCollection auto = new AutoCompleteStringCollection();
foreach (DataRow row in SanPhamBUS.DanhSachSPTheoNCC(cboNCC.SelectedValue.ToString()).Rows)
{
auto.Add(row["MaSanPham"].ToString());
}
txtMaSP.AutoCompleteMode = AutoCompleteMode.Suggest;
txtMaSP.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtMaSP.AutoCompleteCustomSource = auto;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SanPhamDTO sp = SanPhamBUS.LaySanPhamTheoMaSp(Request.QueryString["qqq"]);
lblTenSP.Text = sp.TenSP;
imgAnhMinhHoa.ImageUrl = "images/" + sp.AnhMinhHoa;
lblThongTin.Text = sp.ThongTin;
lblMaSP.Text = sp.MaSP;
lblGia.Text = sp.GiaTien.ToString();
lblMaSP.Visible = false;
DropDownList_size.DataSource = SanPhamBUS.LaySanPhamTheoTheoSise(Request.QueryString["qqq"]);
DropDownList_size.DataTextField = "sizenumber";
DropDownList_size.DataValueField = "SoLuongTonKho";
DropDownList_size.DataBind();
lblSLTK.Text = DropDownList_size.Items[0].Value.ToString();
rpt_LoaiGiay.DataSource = LoaiSanPhamBUS.LayDSLoaiSanPham();
rpt_LoaiGiay.DataBind();
rpt_SizeGiay.DataSource = SizeGiayBUS.LayDSSize();
rpt_SizeGiay.DataBind();
rpt_spcungloai.DataSource = SanPhamBUS.LaySanPhamCungLoaiTrongTrangChiTiet(sp.MaLoaiSP);
rpt_spcungloai.DataBind();
}
}
private void LoadDanhSachSP()
{
//KhachHangBUS BUS = new KhachHangBUS();
//List<KhachHangDTO> lsdtokh = BUS.LAYDSKH();
//cmbkh.DataSource = lsdtokh;
//cmbkh.DisplayMember = "MaKH";
//cmbkh.ValueMember = "MaKH";
SanPhamBUS bus = new SanPhamBUS();
lsdto = bus.LayDSSanPham();
lsdto = new List <SanPhamDTO>();
lsdto = bus.LayDSSanPham().FindAll(o => o.TinhTrang == 1);
for (int i = 0; i < lsdto.Count; i++)
{
ListViewItem lvi = new ListViewItem(lsdto[i].TenSP);
lvi.SubItems.Add(lsdto[i].TenSP);
if (File.Exists(lsdto[i].HinhAnh))
{
byte[] byteHA = File.ReadAllBytes(lsdto[i].HinhAnh);
MemoryStream ms = new MemoryStream(byteHA);
Image img = Image.FromStream(ms);
imgnho.Images.Add(img);
lvi.ImageIndex = imgnho.Images.Count - 1;
}
lsvHienThiDSSP.Items.Add(lvi);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (this.txtMasp.Text == string.Empty || this.txtSoLuong.Text == string.Empty)
{
MessageBox.Show("Bạn chưa điền đầy đủ thông tin !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.txtMasp.Focus();
return;
}
if (!SanPhamBUS.KiemTraMaSPTonTai(this.txtMasp.Text))
{
MessageBox.Show("Mã sản phẩm không tồn tại !!!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtMasp.Focus();
return;
}
if (!KiemTraSLMasp(this.txtMasp.Text, Convert.ToInt32(this.txtSoLuong.Text)))
{
this.txtSoLuong.Focus();
return;
}
if (!KiemTraMaspTonTaiTrongCTHD(this.txtMasp.Text))
{
CTHoaDonBanHangBUS.ThemCTHoaDon(new CTHOADONBANHANG
{
MAHD = hd.MAHD,
MASP = this.txtMasp.Text,
SOLUONG = Convert.ToInt32(this.txtSoLuong.Text.Trim()),
DONGIA = TinhDonGia(this.txtMasp.Text, Convert.ToInt32(this.txtSoLuong.Text)),
DVT = sp.Where(p => p.MASP == this.txtMasp.Text).FirstOrDefault().DVT,
TRANGTHAI = true
});
MessageBox.Show("Thêm sản phẩm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadDSCTHD(hd.MAHD);
CapNhatSoLuongSanPham(this.txtMasp.Text, Convert.ToInt32(this.txtSoLuong.Text), 0);
hd.TONGTIEN = lstcthd.Sum(p => p.DONGIA);
HoaDonBanHangBUS.CapNhatHoaDon(hd);
if (CongNoBUS.LayDanhSachCongNo().Where(p => p.MAKH == this.lblMaKH.Text && p.MAHD == hd.MAHD && p.TRANGTHAI == true).FirstOrDefault() != null)
{
CapNhatThongTienCongNo();
}
this.dangThayDoiCTHD = false;
loadThongTinHD(hd.MAHD);
Reset();
string lsth = "[" + DateTime.Now.ToString("dd/MM/yyyy-h:m:s") + "] " + this.manv + " đã thêm sản phẩm " + this.txtMasp.Text + " vào chi tiết hóa đơn " + hd.MAHD;
LichSuHeThongBUS.ThemLSHT(new LICHSUHETHONG
{
NGAYTAO = DateTime.Now.Date,
NV_THAOTAC = this.manv,
VITRI_THAOTAC = this.vitrithaotac,
GHICHU = lsth
});
}
else
{
MessageBox.Show("Mã sản phẩm đã tồn tại !!!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.txtMasp.Focus();
return;
}
}
public IActionResult Index(string id)
{
string idd = id ?? "B77D9CF5-E9A2-4D31-9490-25E4E3971C61";
//BUS
SanPhamBUS sanphambus = new SanPhamBUS();
SizeSanPhamBUS sizesanphambus = new SizeSanPhamBUS();
GioHangBUS giohangbus = new GioHangBUS();
DiaChiBUS diachibus = new DiaChiBUS();
SanPham sanpham = sanphambus.GetSanPham(idd);
DiaChi diachi = diachibus.GetDiaChiMer(sanpham.IdTaiKhoanNavigation.TenDangNhap);
ViewBag.DiaChiMerchant = diachi;
List <SizeSanPham> listsizesanpham = sizesanphambus.GetSize(idd);
ViewBag.ListSizeSanPham = listsizesanpham;
List <HangSanPham> hang = ctx.HangSanPham.ToList();
ViewBag.Hang = hang;
List <SanPham> spmoi = sanphambus.GetSanPhams("", "", 1, 4);
ViewBag.SanPhamMoi = spmoi;
return(View(sanpham));
}
