private void btnSave_Click(object sender, EventArgs e) { string strRating = ""; Messages oErrMsg = Messages.Instance; FeedBack oFeedBack = new FeedBack(); picbox.Visible = true; Application.DoEvents(); if (cboRating.Text.Trim() == "--Select--") { strRating = ""; } else { strRating = cboRating.Text.Trim(); } try { oErrMsg = oFeedBack.UpdateFeedBack(JobID, strRating, txtComments.Text.Trim(), AccountRef, PartNumber); if (!oErrMsg.IsError) { picbox.Visible = false; comments _cmm = new comments(); _cmm.Comments = txtComments.Text; _cmm.Rating = strRating; _cmm.Row = this.Row; _cmm.Col = this.Col; OnValueChanged(_cmm); DialogResult = DialogResult.OK; this.Close(); } else { picbox.Visible = false; MessageBox.Show(oErrMsg.Message); } } catch (Exception ex) { picbox.Visible = false; MessageBox.Show(ex.Message.ToString()); } }
private void Search() { Messages oErrMsg = Messages.Instance; FeedBack oFeedBack = new FeedBack(); DataSet ds = null; if (this.InvokeRequired) { this.Invoke(new MethodInvoker(delegate { this.Cursor = Cursors.WaitCursor; btnSearch.Enabled = false; })); } else { this.Cursor = Cursors.WaitCursor; btnSearch.Enabled = false; } if (!Utils.PingTest()) { if (this.InvokeRequired) { this.Invoke(new MethodInvoker(delegate { this.Cursor = Cursors.Default; MessageBox.Show("VPN disconnected. Please connect and try again.", "CSRAssistance"); return; })); } else { this.Cursor = Cursors.Default; MessageBox.Show("VPN disconnected. Please connect and try again.", "CSRAssistance"); return; } } if (chkExcludeCallCust.InvokeRequired) { chkExcludeCallCust.Invoke(new MethodInvoker(delegate { oErrMsg = oFeedBack.LoadData(dtfrom.Value.ToString("yyyyMMdd"), dtto.Value.ToString("yyyyMMdd"), (chkExcludeCallCust.Checked ? 1 : 0), txtSearch.Text, 1, Pager.PageSize, false, txtJobID.Text, dtExFrom.Value.ToString("yyyyMMdd"), dtExTo.Value.ToString("yyyyMMdd"), (chkRepair.Checked ? 1 : 0), RangeExclude); })); } else { oErrMsg = oFeedBack.LoadData(dtfrom.Value.ToString("yyyyMMdd"), dtto.Value.ToString("yyyyMMdd"), (chkExcludeCallCust.Checked ? 1 : 0), txtSearch.Text, 1, Pager.PageSize, false, txtJobID.Text, dtExFrom.Value.ToString("yyyyMMdd"), dtExTo.Value.ToString("yyyyMMdd"), (chkRepair.Checked ? 1 : 0), RangeExclude); } if (!oErrMsg.IsError) { ds = (DataSet) oErrMsg.Results; if (ds.Tables.Count > 0) { if (ds.Tables[0] != null) { dtExport = ds.Tables[0]; } } if (outlookGrid1.InvokeRequired) { outlookGrid1.Invoke(new MethodInvoker(delegate { if (ds.Tables.Count > 0) { outlookGrid1.BindData(ds, "data"); View = "BoundInvoices"; DataGridViewCellEventArgs evt = new DataGridViewCellEventArgs(2, -1); object sender = null; } })); } else { if (ds.Tables.Count > 0) { outlookGrid1.BindData(ds, "data"); View = "BoundInvoices"; DataGridViewCellEventArgs evt = new DataGridViewCellEventArgs(2, -1); object sender = null; } } this.Invoke(new Action(() => { this.wfrm.Hide(); Pager.RecordCount = 0; if (ds.Tables.Count > 0) Pager.RecordCount = Convert.ToInt32(ds.Tables["counter"].Rows[0]["CNT"].ToString()); Pager.PageSize = 20; Pager.MaximumNumberofLinks = (Pager.RecordCount > 0 ? 5 : 0); lblCount.Text = Pager.RecordCount.ToString(); if (Pager.RecordCount > 0) Pager.Visible = true; else Pager.Visible = false; })); } else { this.Invoke(new Action(() => { this.wfrm.Hide(); MessageBox.Show(oErrMsg.Message); })); } this.Invoke(new Action(() => { this.btnSearch.Enabled = true; this.Cursor = Cursors.Default; })); }
private void btnSearchRating_Click(object sender, EventArgs e) { Messages oErrMsg = Messages.Instance; FeedBack oFeedBack = new FeedBack(); DataSet ds = null; this.Cursor = Cursors.WaitCursor; btnSearchRating.Enabled = false; if (!Utils.PingTest()) { this.Cursor = Cursors.Default; MessageBox.Show("VPN disconnected. Please connect and try again.", "CSRAssistance"); return; } oErrMsg = oFeedBack.LoadRating(dtRateFrom.Value.ToString("yyyyMMdd"), dtRateTo.Value.ToString("yyyyMMdd"), (cboRating.Text == "--Select--" ? string.Empty : cboRating.Text), (chkBlankComment.Checked ? 1 : 0), 20, 1); if (!oErrMsg.IsError) { ds = (DataSet)oErrMsg.Results; if (ds.Tables.Count > 0) { dgList.DataSource = ds.Tables[0]; } this.wfrm.Hide(); bbaPager1.RecordCount = 0; if (ds.Tables.Count > 0) bbaPager1.RecordCount = Convert.ToInt32(ds.Tables["counter"].Rows[0]["CNT"].ToString()); bbaPager1.PageSize = 20; bbaPager1.MaximumNumberofLinks = (bbaPager1.RecordCount > 0 ? 5 : 0); lblCounter.Text = bbaPager1.RecordCount.ToString(); if (bbaPager1.RecordCount > 0) { bbaPager1.Visible = true; } else { bbaPager1.Visible = false; } this.Cursor = Cursors.Default; btnSearchRating.Enabled = true; } else { this.wfrm.Hide(); this.btnRatingSearch.Enabled = true; this.Cursor = Cursors.Default; MessageBox.Show(oErrMsg.Message); } }
private void Pager_PageClicked(object sender, PagerControl.PageClickEventHandler e) { Messages oErrMsg = Messages.Instance; FeedBack oFeedBack = new FeedBack(); DataSet ds = null; oErrMsg = oFeedBack.LoadData(dtfrom.Value.ToString("yyyyMMdd"), dtto.Value.ToString("yyyyMMdd"), (chkExcludeCallCust.Checked ? 1 : 0), txtSearch.Text, e.SelectedPage, Pager.PageSize, false, txtJobID.Text, dtExFrom.Value.ToString("yyyyMMdd"), dtExTo.Value.ToString("yyyyMMdd"), (chkRepair.Checked ? 1 : 0), (chkExcludeCallCust.Checked ? 1 : 0)); if(!oErrMsg.IsError) { ds = (DataSet)oErrMsg.Results; if (ds.Tables.Count > 0) { outlookGrid1.BindData(ds, "data"); View = "BoundInvoices"; DataGridViewCellEventArgs evt = new DataGridViewCellEventArgs(2, -1); } } }
private void bbaPager1_PageClicked(object sender, PagerControl.PageClickEventHandler e) { Messages oErrMsg = Messages.Instance; FeedBack oFeedBack = new FeedBack(); DataSet ds = null; oErrMsg = oFeedBack.LoadRating(dtRateFrom.Value.ToString("yyyyMMdd"), dtRateTo.Value.ToString("yyyyMMdd"), (cboRating.Text == "--Select--" ? string.Empty : cboRating.Text), (chkBlankComment.Checked ? 1 : 0), 20, e.SelectedPage); if (!oErrMsg.IsError) { ds = (DataSet)oErrMsg.Results; if (ds.Tables.Count > 0) { dgList.DataSource = ds.Tables[0]; } } }