public BanAn findTableByID(int id)
{
using (var db = new QLCafeEntities())
{
return(db.BanAns.Find(id));
}
}
public List <TaiKhoan> getListAccount()
{
using (var db = new QLCafeEntities())
{
return(db.TaiKhoans.Where(a => a.isDeleted == 0).ToList());
}
}
public List <BanAn> getAllTable()
{
using (var db = new QLCafeEntities())
{
return(db.BanAns.ToList());
}
}
public NguoiQuanLi findManager(int id)
{
using (var db = new QLCafeEntities())
{
return(db.TaiKhoans.Find(id).NguoiQuanLi);
}
}
public List <NhomSanPham> getAllCategory()
{
using (var db = new QLCafeEntities())
{
return(db.NhomSanPhams.Where(c => c.isDeleted == 0).ToList());
}
}
public HoaDon findBillByID(int id)
{
using (var db = new QLCafeEntities())
{
return(db.HoaDons.Find(id));
}
}
public SanPham findProductByID(int id)
{
using (var db = new QLCafeEntities())
{
return(db.SanPhams.Find(id));
}
}
public List <ChiTietBanAn> getTableDetailyByIDFull(int id)
{
using (var db = new QLCafeEntities())
{
return(db.ChiTietBanAns.Where(t => t.MaBan == id).ToList());
}
}
public List <ChiTietHoaDon> findBillDetailByID(int id)
{
using (var db = new QLCafeEntities())
{
return(db.ChiTietHoaDons.Where(d => d.MaHoaDon == id).ToList());
}
}
public TaiKhoan findAccountByID(int id)
{
using (var db = new QLCafeEntities())
{
return(db.TaiKhoans.Find(id));
}
}
public List <TaiKhoan> listAccountSame(string user)
{
using (var db = new QLCafeEntities())
{
return(db.TaiKhoans.Where(a => a.TenDangNhap.ToLower() == user.ToLower()).ToList());
}
}
public void RefreshRevenData()
{
using (var db = new QLCafeEntities())
{
var l = db.HoaDons.Select(d => new { d.MaHoaDon, d.MaTaiKhoan, d.TaiKhoan.NguoiQuanLi.HoTen, d.NgayLapHoaDon, d.TongTien }).ToList();
grvReven.DataSource = l;
}
}
private void RefreshCategoryData()
{
using (var db = new QLCafeEntities())
{
var l = db.NhomSanPhams.Where(c => c.isDeleted == 0).Select(c => new { c.MaNhom, c.TenNhom }).ToList();
grvCategory.DataSource = l;
}
}
public void addBillDetail(ChiTietHoaDon billDetail)
{
using (var db = new QLCafeEntities())
{
db.ChiTietHoaDons.Add(billDetail);
db.SaveChanges();
}
}
private void RefreshAccountData()
{
using (var db = new QLCafeEntities())
{
var nql = db.TaiKhoans.Where(u => u.isDeleted == 0).Select(u => new { u.MaTaiKhoan, u.TenDangNhap, u.MatKhau, u.NguoiQuanLi.HoTen, u.NguoiQuanLi.DiaChi }).ToList();
grvAccount.DataSource = nql;
}
}
private void RefreshFoodData()
{
using (var db = new QLCafeEntities())
{
var l = db.SanPhams.Where(p => p.isDeleted == 0).Select(x => new { x.MaSanPham, x.TenSanPham, x.MoTa, x.GiaBan, x.SoLuong }).ToList();
grvFood.DataSource = l;
}
}
public List <SanPham> getProductByCategoryName(string cname)
{
using (var db = new QLCafeEntities())
{
var l = db.NhomSanPhams.Where(c => c.isDeleted == 0 && c.TenNhom == cname).ToList();
var cid = l[0].MaNhom;
return(db.SanPhams.Where(p => p.isDeleted == 0 && p.MaNhom == cid).ToList());
}
}
public void changePassword(int id, string pass)
{
using (var db = new QLCafeEntities())
{
var acc = db.TaiKhoans.Find(id);
acc.MatKhau = pass;
db.SaveChanges();
}
}
public void removeTableDetail(int tableDetailID)
{
using (var db = new QLCafeEntities())
{
var detail = db.ChiTietBanAns.Find(tableDetailID);
db.ChiTietBanAns.Remove(detail);
db.SaveChanges();
}
}
public void updateTable(int tableId, string status)
{
using (var db = new QLCafeEntities())
{
var table = db.BanAns.Find(tableId);
table.TinhTrang = status;
db.SaveChanges();
}
}
public SanPham findProductByName(string pname)
{
using (var db = new QLCafeEntities())
{
var lp = db.SanPhams.Where(p => p.isDeleted == 0 && p.TenSanPham == pname).ToList();
var product = lp[0];
return(product);
}
}
public int addBill(HoaDon bill)
{
using (var db = new QLCafeEntities())
{
db.HoaDons.Add(bill);
db.SaveChanges();
//MessageBox.Show(bill.MaHoaDon.ToString());
return(bill.MaHoaDon);
}
}
public void updateProductDetail(int tableId, SanPham product, int numProduct)
{
using (var db = new QLCafeEntities())
{
db.ChiTietBanAns.Add(new ChiTietBanAn()
{
MaBan = tableId, MaSanPham = product.MaSanPham, SoLuong = numProduct, DonGia = product.GiaBan
});
db.SaveChanges();
}
}
public void registerNewAccount(string user, string pass, int manager)
{
using (var db = new QLCafeEntities())
{
db.TaiKhoans.Add(new TaiKhoan()
{
TenDangNhap = user, MatKhau = pass, MaNQL = manager, isDeleted = 0
});
db.SaveChanges();
}
}
private void btnAddAccount_Click(object sender, EventArgs e)
{
using (var db = new QLCafeEntities())
{
//kiểm tra xem tài khoản đã tồn tại?
var user = txtUsername.Text;
var listUser = db.TaiKhoans.Where(p => p.isDeleted == 0).Select(p => p.TenDangNhap).ToList();
if (listUser.Contains(user, StringComparer.OrdinalIgnoreCase))
{
MessageBox.Show("Tên đăng nhập đã tồn tại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//kiểm tra NQl đã tồn tại?
//var nql = db.NguoiQuanLis.Where(u => u.HoTen.ToString().ToLower() == txtUsermanagement.Text.ToLower()).ToList(); // err with next data
//var nql = db.NguoiQuanLis.Where(u => u.HoTen.Equals(txtUsermanagement.Text, StringComparison.OrdinalIgnoreCase));
var listUserManagement = db.NguoiQuanLis.ToList();
int uid = -1;
foreach (var index in listUserManagement)
{
if (index.HoTen.ToLower() == txtUsermanagement.Text.ToLower())
{
uid = index.MaNQL;
break;
}
}
if (uid != -1) // đã có người quản lí tài khoản này rồi
{
var nql = db.NguoiQuanLis.Find(uid);
db.TaiKhoans.Add(new TaiKhoan()
{
TenDangNhap = txtUsername.Text, MatKhau = txtPassword.Text, isDeleted = 0, MaNQL = nql.MaNQL
});
}
else // chưa có? tại NQL mới
{
var nql = new NguoiQuanLi()
{
HoTen = txtUsermanagement.Text, CMND = txtCMND.Text, DiaChi = txtAddress.Text, SoDienThoai = txtPhoneNumber.Text
};
db.NguoiQuanLis.Add(nql);
db.TaiKhoans.Add(new TaiKhoan()
{
TenDangNhap = txtUsername.Text, MatKhau = txtPassword.Text, isDeleted = 0, NguoiQuanLi = nql
});
}
db.SaveChanges();
}
MessageBox.Show(String.Format("Thêm thành công tài khoản \"{0}\"!", txtUsername.Text), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshAccountData();
}
private void btnEditCategory_Click(object sender, EventArgs e)
{
var id = int.Parse(grvCategory.CurrentRow.Cells[0].Value.ToString());
using (var db = new QLCafeEntities())
{
var catItem = db.NhomSanPhams.Find(id);
catItem.TenNhom = txtCat.Text;
db.SaveChanges();
}
MessageBox.Show(String.Format("Chỉnh sửa thành công nhóm sản phẩm id = {0} !", id), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshCategoryData();
}
private void grvCategory_SelectionChanged(object sender, EventArgs e)
{
var id = int.Parse(grvCategory.CurrentRow.Cells[0].Value.ToString());
if (id == catID)
{
return;
}
catID = id;
using (var db = new QLCafeEntities())
{
txtCat.Text = db.NhomSanPhams.Find(catID).TenNhom;
}
}
private void btnDeleteAccount_Click(object sender, EventArgs e)
{
var id = int.Parse(grvAccount.CurrentRow.Cells[0].Value.ToString());
var res = MessageBox.Show(String.Format("Bạn chắc chắn muốn xóa tài khoản id = {0} ?", id), "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (res == DialogResult.OK)
{
using (var db = new QLCafeEntities())
{
var taikhoanxoa = db.TaiKhoans.Find(id);
taikhoanxoa.isDeleted = 1;
db.SaveChanges();
}
RefreshAccountData();
}
}
public List <ChiTietBanAnClass> getTableDetailyByID(int id)
{
using (var db = new QLCafeEntities())
{
var lt = db.ChiTietBanAns.Where(t => t.MaBan == id).ToList();
List <ChiTietBanAnClass> listTable = new List <ChiTietBanAnClass>();
foreach (var index in lt)
{
listTable.Add(new ChiTietBanAnClass()
{
MaSanPham = index.MaSanPham, TenSanPham = index.SanPham.TenSanPham, SoLuong = (int)index.SoLuong, DonGia = (double)index.DonGia
});
}
return(listTable);
}
}
private void btnDeleteCategory_Click(object sender, EventArgs e)
{
var id = int.Parse(grvCategory.CurrentRow.Cells[0].Value.ToString());
var res = MessageBox.Show(String.Format("Bạn chắc chắn muốn xóa nhóm sản phẩm id = {0} ?", id), "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (res == DialogResult.OK)
{
using (var db = new QLCafeEntities())
{
var catItem = db.NhomSanPhams.Find(id);
catItem.isDeleted = 1;
db.SaveChanges();
}
RefreshCategoryData();
}
}
