public static void SetPrivateStatus(int ThreadNodeId)
{
ForumThreadNodeSettingCollection settings = new ForumThreadNodeSettingCollection(ThreadNodeId);
if(settings.Contains(ForumThreadNodeSetting.Outgoing))
settings.Remove(ForumThreadNodeSetting.Outgoing);
if(settings.Contains(ForumThreadNodeSetting.Incoming))
settings.Remove(ForumThreadNodeSetting.Incoming);
settings.Add(ForumThreadNodeSetting.Internal, "1");
}
private void dgForum_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "Resolution")
{
int nodeId = int.Parse(e.CommandArgument.ToString());
ForumThreadNodeSettingCollection coll = new ForumThreadNodeSettingCollection(nodeId);
coll.Add(ForumThreadNodeSetting.Resolution, "1");
if (coll[ForumThreadNodeSetting.Internal] == null &&
coll[ForumThreadNodeSetting.Incoming] == null &&
coll[ForumThreadNodeSetting.Outgoing] == null)
coll.Add(ForumThreadNodeSetting.Internal, "1");
}
else if (e.CommandName == "Workaround")
{
int nodeId = int.Parse(e.CommandArgument.ToString());
ForumThreadNodeSettingCollection coll = new ForumThreadNodeSettingCollection(nodeId);
coll.Add(ForumThreadNodeSetting.Workaround, "1");
if (coll[ForumThreadNodeSetting.Internal] == null &&
coll[ForumThreadNodeSetting.Incoming] == null &&
coll[ForumThreadNodeSetting.Outgoing] == null)
coll.Add(ForumThreadNodeSetting.Internal, "1");
}
else if (e.CommandName == "UnResolution")
{
int nodeId = int.Parse(e.CommandArgument.ToString());
ForumThreadNodeSettingCollection coll = new ForumThreadNodeSettingCollection(nodeId);
if (coll[ForumThreadNodeSetting.Resolution] != null)
coll.Remove(ForumThreadNodeSetting.Resolution);
if (coll[ForumThreadNodeSetting.Internal] == null &&
coll[ForumThreadNodeSetting.Incoming] == null &&
coll[ForumThreadNodeSetting.Outgoing] == null)
coll.Add(ForumThreadNodeSetting.Internal, "1");
}
else if (e.CommandName == "UnWorkaround")
{
int nodeId = int.Parse(e.CommandArgument.ToString());
ForumThreadNodeSettingCollection coll = new ForumThreadNodeSettingCollection(nodeId);
if (coll[ForumThreadNodeSetting.Workaround] != null)
coll.Remove(ForumThreadNodeSetting.Workaround);
if (coll[ForumThreadNodeSetting.Internal] == null &&
coll[ForumThreadNodeSetting.Incoming] == null &&
coll[ForumThreadNodeSetting.Outgoing] == null)
coll.Add(ForumThreadNodeSetting.Internal, "1");
}
else if (e.CommandName == "ReSend")
{
int emailMessageId = int.Parse(e.CommandArgument.ToString());
try
{
EMailRouterOutputMessage.Send(IncidentId, emailMessageId);
WasFarwarded = 1;
ForwardedEMail = emailMessageId;
}
catch
{
WasFarwarded = -1;
ForwardedEMail = emailMessageId;
}
}
else if (e.CommandName == "ReSendOut")
{
int emailMessageId = int.Parse(e.CommandArgument.ToString());
try
{
EMailRouterOutputMessage.Send(IncidentId, emailMessageId);
WasFarwarded = 1;
ForwardedEMail = emailMessageId;
}
catch
{
WasFarwarded = -1;
ForwardedEMail = emailMessageId;
}
}
else if (e.CommandName == "Reply")
{
try
{
int emailMessageId = int.Parse(e.CommandArgument.ToString());
if (pc["IncForum_ReplyOutlook"] == "1")
{
Response.AddHeader("content-disposition", String.Format("attachment; filename=\"{0}\"", "mail.msg"));
HttpContext.Current.Response.ContentType = "application/msoutlook";
MsgMessage.Open(IncidentId, emailMessageId,
HttpContext.Current.Response.OutputStream);
}
else if (pc["IncForum_ReplyEML"] == "1")
{
Response.AddHeader("content-disposition", String.Format("attachment; filename=\"{0}\"", "mail.eml"));
HttpContext.Current.Response.ContentType = "message/rfc822";
MsgMessage.OpenEml(IncidentId, emailMessageId,
HttpContext.Current.Response.OutputStream);
}
Response.End();
}
catch (Exception ex)
{
HttpContext.Current.Trace.Write(ex.Message);
}
}
}
public static int CreateFromEmail(
string title,
string description,
int project_id,
int type_id,
int priority,
int severity_id,
int task_time,
int expected_duration,
int expected_response_time,
int expected_assign_time,
ArrayList categories,
ArrayList incident_categories,
int IncidentBoxId,
int EMailMessageId,
PrimaryKeyId orgUid,
PrimaryKeyId contactUid,
int mustResponsibleId,
bool useDuration,
DateTime expResolveDate
)
{
if (!Company.CheckDiskSpace())
throw new MaxDiskSpaceException();
// OZ 2009-03-11 Fixed AccessDeniedException if user is inactive
//if (!CanCreate(project_id))
// throw new AccessDeniedException();
title = title.Replace("<", "<").Replace(">", ">");
DateTime now = DateTime.UtcNow;
object oProjectId = null;
if (project_id > 0)
oProjectId = project_id;
EMailMessageInfo mi = EMailMessageInfo.Load(EMailMessageId);
// int SenderUserID = -1; // TODO: Find User By Email
// int UserId = Security.CurrentUser.UserID;
// if (SenderUserID > 0)
// UserId = SenderUserID;
if (orgUid == PrimaryKeyId.Empty && contactUid == PrimaryKeyId.Empty)
{
Client client = Common.GetClient(mi.SenderEmail);
if (client != null)
{
if (client.IsContact)
{
contactUid = client.Id;
}
else
{
orgUid = client.Id;
}
}
}
int stateId, managerId, responsibleId;
bool isResposibleGroup;
ArrayList users = new ArrayList();
Issue2.GetIssueBoxSettings(IncidentBoxId, out stateId, out managerId, out responsibleId, out isResposibleGroup, users);
// O.R. [2008-09-09]: Exclude inactive users
if (responsibleId > 0 && User.GetUserActivity(responsibleId) != User.UserActivity.Active)
responsibleId = -1;
ArrayList activeUsers = new ArrayList();
foreach (int userId in users)
{
if (User.GetUserActivity(userId) == User.UserActivity.Active)
activeUsers.Add(userId);
}
//
//ak [2009-06-10] responsible from creation page (IncidentEdit1)
if (mustResponsibleId > 0)
{
responsibleId = mustResponsibleId;
// O.R. [2009-12-17] upcoming state with responsible fix
if (stateId == (int)ObjectStates.Upcoming)
stateId = (int)ObjectStates.Active;
isResposibleGroup = false;
}
IncidentBox box = IncidentBox.Load(IncidentBoxId);
if (useDuration)
expResolveDate = DBCalendar.GetFinishDateByDuration(box.Document.GeneralBlock.CalendarId, now, expected_duration);
else
{
expResolveDate = User.GetUTCDate(expResolveDate);
expected_duration = DBCalendar.GetDurationByFinishDate(box.Document.GeneralBlock.CalendarId, now, expResolveDate);
}
int IncidentId;
using(DbTransaction tran = DbTransaction.Begin())
{
// Remove from Pending
PendingEMailMessageRow.DeleteByEMailMessageId(EMailMessageId);
// Add to white list
if (PortalConfig.UseAntiSpamFilter && PortalConfig.AutoFillWhiteList)
WhiteListItem.Create(mi.SenderEmail);
IncidentId = DBIncident.Create(oProjectId, Security.UserID,
title, description, now,
type_id, priority, stateId, severity_id, true, task_time,
IncidentBoxId, responsibleId, isResposibleGroup ? 1 : 0,
contactUid, orgUid,
expected_duration, expected_response_time, expected_assign_time,
expResolveDate, useDuration);
string Identifier = TicketUidUtil.Create(box.IdentifierMask, IncidentId);
DBIncident.UpdateIdentifier(IncidentId, Identifier);
// Categories
foreach(int CategoryId in categories)
{
DBCommon.AssignCategoryToObject((int)INCIDENT_TYPE, IncidentId, CategoryId);
}
// Incident Categories
foreach(int CategoryId in incident_categories)
{
DBIncident.AssignIncidentCategory(IncidentId, CategoryId);
}
foreach(int UserId in activeUsers)
{
DbIssue2.ResponsibleGroupAddUser(IncidentId, UserId);
}
// Update Incident Identifier
//string Ticket = TicketUidUtil.Create(box.IdentifierMask,IncidentId);
//DBIncident.UpdateIdentifier(IncidentId, Ticket);
// Forum
// Upload Forum Message
BaseIbnContainer FOcontainer = BaseIbnContainer.Create("FileLibrary",string.Format("IncidentId_{0}",IncidentId));
ForumStorage forumStorage = (ForumStorage)FOcontainer.LoadControl("ForumStorage");
ForumThreadNodeInfo info = forumStorage.CreateForumThreadNode(EMailMessageInfo.ExtractTextFromHtml(mi.HtmlBody),
DateTime.UtcNow,
Security.UserID,
EMailMessageId,
(int)ForumStorage.NodeContentType.EMail);
ForumThreadNodeSettingCollection settings = new ForumThreadNodeSettingCollection(info.Id);
settings.Add(ForumThreadNodeSetting.Incoming, "1");
settings.Add(ForumThreadNodeSetting.Question, "1");
// O.R: Recalculating project TaskTime
if (project_id > 0 && task_time > 0)
TimeTracking.RecalculateProjectTaskTime(project_id);
// 2006-12-12 OZ: Register EMail External Recepient
EMailIssueExternalRecipient.Create(IncidentId, mi.SenderEmail);
string emailFrom = EMail.EMailRouterOutputMessage.FindEMailRouterPublicEmail(IncidentId);
ArrayList excludeUsers = EMailRouterOutputMessage.Send(IncidentId, EMailMessageId);
//SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Created, IncidentId, -1, sendAutoReply ? mi.SenderEmail : null, emailFrom, excludeUsers);
// 2007-02-12 OZ: Auto reply per Issue Box
EMailRouterOutputMessage.SendAutoReply(IncidentId, emailFrom, mi.SenderEmail);
// O.R.[2008-12-16]: Recalculate Current Responsible
DBIncident.RecalculateCurrentResponsible(IncidentId);
// O.R. [2009-06-15]: Recalculate project dates
if (project_id > 0 && PortalConfig.UseIncidentDatesForProject && !useDuration)
Project.RecalculateDates(project_id);
if(project_id > 0)
SystemEvents.AddSystemEvents(SystemEventTypes.Project_Updated_IssueList_IssueAdded, project_id, IncidentId, excludeUsers);
Issue2.SendAlertsForNewIssue(IncidentId, managerId, responsibleId, activeUsers, excludeUsers);
// 2007-02-15: OZ: New Message Addon
Issue2.SetNewMessage(IncidentId, true);
//
// O.R. [2008-09-22]: Gate for sender
Issue2.UpdateMailSenderEmail(IncidentId, mi.SenderEmail);
tran.Commit();
}
return IncidentId;
}
public static int Create(
string title,
string description,
int project_id,
int type_id,
int priority,
int severity_id,
int task_time,
int expected_duration,
int expected_response_time,
int expected_assign_time,
int creator_id,
ArrayList categories,
ArrayList incident_categories,
string FileName,
System.IO.Stream _inputStream,
bool IsEmail,
DateTime creation_date,
int IncidentBoxId,
PrimaryKeyId contactUid,
PrimaryKeyId orgUid,
int mustResponsibleId,
bool useDuration,
DateTime expResolveDate
)
{
if (!Company.CheckDiskSpace())
throw new MaxDiskSpaceException();
if (!CanCreate(project_id))
throw new AccessDeniedException();
// DateTime creation_date = DateTime.UtcNow;
title = title.Replace("<", "<").Replace(">", ">");
object oProjectId = null;
if (project_id > 0)
oProjectId = project_id;
IncidentBox box = null;
if(IncidentBoxId <= 0)
{
IncidentInfo info = new IncidentInfo();
info.Description = description;
info.GeneralCategories = categories;
info.IncidentCategories = incident_categories;
info.PriorityId = priority;
info.SeverityId = severity_id;
info.Title = title;
info.TypeId = type_id;
info.ContactUid = contactUid;
info.OrgUid = orgUid;
if (project_id > 0)
info.ProjectId = project_id;
if(creator_id < 0)
info.CreatorId = Security.CurrentUser.UserID;
else
info.CreatorId = creator_id;
box = IncidentBoxRule.Evaluate(info);
if (box == null)
throw new ArgumentNullException("box");
IncidentBoxId = box.IncidentBoxId;
}
else
box = IncidentBox.Load(IncidentBoxId);
// OZ: Fixed expected_duration and expected_response_time
if (expected_duration <= 0)
expected_duration = box.Document.GeneralBlock.ExpectedDuration;
if (expected_response_time <= 0)
expected_response_time = box.Document.GeneralBlock.ExpectedResponseTime;
if (expected_assign_time <= 0)
expected_assign_time = box.Document.GeneralBlock.ExpectedAssignTime;
//
if (task_time <= 0)
task_time = box.Document.GeneralBlock.TaskTime;
int stateId, managerId, responsibleId;
bool isResposibleGroup;
ArrayList users = new ArrayList();
Issue2.GetIssueBoxSettings(IncidentBoxId, out stateId, out managerId, out responsibleId, out isResposibleGroup, users);
// O.R. [2008-09-09]: Exclude inactive users
if (responsibleId > 0 && User.GetUserActivity(responsibleId) != User.UserActivity.Active)
responsibleId = -1;
ArrayList activeUsers = new ArrayList();
foreach (int userId in users)
{
if (User.GetUserActivity(userId) == User.UserActivity.Active)
activeUsers.Add(userId);
}
//
//ak [2009-06-10] responsible from creation page (IncidentEdit1)
if (mustResponsibleId > 0)
{
responsibleId = mustResponsibleId;
isResposibleGroup = false;
}
if (useDuration)
expResolveDate = DBCalendar.GetFinishDateByDuration(box.Document.GeneralBlock.CalendarId, creation_date, expected_duration);
else
{
expResolveDate = User.GetUTCDate(expResolveDate);
expected_duration = DBCalendar.GetDurationByFinishDate(box.Document.GeneralBlock.CalendarId, creation_date, expResolveDate);
}
int issueId;
using(DbTransaction tran = DbTransaction.Begin())
{
issueId = DBIncident.Create(oProjectId, creator_id,
title, description, creation_date,
type_id, priority, stateId, severity_id, IsEmail, task_time,
IncidentBoxId, responsibleId, isResposibleGroup?1:0, contactUid, orgUid,
expected_duration, expected_response_time, expected_assign_time, expResolveDate, useDuration);
string Identifier = TicketUidUtil.Create(box.IdentifierMask,issueId);
DBIncident.UpdateIdentifier(issueId, Identifier);
// Categories
foreach(int CategoryId in categories)
{
DBCommon.AssignCategoryToObject((int)INCIDENT_TYPE, issueId, CategoryId);
}
// Incident Categories
foreach(int CategoryId in incident_categories)
{
DBIncident.AssignIncidentCategory(issueId, CategoryId);
}
foreach(int UserId in activeUsers)
{
DbIssue2.ResponsibleGroupAddUser(issueId, UserId);
}
ForumStorage.NodeContentType _type = (FileName != String.Empty && _inputStream != null) ?
ForumStorage.NodeContentType.TextWithFiles : ForumStorage.NodeContentType.Text;
// Forum
BaseIbnContainer destContainer = BaseIbnContainer.Create("FileLibrary", string.Format("IncidentId_{0}", issueId));
ForumStorage forumStorage = (ForumStorage)destContainer.LoadControl("ForumStorage");
if(description != String.Empty || (FileName != String.Empty && _inputStream != null))
{
ForumThreadNodeInfo info = forumStorage.CreateForumThreadNode(description, creator_id, (int)_type);
if(FileName != String.Empty && _inputStream != null)
{
BaseIbnContainer forumContainer = BaseIbnContainer.Create("FileLibrary", string.Format("ForumNodeId_{0}", info.Id));
FileStorage fs = (FileStorage)forumContainer.LoadControl("FileStorage");
fs.SaveFile(FileName, _inputStream);
}
ForumThreadNodeSettingCollection settings1 = new ForumThreadNodeSettingCollection(info.Id);
settings1.Add(ForumThreadNodeSetting.Internal, "1");
settings1.Add(ForumThreadNodeSetting.Question, "1");
}
// O.R: Recalculating project TaskTime
if (project_id > 0 && task_time > 0)
TimeTracking.RecalculateProjectTaskTime(project_id);
// O.R.[2008-12-16]: Recalculate Current Responsible
DBIncident.RecalculateCurrentResponsible(issueId);
// O.R. [2009-06-15]: Recalculate project dates
if (project_id > 0 && PortalConfig.UseIncidentDatesForProject && !useDuration)
Project.RecalculateDates(project_id);
SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Created, issueId);
if(project_id > 0)
SystemEvents.AddSystemEvents(SystemEventTypes.Project_Updated_IssueList_IssueAdded, project_id, issueId);
Issue2.SendAlertsForNewIssue(issueId, managerId, responsibleId, activeUsers, null);
tran.Commit();
}
return issueId;
}
protected void btnSubmit_Click(object sender, System.EventArgs e)
{
bool withResponse = false;
if (this.IsPostBack)
{
try
{
string sUserLight = "userlight";
// check user's name and password here
UserLight currentUser = Security.GetUser(Login.Value, Password.Value);
if (currentUser == null)
throw new HttpException(405, "Your login or password is invalid.");
// Security Addon [3/2/2004]
UserLight retUser = null;
if (HttpContext.Current.Items.Contains(sUserLight))
{
retUser = (UserLight)HttpContext.Current.Items[sUserLight];
HttpContext.Current.Items.Remove(sUserLight);
}
HttpContext.Current.Items.Add(sUserLight, currentUser);
// End Security Addon [3/2/2004]
// New Folder System Addon [12/27/2005]
string ContainerName = "FileLibrary";
string ContainerKey = String.Empty;
int objectId = Int32.Parse(ObjectId.Value);
int objectTypeId = Int32.Parse(ObjectTypeId.Value);
int folderId = 0;
switch ((ObjectTypes)objectTypeId)
{
case ObjectTypes.Project:
ContainerKey = "ProjectId_" + objectId.ToString();
break;
case ObjectTypes.Issue:
ContainerKey = string.Empty;
break;
case ObjectTypes.Task:
ContainerKey = "TaskId_" + objectId.ToString();
break;
case ObjectTypes.CalendarEntry:
ContainerKey = "EventId_" + objectId.ToString();
break;
case ObjectTypes.Folder:
ContainerKey = "Workspace";
if (objectId != 0)
{
folderId = objectId;
ContainerKey = Mediachase.IBN.Business.ControlSystem.DirectoryInfo.GetContainerKey(folderId);
}
break;
case ObjectTypes.Document:
ContainerKey = "DocumentId_" + objectId.ToString();
break;
case ObjectTypes.ToDo:
ContainerKey = "ToDoId_" + objectId.ToString();
break;
}
if (ContainerKey != String.Empty)
{
Mediachase.IBN.Business.ControlSystem.BaseIbnContainer bic = Mediachase.IBN.Business.ControlSystem.BaseIbnContainer.Create(ContainerName, ContainerKey);
Mediachase.IBN.Business.ControlSystem.FileStorage fs = (Mediachase.IBN.Business.ControlSystem.FileStorage)bic.LoadControl("FileStorage");
if (folderId == 0)
folderId = fs.Root.Id;
string fileName = Path.GetFileName(PublishedFile.PostedFile.FileName);
if (FileName.Value != string.Empty)
{
fileName = FileName.Value;
}
/*int index = 0;
while (fs.FileExist(fileName, folderId))
{
fileName = Path.GetFileNameWithoutExtension(PublishedFile.PostedFile.FileName) + (index++).ToString();
fileName += Path.GetExtension(PublishedFile.PostedFile.FileName);
}*/
fs.SaveFile(folderId, fileName, PublishedFile.PostedFile.InputStream);
}
else if ((ObjectTypes)objectTypeId == ObjectTypes.List)
{
string xml = SaveNParseExcel(PublishedFile.PostedFile.FileName, PublishedFile.PostedFile.InputStream);
Response.BinaryWrite(System.Text.Encoding.UTF8.GetBytes(xml));
withResponse = true;
}
else if ((ObjectTypes)objectTypeId == ObjectTypes.Issue)
{
string fileName = Path.GetFileName(PublishedFile.PostedFile.FileName);
if (FileName.Value != string.Empty)
{
fileName = FileName.Value;
}
// OZ: 2008-08-19 Add Process Eml Attachments
if (Path.GetExtension(fileName).ToLower() == ".eml")
{
// Calculate email box
int emailBoxId = EMailRouterOutputMessage.FindEMailRouterPublicId(objectId);
// Save Email to email storage
int eMailMessageId = EMailMessage.CreateFromStream(emailBoxId, PublishedFile.PostedFile.InputStream);
EMailMessage.AddToIncidentMessage(false, objectId, eMailMessageId);
try
{
ArrayList excludeUsers = EMailRouterOutputMessage.Send(objectId, eMailMessageId);
SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Updated_Forum_MessageAdded, objectId, -1, excludeUsers);
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex);
//Log.WriteError(ex.ToString());
}
}
// Process Default files
else
{
BaseIbnContainer destContainer = BaseIbnContainer.Create("FileLibrary", string.Format("IncidentId_{0}", objectId));
ForumStorage forumStorage = (ForumStorage)destContainer.LoadControl("ForumStorage");
ForumThreadNodeInfo info = forumStorage.CreateForumThreadNode(string.Empty, Security.CurrentUser.UserID, (int)ForumStorage.NodeContentType.TextWithFiles);
BaseIbnContainer forumContainer = BaseIbnContainer.Create("FileLibrary", string.Format("ForumNodeId_{0}", info.Id));
FileStorage fs = (FileStorage)forumContainer.LoadControl("FileStorage");
fs.SaveFile(fileName, PublishedFile.PostedFile.InputStream);
ForumThreadNodeSettingCollection settings1 = new ForumThreadNodeSettingCollection(info.Id);
settings1.Add(ForumThreadNodeSetting.Internal, "1");
}
}
// End New Folder System Addon [12/27/2005]
// Security Addon [3/2/2004]
HttpContext.Current.Items.Remove(sUserLight);
HttpContext.Current.Items.Add(sUserLight, retUser);
// End Security Addon [3/2/2004]
}
catch (Exception ex)
{
throw new HttpException(405, "Internal Exception", ex);
}
if (!withResponse)
{
this.Response.Write("Published Completed");
}
this.Response.End();
}
}
public static void SetWorkaroundStatus(int ThreadNodeId)
{
ForumThreadNodeSettingCollection settings = new ForumThreadNodeSettingCollection(ThreadNodeId);
settings.Add(ForumThreadNodeSetting.Workaround, "1");
}
public static void SetResolutionStatus(int ThreadNodeId)
{
ForumThreadNodeSettingCollection settings = new ForumThreadNodeSettingCollection(ThreadNodeId);
settings.Add(ForumThreadNodeSetting.Resolution, "1");
}
public static void UpdateQuickTracking(int IssueId, string Message, int ResponsibleId, bool IsResponsibleGroup, DataTable ResponsibleGroup)
{
using (DbTransaction tran = DbTransaction.Begin())
{
int NodeId = -1;
if (Message != null && Message.Trim().Length > 0)
{
BaseIbnContainer destContainer = BaseIbnContainer.Create("FileLibrary", string.Format("IncidentId_{0}", IssueId));
ForumStorage forumStorage = (ForumStorage)destContainer.LoadControl("ForumStorage");
ForumThreadNodeInfo info = forumStorage.CreateForumThreadNode(Message, Security.UserID, 1);
ForumThreadNodeSettingCollection settings1 = new ForumThreadNodeSettingCollection(info.Id);
settings1.Add(ForumThreadNodeSetting.Internal, "1");
NodeId = info.Id;
SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Updated_Forum_MessageAdded, IssueId);
}
UpdateTrackingState(IssueId, NodeId, ResponsibleId, IsResponsibleGroup, ResponsibleGroup);
tran.Commit();
}
}
/// <summary>
/// Updates the quick tracking.
/// </summary>
/// <param name="issueId">The issue id.</param>
/// <param name="message">The message.</param>
/// <param name="stateId">The state id.</param>
/// <param name="priorityId">The priority id.</param>
/// <param name="issueBoxId">The issue box id.</param>
/// <param name="projectId">The project id.</param>
/// <param name="responsibleId">The responsible id.</param>
/// <param name="isResponsibleGroup">if set to <c>true</c> [is responsible group].</param>
/// <param name="responsibleGroup">The responsible group.</param>
/// <param name="decline">if set to <c>true</c> [decline].</param>
/// <param name="useNewResponsible">if set to <c>true</c> [use new responsible from Issue Box].</param>
public static void UpdateQuickTracking(int issueId, string message, int stateId, int priorityId, int? issueBoxId, int? projectId, int responsibleId, bool isResponsibleGroup, DataTable responsibleGroup, bool decline, bool useNewResponsible)
{
using (DbTransaction tran = DbTransaction.Begin())
{
int nodeId = -1;
if (message != null && message.Trim().Length > 0)
{
BaseIbnContainer destContainer = BaseIbnContainer.Create("FileLibrary", string.Format("IncidentId_{0}", issueId));
ForumStorage forumStorage = (ForumStorage)destContainer.LoadControl("ForumStorage");
ForumThreadNodeInfo info = forumStorage.CreateForumThreadNode(message, Security.UserID, 1);
ForumThreadNodeSettingCollection settings1 = new ForumThreadNodeSettingCollection(info.Id);
settings1.Add(ForumThreadNodeSetting.Internal, "1");
nodeId = info.Id;
SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Updated_Forum_MessageAdded, issueId);
}
if (issueBoxId.HasValue && projectId.HasValue && Incident.CanChangeProject(issueId))
{
UpdateProject(issueId, projectId.Value, false);
UpdateIncidentBox(issueId, issueBoxId.Value, false);
if (useNewResponsible)
{
decline = false;
responsibleGroup.Rows.Clear();
IncidentBox box = IncidentBox.Load(issueBoxId.Value);
ResponsibleAssignType responsibleAssignType = box.Document.GeneralBlock.ResponsibleAssignType;
if (responsibleAssignType == ResponsibleAssignType.Manual)
{
responsibleId = -1;
isResponsibleGroup = false;
}
else if (responsibleAssignType == ResponsibleAssignType.CustomUser)
{
responsibleId = box.Document.GeneralBlock.Responsible;
isResponsibleGroup = false;
}
else // Pool
{
responsibleId = -1;
isResponsibleGroup = true;
List<int> responsibleUsers = new List<int>();
foreach (int principalId in box.Document.GeneralBlock.ResponsiblePool)
{
if (User.IsGroup(principalId))
{
using (IDataReader reader = DBGroup.GetListUsersInGroup(principalId))
{
while (reader.Read())
{
if (!responsibleUsers.Contains((int)reader["UserId"]) && (int)reader["Activity"] == 3)
responsibleUsers.Add((int)reader["UserId"]);
}
}
}
else
{
if (!responsibleUsers.Contains(principalId) && User.GetUserActivity(principalId) == User.UserActivity.Active)
responsibleUsers.Add(principalId);
}
}
// responsibleGroup
foreach (int principalId in responsibleUsers)
{
DataRow row = responsibleGroup.NewRow();
row["PrincipalId"] = principalId;
row["IsNew"] = true;
row["ResponsePending"] = true;
responsibleGroup.Rows.Add(row);
}
}
}
}
UpdateTrackingState(issueId, nodeId, stateId, priorityId, responsibleId, isResponsibleGroup, responsibleGroup, decline);
tran.Commit();
}
}
public static void AddForumMessage2(int issueId, string messText,
int nodeType, ArrayList nodeAttribute, bool toSend, int stateId,
string FileName1, System.IO.Stream inputStream1,
string FileName2, System.IO.Stream inputStream2,
string FileName3, System.IO.Stream inputStream3)
{
int oldState;
using(IDataReader reader = Incident.GetIncident(issueId, false))
{
reader.Read();
oldState = (int)reader["StateId"];
}
using(DbTransaction tran = DbTransaction.Begin())
{
ForumThreadNodeInfo info = null;
if (messText.Trim() != String.Empty || FileName1 != String.Empty || FileName2 != String.Empty || FileName3 != String.Empty)
{
BaseIbnContainer destContainer = BaseIbnContainer.Create("FileLibrary", string.Format("IncidentId_{0}", issueId));
ForumStorage forumStorage = (ForumStorage)destContainer.LoadControl("ForumStorage");
info = forumStorage.CreateForumThreadNode(messText, Security.CurrentUser.UserID, nodeType);
if (FileName1 != String.Empty && inputStream1 != null)
{
BaseIbnContainer forumContainer = BaseIbnContainer.Create("FileLibrary", string.Format("ForumNodeId_{0}", info.Id));
FileStorage fs = (FileStorage)forumContainer.LoadControl("FileStorage");
fs.SaveFile(FileName1, inputStream1);
}
if (FileName2 != String.Empty && inputStream2 != null)
{
BaseIbnContainer forumContainer = BaseIbnContainer.Create("FileLibrary", string.Format("ForumNodeId_{0}", info.Id));
FileStorage fs = (FileStorage)forumContainer.LoadControl("FileStorage");
fs.SaveFile(FileName2, inputStream2);
}
if (FileName3 != String.Empty && inputStream3 != null)
{
BaseIbnContainer forumContainer = BaseIbnContainer.Create("FileLibrary", string.Format("ForumNodeId_{0}", info.Id));
FileStorage fs = (FileStorage)forumContainer.LoadControl("FileStorage");
fs.SaveFile(FileName3, inputStream3);
}
ForumThreadNodeSettingCollection settings = new ForumThreadNodeSettingCollection(info.Id);
//if(toSend)
//{
// settings.Add(ForumThreadNodeSetting.Outgoing, "1");
// //EMailRouterOutputMessage.SendOutgoing(issueId, info.Id);
//}
//else
settings.Add(ForumThreadNodeSetting.Internal, "1");
foreach(string sAttr in nodeAttribute)
settings.Add(sAttr, "1");
SystemEvents.AddSystemEvents(SystemEventTypes.Issue_Updated_Forum_MessageAdded, issueId);
}
if(stateId > 0 && stateId != oldState)
UpdateStateAndNotifyController(issueId, stateId, info.Id);
tran.Commit();
}
}
/// <summary>
/// Adds the internal E mail2 incident.
/// </summary>
/// <param name="IncidentId">The incident id.</param>
/// <param name="EMailMessageId">The E mail message id.</param>
/// <param name="SenderName">Name of the sender.</param>
/// <param name="SenderEmail">The sender email.</param>
/// <returns></returns>
private static int AddInternalEMail2Incident(int IncidentId, int EMailMessageId, string SenderName, string SenderEmail)
{
ForumThreadNodeInfo info = null;
using (DbTransaction tran = DbTransaction.Begin())
{
BaseIbnContainer FOcontainer = BaseIbnContainer.Create("FileLibrary", string.Format("IncidentId_{0}", IncidentId));
ForumStorage forumStorage = (ForumStorage)FOcontainer.LoadControl("ForumStorage");
int SenderUserID = Security.UserID;
EMailMessageInfo mi = EMailMessageInfo.Load(EMailMessageId);
info = forumStorage.CreateForumThreadNode(EMailMessageInfo.ExtractTextFromHtml(mi.HtmlBody),
DateTime.UtcNow,
Security.UserID,
EMailMessageId,
(int)ForumStorage.NodeContentType.EMail);
ForumThreadNodeSettingCollection settings = new ForumThreadNodeSettingCollection(info.Id);
settings.Add(ForumThreadNodeSetting.Outgoing, "1");
if (HttpContext.Current != null && HttpContext.Current.Items.Contains(ForumThreadNodeSetting.AllRecipients))
settings.Add(ForumThreadNodeSetting.AllRecipients, HttpContext.Current.Items[ForumThreadNodeSetting.AllRecipients].ToString());
tran.Commit();
}
return info.Id;
}
/// <summary>
/// Adds the external E mail to incident.
/// </summary>
/// <param name="IncidentId">The incident id.</param>
/// <param name="EMailMessageId">The E mail message id.</param>
/// <param name="message">The message.</param>
private static int AddExternalEMail2Incident(int IncidentId, int EMailMessageId, string SenderName, string SenderEmail)
{
ForumThreadNodeInfo info = null;
using (DbTransaction tran = DbTransaction.Begin())
{
BaseIbnContainer FOcontainer = BaseIbnContainer.Create("FileLibrary", string.Format("IncidentId_{0}", IncidentId));
ForumStorage forumStorage = (ForumStorage)FOcontainer.LoadControl("ForumStorage");
EMailMessageInfo mi = EMailMessageInfo.Load(EMailMessageId);
info = forumStorage.CreateForumThreadNode(EMailMessageInfo.ExtractTextFromHtml(mi.HtmlBody),
DateTime.UtcNow,
Security.UserID,
EMailMessageId,
(int)ForumStorage.NodeContentType.EMail);
// 2006-12-12 OZ: Register EMail External Recepient
if (!EMailIssueExternalRecipient.Contains(IncidentId, SenderEmail))
EMailIssueExternalRecipient.Create(IncidentId, SenderEmail);
ForumThreadNodeSettingCollection settings = new ForumThreadNodeSettingCollection(info.Id);
settings.Add(ForumThreadNodeSetting.Incoming, "1");
if (HttpContext.Current != null && HttpContext.Current.Items.Contains(ForumThreadNodeSetting.AllRecipients))
settings.Add(ForumThreadNodeSetting.AllRecipients, HttpContext.Current.Items[ForumThreadNodeSetting.AllRecipients].ToString());
// O.R. [2008-09-19]: Recalculate Expected Dates
DBIncident.RecalculateExpectedResponseDate(IncidentId);
DBIncident.RecalculateExpectedAssignDate(IncidentId);
tran.Commit();
}
return info.Id;
}