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