protected void Unnamed_Click(object sender, EventArgs e) { Project newProject = (Project)Application["newProject"]; newProject.ManagersDescription = txtManagerNote.Text; string s = newProject.InsertNewProject(newProject); //Insert Project products foreach (ProjectProducts pp in ProjectProductsBindingList.RequestedProjectProductList) { ClientVehicleProduct cvp = new ClientVehicleProduct(); cvp.GenericVehicleProductNumber = pp.GenericVehicleProductNumber; cvp.ProjectNumber = newProject.ProjectNumber; cvp.ClientVehicleNumber = newProject.ClientVehicleNumber; s = cvp.InsertClientVehicleProducts(cvp); } //Insert Project Staff foreach (ProjectStaff ps in ProjectStaffBindingList.ProjectStaffList) { s = ps.InsertProjectStaffMember(ps); //Send Email foreach (TweekPerformance_BT.Employee emp in EmployeeBindingList.EmployeeList) { if (ps.UserNumber == emp.UserNumber) { foreach (ClientVehicle cv in ClientVehicleBindingList.ClientVehicleList) { if (newProject.ClientVehicleNumber == cv.ClientVehicleNumber) { Email sendEmail = new Email(); sendEmail.ProjectStaff("*****@*****.**", emp.FirstName, newProject, cv); } } } } } Response.Redirect("./Overview"); }