public void RenderBrochure()
        {
            int iWidth = 587;
            int iHeight = 800;
            int iy = 224;

            panel1.Location = new Point(40, 322);
            panel1.Height = iHeight;
            panel1.Width = 750;

            iy = iy + iHeight;

            this.Width = 800;
            this.Height = 1224;
            pictureEmail.Location = new Point(221, iy + 100);

            //245, 653
            TransactionDB trans = new TransactionDB();
            //trans.CreateTransaction();

            EbrochureLinqDB brochure = new EbrochureLinqDB();
            DataTable dt;
            dt = brochure.GetDataList("", "", trans.Trans);
            trans.CommitTransaction();
            x = 0;
            y  =0 ;
            for (int i = 0; i < dt.Rows.Count; ++i)
            {
                AddItem(dt.Rows[i]["id"] + "", dt.Rows[i]["name_thai"] + "");
                // ++i;
            }
               // AddItem(1, "Service");
            //AddItem2(1, "count_queue");
            //AddItem3(1, "wait_time");
            //AddItem4(1, "app_queue");

            dt.Dispose();
            //FLP.Show();
            panel1.Show();
        }
 public string GetBrochureName(string id)
 {
     EbrochureLinqDB brochure = new EbrochureLinqDB();
     DataTable dt;
     dt = brochure.GetDataList("id=" + id, "", null);
     if (dt.Rows.Count > 0)
     {
         return dt.Rows[0]["name_thai"] + "";
     }
     else
     {
         return "";
     }
 }