private OrderDrink_DTO LayTTHD()
{
for (int i = 0; i < gridView.Rows.Count - 1; i++)
{
listOrder.Add("'" + gridView.Rows[i].Cells[0].Value.ToString() + "'");
}
BsonArray array = new BsonArray();
foreach (var b in listOrder)
{
array.Add(b);
}
OrderDrink_DTO dg = new OrderDrink_DTO();
dg.TenBan = lbTenBan.Text;
dg.SoHoaDon = int.Parse(txtSoHoaDon.Text);
dg.KhachHang = txtKhachHang.Text;
dg.NguoiThuNgan = txtPhucVu.Text;
dg.SanPham = array;
dg.TongTien = double.Parse(txtTongTien.Text);
dg.Thoigian = txtThoiGian.Text;
return(dg);
}
//Thêm Giáo Viên vào CSDL
public void InsertEmployees(OrderDrink_DTO nv)
{
conn.Connect();
string a = "InsertOrder('" + nv.TenBan + "','" + nv.SoHoaDon + "',' " + nv.KhachHang + "','" + nv.NguoiThuNgan + "'," + nv.SanPham + "," + nv.TongTien + ",'" + nv.Thoigian + "')";
conn.KetNoi(a);
}
private void btnTT_Click(object sender, EventArgs e)
{
if (lbTenBan.Text == "" || txtKhachHang.Text == "" || txtBonus.Text == "" || txtPhucVu.Text == "" || txtSoHoaDon.Text == "" || txtThoiGian.Text == "" || txtTongTien.Text == "")
{
MessageBox.Show("Vui lòng chọn bàn!!!");
}
else
{
DataRport dg = LayTT();
DataTable dt = new DataTable();
OrderDrink_DTO tg = LayTTHD();
dgOrder.InsertEmployees(tg);
count++;
txtSoHoaDon.Text = count.ToString();
#region
//Adding columns to datatable
dt.Columns.Add("tenBan", typeof(string));
dt.Columns.Add("thoiGian", typeof(string));
dt.Columns.Add("soHoaDon", typeof(string));
dt.Columns.Add("KhachHang", typeof(string));
dt.Columns.Add("tongTien", typeof(string));
dt.Columns.Add("nguoiThuNgan", typeof(string));
dt.Columns.Add("SanPham", typeof(string));
DataRow row;
row = dt.NewRow();
row["tenBan"] = dg.TenBan;
row["thoiGian"] = dg.Thoigian;
row["soHoaDon"] = dg.SoHoaDon;
row["KhachHang"] = dg.KhachHang;
row["tongTien"] = dg.TongTien.ToString();
row["nguoiThuNgan"] = dg.NguoiThuNgan;
for (int i = 0; i < gridView.Rows.Count - 1; i++)
{
//row[i.ToString()] = gridView.Rows[i].Cells[0].Value.ToString();
row["SanPham"] += gridView.Rows[i].Cells[0].Value.ToString() + ",";
}
dt.Rows.Add(row);
#endregion
ReportBaoCao report = new ReportBaoCao();
report.DataSource = dt;
report.ShowPreviewDialog();
txtKhachHang.ResetText();
txtBonus.Text = "0";
txtThoiGian.ResetText();
txtTongTien.ResetText();
lbTenBan.ResetText();
gridView.Rows.Clear();
}
}
