Clash Royale CLAN TAG#URR8PPP

Passing Email data to database using EWS

I'm currently working on a windows service that collects emails from a mailbox using the Exchange Web Service API, and passes the data from the emails to a stored procedure. The stored procedure then adds this data to a table in SSMS. I've tested the stored procedure manually and it functions fine. I've also got a method writing to a text file and all aspects of the emails (recipients, date, subject etc) are being collected.

My problem is that only the latest email in the mailbox is being passed to the database. Below is my code:

int offset = 0;
int pageSize = 50;
bool moreEmails = true;
ItemView view = new ItemView(pageSize, offset, OffsetBasePoint.Beginning);

view.PropertySet = PropertySet.IdOnly;
FindItemsResults<Item> findResults;
List<EmailMessage> emails = new List<EmailMessage>();
findResults = service.FindItems(WellKnownFolderName.Inbox, view);

while (moreEmails)

foreach (var item in findResults.Items)

emails.Add((EmailMessage)item);


moreEmails = findResults.MoreAvailable;

if (moreEmails)

view.Offset += pageSize;



PropertySet properties = (BasePropertySet.FirstClassProperties);
service.LoadPropertiesForItems(emails, properties);

foreach (var EmailParam in emails)

FromEmail = EmailParam.From.ToString();
EmailDate = EmailParam.DateTimeReceived.ToString("yyyy-MM-dd hh:mm:ss");
EmailSubject = EmailParam.Subject;
EmailBody = EmailParam.Body;
int SourceID = 1;

foreach (var recipient in EmailParam.ToRecipients)

ToEmail += recipient.Address.ToString();


foreach (var cc in EmailParam.CcRecipients)

Emailcc += cc.Address.ToString();


using (SqlConnection con = new SqlConnection(conStr))

con.Open();
SqlDataAdapter da = new SqlDataAdapter("mtsp_CreateTicket", con);
da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;

da.SelectCommand.Parameters.AddWithValue("@Date", EmailDate);
da.SelectCommand.Parameters.AddWithValue("@FromEmail", FromEmail);
da.SelectCommand.Parameters.AddWithValue("@ToEmail", ToEmail);
da.SelectCommand.Parameters.AddWithValue("@EmailSubject", EmailSubject);
da.SelectCommand.Parameters.AddWithValue("@EmailBody", EmailBody);
da.SelectCommand.Parameters.AddWithValue("@Emailcc", Emailcc);
da.SelectCommand.Parameters.AddWithValue("@SourceID", SourceID);
da.SelectCommand.ExecuteNonQuery();




It's my first time using a windows service and I'm sort of new to this so any help is much appreciated. Thanks!

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.