private void BindGrid()
{
dgLog.Columns[0].HeaderText = LocRM.GetString("tDirection");
dgLog.Columns[1].HeaderText = LocRM.GetString("tSubject");
dgLog.Columns[2].HeaderText = LocRM.GetString("tFrom");
dgLog.Columns[3].HeaderText = LocRM.GetString("tTo");
dgLog.Columns[4].HeaderText = LocRM.GetString("tCreated");
dgLog.Columns[5].HeaderText = LocRM.GetString("tEmailBox");
dgLog.Columns[6].HeaderText = LocRM.GetString("tAntiSpamResult");
foreach (DataGridColumn dgc in dgLog.Columns)
{
if (dgc.SortExpression == Sorting)
{
dgc.HeaderText += " <img border='0' align='absmiddle' width='9px' height='5px' src='" + this.Page.ResolveUrl("~/layouts/images/upbtnF.jpg") + "'/>";
}
else if (dgc.SortExpression + " DESC" == Sorting)
{
dgc.HeaderText += " <img border='0' align='absmiddle' width='9px' height='5px' src='" + this.Page.ResolveUrl("~/layouts/images/downbtnF.jpg") + "'/>";
}
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Direction", typeof(string)));
dt.Columns.Add(new DataColumn("Subject", typeof(string)));
dt.Columns.Add(new DataColumn("From", typeof(string)));
dt.Columns.Add(new DataColumn("To", typeof(string)));
dt.Columns.Add(new DataColumn("Created", typeof(DateTime)));
dt.Columns.Add(new DataColumn("EmailBoxId", typeof(int)));
dt.Columns.Add(new DataColumn("AntiSpamResult", typeof(string)));
EMailMessageLog[] emml = EMailMessageLog.List();
foreach (EMailMessageLog item in emml)
{
DataRow dr = dt.NewRow();
if (item.Incoming)
{
dr["Direction"] = LocRM.GetString("tExtType");
}
else
{
dr["Direction"] = LocRM.GetString("tIntType");
}
dr["Subject"] = item.Subject;
dr["From"] = item.From;
dr["To"] = item.To;
dr["EmailBoxId"] = item.EMailBoxId;
switch (item.AntiSpamResult)
{
case EMailMessageAntiSpamRuleRusult.Accept:
dr["AntiSpamResult"] = LocRM.GetString("tAccepted");
break;
case EMailMessageAntiSpamRuleRusult.Deny:
dr["AntiSpamResult"] = LocRM.GetString("tDenied");
break;
case EMailMessageAntiSpamRuleRusult.Pending:
dr["AntiSpamResult"] = LocRM.GetString("tPending");
break;
}
dr["Created"] = item.Created;
dt.Rows.Add(dr);
}
DataView dv = dt.DefaultView;
dv.Sort = Sorting;
dgLog.DataSource = dv;
dgLog.PageSize = int.Parse(PageSize);
int iPageIndex = int.Parse(PageIndex);
int ppi = dv.Count / dgLog.PageSize;
if (dv.Count % dgLog.PageSize == 0)
{
ppi = ppi - 1;
}
if (iPageIndex <= ppi)
{
dgLog.CurrentPageIndex = iPageIndex;
}
else
{
dgLog.CurrentPageIndex = 0;
}
dgLog.DataBind();
}
private void lbClearLog_Click(object sender, EventArgs e)
{
PageIndex = "0";
EMailMessageLog.Clear();
Response.Redirect("~/Incidents/EmailLog.aspx");
}
public static void SendMessage(string[] To, string Subject, string Body, Mediachase.IBN.Business.ControlSystem.DirectoryInfo Attachments, string Mode, NameValueCollection Params)
{
// Cleanup Temporary files
DbEMailTempFile.CleanUp();
#region Validate Arguments
if (To == null)
{
throw new ArgumentNullException("To");
}
if (Subject == null)
{
throw new ArgumentNullException("Subject");
}
if (Body == null)
{
throw new ArgumentNullException("Body");
}
//if (To.Length == 0)
// throw new ArgumentOutOfRangeException("To", "Email recipient list is empty.");
if (Mode == null)
{
Mode = string.Empty;
}
if (Params == null)
{
Params = new NameValueCollection();
}
#endregion
string FromEmail = string.Empty;
switch (Mode)
{
case EMailClient.IssueMode:
case EMailClient.SmtpTestMode:
FromEmail = Alerts2.AlertSenderEmail;
break;
default:
FromEmail = Security.CurrentUser.Email;
break;
}
string FullFromEmail = string.Format("\"{0} {1}\" <{2}>",
Security.CurrentUser.LastName,
Security.CurrentUser.FirstName,
FromEmail);
using (DbTransaction tran = DbTransaction.Begin())
{
EMailMessageLogSetting EmailLogSettings = EMailMessageLogSetting.Current;
if (EmailLogSettings.IsActive)
{
EMailMessageLog.CleanUp(EmailLogSettings.Period);
}
else
{
EmailLogSettings = null;
}
Mode = Mode.ToLower();
#region Pre-format incoming arguments
switch (Mode)
{
case EMailClient.IssueMode:
if (Params["IssueId"] == null)
{
throw new ArgumentNullException("Params[\"IssueId\"]");
}
int IssueId = int.Parse(Params["IssueId"]);
// TODO: Validate Subject & Ticket
if (TicketUidUtil.LoadFromString(Subject) == string.Empty)
{
IncidentBox incidentBox = IncidentBox.Load(Incident.GetIncidentBox(IssueId));
string IncidentTicket = Incident.GetIdentifier(IssueId);
if (incidentBox.Document.GeneralBlock.AllowOutgoingEmailFormat)
{
StringBuilder sb = new StringBuilder(incidentBox.Document.GeneralBlock.OutgoingEmailFormatSubject, 4096);
sb.Replace("[=Title=]", Subject);
sb.Replace("[=Ticket=]", IncidentTicket);
//sb.Replace("[=Text=]", Body);
sb.Replace("[=FirstName=]", Security.CurrentUser.FirstName);
sb.Replace("[=LastName=]", Security.CurrentUser.LastName);
Subject = sb.ToString();
}
else
{
Subject = string.Format("RE: [{0}] {1}",
IncidentTicket,
Subject);
}
}
break;
default:
break;
}
#endregion
Pop3Message msg = Create(FullFromEmail, To, Subject, Body, Attachments);
switch (Mode)
{
case EMailClient.IssueMode:
#region Issue
int IssueId = int.Parse(Params["IssueId"]);
IncidentBox incidentBox = IncidentBox.Load(Incident.GetIncidentBox(IssueId));
bool AllowEMailRouting = true;
EMailRouterIncidentBoxBlock settings = IncidentBoxDocument.Load(incidentBox.IncidentBoxId).EMailRouterBlock;
if (!settings.AllowEMailRouting)
{
AllowEMailRouting = false;
}
EMailRouterPop3Box internalPop3Box = EMailRouterPop3Box.ListInternal();
if (internalPop3Box == null)
{
AllowEMailRouting = false;
}
// Register Email Message
// OZ: [2007--05-25] Fix Problem Object reference not set to an instance of an object If (internalPop3Box == NULL)
int EMailMessageId = EMailMessage.Create(internalPop3Box != null?
internalPop3Box.EMailRouterPop3BoxId : EMailRouterOutputMessage.FindEMailRouterPublicId(IssueId),
msg);
// Register Forume Node
int ThreadNodeId = EMailMessage.AddToIncidentMessage(true, IssueId, EMailMessageId, msg);
// Send Message
if (AllowEMailRouting)
{
ArrayList excludedUsers = EMailRouterOutputMessage.Send(IssueId, internalPop3Box, msg, To);
SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Updated_Forum_MessageAdded, IssueId, -1, excludedUsers);
}
else
{
FromEmail = EMailRouterOutputMessage.FindEMailRouterPublicEmail(IssueId);
FullFromEmail = string.Format("\"{0} {1}\" <{2}>",
Security.CurrentUser.LastName,
Security.CurrentUser.FirstName,
FromEmail);
// Create OutputMessageCreator
OutputMessageCreator issueOutput = new OutputMessageCreator(msg,
-1,
FromEmail,
FullFromEmail);
// Fill Recipent
foreach (string ToItem in To)
{
issueOutput.AddRecipient(ToItem);
}
foreach (EMailIssueExternalRecipient exRecipient in EMailIssueExternalRecipient.List(IssueId))
{
issueOutput.AddRecipient(exRecipient.EMail);
}
int emailBoxId = EMail.EMailRouterOutputMessage.FindEMailRouterPublicId(IssueId);
//Send Smtp Message
foreach (OutputMessage outputMsg in issueOutput.Create())
{
SmtpClientUtility.SendMessage(OutgoingEmailServiceType.HelpDeskEmailBox, emailBoxId, outputMsg.MailFrom, outputMsg.RcptTo, outputMsg.Subject, outputMsg.Data);
}
ArrayList excludedUsers = new ArrayList();
foreach (string ToItem in To)
{
int emailUserId = DBUser.GetUserByEmail(ToItem, false);
if (emailUserId > 0)
{
excludedUsers.Add(emailUserId);
}
}
SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Updated_Forum_MessageAdded, IssueId, -1, excludedUsers);
}
#endregion
break;
case EMailClient.SmtpTestMode:
throw new NotImplementedException();
//OutputMessageCreator smtpTestOutput = new OutputMessageCreator(msg,
// -1,
// FromEmail,
// FullFromEmail);
//// Fill Recipent
//foreach (string ToItem in To)
//{
// smtpTestOutput.AddRecipient(ToItem);
//}
////Send Smtp Message
//foreach (OutputMessage outputMsg in smtpTestOutput.Create())
//{
// //SmtpClientUtility.DirectSendMessage(outputMsg.MailFrom, outputMsg.RcptTo, outputMsg.Subject, outputMsg.Data);
// //SmtpBox.SendTestEmail(
//}
//break;
default:
#region Default
// Create OutputMessageCreator
OutputMessageCreator defaultOutput = new OutputMessageCreator(msg,
-1,
FromEmail,
FullFromEmail);
// Fill Recipent
foreach (string ToItem in To)
{
defaultOutput.AddRecipient(ToItem);
}
//Send Smtp Message
foreach (OutputMessage outputMsg in defaultOutput.Create())
{
SmtpClientUtility.SendMessage(OutgoingEmailServiceType.SendFile, null, outputMsg.MailFrom, outputMsg.RcptTo, outputMsg.Subject, outputMsg.Data);
}
#endregion
break;
}
if (Attachments != null)
{
FileStorage.InnerDeleteFolder(Attachments.Id);
}
tran.Commit();
}
}
