public void loadListTable()
{
TableDAO tableDAO = new TableDAO();
var tables = (List <Table>)tableDAO.LoadListTable();
flowLayoutPanel1.Controls.Clear();
foreach (Table item in tables)
{
Button button = new Button();
int id = item.tablestatus_id;
button.Text = item.title + "\n" + getTableStatusByID(id);
button.Width = 80;
button.Height = 80;
button.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
button.Font = new System.Drawing.Font("Tahoma", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
button.FlatAppearance.MouseDownBackColor = System.Drawing.Color.Gray;
button.FlatAppearance.MouseOverBackColor = System.Drawing.Color.FromArgb(((int)(((byte)(17)))), ((int)(((byte)(17)))), ((int)(((byte)(17)))));
button.BackColor = Color.FromArgb(17, 17, 17);
button.Tag = item;
if (item.tablestatus_id == 0)
{
button.ForeColor = Color.FromArgb(243, 119, 53);
button.FlatAppearance.BorderColor = System.Drawing.Color.FromArgb(243, 119, 53);
}
if (item.tablestatus_id != 0)
{
button.ForeColor = Color.SeaGreen;
button.FlatAppearance.BorderColor = System.Drawing.Color.SeaGreen;
}
button.Click += Button_Click;
flowLayoutPanel1.Controls.Add(button);
}
cbListTable.DataSource = tables;
cbListTable.DisplayMember = "title";
}
public static List <DBColInfo> GetColsByTable(string Server, string DB, string Table)
{
var tableDao = new TableDAO();
var list = new List <DBColInfo>();
return(tableDao.GetTable(Server, DB, Table).Cols);
}
public JsonResult Table_show()
{
var dao = new TableDAO();
var result = dao.GetTable_show();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void LoadTable()
{
flpTableList.Controls.Clear();
TableDAO tbdao = new TableDAO();
List <Table> tablelist = tbdao.LoadTable();
foreach (Table item in tablelist)
{
Button btn = new Button();
btn.Width = 115;
btn.Height = 115;
btn.Click += btn_Click;
btn.Tag = item;
btn.Text = item.Name + "\r\n\r\n" + item.Status;
if (item.Status.Equals("Trống"))
{
btn.BackColor = Color.LightSkyBlue;
}
else
{
btn.BackColor = Color.LightPink;
}
flpTableList.Controls.Add(btn);
}
}
private void Form1_Load(object sender, EventArgs e)
{
TableDAO table = new TableDAO();
dgvtable.DataSource = bindingSource;
bindingSource.DataSource = table.tablelist();
addBindingsourcebanan();
}
private void btnespece_Click(object sender, RoutedEventArgs e)
{
decimal t;
decimal t2;
Decimal.TryParse(txtEspece.Text, out t);
Decimal.TryParse(lbltotal.Content.ToString(), out t2);
if (t > t2)
{
decimal rest = t - t2;
MessageBox.Show("reste de Commande = " + rest + "DT");
TK_et_FK tk = new TK_et_FK(id);
tk.ShowDialog();
CommandeDAO daoc = new CommandeDAO();
daoc.updateEtat(id);
ChequeDAO daoch = new ChequeDAO();
int lastch = daoch.getLastCheque() + 1;
Payement pa = new Payement(1, id, t);
PayementDAO daop = new PayementDAO();
daop.addesp(pa);
g.PerformRefresh();
TableDAO table = new TableDAO();
Commande c = daoc.getById(id);
table.update(c.NumTable, false);
g.dgmois.Items.Refresh();
this.Close();
}
else if (t < t2)
{
lbltotal.Content = t2 - t;
Payement pa = new Payement(1, id, t);
PayementDAO daop = new PayementDAO();
daop.addesp(pa);
g.PerformRefresh();
}
else
{
TK_et_FK tk = new TK_et_FK(id);
tk.ShowDialog();
CommandeDAO daoc = new CommandeDAO();
daoc.updateEtat(id);
ChequeDAO daoch = new ChequeDAO();
int lastch = daoch.getLastCheque() + 1;
Payement pa = new Payement(1, id, t);
PayementDAO daop = new PayementDAO();
daop.addesp(pa);
g.PerformRefresh();
TableDAO table = new TableDAO();
Commande c = daoc.getById(id);
table.update(c.NumTable, false);
this.Close();
}
}
public IList <View> Post(
[FromServices] ISession session,
[FromServices] UserDAO userDAO,
[FromServices] TableDAO tableDAO,
[FromServices] FieldDAO fieldDAO,
[FromServices] ViewDAO viewDAO)
{
return(session.QueryOver <View>().List());
}
public void RemoveTableDetail(int TableId)
{
var lt = new TableDAO().getTableDetailyByIDFull(TableId);
foreach (var index in lt)
{
new TableDAO().removeTableDetail(index.MaChiTietBanAn);
}
}
public int checkTableStatus(int tableId)
{
var table = new TableDAO().findTableByID(tableId);
if (table.TinhTrang == "Trống")
{
return(0);
}
return(1);
}
public SetupService()
{
mObjInternalFreightDAO = new TableDAO <InternalFreight>();
mObjRoutesDAO = new TableDAO <Routes>();
mObjCommissionsDAO = new TableDAO <Commissions>();
mObjCommissionLineDAO = new TableDAO <CommissionLine>();
mObjStartDay = new TableDAO <StartDay>();
mObjCommissionsRows = new TableDAO <CommissionsRows>();
mobjTownDAO = new TableDAO <TOWN>();
}
/// <summary>
/// <see cref="ValidationAttribute.IsValid(object, ValidationContext)" />
/// </summary>
protected override ValidationResult IsValid(object value, ValidationContext context)
{
ISession session = GetContextParameter <ISession>(context);
TableDAO dao = new TableDAO(session);
string typed = value as string;
return(dao.IsTableCodeAvailable(typed) ?
ValidationResult.Success :
new ValidationResult("Table code is unavailable"));
}
public ActionResult BookTable(BookTable model)
{
var kq1 = new BookTableDAO().Insert(model);
var kq2 = new TableDAO().Update(model);
if (kq1 & kq2)
{
return(Redirect("/trang-chu"));
}
return(PartialView(model));
}
public List <int> getAllIdTable()
{
var temp = new TableDAO().getAllTable();
List <int> l = new List <int>();
foreach (var index in temp)
{
l.Add(index.MaBan);
}
return(l);
}
// public static void Update(Table table)
// {
// if (TableDAO.Update(table))
// {
// MessageBox.Show("Cập nhật thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
// }
// else
// {
// MessageBox.Show("Cập nhật thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
// }
public static void Delete(int num)
{
if (TableDAO.Delete(num))
{
MessageBox.Show("Xóa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Xóa thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary> Default constructor. </summary>
/// <remarks> Ranaya, 24/05/2017. </remarks>
public SetupService()
{
mObjDestinationRequestDAO = new TableDAO <DestinationRequest>();
mObjParameterRequestDAO = new TableDAO <ParameterRequest>();
mObjPermissionRequestDAO = new TableDAO <PermissionRequest>();
mObjPortRequestDAO = new TableDAO <PortRequest>();
mObjProductRequestDAO = new TableDAO <ProductRequest>();
mobjSaleOrderDAO = new SAPObjectDAO <SaleOrder>();
mobjSaleOrderDetailDAO = new SAPObjectDAO <SaleOrderDetail>();
mobjItemDAO = new SAPObjectDAO <Item>();
}
public static void Add(int i)
{
if (TableDAO.Add(i))
{
MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Thêm thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void createBillDetail(int tableId, int billId)
{
var tableDetail = new TableDAO().getTableDetailyByID(tableId);
foreach (var index in tableDetail)
{
var billToAdd = new ChiTietHoaDon()
{
MaSanPham = index.MaSanPham, MaHoaDon = billId, SoLuong = index.SoLuong, DonGia = index.DonGia
};
new TableDAO().addBillDetail(billToAdd);
}
}
public static void ShowTable(DataGridView gridView)
{
//Lấy data dưới dạng bảng
DataSet dataSet = TableDAO.SelectTable();
if (dataSet.Tables.Count > 0)
{
dataSet.Tables[0].Columns[0].ColumnName = "Số bàn";
// dataSet.Tables[0].Columns[1].ColumnMapping = MappingType.Hidden;
dataSet.Tables[0].Columns[2].ColumnName = "Trạng thái";
gridView.DataSource = dataSet.Tables[0];
}
}
void Start()
{
TableDAO tableDAO = new TableDAO();
OrderDAO orderDAO = new OrderDAO();
MenuDAO menuDAO = new MenuDAO();
//menuDAO.Insert(915, "Secret menu", new TimeSpan(10, 10, 10), new TimeSpan(10, 20, 20));
List <Menu> menus = menuDAO.GetAll();
Console.WriteLine(menus);
Console.ReadKey();
}
public int switchTable(int tableFrom, int tableTo)
{
var tableSwitch = new TableDAO().findTableByID(tableTo);
var tableIndex = new TableDAO().findTableByID(tableFrom);
if (tableSwitch.TinhTrang == "Có người")
{
return(1); // fail
}
// Ngược lại : update table
new TableDAO().updateTableStatus(tableFrom, tableTo);
return(0); // success
}
private void btndelete_Click(object sender, EventArgs e)
{
int ID = Convert.ToInt32(txtID.Text);
TableDAO table = new TableDAO();
bool Thanhcong = table.xoaban(ID);
if (Thanhcong == false)
{
MessageBox.Show("Xóa bàn không thành công (-_-) , vui lòng thử lại sau", "Thông báo");
return;
}
MessageBox.Show("Xóa bàn thành công (^_^)", "Thông báo");
dgvtable.DataSource = table.tablelist();
}
public async Task <bool> Create(Table Table)
{
TableDAO TableDAO = new TableDAO();
TableDAO.Id = Table.Id;
TableDAO.Code = Table.Code;
TableDAO.OrderId = Table.OrderId;
DataContext.Table.Add(TableDAO);
await DataContext.SaveChangesAsync();
Table.Id = TableDAO.Id;
await SaveReference(Table);
return(true);
}
public ActionResult GetTableList()
{
var Server = "Server".ValueOfForm().TryString("DefaultServer");
string dbName = "DBName".ValueOfForm();
string tbName = "TableName".ValueOfForm();
TableDAO tableDao = new TableDAO();
var tbList = tableDao.GetTableList(Server, dbName);
if (tbList != null && tbList.Count() > 0 && tbName.IsNullOrEmpty() == false)
{
tbList = tbList.Where(t => t.TableName.Contains(tbName)).DefaultIfEmpty().ToList();
}
ViewBag.DBList = tbList;
return(View("~/Views/DBManage/MenuPage_PartTableList.cshtml"));
}
public async Task <bool> BulkMerge(List <Table> Tables)
{
List <TableDAO> TableDAOs = new List <TableDAO>();
foreach (Table Table in Tables)
{
TableDAO TableDAO = new TableDAO();
TableDAO.Id = Table.Id;
TableDAO.Code = Table.Code;
TableDAO.OrderId = Table.OrderId;
TableDAOs.Add(TableDAO);
}
await DataContext.BulkMergeAsync(TableDAOs);
return(true);
}
public async Task <bool> Update(Table Table)
{
TableDAO TableDAO = DataContext.Table.Where(x => x.Id == Table.Id).FirstOrDefault();
if (TableDAO == null)
{
return(false);
}
TableDAO.Id = Table.Id;
TableDAO.Code = Table.Code;
TableDAO.OrderId = Table.OrderId;
await DataContext.SaveChangesAsync();
await SaveReference(Table);
return(true);
}
private void btnswitchtable_Click(object sender, EventArgs e)
{
if ((lsvBill.Tag as TableDTO) == null || (cbswitch.SelectedItem as TableDTO) == null)
{
MessageBox.Show("Hãy chọn bàn để chuyển bạn nhé", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
int idtable1 = (lsvBill.Tag as TableDTO).ID;
int idtable2 = (cbswitch.SelectedItem as TableDTO).ID;
if (MessageBox.Show(string.Format("Bạn chắc chuyển từ {0} sang {1}", (lsvBill.Tag as TableDTO).Tenban, (cbswitch.SelectedItem as TableDTO).Tenban), "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
TableDAO.ChuyenBan(idtable1, idtable2);
}
LoadTable();
}
public SetupService()
{
mObjRiseDAO = new TableDAO <Rise>();
mObjRiseEmployeesDAO = new TableDAO <Employees>();
mObjRiseContractsDAO = new TableDAO <Contracts>();
mObjRiseConsumablesDAO = new TableDAO <Consumables>();
mObjRiseTravelExpensesDAO = new TableDAO <TravelExpenses>();
mObjInitialRecordsDAO = new TableDAO <InitialRecords>();
mObjPurchaseOrdersDAO = new TableDAO <PurchaseOrders>();
mObjFinalsRecordsDAO = new TableDAO <FinalsRecords>();
mObjTotalRecordsDAO = new TableDAO <TotalRecords>();
mObjHoursRecordsDAO = new TableDAO <HoursRecords>();
mObjTransitHoursRecordsDAO = new TableDAO <TransitHoursRecords>();
mObjPerformanceDAO = new TableDAO <Performance>();
mObjDocumentsHistoryDAO = new TableDAO <DocumentsHistory>();
mObjAuthorizationsDAO = new TableDAO <Authorizations>();
mObjCommissionsDAO = new TableDAO <Commissions>();
}
// private static void newOrder()
// {
// MessageBox.Show("ok");
// }
public static void ShowIcon(FlowLayoutPanel flowLayoutPanel, Panel panel, int x)
{
List <Table> tables = TableDAO.SelectAll(x);
// lặp qua lần lượt các bàn
foreach (var table in tables)
{
Button btn = new Button();
String nameBtn = String.Format("Bàn {0}", table.Id);
btn.Name = table.Id;
btn.Text = nameBtn;
btn.Font = new Font("Segoe UI", 14F);
btn.Size = new Size(100, 50);
// hiển thị trang thái bàn
switch (table.Status)
{
case 1:
btn.BackColor = Color.Chartreuse;
btn.Click += showStatus;
break;
case 2:
btn.BackColor = Color.Firebrick;
btn.Click += showStatus;
break;
case 3:
btn.BackColor = Color.Goldenrod;
btn.Click += showStatus;
break;
case 4:
btn.BackColor = Color.Gray;
btn.Click += showStatus;
break;
}
//xác định vị trí nút được gắn vào panel nào
flowLayoutPanel.Controls.Add(btn);
}
}
private void btnadd_Click(object sender, EventArgs e)
{
string name = txtName.Text;
int status = 0;
if (cbstatus.SelectedItem.ToString() == "Có Người")
{
status = 1;
}
int capacity = Convert.ToInt32(nmcapacity.Value);
TableDAO table = new TableDAO();
bool Thanhcong = table.Thembanan(name, status, capacity);
if (Thanhcong == false)
{
MessageBox.Show("Thêm bàn không thành công (-_-) , vui lòng thử lại sau", "Thông báo");
return;
}
MessageBox.Show("Thêm bàn thành công (^_^)", "Thông báo");
dgvtable.DataSource = table.tablelist();
}
public ActionResult TableInfoEdit()
{
var Server = "Server".ValueOfQuery().TryString("DefaultServer");
var dbName = "DBName".ValueOfQuery();
var tbName = "TableName".ValueOfQuery();
try
{
//填充dbList
TableDAO tbDao = new TableDAO();
DBTableInfo tb = tbDao.GetTable(Server, dbName, tbName);
this.ViewBag.TableInfo = tb;
this.ViewBag.Indexs = tbDao.GetIndexs(Server, dbName, tbName);
return(View("~/Views/DBManage/TableInfoEdit.cshtml"));
}
catch (Exception ex)
{
Response.Write(ex.GetInnerMessage());
return(View("~/Views/Shared/ErrorHander.cshtml"));
}
}
