private static SupportEmail ReadSupportEmailFromReader(MySqlDataReader reader) { SupportEmail email = new SupportEmail(); // BugEvent.ixBugEvent AS BugEventId,BugEvent.ixBug AS BugId, Bug.sTitle as BugTitle, Bug.sCustomerEmail AS Recipient, BugEvent.s AS Body,Person.sFullName AS Sender email.CaseId = reader.GetInt32(1); email.Body = Encoding.UTF8.GetString(Encoding.GetEncoding(1252).GetBytes(reader.GetString(4))); email.EventId = reader.GetInt32(0); email.From = reader.GetString(5); email.To = reader.GetString(3); email.CaseTitle = reader.GetString(2); return(email); }
private static SupportEmail ReadSupportEmailFromReader (MySqlDataReader reader) { SupportEmail email = new SupportEmail(); // BugEvent.ixBugEvent AS BugEventId,BugEvent.ixBug AS BugId, Bug.sTitle as BugTitle, Bug.sCustomerEmail AS Recipient, BugEvent.s AS Body,Person.sFullName AS Sender email.CaseId = reader.GetInt32(1); email.Body = Encoding.UTF8.GetString(Encoding.GetEncoding(1252).GetBytes(reader.GetString(4))); email.EventId = reader.GetInt32(0); email.From = reader.GetString(5); email.To = reader.GetString(3); email.CaseTitle = reader.GetString(2); return email; }