public void EmailAssignments(EmailHelper email) { string prevEmailTo = ""; string emailTo; string firstName; string wmsPriority; string wmsCategory; string siteId; string folderName; string description; string wmsComments; double wmsEffort; long efolderId; using (OleDbCommand cmd = AccessDatalayer.Instance.Connection.CreateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT Person.Email, Person.Firstname, EworkItem.WmsPriority, EworkItem.WmsCategory, " + "EworkItem.SiteId, EworkItem.FolderName, EworkItem.Description, EworkItem.WmsComments, " + "EworkItem.WmsEffort, EworkItem.EfolderId " + "FROM Person INNER JOIN EworkItem ON Person.PersonId = EworkItem.WmsAssignedTo " + "WHERE (((Person.WmsCore)=True) AND ((EworkItem.EworkStatus)=\"06 WMS Team for Action\")) " + "ORDER BY Person.Email, EworkItem.WmsPriority, EworkItem.WmsCategory "; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { emailTo = ""; if (!reader.IsDBNull(0)) { emailTo = reader.GetString(0); } firstName = ""; if (!reader.IsDBNull(1)) { firstName = reader.GetString(1); } wmsPriority = ""; if (!reader.IsDBNull(2)) { wmsPriority = reader.GetString(2); } wmsCategory = ""; if (!reader.IsDBNull(3)) { wmsCategory = reader.GetString(3); } siteId = ""; if (!reader.IsDBNull(4)) { siteId = reader.GetString(4); } folderName = ""; if (!reader.IsDBNull(5)) { folderName = reader.GetString(5); } description = ""; if (!reader.IsDBNull(6)) { description = reader.GetString(6); } wmsComments = ""; if (!reader.IsDBNull(7)) { wmsComments = reader.GetString(7); } wmsEffort = 0; if (!reader.IsDBNull(8)) { wmsEffort = double.Parse(reader.GetValue(8).ToString()); } efolderId = 0; if (!reader.IsDBNull(9)) { efolderId = long.Parse(reader.GetValue(9).ToString()); } if (prevEmailTo != emailTo) { if (prevEmailTo.Length > 0) { email.SendAssignments(); } email.PrepareAssignments(emailTo, firstName); } email.AddAssignment(efolderId, folderName, wmsPriority, wmsCategory, siteId, description, wmsComments, wmsEffort); prevEmailTo = emailTo; } email.SendAssignments(); } }