private void btsua1_Click(object sender, EventArgs e)
{
if (!kt())
{
return;
}
try
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
KhachHang kh = quanli.KhachHangs.FirstOrDefault(p => p.MaKH == makhachhang);
kh.TenKH = txttenkh.Text;
kh.DiaChi = txtdiachi.Text;
kh.SDT = int.Parse(txtsdt.Text);
kh.Email = txtemail.Text;
quanli.SaveChanges();
MessageBox.Show("Đã sửa");
kh1_Load(sender, e);
}
}
catch (Exception)
{
MessageBox.Show("Không thể sửa, vui lòng kiểm tra lại!");
return;
}
}
private void btdangnhap_Click(object sender, EventArgs e)
{
using (quanlithucungEntities1 thucung = new quanlithucungEntities1())
{
List <KhachHang> list = thucung.KhachHangs.ToList();
KhachHang kh = thucung.KhachHangs.FirstOrDefault(p => p.TenKH.Trim() == txtten.Text && p.Email.Trim() == txtemail.Text);
if (kh != null)
{
MessageBox.Show("Đăng nhập thành công.");
tenquaform.tenkh = txtten.Text;
Client f = new Client();
this.Hide();
f.ShowDialog();
//f.Ten = tbtk.Text;
//this.Hide();
//f.ShowDialog();
}
else
{
MessageBox.Show("tài khoản mật khẩu không chính xác.Vui lòng nhập lại!");
}
}
}
private void themThucPham()
{
string tenthucpham = cbTen.Text;
using (quanlithucungEntities1 qlthucpham = new quanlithucungEntities1())
{
THUCPHAM tp = qlthucpham.THUCPHAMs.FirstOrDefault(p => p.Tenthucpham.ToLower() == tenthucpham.ToLower());
if (tp == null)
{
qlthucpham.insertCTTP(mapn, int.Parse(txtSoLuong.Text), double.Parse(txtGia.Text), tenthucpham, cbLoai.SelectedValue.ToString(), null, txtdonvi.Text);
qlthucpham.SaveChanges();
MessageBox.Show("Thêm thành công!");
}
else
{
tp.SOLUONG += int.Parse(txtSoLuong.Text);
CTNhapThucPham tpm = new CTNhapThucPham();
tpm.MaPN = mapn;
tpm.MaThucPham = tp.Mathucpham;
tpm.TenThucPham = tp.Tenthucpham;
tpm.MaLoai = cbLoai.SelectedValue.ToString();
tpm.Soluong = int.Parse(txtSoLuong.Text);
tpm.GiaNhap = double.Parse(txtGia.Text);
tpm.DonVi = txtdonvi.Text;
qlthucpham.CTNhapThucPhams.Add(tpm);
qlthucpham.SaveChanges();
MessageBox.Show("Thêm thành công!");
}
}
}
private void themPhuKien()
{
string tenphukien = cbTen.Text;
using (quanlithucungEntities1 quanli = new quanlithucungEntities1()) {
PHUKIEN pk = quanli.PHUKIENs.FirstOrDefault(p => p.Tenphukien.ToLower() == tenphukien.ToLower());
if (pk == null)
{
Console.WriteLine("aa");
quanli.insertCTPK(mapn, int.Parse(txtSoLuong.Text), double.Parse(txtGia.Text), tenphukien, cbLoai.SelectedValue.ToString(), null, txtdonvi.Text);
quanli.SaveChanges();
MessageBox.Show("Thêm thành công");
}
else
{
pk.Soluong += int.Parse(txtSoLuong.Text);
CTNhapPhuKien pkm = new CTNhapPhuKien();
pkm.MaPN = mapn;
pkm.MaPhuKien = pk.Maphukien;
pkm.TenPhuKien = pk.Tenphukien;
pkm.MaLoai = cbLoai.SelectedValue.ToString();
pkm.GiaNhap = double.Parse(txtGia.Text);
pkm.Soluong = int.Parse(txtSoLuong.Text);
pkm.Donvi = txtdonvi.Text;
pkm.Anh = pk.HinhAnh;
quanli.CTNhapPhuKiens.Add(pkm);
quanli.SaveChanges();
MessageBox.Show("Thêm thành công");
}
}
}
private void btnluu_Click(object sender, EventArgs e)
{
if (!kiemtraud())
{
return;
}
try
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
UuDaiHD ud = quanli.UuDaiHDs.FirstOrDefault(p => p.MaUD == makm);
ud.TenUD = txttenud.Text;
ud.NgayBD = tgbdud.Value;
ud.NgayKT = tgktud.Value;
ud.GiamGia = int.Parse(txtgiamgia.Text);
quanli.SaveChanges();
MessageBox.Show("Đã sửa");
loaduudai();
resetud();
}
}
catch (Exception)
{
MessageBox.Show("Không thể sửa, vui lòng kiểm tra lại");
return;
}
}
private void dgvChucvu_CellClick(object sender, DataGridViewCellEventArgs e)
{
them.Text = "Làm mới";
luu.Enabled = true;
txtmacv.Text = dgvChucvu.CurrentRow.Cells[0].Value.ToString();
txttencv.Text = dgvChucvu.CurrentRow.Cells[1].Value.ToString();
txtluong.Text = dgvChucvu.CurrentRow.Cells[2].Value.ToString();
ckbbanhang.Checked = Convert.ToBoolean(dgvChucvu.CurrentRow.Cells[3].Value);
ckbquanlynhanvien.Checked = Convert.ToBoolean(dgvChucvu.CurrentRow.Cells[4].Value);
ckbthongke.Checked = Convert.ToBoolean(dgvChucvu.CurrentRow.Cells[5].Value);
cbkquanlykho.Checked = Convert.ToBoolean(dgvChucvu.CurrentRow.Cells[6].Value);
if (e.ColumnIndex == 7)
{
if (MessageBox.Show("bạn có muốn xóa phiếu nhập này không ?", "xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
ChucVu cv = quanli.ChucVus.FirstOrDefault(p => p.MaCV == txtmacv.Text);
quanli.ChucVus.Remove(cv);
quanli.SaveChanges();
MessageBox.Show("Xóa thành công!");
FrmQuanly_Load(sender, e);
}
}
}
}
private void bunifuCustomDataGrid1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 6)
{
if (MessageBox.Show("bạn có muốn xóa phiếu nhập này không ?", "xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
string mapn = dgvPhieuNhap.CurrentRow.Cells[0].Value.ToString();
quanli.deletePN(mapn);
MessageBox.Show("đã xóa");
FrmPhieuNhap_Load(sender, e);
}
}
}
if (e.ColumnIndex == 5)
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
string mapn = dgvPhieuNhap.CurrentRow.Cells[0].Value.ToString();
FrmCTPhieuNhap ct = new FrmCTPhieuNhap();
ct.mapn = mapn;
ct.FormClosed += thoat;
ct.ShowDialog();
}
}
}
private void btnthem_Click(object sender, EventArgs e)
{
if (!kiemtraud())
{
return;
}
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
UuDaiHD ud = quanli.UuDaiHDs.FirstOrDefault(p => p.TenUD == txttenud.Text.Trim());
if (ud != null)
{
MessageBox.Show("Đã có ưu đãi" + txttenud.Text + "không thể thêm!");
return;
}
try
{
int giamgia = int.Parse(txtgiamgia.Text);
quanli.insertudhd(txttenud.Text, tgbdud.Value, tgktud.Value, giamgia, null);
quanli.SaveChanges();
MessageBox.Show("Đã thêm !!");
loaduudai();
}
catch (Exception)
{
MessageBox.Show("Không thể thêm, vui lòng kiểm tra lại");
return;
}
}
resetud();
}
private void ThongTinHoaDonNhap_Load(object sender, EventArgs e)
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
RPHoaDon report = new RPHoaDon();
DataTable table = new DataTable();
table.Columns.Add("mapn");
table.Columns.Add("ngaylap");
table.Columns.Add("nhanvien");
table.Columns.Add("nhacc");
table.Columns.Add("tensanpham");
table.Columns.Add("soluong");
table.Columns.Add("dongia");
table.Columns.Add("thanhtien");
table.Columns.Add("TongTien");
List <reportPhieuNhap_Result> ds_hoadon = quanli.reportPhieuNhap("PN01").ToList();
foreach (var item in ds_hoadon)
{
table.Rows.Add(item.mapn, item.ngaylap, item.nhanvien, item.nhacc, item.tensanpham, item.soluong, item.dongia, item.thanhtien, item.tongtien);
}
RPHoaDonNhap1.SetDataSource(table);
crystalReportViewer1.ReportSource = RPHoaDonNhap1;
crystalReportViewer1.Show();
}
}
public void loaddulieu()
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
dataGridView1.DataSource = quanli.CTNhapPhuKiens.ToList();
}
}
private void btnluu_Click(object sender, EventArgs e)
{
if (!kiemtra())
{
return;
}
else
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
MD5 mh = MD5.Create();
byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(txtmkmoi.Text);
byte[] hash = mh.ComputeHash(inputBytes);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < hash.Length; i++)
{
sb.Append(hash[i].ToString("X2"));
}
string pass = sb.ToString();
DangNhap lg = quanli.DangNhaps.FirstOrDefault(p => p.UserName == user);
lg.PassWord = pass;
quanli.SaveChanges();
MessageBox.Show("Đổi thành công!");
}
}
}
private void loaddanhmuc()
{
panelDanhMuc.Controls.Clear();
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
List <LoaiThucPham> ds_loaitc = quanli.LoaiThucPhams.ToList();
int i = 0;
foreach (var item in ds_loaitc)
{
BunifuThinButton2 bt = new BunifuThinButton2();
bt.Size = new System.Drawing.Size(98, 45);
bt.TabIndex = i;
bt.ActiveFillColor = System.Drawing.Color.DeepSkyBlue;
bt.ActiveLineColor = System.Drawing.Color.DeepSkyBlue;
bt.IdleForecolor = Color.MidnightBlue;
bt.IdleFillColor = Color.White;
bt.IdleLineColor = System.Drawing.Color.LightSkyBlue;
bt.Name = item.MaLoai;
bt.Click += clickChonDanhMuc;
bt.ButtonText = item.TenLoai.Trim();
bt.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
panelDanhMuc.Controls.Add(bt);
i++;
}
}
//using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
//{
// List<LoaiThuCung> ds_loaithucung = quanli.LoaiThuCungs.ToList();
//}
}
private void btnDatLaiMK_Click(object sender, EventArgs e)
{
if (!kiemtra())
{
return;
}
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
MD5 mh = MD5.Create();
byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(txtMatKhauMoi.Text);
byte[] hash = mh.ComputeHash(inputBytes);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < hash.Length; i++)
{
sb.Append(hash[i].ToString("X2"));
}
string pass = sb.ToString();
DangNhap dn = quanli.DangNhaps.FirstOrDefault(p => p.MaNV == manv);
dn.PassWord = pass;
quanli.SaveChanges();
MessageBox.Show("Đặt lại mật khẩu thành công! Mật khẩu của bạn là: " + txtMatKhauMoi.Text);
this.Close();
}
}
void LoadDanhMuc()
{
panelDanhMuc.Controls.Clear();
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
List <LoaiPhuKien> ds_loaipk = quanli.LoaiPhuKiens.ToList();
int i = 0;
foreach (var item in ds_loaipk)
{
BunifuThinButton2 bt = new BunifuThinButton2();
bt.Size = new System.Drawing.Size(98, 45);
bt.TabIndex = i;
bt.ActiveFillColor = System.Drawing.Color.DeepSkyBlue;
bt.ActiveLineColor = System.Drawing.Color.DeepSkyBlue;
bt.IdleFillColor = Color.White;
bt.IdleForecolor = Color.MidnightBlue;
bt.IdleLineColor = System.Drawing.Color.White;
bt.Text = item.TenLoai.ToUpper();
bt.Name = item.MaLoai;
bt.Click += clickChonDanhMuc;
bt.ButtonText = item.TenLoai.Trim();
bt.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
panelDanhMuc.Controls.Add(bt);
i++;
}
}
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
List <LoaiPhuKien> ds_phukien = quanli.LoaiPhuKiens.ToList();
}
}
private void btnthanhtoan_Click(object sender, EventArgs e)
{
if (dgvDichvu.Rows.Count == 0)
{
MessageBox.Show("Chưa có hóa đơn để thanh toán");
return;
}
try
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
HoaDon hd = quanli.HoaDons.FirstOrDefault(p => p.MaHD == cbHoaDon.Text);
hd.TrangThai = true;
quanli.SaveChanges();
MessageBox.Show("Thanh toán thành công!");
FrmDichVu_Load(sender, e);
cbchuathanhtoan.Text = null;
btnthanhtoan.Enabled = false;
btnthem.Enabled = true;
txttendichvu.Text = "";
txtdongia.Text = "";
return;
}
}
catch (Exception)
{
MessageBox.Show("Xin lỗi, không thể thanh toán");
return;
}
}
private void btnXem_Click(object sender, EventArgs e)
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
DataTable table = new DataTable();
table.Columns.Add("mapn");
table.Columns.Add("ngaylap");
table.Columns.Add("nhanvien");
table.Columns.Add("nhacc");
table.Columns.Add("tensanpham");
table.Columns.Add("soluong");
table.Columns.Add("dongia");
table.Columns.Add("thanhtien");
table.Columns.Add("tongtien");
List <reportPhieuNhap_Result> ds_hoadon = quanli.reportPhieuNhap(comboBox1.SelectedValue.ToString()).ToList();
foreach (var item in ds_hoadon)
{
table.Rows.Add(item.mapn, item.ngaylap, item.nhanvien, item.nhacc, item.tensanpham, item.soluong, item.dongia, item.thanhtien, item.tongtien);
}
RPHoaDonNhap2.SetDataSource(table);
crystalReportViewer1.ReportSource = RPHoaDonNhap2;
crystalReportViewer1.Show();
}
}
private void btnthanhtoan_Click(object sender, EventArgs e)
{
if (dgvThucPham.Rows.Count == 0)
{
MessageBox.Show("Chưa có hóa đơn để thanh toán");
return;
}
try
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
HoaDon hd = quanli.HoaDons.FirstOrDefault(p => p.MaHD == txtmahoadon.Text);
hd.TrangThai = true;
quanli.SaveChanges();
MessageBox.Show("Thanh toán thành công!");
Formbanhthuong_Load(sender, e);
cbchuathanhtoan.Text = "";
txttenthucpham.Text = "";
txtdongia.Text = "";
btnthanhtoan.Enabled = false;
btnthem.Enabled = true;
return;
}
}
catch (Exception)
{
MessageBox.Show("Không thể thanh toán, vui lòng kiểm tra lại!");
return;
}
}
private void btnluu_Click(object sender, EventArgs e)
{
if (dgvDichvu.Rows.Count == 0)
{
MessageBox.Show("Chưa có thông tin để lưu");
return;
}
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
HoaDon hd = quanli.HoaDons.FirstOrDefault(p => p.MaHD == cbHoaDon.Text);
if (hd == null)
{
hd = new HoaDon();
hd.MaHD = cbHoaDon.Text;
hd.UserName = null;
hd.ThoiGianLap = DateTime.Now.Date;
hd.TrangThai = false;
quanli.HoaDons.Add(hd);
quanli.SaveChanges();
}
else
{
hd.TrangThai = false;
}
if (txtuudai.Text != "0")
{
CTUuDai ct = quanli.CTUuDais.FirstOrDefault(p => p.MaHD == cbHoaDon.Text);
if (ct != null)
{
MessageBox.Show("Hóa đơn này đã có ưu đãi");
return;
}
CTUuDai ud = new CTUuDai();
ud.MaHD = cbHoaDon.Text;
ud.MaUD = maud;
Console.WriteLine(maud);
quanli.CTUuDais.Add(ud);
quanli.SaveChanges();
}
foreach (DataGridViewRow rows in dgvDichvu.Rows)
{
string madichvu = rows.Cells["madichvu"].Value.ToString();
int sl = int.Parse(rows.Cells["soluong"].Value.ToString());
CTDichVu ct = new CTDichVu();
ct.MaHD = cbHoaDon.Text;
ct.MaDV = madichvu;
ct.SoDV = sl;
quanli.CTDichVus.Add(ct);
quanli.SaveChanges();
}
MessageBox.Show("Lưu thành công!");
loadhdchuathanhtoan();
btnthem.Enabled = false;
btnluu.Enabled = false;
btnthanhtoan.Enabled = true;
return;
}
}
public void loaddulieu()
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
dgvNhapThuCung.DataSource = quanli.CTNhapThuCungs.ToList();
}
}
private void Mèotaicụp_Load(object sender, EventArgs e)
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
// label1.Text = quanli.ThuCungs.Where(p => p.MaThuCung == );
}
}
public void loadnhanvien()
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
List <NhanVien> ds_nhanvien = quanli.NhanViens.ToList();
DataTable table = new DataTable();
table.Columns.Add("MaNV");
table.Columns.Add("tennv");
table.Columns.Add("diachi");
table.Columns.Add("cmnd");
table.Columns.Add("sdt");
table.Columns.Add("chucvu");
table.Columns.Add("gmail");
foreach (NhanVien item in ds_nhanvien)
{
string chucvu = "";
if (item.MaCV == null)
{
chucvu = "rỗng";
}
else
{
chucvu = quanli.ChucVus.FirstOrDefault(p => p.MaCV == item.MaCV).TenCV;
}
table.Rows.Add(item.MaNV, item.TenNV, item.CMND, item.DiaChi, item.sodienthoai, chucvu, item.Gmail);
}
dgvnhanvien.AutoGenerateColumns = false;
dgvnhanvien.DataSource = table;
}
}
public void phanquyen()
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
string manv = quanli.DangNhaps.FirstOrDefault(p => p.UserName == user.Trim()).MaNV;
string macv = quanli.NhanViens.FirstOrDefault(p => p.MaNV == manv).MaCV;
ChucVu cv = quanli.ChucVus.FirstOrDefault(p => p.MaCV == macv);
Console.WriteLine(manv);
Console.WriteLine(macv);
Console.WriteLine(cv.BanHang);
if (cv.BanHang == false)
{
banhang = false;
}
if (cv.Thongke == false)
{
thongke = false;
}
if (cv.Quanlykho == false)
{
quanlykho = false;
}
if (cv.Quanlynhanvien == false)
{
quanlinhanvien = false;
}
if (cv.BanHang == true && cv.Quanlynhanvien == true && cv.Thongke == true && cv.Quanlykho == true)
{
admin = true;
}
//else
//{
// panelMain.Controls.Clear();
// panelMain.Controls.Add(new FrmThuCUng());
// dem++;dem1++;
// if(dem == 0)
// {
// panelMain.Controls.Clear();
// panelMain.Controls.Add(new Frmthucpham());
// }
// if (dem1 == 0)
// {
// panelMain.Controls.Clear();
// panelMain.Controls.Add(new Frmphukien());
// }
//}
//if (cv.Thongke == false)
//{
// btnThongKe.Click += new EventHandler(ttnhanvien);
//}
//else
//{
// if (dem == 0)
// {
// }
//}
}
}
private void loadhoadon()
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
cbHoaDon.DataSource = quanli.HoaDons.ToList();
cbHoaDon.DisplayMember = "MaHD";
}
}
private void kh1_Load(object sender, EventArgs e)
{
dataGridView1.AutoGenerateColumns = false;
using (quanlithucungEntities1 thucung = new quanlithucungEntities1())
{
dataGridView1.DataSource = thucung.KhachHangs.ToList();
}
}
private void loadLuongThang()
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
dgvLuong.AutoGenerateColumns = false;
dgvLuong.DataSource = quanli.LuongTungThangs.ToList();
}
}
public void loadtp()
{
dgvThuongPhat.AutoGenerateColumns = false;
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
dgvThuongPhat.DataSource = quanli.ThuongPhats.ToList();
}
}
private void loadhd()
{
dgvHoaDon.AutoGenerateColumns = false;
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
dgvHoaDon.DataSource = quanli.HoaDons.ToList();
}
}
private void Formnhacungcap_Load(object sender, EventArgs e)
{
dgvNhacc.AutoGenerateColumns = false;
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
Console.WriteLine(quanli.NhaCungCaps.ToList().Count);
dgvNhacc.DataSource = quanli.NhaCungCaps.ToList();
}
}
private void guimail_Load(object sender, EventArgs e)
{
using (quanlithucungEntities1 thucung = new quanlithucungEntities1())
{
comboBox1.DisplayMember = "TenUD";
comboBox1.ValueMember = "MaUD";
comboBox1.DataSource = thucung.selectalluudai();
}
}
private void loadLoaiThuCung()
{
using (quanlithucungEntities1 quanli = new quanlithucungEntities1())
{
cbLoaiThuCung.DataSource = quanli.LoaiThuCungs.ToList();
cbLoaiThuCung.DisplayMember = "TenLoai";
cbLoaiThuCung.ValueMember = "MaLoai";
}
}