This is the modified EditTask.aspx.cs that sends an Email upon closure
//
// ADefwebserver.com
// Copyright (c) 2009
// by Michael Washington
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions
// of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
// DEALINGS IN THE SOFTWARE.
//
//
using System;
using System.Linq;
using System.Web;
using System.Web.UI.WebControls;
using System.Collections.Generic;
using System.Collections;
using System.Drawing;
using Microsoft.VisualBasic;
using System.Text;
using System.IO;
namespace ADefWebserver.Modules.ADefHelpDesk
{
public partial class EditTask : ModuleBase
{
protected void Page_Load(object sender, EventArgs e)
{
// Register JQuery Calendar JavaScript
JQueryCalendarJavaScript1.Text = Utility.InsertCalendarJavaScript(txtDueDate.ClientID);
JQueryCalendarJavaScript2.Text = Utility.InsertCalendarJavaScript(txtStart.ClientID);
JQueryCalendarJavaScript3.Text = Utility.InsertCalendarJavaScript(txtComplete.ClientID);
if (!Page.IsPostBack)
{
if (Request.QueryString["TaskID"] != null)
{
CommentsControl.ViewOnly = true;
if (CheckSecurity())
{
ShowAdministratorLink();
ShowExistingTicketsLink();
LoadRolesDropDown();
DisplayCategoryTree();
DisplayTicketData();
CommentsControl.TaskID = Convert.ToInt32(lblTask.Text);
WorkControl.TaskID = Convert.ToInt32(lblTask.Text);
LogsControl.TaskID = Convert.ToInt32(lblTask.Text);
// If at this point CommentsControl is in View Only mode
// Set main form in View Only mode
if (CommentsControl.ViewOnly == true)
{
SetViewOnlyMode();
}
// Insert Log
Log.InsertLog(Convert.ToInt32(lblTask.Text), UserId, String.Format("{0} viewed ticket.", (UserId == -1) ? "Requester" : UserController.GetUser(PortalId, UserId, false).DisplayName));
}
else
{
pnlEditTask.Visible = false;
Response.Redirect("Default.aspx"); ;
}
}
else
{
pnlEditTask.Visible = false;
Response.Redirect("Default.aspx");
}
}
}
#region SetViewOnlyMode
private void SetViewOnlyMode()
{
btnSave.Visible = false;
btnComments.Visible = false;
btnWorkItems.Visible = false;
btnLogs.Visible = false;
ddlAssigned.Enabled = false;
ddlStatus.Enabled = false;
ddlPriority.Enabled = false;
}
#endregion
#region LoadRolesDropDown
private void LoadRolesDropDown()
{
RoleController objRoleController = new RoleController();
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
List<ADefHelpDesk_Role> colADefHelpDesk_Roles = (from ADefHelpDesk_Roles in objdnnHelpDeskDALDataContext.ADefHelpDesk_Roles
where ADefHelpDesk_Roles.PortalID == PortalId
select ADefHelpDesk_Roles).ToList();
// Create a ListItemCollection to hold the Roles
ListItemCollection colListItemCollection = new ListItemCollection();
// Add the Roles to the List
foreach (ADefHelpDesk_Role objADefHelpDesk_Role in colADefHelpDesk_Roles)
{
try
{
RoleInfo objRoleInfo = objRoleController.GetRole(PortalId, Convert.ToInt32(objADefHelpDesk_Role.ID));
ListItem RoleListItem = new ListItem();
RoleListItem.Text = objRoleInfo.RoleName;
RoleListItem.Value = objADefHelpDesk_Role.ID.ToString();
ddlAssigned.Items.Add(RoleListItem);
}
catch
{
// Role no longer exists in Portal
ListItem RoleListItem = new ListItem();
RoleListItem.Text = GetLocalResourceObject("DeletedRole.Text").ToString();
RoleListItem.Value = objADefHelpDesk_Role.ID.ToString();
ddlAssigned.Items.Add(RoleListItem);
}
}
// Add UnAssigned
ListItem UnassignedRoleListItem = new ListItem();
UnassignedRoleListItem.Text = GetLocalResourceObject("Unassigned.Text").ToString();
UnassignedRoleListItem.Value = "-1";
ddlAssigned.Items.Add(UnassignedRoleListItem);
}
#endregion
#region CheckSecurity
private bool CheckSecurity()
{
bool boolPassedSecurity = false;
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
ADefHelpDesk_Task objADefHelpDesk_Tasks = (from ADefHelpDesk_Tasks in objdnnHelpDeskDALDataContext.ADefHelpDesk_Tasks
where ADefHelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select ADefHelpDesk_Tasks).FirstOrDefault();
if (objADefHelpDesk_Tasks == null)
{
pnlEditTask.Visible = false;
Response.Redirect(string.Format("{0}/Default.aspx", HttpContext.Current.Request.Url.DnsSafeHost));
}
// User not logged in
if (UserId == -1)
{
// Must have the valid password
if (Request.QueryString["TP"] != null)
{
// Check the password for this Ticket
if (objADefHelpDesk_Tasks.TicketPassword == Convert.ToString(Request.QueryString["TP"]))
{
boolPassedSecurity = true;
}
else
{
boolPassedSecurity = false;
}
}
}
// User is logged in
if (UserId > -1)
{
// Is user an Admin?
string strAdminRoleID = GetAdminRole();
if (UserInfo.IsInRole(UserId, strAdminRoleID) || UserInfo.IsSuperUser(UserId))
{
boolPassedSecurity = true;
CommentsControl.ViewOnly = false;
}
// Is user the Requestor?
if (UserId == objADefHelpDesk_Tasks.RequesterUserID)
{
boolPassedSecurity = true;
}
//Is user in the Assigned Role?
RoleController objRoleController = new RoleController();
RoleInfo objRoleInfo = objRoleController.GetRole(PortalId, objADefHelpDesk_Tasks.AssignedRoleID);
if (objRoleInfo != null)
{
if (UserInfo.IsInRole(UserId, objRoleInfo.RoleName))
{
boolPassedSecurity = true;
CommentsControl.ViewOnly = false;
}
}
// Does user have a valid temporary password?
if (Request.QueryString["TP"] != null)
{
// Check the password for this Ticket
if (objADefHelpDesk_Tasks.TicketPassword == Convert.ToString(Request.QueryString["TP"]))
{
boolPassedSecurity = true;
}
else
{
boolPassedSecurity = false;
}
}
}
return boolPassedSecurity;
}
#endregion
#region lnkAdministratorSettings_Click
protected void lnkAdministratorSettings_Click(object sender, EventArgs e)
{
Response.Redirect("Administration.aspx");
}
#endregion
#region lnkNewTicket_Click
protected void lnkNewTicket_Click(object sender, EventArgs e)
{
Response.Redirect("Default.aspx?Ticket=new");
}
#endregion
#region lnkExistingTickets_Click
protected void lnkExistingTickets_Click(object sender, EventArgs e)
{
Response.Redirect("Default.aspx");
}
#endregion
#region ShowExistingTicketsLink
private void ShowExistingTicketsLink()
{
// Show Existing Tickets link if user is logged in
if (UserId > -1)
{
lnkExistingTickets.Visible = true;
imgExitingTickets.Visible = true;
}
else
{
lnkExistingTickets.Visible = false;
imgExitingTickets.Visible = false;
}
}
#endregion
#region ShowAdministratorLink
private void ShowAdministratorLink()
{
// Get Admin Role
string strAdminRoleID = GetAdminRole();
// Show Admin link if user is an Administrator
if (UserInfo.IsInRole(UserId, strAdminRoleID) || UserInfo.IsSuperUser(UserId))
{
lnkAdministratorSettings.Visible = true;
imgAdministrator.Visible = true;
}
else
{
lnkAdministratorSettings.Visible = false;
imgAdministrator.Visible = false;
}
}
#endregion
#region GetAdminRole
private string GetAdminRole()
{
List<ADefHelpDesk_Setting> objADefHelpDesk_Settings = GetSettings();
ADefHelpDesk_Setting objADefHelpDesk_Setting = objADefHelpDesk_Settings.Where(x => x.SettingName == "AdminRole").FirstOrDefault();
string strAdminRoleID = "Administrators";
if (objADefHelpDesk_Setting != null)
{
strAdminRoleID = objADefHelpDesk_Setting.SettingValue;
}
return strAdminRoleID;
}
#endregion
#region GetSettings
private List<ADefHelpDesk_Setting> GetSettings()
{
// Get Settings
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
List<ADefHelpDesk_Setting> colADefHelpDesk_Setting = (from ADefHelpDesk_Settings in objdnnHelpDeskDALDataContext.ADefHelpDesk_Settings
where ADefHelpDesk_Settings.PortalID == PortalId
select ADefHelpDesk_Settings).ToList();
if (colADefHelpDesk_Setting.Count == 0)
{
// Create Default vaules
ADefHelpDesk_Setting objADefHelpDesk_Setting1 = new ADefHelpDesk_Setting();
objADefHelpDesk_Setting1.PortalID = PortalId;
objADefHelpDesk_Setting1.SettingName = "AdminRole";
objADefHelpDesk_Setting1.SettingValue = "Administrators";
objdnnHelpDeskDALDataContext.ADefHelpDesk_Settings.InsertOnSubmit(objADefHelpDesk_Setting1);
objdnnHelpDeskDALDataContext.SubmitChanges();
ADefHelpDesk_Setting objADefHelpDesk_Setting2 = new ADefHelpDesk_Setting();
objADefHelpDesk_Setting2.PortalID = PortalId;
objADefHelpDesk_Setting2.SettingName = "FileUploadPath";
objADefHelpDesk_Setting2.SettingValue = Server.MapPath("~/DesktopModules/ADefHelpDesk/Upload");
objdnnHelpDeskDALDataContext.ADefHelpDesk_Settings.InsertOnSubmit(objADefHelpDesk_Setting2);
objdnnHelpDeskDALDataContext.SubmitChanges();
colADefHelpDesk_Setting = (from ADefHelpDesk_Settings in objdnnHelpDeskDALDataContext.ADefHelpDesk_Settings
where ADefHelpDesk_Settings.PortalID == PortalId
select ADefHelpDesk_Settings).ToList();
}
return colADefHelpDesk_Setting;
}
#endregion
// Tags
#region DisplayCategoryTree
private void DisplayCategoryTree()
{
bool boolUserAssignedToTask = false;
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
ADefHelpDesk_Task objADefHelpDesk_Tasks = (from ADefHelpDesk_Tasks in objdnnHelpDeskDALDataContext.ADefHelpDesk_Tasks
where ADefHelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select ADefHelpDesk_Tasks).FirstOrDefault();
//Is user in the Assigned Role?
RoleController objRoleController = new RoleController();
RoleInfo objRoleInfo = objRoleController.GetRole(PortalId, objADefHelpDesk_Tasks.AssignedRoleID);
if (objRoleInfo != null)
{
if (UserInfo.IsInRole(UserId, objRoleInfo.RoleName))
{
boolUserAssignedToTask = true;
}
}
if (boolUserAssignedToTask || UserInfo.IsInRole(UserId, GetAdminRole()) || UserInfo.IsSuperUser(UserId))
{
// Show all Tags
TagsTreeExistingTasks.Visible = true;
TagsTreeExistingTasks.TagID = Convert.ToInt32(Request.QueryString["TaskID"]);
TagsTreeExistingTasks.DisplayType = "Administrator";
TagsTreeExistingTasks.Expand = false;
}
else
{
// Show only Visible Tags
TagsTreeExistingTasks.Visible = true;
TagsTreeExistingTasks.TagID = Convert.ToInt32(Request.QueryString["TaskID"]);
TagsTreeExistingTasks.DisplayType = "Requestor";
TagsTreeExistingTasks.Expand = false;
}
// Select Existing values
if (objADefHelpDesk_Tasks.ADefHelpDesk_TaskCategories.Select(x => x.CategoryID).ToArray<int>().Count() > 0)
{
int[] ArrStrCategories = objADefHelpDesk_Tasks.ADefHelpDesk_TaskCategories.Select(x => x.CategoryID).ToArray<int>();
int?[] ArrIntCatagories = Array.ConvertAll<int, int?>(ArrStrCategories, new Converter<int, int?>(ConvertToNullableInt));
TagsTreeExistingTasks.SelectedCategories = ArrIntCatagories;
}
// Set visibility of Tags
bool RequestorCatagories = (TagsTreeExistingTasks.DisplayType == "Administrator") ? false : true;
int CountOfCatagories = (from AdefWebserverCategories in CategoriesTable.GetCategoriesTable(PortalId, RequestorCatagories)
where AdefWebserverCategories.PortalID == PortalId
where AdefWebserverCategories.Level == 1
select AdefWebserverCategories).Count();
imgTags.Visible = (CountOfCatagories > 0);
lbltxtTags.Visible = (CountOfCatagories > 0);
}
#endregion
#region ConvertToNullableInt
private int? ConvertToNullableInt(int strParameter)
{
return Convert.ToInt32(strParameter);
}
#endregion
// Display Ticket Data
#region DisplayTicketData
private void DisplayTicketData()
{
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
ADefHelpDesk_Task objADefHelpDesk_Tasks = (from ADefHelpDesk_Tasks in objdnnHelpDeskDALDataContext.ADefHelpDesk_Tasks
where ADefHelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select ADefHelpDesk_Tasks).FirstOrDefault();
// Name is editable only if user is Anonymous
if (objADefHelpDesk_Tasks.RequesterUserID == -1)
{
txtEmail.Visible = true;
txtName.Visible = true;
lblEmail.Visible = false;
lblName.Visible = false;
txtEmail.Text = objADefHelpDesk_Tasks.RequesterEmail;
txtName.Text = objADefHelpDesk_Tasks.RequesterName;
}
else
{
txtEmail.Visible = false;
txtName.Visible = false;
lblEmail.Visible = true;
lblName.Visible = true;
UserInfo objRequester = UserController.GetUser(PortalId, objADefHelpDesk_Tasks.RequesterUserID, false);
if (objRequester != null)
{
lblEmail.Text = UserController.GetUser(PortalId, objADefHelpDesk_Tasks.RequesterUserID, false).Email;
lblName.Text = UserController.GetUser(PortalId, objADefHelpDesk_Tasks.RequesterUserID, false).DisplayName;
}
else
{
lblName.Text = "[User Deleted]";
}
}
lblTask.Text = objADefHelpDesk_Tasks.TaskID.ToString();
lblCreated.Text = String.Format(GetLocalResourceObject("Created.Text").ToString(), objADefHelpDesk_Tasks.CreatedDate.ToShortDateString(), objADefHelpDesk_Tasks.CreatedDate.ToShortTimeString());
ddlStatus.SelectedValue = objADefHelpDesk_Tasks.Status;
ddlPriority.SelectedValue = objADefHelpDesk_Tasks.Priority;
txtDescription.Text = objADefHelpDesk_Tasks.Description;
txtPhone.Text = objADefHelpDesk_Tasks.RequesterPhone;
txtDueDate.Text = (objADefHelpDesk_Tasks.DueDate.HasValue) ? objADefHelpDesk_Tasks.DueDate.Value.ToShortDateString() : "";
txtStart.Text = (objADefHelpDesk_Tasks.EstimatedStart.HasValue) ? objADefHelpDesk_Tasks.EstimatedStart.Value.ToShortDateString() : "";
txtComplete.Text = (objADefHelpDesk_Tasks.EstimatedCompletion.HasValue) ? objADefHelpDesk_Tasks.EstimatedCompletion.Value.ToShortDateString() : "";
txtEstimate.Text = (objADefHelpDesk_Tasks.EstimatedHours.HasValue) ? objADefHelpDesk_Tasks.EstimatedHours.Value.ToString() : "";
ListItem TmpRoleListItem = ddlAssigned.Items.FindByValue(objADefHelpDesk_Tasks.AssignedRoleID.ToString());
if (TmpRoleListItem == null)
{
// Value was not found so add it
RoleController objRoleController = new RoleController();
RoleInfo objRoleInfo = objRoleController.GetRole(PortalId, objADefHelpDesk_Tasks.AssignedRoleID);
if (objRoleInfo != null)
{
ListItem RoleListItem = new ListItem();
RoleListItem.Text = objRoleInfo.RoleName;
RoleListItem.Value = objADefHelpDesk_Tasks.AssignedRoleID.ToString();
ddlAssigned.Items.Add(RoleListItem);
ddlAssigned.SelectedValue = objADefHelpDesk_Tasks.AssignedRoleID.ToString();
}
else
{
// Role no longer exists in Portal
ddlAssigned.SelectedValue = "-1";
}
}
else
{
// The Value already exists so set it
ddlAssigned.SelectedValue = objADefHelpDesk_Tasks.AssignedRoleID.ToString();
}
}
#endregion
// Save Form Data
#region btnSave_Click
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateTicketForm())
{
int intTaskID = SaveTicketForm();
SaveTags(intTaskID);
ShowUpdated();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}
#endregion
#region ValidateTicketForm
private bool ValidateTicketForm()
{
List<string> ColErrors = new List<string>();
// Only validate Name and email if Ticket is not for a DNN user
// lblName will be hidden if it is not a DNN user
if (lblName.Visible == false)
{
if (txtName.Text.Trim().Length < 1)
{
ColErrors.Add(GetLocalResourceObject("NameIsRequired.Text").ToString());
}
if (txtEmail.Text.Trim().Length < 1)
{
ColErrors.Add(GetLocalResourceObject("EmailIsRequired.Text").ToString());
}
}
// Validate the date only if a date was entered
if (txtDueDate.Text.Trim().Length > 1)
{
try
{
DateTime tmpDate = Convert.ToDateTime(txtDueDate.Text.Trim());
}
catch
{
ColErrors.Add(GetLocalResourceObject("MustUseAValidDate.Text").ToString());
}
}
if (txtStart.Text.Trim().Length > 1)
{
try
{
DateTime tmpDate = Convert.ToDateTime(txtStart.Text.Trim());
}
catch
{
ColErrors.Add(GetLocalResourceObject("MustUseAValidDate.Text").ToString());
}
}
if (txtComplete.Text.Trim().Length > 1)
{
try
{
DateTime tmpDate = Convert.ToDateTime(txtComplete.Text.Trim());
}
catch
{
ColErrors.Add(GetLocalResourceObject("MustUseAValidDate.Text").ToString());
}
}
if (txtEstimate.Text.Trim().Length > 0)
{
try
{
int tmpInt = Convert.ToInt32(txtEstimate.Text.Trim());
}
catch
{
ColErrors.Add(GetLocalResourceObject("MustUseAValidEstimateHours.Text").ToString());
}
}
// Display Validation Errors
if (ColErrors.Count > 0)
{
foreach (string objError in ColErrors)
{
lblError.Text = lblError.Text + String.Format("* {0}<br />", objError);
}
}
return (ColErrors.Count == 0);
}
#endregion
//*****************************************
#region SaveTicketForm
private int SaveTicketForm()
{
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
ADefHelpDesk_Task objADefHelpDesk_Task = (from ADefHelpDesk_Tasks in objdnnHelpDeskDALDataContext.ADefHelpDesk_Tasks
where ADefHelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select ADefHelpDesk_Tasks).FirstOrDefault();
// Save original Assigned Group
int intOriginalAssignedGroup = objADefHelpDesk_Task.AssignedRoleID;
//*****************************************
String strOrigTaskStatus = objADefHelpDesk_Task.Status;
//*****************************************
// Save Task
objADefHelpDesk_Task.Status = ddlStatus.SelectedValue;
objADefHelpDesk_Task.Description = txtDescription.Text;
objADefHelpDesk_Task.PortalID = PortalId;
objADefHelpDesk_Task.Priority = ddlPriority.SelectedValue;
objADefHelpDesk_Task.RequesterPhone = txtPhone.Text;
objADefHelpDesk_Task.AssignedRoleID = Convert.ToInt32(ddlAssigned.SelectedValue);
// Only validate Name and email if Ticket is not for a DNN user
// lblName will be hidden if it is not a DNN user
if (lblName.Visible == false)
{
// not a DNN user
objADefHelpDesk_Task.RequesterEmail = txtEmail.Text;
objADefHelpDesk_Task.RequesterName = txtName.Text;
objADefHelpDesk_Task.RequesterUserID = -1;
}
// DueDate
if (txtDueDate.Text.Trim().Length > 1)
{
objADefHelpDesk_Task.DueDate = Convert.ToDateTime(txtDueDate.Text.Trim());
}
else
{
objADefHelpDesk_Task.DueDate = null;
}
// EstimatedStart
if (txtStart.Text.Trim().Length > 1)
{
objADefHelpDesk_Task.EstimatedStart = Convert.ToDateTime(txtStart.Text.Trim());
}
else
{
objADefHelpDesk_Task.EstimatedStart = null;
}
// EstimatedCompletion
if (txtComplete.Text.Trim().Length > 1)
{
objADefHelpDesk_Task.EstimatedCompletion = Convert.ToDateTime(txtComplete.Text.Trim());
}
else
{
objADefHelpDesk_Task.EstimatedCompletion = null;
}
// EstimatedHours
if (txtEstimate.Text.Trim().Length > 0)
{
objADefHelpDesk_Task.EstimatedHours = Convert.ToInt32(txtEstimate.Text.Trim());
}
else
{
objADefHelpDesk_Task.EstimatedHours = null;
}
objdnnHelpDeskDALDataContext.SubmitChanges();
// Notify Assigned Group
if (Convert.ToInt32(ddlAssigned.SelectedValue) > -1)
{
// Only notify if Assigned group has changed
if (intOriginalAssignedGroup != Convert.ToInt32(ddlAssigned.SelectedValue))
{
NotifyAssignedGroupOfAssignment();
}
}
//*****************************************
// Notify on closure
if (ddlStatus.SelectedValue == "Resolved")
{
// Only notify if Assigned group has changed
if (strOrigTaskStatus != ddlStatus.SelectedValue)
{
// Insert Log
Log.InsertLog(objADefHelpDesk_Task.TaskID, UserId, String.Format("Al-{0}", "Send Closure EMail"));
SendClosureEmail(objADefHelpDesk_Task.TaskID.ToString());
}
}
//*****************************************
// Insert Log
Log.InsertLog(objADefHelpDesk_Task.TaskID, UserId, String.Format(GetLocalResourceObject("UpdatedTicket.Text").ToString(), UserController.GetUser(PortalId, UserId, false).DisplayName));
return objADefHelpDesk_Task.TaskID;
}
#endregion
//*****************************************
#region SaveTags
private void SaveTags(int intTaskID)
{
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
var ExistingTaskCategories = from ADefHelpDesk_TaskCategories in objdnnHelpDeskDALDataContext.ADefHelpDesk_TaskCategories
where ADefHelpDesk_TaskCategories.TaskID == intTaskID
select ADefHelpDesk_TaskCategories;
// Delete all existing TaskCategories
if (ExistingTaskCategories != null)
{
objdnnHelpDeskDALDataContext.ADefHelpDesk_TaskCategories.DeleteAllOnSubmit(ExistingTaskCategories);
objdnnHelpDeskDALDataContext.SubmitChanges();
}
// Add TaskCategories
TreeView objTreeView = (TreeView)TagsTreeExistingTasks.FindControl("tvCategories");
if (objTreeView.CheckedNodes.Count > 0)
{
// Iterate through the CheckedNodes collection
foreach (TreeNode node in objTreeView.CheckedNodes)
{
ADefHelpDesk_TaskCategory objADefHelpDesk_TaskCategory = new ADefHelpDesk_TaskCategory();
objADefHelpDesk_TaskCategory.TaskID = intTaskID;
objADefHelpDesk_TaskCategory.CategoryID = Convert.ToInt32(node.Value);
objdnnHelpDeskDALDataContext.ADefHelpDesk_TaskCategories.InsertOnSubmit(objADefHelpDesk_TaskCategory);
objdnnHelpDeskDALDataContext.SubmitChanges();
}
}
}
#endregion
#region ShowUpdated
private void ShowUpdated()
{
lblError.Text = GetLocalResourceObject("Updated.Text").ToString();
// Provide a way for the user to see that a record has been updated
// multiple times by changing the color each time
lblError.ForeColor = (lblError.ForeColor == Color.Red) ? Color.Blue : Color.Red;
}
#endregion
// Details
#region DisableAllButtons
private void DisableAllButtons()
{
btnComments.BorderStyle = BorderStyle.Outset;
btnComments.BackColor = Color.WhiteSmoke;
btnComments.Font.Bold = false;
btnComments.ForeColor = Color.Black;
pnlComments.Visible = false;
btnWorkItems.BorderStyle = BorderStyle.Outset;
btnWorkItems.BackColor = Color.WhiteSmoke;
btnWorkItems.Font.Bold = false;
btnWorkItems.ForeColor = Color.Black;
pnlWorkItems.Visible = false;
btnLogs.BorderStyle = BorderStyle.Outset;
btnLogs.BackColor = Color.WhiteSmoke;
btnLogs.Font.Bold = false;
btnLogs.ForeColor = Color.Black;
pnlLogs.Visible = false;
}
#endregion
// Comments
#region btnComments_Click
protected void btnComments_Click(object sender, EventArgs e)
{
// If we are already on the Comments screen then switch Comments to Default mode
if (pnlComments.Visible == true)
{
CommentsControl.SetView("Default");
}
DisableAllButtons();
btnComments.BorderStyle = BorderStyle.Inset;
btnComments.BackColor = Color.LightGray;
btnComments.Font.Bold = true;
btnComments.ForeColor = Color.Red;
pnlComments.Visible = true;
}
#endregion
// Work Items
#region btnWorkItems_Click
protected void btnWorkItems_Click(object sender, EventArgs e)
{
DisableAllButtons();
btnWorkItems.BorderStyle = BorderStyle.Inset;
btnWorkItems.BackColor = Color.LightGray;
btnWorkItems.Font.Bold = true;
btnWorkItems.ForeColor = Color.Red;
pnlWorkItems.Visible = true;
}
#endregion
// Emails
#region NotifyAssignedGroupOfAssignment
private void NotifyAssignedGroupOfAssignment()
{
RoleController objRoleController = new RoleController();
string strAssignedRole = String.Format("{0}", objRoleController.GetRole(PortalId, Convert.ToInt32(ddlAssigned.SelectedValue)).RoleName);
string strLinkUrl = string.Format("{0}?TaskID={1}", Utility.NavigateURL(this.Context, "TaskEdit.aspx"), Request.QueryString["TaskID"]);
string strSubject = "[" + GetLocalResourceObject(String.Format("ddlStatusAdmin{0}.Text", ddlStatus.SelectedValue)).ToString() + "] " + String.Format(GetLocalResourceObject("HelpDeskTicketAtHasBeenAssigned.Text").ToString(), Request.QueryString["TaskID"], HttpContext.Current.Request.Url.DnsSafeHost, strAssignedRole);
string strBody = String.Format(GetLocalResourceObject("ANewHelpDeskTicketHasBeenAssigned.Text").ToString(), Request.QueryString["TaskID"], txtDescription.Text);
strBody = strBody + Environment.NewLine;
strBody = strBody + String.Format(GetLocalResourceObject("YouMaySeeStatusHere.Text").ToString(), strLinkUrl);
// Get all users in the AssignedRole Role
List<UserInfo> colAssignedRoleUsers = objRoleController.GetUsersByRoleName(PortalId, strAssignedRole);
foreach (UserInfo objUserInfo in colAssignedRoleUsers)
{
Email.SendMail(objUserInfo.Email, "", "", "", strSubject, strBody);
}
Log.InsertLog(Convert.ToInt32(Request.QueryString["TaskID"]), UserId, String.Format(GetLocalResourceObject("AssignedTicketTo.Text").ToString(), UserController.GetUser(PortalId, Convert.ToInt32(UserId), false).DisplayName, strAssignedRole));
}
#endregion
//*****************************************
#region SendClosureEmail
//*****************************************
private void SendClosureEmail(string TaskID)
{
dnnHelpDeskDALDataContext objdnnHelpDeskDALDataContext = new dnnHelpDeskDALDataContext();
ADefHelpDesk_Task objADefHelpDesk_Tasks = (from ADefHelpDesk_Tasks in objdnnHelpDeskDALDataContext.ADefHelpDesk_Tasks
where ADefHelpDesk_Tasks.TaskID == Convert.ToInt32(TaskID)
select ADefHelpDesk_Tasks).FirstOrDefault();
string strPasswordLinkUrl = String.Format(@"{0}?TaskID={1}&TP={2}", Utility.NavigateURL(this.Context, "TaskEdit.aspx"), TaskID, objADefHelpDesk_Tasks.TicketPassword);
string strLinkUrl = String.Format(@"{0}?TaskID={1}", Utility.NavigateURL(this.Context, "TaskEdit.aspx"), TaskID);
string strSubject = String.Format("Help desk ticket #{0} has been resolved.", TaskID);
string strBody = "";
strBody = strBody + Environment.NewLine;
strBody = strBody + String.Format("You may see the resolution here: {0}", strPasswordLinkUrl);
string strEmail = txtEmail.Text;
Email.SendMail(strEmail, "", "", "", strSubject, strBody);
}
#endregion
//*****************************************
// Logs
#region btnLogs_Click
protected void btnLogs_Click(object sender, EventArgs e)
{
DisableAllButtons();
btnLogs.BorderStyle = BorderStyle.Inset;
btnLogs.BackColor = Color.LightGray;
btnLogs.Font.Bold = true;
btnLogs.ForeColor = Color.Red;
pnlLogs.Visible = true;
LogsControl.RefreshLogs();
}
#endregion
}
}