private void cbbLoai_SelectionChangeCommitted(object sender, EventArgs e)
{
var MaLoai = cbbLoai.SelectedValue.ToString();
using (MyEStoreDataContext _Database = new MyEStoreDataContext()) {
_Database.DeferredLoadingEnabled = false;
var danhSachHangHoaTheoLoai =
_Database.HangHoas.Where(hh => hh.MaLoai.Equals(MaLoai)).ToList();
dgvHangHoa.DataSource = danhSachHangHoaTheoLoai;
}
}
private void FormThemHangHoa_Load(object sender, EventArgs e)
{
using (MyEStoreDataContext _Database = new MyEStoreDataContext()) {
cbbLoaiHangHoa.DataSource = _Database.Loais.ToList();
cbbLoaiHangHoa.DisplayMember = "TenLoai";
cbbLoaiHangHoa.ValueMember = "MaLoai";
cbbNhaCungCap.DataSource = _Database.NhaCungCaps.ToList();
cbbNhaCungCap.DisplayMember = "TenCongTy";
cbbNhaCungCap.ValueMember = "MaNCC";
}
}
private void button1_Click(object sender, EventArgs e)
{
Form fThemHangHoa = new FormThemHangHoa();
DialogResult formThem = fThemHangHoa.ShowDialog();
if (formThem == DialogResult.OK)
{
using (MyEStoreDataContext _Database = new MyEStoreDataContext())
{
_Database.DeferredLoadingEnabled = false;
dgvHangHoa.DataSource = _Database.HangHoas.ToList();
}
}
}
private void btnTim_Click(object sender, EventArgs e)
{
string tuKhoa = txtTuKhoa.Text;
using (MyEStoreDataContext _Database = new MyEStoreDataContext()) {
_Database.DeferredLoadingEnabled = false;
var danhSachHHTimKiem =
_Database.HangHoas.Where(
hh => hh.TenHH.Contains(tuKhoa) ||
hh.MaHH.ToString().Contains(tuKhoa)
).ToList();
dgvHangHoa.DataSource = danhSachHHTimKiem;
}
}
private void dgvHangHoa_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var MaHH = dgvHangHoa.Rows[e.RowIndex].Cells[0].Value.ToString();
Form formSuaHangHoa = new FormSuaHangHoa(MaHH);
DialogResult kt = formSuaHangHoa.ShowDialog();
if (kt == DialogResult.OK)
{
using (MyEStoreDataContext _Database = new MyEStoreDataContext())
{
_Database.DeferredLoadingEnabled = false;
dgvHangHoa.DataSource = _Database.HangHoas.ToList();
}
}
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
HangHoa hh = GetInputForm();
using (MyEStoreDataContext _Database = new MyEStoreDataContext())
{
_Database.HangHoas.InsertOnSubmit(hh);
_Database.SubmitChanges();
DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Form1_Load(object sender, EventArgs e)
{
using (MyEStoreDataContext _Database = new MyEStoreDataContext()) {
_Database.DeferredLoadingEnabled = false;
//Load datagreaView
dgvHangHoa.DataSource = _Database.HangHoas.ToList();
//Load cbbLoai
List <Loai> danhSachLoai = _Database.Loais.ToList();
danhSachLoai.Insert(0, new Loai()
{
MaLoai = 0,
TenLoai = "Chọn Loại Sản Phẩm"
});
cbbLoai.DataSource = danhSachLoai;
cbbLoai.SelectedIndex = 0;
cbbLoai.ValueMember = "MaLoai";
cbbLoai.DisplayMember = "TenLoai";
}
}