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);
}
