public void UpdateAllRecords() { DataSet ds = new DataSet(); //grdWithdrawDJsActiveBookings.DataSource = DJs.GetAllBookings(ds, txtEnterName.Text.ToUpper()).Tables["Bookings"]; ds = DJs.GetAllBookingsOutsideNoticePeriod(ds, Convert.ToInt32(txtDJID.Text)); grdWithdrawDJActiveBookings3.DataSource = ds.Tables["searchBookingsOutsideNotice"]; //reference fellow student Carraig McNulty for help with foreach loop to declare array foreach (DataRow row in ds.Tables["searchBookingsOutsideNotice"].Rows) { StringBuilder query = new StringBuilder(); for (int i = 0; i < grdWithdrawDJActiveBookings3.Rows.Count; i++) { //DataGridViewRow row = grdWithdrawDJActiveBookings3.Rows[i]; Bookings.updateBookingsWhereDJWithdrawn(Convert.ToInt32(grdWithdrawDJActiveBookings3.Rows[i].Cells[0].Value), Convert.ToInt32(15)); } } }
private void btnWithdrawDJPrintBookings_Click(object sender, EventArgs e) { String ClientID = txtDJID.Text; String Forename = txtDJForename.Text; grpWithdrawMatchingDJs.Visible = false; grdWithdrawDJActiveBookings.AllowUserToAddRows = false; grdWithdrawDJActiveBookings.Visible = true; grpWithdrawDJActiveBookings.Visible = true; grdWithdrawDJActiveBookings2.Visible = true; grpWithdrawDJActiveBookings2.Visible = true; grdWithdrawDJActiveBookings2.AllowUserToAddRows = false; btnDJWithdrawDJPrintBookings.Visible = false; btnLegendDJsWithdrawDJPrintBookings.Visible = false; grpWithdrawDJ.Visible = false; btnSelectAll.Visible = false; btnLegendDJsWithBookingsWithdrawDJ.Visible = false; btnDJWithBookingsWithdrawDJ.Visible = false; grdWithdrawDJActiveBookings3.AllowUserToAddRows = false; grdWithdrawDJActiveBookings3.Visible = true; grpWithdrawDJActiveBookings3.Visible = true; DataSet ds = new DataSet(); //grdWithdrawDJsActiveBookings.DataSource = DJs.GetAllBookings(ds, txtEnterName.Text.ToUpper()).Tables["Bookings"]; ds = DJs.GetAllBookingsOutsideNoticePeriod(ds, Convert.ToInt32(txtDJID.Text)); grdWithdrawDJActiveBookings3.DataSource = ds.Tables["searchBookingsOutsideNotice"]; UpdateAllRecords(); DJs.WithdrawDJ(Convert.ToInt32(txtDJID.Text)); MessageBox.Show(text: "DJ Withdrawn"); txtDJID.Clear(); txtDJForename.Clear(); txtDJSurname.Clear(); txtDJContactNo.Clear(); txtDJEmail.Clear(); txtDJStreet.Clear(); txtDJTown.Clear(); txtDJCounty.Clear(); txtDJCity.Clear(); txtDJEircode.Clear(); txtDJHourlyRate.Clear(); //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 MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**", "Legend DJs"); mail.To.Add("*****@*****.**"); mail.IsBodyHtml = true; mail.Subject = "DJ Withdrawn"; //string html = ""; mail.Body = "Dear " + Forename + "," + "<br/><br/>In relation to your request to withdraw your services form Legend DJs' system, and in accordance with the terms and conditions of your employment, " + "we will be withdrawing you from our system." + "<br/><br/>Please find attached a list of final bookings to fulfil before you officially leave Legend DJs." + "<br/><br/>We would like to thank you, again, for your great service to this point." + "<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 DJ"); grdWithdrawDJActiveBookings.AllowUserToAddRows = false; grdWithdrawDJActiveBookings.Visible = false; grpWithdrawDJActiveBookings.Visible = false; grdWithdrawDJActiveBookings2.Visible = false; grpWithdrawDJActiveBookings2.Visible = false; grdWithdrawDJActiveBookings2.AllowUserToAddRows = false; btnDJWithdrawDJPrintBookings.Visible = false; btnLegendDJsWithdrawDJPrintBookings.Visible = false; grpWithdrawDJ.Visible = false; btnSelectAll.Visible = false; btnLegendDJsWithBookingsWithdrawDJ.Visible = false; btnDJWithBookingsWithdrawDJ.Visible = false; grdWithdrawDJActiveBookings3.AllowUserToAddRows = false; grdWithdrawDJActiveBookings3.Visible = false; grpWithdrawDJActiveBookings3.Visible = false; txtEnterSurname.Select(); }