private void ThemChiTietDonNhapUI(object sender, DataGridViewCellEventArgs e)
{
try
{
HangBUS hangBUS = new HangBUS();
if (grvThongKeHangBan.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
grvThongKeHangBan.CurrentRow.Selected = true;
string mahang = grvThongKeHangBan.Rows[e.RowIndex].Cells["COLMAHANG"].FormattedValue.ToString();
List <HangDTO> hangByID = hangBUS.TimKiem(mahang);
if (!maHang_Add.Contains(hangByID[0].maHang.ToString()))
{
maHang_Add.Add(hangByID[0].maHang.ToString());
grvChiTietDonNhapTab1.Rows.Add(
hangByID[0].maHang,
hangByID[0].tenHang,
1
);
}
else
{
MessageBox.Show("Đã tồn tại hàng trong đơn");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void loadData()
{
dataGridView1.DataSource = HangBUS.loadAllDataHang();
(dataGridView1.Columns["MaLoai"] as DataGridViewComboBoxColumn).DataSource = loaiHang;
(dataGridView1.Columns["MaLoai"] as DataGridViewComboBoxColumn).DisplayMember = "TenLoai";
(dataGridView1.Columns["MaLoai"] as DataGridViewComboBoxColumn).ValueMember = "MaLoai";
}
public ActionResult Edit(string id, NhaSanXuat nsx)
{
try
{
// TODO: Add update logic here
HangBUS.UpdateNSX(id, nsx);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create(NhaSanXuat nsx)
{
try
{
// TODO: Add insert logic here
// HAM THEM
HangBUS.ThemNSX(nsx);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Xoa(String id, NhaSanXuat nsx)
{
try
{
// TODO: Add delete logic here
nsx.TinhTrang = "1";
HangBUS.UpdateNSX(id, nsx);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void Load_BTKHangBan()
{
HangBUS hangBUS = new HangBUS();
grvThongKeHangBan.Rows.Clear();
grvThongKeHangBan.Refresh();
List <HangDTO> allHang = hangBUS.lapBangThongKeHangBan(dtimeThongKeHangStart.Value, dtimeThongKeHangEnd.Value);
for (int i = 0; i < allHang.Count; i++)
{
grvThongKeHangBan.Rows.Add(
allHang[i].maHang,
allHang[i].tenHang,
allHang[i].soLuongDaBan);
this.grvThongKeHangBan.ClearSelection();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Bạn chắc chứ ?", "Cảnh báo !!!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No)
{
return;
}
try
{
HangBUS.deleteDataHang(txtMaHang.Text);
loadData();
MessageBox.Show("Xóa thành công !!!");
}
catch (SqlException)
{
MessageBox.Show("Có lỗi xảy ra !!!");
}
}
private void btnSua_Click(object sender, EventArgs e)
{
try
{
HangDTO hangDTO = new HangDTO();
hangDTO.MaHang = txtMaHang.Text;
hangDTO.TenHang = txtTenHang.Text;
hangDTO.DonGia = Convert.ToSingle(txtDonGia.Text);
hangDTO.SoLuong = Convert.ToInt32(txtSoLuong.Text);
hangDTO.MaLoai = cbLoaiHang.SelectedValue.ToString();
HangBUS.editDataHang(hangDTO);
loadData();
MessageBox.Show("Sửa thành công !!!");
}
catch (SqlException)
{
MessageBox.Show("Có lỗi xảy ra !!!");
}
}
//==========================================================================/
private void HienDSMatHang()
{
HangBUS hang = new HangBUS();
List <HangDTO> allHang = hang.TimKiem(txtTimKiem.Text);
/*format column size*/
grd_HangQuangCao.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
grd_HangQuangCao.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;
grd_HangQuangCao.Rows.Clear();
for (int i = 0; i < allHang.Count; i++)
{
grd_HangQuangCao.Rows.Add(
allHang[i].maHang,
allHang[i].tenHang,
allHang[i].soLuongConLai,
allHang[i].donGia);
}
this.grd_HangQuangCao.ClearSelection();
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtMaHang.Text.Equals("") || txtTenHang.Text.Equals("") || txtDonGia.Text.Equals("") || txtSoLuong.Text.Equals(""))
{
MessageBox.Show("Yêu cầu nhập đủ các trường !!!");
return;
}
try
{
HangDTO hangDTO = new HangDTO();
hangDTO.MaHang = txtMaHang.Text;
hangDTO.TenHang = txtTenHang.Text;
hangDTO.DonGia = Convert.ToSingle(txtDonGia.Text);
hangDTO.SoLuong = Convert.ToInt32(txtSoLuong.Text);
hangDTO.MaLoai = cbLoaiHang.SelectedValue.ToString();
HangBUS.addDataHang(hangDTO);
loadData();
MessageBox.Show("Thêm thành công !!!");
}
catch (SqlException)
{
MessageBox.Show("Có lỗi xảy ra !!!");
}
}
public ActionResult Xoa(String id)
{
return(View(HangBUS.ChiTietAdmin(id)));
}
// GET: Admin/NhaSanXuat
public ActionResult Index()
{
var ds = HangBUS.DanhSachAll();
return(View(ds));
}
// GET: Admin/Admin/Create
public ActionResult Create()
{
ViewBag.MaNhaSanXuat = new SelectList(HangBUS.DanhSach(), "MaNhaSanXuat", "TenNhaSanXuat");
ViewBag.MaLoaiSanPham = new SelectList(LoaiBUS.DanhSach(), "MaLoaiSanPham", "TenLoaiSanPham");
return(View());
}
// GET: Admin/Admin/Edit/5
public ActionResult Edit(String id)
{
ViewBag.MaNhaSanXuat = new SelectList(HangBUS.DanhSach(), "MaNhaSanXuat", "TenNhaSanXuat", MobiShopBUS.ChiTietSP(id).MaNhaSanXuat);
ViewBag.MaLoaiSanPham = new SelectList(LoaiBUS.DanhSach(), "MaLoaiSanPham", "TenLoaiSanPham", MobiShopBUS.ChiTietSP(id).MaLoaiSanPham);
return(View(MobiShopBUS.ChiTietSP(id)));
}
private void loadTimKiem(string maHang)
{
dataGridView1.DataSource = HangBUS.searchById(maHang);
}
// GET: Hang
public ActionResult Index(String id, int page = 1, int pagesize = 3)
{
var dsNSX = HangBUS.Chitiet(id).ToPagedList(page, pagesize);
return(View(dsNSX));
}
