private void buttonValidate_Click(object sender, EventArgs e)
{
GroupClient generalService = new GroupClient("ReportWSServiceHttpEndpoint2");
WSCarrierLookupResponse wSCarrierLookupResponse;
string securityToken;
string orgCode = "wt63419";
// Moses Newman 06/01/2020 replace with SBTNonValid
//CUSTOMERTableAdapter.FillByActiveDayDue(IACData.CUSTOMER, 0, false, true);
CUSTOMERTableAdapter.FillBySBTNonValidDefi(IACData.CUSTOMER);
progressBar1.Minimum = 0;
progressBar1.Maximum = IACData.CUSTOMER.Rows.Count;
for (Int32 i = 0; i < IACData.CUSTOMER.Rows.Count; i++)
{
labelStatus.Text = "Working on customer " + IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_NO") + " " + i.ToString().TrimStart() + " of " + (IACData.CUSTOMER.Rows.Count - 1).ToString().TrimStart();
labelStatus.Refresh();
// Moses Newman 07/21/2020 Only Force Validate people who have not opted out
string[] phone = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_CELL_PHONE").Split(',');
if (GetSubscriberStatus(phone[0]) != "Inactive" && phone[0] != "")
{
securityToken = sbtLogin();
wSCarrierLookupResponse = generalService.GetCarrierLookup(securityToken, phone, orgCode);
if (!wSCarrierLookupResponse.Result)
{
MakeComment("*** Failed to VALIDATE cell phone number! ***", wSCarrierLookupResponse.Message, i);
IACData.CUSTOMER.Rows[i].SetField <Boolean>("CellValid", false);
}
else
{
if (wSCarrierLookupResponse.Result && !wSCarrierLookupResponse.Response[0].Landline)
{
string VBTError = "", gsVBTPin = "";
MessageClient messageResult = new MessageClient("MessageWSServiceHttpEndpoint");
securityToken = sbtLogin();
string phoneNo = phone[0];
WSVerificationResponse wSVerificationResponse = messageResult.RequestVBT(securityToken, orgCode, phoneNo);
if (!wSVerificationResponse.Result)
{
gsVBTPin = "";
VBTError = wSVerificationResponse.Message;
if (VBTError.TrimEnd() != "Subscriber information already exists")
{
IACData.CUSTOMER.Rows[i].SetField <Boolean>("TAcct", false);
MakeComment("*** VBT PIN NOT CREATED! ***", VBTError, i);
MessageBox.Show(VBTError);
}
}
else
{
gsVBTPin = "AUTO";
IACData.CUSTOMER.Rows[i].SetField <Boolean>("DNTAcct", false);
IACData.CUSTOMER.Rows[i].SetField <Boolean>("TAcct", true);
MakeComment("VBT AUTO CREATED.", wSVerificationResponse.Message, i);
}
if (gsVBTPin == "AUTO")
{
SubscriberClient subscriberService = new SubscriberClient("SubscriberWSServiceHttpEndpoint");
SubscriberInfo subscriber = new SubscriberInfo();
SubscriberDetails subdetails = new SubscriberDetails();
subscriber.MobilePhone = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_CELL_PHONE");
subscriber.FName = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_FIRST_NAME");
subscriber.LName = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_LAST_NAME");
EmailTableAdapter.Fill(IACData.Email, IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_NO"));
subscriber.Email = IACData.Email.Rows[0].Field <String>("EmailAddress");
subscriber.City = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_CITY");
subscriber.Street = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_STREET_1");
subscriber.Street2 = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_STREET_2");
subscriber.ZipCode = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_ZIP_1") + IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_ZIP_2");
subscriber.CustomField1 = "";
subscriber.CustomField2 = "";
subscriber.CustomField3 = "";
subscriber.PrivateCode = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_PURCHASE_ORDER");
subscriber.UniqueID = IACData.CUSTOMER.Rows[i].Field <String>("CUSTOMER_NO");
securityToken = sbtLogin();
WSSubscriberResponse wSSubscriberResponse = subscriberService.UpdateSubscriber(securityToken, subscriber);
if (!wSSubscriberResponse.Result)
{
MakeComment("*** SBT SUBSCRIBER FIELDS UPDATE FAILED! ***", wSSubscriberResponse.Message, i);
MessageBox.Show(wSSubscriberResponse.Message);
}
else
{
MakeComment("SBT SUBSCRIBER FIELDS UPDATED.", wSSubscriberResponse.Message, i);
}
MakeComment("Cell Phone Number VALIDATED. AUTO VBT", wSCarrierLookupResponse.Message, i);
IACData.CUSTOMER.Rows[i].SetField <Boolean>("CellValid", true);
IACData.CUSTOMER.Rows[i].SetField <Boolean>("DNTAcct", false);
IACData.CUSTOMER.Rows[i].SetField <Boolean>("TAcct", true);
IACData.CUSTOMER.Rows[i].SetField <Boolean>("TConfirmed", true);
IACData.CUSTOMER.Rows[i].SetField <String>("TPin", "AUTO");
}
}
else
{
MakeComment("*** Cell Phone Number will not VALIDATE because it is a LANDLINE! ***", wSCarrierLookupResponse.Message, i);
IACData.CUSTOMER.Rows[i].SetField <Boolean>("CellValid", false);
}
}
CUSTOMERTableAdapter.Update(IACData.CUSTOMER.Rows[i]);
}
progressBar1.Value = i;
}
MessageBox.Show("*** Completed cell phone validation! ***", "Validate Cell Phones", MessageBoxButtons.OK);
}
