EWS Get Attachments and plain text body C#

Question

I am writing a help desk application and the user can log a ticket using email so I have used the EWS API to pick up on emails and store the subject line and body in plain text to the database.

I would also like to store attachments but I am having trouble as the BodyType cannot be text, it must be HTML to allow attachments to be stored but I require the body to be in plain text when storing it to the database.

I got the code for storing plain text from this link EWS body plain text. I can't seem to find anything of interest about attachments.

My code so far:

itempropertyset.RequestedBodyType = BodyType.Text;
email.Load();

bb = email.Body.Text;

try
{// Add The new ticket to the DB
    string stmt = "INSERT INTO Tickets(Subject, StatusId, PriorityId, CreatedByUserId, CreatedDateTime, ClientDescription, TicketTypeId) VALUES (@Subject, @sId, @pId, @cId, @ctd, @cd, @tId); Select SCOPE_IDENTITY() as Id";
    cmd = new SqlCommand(stmt, conn);
    cmd.Parameters.AddWithValue("@Subject", ss); //Subject Line from email
    cmd.Parameters.AddWithValue("@sId", 1); //Default to Open
    cmd.Parameters.AddWithValue("@pId", 6); //Default Prioirity to Normal
    cmd.Parameters.AddWithValue("@cId", UserId); //GetTheUserId
    cmd.Parameters.AddWithValue("@ctd", DateTime.Now);
    cmd.Parameters.AddWithValue("@cd", bb); //Subject Line from email
    cmd.Parameters.AddWithValue("@sId", 2); //Default to Email

    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataTable dte = new DataTable("res");
    da.Fill(dte);
    if (dte.Rows.Count > 0)
    {
        decimal tId = Convert.ToDecimal(dte.Rows[0]["Id"]);
        try
        { //Add the new activity for the ticket
            string stmnt = "INSERT INTO Activities(TicketId, ActivityTypeId, CreatedByUserId, Subject, ActivityContent, CreatedDateTime) VALUES (@tId, @atId, @cId, @Subject, @ac, @ctd ); Select SCOPE_IDENTITY() as Id";;
            SqlCommand cmde = new SqlCommand(stmnt, conn);
            cmde.Parameters.AddWithValue("@tId", tId); //Subject Line from email
            cmde.Parameters.AddWithValue("@atId", 3); //Default to Email
            cmde.Parameters.AddWithValue("@cId", UserId); //GetTheUserId
            cmde.Parameters.AddWithValue("@Subject", ss);
            cmde.Parameters.AddWithValue("@ac", bb);
            cmde.Parameters.AddWithValue("@ctd", DateTime.Now);
            SqlDataAdapter sdtc = new SqlDataAdapter(cmde);
            DataTable sdta = new DataTable("ActivityTable");
            sdtc.Fill(sdta);
            if (sdta.Rows.Count > 0 && email.HasAttachments == true)
            {
                decimal aId = Convert.ToDecimal(sdta.Rows[0]["Id"]);
                foreach(Microsoft.Exchange.WebServices.Data.Attachment attachment in email.Attachments)
                {
                    if (attachment is FileAttachment)
                    {
                        fileAttachment = attachment as FileAttachment;
                        fileAttachment.Load("\\\\Helpdesk\\Attachments\\" + attachment.Name);  
                    }
                    else
                    {
                        ItemAttachment itemAttachment = attachment as ItemAttachment;
                        itemAttachment.Load();
                    }
                    string path = "\\\\Helpdesk\\Attachments\\" + attachment.Name;
                    string stmtattach = "INSERT INTO Attachment(TicketId, ActivityId, AttachmentTypeId, CreatedByUserId, CreatedDateTime, AttachmentPath) VALUES (@tId, @aId, @atId, @cId, @cdt, @path)";
                    SqlCommand comd = new SqlCommand(stmtattach, conn);
                    comd.Parameters.AddWithValue("@tId", tId);
                    comd.Parameters.AddWithValue("@aId", aId);
                    comd.Parameters.AddWithValue("@atId", 1);
                    comd.Parameters.AddWithValue("@cId", UserId);
                    comd.Parameters.AddWithValue("@cdt", DateTime.Now);
                    comd.Parameters.AddWithValue("@path", path);
                    SqlDataAdapter ada = new SqlDataAdapter(comd);
                    DataTable adte = new DataTable("attachment");
                    ada.Fill(adte);
                }

            }
            SendMail(senderName, email.Sender.Address, "TICKET?" + tId.ToString() + "#" + ss, "Original Message: " + bb + "Your Ticket has successfully been added to the helpdesk your ticket is " + tId);
        }
        catch (System.Exception ex)
        {
            Console.WriteLine(ex);
            lg.AppendLine(" - Unsuccessful adding activity to DB.<br/>");
        }

    }
}

Answer 1

If I understand your problem correctly, you want to get the body text of the attachment.

To do that you need to use the Item.TextBody property.

So something like the below:

ItemAttachment itemAttachment = attachment as ItemAttachment;

itemAttachment.Load(new PropertySet(EmailMessageSchema.TextBody));

Console.WriteLine(itemAttachment.Item.TextBody);