private void SearchByMisc()
{
string strKeyWord = "", strFrom = "", strTo = "";
bool flag = false;
Messages oErrMsg = Messages.Instance;
CallerAssistant oCallerAssistant = new CallerAssistant();
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 (this.InvokeRequired)
{
this.Invoke(new MethodInvoker(delegate
{
//this.Cursor = Cursors.WaitCursor;
btnGo.Enabled = false;
btnFillJobs.Enabled = false;
if (rdAllDebtorJobs.Checked)
{
strKeyWord = "ALL DEBTOR JOBS";
flag = true;
}
if (!flag)
{
if (rdCallBack.Checked)
{
strKeyWord = "ONLY CALL BACK JOBS";
flag = true;
}
}
if (!flag)
{
if (rdAllDoneShip.Checked)
{
strKeyWord = "ALL DONE AND SHIPPED JOBS";
flag = true;
}
}
if (!flag)
{
if (rdCallNotDone.Checked)
{
strKeyWord = "ALL CALL NOT DONE JOBS";
flag = true;
}
}
if (!flag)
{
if (rdAllEscalated.Checked)
{
strKeyWord = "ALL ESCALATED JOBS";
flag = true;
}
}
if (!flag)
{
if (rdFrom.Checked)
{
strKeyWord = "FROM";
strFrom = dtpkFrom.Value.ToString("yyyyMMdd");
strTo = dtpkTo.Value.AddDays(1).ToString("yyyyMMdd");
flag = true;
}
else
{
strKeyWord = "";
strFrom = dtpkJobDate.Value.ToString("yyyyMMdd");
strTo = dtpkJobDate.Value.AddDays(1).ToString("yyyyMMdd");
}
}
}));
}
else
{
btnFillJobs.Enabled = false;
btnGo.Enabled = false;
}
if (this.InvokeRequired)
{
this.Invoke(new MethodInvoker(delegate
{
oErrMsg = oCallerAssistant.LoadData(strKeyWord, strFrom, strTo, 0);
if (!oErrMsg.IsError)
{
dgList.DataSource = ((DataSet) oErrMsg.Results).Tables[0];
this.wfrm.Hide();
btnGo.Enabled = true;
btnFillJobs.Enabled = true;
}
else
{
this.wfrm.Hide();
btnGo.Enabled = true;
btnFillJobs.Enabled = true;
MessageBox.Show(oErrMsg.Message);
}
}));
}
}
private void dgList_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0) return;
int rowSelect = 0;
Messages oMsg = Messages.Instance;
CallerAssistant oCallerAssistant = new CallerAssistant();
rowSelect = e.RowIndex;
string AccRef = dgList[1, rowSelect].Value.ToString();
lblJID.Text = dgList[0, rowSelect].Value.ToString();
lblOERef.Text = dgList[2, rowSelect].Value.ToString();
lblCustName.Text = dgList[7, rowSelect].Value.ToString();
lblContactName.Text = dgList[8, rowSelect].Value.ToString();
lblAccRef.Text = dgList[1, rowSelect].Value.ToString();
if (CSRBusiness.User.Country != "USA")
{
oMsg = oCallerAssistant.GetAddress(AccRef, true);
if (!oMsg.IsError)
{
txtPhNo.Text =PhoneFormat((string)oMsg.Results);
}
else
{
MessageBox.Show(oMsg.Results.ToString());
}
}
else
{
oMsg = oCallerAssistant.GetAddressUSA(AccRef, true);
if (!oMsg.IsError)
{
txtPhNo.Text = PhoneFormat((string)oMsg.Results);
}
else
{
MessageBox.Show(oMsg.Results.ToString());
}
}
if (CSRBusiness.User.Country != "USA")
{
oMsg = oCallerAssistant.GetAddress(AccRef, false);
if (!oMsg.IsError)
{
txtAddress.Text = (string)oMsg.Results;
}
else
{
MessageBox.Show(oMsg.Results.ToString());
}
}
else
{
oMsg = oCallerAssistant.GetAddressUSA(AccRef, false);
if (!oMsg.IsError)
{
txtAddress.Text = (string)oMsg.Results;
}
else
{
MessageBox.Show(oMsg.Results.ToString());
}
}
oMsg = oCallerAssistant.LoadRemarks(Convert.ToInt32(lblJID.Text), false);
if (!oMsg.IsError)
{
txtOldRem.Text = (string)oMsg.Results;
}
else
{
MessageBox.Show(oMsg.Results.ToString());
}
string callStatus = dgList[12, rowSelect].Value.ToString();
oMsg = oCallerAssistant.LoadRemarks(Convert.ToInt32(lblJID.Text), true);
if (!oMsg.IsError)
{
txtShopRemarks.Text = (string)oMsg.Results;
}
else
{
MessageBox.Show(oMsg.Results.ToString());
}
oMsg = oCallerAssistant.GetShippingInfo(lblJID.Text);
DataSet shipping = null;
if (!oMsg.IsError)
{
shipping = (DataSet)oMsg.Results;
}
else
{
MessageBox.Show(oMsg.Results.ToString());
}
cboShipNo.DataSource = null;
cboRetShipNo.DataSource = null;
cboShipNo.Items.Clear();
cboRetShipNo.Items.Clear();
if (shipping != null)
{
if (shipping.Tables[0].Rows.Count > 0)
{
cboShipNo.DataSource = shipping.Tables[0].DefaultView;
cboShipNo.DisplayMember = "NormalTrackNo";
cboShipNo.ValueMember = "NormalTrackNo";
cboShipNo.Enabled = true;
cboShipNo.SelectedIndex = 0;
lblShipCount.Text = cboShipNo.Items.Count.ToString();
}
else
{
cboShipNo.Items.Clear();
cboShipNo.Enabled = false;
lblShipCount.Text = "0";
}
if (shipping.Tables[1].Rows.Count > 0)
{
cboRetShipNo.DataSource = shipping.Tables[1].DefaultView;
cboRetShipNo.DisplayMember = "ReturnTrackNo";
cboRetShipNo.ValueMember = "ReturnTrackNo";
cboRetShipNo.Enabled = true;
cboRetShipNo.SelectedIndex = 0;
lblRetCount.Text = cboRetShipNo.Items.Count.ToString();
}
else
{
cboRetShipNo.Items.Clear();
cboRetShipNo.Enabled = false;
lblRetCount.Text = "0";
}
}
if (callStatus == "Escalated")
rdEscalated.Checked = true;
if (callStatus == "Not Done")
rdNotDone.Checked = true;
if (callStatus == "Done & Shipped")
rdDonewithShip.Checked = true;
if (callStatus == "Call Back")
rdCallBack.Checked = true;
if (callStatus == "Done")
rdDone.Checked = true;
}
private void SearchByID()
{
Messages oErrMsg = Messages.Instance;
CallerAssistant oCallerAssistant = new CallerAssistant();
if (this.InvokeRequired)
{
this.Invoke(new MethodInvoker(delegate
{
//this.Cursor = Cursors.WaitCursor;
btnGo.Enabled = false;
btnFillJobs.Enabled = false;
}));
}
else
{
btnFillJobs.Enabled = false;
btnGo.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 (this.InvokeRequired)
{
this.Invoke(new MethodInvoker(delegate
{
oErrMsg = oCallerAssistant.LoadData(txtJID.Text.Trim(), txtTrackNo.Text.Trim(), 1, 100, 0);
if (!oErrMsg.IsError)
{
dgList.DataSource = ((DataSet) oErrMsg.Results).Tables[0];
this.wfrm.Hide();
btnGo.Enabled = true;
btnFillJobs.Enabled = true;
}
else
{
this.wfrm.Hide();
btnGo.Enabled = true;
btnFillJobs.Enabled = true;
MessageBox.Show(oErrMsg.Message);
}
}));
}
}
private void btnSave_Click(object sender, EventArgs e)
{
CallerAssistant oCallerAssistant = new CallerAssistant();
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.", "CSR Assistance");
return;
}
}
btnSave.Enabled = false;
System.Windows.Forms.Application.DoEvents();
string status = string.Empty;
//this.Cursor = Cursors.WaitCursor;
if (rdDone.Checked)
{
status = "Done";
}
if (rdCallBack.Checked)
{
status = "Call Back";
}
if (rdDonewithShip.Checked)
{
status = "Done & Shipped";
}
if (rdNotDone.Checked)
{
status = "Not Done";
}
if (rdEscalated.Checked)
{
status = "Escalated";
}
if (Convert.ToInt32(lblJID.Text) > 0)
{
if (oCallerAssistant.SaveCallRem(lblJID.Text, txtPhNo.Text.Trim(), txtRem.Text, status, (lblOERef.Text.Trim().Length > 14 ? lblOERef.Text.Trim().Substring(14) : lblOERef.Text.Trim()), txtShopRemarks.Text.Trim()))
{
MessageBox.Show("Data saved successfully", "Call Status");
}
}
btnSave.Enabled = true;
System.Windows.Forms.Application.DoEvents();
}
