private void BtnSubmit_Click(object sender, EventArgs e) { //get column values where MK not null or empty DataTable dt = uIUtility.SubmitChanges(); //send to web service frmUsageChargeMasterController oController = new frmUsageChargeMasterController(); try { if (dt.Rows.Count > 0) { DataTable result = oController.Submit(dt, out uIUtility.MetaData); //update data grid view uIUtility.UpdateReturnedresults(result); } } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); } }
private void BindGrid() { try { //assign search keywords string company_no_box = txtCONTRACT_CODE.Text; string company_name = txtCONSTRACT_NAME.Text; //string email = txtEmail.Text; if (CheckUtility.SearchConditionCheck(this, lblCONTRACT_CODE.Text, txtCONTRACT_CODE.Text, false, Utility.DataType.HALF_ALPHA_NUMERIC, 10, 0) && CheckUtility.SearchConditionCheck(this, lblCONSTRACT_NAME.Text, txtCONSTRACT_NAME.Text, false, Utility.DataType.FULL_WIDTH, 80, 0) ) { frmUsageChargeMasterController oController = new frmUsageChargeMasterController(); DataTable dt = oController.GetUsageChargeMaster(company_no_box, company_name, uIUtility.MetaData.Offset, uIUtility.MetaData.Limit, out uIUtility.MetaData); if (dt.Rows.Count > 0) { uIUtility.dtList = dt; dgvList.DataSource = uIUtility.dtList; uIUtility.dtOrigin = uIUtility.dtList.Copy(); //pagination uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } else { //clear data except headers uIUtility.ClearDataGrid(); uIUtility.CalculatePagination(lblcurrentPage, lblTotalPages, lblTotalRecords); } uIUtility.CheckPagination(btnFirst, btnPrev, btnNext, btnLast, lblcurrentPage.Text, lblTotalPages.Text); uIUtility.FormatUpdatedat(); } } catch (System.TimeoutException) { MetroMessageBox.Show(this, "\n" + Messages.General.ServerTimeOut, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Net.WebException) { MetroMessageBox.Show(this, "\n" + Messages.General.NoConnection, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { Utility.WriteErrorLog(ex.Message, ex, false); MetroMessageBox.Show(this, "\n" + Messages.General.ThereWasAnError, "Search Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } }