private void BindDataGrid()
{
DataTable dtTop = new DataTable();
DataRow dr;
dtTop.Columns.Add(new DataColumn("Id", typeof(int)));
dtTop.Columns.Add(new DataColumn("Index", typeof(string)));
dtTop.Columns.Add(new DataColumn("EMailMessageId", typeof(int)));
dtTop.Columns.Add(new DataColumn("Weight", typeof(int)));
dtTop.Columns.Add(new DataColumn("Sender", typeof(string)));
dtTop.Columns.Add(new DataColumn("Message", typeof(string)));
dtTop.Columns.Add(new DataColumn("SystemMessage", typeof(string)));
dtTop.Columns.Add(new DataColumn("Created", typeof(string)));
dtTop.Columns.Add(new DataColumn("CreationDate", typeof(DateTime)));
dtTop.Columns.Add(new DataColumn("Attachments", typeof(string)));
dtTop.Columns.Add(new DataColumn("NodeType", typeof(string)));
dtTop.Columns.Add(new DataColumn("CanMakeResolution", typeof(bool)));
dtTop.Columns.Add(new DataColumn("CanMakeWorkaround", typeof(bool)));
dtTop.Columns.Add(new DataColumn("CanUnMakeResolution", typeof(bool)));
dtTop.Columns.Add(new DataColumn("CanUnMakeWorkaround", typeof(bool)));
dtTop.Columns.Add(new DataColumn("CanReSend", typeof(bool)));
dtTop.Columns.Add(new DataColumn("CanReSendOut", typeof(bool)));
dtTop.Columns.Add(new DataColumn("CanReply", typeof(bool)));
DataTable dt = dtTop.Clone();
IncidentBox incidentBox = IncidentBox.Load(Incident.GetIncidentBox(IncidentId));
EMailRouterIncidentBoxBlock settings = IncidentBoxDocument.Load(incidentBox.IncidentBoxId).EMailRouterBlock;
bool allowEMailRouting = settings.AllowEMailRouting;
bool CanUpdate = Incident.CanUpdate(IncidentId);
int _index = 0;
foreach (ForumThreadNodeInfo node in Incident.GetForumThreadNodes(IncidentId))
{
bool fl_IsTop = false;
int iWeight = 3;
string typeName = "internal";
ForumThreadNodeSettingCollection coll = new ForumThreadNodeSettingCollection(node.Id);
if (coll[ForumThreadNodeSetting.Question] != null)
{
if (pc["IncForum_Quests458"] == "1")
{
fl_IsTop = true;
iWeight = 0;
}
if (coll[ForumThreadNodeSetting.Incoming] != null)
{
typeName = "Mail_incoming_quest";
}
else if (coll[ForumThreadNodeSetting.Outgoing] != null)
{
typeName = "Mail_outgoing_quest";
}
else
{
typeName = "internal_quest";
}
}
else if (coll[ForumThreadNodeSetting.Resolution] != null)
{
if (pc["IncForum_Resol458"] == "1")
{
fl_IsTop = true;
iWeight = 1;
}
if (coll[ForumThreadNodeSetting.Incoming] != null)
{
typeName = "Mail_incoming_resol";
}
else if (coll[ForumThreadNodeSetting.Outgoing] != null)
{
typeName = "Mail_outgoing_resol";
}
else
{
typeName = "internal_resol";
}
}
else if (coll[ForumThreadNodeSetting.Workaround] != null)
{
if (pc["IncForum_Work458"] == "1")
{
fl_IsTop = true;
iWeight = 2;
}
if (coll[ForumThreadNodeSetting.Incoming] != null)
{
typeName = "Mail_incoming_wa";
}
else if (coll[ForumThreadNodeSetting.Outgoing] != null)
{
typeName = "Mail_outgoing_wa";
}
else
{
typeName = "internal_wa";
}
}
else if (coll[ForumThreadNodeSetting.Incoming] != null)
{
typeName = "Mail_incoming";
}
else if (coll[ForumThreadNodeSetting.Outgoing] != null)
{
typeName = "Mail_outgoing";
}
if (fl_IsTop)
{
dr = dtTop.NewRow();
}
else
{
dr = dt.NewRow();
}
dr["Weight"] = iWeight;
dr["Id"] = node.Id;
dr["EMailMessageId"] = node.EMailMessageId;
dr["CanMakeResolution"] = false;
dr["CanMakeWorkaround"] = false;
dr["CanUnMakeResolution"] = false;
dr["CanUnMakeWorkaround"] = false;
dr["CanReply"] = false;
dr["CanReSend"] = false;
dr["CanReSendOut"] = false;
switch (typeName)
{
case "internal_resol":
case "Mail_incoming_resol":
case "Mail_outgoing_resol":
dr["CanUnMakeResolution"] = true;
break;
case "internal_wa":
case "Mail_incoming_wa":
case "Mail_outgoing_wa":
dr["CanMakeResolution"] = true;
dr["CanUnMakeWorkaround"] = true;
break;
case "internal":
case "Mail_incoming":
case "Mail_outgoing":
dr["CanMakeResolution"] = true;
dr["CanMakeWorkaround"] = true;
break;
default:
break;
}
if (coll[ForumThreadNodeSetting.Outgoing] != null && !Security.CurrentUser.IsExternal)
{
dr["CanReSendOut"] = true;
///AK test
//dr["CanReply"] = true;
///
}
if (coll[ForumThreadNodeSetting.Incoming] != null && !Security.CurrentUser.IsExternal)
{
dr["CanReply"] = true;
dr["CanReSend"] = allowEMailRouting;
}
if (node.EMailMessageId <= 0)
{
dr["Sender"] = CommonHelper.GetUserStatus(node.CreatorId);
}
dr["Created"] = node.Created.ToShortDateString() + " " + node.Created.ToShortTimeString();
dr["CreationDate"] = node.Created;
string sNodeType = typeName;
try
{
sNodeType = LocRM.GetString(String.Format("NodeType_{0}", typeName));
}
catch
{
}
dr["NodeType"] = String.Format("<img alt='{1}' src='../Layouts/Images/icons/{0}.gif'/>", typeName, sNodeType);
dr["SystemMessage"] = " ";
string sMessage = "";
if (coll[IncidentForum.IssueEvent.Declining.ToString()] != null)
{
sMessage = String.Format("<font color='red'><b>{0}</b></font>",
LocRM.GetString("tUserDeclined"));
}
if (coll[IncidentForum.IssueEvent.State.ToString()] != null)
{
int stateId = int.Parse(coll[IncidentForum.IssueEvent.State.ToString()].ToString());
if (sMessage == "")
{
sMessage = String.Format("{2}: <font color='{0}'><b>{1}</b></font>",
Util.CommonHelper.GetStateColorString(stateId),
GetStatusName(stateId),
LocRM.GetString("Status"));
}
else
{
sMessage += String.Format("{2}: <font color='{0}'><b>{1}</b></font>",
Util.CommonHelper.GetStateColorString(stateId),
GetStatusName(stateId),
LocRM.GetString("Status"));
}
}
if (coll[IncidentForum.IssueEvent.Responsibility.ToString()] != null)
{
string sResp = "";
int iResp = int.Parse(coll[IncidentForum.IssueEvent.Responsibility.ToString()].ToString());
if (iResp == -2)
{
sResp = String.Format("<img alt='' src='{0}'/> <span style='color:#808080;font-weight:bold'>{1}</span>",
ResolveUrl("~/Layouts/Images/not_set.png"),
LocRM.GetString("tRespNotSet"));
}
else if (iResp == -1)
{
sResp = String.Format("<img alt='' src='{0}'/> <span style='color:green;font-weight:bold'>{1}</span>",
ResolveUrl("~/Layouts/Images/waiting.gif"),
LocRM.GetString("tRespGroup"));
}
else
{
sResp = Util.CommonHelper.GetUserStatus(iResp);
}
sResp = "<span class='IconAndText'><span>" + LocRM.GetString("tResponsible") + ":</span> " + sResp + "</span>";
if (sMessage == "")
{
sMessage = sResp;
}
else
{
sMessage += "<br/>" + sResp;
}
}
if (WasFarwarded == 1 && node.EMailMessageId == ForwardedEMail)
{
sMessage = "<font color='green'><b>" + LocRM.GetString("tWasResended") + "</b></font><br/>" + sMessage;
}
if (WasFarwarded == -1 && node.EMailMessageId == ForwardedEMail)
{
sMessage = "<font color='red'><b>" + LocRM.GetString("tWasNotResended") + "</b></font><br/>" + sMessage;
}
dr["SystemMessage"] = (sMessage.Length == 0) ? " " : sMessage;
string sAttach = "";
// EmailMessage
if (node.EMailMessageId > 0)
{
EMailMessageInfo mi = null;
try
{
mi = EMailMessageInfo.Load(node.EMailMessageId);
int iUserId = User.GetUserByEmail(mi.SenderEmail);
if (EMailClient.IsAlertSenderEmail(mi.SenderEmail))
{
iUserId = node.CreatorId; //User.GetUserByEmail(mi.SenderEmail);
}
if (iUserId > 0)
{
dr["Sender"] = Util.CommonHelper.GetUserStatus(iUserId);
}
else
{
Client client = Mediachase.IBN.Business.Common.GetClient(mi.SenderEmail);
if (client != null)
{
if (client.IsContact)
{
dr["Sender"] = CommonHelper.GetContactLink(this.Page, client.Id, client.Name);
}
else
{
dr["Sender"] = CommonHelper.GetOrganizationLink(this.Page, client.Id, client.Name);
}
}
else if (mi.SenderName != "")
{
dr["Sender"] = CommonHelper.GetEmailLink(mi.SenderEmail, mi.SenderName);
}
else
{
dr["Sender"] = CommonHelper.GetEmailLink(mi.SenderEmail, mi.SenderEmail);
}
}
string sBody = "";
if (mi.HtmlBody != null)
{
int iMaxLen = 256;
sBody = mi.HtmlBody;
if (!Security.CurrentUser.IsExternal && pc["IncForum_FullMess"] != "1")
{
sBody = EMailMessageInfo.CutHtmlBody(mi.HtmlBody, iMaxLen, "...");
}
}
if (pc["IncForum_FullMess"] != "1")
{
dr["Message"] = String.Format("{0}<div class='text' style='text-align:right; font-weight:bold'><a href='javascript:OpenMessage({2},{3},false)'>{1}</a></div>", sBody, LocRM.GetString("More"), node.Id, node.EMailMessageId);
}
else
{
dr["Message"] = sBody;
}
// Attachments
for (int i = 0; i < mi.Attachments.Length; i++)
{
AttachmentInfo ai = mi.Attachments[i];
int id = DSFile.GetContentTypeByFileName(ai.FileName);
string sIcon = "";
if (id > 0)
{
sIcon = String.Format("<img alt='' src='{0}'/>", ResolveUrl("~/Common/ContentIcon.aspx?IconID=" + id));
}
//sAttach += String.Format("<nobr><a href='{0}'{2}>{1}</a></nobr> ",
// ResolveUrl("~/Incidents/EmailAttachDownload.aspx") + "?EMailId=" + node.EMailMessageId.ToString() + "&AttachmentIndex=" + i.ToString(),
// sIcon + " " + ai.FileName,
// Mediachase.IBN.Business.Common.OpenInNewWindow(ai.ContentType) ? " target='_blank'" : "");
sAttach += String.Format("<a href='{0}'{2} style='white-space:nowrap'>{1}</a> ", WebDavUrlBuilder.GetEmailAtachWebDavUrl(node.EMailMessageId, i, true),
sIcon + " " + ai.FileName, Mediachase.IBN.Business.Common.OpenInNewWindow(ai.ContentType) ? " target='_blank'" : "");
}
}
catch
{
dr["Sender"] = Util.CommonHelper.GetUserStatus(-1);
dr["Message"] = String.Format("<font color='red'><b>{0}</b> (#{1})</font>", LocRM.GetString("tNotFound"), node.EMailMessageId);
}
}
else
{
string sBody = CommonHelper.parsetext_br(node.Text, false);
dr["Message"] = sBody;
if (!Security.CurrentUser.IsExternal && pc["IncForum_FullMess"] != "1")
{
int iMaxLen = 300;
string sBody1 = sBody;
sBody = EMailMessageInfo.CutHtmlBody(sBody, iMaxLen, "...");
if (!sBody.Equals(sBody1))
{
dr["Message"] = String.Format("{0}<div class='text' style='text-align:right; font-weight:bold'><a href=\"javascript:OpenMessage({2},-1,true)\">{1}</a></div>", sBody, LocRM.GetString("More"), node.Id);
}
}
// Files
if (node.ContentType == ForumStorage.NodeContentType.TextWithFiles)
{
FileInfo[] files = Incident.GetForumNodeFiles(node.Id);
if (files.Length > 0)
{
foreach (FileInfo fl in files)
{
if (sAttach != "")
{
sAttach += " ";
}
string sTarget = Mediachase.IBN.Business.Common.OpenInNewWindow(fl.FileBinaryContentType) ? " target='_blank'" : "";
//string sLink = Util.CommonHelper.GetAbsolutePath(WebDavFileUserTicket.GetDownloadPath(fl.Id, fl.Name));
string sLink = Util.CommonHelper.GetAbsoluteDownloadFilePath(fl.Id, fl.Name, "FileLibrary", "ForumNodeId_" + node.Id);
string sNameLocked = CommonHelper.GetLockerText(sLink);
sAttach += String.Format("<span style='white-space:nowrap'><a href=\"{1}\"{3}><img alt='' src='../Common/ContentIcon.aspx?IconID={2}'/> {0}</a> {4}</span>", fl.Name, sLink, fl.FileBinaryContentTypeId, sTarget, sNameLocked);
}
}
}
}
dr["Attachments"] = sAttach;
if (sMessage.Length > 0 && dr["Message"].ToString() == "" && sAttach.Length == 0)
{
if (pc["IncForum_Info"] == "0")
{
continue;
}
dr["NodeType"] = String.Format("<img src='../Layouts/Images/icons/info_message.gif' alt='{1}'/>", typeName, LocRM.GetString("NodeType_InfoMessage"));
dr["CanMakeResolution"] = false;
dr["CanMakeWorkaround"] = false;
dr["CanUnMakeResolution"] = false;
dr["CanUnMakeWorkaround"] = false;
}
if (dr["Message"].ToString().Trim() == "")
{
dr["Message"] = " ";
}
if (pc["IncForum_ShowNums"] == "1")
{
dr["Index"] = "<table cellspacing='0' cellpadding='4' border='0' width='100%'><tr><td class='text' align='center' style='background-position: center center; background-image: url(../Layouts/Images/atrisk1.gif); background-repeat: no-repeat'><b>" + (++_index).ToString() + "</b></td></tr></table>";
}
else
{
dr["Index"] = " ";
}
if (fl_IsTop)
{
dtTop.Rows.Add(dr);
}
else
{
dt.Rows.Add(dr);
}
}
DataRow[] drtop = dtTop.Select("", "Weight, CreationDate");
DataRow[] drother = dt.Select("", pc["IncForum_Sort458"]);
DataTable result = dt.Clone();
foreach (DataRow dr1 in drtop)
{
DataRow _dr = result.NewRow();
_dr.ItemArray = (Object[])dr1.ItemArray.Clone();
result.Rows.Add(_dr);
}
foreach (DataRow dr2 in drother)
{
DataRow _dr = result.NewRow();
_dr.ItemArray = (Object[])dr2.ItemArray.Clone();
result.Rows.Add(_dr);
}
DataView dv = result.DefaultView;
dgForum.DataSource = dv;
if (pc["IncidentForum_PageSize"] != null)
{
dgForum.PageSize = int.Parse(pc["IncidentForum_PageSize"]);
}
if (pc["IncidentForum_Page"] != null)
{
int iPageIndex = int.Parse(pc["IncidentForum_Page"]);
int ppi = dv.Count / dgForum.PageSize;
if (dv.Count % dgForum.PageSize == 0)
{
ppi = ppi - 1;
}
if (iPageIndex <= ppi)
{
dgForum.CurrentPageIndex = iPageIndex;
}
else
{
dgForum.CurrentPageIndex = 0;
}
pc["IncidentForum_Page"] = dgForum.CurrentPageIndex.ToString();
}
dgForum.DataBind();
foreach (DataGridItem dgi in dgForum.Items)
{
ImageButton ib = (ImageButton)dgi.FindControl("ibDelete");
if (ib != null)
{
ib.ToolTip = LocRM.GetString("Delete");
ib.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("WarningForumNode") + "')");
ib.Visible = CanUpdate;
}
ImageButton ib1 = (ImageButton)dgi.FindControl("ibResolution");
if (ib1 != null)
{
ib1.ToolTip = LocRM.GetString("tMarkAsResolution");
ib1.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("tMarkAsResolutionWarning") + "')");
}
ImageButton ib2 = (ImageButton)dgi.FindControl("ibWA");
if (ib2 != null)
{
ib2.ToolTip = LocRM.GetString("tMarkAsWA");
ib2.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("tMarkAsWAWarning") + "')");
}
ImageButton ib3 = (ImageButton)dgi.FindControl("ibUnResolution");
if (ib3 != null)
{
ib3.ToolTip = LocRM.GetString("tUnMarkAsResolution");
ib3.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("tUnMarkAsResolutionWarning") + "')");
}
ImageButton ib4 = (ImageButton)dgi.FindControl("ibUnWA");
if (ib4 != null)
{
ib4.ToolTip = LocRM.GetString("tUnMarkAsWA");
ib4.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("tUnMarkAsWAWarning") + "')");
}
ImageButton ib5 = (ImageButton)dgi.FindControl("ibReSend");
if (ib5 != null)
{
ib5.ToolTip = LocRM.GetString("tReSend");
ib5.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("tReSendWarning") + "')");
}
ImageButton ib6 = (ImageButton)dgi.FindControl("ibReSendOut");
if (ib6 != null)
{
ib6.ToolTip = LocRM.GetString("tReSend");
ib6.Attributes.Add("onclick", "return confirm('" + LocRM.GetString("tReSendOutWarning") + "')");
}
ImageButton ib7 = (ImageButton)dgi.FindControl("ibReply");
if (ib7 != null)
{
ib7.ToolTip = LocRM.GetString("tReply");
if (!allowEMailRouting || (pc["IncForum_ReplyOutlook"] == "0" && pc["IncForum_ReplyEML"] == "0"))
{
string command = string.Format(CultureInfo.InvariantCulture,
"{{ShowResizableWizard('{0}?IncidentId={1}&NodeId={2}&send=1',800,600);return false;}}",
Page.ResolveUrl("~/Incidents/AddEMailMessage.aspx"), IncidentId, ib7.CommandArgument);
ib7.Attributes.Add("onclick", command);
}
}
}
if (dgForum.Items.Count == 0)
{
dgForum.Visible = false;
divNoMess.Visible = true;
divNoMess.InnerHtml = "<span style='color:red'>" + LocRM.GetString("NoMessages") + "</span>";
}
else
{
dgForum.Visible = true;
divNoMess.Visible = false;
}
}
private void BindEmailValues()
{
EMailMessageInfo mi = EMailMessageInfo.Load(EMailMessageId);
IncidentInfo incidentInfo = EMailIncidentMappingHandler.CreateMapping(EMailMessageId);
// Eval IncidentBox
ddlFolder.SelectedValue = IncidentBoxRule.Evaluate(incidentInfo).IncidentBoxId.ToString();
txtTitle.Text = incidentInfo.Title;
ftbDescription.Text = incidentInfo.Description;
CommonHelper.SafeSelect(ddlPriority, incidentInfo.PriorityId.ToString());
CommonHelper.SafeSelect(ddlSeverity, incidentInfo.SeverityId.ToString());
CommonHelper.SafeSelect(ddlType, incidentInfo.TypeId.ToString());
ddProject.ObjectTypeId = (int)ObjectTypes.Project;
ddProject.ObjectId = incidentInfo.ProjectId;
if (incidentInfo.GeneralCategories != null)
{
foreach (int CatId in incidentInfo.GeneralCategories)
{
CommonHelper.SafeMultipleSelect(lbCategory, CatId.ToString());
}
}
if (incidentInfo.IncidentCategories != null)
{
foreach (int CatId in incidentInfo.IncidentCategories)
{
CommonHelper.SafeMultipleSelect(lbIncidentCategory, CatId.ToString());
}
}
//try from MailSenderEmail
PrimaryKeyId contactUid = PrimaryKeyId.Empty;
PrimaryKeyId orgUid = PrimaryKeyId.Empty;
Client client = Common.GetClient(incidentInfo.MailSenderEmail);
if (client != null)
{
if (client.IsContact)
{
contactUid = client.Id;
ClientControl.ObjectType = ContactEntity.GetAssignedMetaClassName();
ClientControl.ObjectId = contactUid;
}
else
{
orgUid = client.Id;
ClientControl.ObjectType = OrganizationEntity.GetAssignedMetaClassName();
ClientControl.ObjectId = orgUid;
}
}
//from incidentinfo
if (orgUid == PrimaryKeyId.Empty && contactUid == PrimaryKeyId.Empty)
{
if (incidentInfo.OrgUid != PrimaryKeyId.Empty)
{
ClientControl.ObjectType = OrganizationEntity.GetAssignedMetaClassName();
ClientControl.ObjectId = incidentInfo.OrgUid;
}
else if (incidentInfo.ContactUid != PrimaryKeyId.Empty)
{
ClientControl.ObjectType = ContactEntity.GetAssignedMetaClassName();
ClientControl.ObjectId = incidentInfo.ContactUid;
}
}
trHtmlAttach.Visible = false;
trEmail.Visible = true;
string sBody = "";
if (mi.HtmlBody != null)
{
sBody = EMailMessageInfo.CutHtmlBody(mi.HtmlBody, 256, "...");
}
if (sBody.Trim() != "")
{
lblEmail.Text = String.Format("{0}<p align=right class='text'><a href=\"javascript:OpenSizableWindow('EMailView.aspx?EMailId={2}', 750, 550)\"><b>{1}</b></a>", sBody, LocRM4.GetString("More"), EMailMessageId);
}
else
{
lblEmail.Text = sBody;
}
}