public NhapKho()
{
InitializeComponent();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
RefreshGridview();
//todo db sanpham
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <SanPham> sanPhamRepo = new Repository <SanPham>(dbCxt);
Repository <LoSanPham> loSanPhamRepo = new Repository <LoSanPham>(dbCxt);
Repository <LoaiSanPham> loaiSanPhamRepo = new Repository <LoaiSanPham>(dbCxt);
Repository <DonViSanPham> donViSanPhamRepo = new Repository <DonViSanPham>(dbCxt);
Repository <NhaCungCap> nccRepo = new Repository <NhaCungCap>(dbCxt);
comboloai.Items.Clear();
combodonvi.Items.Clear();
combonhaCungCap.Items.Clear();
foreach (var loaiSp in loaiSanPhamRepo.GetAll())
{
comboloai.Items.Add(loaiSp);
}
foreach (var donviSp in donViSanPhamRepo.GetAll())
{
combodonvi.Items.Add(donviSp);
}
foreach (var ncc in nccRepo.GetAll())
{
combonhaCungCap.Items.Add(ncc);
}
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBoxID.Text))
{
MessageBox.Show("Thông tin trống!");
}
else
{
if (MessageBox.Show(
"Có chắc là muốn xoá nhà cung cấp" + Environment.NewLine +
textBoxTenNhaCungCap.Text,
"Cảnh báo",
MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhaCungCap> nccRepo = new Repository <NhaCungCap>(dbCxt);
var ncc = nccRepo.Get(Guid.Parse(textBoxID.Text));
nccRepo.Delete(ncc);
MessageBox.Show("Xoá nhà cung cấp xong.");
}
RefreshGridView();
}
clear();
}
private void BtnThem_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtIdNV.Text))
{
MessageBox.Show("Trống!");
txtIdNV.Select();
}
if (string.IsNullOrWhiteSpace(txtTenNV.Text))
{
txtTenNV.Select();
}
else
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhanVien> nvRepo = new Repository <NhanVien>(dbCxt);
var nvMoi = new NhanVien
{
Id = Guid.NewGuid(),
TenNhanVien = txtTenNV.Text,
Username = txtTenNV.Text.Replace(" ", "").ToLower(),
Matkhau = "123456"
};
nvRepo.Insert(nvMoi);
MessageBox.Show("Đã thêm nhân viên" + Environment.NewLine + "Tên đăng nhập mới:" + nvMoi.Username);
}
gridviewNhanVien();
}
}
private void btnsua_Click(object sender, EventArgs e)
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository<LoSanPham> repo = new Repository<LoSanPham>(dbCxt);
var lsp = repo.Get(Guid.Parse(maspedit));
lsp.SoLuong = lsp.SoLuong + slspedit;
repo.Update(lsp);
}
DataGridViewRow newDataRow = dataGridView1.Rows[indexRow];
newDataRow.Cells[0].Value = txtmasp.Text;
newDataRow.Cells[1].Value = txttensp.Text;
newDataRow.Cells[2].Value = txtsoluongsp.Text;
newDataRow.Cells[3].Value = txtdongiasp.Text;
newDataRow.Cells[4].Value = txttiensp.Text;
newDataRow.Cells[5].Value = comboBoxdonvisp.Text;
newDataRow.Cells[6].Value = comboBoxloaisp.Text;
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository<LoSanPham> repo = new Repository<LoSanPham>(dbCxt);
var lsp = repo.Get(Guid.Parse(txtmasp.Text));
lsp.SoLuong = Math.Clamp(lsp.SoLuong - int.Parse(txtsoluongsp.Text), 0, lsp.SoLuong);
repo.Update(lsp);
}
clearsp();
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBoxID.Text))
{
MessageBox.Show("Thông tin trống!");
}
else
{
if (MessageBox.Show(
"Có chắc là muốn xoá loại sản phẩm" + Environment.NewLine +
textBoxTenLoai.Text,
"Cảnh báo",
MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <LoaiSanPham> loaiSpRepo = new Repository <LoaiSanPham>(dbCxt);
var lsp = loaiSpRepo.Get(Guid.Parse(textBoxID.Text));
loaiSpRepo.Delete(lsp);
MessageBox.Show("Xoá loại sản phẩm xong.");
}
RefreshGridView();
}
clear();
}
private void InsertDatabase(Guid nhanVienId, Guid khachHangId, double no = 0)
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <HoaDon> hoadonRepo = new Repository <HoaDon>(dbCxt);
Repository <ChiTietHoaDon> chitiethoadonRepo = new Repository <ChiTietHoaDon>(dbCxt);
Repository <LoSanPham> lspRepo = new Repository <LoSanPham>(dbCxt);
HoaDon hoaDon = new HoaDon()
{
Id = Guid.NewGuid(),
KhachHangId = khachHangId == Guid.Empty ? Guid.Parse("00000000-0000-0000-0000-000000000001") : khachHangId,
NhanVienId = nhanVienId,
NgayLap = DateTime.Now,
No = no
};
var cthds = chiTietHoaDons.Select(cthd => new ChiTietHoaDon()
{
LoSanPhamId = lspRepo.Query(lsp => lsp.SanPhamId == cthd.LoSanPhamId).FirstOrDefault().Id,
HoaDonId = hoaDon.Id,
SoLuong = cthd.SoLuong,
DonGia = cthd.DonGia
});
hoadonRepo.Insert(hoaDon);
cthds.ToList().ForEach(chitiethoadonRepo.Insert);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(textBoxID.Text))
{
MessageBox.Show("Xin nhập nhà cung cấp mới, bấm nút Nhập lại để xoá các field.");
return;
}
else
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhaCungCap> nccRepo = new Repository <NhaCungCap>(dbCxt);
NhaCungCap nccMoi = new NhaCungCap
{
Id = Guid.NewGuid(),
TenNhaCungCap = textBoxTenNhaCungCap.Text
};
nccRepo.Insert(nccMoi);
MessageBox.Show("Thêm nhà cung cấp xong.");
}
RefreshGridView();
}
}
private void btnxoa_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow item in this.dataGridView1.SelectedRows)
{
DataGridViewRow row = dataGridView1.Rows[item.Index];
masp1 = row.Cells[0].Value.ToString();
slsp1 = Convert.ToInt32(row.Cells[2].Value.ToString());
dataGridView1.Rows.RemoveAt(item.Index); //remove row in datagridview
}
//------------- tra lai soluong sp database -----------------//
try
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository<LoSanPham> repo = new Repository<LoSanPham>(dbCxt);
var lsp = repo.Get(Guid.Parse(masp1));
lsp.SoLuong = lsp.SoLuong + slsp1;
repo.Update(lsp);
}
}
catch (Exception ex)
{
MessageBox.Show("loi update ne" + ex.Message);
}
}
private void MainControl_Load(object sender, EventArgs e)
{
PanelDropDownSP.Height = 50;
try
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhanVien> repo = new Repository <NhanVien>(dbCxt);
var nv = repo.Query(nv => nv.Username == DangNhap.usernv).FirstOrDefault();
if (nv == null)
{
MessageBox.Show("not found");
}
else
{
LabelUser.Text = nv.TenNhanVien;
tennv = nv.TenNhanVien;
manv = nv.Id;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnSua_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtIdNV.Text))
{
MessageBox.Show("Xin chọn nhân viên cần sửa ở bảng bên phải!");
return;
}
if (string.IsNullOrWhiteSpace(txtTenNV.Text))
{
txtTenNV.Select();
}
else
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhanVien> nvRepo = new Repository <NhanVien>(dbCxt);
var nv = nvRepo.Get(Guid.Parse(txtIdNV.Text));
nv.TenNhanVien = txtTenNV.Text;
nv.Username = txtTenNV.Text.Replace(" ", "").ToLower();
nvRepo.Update(nv);
MessageBox.Show("Đã sửa nhân viên" + Environment.NewLine + "Tên đăng nhập mới:" + nv.Username);
}
gridviewNhanVien();
}
}
private void txtmakh_TextChanged(object sender, EventArgs e)
{
try
{
if (string.IsNullOrWhiteSpace(txtmakh.Text))
{
txttenkh.Clear();
}
else
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository<KhachHang> repo = new Repository<KhachHang>(dbCxt);
var kh = repo.Get(Guid.Parse(txtmakh.Text));
if (kh == null)
{
MessageBox.Show("Không tìm thấy khách hàng");
return;
}
else
{
txttenkh.Text = (kh.TenKhachHang);
//luu tru cho form TT
MaKH = kh.Id;
TenKH = txttenkh.Text;
SDT = txtmakh.Text;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void BtnXoa_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtIdNV.Text))
{
MessageBox.Show("Xin chọn nhân viên cần xoá ở bảng bên phải!");
return;
}
else
{
if (MessageBox.Show(
"Có chắc là muốn xoá loại sản phẩm" + Environment.NewLine +
txtTenNV.Text,
"Cảnh báo",
MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhanVien> nvRepo = new Repository <NhanVien>(dbCxt);
var nv = nvRepo.Get(Guid.Parse(txtIdNV.Text));
nvRepo.Delete(nv);
MessageBox.Show("Đã xoá nhân viên: " + nv.TenNhanVien);
}
gridviewNhanVien();
}
}
private void HoaDonChiTiet_Load(object sender, EventArgs e)
{
try
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <HoaDon> hdRepo = new Repository <HoaDon>(dbCxt);
Repository <ChiTietHoaDon> cthdRepo = new Repository <ChiTietHoaDon>(dbCxt);
var chitiethoadons = cthdRepo.Query(cthd => cthd.HoaDonId == DonHang.hdid).Select(cthd => new HienThiChiTietHoaDon
{
SanPhamId = cthd.LoSanPham.SanPhamId,
TenSanPham = cthd.LoSanPham.SanPham.TenSanPham,
SoLuong = cthd.SoLuong,
DonGia = cthd.DonGia
});
dataGridViewct.DataSource = chitiethoadons.ToList().ToDataTable();
var hoadon = hdRepo.Get(DonHang.hdid);
txtBoxNo.Text = string.Format("{0:N2}", hoadon.No);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void RefreshGridview()
{
//todo db sanpham
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <SanPham> sanPhamRepo = new Repository <SanPham>(dbCxt);
Repository <LoSanPham> loSanPhamRepo = new Repository <LoSanPham>(dbCxt);
DataTable datatbsp;
var spQuery = loSanPhamRepo.GetAll().Select(lsp => new HienThiLoSanPham
{
Id = lsp.Id,
SanPhamId = lsp.SanPhamId,
TenSanPham = lsp.SanPham.TenSanPham,
GiaTien = lsp.SanPham.GiaTien,
SoLuong = lsp.SoLuong,
LoaiSanPham = lsp.SanPham.LoaiSanPham,
DonViSanPham = lsp.SanPham.DonViSanPham,
NhaCungCap = lsp.NhaCungCap
});
datatbsp = spQuery.ToDataTable();
dataGridView1.DataSource = datatbsp;
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(textBoxID.Text))
{
MessageBox.Show("Xin nhập loại sản phẩm mới, bấm nút Nhập lại để xoá các field.");
return;
}
else
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <LoaiSanPham> loaiSpRepo = new Repository <LoaiSanPham>(dbCxt);
LoaiSanPham lspMoi = new LoaiSanPham
{
Id = Guid.NewGuid(),
TenLoaiSanPham = textBoxTenLoai.Text
};
loaiSpRepo.Insert(lspMoi);
MessageBox.Show("Thêm loại sản phẩm xong.");
}
RefreshGridView();
}
}
private void txtmasp_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
double giamgiaTextbox;
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository<Data.Models.LoSanPham> lspRepo = new Repository<Data.Models.LoSanPham>(dbCxt);
var loSanPham = lspRepo.Query(lsp => lsp.SanPham.TenSanPham == txttensp.Text)
.Include(lsp => lsp.SanPham)
.ThenInclude(sp => sp.LoaiSanPham)
.Include(lsp => lsp.SanPham)
.ThenInclude(sp => sp.DonViSanPham)
.FirstOrDefault();
if (loSanPham == null)
{
MessageBox.Show("Sản phẩm ko có trong kho");
}
Repository<GiamGia> ggRepo = new Repository<GiamGia>(dbCxt);
var gg = ggRepo.Query(gg => gg.SanPhamId == loSanPham.SanPhamId && gg.NgayBatDau < DateTime.Now && gg.NgayKetThuc > DateTime.Now).FirstOrDefault();
int phanTramGiamGia = 0;
if (gg == null)
{
phanTramGiamGia = 0;
}
else
{
phanTramGiamGia = gg.PhanTramGiamGia;
}
txtmasp.Text = (loSanPham.SanPham.Id.ToString());
txttensp.Text = (loSanPham.SanPham.TenSanPham.ToString());
txtdongiasp.Text = (loSanPham.SanPham.GiaTien.ToString());
txtsoluongsp.Text = "1";
txtgiamphantramsp.Text = (phanTramGiamGia.ToString());
comboBoxdonvisp.Text = (loSanPham.SanPham.DonViSanPham.TenDonViSanPham.ToString());
comboBoxloaisp.Text = (loSanPham.SanPham.LoaiSanPham.TenLoaiSanPham.ToString());
//thanhtiensp = soluong * don gia
double slsp;
double dongiasp;
double thanhtiensp;
double thanhtiensp2;
slsp = double.Parse(txtsoluongsp.Text);
dongiasp = double.Parse(txtdongiasp.Text);
thanhtiensp = slsp * dongiasp;
//tien giam gia cua san pham
giamgiaTextbox = double.Parse(txtgiamphantramsp.Text);
double giamgiasp = (giamgiaTextbox * thanhtiensp) / 100;
//tien san pham = (so luong * don gia ) - giam gia
thanhtiensp2 = thanhtiensp - giamgiasp;
txttiensp.Text = string.Format("{0:N2}", thanhtiensp2);
}
}
}
private void txtsearch_TextChanged(object sender, EventArgs e)
{
try
{
//todo db sanpham nhap kho
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
string searchText = txtsearch.Text;
Repository <SanPham> sanPhamRepo = new Repository <SanPham>(dbCxt);
Repository <LoSanPham> loSanPhamRepo = new Repository <LoSanPham>(dbCxt);
DataTable datatbsp;
var spQuery = loSanPhamRepo
.Query(lsp =>
lsp.Id.ToString().Contains(searchText) ||
lsp.SanPham.TenSanPham.Contains(searchText))
.Select(lsp => new HienThiLoSanPham
{
Id = lsp.Id,
SanPhamId = lsp.SanPhamId,
TenSanPham = lsp.SanPham.TenSanPham,
GiaTien = lsp.SanPham.GiaTien,
SoLuong = lsp.SoLuong,
LoaiSanPham = lsp.SanPham.LoaiSanPham,
DonViSanPham = lsp.SanPham.DonViSanPham,
NhaCungCap = lsp.NhaCungCap
});
datatbsp = spQuery.ToDataTable();
dataGridView1.DataSource = datatbsp;
}
if (dataGridView1.Rows.Count > 0 && dataGridView1.Rows != null)
{
LabelSearch.Text = "Đã tìm thấy";
}
else
{
LabelSearch.Text = "Không tìm thấy...";
}
if (string.IsNullOrWhiteSpace(txtsearch.Text))
{
LabelSearch.Text = "Tìm kiếm";
}
}
catch (Exception ex)
{
connect.Close();
MessageBox.Show(ex.Message);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrWhiteSpace(txtid.Text))
{
MessageBox.Show("Xin nhập sản phẩm mới, bấm nút Nhập lại để xoá các field.");
return;
}
if (!ValidateInput())
{
MessageBox.Show("Lỗi dữ liệu!");
}
else
{
//todo db sanpham nhap kho
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <SanPham> sanPhamRepo = new Repository <SanPham>(dbCxt);
Repository <LoSanPham> loSanPhamRepo = new Repository <LoSanPham>(dbCxt);
Repository <LoaiSanPham> loaiSanPhamRepo = new Repository <LoaiSanPham>(dbCxt);
Repository <DonViSanPham> donViSanPhamRepo = new Repository <DonViSanPham>(dbCxt);
Repository <NhaCungCap> nccRepo = new Repository <NhaCungCap>(dbCxt);
var sanphamMoi = new SanPham
{
Id = Guid.NewGuid(),
TenSanPham = txttensp.Text,
GiaTien = double.Parse(txtgiaban.Text),
LoaiSanPhamId = (comboloai.SelectedItem as LoaiSanPham).Id,
DonViSanPhamId = (combodonvi.SelectedItem as DonViSanPham).Id,
};
var loSanPhamMoi = new LoSanPham
{
Id = Guid.NewGuid(),
SanPhamId = sanphamMoi.Id,
NhaCungCapId = (combonhaCungCap.SelectedItem as NhaCungCap).Id,
NgayNhap = DateTime.Now,
SoLuong = int.Parse(txtsl.Text)
};
sanPhamRepo.Insert(sanphamMoi);
loSanPhamRepo.Insert(loSanPhamMoi);
MessageBox.Show("Đã nhập xong");
}
txtid.ReadOnly = true;
RefreshGridview();
}
}
static void Main(string[] args)
{
var contextOptions = new DbContextOptionsBuilder <CuaHangTienLoiDbContext>()
.UseSqlServer(@"Data Source=(LocalDB)\MSSQLLocalDB;Initial Catalog=chtl;Integrated Security=True")
.Options;
CuaHangTienLoiDbContext context = new CuaHangTienLoiDbContext();
Repository <SanPham> spRepo = new Repository <SanPham>(context);
Console.WriteLine(JsonConvert.SerializeObject(spRepo.GetAll().Include(sp => sp.LoaiSanPham), Formatting.Indented));
Console.ReadLine();
}
private void RefreshGridView()
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <DonViSanPham> dvSpRepo = new Repository <DonViSanPham>(dbCxt);
DataTable datatbdv = dvSpRepo.GetAll().Select(dvsp => new HienThiDonViSanPham
{
Id = dvsp.Id,
TenDonViSanPham = dvsp.TenDonViSanPham
}).ToDataTable();
dataGridViewDVsp.DataSource = datatbdv;
}
}
private void RefreshGridView()
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhaCungCap> nccRepo = new Repository <NhaCungCap>(dbCxt);
DataTable datatbnhaCungCap = nccRepo.GetAll().Select(ncc => new HienThiNhaCungCap
{
Id = ncc.Id,
TenNhaCungCap = ncc.TenNhaCungCap
}).ToDataTable();
dataGridViewLoaiSPloai.DataSource = datatbnhaCungCap;
}
}
private void RefreshGridView()
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <LoaiSanPham> loaiSpRepo = new Repository <LoaiSanPham>(dbCxt);
DataTable datatbsploai = loaiSpRepo.GetAll().Select(lsp => new HienThiLoaiSanPham
{
Id = lsp.Id,
TenLoaiSanPham = lsp.TenLoaiSanPham
}).ToDataTable();
dataGridViewLoaiSPloai.DataSource = datatbsploai;
}
}
public void gridviewNhanVien()
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <NhanVien> nvRepo = new Repository <NhanVien>(dbCxt);
DataTable datatbnv = nvRepo.GetAll().Select(nv => new HienThiNhanVien
{
Id = nv.Id,
TenNhanVien = nv.TenNhanVien
}).ToDataTable();
dataGridViewNV.DataSource = datatbnv;
}
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
string getdate = dateTimePicker1.Value.Date.ToShortDateString();
try
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <HoaDon> hdRepo = new Repository <HoaDon>(dbCxt);
Repository <ChiTietHoaDon> cthdRepo = new Repository <ChiTietHoaDon>(dbCxt);
var searchText = textBoxSearch.Text;
var hoadons = hdRepo.GetAll()
.Include(hd => hd.KhachHang).Include(hd => hd.NhanVien)
.AsEnumerable().Where(hd => hd.NgayLap.ToShortDateString() == getdate)
.Select(hd => new HienThiHoaDon
{
Id = hd.Id,
NgayLap = hd.NgayLap,
TenKhachHang = hd.KhachHang.TenKhachHang,
TenNhanVien = hd.NhanVien.TenNhanVien
});
dataGridView1.DataSource = hoadons.ToList().ToDataTable <HienThiHoaDon>();
}
//using (SqlDataAdapter da = new SqlDataAdapter("select * from HoaDon where cast ([HDtime] as date) = '" + getdate + "' ", connect))
//{
// DataTable dtsearch = new DataTable("HoaDon");
// da.Fill(dtsearch);
// dataGridView1.DataSource = dtsearch;
//}
//connect.Close();
if (dataGridView1.Rows.Count > 1 && dataGridView1.Rows != null)
{
// labelSearch.Text = "Đã tìm thấy";
}
else
{
// labelSearch.Text = "Không tìm thấy...";
}
}
catch (Exception ex)
{
connect.Close();
MessageBox.Show(ex.Message);
}
}
private void gridviewKhachHang()
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <KhachHang> khRepo = new Repository <KhachHang>(dbCxt);
DataTable datatbkh = khRepo.GetAll().Select(kh => new HienThiKhachHang
{
Id = kh.Id,
TenKhachHang = kh.TenKhachHang,
SoDienThoai = kh.SoDienThoai,
DiaChi = kh.DiaChi,
Email = kh.Email
}).ToDataTable();
dataGridViewKH.DataSource = datatbkh;
}
}
public void RefreshGridview()
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <HoaDon> hdRepo = new Repository <HoaDon>(dbCxt);
Repository <ChiTietHoaDon> cthdRepo = new Repository <ChiTietHoaDon>(dbCxt);
var hoadons = hdRepo.GetAll().Select(hd => new HienThiHoaDon
{
Id = hd.Id,
NgayLap = hd.NgayLap,
TenKhachHang = hd.KhachHang.TenKhachHang,
TenNhanVien = hd.NhanVien.TenNhanVien,
No = hd.No
});
dataGridView1.DataSource = hoadons.ToList().ToDataTable <HienThiHoaDon>();
}
}
private void textBoxSearch_TextChanged(object sender, EventArgs e)
{
try
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <HoaDon> hdRepo = new Repository <HoaDon>(dbCxt);
Repository <ChiTietHoaDon> cthdRepo = new Repository <ChiTietHoaDon>(dbCxt);
var searchText = textBoxSearch.Text;
var hoadons = hdRepo.Query(hd =>
hd.Id.ToString().Contains(searchText) ||
hd.KhachHang.SoDienThoai.Contains(searchText) ||
hd.KhachHang.TenKhachHang.Contains(searchText)
).Select(hd => new HienThiHoaDon
{
Id = hd.Id,
NgayLap = hd.NgayLap,
TenKhachHang = hd.KhachHang.TenKhachHang,
TenNhanVien = hd.NhanVien.TenNhanVien
});
dataGridView1.DataSource = hoadons.ToList().ToDataTable <HienThiHoaDon>();
}
if (dataGridView1.Rows.Count > 0 && dataGridView1.Rows != null)
{
labelSearch.Text = "Đã tìm thấy";
}
else
{
labelSearch.Text = "Không tìm thấy...";
}
if (string.IsNullOrWhiteSpace(textBoxSearch.Text))
{
labelSearch.Text = "Tìm kiếm theo: ID hóa đơn, SĐT khách hàng, Tên khách hàng";
}
}
catch (Exception ex)
{
connect.Close();
MessageBox.Show(ex.Message);
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBoxID.Text))
{
MessageBox.Show("Thông tin trống!");
}
else
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <DonViSanPham> dvSpRepo = new Repository <DonViSanPham>(dbCxt);
var dv = dvSpRepo.Get(Guid.Parse(textBoxID.Text));
dv.TenDonViSanPham = textBoxTenDV.Text;
dvSpRepo.Update(dv);
MessageBox.Show("Sửa đơn vị sản phẩm xong.");
}
RefreshGridView();
}
}
private void BanHang_Load(object sender, EventArgs e)
{
try
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository<Data.Models.SanPham> repo = new Repository<Data.Models.SanPham>(dbCxt);
var sp = repo.GetAll().Select(s => s.TenSanPham).ToList();
AutoCompleteStringCollection autotensp = new AutoCompleteStringCollection();
sp.ForEach(tsp => autotensp.Add(tsp));
txttensp.AutoCompleteMode = AutoCompleteMode.Suggest;
txttensp.AutoCompleteSource = AutoCompleteSource.CustomSource;
txttensp.AutoCompleteCustomSource = autotensp;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSua_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBoxID.Text))
{
MessageBox.Show("Thông tin trống!");
}
else
{
using (CuaHangTienLoiDbContext dbCxt = new CuaHangTienLoiDbContext(ClassKetnoi.contextOptions))
{
Repository <LoaiSanPham> loaiSpRepo = new Repository <LoaiSanPham>(dbCxt);
var lsp = loaiSpRepo.Get(Guid.Parse(textBoxID.Text));
lsp.TenLoaiSanPham = textBoxTenLoai.Text;
loaiSpRepo.Update(lsp);
MessageBox.Show("Sửa loại sản phẩm xong.");
}
RefreshGridView();
}
clear();
}
