private void btnLuu_Click(object sender, EventArgs e)
{
if (Them)
{
try
{
LoaiSP sp = new LoaiSP();
sp.MaLSP = txtMa.Text; sp.TenLSP = txtTenLoai.Text;
LoaiSPBUS.ThemLSP(sp);
LoadData();
// Thông báo
MessageBox.Show("Đã thêm xong!");
}
catch
{
MessageBox.Show("Mã loại sản phẩm tồn tai. Nhập Mã loại sản phẩm khác !");
txtMa.ResetText();
txtTenLoai.ResetText();
txtMa.Focus();
}
}
else
{
LoaiSP sp = new LoaiSP();
sp.MaLSP = txtMa.Text; sp.TenLSP = txtTenLoai.Text;
LoaiSPBUS.SuaLSP(sp);
LoadData();
// Thông báo
MessageBox.Show("Đã sửa xong!");
}
}
private void FrmNhapHang_Load(object sender, EventArgs e)
{
imgnho.ColorDepth = ColorDepth.Depth32Bit;
imgnho.ImageSize = new System.Drawing.Size(60, 60);
lsvNhapSP.LargeImageList = imgnho;
NXSBUS bus2 = new NXSBUS();
List <NSXDTO> lsdto2 = bus2.LayDSNSX();
cmbnsx.DataSource = lsdto2;
cmbnsx.DisplayMember = "TenNSX";
cmbnsx.ValueMember = "MaNSX";
LoaiSPBUS buss = new LoaiSPBUS();
List <LoaiSPDTO> lss = buss.layDSLoaiSP();
cboLoaiSP.DataSource = lss;
cboLoaiSP.DisplayMember = "TenLoaiSP";
cboLoaiSP.ValueMember = "MaLoaiSP";
if (!string.IsNullOrEmpty(tendangnhap))
{
FrmBanHang.tdn = tendangnhap;
TaiKhoanBUS bus1 = new TaiKhoanBUS();
TaiKhoanDTO dto1 = bus1.LayThongTinTK(tendangnhap);
txtNVLap.Text = dto1.HoTen;
}
colXoa.UseColumnTextForButtonValue = true;
}
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";
}
void LoadComboBox()
{
cmBoxDSP.DataSource = DongSanPhamBUS.GetAllDongSP();
cmBoxDSP.DisplayMember = "TenDong";
cmBoxDSP.ValueMember = "MaDSP";
cmBoxNSX.DataSource = HSXBUS.GetAllHSX();
cmBoxNSX.ValueMember = "MaHSX";
cmBoxNSX.DisplayMember = "TenHSX";
cmBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP();
cmBoxLoaiSP.DisplayMember = "TenLSP";
cmBoxLoaiSP.ValueMember = "MaLSP";
comboBoxNoiNhapHang.DataSource = CuaHangBUS.GetAllCuaHang();
comboBoxNoiNhapHang.DisplayMember = "TenCuaHang";
comboBoxNoiNhapHang.ValueMember = "MaCuaHang";
comboBoxNoiNhapHang.SelectedValue = "ts";
if (IDHDNH == null)
{
//txtboxHSX.Visible = false;
//txtBoxLSP.Visible = false;
//txtBoxDSP.Visible = false;
//txtboxGiaBan.Visible = false;
//txtBoxKieuSP.Visible = false;
//txtboxSP.Visible = false;
txtBoxMaHDNH.ReadOnly = false;
txtBoxMaNVNH.Text = MaNV;
groupBox2.Enabled = false;
//txtboxGiaBan.ReadOnly = false;
//txtboxGiaNhap.ReadOnly = false;
//txtboxGiaBan.Visible = true;
}
}
// GET: Admin/LoaiSP
public ActionResult Index(int?page)
{
var LstDS = LoaiSPBUS.LoadDSLoaiSP();
int pageSize = 12;
int pageNumber = (page ?? 1);
return(View(LstDS.ToPagedList(pageNumber, pageSize)));
}
// GET: Admin/LoaiSP/Edit/5
public ActionResult Edit(int id)
{
var lsp = LoaiSPBUS.LoadLoaiSP(id);
var n = new LoaiSP();
n.idLoai = lsp.idLoai;
n.TenLoai = lsp.TenLoai;
return(View(n));
}
private void LoaDSLOAISP()
{
LoaiSPBUS bus = new LoaiSPBUS();
List <LoaiSPDTO> dto = bus.layDSLoaiSP();
cmbLoaiSP.DataSource = dto;
cmbLoaiSP.DisplayMember = "TenLoaiSP";
cmbLoaiSP.ValueMember = "MaLoaiSP";
}
void LoadDSP()
{
dongSanPhamBindingSource.DataSource = DongSanPhamBUS.GetAllDongSP();
cmBoxHSX.DataSource = HSXBUS.GetAllHSX();
cmBoxHSX.DisplayMember = "TenHSX";
cmBoxHSX.ValueMember = "MaHSX";
cmBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP();
cmBoxLoaiSP.DisplayMember = "TenLSP";
cmBoxLoaiSP.ValueMember = "MaLSP";
}
public void LoadGomNhomSanPhamTheoLoai()
{
LoaiSPBUS lspbus = new LoaiSPBUS();
List <LoaiSPDTO> lst = lspbus.layDSLoaiSP();
rpvBaoCao.LocalReport.ReportEmbeddedResource = "QuanLiCuaHangDoChoi.rptTheoGomNhomLSP.rdlc";
rpvBaoCao.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
rpvBaoCao.LocalReport.DataSources.Add(new ReportDataSource("dsLoaiSP", lst));
rpvBaoCao.RefreshReport();
}
public void loadCmboxDongSanPham()
{
cmBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP();
cmBoxLoaiSP.DisplayMember = "TenLSP";
cmBoxLoaiSP.ValueMember = "MaLSP";
cmBoxHSX.DataSource = HSXBUS.GetAllHSX();
cmBoxHSX.DisplayMember = "TenHSX";
cmBoxHSX.ValueMember = "MaHSX";
}
public void LoadSanPhamTheoLoai(string maLoai)
{
SanPhamBUS bus = new SanPhamBUS();
List <SanPhamDTO> lsp = bus.LayDSSanPhamTheoLoai(maLoai);
rpvBaoCao.LocalReport.ReportEmbeddedResource = "QuanLiCuaHangDoChoi.rptTheoLoaiSanPham.rdlc";
LoaiSPBUS lspbus = new LoaiSPBUS();
LoaiSPDTO l = lspbus.LayLoaiSanPham(maLoai);
rpvBaoCao.LocalReport.SetParameters(new ReportParameter("pMaLoai", l.TenLoaiSP));
rpvBaoCao.LocalReport.DataSources.Add(new ReportDataSource("dsLoaiSP", lsp));
}
public ActionResult Create(SP n)
{
// TODO: Add insert logic here
ViewBag.NhaSX = NSXBUS.DanhSach();
ViewBag.Loai = LoaiSPBUS.LoadDSLoaiSP();
if (ModelState.IsValid)
{
try
{
if (HttpContext.Request.Files.Count > 0)
{
var hpf = HttpContext.Request.Files[0];
if (hpf.ContentLength > 0)
{
string fileName = Guid.NewGuid().ToString();
string fullPathWithFileName = "/Assets/Images/products/" + fileName + ".jpg";
hpf.SaveAs(Server.MapPath(fullPathWithFileName));
n.HinhAnh = fullPathWithFileName;
var b = new SanPham()
{
idSP = n.idSP,
GiaSP = n.GiaSP,
HinhAnh = n.HinhAnh,
MaLoai = n.MaLoai,
TenSP = n.TenSP,
MaNSX = n.MaNSX,
MoTa = n.MoTa
};
SPBUS.ThemSP(b);
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
else
{
return(View());
}
}
catch
{
return(View());
}
}
else
{
return(View());
}
}
private void frmQLDanhMuc_Load(object sender, EventArgs e)
{
List <LoaiSPDTO> lstLSP = LoaiSPBUS.layDanhSachLoaiSP(1);
for (int i = 0; i < lstLSP.Count; i++)
{
ListViewItem lst = new ListViewItem();
lst.Text = lstLSP[i].Ten.ToString();
lst.SubItems.Add(lstLSP[i].TThai.ToString());
lst.Tag = lstLSP[i];
lvLoaiSP.Items.Add(lst);
}
}
public void LoadData()
{
loaiSPBindingSource.DataSource = LoaiSPBUS.GetAllLoaiSP();
txtMa.ResetText();
txtTenLoai.ResetText();
// Không cho thao tác trên các nút Lưu / Hủy
btnLuu.Enabled = false;
btnHuy.Enabled = false;
panel.Enabled = false;
// Cho thao tác trên các nút Thêm / Sửa / Xóa / Thoát
btnThem.Enabled = true;
btnSua.Enabled = true;
btnXoa.Enabled = true;
}
private void FrmBaoCaoThongKe_Load(object sender, EventArgs e)
{
LoaiSPBUS bus = new LoaiSPBUS();
cboTheoLoaiSP.DisplayMember = "TenLoaiSP";
cboTheoLoaiSP.ValueMember = "MaLoaiSP";
cboTheoLoaiSP.DataSource = bus.layDSLoaiSP();
//LoadMaNV
TaiKhoanBUS tk = new TaiKhoanBUS();
cboDSMaNV.DisplayMember = "MaNV";
cboDSMaNV.ValueMember = "MaNV";
cboDSMaNV.DataSource = tk.LayDSTaiKhoan();
}
private void btnThem_Click(object sender, EventArgs e)
{
LoaiSPDTO lsp = new LoaiSPDTO();
lsp.Ten = txtTen.Text;
lsp.TThai = 1;
if (radAn.Checked)
{
lsp.TThai = 0;
}
LoaiSPBUS.themLoaiSP(lsp);
MessageBox.Show("Thêm danh mục sản phẩm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void frmThemSP_Load(object sender, EventArgs e)
{
List <LoaiSPDTO> lstloaisp = LoaiSPBUS.layDanhSachLoaiSP(1);
cbLoaiSP.DisplayMember = "Ten";
cbLoaiSP.ValueMember = "Ma";
cbLoaiSP.DataSource = lstloaisp;
List <NhaCungCapDTO> lstNCC = NhaCungCapBUS.layDanhSachNCC(1);
cbNCC.DisplayMember = "TenNCC";
cbNCC.ValueMember = "Ma";
cbNCC.DataSource = lstNCC;
if (_sp != null)
{
txtTen.Text = _sp.Ten;
txtMota.Text = _sp.MoTa;
txtGia.Text = _sp.Gia.ToString();
cbLoaiSP.SelectedValue = _sp.LoaiSP;
cbNCC.SelectedValue = _sp.NCC;
txtHSD.Text = String.Format("{0:dd/MM/yyyy}", _sp.HSD.ToString());
if (_sp.TThai == 1)
{
radHien.Checked = true;
}
if (_sp.TThai == 0)
{
radAn.Checked = true;
}
pictureBox1.Image = LoadImage("images\\" + _sp.Hinh);
btnThem.Visible = false;
btnSua.Visible = true;
this.Text = "Chỉnh sửa sản phẩm";
}
else
{
btnSua.Visible = false;
btnXoa.Visible = false;
}
}
private void frmthemsanpham_Load(object sender, EventArgs e)
{
txtMaSP.Text = bus.LayMaSPTiepTheo();
LoaiSPBUS bus3 = new LoaiSPBUS();
List <LoaiSPDTO> dto3 = bus3.layDSLoaiSP();
cmbLoaiSP.DataSource = dto3;
cmbLoaiSP.DisplayMember = "TenLoaiSP";
cmbLoaiSP.ValueMember = "MaLoaiSP";
NXSBUS bus2 = new NXSBUS();
List <NSXDTO> dto1 = bus2.LayDSNSX();
cmbNSX.DataSource = dto1;
cmbNSX.DisplayMember = "TenNSX";
cmbNSX.ValueMember = "MaNSX";
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
LoaiSPDTO lspDTO = new LoaiSPDTO();
lspDTO.MaLoai = int.Parse(txtID.Text);
lspDTO.TenLoai = txtName.Text;
if (LoaiSPBUS.ThemLoaiSanPham(lspDTO) == true)
{
lblThongBao.Text = "Thêm thành công";
}
else
{
lblThongBao.Text = "Thêm thất bại";
}
}
catch (Exception ex)
{ }
}
// GET: Admin/NhaSX/Edit/5
public ActionResult Edit(int id)
{
ViewBag.NhaSX = NSXBUS.DanhSach();
ViewBag.Loai = LoaiSPBUS.LoadDSLoaiSP();
//////////
var b = SPBUS.LoadSanPham(id);
var a = new SP()
{
HinhAnh = b.HinhAnh,
idSP = b.idSP,
GiaSP = int.Parse(b.GiaSP.ToString()),
MaLoai = int.Parse(b.MaLoai.ToString()),
MaNSX = int.Parse(b.MaNSX.ToString()),
MoTa = b.MoTa,
TenSP = b.TenSP
};
return(View(a));
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
// Lấy thứ tự record hiện hành
int r = dgvLSP.CurrentCell.RowIndex;
// Lấy MaKH của record hiện hành
LoaiSP a = new LoaiSP();
a.TenLSP = txtTenLoai.Text;
a.MaLSP = txtMa.Text;
LoaiSPBUS.XoaLSP(a);
LoadData();
//dgvNV_CellClick(null, null);
MessageBox.Show("Đã xóa xong!");
}
catch
{
MessageBox.Show("Không được phép xóa nhân viên này");
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
GridView gv = (GridView)sender;
GridViewRow row = GridView1.Rows[e.RowIndex];
string sMaLoai = gv.DataKeys[e.RowIndex]["MaLoai"].ToString();
LoaiSPDTO lspDTO = new LoaiSPDTO();
lspDTO.MaLoai = int.Parse(sMaLoai);
if (gv.Rows.Count == 1)
{
CurrentPage--;
}
LoaiSPBUS.XoaLoaiSP(lspDTO);
BindItemsList();
}
catch (Exception ex)
{ }
}
private void frmQLSanPham_Load(object sender, EventArgs e)
{
LoadSanPham(SanPhamBUS.layDanhSachSP(1));
List <LoaiSPDTO> lstloai = LoaiSPBUS.layDanhSachLoaiSP(1);
cbLoaiSP.Items.Insert(0, "Tất cả");
cbbTKLoaiSP.Items.Insert(0, "Tất cả");
cbbTGLoai.Items.Insert(0, "Tất cả");
cbLoaiSP.SelectedIndex = 0;
cbbTKLoaiSP.SelectedIndex = 0;
cbbTGLoai.SelectedIndex = 0;
for (int i = 0; i < lstloai.Count; i++)
{
cbLoaiSP.Items.Insert(lstloai[i].Ma, lstloai[i].Ten);
cbbTKLoaiSP.Items.Insert(lstloai[i].Ma, lstloai[i].Ten);
cbbTGLoai.Items.Insert(lstloai[i].Ma, lstloai[i].Ten);
}
}
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 btnSua_Click(object sender, EventArgs e)
{
if (txtTen.Text == "")
{
MessageBox.Show("Chưa nhập tên loại sản phẩm");
return;
}
//kiem tra trang thai
_lsp.Ten = txtTen.Text;
_lsp.TThai = 1;
if (radAn.Checked)
{
_lsp.TThai = 0;
}
if (LoaiSPBUS.suaLoaiSP(_lsp))
{
MessageBox.Show("Sửa loại sản phẩm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public ActionResult Edit(LoaiSP n)
{
if (ModelState.IsValid)
{
try
{
var lsp = new LoaiSanPham();
lsp.idLoai = n.idLoai;
lsp.TenLoai = n.TenLoai;
LoaiSPBUS.SuaDSLoaiSP(lsp);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
else
{
return(View());
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
GridView gv = (GridView)sender;
GridViewRow row = GridView1.Rows[e.RowIndex];
string sID = gv.DataKeys[e.RowIndex]["MaLoai"].ToString();
string sName = ((TextBox)(row.Cells[1].Controls[0])).Text;
LoaiSPDTO lspDTO = new LoaiSPDTO();
lspDTO.MaLoai = int.Parse(sID);
lspDTO.TenLoai = sName;
LoaiSPBUS.SuaThongTin(lspDTO);
GridView1.EditIndex = -1;
BindItemsList();
}
catch (Exception ex)
{
Response.Write("<script type='text/javascript'>"
+ "alert('Có lỗi xảy ra. Vui Lòng điền đúng kiểu dữ liệu yêu cầu !!!');"
+ "</script>");
}
}
// GET: Admin/NhaSX/Create
public ActionResult Create()
{
ViewBag.NhaSX = NSXBUS.DanhSach();
ViewBag.Loai = LoaiSPBUS.LoadDSLoaiSP();
return(View());
}
// GET: Admin/LoaiSP/Delete/5
public ActionResult Delete(int id)
{
LoaiSPBUS.XoaDSLoaiSP(id);
return(View());
}
/// <summary>
/// Build DataTable to bind Main Items List
/// </summary>
/// <returns>DataTable</returns>
private DataTable GetDataTable()
{
DataTable dt = LoaiSPBUS.LayThongTinLoaiSanPham();
return(dt);
}
