private void frmMakeBooking_Load(object sender, EventArgs e)
{
txtBookingID.Text = Bookings.nextBookingID().ToString("00000");
txtBookingID.Visible = true;
txtEnterSurname.Select();
//reference for autocomplete textbox http://www.simplylearnprogramming.com/autocomplete-textbox-from-database-using-csharp/51
cmd = new OracleCommand("SELECT Surname FROM Client", myConn);
myConn.Open();
dr = cmd.ExecuteReader();
AutoCompleteStringCollection Collection = new AutoCompleteStringCollection();
while (dr.Read())
{
Collection.Add(dr.GetString(0));
}
txtEnterSurname.AutoCompleteCustomSource = Collection;
dr.Close();
myConn.Close();
}
private void btnConfirmBooking_Click(object sender, EventArgs e)
{
string BookingID = txtBookingID.Text;
DateTime EventDate = dtpEventDate.Value;
string StartTime = cboStartTime.Text;
string EndTime = cboEndTime.Text;
string Duration = txtDuration.Text;
string Location = txtLocation.Text;
string Eircode = txtEircode.Text;
string TotalCost = "€" + txtTotalCost.Text;
string ClientID = txtClientID.Text;
string DJID = txtDJID.Text;
string ServiceID = txtServiceID.Text;
string Forename = grdMakeBookingMatchingClients.SelectedRows[0].Cells[1].Value + string.Empty;
int parsedValueInt;
if (!ValidateData.isValidDate3(dtpEventDate.Value))
{
MessageBox.Show("Cannot be previous Date", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
dtpEventDate.Focus();
return;
}
if (!ValidateData.isBlank(txtLocation.Text))
{
MessageBox.Show("Location must be entered", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLocation.Focus();
return;
}
else if (int.TryParse(txtLocation.Text, out parsedValueInt))
{
MessageBox.Show("Location cannot contain numbers only", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLocation.Clear();
txtLocation.Focus();
return;
}
if (!ValidateData.isBlank(txtEircode.Text))
{
MessageBox.Show("Eircode must be entered", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtEircode.Focus();
return;
}
else if (!ValidateData.containsSpaces(txtEircode.Text))
{
MessageBox.Show("Eircode cannot contain spaces", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtEircode.Clear();
txtEircode.Focus();
return;
}
else if (!ValidateData.isValidEircode(txtEircode.Text))
{
MessageBox.Show("Eircode must be valid", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtEircode.Clear();
txtEircode.Focus();
return;
}
Bookings bookings = new Bookings(Convert.ToInt32(txtBookingID.Text), dtpEventDate.Text.ToUpper(), cboStartTime.Text.ToUpper(), cboEndTime.Text.ToUpper(),
double.Parse(txtDuration.Text), ValidateData.apostChecker(txtLocation.Text.ToUpper()), txtEircode.Text.ToUpper(), Convert.ToDecimal(txtTotalCost.Text),
"P", Convert.ToInt32(0), Convert.ToDecimal(0.00), "A", Convert.ToInt32(txtClientID.Text), Convert.ToInt32(txtDJID.Text), txtServiceID.Text.ToUpper());
bookings.AddBooking();
txtBookingID.Text = Bookings.nextBookingID().ToString("00000");
cboStartTime.SelectedIndex = -1;
cboEndTime.SelectedIndex = -1;
txtDuration.Clear();
txtLocation.Clear();
txtEircode.Clear();
txtTotalCost.Clear();
txtClientID.Clear();
txtServiceID.Clear();
txtDJID.Clear();
dtpEventDate.Value = DateTime.Now;
txtEnterSurname.Select();
grpMakeBookingMatchingClients.Visible = false;
grpMakeBookingActiveServices.Visible = false;
grpMakeBookingActiveDJs.Visible = false;
grpMakeBooking.Visible = false;
// I need to check if the content is valid before adding it to the form
//this.textBox1.Items.Add(item);
MessageBox.Show(text: "Booking details added!" +
Environment.NewLine + Environment.NewLine + "Booking ID: " + BookingID.ToUpper() +
Environment.NewLine + Environment.NewLine + "Event Date: " + EventDate +
Environment.NewLine + Environment.NewLine + "Start Time: " + StartTime +
Environment.NewLine + Environment.NewLine + "End Time: " + EndTime +
Environment.NewLine + Environment.NewLine + "Duration: " + Duration +
Environment.NewLine + Environment.NewLine + "Location: " + Location.ToUpper() +
Environment.NewLine + Environment.NewLine + "Eircode: " + Eircode.ToUpper() +
Environment.NewLine + Environment.NewLine + "Total Cost: €" + TotalCost +
Environment.NewLine + Environment.NewLine + "Client ID: " + ClientID.ToUpper() +
Environment.NewLine + Environment.NewLine + "DJ ID: " + DJID.ToUpper() +
Environment.NewLine + Environment.NewLine + "Service ID: " + ServiceID.ToUpper());
dtpEventDate.Value = DateTime.Now;
//Reference for being able to send emails http://karmic-development.blogspot.com/2013/10/send-email-from-aspnet-using-gmail-as.html
//Reference to set up various security aspects to be able to send email through google mail https://stackoverflow.com/questions/704636/sending-email-through-gmail-smtp-server-with-c-sharp/9572958#9572958
//Reference on how to send an embedded link inside email
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "Legend DJs");
mail.To.Add("*****@*****.**");
mail.IsBodyHtml = true;
mail.Subject = "Booking confirmed";
//string html = "";
mail.Body =
"Dear " + Forename + "," +
"<br/><br/>Thank you for making a booking with Legend DJs." +
"<br/><br/>We provide the best DJ service in Ireland and we look forward to seeing you on the date." +
"<br/><br/>If there are any special requirements such as song requests, plugging, or lighting systems etc, please don't hesitate to call us and we will help as best we can." +
"<br/><br/>Please check the details below to ensure that the booking information we have is correct. You can update this information at any time up to 28 days before the event date " +
"by contacting us." +
"<br/><br/><h1>Booking details added!</h1>" +
"<br/><br/>Booking ID: " + BookingID.ToUpper() +
"<br/>Event Date: " + EventDate +
"<br/>Start Time: " + StartTime +
"<br/>End Time: " + EndTime +
"<br/>Duration: " + Duration +
"<br/>Location: " + Location.ToUpper() +
"<br/>Eircode: " + Eircode.ToUpper() +
"<br/>Total Cost: €" + TotalCost +
"<br/>DJ ID: " + DJID.ToUpper() +
"<br/>Service ID: " + ServiceID.ToUpper() +
"<br/><br/><br/>Kind regards," +
"<br/><br/>Legend DJs" +
"<br/><br/><h1>Contact Us</h1>" +
"<br/><br/>Legend DJs" +
"<br/>Main Street" +
"<br/>Tralee" +
"<br/>Co. Kerry" +
"<br/>087 170 1459" +
"<br/><br/><html><body><a href=\"http://www.livinglegendcolmg.com/\" > LegendDJs.com</a></body></html>" +
"<br/><br/><html><body><a href=\"https://www.facebook.com/colm.l.gallagher/\" > LegendDJs @ facebook</a></body></html>" +
"<br/><br/><html><body><a href=\"https://twitter.com/LivingLegendDJ/\" > LegendDJs @ twitter</a></body></html>" +
"<br/><br/><html><body><a href=\"https://www.instagram.com/livinglegendcolmg/?hl=en/\" > LegendDJs @ instagram</a></body></html>";
mail.Priority = MailPriority.High;
SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587);
smtp.UseDefaultCredentials = false;
//smtp.UseDefaultCredentials = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "jcxvqxkvqrfanhqj");
smtp.EnableSsl = true;
//smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Send(mail);
//send email to client
MessageBox.Show(text: "Confirmation email sent to Client");
txtEnterSurname.Select();
}