private void BindGrid(DateTime from, DateTime to) { try { Controllers.frm36Controller oController = new Controllers.frm36Controller(); DataTable dtCheckResult = oController.GetUnmatchInvoice(from, to); if (dtCheckResult.Rows.Count > 0) { dgvList.DataSource = dtCheckResult; ResetHeader(); } else { //clear data except headers var empty = dgvList.DataSource as DataTable; try { empty.Rows.Clear(); } catch (Exception)//handle null result on first search { } dgvList.DataSource = empty; } } 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); } }
private void BtnRefund_Click(object sender, EventArgs e) { #region CheckSelectedRow int status = 0; int index = 0; int foundindex = 0; foreach (DataGridViewRow row in dgvList.Rows) { if (row.Cells["colCheck"].Value == null ? false : bool.Parse(row.Cells["colCheck"].Value.ToString())) { if (status >= 1) //if already found { status = 2; } else //first selected { status = 1; foundindex = index; } } index++; } #endregion if (status == 0) //if no row selected { MetroMessageBox.Show(this, "\n" + Messages.CheckUnmatchedInvoice.NoSelectedRow, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try { var confirmResult = MetroMessageBox.Show(this, "\n" + Messages.CheckUnmatchedInvoice.ConfirmRefund, "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (confirmResult == DialogResult.Yes) { DataTable dt = new DataTable(); dt.Columns.Add("SEQ_NO"); int intseqno = 0; for (int i = 0; i < dgvList.Rows.Count; i++) //get selected items { bool value = bool.Parse(dgvList[0, i].Value == null ? "false" : dgvList[0, i].Value.ToString()); if (value == true) { intseqno = int.Parse(dgvList.Rows[i].Cells["SEQ_NO"].Value.ToString()); DataRow dr = dt.NewRow(); dr["SEQ_NO"] = intseqno; dt.Rows.Add(dr); } } Controllers.frm36Controller oController = new Controllers.frm36Controller(); bool success = oController.RefundProcess(dt); if (success) { btnCheckTheResult.PerformClick(); MetroMessageBox.Show(this, "\n" + Messages.CheckUnmatchedInvoice.StatusUpdatedToRefund, "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } 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); } } }