Esempio n. 1
0
        public re_issue_card()
        {
            InitializeComponent();
            card_type.Items.Add(new ComboItem(-1, "CARD TYPE"));

            // ADD MEMBERCARD TYPE TO CARD_TYPE
            String    queryString = "SELECT * FROM MEMBERCARD_TYPE WHERE (EXPIRY_DATE IS NULL OR GETDATE() <= EXPIRY_DATE) ORDER BY MEMBERCARD_TYPE_NAME";
            DataTable DT;

            using (DT = DB.getS(queryString, null, "GET LIMITED MEMBERCARD TYPE", false))
            {
                foreach (DataRow row in DT.Rows)
                {
                    card_type.Items.Add(new ComboItem(Convert.ToInt32(row["MEMBERCARD_TYPE_ID"].ToString()), row["MEMBERCARD_TYPE_NAME"].ToString()));
                }
            }

            card_type.Items.Add(new ComboItem(50, "GIFT CERTIFICATE"));
            //card_type.Items.Add(new ComboItem(99, "GIFT VOUCHER"));

            card_type.SelectedIndex = 0;
            GF.resizeComboBox(card_type);

            //UC EVENTS
            btn_dgv.DeleteClick  += new btn_dgv.DeleteClickHandler(DeleteClick);
            btn_dgv.RefreshClick += new btn_dgv.RefreshClickHandler(doLoadGridData);
            btn_dgv.SearchClick  += new btn_dgv.SearchClickHandler(doLoadGridData);

            //PAGING DELEGATE
            btn_dgv.firstClick        += new btn_dgv.firstClickHandler(doLoadGridData);
            btn_dgv.prevClick         += new btn_dgv.prevClickHandler(doLoadGridData);
            btn_dgv.nextClick         += new btn_dgv.nextClickHandler(doLoadGridData);
            btn_dgv.lastClick         += new btn_dgv.lastClickHandler(doLoadGridData);
            btn_dgv.pageNumberChanged += new btn_dgv.pageNumberChangedHandler(doLoadGridData);
        }
Esempio n. 2
0
        private void re_issue_card_approve_Load(object sender, EventArgs e)
        {
            if (GF.can_approve)
            {
                approve_id = GF.emp_id;
                approve_btn.PerformClick();
            }
            else
            {
                approved_by.Items.Add(new ComboItem(-1, "APPROVER"));
                approved_by.Items.Add(new ComboItem(0, "S.A."));

                String queryString = "SELECT EMP_ID, FULLNAME FROM EMPLOYEE WHERE EMP_STATUS=1 AND CAN_APPROVE=1 ORDER BY FULLNAME";
                using (DataTable DT = DB.getS(queryString, null, "GET APPROVABLE EMPLOYEE", false))
                {
                    foreach (DataRow row in DT.Rows)
                    {
                        approved_by.Items.Add(new ComboItem(Convert.ToInt32(row["EMP_ID"].ToString()), row["FULLNAME"].ToString()));
                    }
                }
                approved_by.SelectedIndex = 0;
                GF.resizeComboBox(approved_by);
            }
        }