Thêm, xóa, sửa thức ăn trong phần mềm Quản lý quán cafe với C# Winform
Lập trình phần mềm Quản lý quán cafe với C# Winform
0.0 (0 đánh giá)
Tác giả/Dịch giả:
HowKteam
Học nhanh
HowKteam
Danh sách bài học
Thêm, xóa, sửa thức ăn trong phần mềm Quản lý quán cafe với C# Winform
Không có gì tuyệt vời hơn là luyện tập với ví dụ thực tế. Nào cùng nhau thử thách bản thân với phần mềm: Quản lý quán cafe
Bạn nên có kiến thức về:
- Lập trình Winform cơ bản
- Delegate – Event
- SQL server
- Xử lý ngày tháng năm
Code data.sql
CREATE DATABASE QuanLyQuanCafe
GO
USE QuanLyQuanCafe
GO
-- Food
-- Table
-- FoodCategory
-- Account
-- Bill
-- BillInfo
CREATE TABLE TableFood
(
id INT IDENTITY PRIMARY KEY,
name NVARCHAR(100) NOT NULL DEFAULT N'Bàn chưa có tên',
status NVARCHAR(100) NOT NULL DEFAULT N'Trống' -- Trống || Có người
)
GO
CREATE TABLE Account
(
UserName NVARCHAR(100) PRIMARY KEY,
DisplayName NVARCHAR(100) NOT NULL DEFAULT N'Kter',
PassWord NVARCHAR(1000) NOT NULL DEFAULT 0,
Type INT NOT NULL DEFAULT 0 -- 1: admin && 0: staff
)
GO
CREATE TABLE FoodCategory
(
id INT IDENTITY PRIMARY KEY,
name NVARCHAR(100) NOT NULL DEFAULT N'Chưa đặt tên'
)
GO
CREATE TABLE Food
(
id INT IDENTITY PRIMARY KEY,
name NVARCHAR(100) NOT NULL DEFAULT N'Chưa đặt tên',
idCategory INT NOT NULL,
price FLOAT NOT NULL DEFAULT 0
FOREIGN KEY (idCategory) REFERENCES dbo.FoodCategory(id)
)
GO
CREATE TABLE Bill
(
id INT IDENTITY PRIMARY KEY,
DateCheckIn DATE NOT NULL DEFAULT GETDATE(),
DateCheckOut DATE,
idTable INT NOT NULL,
status INT NOT NULL DEFAULT 0 -- 1: đã thanh toán && 0: chưa thanh toán
FOREIGN KEY (idTable) REFERENCES dbo.TableFood(id)
)
GO
CREATE TABLE BillInfo
(
id INT IDENTITY PRIMARY KEY,
idBill INT NOT NULL,
idFood INT NOT NULL,
count INT NOT NULL DEFAULT 0
FOREIGN KEY (idBill) REFERENCES dbo.Bill(id),
FOREIGN KEY (idFood) REFERENCES dbo.Food(id)
)
GO
INSERT INTO dbo.Account
( UserName ,
DisplayName ,
PassWord ,
Type
)
VALUES ( N'K9' , -- UserName - nvarchar(100)
N'RongK9' , -- DisplayName - nvarchar(100)
N'1' , -- PassWord - nvarchar(1000)
1 -- Type - int
)
INSERT INTO dbo.Account
( UserName ,
DisplayName ,
PassWord ,
Type
)
VALUES ( N'staff' , -- UserName - nvarchar(100)
N'staff' , -- DisplayName - nvarchar(100)
N'1' , -- PassWord - nvarchar(1000)
0 -- Type - int
)
GO
CREATE PROC USP_GetAccountByUserName
@userName nvarchar(100)
AS
BEGIN
SELECT * FROM dbo.Account WHERE UserName = @userName
END
GO
EXEC dbo.USP_GetAccountByUserName @userName = N'k9' -- nvarchar(100)
GO
CREATE PROC USP_Login
@userName nvarchar(100), @passWord nvarchar(100)
AS
BEGIN
SELECT * FROM dbo.Account WHERE UserName = @userName AND PassWord = @passWord
END
GO
-- thêm bàn
DECLARE @i INT = 0
WHILE @i <= 10
BEGIN
INSERT dbo.TableFood ( name)VALUES ( N'Bàn ' + CAST(@i AS nvarchar(100)))
SET @i = @i + 1
END
GO
CREATE PROC USP_GetTableList
AS SELECT * FROM dbo.TableFood
GO
UPDATE dbo.TableFood SET STATUS = N'Có người' WHERE id = 9
EXEC dbo.USP_GetTableList
GO
-- thêm category
INSERT dbo.FoodCategory
( name )
VALUES ( N'Hải sản' -- name - nvarchar(100)
)
INSERT dbo.FoodCategory
( name )
VALUES ( N'Nông sản' )
INSERT dbo.FoodCategory
( name )
VALUES ( N'Lâm sản' )
INSERT dbo.FoodCategory
( name )
VALUES ( N'Sản sản' )
INSERT dbo.FoodCategory
( name )
VALUES ( N'Nước' )
-- thêm món ăn
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Mực một nắng nước sa tế', -- name - nvarchar(100)
1, -- idCategory - int
120000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Nghêu hấp xả', 1, 50000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Dú dê nướng sữa', 2, 60000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Heo rừng nướng muối ớt', 3, 75000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Cơm chiên mushi', 4, 999999)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'7Up', 5, 15000)
INSERT dbo.Food
( name, idCategory, price )
VALUES ( N'Cafe', 5, 12000)
-- thêm bill
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
3 , -- idTable - int
0 -- status - int
)
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
4, -- idTable - int
0 -- status - int
)
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
GETDATE() , -- DateCheckOut - date
5 , -- idTable - int
1 -- status - int
)
-- thêm bill info
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 5, -- idBill - int
1, -- idFood - int
2 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 5, -- idBill - int
3, -- idFood - int
4 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 5, -- idBill - int
5, -- idFood - int
1 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 6, -- idBill - int
1, -- idFood - int
2 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 6, -- idBill - int
6, -- idFood - int
2 -- count - int
)
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( 7, -- idBill - int
5, -- idFood - int
2 -- count - int
)
GO
CREATE PROC USP_InsertBill
@idTable INT
AS
BEGIN
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status,
discount
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
@idTable , -- idTable - int
0, -- status - int
0
)
END
GO
CREATE PROC USP_InsertBillInfo
@idBill INT, @idFood INT, @count INT
AS
BEGIN
DECLARE @isExitsBillInfo INT
DECLARE @foodCount INT = 1
SELECT @isExitsBillInfo = id, @foodCount = b.count
FROM dbo.BillInfo AS b
WHERE idBill = @idBill AND idFood = @idFood
IF (@isExitsBillInfo > 0)
BEGIN
DECLARE @newCount INT = @foodCount + @count
IF (@newCount > 0)
UPDATE dbo.BillInfo SET count = @foodCount + @count WHERE idFood = @idFood
ELSE
DELETE dbo.BillInfo WHERE idBill = @idBill AND idFood = @idFood
END
ELSE
BEGIN
INSERT dbo.BillInfo
( idBill, idFood, count )
VALUES ( @idBill, -- idBill - int
@idFood, -- idFood - int
@count -- count - int
)
END
END
GO
DELETE dbo.BillInfo
DELETE dbo.Bill
CREATE TRIGGER UTG_UpdateBillInfo
ON dbo.BillInfo FOR INSERT, UPDATE
AS
BEGIN
DECLARE @idBill INT
SELECT @idBill = idBill FROM Inserted
DECLARE @idTable INT
SELECT @idTable = idTable FROM dbo.Bill WHERE id = @idBill AND status = 0
DECLARE @count INT
SELECT @count = COUNT(*) FROM dbo.BillInfo WHERE idBill = @idBill
IF (@count > 0)
BEGIN
PRINT @idTable
PRINT @idBill
PRINT @count
UPDATE dbo.TableFood SET status = N'Có người' WHERE id = @idTable
END
ELSE
BEGIN
PRINT @idTable
PRINT @idBill
PRINT @count
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable
end
END
GO
CREATE TRIGGER UTG_UpdateBill
ON dbo.Bill FOR UPDATE
AS
BEGIN
DECLARE @idBill INT
SELECT @idBill = id FROM Inserted
DECLARE @idTable INT
SELECT @idTable = idTable FROM dbo.Bill WHERE id = @idBill
DECLARE @count int = 0
SELECT @count = COUNT(*) FROM dbo.Bill WHERE idTable = @idTable AND status = 0
IF (@count = 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable
END
GO
ALTER TABLE dbo.Bill
ADD discount INT
UPDATE dbo.Bill SET discount = 0
GO
CREATE PROC USP_SwitchTabel
@idTable1 INT, @idTable2 int
AS BEGIN
DECLARE @idFirstBill int
DECLARE @idSeconrdBill INT
DECLARE @isFirstTablEmty INT = 1
DECLARE @isSecondTablEmty INT = 1
SELECT @idSeconrdBill = id FROM dbo.Bill WHERE idTable = @idTable2 AND status = 0
SELECT @idFirstBill = id FROM dbo.Bill WHERE idTable = @idTable1 AND status = 0
PRINT @idFirstBill
PRINT @idSeconrdBill
PRINT '-----------'
IF (@idFirstBill IS NULL)
BEGIN
PRINT '0000001'
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
@idTable1 , -- idTable - int
0 -- status - int
)
SELECT @idFirstBill = MAX(id) FROM dbo.Bill WHERE idTable = @idTable1 AND status = 0
END
SELECT @isFirstTablEmty = COUNT(*) FROM dbo.BillInfo WHERE idBill = @idFirstBill
PRINT @idFirstBill
PRINT @idSeconrdBill
PRINT '-----------'
IF (@idSeconrdBill IS NULL)
BEGIN
PRINT '0000002'
INSERT dbo.Bill
( DateCheckIn ,
DateCheckOut ,
idTable ,
status
)
VALUES ( GETDATE() , -- DateCheckIn - date
NULL , -- DateCheckOut - date
@idTable2 , -- idTable - int
0 -- status - int
)
SELECT @idSeconrdBill = MAX(id) FROM dbo.Bill WHERE idTable = @idTable2 AND status = 0
END
SELECT @isSecondTablEmty = COUNT(*) FROM dbo.BillInfo WHERE idBill = @idSeconrdBill
PRINT @idFirstBill
PRINT @idSeconrdBill
PRINT '-----------'
SELECT id INTO IDBillInfoTable FROM dbo.BillInfo WHERE idBill = @idSeconrdBill
UPDATE dbo.BillInfo SET idBill = @idSeconrdBill WHERE idBill = @idFirstBill
UPDATE dbo.BillInfo SET idBill = @idFirstBill WHERE id IN (SELECT * FROM IDBillInfoTable)
DROP TABLE IDBillInfoTable
IF (@isFirstTablEmty = 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable2
IF (@isSecondTablEmty= 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable1
END
GO
ALTER TABLE dbo.Bill ADD totalPrice FLOAT
DELETE dbo.BillInfo
DELETE dbo.Bill
GO
CREATE PROC USP_GetListBillByDate
@checkIn date, @checkOut date
AS
BEGIN
SELECT t.name AS [Tên bàn], b.totalPrice AS [Tổng tiền], DateCheckIn AS [Ngày vào], DateCheckOut AS [Ngày ra], discount AS [Giảm giá]
FROM dbo.Bill AS b,dbo.TableFood AS t
WHERE DateCheckIn >= @checkIn AND DateCheckOut <= @checkOut AND b.status = 1
AND t.id = b.idTable
END
GO
CREATE PROC USP_UpdateAccount
@userName NVARCHAR(100), @displayName NVARCHAR(100), @password NVARCHAR(100), @newPassword NVARCHAR(100)
AS
BEGIN
DECLARE @isRightPass INT = 0
SELECT @isRightPass = COUNT(*) FROM dbo.Account WHERE USERName = @userName AND PassWord = @password
IF (@isRightPass = 1)
BEGIN
IF (@newPassword = NULL OR @newPassword = '')
BEGIN
UPDATE dbo.Account SET DisplayName = @displayName WHERE UserName = @userName
END
ELSE
UPDATE dbo.Account SET DisplayName = @displayName, PassWord = @newPassword WHERE UserName = @userName
end
END
GO
CREATE TRIGGER UTG_DeleteBillInfo
ON dbo.BillInfo FOR DELETE
AS
BEGIN
DECLARE @idBillInfo INT
DECLARE @idBill INT
SELECT @idBillInfo = id, @idBill = Deleted.idBill FROM Deleted
DECLARE @idTable INT
SELECT @idTable = idTable FROM dbo.Bill WHERE id = @idBill
DECLARE @count INT = 0
SELECT @count = COUNT(*) FROM dbo.BillInfo AS bi, dbo.Bill AS b WHERE b.id = bi.idBill AND b.id = @idBill AND b.status = 0
IF (@count = 0)
UPDATE dbo.TableFood SET status = N'Trống' WHERE id = @idTable
END
GO
Code fTableManager.cs
using QuanLyQuanCafe.DAO;
using QuanLyQuanCafe.DTO;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace QuanLyQuanCafe
{
public partial class fTableManager : Form
{
private Account loginAccount;
public Account LoginAccount
{
get { return loginAccount; }
set { loginAccount = value; ChangeAccount(loginAccount.Type); }
}
public fTableManager(Account acc)
{
InitializeComponent();
this.LoginAccount = acc;
LoadTable();
LoadCategory();
LoadComboboxTable(cbSwitchTable);
}
#region Method
void ChangeAccount(int type)
{
adminToolStripMenuItem.Enabled = type == 1;
thôngTinTàiKhoảnToolStripMenuItem.Text += " (" + LoginAccount.DisplayName + ")";
}
void LoadCategory()
{
List<Category> listCategory = CategoryDAO.Instance.GetListCategory();
cbCategory.DataSource = listCategory;
cbCategory.DisplayMember = "Name";
}
void LoadFoodListByCategoryID(int id)
{
List<Food> listFood = FoodDAO.Instance.GetFoodByCategoryID(id);
cbFood.DataSource = listFood;
cbFood.DisplayMember = "Name";
}
void LoadTable()
{
flpTable.Controls.Clear();
List<Table> tableList = TableDAO.Instance.LoadTableList();
foreach (Table item in tableList)
{
Button btn = new Button() { Width = TableDAO.TableWidth, Height = TableDAO.TableHeight};
btn.Text = item.Name + Environment.NewLine + item.Status;
btn.Click += btn_Click;
btn.Tag = item;
switch (item.Status)
{
case "Trống":
btn.BackColor = Color.Aqua;
break;
default:
btn.BackColor = Color.LightPink;
break;
}
flpTable.Controls.Add(btn);
}
}
void ShowBill(int id)
{
lsvBill.Items.Clear();
List<QuanLyQuanCafe.DTO.Menu> listBillInfo = MenuDAO.Instance.GetListMenuByTable(id);
float totalPrice = 0;
foreach (QuanLyQuanCafe.DTO.Menu item in listBillInfo)
{
ListViewItem lsvItem = new ListViewItem(item.FoodName.ToString());
lsvItem.SubItems.Add(item.Count.ToString());
lsvItem.SubItems.Add(item.Price.ToString());
lsvItem.SubItems.Add(item.TotalPrice.ToString());
totalPrice += item.TotalPrice;
lsvBill.Items.Add(lsvItem);
}
CultureInfo culture = new CultureInfo("vi-VN");
//Thread.CurrentThread.CurrentCulture = culture;
txbTotalPrice.Text = totalPrice.ToString("c", culture);
}
void LoadComboboxTable(ComboBox cb)
{
cb.DataSource = TableDAO.Instance.LoadTableList();
cb.DisplayMember = "Name";
}
#endregion
#region Events
void btn_Click(object sender, EventArgs e)
{
int tableID = ((sender as Button).Tag as Table).ID;
lsvBill.Tag = (sender as Button).Tag;
ShowBill(tableID);
}
private void đăngXuấtToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Close();
}
private void thôngTinCáNhânToolStripMenuItem_Click(object sender, EventArgs e)
{
fAccountProfile f = new fAccountProfile(LoginAccount);
f.UpdateAccount += f_UpdateAccount;
f.ShowDialog();
}
void f_UpdateAccount(object sender, AccountEvent e)
{
thôngTinTàiKhoảnToolStripMenuItem.Text = "Thông tin tài khoản (" + e.Acc.DisplayName + ")";
}
private void adminToolStripMenuItem_Click(object sender, EventArgs e)
{
fAdmin f = new fAdmin();
f.InsertFood += f_InsertFood;
f.DeleteFood += f_DeleteFood;
f.UpdateFood += f_UpdateFood;
f.ShowDialog();
}
void f_UpdateFood(object sender, EventArgs e)
{
LoadFoodListByCategoryID((cbCategory.SelectedItem as Category).ID);
if (lsvBill.Tag != null)
ShowBill((lsvBill.Tag as Table).ID);
}
void f_DeleteFood(object sender, EventArgs e)
{
LoadFoodListByCategoryID((cbCategory.SelectedItem as Category).ID);
if (lsvBill.Tag != null)
ShowBill((lsvBill.Tag as Table).ID);
LoadTable();
}
void f_InsertFood(object sender, EventArgs e)
{
LoadFoodListByCategoryID((cbCategory.SelectedItem as Category).ID);
if (lsvBill.Tag != null)
ShowBill((lsvBill.Tag as Table).ID);
}
private void cbCategory_SelectedIndexChanged(object sender, EventArgs e)
{
int id = 0;
ComboBox cb = sender as ComboBox;
if (cb.SelectedItem == null)
return;
Category selected = cb.SelectedItem as Category;
id = selected.ID;
LoadFoodListByCategoryID(id);
}
private void btnAddFood_Click(object sender, EventArgs e)
{
Table table = lsvBill.Tag as Table;
if (table == null)
{
MessageBox.Show("Hãy chọn bàn");
return;
}
int idBill = BillDAO.Instance.GetUncheckBillIDByTableID(table.ID);
int foodID = (cbFood.SelectedItem as Food).ID;
int count = (int)nmFoodCount.Value;
if (idBill == -1)
{
BillDAO.Instance.InsertBill(table.ID);
BillInfoDAO.Instance.InsertBillInfo(BillDAO.Instance.GetMaxIDBill(), foodID , count);
}
else
{
BillInfoDAO.Instance.InsertBillInfo(idBill, foodID, count);
}
ShowBill(table.ID);
LoadTable();
}
private void btnCheckOut_Click(object sender, EventArgs e)
{
Table table = lsvBill.Tag as Table;
int idBill = BillDAO.Instance.GetUncheckBillIDByTableID(table.ID);
int discount = (int)nmDisCount.Value;
double totalPrice = Convert.ToDouble(txbTotalPrice.Text.Split(',')[0]);
double finalTotalPrice = totalPrice - (totalPrice/100)*discount;
if (idBill != -1)
{
if (MessageBox.Show(string.Format("Bạn có chắc thanh toán hóa đơn cho bàn {0}\nTổng tiền - (Tổng tiền / 100) x Giảm giá\n=> {1} - ({1} / 100) x {2} = {3}",table.Name, totalPrice, discount, finalTotalPrice), "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
BillDAO.Instance.CheckOut(idBill, discount, (float)finalTotalPrice);
ShowBill(table.ID);
LoadTable();
}
}
}
private void btnSwitchTable_Click(object sender, EventArgs e)
{
int id1 = (lsvBill.Tag as Table).ID;
int id2 = (cbSwitchTable.SelectedItem as Table).ID;
if (MessageBox.Show(string.Format("Bạn có thật sự muốn chuyển bàn {0} qua bàn {1}", (lsvBill.Tag as Table).Name, (cbSwitchTable.SelectedItem as Table).Name), "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
TableDAO.Instance.SwitchTable(id1, id2);
LoadTable();
}
}
#endregion
}
}
Code FoodDAO.cs
using QuanLyQuanCafe.DTO;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace QuanLyQuanCafe.DAO
{
public class FoodDAO
{
private static FoodDAO instance;
public static FoodDAO Instance
{
get { if (instance == null)instance = new FoodDAO(); return FoodDAO.instance; }
private set { FoodDAO.instance = value; }
}
private FoodDAO() { }
public List<Food> GetFoodByCategoryID(int id)
{
List<Food> list = new List<Food>();
string query = "select * from Food where idCategory = " + id;
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Food food = new Food(item);
list.Add(food);
}
return list;
}
public List<Food> GetListFood()
{
List<Food> list = new List<Food>();
string query = "select * from Food";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Food food = new Food(item);
list.Add(food);
}
return list;
}
public bool InsertFood(string name, int id, float price)
{
string query = string.Format("INSERT dbo.Food ( name, idCategory, price )VALUES ( N'{0}', {1}, {2})", name, id, price);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return result > 0;
}
public bool UpdateFood(int idFood, string name, int id, float price)
{
string query = string.Format("UPDATE dbo.Food SET name = N'{0}', idCategory = {1}, price = {2} WHERE id = {3}", name, id, price, idFood);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return result > 0;
}
public bool DeleteFood(int idFood)
{
BillInfoDAO.Instance.DeleteBillInfoByFoodID(idFood);
string query = string.Format("Delete Food where id = {0}",idFood);
int result = DataProvider.Instance.ExecuteNonQuery(query);
return result > 0;
}
}
}
Code BillDAO.cs
using QuanLyQuanCafe.DTO;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace QuanLyQuanCafe.DAO
{
public class BillDAO
{
private static BillDAO instance;
public static BillDAO Instance
{
get { if (instance == null) instance = new BillDAO(); return BillDAO.instance; }
private set { BillDAO.instance = value; }
}
private BillDAO() { }
/// <summary>
/// Thành công: bill ID
/// thất bại: -1
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int GetUncheckBillIDByTableID(int id)
{
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.Bill WHERE idTable = " + id +" AND status = 0");
if (data.Rows.Count > 0)
{
Bill bill = new Bill(data.Rows[0]);
return bill.ID;
}
return -1;
}
public void CheckOut(int id, int discount, float totalPrice)
{
string query = "UPDATE dbo.Bill SET dateCheckOut = GETDATE(), status = 1, " + "discount = " + discount + ", totalPrice = " + totalPrice + " WHERE id = " + id;
DataProvider.Instance.ExecuteNonQuery(query);
}
public void InsertBill(int id)
{
DataProvider.Instance.ExecuteNonQuery("exec USP_InsertBill @idTable", new object[]{id});
}
public DataTable GetBillListByDate(DateTime checkIn, DateTime checkOut)
{
return DataProvider.Instance.ExecuteQuery("exec USP_GetListBillByDate @checkIn , @checkOut", new object[]{checkIn, checkOut});
}
public int GetMaxIDBill()
{
try
{
return (int)DataProvider.Instance.ExecuteScalar("SELECT MAX(id) FROM dbo.Bill");
}
catch
{
return 1;
}
}
}
}
Code fLogin.cs
using QuanLyQuanCafe.DAO;
using QuanLyQuanCafe.DTO;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace QuanLyQuanCafe
{
public partial class fLogin : Form
{
public fLogin()
{
InitializeComponent();
}
private void btnLogin_Click(object sender, EventArgs e)
{
string userName = txbUserName.Text;
string passWord = txbPassWord.Text;
if (Login(userName, passWord))
{
Account loginAccount = AccountDAO.Instance.GetAccountByUserName(userName);
fTableManager f = new fTableManager(loginAccount);
this.Hide();
f.ShowDialog();
this.Show();
}
else
{
MessageBox.Show("Sai tên tài khoản hoặc mật khẩu!");
}
}
bool Login(string userName, string passWord)
{
return AccountDAO.Instance.Login(userName, passWord);
}
private void btnExit_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void fLogin_FormClosing(object sender, FormClosingEventArgs e)
{
if (MessageBox.Show("Bạn có thật sự muốn thoát chương trình?", "Thông báo", MessageBoxButtons.OKCancel) != System.Windows.Forms.DialogResult.OK)
{
e.Cancel = true;
}
}
}
}
Code fAdmin.Designer.cs
namespace QuanLyQuanCafe
{
partial class fAdmin
{
/// <summary>
/// Required designer variable.
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// Clean up any resources being used.
/// </summary>
/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows Form Designer generated code
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.tcAdmin = new System.Windows.Forms.TabControl();
this.tpBill = new System.Windows.Forms.TabPage();
this.panel2 = new System.Windows.Forms.Panel();
this.btnViewBill = new System.Windows.Forms.Button();
this.dtpkToDate = new System.Windows.Forms.DateTimePicker();
this.dtpkFromDate = new System.Windows.Forms.DateTimePicker();
this.panel1 = new System.Windows.Forms.Panel();
this.dtgvBill = new System.Windows.Forms.DataGridView();
this.tpFood = new System.Windows.Forms.TabPage();
this.panel6 = new System.Windows.Forms.Panel();
this.txbSearchFoodName = new System.Windows.Forms.TextBox();
this.btnSearchFood = new System.Windows.Forms.Button();
this.panel5 = new System.Windows.Forms.Panel();
this.panel10 = new System.Windows.Forms.Panel();
this.nmFoodPrice = new System.Windows.Forms.NumericUpDown();
this.label4 = new System.Windows.Forms.Label();
this.panel9 = new System.Windows.Forms.Panel();
this.cbFoodCategory = new System.Windows.Forms.ComboBox();
this.label3 = new System.Windows.Forms.Label();
this.panel8 = new System.Windows.Forms.Panel();
this.txbFoodName = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.panel7 = new System.Windows.Forms.Panel();
this.txbFoodID = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.panel4 = new System.Windows.Forms.Panel();
this.btnShowFood = new System.Windows.Forms.Button();
this.btnEditFood = new System.Windows.Forms.Button();
this.btnDeleteFood = new System.Windows.Forms.Button();
this.btnAddFood = new System.Windows.Forms.Button();
this.panel3 = new System.Windows.Forms.Panel();
this.dtgvFood = new System.Windows.Forms.DataGridView();
this.tbFoodCategory = new System.Windows.Forms.TabPage();
this.panel12 = new System.Windows.Forms.Panel();
this.panel15 = new System.Windows.Forms.Panel();
this.textBox2 = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.panel16 = new System.Windows.Forms.Panel();
this.txbCategoryID = new System.Windows.Forms.TextBox();
this.label8 = new System.Windows.Forms.Label();
this.panel17 = new System.Windows.Forms.Panel();
this.btnShowCategory = new System.Windows.Forms.Button();
this.btnEditCategory = new System.Windows.Forms.Button();
this.btnDeleteCategory = new System.Windows.Forms.Button();
this.btnAddCategory = new System.Windows.Forms.Button();
this.panel18 = new System.Windows.Forms.Panel();
this.dtgvCategory = new System.Windows.Forms.DataGridView();
this.tpTable = new System.Windows.Forms.TabPage();
this.panel11 = new System.Windows.Forms.Panel();
this.panel21 = new System.Windows.Forms.Panel();
this.cbTableStatus = new System.Windows.Forms.ComboBox();
this.label9 = new System.Windows.Forms.Label();
this.panel13 = new System.Windows.Forms.Panel();
this.txbTableName = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.panel14 = new System.Windows.Forms.Panel();
this.textBox3 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.panel19 = new System.Windows.Forms.Panel();
this.btnShowTable = new System.Windows.Forms.Button();
this.btnEditTable = new System.Windows.Forms.Button();
this.btnDeleteTable = new System.Windows.Forms.Button();
this.btnAddTable = new System.Windows.Forms.Button();
this.panel20 = new System.Windows.Forms.Panel();
this.dtgvTable = new System.Windows.Forms.DataGridView();
this.tpAccount = new System.Windows.Forms.TabPage();
this.panel23 = new System.Windows.Forms.Panel();
this.btnResetPassword = new System.Windows.Forms.Button();
this.panel25 = new System.Windows.Forms.Panel();
this.cbAccountType = new System.Windows.Forms.ComboBox();
this.label11 = new System.Windows.Forms.Label();
this.panel26 = new System.Windows.Forms.Panel();
this.txbDisplayName = new System.Windows.Forms.TextBox();
this.label12 = new System.Windows.Forms.Label();
this.panel27 = new System.Windows.Forms.Panel();
this.txbUserName = new System.Windows.Forms.TextBox();
this.label13 = new System.Windows.Forms.Label();
this.panel28 = new System.Windows.Forms.Panel();
this.btnShowAccount = new System.Windows.Forms.Button();
this.btnEditAccount = new System.Windows.Forms.Button();
this.btnDeleteAccount = new System.Windows.Forms.Button();
this.btnAddAccount = new System.Windows.Forms.Button();
this.panel29 = new System.Windows.Forms.Panel();
this.dtgvAccount = new System.Windows.Forms.DataGridView();
this.tcAdmin.SuspendLayout();
this.tpBill.SuspendLayout();
this.panel2.SuspendLayout();
this.panel1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvBill)).BeginInit();
this.tpFood.SuspendLayout();
this.panel6.SuspendLayout();
this.panel5.SuspendLayout();
this.panel10.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.nmFoodPrice)).BeginInit();
this.panel9.SuspendLayout();
this.panel8.SuspendLayout();
this.panel7.SuspendLayout();
this.panel4.SuspendLayout();
this.panel3.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvFood)).BeginInit();
this.tbFoodCategory.SuspendLayout();
this.panel12.SuspendLayout();
this.panel15.SuspendLayout();
this.panel16.SuspendLayout();
this.panel17.SuspendLayout();
this.panel18.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvCategory)).BeginInit();
this.tpTable.SuspendLayout();
this.panel11.SuspendLayout();
this.panel21.SuspendLayout();
this.panel13.SuspendLayout();
this.panel14.SuspendLayout();
this.panel19.SuspendLayout();
this.panel20.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvTable)).BeginInit();
this.tpAccount.SuspendLayout();
this.panel23.SuspendLayout();
this.panel25.SuspendLayout();
this.panel26.SuspendLayout();
this.panel27.SuspendLayout();
this.panel28.SuspendLayout();
this.panel29.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dtgvAccount)).BeginInit();
this.SuspendLayout();
//
// tcAdmin
//
this.tcAdmin.Controls.Add(this.tpBill);
this.tcAdmin.Controls.Add(this.tpFood);
this.tcAdmin.Controls.Add(this.tbFoodCategory);
this.tcAdmin.Controls.Add(this.tpTable);
this.tcAdmin.Controls.Add(this.tpAccount);
this.tcAdmin.Location = new System.Drawing.Point(12, 12);
this.tcAdmin.Name = "tcAdmin";
this.tcAdmin.SelectedIndex = 0;
this.tcAdmin.Size = new System.Drawing.Size(658, 439);
this.tcAdmin.TabIndex = 0;
//
// tpBill
//
this.tpBill.Controls.Add(this.panel2);
this.tpBill.Controls.Add(this.panel1);
this.tpBill.Location = new System.Drawing.Point(4, 22);
this.tpBill.Name = "tpBill";
this.tpBill.Padding = new System.Windows.Forms.Padding(3);
this.tpBill.Size = new System.Drawing.Size(650, 413);
this.tpBill.TabIndex = 0;
this.tpBill.Text = "Doanh thu";
this.tpBill.UseVisualStyleBackColor = true;
//
// panel2
//
this.panel2.Controls.Add(this.btnViewBill);
this.panel2.Controls.Add(this.dtpkToDate);
this.panel2.Controls.Add(this.dtpkFromDate);
this.panel2.Location = new System.Drawing.Point(6, 6);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(638, 26);
this.panel2.TabIndex = 1;
//
// btnViewBill
//
this.btnViewBill.Location = new System.Drawing.Point(282, 0);
this.btnViewBill.Name = "btnViewBill";
this.btnViewBill.Size = new System.Drawing.Size(75, 23);
this.btnViewBill.TabIndex = 2;
this.btnViewBill.Text = "Thống kê";
this.btnViewBill.UseVisualStyleBackColor = true;
this.btnViewBill.Click += new System.EventHandler(this.btnViewBill_Click);
//
// dtpkToDate
//
this.dtpkToDate.Location = new System.Drawing.Point(435, 3);
this.dtpkToDate.Name = "dtpkToDate";
this.dtpkToDate.Size = new System.Drawing.Size(200, 20);
this.dtpkToDate.TabIndex = 1;
//
// dtpkFromDate
//
this.dtpkFromDate.Location = new System.Drawing.Point(3, 3);
this.dtpkFromDate.Name = "dtpkFromDate";
this.dtpkFromDate.Size = new System.Drawing.Size(200, 20);
this.dtpkFromDate.TabIndex = 0;
//
// panel1
//
this.panel1.Controls.Add(this.dtgvBill);
this.panel1.Location = new System.Drawing.Point(6, 38);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(638, 369);
this.panel1.TabIndex = 0;
//
// dtgvBill
//
this.dtgvBill.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
this.dtgvBill.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvBill.Location = new System.Drawing.Point(3, 3);
this.dtgvBill.Name = "dtgvBill";
this.dtgvBill.Size = new System.Drawing.Size(632, 363);
this.dtgvBill.TabIndex = 0;
//
// tpFood
//
this.tpFood.Controls.Add(this.panel6);
this.tpFood.Controls.Add(this.panel5);
this.tpFood.Controls.Add(this.panel4);
this.tpFood.Controls.Add(this.panel3);
this.tpFood.Location = new System.Drawing.Point(4, 22);
this.tpFood.Name = "tpFood";
this.tpFood.Padding = new System.Windows.Forms.Padding(3);
this.tpFood.Size = new System.Drawing.Size(650, 413);
this.tpFood.TabIndex = 1;
this.tpFood.Text = "Thức ăn";
this.tpFood.UseVisualStyleBackColor = true;
//
// panel6
//
this.panel6.Controls.Add(this.txbSearchFoodName);
this.panel6.Controls.Add(this.btnSearchFood);
this.panel6.Location = new System.Drawing.Point(361, 3);
this.panel6.Name = "panel6";
this.panel6.Size = new System.Drawing.Size(283, 52);
this.panel6.TabIndex = 3;
//
// txbSearchFoodName
//
this.txbSearchFoodName.Location = new System.Drawing.Point(3, 17);
this.txbSearchFoodName.Name = "txbSearchFoodName";
this.txbSearchFoodName.Size = new System.Drawing.Size(199, 20);
this.txbSearchFoodName.TabIndex = 5;
//
// btnSearchFood
//
this.btnSearchFood.Location = new System.Drawing.Point(208, 3);
this.btnSearchFood.Name = "btnSearchFood";
this.btnSearchFood.Size = new System.Drawing.Size(75, 46);
this.btnSearchFood.TabIndex = 4;
this.btnSearchFood.Text = "Tìm";
this.btnSearchFood.UseVisualStyleBackColor = true;
//
// panel5
//
this.panel5.Controls.Add(this.panel10);
this.panel5.Controls.Add(this.panel9);
this.panel5.Controls.Add(this.panel8);
this.panel5.Controls.Add(this.panel7);
this.panel5.Location = new System.Drawing.Point(361, 61);
this.panel5.Name = "panel5";
this.panel5.Size = new System.Drawing.Size(285, 346);
this.panel5.TabIndex = 2;
//
// panel10
//
this.panel10.Controls.Add(this.nmFoodPrice);
this.panel10.Controls.Add(this.label4);
this.panel10.Location = new System.Drawing.Point(3, 153);
this.panel10.Name = "panel10";
this.panel10.Size = new System.Drawing.Size(279, 44);
this.panel10.TabIndex = 4;
//
// nmFoodPrice
//
this.nmFoodPrice.Location = new System.Drawing.Point(91, 8);
this.nmFoodPrice.Maximum = new decimal(new int[] {
100000000,
0,
0,
0});
this.nmFoodPrice.Name = "nmFoodPrice";
this.nmFoodPrice.Size = new System.Drawing.Size(185, 20);
this.nmFoodPrice.TabIndex = 1;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label4.Location = new System.Drawing.Point(3, 9);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(40, 19);
this.label4.TabIndex = 0;
this.label4.Text = "Giá:";
//
// panel9
//
this.panel9.Controls.Add(this.cbFoodCategory);
this.panel9.Controls.Add(this.label3);
this.panel9.Location = new System.Drawing.Point(3, 103);
this.panel9.Name = "panel9";
this.panel9.Size = new System.Drawing.Size(279, 44);
this.panel9.TabIndex = 3;
//
// cbFoodCategory
//
this.cbFoodCategory.FormattingEnabled = true;
this.cbFoodCategory.Location = new System.Drawing.Point(91, 9);
this.cbFoodCategory.Name = "cbFoodCategory";
this.cbFoodCategory.Size = new System.Drawing.Size(185, 21);
this.cbFoodCategory.TabIndex = 1;
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label3.Location = new System.Drawing.Point(3, 9);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(93, 19);
this.label3.TabIndex = 0;
this.label3.Text = "Danh mục:";
//
// panel8
//
this.panel8.Controls.Add(this.txbFoodName);
this.panel8.Controls.Add(this.label2);
this.panel8.Location = new System.Drawing.Point(3, 53);
this.panel8.Name = "panel8";
this.panel8.Size = new System.Drawing.Size(279, 44);
this.panel8.TabIndex = 2;
//
// txbFoodName
//
this.txbFoodName.Location = new System.Drawing.Point(91, 8);
this.txbFoodName.Name = "txbFoodName";
this.txbFoodName.Size = new System.Drawing.Size(185, 20);
this.txbFoodName.TabIndex = 1;
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label2.Location = new System.Drawing.Point(3, 9);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(82, 19);
this.label2.TabIndex = 0;
this.label2.Text = "Tên món:";
//
// panel7
//
this.panel7.Controls.Add(this.txbFoodID);
this.panel7.Controls.Add(this.label1);
this.panel7.Location = new System.Drawing.Point(3, 3);
this.panel7.Name = "panel7";
this.panel7.Size = new System.Drawing.Size(279, 44);
this.panel7.TabIndex = 1;
//
// txbFoodID
//
this.txbFoodID.Location = new System.Drawing.Point(91, 8);
this.txbFoodID.Name = "txbFoodID";
this.txbFoodID.ReadOnly = true;
this.txbFoodID.Size = new System.Drawing.Size(185, 20);
this.txbFoodID.TabIndex = 1;
this.txbFoodID.TextChanged += new System.EventHandler(this.txbFoodID_TextChanged);
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label1.Location = new System.Drawing.Point(3, 9);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(31, 19);
this.label1.TabIndex = 0;
this.label1.Text = "ID:";
//
// panel4
//
this.panel4.Controls.Add(this.btnShowFood);
this.panel4.Controls.Add(this.btnEditFood);
this.panel4.Controls.Add(this.btnDeleteFood);
this.panel4.Controls.Add(this.btnAddFood);
this.panel4.Location = new System.Drawing.Point(6, 3);
this.panel4.Name = "panel4";
this.panel4.Size = new System.Drawing.Size(349, 52);
this.panel4.TabIndex = 1;
//
// btnShowFood
//
this.btnShowFood.Location = new System.Drawing.Point(246, 3);
this.btnShowFood.Name = "btnShowFood";
this.btnShowFood.Size = new System.Drawing.Size(75, 46);
this.btnShowFood.TabIndex = 3;
this.btnShowFood.Text = "Xem";
this.btnShowFood.UseVisualStyleBackColor = true;
this.btnShowFood.Click += new System.EventHandler(this.btnShowFood_Click);
//
// btnEditFood
//
this.btnEditFood.Location = new System.Drawing.Point(165, 3);
this.btnEditFood.Name = "btnEditFood";
this.btnEditFood.Size = new System.Drawing.Size(75, 46);
this.btnEditFood.TabIndex = 2;
this.btnEditFood.Text = "Sửa";
this.btnEditFood.UseVisualStyleBackColor = true;
this.btnEditFood.Click += new System.EventHandler(this.btnEditFood_Click);
//
// btnDeleteFood
//
this.btnDeleteFood.Location = new System.Drawing.Point(84, 3);
this.btnDeleteFood.Name = "btnDeleteFood";
this.btnDeleteFood.Size = new System.Drawing.Size(75, 46);
this.btnDeleteFood.TabIndex = 1;
this.btnDeleteFood.Text = "Xóa";
this.btnDeleteFood.UseVisualStyleBackColor = true;
this.btnDeleteFood.Click += new System.EventHandler(this.btnDeleteFood_Click);
//
// btnAddFood
//
this.btnAddFood.Location = new System.Drawing.Point(3, 3);
this.btnAddFood.Name = "btnAddFood";
this.btnAddFood.Size = new System.Drawing.Size(75, 46);
this.btnAddFood.TabIndex = 0;
this.btnAddFood.Text = "Thêm";
this.btnAddFood.UseVisualStyleBackColor = true;
this.btnAddFood.Click += new System.EventHandler(this.btnAddFood_Click);
//
// panel3
//
this.panel3.Controls.Add(this.dtgvFood);
this.panel3.Location = new System.Drawing.Point(6, 61);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(349, 346);
this.panel3.TabIndex = 0;
//
// dtgvFood
//
this.dtgvFood.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvFood.Location = new System.Drawing.Point(3, 3);
this.dtgvFood.Name = "dtgvFood";
this.dtgvFood.Size = new System.Drawing.Size(343, 340);
this.dtgvFood.TabIndex = 0;
//
// tbFoodCategory
//
this.tbFoodCategory.Controls.Add(this.panel12);
this.tbFoodCategory.Controls.Add(this.panel17);
this.tbFoodCategory.Controls.Add(this.panel18);
this.tbFoodCategory.Location = new System.Drawing.Point(4, 22);
this.tbFoodCategory.Name = "tbFoodCategory";
this.tbFoodCategory.Padding = new System.Windows.Forms.Padding(3);
this.tbFoodCategory.Size = new System.Drawing.Size(650, 413);
this.tbFoodCategory.TabIndex = 2;
this.tbFoodCategory.Text = "Danh mục";
this.tbFoodCategory.UseVisualStyleBackColor = true;
//
// panel12
//
this.panel12.Controls.Add(this.panel15);
this.panel12.Controls.Add(this.panel16);
this.panel12.Location = new System.Drawing.Point(360, 62);
this.panel12.Name = "panel12";
this.panel12.Size = new System.Drawing.Size(285, 346);
this.panel12.TabIndex = 6;
//
// panel15
//
this.panel15.Controls.Add(this.textBox2);
this.panel15.Controls.Add(this.label7);
this.panel15.Location = new System.Drawing.Point(3, 53);
this.panel15.Name = "panel15";
this.panel15.Size = new System.Drawing.Size(279, 44);
this.panel15.TabIndex = 2;
//
// textBox2
//
this.textBox2.Location = new System.Drawing.Point(125, 8);
this.textBox2.Name = "textBox2";
this.textBox2.Size = new System.Drawing.Size(151, 20);
this.textBox2.TabIndex = 1;
//
// label7
//
this.label7.AutoSize = true;
this.label7.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label7.Location = new System.Drawing.Point(3, 9);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(124, 19);
this.label7.TabIndex = 0;
this.label7.Text = "Tên danh mục:";
//
// panel16
//
this.panel16.Controls.Add(this.txbCategoryID);
this.panel16.Controls.Add(this.label8);
this.panel16.Location = new System.Drawing.Point(3, 3);
this.panel16.Name = "panel16";
this.panel16.Size = new System.Drawing.Size(279, 44);
this.panel16.TabIndex = 1;
//
// txbCategoryID
//
this.txbCategoryID.Location = new System.Drawing.Point(125, 8);
this.txbCategoryID.Name = "txbCategoryID";
this.txbCategoryID.ReadOnly = true;
this.txbCategoryID.Size = new System.Drawing.Size(151, 20);
this.txbCategoryID.TabIndex = 1;
//
// label8
//
this.label8.AutoSize = true;
this.label8.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label8.Location = new System.Drawing.Point(3, 9);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(31, 19);
this.label8.TabIndex = 0;
this.label8.Text = "ID:";
//
// panel17
//
this.panel17.Controls.Add(this.btnShowCategory);
this.panel17.Controls.Add(this.btnEditCategory);
this.panel17.Controls.Add(this.btnDeleteCategory);
this.panel17.Controls.Add(this.btnAddCategory);
this.panel17.Location = new System.Drawing.Point(5, 4);
this.panel17.Name = "panel17";
this.panel17.Size = new System.Drawing.Size(349, 52);
this.panel17.TabIndex = 5;
//
// btnShowCategory
//
this.btnShowCategory.Location = new System.Drawing.Point(246, 3);
this.btnShowCategory.Name = "btnShowCategory";
this.btnShowCategory.Size = new System.Drawing.Size(75, 46);
this.btnShowCategory.TabIndex = 3;
this.btnShowCategory.Text = "Xem";
this.btnShowCategory.UseVisualStyleBackColor = true;
//
// btnEditCategory
//
this.btnEditCategory.Location = new System.Drawing.Point(165, 3);
this.btnEditCategory.Name = "btnEditCategory";
this.btnEditCategory.Size = new System.Drawing.Size(75, 46);
this.btnEditCategory.TabIndex = 2;
this.btnEditCategory.Text = "Sửa";
this.btnEditCategory.UseVisualStyleBackColor = true;
//
// btnDeleteCategory
//
this.btnDeleteCategory.Location = new System.Drawing.Point(84, 3);
this.btnDeleteCategory.Name = "btnDeleteCategory";
this.btnDeleteCategory.Size = new System.Drawing.Size(75, 46);
this.btnDeleteCategory.TabIndex = 1;
this.btnDeleteCategory.Text = "Xóa";
this.btnDeleteCategory.UseVisualStyleBackColor = true;
//
// btnAddCategory
//
this.btnAddCategory.Location = new System.Drawing.Point(3, 3);
this.btnAddCategory.Name = "btnAddCategory";
this.btnAddCategory.Size = new System.Drawing.Size(75, 46);
this.btnAddCategory.TabIndex = 0;
this.btnAddCategory.Text = "Thêm";
this.btnAddCategory.UseVisualStyleBackColor = true;
//
// panel18
//
this.panel18.Controls.Add(this.dtgvCategory);
this.panel18.Location = new System.Drawing.Point(5, 62);
this.panel18.Name = "panel18";
this.panel18.Size = new System.Drawing.Size(349, 346);
this.panel18.TabIndex = 4;
//
// dtgvCategory
//
this.dtgvCategory.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvCategory.Location = new System.Drawing.Point(3, 3);
this.dtgvCategory.Name = "dtgvCategory";
this.dtgvCategory.Size = new System.Drawing.Size(343, 340);
this.dtgvCategory.TabIndex = 0;
//
// tpTable
//
this.tpTable.Controls.Add(this.panel11);
this.tpTable.Controls.Add(this.panel19);
this.tpTable.Controls.Add(this.panel20);
this.tpTable.Location = new System.Drawing.Point(4, 22);
this.tpTable.Name = "tpTable";
this.tpTable.Padding = new System.Windows.Forms.Padding(3);
this.tpTable.Size = new System.Drawing.Size(650, 413);
this.tpTable.TabIndex = 3;
this.tpTable.Text = "Bàn ăn";
this.tpTable.UseVisualStyleBackColor = true;
//
// panel11
//
this.panel11.Controls.Add(this.panel21);
this.panel11.Controls.Add(this.panel13);
this.panel11.Controls.Add(this.panel14);
this.panel11.Location = new System.Drawing.Point(360, 62);
this.panel11.Name = "panel11";
this.panel11.Size = new System.Drawing.Size(285, 346);
this.panel11.TabIndex = 9;
//
// panel21
//
this.panel21.Controls.Add(this.cbTableStatus);
this.panel21.Controls.Add(this.label9);
this.panel21.Location = new System.Drawing.Point(3, 103);
this.panel21.Name = "panel21";
this.panel21.Size = new System.Drawing.Size(279, 44);
this.panel21.TabIndex = 3;
//
// cbTableStatus
//
this.cbTableStatus.FormattingEnabled = true;
this.cbTableStatus.Location = new System.Drawing.Point(125, 9);
this.cbTableStatus.Name = "cbTableStatus";
this.cbTableStatus.Size = new System.Drawing.Size(151, 21);
this.cbTableStatus.TabIndex = 1;
//
// label9
//
this.label9.AutoSize = true;
this.label9.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label9.Location = new System.Drawing.Point(3, 9);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(91, 19);
this.label9.TabIndex = 0;
this.label9.Text = "Trạng thái:";
//
// panel13
//
this.panel13.Controls.Add(this.txbTableName);
this.panel13.Controls.Add(this.label5);
this.panel13.Location = new System.Drawing.Point(3, 53);
this.panel13.Name = "panel13";
this.panel13.Size = new System.Drawing.Size(279, 44);
this.panel13.TabIndex = 2;
//
// txbTableName
//
this.txbTableName.Location = new System.Drawing.Point(125, 8);
this.txbTableName.Name = "txbTableName";
this.txbTableName.Size = new System.Drawing.Size(151, 20);
this.txbTableName.TabIndex = 1;
//
// label5
//
this.label5.AutoSize = true;
this.label5.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label5.Location = new System.Drawing.Point(3, 9);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(77, 19);
this.label5.TabIndex = 0;
this.label5.Text = "Tên bàn:";
//
// panel14
//
this.panel14.Controls.Add(this.textBox3);
this.panel14.Controls.Add(this.label6);
this.panel14.Location = new System.Drawing.Point(3, 3);
this.panel14.Name = "panel14";
this.panel14.Size = new System.Drawing.Size(279, 44);
this.panel14.TabIndex = 1;
//
// textBox3
//
this.textBox3.Location = new System.Drawing.Point(125, 8);
this.textBox3.Name = "textBox3";
this.textBox3.ReadOnly = true;
this.textBox3.Size = new System.Drawing.Size(151, 20);
this.textBox3.TabIndex = 1;
//
// label6
//
this.label6.AutoSize = true;
this.label6.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label6.Location = new System.Drawing.Point(3, 9);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(31, 19);
this.label6.TabIndex = 0;
this.label6.Text = "ID:";
//
// panel19
//
this.panel19.Controls.Add(this.btnShowTable);
this.panel19.Controls.Add(this.btnEditTable);
this.panel19.Controls.Add(this.btnDeleteTable);
this.panel19.Controls.Add(this.btnAddTable);
this.panel19.Location = new System.Drawing.Point(5, 4);
this.panel19.Name = "panel19";
this.panel19.Size = new System.Drawing.Size(349, 52);
this.panel19.TabIndex = 8;
//
// btnShowTable
//
this.btnShowTable.Location = new System.Drawing.Point(246, 3);
this.btnShowTable.Name = "btnShowTable";
this.btnShowTable.Size = new System.Drawing.Size(75, 46);
this.btnShowTable.TabIndex = 3;
this.btnShowTable.Text = "Xem";
this.btnShowTable.UseVisualStyleBackColor = true;
//
// btnEditTable
//
this.btnEditTable.Location = new System.Drawing.Point(165, 3);
this.btnEditTable.Name = "btnEditTable";
this.btnEditTable.Size = new System.Drawing.Size(75, 46);
this.btnEditTable.TabIndex = 2;
this.btnEditTable.Text = "Sửa";
this.btnEditTable.UseVisualStyleBackColor = true;
//
// btnDeleteTable
//
this.btnDeleteTable.Location = new System.Drawing.Point(84, 3);
this.btnDeleteTable.Name = "btnDeleteTable";
this.btnDeleteTable.Size = new System.Drawing.Size(75, 46);
this.btnDeleteTable.TabIndex = 1;
this.btnDeleteTable.Text = "Xóa";
this.btnDeleteTable.UseVisualStyleBackColor = true;
//
// btnAddTable
//
this.btnAddTable.Location = new System.Drawing.Point(3, 3);
this.btnAddTable.Name = "btnAddTable";
this.btnAddTable.Size = new System.Drawing.Size(75, 46);
this.btnAddTable.TabIndex = 0;
this.btnAddTable.Text = "Thêm";
this.btnAddTable.UseVisualStyleBackColor = true;
//
// panel20
//
this.panel20.Controls.Add(this.dtgvTable);
this.panel20.Location = new System.Drawing.Point(5, 62);
this.panel20.Name = "panel20";
this.panel20.Size = new System.Drawing.Size(349, 346);
this.panel20.TabIndex = 7;
//
// dtgvTable
//
this.dtgvTable.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvTable.Location = new System.Drawing.Point(3, 3);
this.dtgvTable.Name = "dtgvTable";
this.dtgvTable.Size = new System.Drawing.Size(343, 340);
this.dtgvTable.TabIndex = 0;
//
// tpAccount
//
this.tpAccount.Controls.Add(this.panel23);
this.tpAccount.Controls.Add(this.panel28);
this.tpAccount.Controls.Add(this.panel29);
this.tpAccount.Location = new System.Drawing.Point(4, 22);
this.tpAccount.Name = "tpAccount";
this.tpAccount.Padding = new System.Windows.Forms.Padding(3);
this.tpAccount.Size = new System.Drawing.Size(650, 413);
this.tpAccount.TabIndex = 4;
this.tpAccount.Text = "Tài khoản";
this.tpAccount.UseVisualStyleBackColor = true;
//
// panel23
//
this.panel23.Controls.Add(this.btnResetPassword);
this.panel23.Controls.Add(this.panel25);
this.panel23.Controls.Add(this.panel26);
this.panel23.Controls.Add(this.panel27);
this.panel23.Location = new System.Drawing.Point(360, 62);
this.panel23.Name = "panel23";
this.panel23.Size = new System.Drawing.Size(285, 346);
this.panel23.TabIndex = 6;
//
// btnResetPassword
//
this.btnResetPassword.Location = new System.Drawing.Point(204, 153);
this.btnResetPassword.Name = "btnResetPassword";
this.btnResetPassword.Size = new System.Drawing.Size(75, 46);
this.btnResetPassword.TabIndex = 4;
this.btnResetPassword.Text = "Đặt lại mật khẩu";
this.btnResetPassword.UseVisualStyleBackColor = true;
//
// panel25
//
this.panel25.Controls.Add(this.cbAccountType);
this.panel25.Controls.Add(this.label11);
this.panel25.Location = new System.Drawing.Point(3, 103);
this.panel25.Name = "panel25";
this.panel25.Size = new System.Drawing.Size(279, 44);
this.panel25.TabIndex = 3;
//
// cbAccountType
//
this.cbAccountType.FormattingEnabled = true;
this.cbAccountType.Location = new System.Drawing.Point(127, 9);
this.cbAccountType.Name = "cbAccountType";
this.cbAccountType.Size = new System.Drawing.Size(149, 21);
this.cbAccountType.TabIndex = 1;
//
// label11
//
this.label11.AutoSize = true;
this.label11.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label11.Location = new System.Drawing.Point(3, 9);
this.label11.Name = "label11";
this.label11.Size = new System.Drawing.Size(116, 19);
this.label11.TabIndex = 0;
this.label11.Text = "Loại tài khoản";
//
// panel26
//
this.panel26.Controls.Add(this.txbDisplayName);
this.panel26.Controls.Add(this.label12);
this.panel26.Location = new System.Drawing.Point(3, 53);
this.panel26.Name = "panel26";
this.panel26.Size = new System.Drawing.Size(279, 44);
this.panel26.TabIndex = 2;
//
// txbDisplayName
//
this.txbDisplayName.Location = new System.Drawing.Point(127, 8);
this.txbDisplayName.Name = "txbDisplayName";
this.txbDisplayName.Size = new System.Drawing.Size(149, 20);
this.txbDisplayName.TabIndex = 1;
//
// label12
//
this.label12.AutoSize = true;
this.label12.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label12.Location = new System.Drawing.Point(3, 9);
this.label12.Name = "label12";
this.label12.Size = new System.Drawing.Size(104, 19);
this.label12.TabIndex = 0;
this.label12.Text = "Tên hiển thị:";
//
// panel27
//
this.panel27.Controls.Add(this.txbUserName);
this.panel27.Controls.Add(this.label13);
this.panel27.Location = new System.Drawing.Point(3, 3);
this.panel27.Name = "panel27";
this.panel27.Size = new System.Drawing.Size(279, 44);
this.panel27.TabIndex = 1;
//
// txbUserName
//
this.txbUserName.Location = new System.Drawing.Point(127, 8);
this.txbUserName.Name = "txbUserName";
this.txbUserName.ReadOnly = true;
this.txbUserName.Size = new System.Drawing.Size(149, 20);
this.txbUserName.TabIndex = 1;
//
// label13
//
this.label13.AutoSize = true;
this.label13.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(163)));
this.label13.Location = new System.Drawing.Point(3, 9);
this.label13.Name = "label13";
this.label13.Size = new System.Drawing.Size(118, 19);
this.label13.TabIndex = 0;
this.label13.Text = "Tên tài khoản:";
//
// panel28
//
this.panel28.Controls.Add(this.btnShowAccount);
this.panel28.Controls.Add(this.btnEditAccount);
this.panel28.Controls.Add(this.btnDeleteAccount);
this.panel28.Controls.Add(this.btnAddAccount);
this.panel28.Location = new System.Drawing.Point(5, 4);
this.panel28.Name = "panel28";
this.panel28.Size = new System.Drawing.Size(349, 52);
this.panel28.TabIndex = 5;
//
// btnShowAccount
//
this.btnShowAccount.Location = new System.Drawing.Point(246, 3);
this.btnShowAccount.Name = "btnShowAccount";
this.btnShowAccount.Size = new System.Drawing.Size(75, 46);
this.btnShowAccount.TabIndex = 3;
this.btnShowAccount.Text = "Xem";
this.btnShowAccount.UseVisualStyleBackColor = true;
//
// btnEditAccount
//
this.btnEditAccount.Location = new System.Drawing.Point(165, 3);
this.btnEditAccount.Name = "btnEditAccount";
this.btnEditAccount.Size = new System.Drawing.Size(75, 46);
this.btnEditAccount.TabIndex = 2;
this.btnEditAccount.Text = "Sửa";
this.btnEditAccount.UseVisualStyleBackColor = true;
//
// btnDeleteAccount
//
this.btnDeleteAccount.Location = new System.Drawing.Point(84, 3);
this.btnDeleteAccount.Name = "btnDeleteAccount";
this.btnDeleteAccount.Size = new System.Drawing.Size(75, 46);
this.btnDeleteAccount.TabIndex = 1;
this.btnDeleteAccount.Text = "Xóa";
this.btnDeleteAccount.UseVisualStyleBackColor = true;
//
// btnAddAccount
//
this.btnAddAccount.Location = new System.Drawing.Point(3, 3);
this.btnAddAccount.Name = "btnAddAccount";
this.btnAddAccount.Size = new System.Drawing.Size(75, 46);
this.btnAddAccount.TabIndex = 0;
this.btnAddAccount.Text = "Thêm";
this.btnAddAccount.UseVisualStyleBackColor = true;
//
// panel29
//
this.panel29.Controls.Add(this.dtgvAccount);
this.panel29.Location = new System.Drawing.Point(5, 62);
this.panel29.Name = "panel29";
this.panel29.Size = new System.Drawing.Size(349, 346);
this.panel29.TabIndex = 4;
//
// dtgvAccount
//
this.dtgvAccount.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dtgvAccount.Location = new System.Drawing.Point(3, 3);
this.dtgvAccount.Name = "dtgvAccount";
this.dtgvAccount.Size = new System.Drawing.Size(343, 340);
this.dtgvAccount.TabIndex = 0;
//
// fAdmin
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(674, 463);
this.Controls.Add(this.tcAdmin);
this.Name = "fAdmin";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "Admin";
this.tcAdmin.ResumeLayout(false);
this.tpBill.ResumeLayout(false);
this.panel2.ResumeLayout(false);
this.panel1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvBill)).EndInit();
this.tpFood.ResumeLayout(false);
this.panel6.ResumeLayout(false);
this.panel6.PerformLayout();
this.panel5.ResumeLayout(false);
this.panel10.ResumeLayout(false);
this.panel10.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.nmFoodPrice)).EndInit();
this.panel9.ResumeLayout(false);
this.panel9.PerformLayout();
this.panel8.ResumeLayout(false);
this.panel8.PerformLayout();
this.panel7.ResumeLayout(false);
this.panel7.PerformLayout();
this.panel4.ResumeLayout(false);
this.panel3.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvFood)).EndInit();
this.tbFoodCategory.ResumeLayout(false);
this.panel12.ResumeLayout(false);
this.panel15.ResumeLayout(false);
this.panel15.PerformLayout();
this.panel16.ResumeLayout(false);
this.panel16.PerformLayout();
this.panel17.ResumeLayout(false);
this.panel18.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvCategory)).EndInit();
this.tpTable.ResumeLayout(false);
this.panel11.ResumeLayout(false);
this.panel21.ResumeLayout(false);
this.panel21.PerformLayout();
this.panel13.ResumeLayout(false);
this.panel13.PerformLayout();
this.panel14.ResumeLayout(false);
this.panel14.PerformLayout();
this.panel19.ResumeLayout(false);
this.panel20.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvTable)).EndInit();
this.tpAccount.ResumeLayout(false);
this.panel23.ResumeLayout(false);
this.panel25.ResumeLayout(false);
this.panel25.PerformLayout();
this.panel26.ResumeLayout(false);
this.panel26.PerformLayout();
this.panel27.ResumeLayout(false);
this.panel27.PerformLayout();
this.panel28.ResumeLayout(false);
this.panel29.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dtgvAccount)).EndInit();
this.ResumeLayout(false);
}
#endregion
private System.Windows.Forms.TabControl tcAdmin;
private System.Windows.Forms.TabPage tpBill;
private System.Windows.Forms.Panel panel2;
private System.Windows.Forms.Panel panel1;
private System.Windows.Forms.DataGridView dtgvBill;
private System.Windows.Forms.TabPage tpFood;
private System.Windows.Forms.TabPage tbFoodCategory;
private System.Windows.Forms.TabPage tpTable;
private System.Windows.Forms.TabPage tpAccount;
private System.Windows.Forms.Button btnViewBill;
private System.Windows.Forms.DateTimePicker dtpkToDate;
private System.Windows.Forms.DateTimePicker dtpkFromDate;
private System.Windows.Forms.Panel panel6;
private System.Windows.Forms.TextBox txbSearchFoodName;
private System.Windows.Forms.Button btnSearchFood;
private System.Windows.Forms.Panel panel5;
private System.Windows.Forms.Panel panel4;
private System.Windows.Forms.Button btnShowFood;
private System.Windows.Forms.Button btnEditFood;
private System.Windows.Forms.Button btnDeleteFood;
private System.Windows.Forms.Button btnAddFood;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.DataGridView dtgvFood;
private System.Windows.Forms.Panel panel8;
private System.Windows.Forms.TextBox txbFoodName;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Panel panel7;
private System.Windows.Forms.TextBox txbFoodID;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Panel panel10;
private System.Windows.Forms.NumericUpDown nmFoodPrice;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Panel panel9;
private System.Windows.Forms.ComboBox cbFoodCategory;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Panel panel12;
private System.Windows.Forms.Panel panel15;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Panel panel16;
private System.Windows.Forms.TextBox txbCategoryID;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Panel panel17;
private System.Windows.Forms.Button btnShowCategory;
private System.Windows.Forms.Button btnEditCategory;
private System.Windows.Forms.Button btnDeleteCategory;
private System.Windows.Forms.Button btnAddCategory;
private System.Windows.Forms.Panel panel18;
private System.Windows.Forms.DataGridView dtgvCategory;
private System.Windows.Forms.Panel panel11;
private System.Windows.Forms.Panel panel21;
private System.Windows.Forms.ComboBox cbTableStatus;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.Panel panel13;
private System.Windows.Forms.TextBox txbTableName;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Panel panel14;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Panel panel19;
private System.Windows.Forms.Button btnShowTable;
private System.Windows.Forms.Button btnEditTable;
private System.Windows.Forms.Button btnDeleteTable;
private System.Windows.Forms.Button btnAddTable;
private System.Windows.Forms.Panel panel20;
private System.Windows.Forms.DataGridView dtgvTable;
private System.Windows.Forms.Panel panel23;
private System.Windows.Forms.Button btnResetPassword;
private System.Windows.Forms.Panel panel25;
private System.Windows.Forms.ComboBox cbAccountType;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.Panel panel26;
private System.Windows.Forms.TextBox txbDisplayName;
private System.Windows.Forms.Label label12;
private System.Windows.Forms.Panel panel27;
private System.Windows.Forms.TextBox txbUserName;
private System.Windows.Forms.Label label13;
private System.Windows.Forms.Panel panel28;
private System.Windows.Forms.Button btnShowAccount;
private System.Windows.Forms.Button btnEditAccount;
private System.Windows.Forms.Button btnDeleteAccount;
private System.Windows.Forms.Button btnAddAccount;
private System.Windows.Forms.Panel panel29;
private System.Windows.Forms.DataGridView dtgvAccount;
}
}
Code fAdmin.cs
using QuanLyQuanCafe.DAO;
using QuanLyQuanCafe.DTO;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace QuanLyQuanCafe
{
public partial class fAdmin : Form
{
BindingSource foodList = new BindingSource();
public fAdmin()
{
InitializeComponent();
Load();
}
#region methods
void Load()
{
dtgvFood.DataSource = foodList;
LoadDateTimePickerBill();
LoadListBillByDate(dtpkFromDate.Value, dtpkToDate.Value);
LoadListFood();
LoadCategoryIntoCombobox(cbFoodCategory);
AddFoodBinding();
}
void LoadDateTimePickerBill()
{
DateTime today = DateTime.Now;
dtpkFromDate.Value = new DateTime(today.Year, today.Month, 1);
dtpkToDate.Value = dtpkFromDate.Value.AddMonths(1).AddDays(-1);
}
void LoadListBillByDate(DateTime checkIn, DateTime checkOut)
{
dtgvBill.DataSource = BillDAO.Instance.GetBillListByDate(checkIn, checkOut);
}
void AddFoodBinding()
{
txbFoodName.DataBindings.Add(new Binding("Text", dtgvFood.DataSource, "Name", true, DataSourceUpdateMode.Never));
txbFoodID.DataBindings.Add(new Binding("Text", dtgvFood.DataSource, "ID", true, DataSourceUpdateMode.Never));
nmFoodPrice.DataBindings.Add(new Binding("Value", dtgvFood.DataSource, "Price", true, DataSourceUpdateMode.Never));
}
void LoadCategoryIntoCombobox(ComboBox cb)
{
cb.DataSource = CategoryDAO.Instance.GetListCategory();
cb.DisplayMember = "Name";
}
void LoadListFood()
{
foodList.DataSource = FoodDAO.Instance.GetListFood();
}
#endregion
#region events
private void txbFoodID_TextChanged(object sender, EventArgs e)
{
if (dtgvFood.SelectedCells.Count > 0)
{
int id = (int)dtgvFood.SelectedCells[0].OwningRow.Cells["CategoryID"].Value;
Category cateogory = CategoryDAO.Instance.GetCategoryByID(id);
cbFoodCategory.SelectedItem = cateogory;
int index = -1;
int i = 0;
foreach (Category item in cbFoodCategory.Items)
{
if (item.ID == cateogory.ID)
{
index = i;
break;
}
i++;
}
cbFoodCategory.SelectedIndex = index;
}
}
private void btnAddFood_Click(object sender, EventArgs e)
{
string name = txbFoodName.Text;
int categoryID = (cbFoodCategory.SelectedItem as Category).ID;
float price = (float)nmFoodPrice.Value;
if (FoodDAO.Instance.InsertFood(name, categoryID, price))
{
MessageBox.Show("Thêm món thành công");
LoadListFood();
if (insertFood != null)
insertFood(this, new EventArgs());
}
else
{
MessageBox.Show("Có lỗi khi thêm thức ăn");
}
}
private void btnEditFood_Click(object sender, EventArgs e)
{
string name = txbFoodName.Text;
int categoryID = (cbFoodCategory.SelectedItem as Category).ID;
float price = (float)nmFoodPrice.Value;
int id = Convert.ToInt32(txbFoodID.Text);
if (FoodDAO.Instance.UpdateFood(id, name, categoryID, price))
{
MessageBox.Show("Sửa món thành công");
LoadListFood();
if (updateFood != null)
updateFood(this, new EventArgs());
}
else
{
MessageBox.Show("Có lỗi khi sửa thức ăn");
}
}
private void btnDeleteFood_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txbFoodID.Text);
if (FoodDAO.Instance.DeleteFood(id))
{
MessageBox.Show("Xóa món thành công");
LoadListFood();
if (deleteFood != null)
deleteFood(this, new EventArgs());
}
else
{
MessageBox.Show("Có lỗi khi xóa thức ăn");
}
}
private void btnShowFood_Click(object sender, EventArgs e)
{
LoadListFood();
}
private void btnViewBill_Click(object sender, EventArgs e)
{
LoadListBillByDate(dtpkFromDate.Value, dtpkToDate.Value);
}
private event EventHandler insertFood;
public event EventHandler InsertFood
{
add { insertFood += value; }
remove { insertFood -= value; }
}
private event EventHandler deleteFood;
public event EventHandler DeleteFood
{
add { deleteFood += value; }
remove { deleteFood -= value; }
}
private event EventHandler updateFood;
public event EventHandler UpdateFood
{
add { updateFood += value; }
remove { updateFood -= value; }
}
#endregion
}
}
Bài sau chúng ta sẽ cùng nhau tìm hiểu cách tìm kiếm gần đúng thức ăn.
Đừng quên: “Luyện tập – Thử thách – Không ngại khó”
Tải xuống
Tài liệu
Nhằm phục vụ mục đích học tập Offline của cộng đồng, Kteam hỗ trợ tính năng lưu trữ nội dung bài học Thêm, xóa, sửa thức ăn trong phần mềm Quản lý quán cafe với C# Winform dưới dạng file PDF trong link bên dưới.
Ngoài ra, bạn cũng có thể tìm thấy các tài liệu được đóng góp từ cộng đồng ở mục TÀI LIỆU trên thư viện Howkteam.com
Đừng quên like và share để ủng hộ Kteam và tác giả nhé!
Project
Nếu việc thực hành theo hướng dẫn không diễn ra suôn sẻ như mong muốn. Bạn cũng có thể tải xuống PROJECT THAM KHẢO ở link bên dưới!
Thảo luận
Nếu bạn có bất kỳ khó khăn hay thắc mắc gì về khóa học, đừng ngần ngại đặt câu hỏi trong phần bên dưới hoặc trong mục HỎI & ĐÁP trên thư viện Howkteam.com để nhận được sự hỗ trợ từ cộng đồng.
Nội dung bài viết
Tác giả/Dịch giả
Khóa học
Lập trình phần mềm Quản lý quán cafe với C# Winform
Bạn đã học qua LẬP TRÌNH C# CƠ BẢN? Xong nốt cả LẬP TRÌNH WINFORM lẫn SQL?
Bạn đã chán các bài tập căn bản, muốn thực hành các kiến thức đã học vào một dự án thực tế?
Hay đơn giản bạn là chủ quán café, mong muốn tự tạo nên phần mềm dành cho chính mình sử dụng?
Vậy còn chần chừ gì không tham gia ngay khóa học LẬP TRÌNH PHẦN MỀM QUÁN CAFÉ VỚI C# WINFORM?
Có 1 lỗi nhỏ khi xóa món ăn đó là nếu có nhiều bàn cùng chọn món đó (mỗi bàn chỉ gọi 1 món) thì khi xóa món chỉ có bàn đầu tiên đổi status về "Trống". Để fix lỗi này các bạn tạo trigger cho delete billInfo, sử dụng Cursor để duyệt các idbillInfo, Id nào không còn trong bảng BillInfo nữa thì xóa luôn bill đó trong bảng Bill, rồi tạo trigger for delete cho bảng Bill, nếu có bill bị xóa thì update status của bàn về Trống là được.
Cho em hỏi chức năng ở Danh Mục khi thêm xóa sửa thành công hiện vào bảng rồi thì làm sao để cập nhật vào combobox Category ở Hóa Đơn được ạ? Em làm nó bị lỗi khi thêm dữ liệu mới vào Danh Mục thành công là mất dữ liệu trong combobox Category bên hóa đơn luôn :((( Mong anh giúp giùm em ạ.
lỗi ở câu truy vấn delete thì fix sao ạ
The DELETE statement conflicted with the REFERENCE constraint "FK__BillInfo__idFood__21B6055D". The conflict occurred in database "QuanLyQuanCafe", table "dbo.BillInfo", column 'idFood'.
The statement has been terminated.'
Ad cho em hỏi ở bài 18 trong phần thêm món vào list thì IDENTITY tự động nhảy lên đến hàng ngàn trong khi thêm ở SQL thì lại bình thường?
Ad cho e xin code trigger delete category đc hk ạ?
ngothanhtri722@gmail.com