//on page load the job number drop down contain all job from the database
protected void fillDdljobNo2()
{ // on page load the Drop down list is populated with all job numbers from the database
JobNumbers myJob = new JobNumbers();
SqlDataReader drJob = myJob.GetJobNo();
DDLjobNos.DataSource = drJob;
DDLjobNos.DataTextField = "job_number";
DDLjobNos.DataValueField = "job_Number";
DDLjobNos.DataBind();
}
} // Closes Page_Load
//on page load the job number drop down is populated with all job numbers from the database
protected void fillDdljobNo()
{
JobNumbers myJob = new JobNumbers();
SqlDataReader drJob = myJob.GetJobNo();
DDLjobNo.DataSource = drJob;
DDLjobNo.DataTextField = "job_number";
DDLjobNo.DataValueField = "job_Number";
DDLjobNo.DataBind();
}
}// closes the fillorders
/* on page load the Drop down list is populated with all job numbers from the database
* Uses the same method as the job number drop downn in bookout goods
*/
protected void fillDdljobNo3()
{
JobNumbers myJob = new JobNumbers();
SqlDataReader drJob = myJob.GetJobNo();
DDLjobNos.DataSource = drJob;
DDLjobNos.DataTextField = "job_number";
DDLjobNos.DataValueField = "job_Number";
DDLjobNos.DataBind();
DDLjobNos.Items.Insert(0, new ListItem(String.Empty, String.Empty));
}
private void RemoveValue(object sender, EventArgs e)
{
var list = (Button)sender;
switch (list.Name)
{
case "CmdRemoveNumber":
{
ListBox.SelectedObjectCollection selectedItems = new ListBox.SelectedObjectCollection(LbNumbers);
selectedItems = LbNumbers.SelectedItems;
if (LbNumbers.SelectedIndex == -1)
{
return;
}
for (int i = selectedItems.Count - 1; i >= 0; i--)
{
string number = LbNumbers.GetItemText(selectedItems[i]);
LbNumbers.Items.Remove(selectedItems[i]);
JobNumbers.Remove(number);
}
CmdRemoveNumber.Enabled = false;
return;
}
case "CmdRemoveFiles":
{
ListBox.SelectedObjectCollection selectedItems = new ListBox.SelectedObjectCollection(LbFiles);
selectedItems = LbFiles.SelectedItems;
if (LbFiles.SelectedIndex == -1)
{
return;
}
for (int i = selectedItems.Count - 1; i >= 0; i--)
{
string number = LbFiles.GetItemText(selectedItems[i]);
LbFiles.Items.Remove(selectedItems[i]);
Files.Remove(Files.First(f => f.Contains(number)));
}
CmdRemoveFiles.Enabled = false;
return;
}
}
}
/*
* When the user selects a job number from the drop down list the gridview updates to show that one job number
*/
protected void DDLjobNo_SelectedIndexChanged(object sender, EventArgs e)
{ // When the user selects a job number the gridview shows the description for that site
JobNumbers myJob = new JobNumbers();
myJob.jobNo = Convert.ToString(DDLjobNo.SelectedValue);
GVjobDesc.DataSource = myJob.GetJobNoFilter();
GVjobDesc.DataBind();
focus();
// If the job number is changed after the order has been created call the updateJobNo();
if (Session["sordernbr"] != null)
{
updateJobNo();
}
}
private void AddValue(object sender, EventArgs e)
{
var btn = (Button)sender;
switch (btn.Name)
{
case "CmdAddNumber":
{
if (!Regex.IsMatch(TxtNumber.Text, @"\d{2}-\d{2}-\d{3}"))
{
return; //When the user hits enter and bypasses the button.
}
LbNumbers.Items.Add(TxtNumber.Text);
JobNumbers.Add(TxtNumber.Text);
CmdAddNumber.Enabled = false;
return;
}
case "CmdAddFiles":
{
string baseDir = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
if (!string.IsNullOrEmpty(Properties.Settings.Default.DefaultSearch))
{
baseDir = Properties.Settings.Default.DefaultSearch;
}
OpenFileDialog dialog = new OpenFileDialog
{
Title = "Select files",
Multiselect = true,
InitialDirectory = baseDir
};
var dr = dialog.ShowDialog();
if (dr == DialogResult.Cancel)
{
return;
}
foreach (string file in dialog.FileNames)
{
LbFiles.Items.Add(Path.GetFileName(file));
Files.Add(file);
}
return;
}
}
}
/*
On page load a gridview is populated with the job number and job decription for all jobs.
* The user can review the gridview to identify the job nuumber if unknown
*/
protected void fillJobDesc2()
{ // populates a gridview with all job numbers
JobNumbers myJob = new JobNumbers();
GVjobDesc2.DataSource = myJob.GetJobNo();
GVjobDesc2.DataBind();
}
void SendData(object s, EventArgs e)
{
if (Properties.Settings.Default.SendMethod)
{
//TCP
}
else
{
lblStatus.Text = "Creating E-Mail";
//EMail
try
{
MailMessage message = new MailMessage();
string[] toPeople = Properties.Settings.Default.DestEmail.Split(',');
foreach (string dest in toPeople)
{
message.To.Add(dest);
}
message.From = new MailAddress(Properties.Settings.Default.EMail);
if (TxtNumber.Text == "12-34-567")
{
message.Subject = "Testing app config";
message.Body = "Alert the person who sent this that the test worked and you received this message.";
}
else
{
if (JobNumbers.Count == 0)
{
if (Regex.IsMatch(TxtNumber.Text, @"\d{2}-\d{2}-\d{3}"))
{
JobNumbers.Add(TxtNumber.Text);
}
else
{
lblStatus.Text = "No job numbers detected.";
return;
}
}
if (Files.Count == 0)
{
var mr = MessageBox.Show("No files were added, continue sending data?", "Confirm", MessageBoxButtons.YesNo);
if (mr == DialogResult.No)
{
lblStatus.Text = "No files detected."; return;
}
}
else
{
foreach (string file in Files)
{
Attachment attachment = new Attachment(file);
message.Attachments.Add(attachment);
}
}
string msgBodyFormatted = msgBody.Replace("{SENDER}", Properties.Settings.Default.Name)
.Replace("{JOBNO}", String.Join("\r\n", JobNumbers))
.Replace("{PURPOSE}", CbPurpose.Text)
.Replace("{NOTES}", TxtNotes.Text);
message.Subject = "Field Data Submission";
message.Body = msgBodyFormatted;
}
lblStatus.Text = "Preparing Sender";
SmtpClient client;
switch (Properties.Settings.Default.EMailServerMethod)
{
case 0:
{
client = new SmtpClient(EMailServerInfo.GMail.Host)
{
Port = EMailServerInfo.GMail.Port,
EnableSsl = EMailServerInfo.GMail.EnableSSL,
Credentials = new NetworkCredential(Properties.Settings.Default.EMail, Properties.Settings.Default.Password)
};
break;
}
case 1:
{
client = new SmtpClient(EMailServerInfo.GoDaddy.Host)
{
Port = EMailServerInfo.GoDaddy.Port,
EnableSsl = EMailServerInfo.GoDaddy.EnableSSL,
Credentials = new NetworkCredential(Properties.Settings.Default.EMail, Properties.Settings.Default.Password)
};
break;
}
case 2:
{
client = new SmtpClient(EMailServerInfo.Office365.Host)
{
Port = EMailServerInfo.Office365.Port,
EnableSsl = EMailServerInfo.Office365.EnableSSL,
Credentials = new NetworkCredential(Properties.Settings.Default.EMail, Properties.Settings.Default.Password)
};
break;
}
case 3:
default:
{
client = new SmtpClient(Properties.Settings.Default.EMailDomain)
{
Port = Properties.Settings.Default.EMailPort,
EnableSsl = Properties.Settings.Default.EMailSSL,
Credentials = new NetworkCredential(Properties.Settings.Default.EMail, Properties.Settings.Default.Password)
};
break;
}
}
lblStatus.Text = "Sending E-Mail";
client.Send(message);
lblStatus.Text = "Message sent.";
message.Dispose();
client.Dispose();
} catch (Exception ex)
{
lblStatus.Text = "Message failed.";
#if DEBUG
MessageBox.Show(ex.Message);
#endif
}
finally
{
}
}
}
