private void btnok_Click(object sender, EventArgs e) { int key = 0; TableMenuDAL tbmenuDAL = new TableMenuDAL(); DataTable dtmenu = tbmenuDAL.getTableMenu(); TableMenu tbmenu = new TableMenu(); tbmenu.Area = cbxarea.SelectedItem.ToString(); string filterExpression = string.Format("Area='{0}'", tbmenu.Area); DataRow[] rows = dtmenu.Select(filterExpression); if (rows.Length == 0) { tbmenu.TableName = tbtablename.Text; } else { key++; lbloitablename.Text = "*Tên bàn bị trùng"; } tbmenu.Status = 0; if (key == 0) { tbmenuDAL.insertTableMenu(tbmenu); lbnotice1.Text = "Thêm bàn thành công"; } else { lbnotice1.Text = "Thêm bàn thất bại"; } }
/// <summary> /// Creates a new TMS Home Page object by initializing elements that are genetical for all class' children - left hand menu, projects tabs and right corner application board. /// </summary> /// <exception cref="System.Exception">Thrown when actual URL adress is different than https:\/\/tms.lionbridge.com\/</exception> /// <param name="driver"> is passed IWebDriver in the actual state.</param> public TMSProjectHomePage(IWebDriver driver) { if (driver.Url != "https://tms.lionbridge.com/") { throw new Exception("URL address is not equal to https://tms.lionbridge.com/."); } this.driver = driver; /* If there should be a wait here, it should be a maximum for three initialized fields. */ tableMenu = new TableMenu(driver); appBoard = new AppBoard(driver); leftMenu = new LeftMenu(driver); }
private void Tree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { Tree.SelectedNode = e.Node; if (e.Button == MouseButtons.Right) { if (e.Node.ImageIndex == 3) { ServerMenu.Show(Cursor.Position); } else if (e.Node.ImageIndex == 4) { DatabaseMenu.Show(Cursor.Position); } else if (e.Node.ImageIndex == 5) { TableMenu.Show(Cursor.Position); } } }
public IQueryable <MenuDetails> GetRestaurantMenu(int restaurantID) { List <MenuDetails> menudetails = new List <MenuDetails>(); try { if (db != null) { var menudetail = (from offer in db.TblOffer join menu in db.TblMenu on offer.TblMenuId equals menu.Id into TableMenu from menu in TableMenu.ToList() join rest in db.TblRestaurant on menu.TblRestaurantId equals rest.Id where offer.TblRestaurantId == restaurantID select new MenuDetails { tbl_Offer = offer, tbl_Restaurant = rest, tbl_Menu = menu }).ToList(); foreach (var item in menudetail) { MenuDetails menuitem = new MenuDetails { tbl_Restaurant = item.tbl_Restaurant, tbl_Menu = item.tbl_Menu, tbl_Offer = item.tbl_Offer }; menudetails.Add(menuitem); } } return(menudetails.AsQueryable()); } catch (Exception ex) { throw ex; } }
public void insertTableMenu(TableMenu tb) { string query = string.Format("INSERT dbo.TableMenu(TableName, Status, Area) VALUES('{0}', {1}, '{2}')", tb.TableName, tb.Status, tb.Area); dbConnect.ExecuteNonQuery(query); }