public void LoadLabel()
{
DataTable table = new DataTable();
string lenh3 = "select maTTDH from DonHang where maCN='" + maCN + "'";
var sql = new GetDataFromSQL();
table = sql.getDataTable(lenh3);
int mangve = 0, tongdai = 0, empty = 0;;
foreach (DataRow row in table.Rows)
{
if (Convert.ToInt32(row[0].ToString()) == 6)
{
mangve++;
}
if (Convert.ToInt32(row[0].ToString()) == 7)
{
tongdai++;
}
}
button11.Text = "Mang về (" + mangve + ")";
button12.Text = "Tổng đài (" + tongdai + ")";
var table1 = new DataTable();
string lenh = "select maBA, tenBA, ghiChu, sucChua, tinhTrang, cn.maCN from BanAn ba, ChiNhanh cn where tinhTrang=0 and cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";
table1 = sql.getDataTable(lenh);
foreach (DataRow row in table1.Rows)
{
empty++;
}
button7.Text = "Còn trống (" + empty + ")";
int open = 0;
var table2 = new DataTable();
string lenh2 = "select distinct ba.maBA, cn.maCN from BanAn ba, ChiNhanh cn, DonHang dh where dh.maCN=cn.maCN and dh.maTTDH=1 and tinhTrang=1 and cn.maCN=ba.maCN and ba.maBA=dh.maBA and cn.tenCN=N'" + tenCN + "'";
table2 = sql.getDataTable(lenh2);
foreach (DataRow row in table2.Rows)
{
open++;
}
button1.Text = "Bàn đang mở (" + open + ")";
int chebien = 0;
var table3 = new DataTable();
string lenh4 = "select distinct ba.maBA, cn.maCN from BanAn ba, ChiNhanh cn, DonHang dh where dh.maCN=cn.maCN and (dh.maTTDH=2 or dh.maTTDH=3) and tinhTrang=1 and ba.maBA=dh.maBA and cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";
table3 = sql.getDataTable(lenh4);
foreach (DataRow row in table3.Rows)
{
chebien++;
}
button2.Text = "Đang chế biến (" + chebien + ")";
}
private void button3_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
tien += Convert.ToDecimal(row.Cells[1].Value);
}
var sql = new GetDataFromSQL();
string time = DateTime.Now.ToString();
string lenh = "insert into DonHang(maTTDH,thoiGian,SDT,diaChi,giaTriDonHang) values (9,'" + time + "','" + textBox1.Text + "',N'" + label4.Name + "'," + tien + ")";
if (sql.ExecuteNonQuery(lenh) > 0)
{
string lenhx = "select maDH from DonHang where SDT='" + textBox1.Text + "' and thoiGian='" + time + "'";
DataTable tab = new DataTable();
tab = sql.getDataTable(lenhx);
foreach (DataRow row in tab.Rows)
{
maDH = Convert.ToInt32(row[0].ToString());
textBox1.Text = "dsa " + maDH;
}
int i = dataGridView1.RowCount, j = 0;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
var dt = new DataTable();
string tenMonAn = row.Cells[0].Value.ToString();
string timMaMA = "select maMA from MonAn where tenMA=N'" + tenMonAn + "'";
dt = sql.getDataTable(timMaMA);
int maMA = 0;
foreach (DataRow dtRow in dt.Rows)
{
maMA = Convert.ToInt32(dtRow[0].ToString());
}
string lenh1 = "insert into ChiTietDonHang(maDonHang,maMA) values ('" + maDH + "','" + maMA + "')";
if (sql.ExecuteNonQuery(lenh1) > 0)
{
j++;
}
}
if (i == j)
{
MessageBox.Show("Tạo đơn hàng thành công!");
this.Refresh();
}
else
{
MessageBox.Show("Không thể tạo đơn hàng này!");
}
}
}
private void Form5_Load(object sender, EventArgs e)
{
var sql = new GetDataFromSQL();
DataTable dh = new DataTable();
string lenh = "select ten, kh.SDT, maDH from KhachHang kh, DonHang dh where dh.SDT=kh.SDT and maTTDH=6 and dh.maCN=" + Form1.maCN;
dh = sql.getDataTable(lenh);
foreach (DataRow row in dh.Rows)
{
Button bt = new Button();
bt.Parent = flowLayoutPanel1;
bt.Size = new Size(365, 165);
bt.Text = row[0].ToString() + "\r\n" + row[1].ToString();
bt.Font = new System.Drawing.Font("Microsoft Sans Serif", 25, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
bt.ForeColor = Color.DodgerBlue;
bt.BackColor = Color.Navy;
bt.Click += Bt_Click;
bt.LostFocus += Bt_LostFocus;
bt.Name = row[1].ToString();
}
//hide task and fullscreen
FormState fm = new FormState();
fm.Maximize(this);
}
private void button7_Click(object sender, EventArgs e)
{
flowLayoutPanel1.Controls.Clear();
var table = new DataTable();
string lenh = "select maBA, tenBA, ghiChu, sucChua, tinhTrang, cn.maCN from BanAn ba, ChiNhanh cn where tinhTrang=0 and cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";
var sql = new GetDataFromSQL();
table = sql.getDataTable(lenh);
foreach (DataRow row in table.Rows)
{
Button bt = new Button()
{
Width = 120, Height = 120
};
bt.Name = row[0].ToString();
bt.Parent = flowLayoutPanel1;
bt.Text = "Bàn " + row[1].ToString();
bt.BackColor = Color.Lavender;
bt.ForeColor = Color.Navy;
bt.Font = new System.Drawing.Font("Microsoft Sans Serif", 17, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
var projectPath = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName;
string filePath = Path.Combine(projectPath, "Resources\\Icons8-Ios7-Household-Table.ico");
bt.Image = Image.FromFile(filePath, true);
bt.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
bt.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
bt.BackgroundImageLayout = ImageLayout.Center;
bt.Click += Bt_Click;
}
}
private void Bt_Click(object sender, EventArgs e)
{
Button bt = (Button)sender;
curTable = Convert.ToInt32(bt.Name);
var sql = new GetDataFromSQL();
string lenh = "insert into DonHang(maTTDH, maCN, thoiGian, maBA) values (1,'" + maCN + "','" + DateTime.Now.ToString() + "'," + curTable + ")";
sql.ExecuteNonQuery(lenh);
var temp = new DataTable();
string lenh2 = "select maDH from DonHang where maCN=" + maCN + " and maBA=" + curTable;
temp = sql.getDataTable(lenh2);
foreach (DataRow row in temp.Rows)
{
maDH = Convert.ToInt32(row[0].ToString());
}
string lenh3 = "update BanAn set tinhTrang=1 where maBA='" + curTable + "' and maCN=" + maCN;
sql.ExecuteNonQuery(lenh3);
tenTable = bt.Text;
Form4 f3 = new Form4();
f3.ShowDialog();
}
private void Form4_Load(object sender, EventArgs e)
{
label3.Text = DateTime.Now.ToString();
var sql = new GetDataFromSQL();
DataTable danhmuc = new DataTable();
string lenh = "select distinct tenDM from DanhMucMonAn dm, MonAn ma, MenuChiNhanh mn where dm.maDM=ma.danhMuc and ma.maMA=mn.maMA and mn.maCN='" + Form1.maCN + "'";
danhmuc = sql.getDataTable(lenh);
foreach (DataRow row in danhmuc.Rows)
{
Button bt = new Button();
bt.Parent = flowLayoutPanel1;
bt.Size = new Size(165, 165);
bt.Text = row[0].ToString();
bt.ForeColor = Color.DodgerBlue;
bt.BackColor = Color.Navy;
bt.Font = new Font(this.Font, FontStyle.Bold);
bt.Click += Bt_Click;
}
label1.Text = Form1.tenTable;
//hide task and fullscreen
FormState fm = new FormState();
fm.Maximize(this);
}
void LoadDGVDonHang() //dgv3
{
string lenh = "select maDH as N'Mã đơn hàng', ten as N'Tên khách hàng', kh.SDT as N'Số điện thoại', dh.thoiGian as N'Thời gian đặt hàng' from KhachHang kh, DonHang dh where dh.SDT = kh.SDT and maTTDH = 9 ";
var sql = new GetDataFromSQL();
dtDuyet = sql.getDataTable(lenh);
dataGridView3.DataSource = dtDuyet;
}
public void LoadChiNhanh()
{
var sql = new GetDataFromSQL();
cn = sql.getDataTable("select maCN, tenCN, dienThoai, diaChi, tinhThanh from ChiNhanh");
dataGridView3.DataSource = cn;
dataGridView3.ReadOnly = true;
}
void LoadDGVHuyDoi() //dgv5
{
string lenh = "select maDH as N'Mã đơn hàng', tenTTDH as 'Trạng thái' ,ten as N'Tên khách hàng', kh.SDT as N'Số điện thoại', dh.thoiGian as N'Thời gian đặt hàng' from KhachHang kh, DonHang dh, TinhTrangDonHang ttdh where dh.SDT = kh.SDT and dh.maTTDH=ttdh.maTTDH and (dh.maTTDH = 4 or dh.maTTDH = 6 or dh.maTTDH =7 or dh.maTTDH =8 or dh.maTTDH =9 or dh.maTTDH =10 or dh.maTTDH =11) and dh.maBA is null";
var sql = new GetDataFromSQL();
dtDuyet = sql.getDataTable(lenh);
dataGridView5.DataSource = dtDuyet;
}
private void Form2_Activated(object sender, EventArgs e)
{
var tableOfCN = new DataTable();
var sql = new GetDataFromSQL();
string lenh = "select maBA,tenBA,ghiChu,sucChua from BanAn where maCN= " + masoCN;
tableOfCN = sql.getDataTable(lenh);
dataGridView4.DataSource = tableOfCN;
}
void LoadFlowPanel2()
{
var dt = new DataTable();
dt = sql.getDataTable("select top(8) tenMA,maMA from MonAn order by dem desc");
foreach (DataRow row in dt.Rows)
{
Button btTop = new Button();
btTop.Parent = flowLayoutPanel2;
btTop.Text = row[0].ToString();
btTop.ForeColor = Color.MediumBlue;
btTop.BackColor = Color.SeaShell;
btTop.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
btTop.Size = new Size(386, 55);
btTop.Font = new System.Drawing.Font("Microsoft Sans Serif", 18, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
btTop.Click += BtTop_Click;
btTop.Name = row[1].ToString();
}
}
void LoadDonHangChuyenXuongCN()
{
var table = new DataTable();
string lenh = "select tenCN,maCN from ChiNhanh";
var sql = new GetDataFromSQL();
table = sql.getDataTable(lenh);
double congsuat = 0;
double tong = 0;
double hien = 0;
foreach (DataRow row in table.Rows)
{
var temp = new DataTable();
string cmd = "select maBA,tinhTrang from BanAn ba, ChiNhanh cn where ba.maCN=cn.maCN and cn.maCN=" + Convert.ToInt32(row[1].ToString());
temp = sql.getDataTable(cmd);
foreach (DataRow rowtemp in temp.Rows)
{
tong++;
if (Convert.ToInt32(rowtemp[1]) == 1)
{
hien++;
}
}
congsuat = (hien / tong) * 100;
if (hien == 0 || tong == 0)
{
congsuat = 0;
}
Button btDuyet = new Button();
btDuyet.Parent = flowLayoutPanel6;
btDuyet.Size = new Size(290, 100);
btDuyet.Text = row[0].ToString() + "\r\nCông suất: " + Math.Round(congsuat, 1) + "%";
btDuyet.Font = new System.Drawing.Font("Microsoft Sans Serif", 15, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
btDuyet.ForeColor = Color.DodgerBlue;
btDuyet.BackColor = Color.Navy;
btDuyet.Click += btDuyet_Click;
btDuyet.LostFocus += btDuyet_LostFocus;
btDuyet.Name = row[1].ToString();
//btDuyet.AccessibleName = row[2].ToString();
}
}
void LoadcbbDanhMuc()
{
var dtDM = new DataTable();
var sql = new GetDataFromSQL();
dtDM = sql.getDataTable("select tenDM from DanhMucMonAn");
foreach (DataRow row in dtDM.Rows)
{
cb_DM.Items.Add(row["tenDM"]);
}
}
//MON AN
private void LoadComboBoxDanhMuc()
{
cb_MADanhMuc.Items.Clear();
var sql = new GetDataFromSQL();
cbb = sql.getDataTable("select distinct tenDM from DanhMucMonAn");
foreach (DataRow row in cbb.Rows)
{
cb_MADanhMuc.Items.Add(row["tenDM"]);
}
}
private void chebien_Load(object sender, EventArgs e)
{
var sql = new GetDataFromSQL();
DataTable dh = new DataTable();
string lenh = "select tenBA, dh.maBA, maDH, dh.thoiGian from DonHang dh, BanAn ba where (maTTDH=2 or maTTDH=3) and dh.maCN='" + Form1.maCN + "' and dh.maBA=ba.maBA";
DataTable dh2 = new DataTable();
dh2 = sql.getDataTable(lenh);
foreach (DataRow row in dh2.Rows)
{
Button open = new Button();
open.Parent = flowLayoutPanel1;
open.Size = new Size(350, 150);
open.Text = "Bàn: " + row[0].ToString() + "\r\nThời gian: " + row[3].ToString();
open.Font = new System.Drawing.Font("Microsoft Sans Serif", 15, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
open.ForeColor = Color.DodgerBlue;
open.BackColor = Color.Navy;
open.Click += open_Click;
open.LostFocus += open_LostFocus;
open.Name = row[1].ToString();
open.AccessibleName = row[2].ToString();
}
string lenh2 = "select kh.ten, dh.maBA, maDH, dh.SDT from DonHang dh, KhachHang kh where (maTTDH=2 or maTTDH=3) and dh.maCN='" + Form1.maCN + "' and dh.SDT=kh.SDT";
dh = sql.getDataTable(lenh2);
foreach (DataRow row in dh.Rows)
{
Button open = new Button();
open.Parent = flowLayoutPanel1;
open.Size = new Size(350, 150);
open.Text = "Khách hàng: " + row[0].ToString() + "\r\nSDT: " + row[3].ToString();
open.Font = new System.Drawing.Font("Microsoft Sans Serif", 15, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
open.ForeColor = Color.DodgerBlue;
open.BackColor = Color.Navy;
open.Click += open_Click;
open.LostFocus += open_LostFocus;
open.Name = row[1].ToString();
open.AccessibleName = row[2].ToString();
}
}
void LoadCBB()
{
string s = "select tenCN from ChiNhanh";
var sql = new GetDataFromSQL();
var dt = new DataTable();
dt = sql.getDataTable(s);
foreach (DataRow row in dt.Rows)
{
comboBox1.Items.Add(row[0].ToString());
}
}
private void dataGridView3_SelectionChanged(object sender, EventArgs e)
{
masoCN = Convert.ToInt32(dataGridView3.CurrentRow.Cells[0].Value);
tenCN = Convert.ToString(dataGridView3.CurrentRow.Cells[1].Value);
var tableOfCN = new DataTable();
var sql = new GetDataFromSQL();
string lenh = "select maBA,tenBA,ghiChu,sucChua from BanAn where maCN= " + masoCN;
tableOfCN = sql.getDataTable(lenh);
dataGridView4.DataSource = tableOfCN;
dataGridView4.ReadOnly = true;
textBox3.Text = "Danh sách bàn chi nhánh: " + tenCN;
}
private void Form7_Load(object sender, EventArgs e)
{
DataTable table = new DataTable();
var sql = new GetDataFromSQL();
string lenh = "select SDT from KhachHang";
table = sql.getDataTable(lenh);
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
foreach (DataRow row in table.Rows)
{
collection.Add(row[0].ToString());
}
textBox1.AutoCompleteCustomSource = collection;
DataTable danhmuc = new DataTable();
string lenh2 = "select distinct tenDM from DanhMucMonAn dm ";
danhmuc = sql.getDataTable(lenh2);
foreach (DataRow row in danhmuc.Rows)
{
Button bt = new Button();
bt.Parent = flowLayoutPanel1;
bt.Size = new Size(180, 55);
bt.Text = row[0].ToString();
bt.ForeColor = Color.DodgerBlue;
bt.BackColor = Color.SeaShell;
bt.Font = new Font(this.Font, FontStyle.Bold);
bt.Click += Bt_Click;
}
LoadDonHangChuyenXuongCN(); //chinhanh de don hang chuyen xuong
LoadDGVDuyetDonHang(); //dgv2
LoadDGVDonHang(); //dgv3
LoadDGVXemTTDonHang(); //dgv4
LoadDGVHuyDoi();
hidetabpage();
}
void LoadDGVChiTietDonHang()
{
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
var table = new DataTable();
string lenh = "select tenMA from MonAn ma, ChiTietDonHang ctdh where ma.maMA=ctdh.maMA and ctdh.maDonHang='" + maDH + "'";
var sql = new GetDataFromSQL();
table = sql.getDataTable(lenh);
foreach (DataRow row in table.Rows)
{
dataGridView1.Rows.Add(row[0].ToString());
}
}
void LoadcbbMonAn(string danhmuc)
{
cb_TenMA.Items.Clear();
var dtMA = new DataTable();
var sql = new GetDataFromSQL();
int s = sql.timMaDanhMuc(danhmuc);
string query = "select distinct tenMA from MonAn ma, DanhMucMonAn dm where ma.danhMuc=" + s;
dtMA = sql.getDataTable(query);
foreach (DataRow row in dtMA.Rows)
{
cb_TenMA.Items.Add(row["tenMA"]);
}
}
private void Form1_Load(object sender, EventArgs e)
{
var sql = new GetDataFromSQL();
string lenh = "select tenCN from ChiNhanh";
table = sql.getDataTable(lenh);
AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
foreach (DataRow row in table.Rows)
{
collection.Add(row[0].ToString());
}
textBox1.AutoCompleteCustomSource = collection;
}
private void button4_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có muốn chuyển xuống bếp?", "Thông báo", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
var sql = new GetDataFromSQL();
int i = dataGridView1.RowCount, j = 0;
decimal tien = 0;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
var dt = new DataTable();
string tenMonAn = row.Cells[0].Value.ToString();
string timMaMA = "select maMA from MonAn where tenMA=N'" + tenMonAn + "'";
dt = sql.getDataTable(timMaMA);
int maMA = 0;
foreach (DataRow dtRow in dt.Rows)
{
maMA = Convert.ToInt32(dtRow[0].ToString());
}
string lenh = "insert into ChiTietDonHang(maDonHang,maMA) values ('" + Form1.maDH + "','" + maMA + "')";
if (sql.ExecuteNonQuery(lenh) > 0)
{
j++;
}
tien += Convert.ToDecimal(row.Cells[1].Value.ToString());
}
if (i == j)
{
string s = "update DonHang set maTTDH=2 , giaTriDonHang='" + tien + "' where maDH='" + Form1.maDH + "'";
sql.ExecuteNonQuery(s);
string s1 = "update BanAn set tinhTrang=1 where maBA=" + Form1.curTable + " and maCN=" + Form1.maCN;
if (sql.ExecuteNonQuery(s1) > 0)
{
MessageBox.Show("Đã chuyển xuống bếp");
}
var f1 = new Form1();
this.Close();
f1.Show();
}
else
{
MessageBox.Show("Không thể chuyển đơn hàng này xuống bếp!");
}
}
else
{
MessageBox.Show("Đã hủy chuyển đơn xuống bếp");
}
}
//DANH MUC
private void LoadDGVDanhMuc()
{
tb_ghiChu.Clear();
tb_tenDM.Clear();
tb_ghiChu.Enabled = false;
tb_tenDM.Enabled = false;
bt_sua.Enabled = true;
bt_xoa.Enabled = true;
bt_them.Enabled = true;
bt_luu.Enabled = false;
var sql = new GetDataFromSQL();
dt = sql.getDataTable("select maDM as 'Mã danh mục', tenDM as 'Tên danh mục', ghiChu as 'Ghi chú' from DanhMucMonAn");
dataGridView1.DataSource = dt;
}
private void button1_Click(object sender, EventArgs e)
{
var kh = new DataTable();
string lenh = "select SDT,ten,diaChi,email from KhachHang where SDT=N'" + textBox1.Text + "'";
var sql = new GetDataFromSQL();
kh = sql.getDataTable(lenh);
foreach (DataRow row in kh.Rows)
{
label2.Text = "Tên khách hàng: " + row[1].ToString();
label2.Name = row[1].ToString();
label4.Text = "Địa chỉ: " + row[2].ToString();
label4.Name = row[2].ToString();
label6.Text = "Email: " + row[3].ToString();
label6.Name = row[3].ToString();
}
}
private void Form1_Load(object sender, EventArgs e)
{
//Ban An
//Trong:0
//Co nguoi: 1
flowLayoutPanel1.Controls.Clear();
label1.Text = "Chi nhánh :" + dangnhap.tenCN;
var sql = new GetDataFromSQL();
string lenh = "select maBA, tenBA, ghiChu, sucChua, tinhTrang, cn.maCN from BanAn ba, ChiNhanh cn where cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";
dsBan = sql.getDataTable(lenh);
foreach (DataRow row in dsBan.Rows)
{
maCN = Convert.ToInt32(row[5].ToString());
}
foreach (DataRow row in dsBan.Rows)
{
Button bt = new Button()
{
Width = 120, Height = 120
};
bt.Name = row[0].ToString();
bt.Parent = flowLayoutPanel1;
bt.Text = "Bàn " + row[1].ToString();
bt.BackColor = Color.Lavender;
bt.ForeColor = Color.Navy;
bt.Font = new System.Drawing.Font("Microsoft Sans Serif", 17, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
var projectPath = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName;
string filePath = Path.Combine(projectPath, "Resources\\Icons8-Ios7-Household-Table.ico");
bt.Image = Image.FromFile(filePath, true);
bt.ImageAlign = System.Drawing.ContentAlignment.TopCenter;
bt.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
bt.BackgroundImageLayout = ImageLayout.Center;
bt.Click += Bt_Click;
}
LoadLabel();
//hide taskbar and fullscreen
FormState fm = new FormState();
fm.Maximize(this);
}
private void Form10_Load(object sender, EventArgs e)
{
DataTable danhmuc = new DataTable();
string lenh2 = "select distinct tenDM from DanhMucMonAn dm ";
danhmuc = sql.getDataTable(lenh2);
foreach (DataRow row in danhmuc.Rows)
{
Button bt = new Button();
bt.Parent = flowLayoutPanel1;
bt.Size = new Size(180, 55);
bt.Text = row[0].ToString();
bt.ForeColor = Color.DodgerBlue;
bt.BackColor = Color.SeaShell;
bt.Font = new Font(this.Font, FontStyle.Bold);
bt.Click += Bt_Click;;
}
}
private void Form11_Load(object sender, EventArgs e)
{
string lenh = "select tenCN,diaChi,dienThoai from ChiNhanh";
var dt = new DataTable();
var sql = new GetDataFromSQL();
dt = sql.getDataTable(lenh);
foreach (DataRow row in dt.Rows)
{
Button lb = new Button();
lb.Parent = flowLayoutPanel1;
lb.Text = "Chi nhánh " + row[0].ToString() + "\r\nĐịa chỉ: " + row[1].ToString() + "\r\nĐiện thoại " + row[2].ToString();
lb.ForeColor = Color.DarkGreen;
lb.BackColor = Color.AliceBlue;
lb.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
lb.Font = new System.Drawing.Font("Microsoft Sans Serif", 18, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
lb.Size = new Size(400, 150);
}
}
private void button5_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có muốn thanh toán đơn hàng này và in hóa đơn?", "Thanh toán", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
var sql = new GetDataFromSQL();
int i = dataGridView1.RowCount, j = 0;
decimal tien = 0;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
var dt = new DataTable();
string tenMonAn = row.Cells[0].Value.ToString();
string timMaMA = "select maMA from MonAn where tenMA=N'" + tenMonAn + "'";
dt = sql.getDataTable(timMaMA);
int maMA = 0;
foreach (DataRow dtRow in dt.Rows)
{
maMA = Convert.ToInt32(dtRow[0].ToString());
}
string lenh = "insert into ChiTietDonHang(maDonHang,maMA) values ('" + Form1.maDH + "','" + maMA + "')";
if (sql.ExecuteNonQuery(lenh) > 0)
{
j++;
}
string rank = "update MonAn set dem=dem+1 where maMA=" + maMA;
sql.ExecuteNonQuery(rank);
tien += Convert.ToDecimal(row.Cells[1].Value.ToString());
}
if (i == j)
{
string s = "update DonHang set maTTDH=4 , giaTriDonHang='" + tien + "' where maDH='" + Form1.maDH + "'";
sql.ExecuteNonQuery(s);
MessageBox.Show("Đã thanh toán. Vui lòng chờ in hóa đơn");
var f1 = new Form1();
this.Close();
f1.Show();
}
;
}
else
{
MessageBox.Show("Đã hủy thanh toán");
}
}
private void opening_Load(object sender, EventArgs e)
{
var sql = new GetDataFromSQL();
DataTable dh = new DataTable();
string lenh = "select ten, dh.maBA, maDH from KhachHang kh, DonHang dh where dh.SDT=kh.SDT and maTTDH=1";
dh = sql.getDataTable(lenh);
foreach (DataRow row in dh.Rows)
{
Button open = new Button();
open.Parent = flowLayoutPanel1;
open.Size = new Size(365, 165);
open.Text = row[0].ToString() + "\r\n" + row[1].ToString();
open.Font = new System.Drawing.Font("Microsoft Sans Serif", 25, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
open.ForeColor = Color.DodgerBlue;
open.BackColor = Color.Navy;
open.Click += open_Click;
open.LostFocus += open_LostFocus;
open.Name = row[1].ToString();
}
}
void LoadDonHangTuTongDai()
{
var table = new DataTable();
string lenh = "select ten, kh.SDT, maDH from KhachHang kh, DonHang dh where dh.SDT = kh.SDT and maTTDH = 7 and dh.maCN=" + Form1.maCN;
var sql = new GetDataFromSQL();
table = sql.getDataTable(lenh);
foreach (DataRow row in table.Rows)
{
Button bt = new Button();
bt.Parent = flowLayoutPanel1;
bt.Size = new Size(315, 165);
bt.Text = row[0].ToString() + "\r\n" + row[1].ToString();
bt.Font = new System.Drawing.Font("Microsoft Sans Serif", 25, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
bt.ForeColor = Color.DodgerBlue;
bt.BackColor = Color.Navy;
bt.Click += Bt_Click;
bt.LostFocus += Bt_LostFocus;
bt.Name = row[1].ToString();
bt.AccessibleName = row[2].ToString();
}
}