protected void Page_Load(object sender, EventArgs e)
{
ConnectDatabase alayer = new ConnectDatabase();
SqlDataReader reader;
int num = 0;
string GroupNo, MenuName = "", ImagePath, MenuPrice, MenuDescription, Mode;
if (Request.QueryString["Menu_Name"] != null)
{
MenuName = Request.QueryString["Menu_Name"];
}
if (Request.QueryString["Menu_Group"] != null)
{
GroupNo = Request.QueryString["Menu_Group"];
Label_Groupno.Text = GroupNo;
num = Convert.ToInt32(GroupNo.ToString());
}
reader = alayer.GetAllMenuTableFromDB(num, MenuName);
if (reader != null)
{
while (reader.HasRows)
{
MenuName = reader.GetName(0);
MenuPrice = reader.GetName(1);
while (reader.Read())
{
MenuName = reader.GetString(0);
MenuPrice = reader.GetString(1);
ImagePath = reader.GetString(2);
MenuDescription = reader.GetString(3);
ImagePath = ImagePath.Trim();
MenuDescription = MenuDescription.Trim();
Label3.Text = MenuName;
Image1.ImageUrl = ImagePath;
txtMenuName.Text = MenuName;
txtMenuPrice.Text = MenuPrice;
Session["ImagePath"] = ImagePath;
txtMenuDescription.Text = MenuDescription;
}
reader.NextResult();
}
}
else
{
Response.Write("<script>alert('Can not get data from database');window.location='ViewUserPage.aspx';</script>");
return;
}
reader.Close();
}
public CTable CreateCTableObject()
{
CTable o = new CTable("");
o.SetFieldValue("EXT_FLAG", "A");
o.SetFieldValue("SELECTION_TYPE", SelectionType);
o.SetFieldValue("ITEM_ID", ItemID);
o.SetFieldValue("ITEM_NAME_THAI", ItemName);
o.SetFieldValue("ITEM_CODE", ItemCode);
o.SetFieldValue("ITEM_CATEGORY_ID", ItemCategoryID);
o.SetFieldValue("SERVICE_ID", ServiceID);
o.SetFieldValue("SERVICE_NAME", ServiceName);
o.SetFieldValue("SERVICE_CODE", ServiceCode);
o.SetFieldValue("CODE", Code);
o.SetFieldValue("NAME", Name);
o.SetFieldValue("VOUCHER_ID", si.VoucherID);
o.SetFieldValue("VOUCHER_NAME", si.VoucherName);
o.SetFieldValue("VOUCHER_CODE", si.VoucherNo);
o.SetFieldValue("FREE_TEXT", si.FreeText);
String flag = "N";
if (IsTray)
{
flag = "Y";
}
o.SetFieldValue("IS_TRAY", flag);
String pricedFlag = "N";
if (IsPriced)
{
pricedFlag = "Y";
}
o.SetFieldValue("IS_PRICED", pricedFlag);
o.SetFieldValue("TOTAL_AMOUNT", TotalAmount.ToString());
o.SetFieldValue("DISCOUNT", Discount.ToString());
o.SetFieldValue("AMOUNT", Amount.ToString());
o.SetFieldValue("QUANTITY", Quantity.ToString());
o.SetFieldValue("BASKET_TYPE", ((int)BasketType).ToString());
o.SetFieldValue("BUNDLE_AMOUNT", BundledAmount.ToString());
o.SetFieldValue("GROUP_NO", GroupNo.ToString());
o.SetFieldValue("SEQUENCE", Sequence.ToString());
o.SetFieldValue("PROMOTION_CODE", Sequence.ToString());
o.SetFieldValue("PROMOTION_NAME", Sequence.ToString());
o.SetFieldValue("DISPLAY_CATEGORY", DisplayCategory.ToString());
return(o);
}
public void DeleteMainDisplayMenu()
{
string query, MenuName, GroupNo;
SqlCommand command;
connection = new SqlConnection(connectionString);
connection.Open();
query = "select Menu_Name from tblSelectMenu";
command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
MenuName = reader.GetName(0);
GroupNo = reader.GetName(1);
while (reader.Read())
{
MenuName = reader.GetString(0);
GroupNo = reader.GetString(1);
MenuName = MenuName.Trim();
GroupNo = GroupNo.Trim();
if (MenuName != "")
{
query = "DELETE FROM tblDisplayMenu WHERE Menu_Name='" + MenuName + "'";
DeleteItemFromTable(query);
}
}
reader.NextResult();
}
reader.Close();
query = "DELETE tblSellectMenu";
DeleteItemFromTable(query);
connection.Close();
}
