private string GetNodePath(int intCategoryID)
{
string strNodePath = intCategoryID.ToString();
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.CategoryID == intCategoryID
select HelpDesk_Categories).FirstOrDefault();
// Only build a node path if the current level is not the root
if (result.Level > 1)
{
int intCurrentCategoryID = result.CategoryID;
for (int i = 1; i < result.Level; i++)
{
var CurrentCategory = (from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.CategoryID == intCurrentCategoryID
select HelpDesk_Categories).FirstOrDefault();
strNodePath = CurrentCategory.ParentCategoryID.ToString() + @"/" + strNodePath;
var ParentCategory = (from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.CategoryID == CurrentCategory.ParentCategoryID
select HelpDesk_Categories).FirstOrDefault();
intCurrentCategoryID = ParentCategory.CategoryID;
}
}
return(strNodePath);
}
private void UpdateLevelOfChildren(HelpDesk_Category result)
{
int?intStartingLevel = result.Level;
if (colProcessedCategoryIDs == null)
{
colProcessedCategoryIDs = new List <int>();
}
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
// Get the children of the current item
// This method may be called from the top level or recuresively by one of the child items
var CategoryChildren = from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.ParentCategoryID == result.CategoryID
where !colProcessedCategoryIDs.Contains(result.CategoryID)
select HelpDesk_Categories;
// Loop thru each item
foreach (var objCategory in CategoryChildren)
{
colProcessedCategoryIDs.Add(objCategory.CategoryID);
objCategory.Level = ((intStartingLevel) ?? 0) + 1;
objHelpDeskDALDataContext.SubmitChanges();
//Recursively call the UpdateLevelOfChildren method adding all children
UpdateLevelOfChildren(objCategory);
}
}
// File upload
#region UploadFile
private void UploadFile(int intDetailID)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
string strUploFilesPath = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
where HelpDesk_Settings.SettingName == "UploFilesPath"
select HelpDesk_Settings).FirstOrDefault().SettingValue;
EnsureDirectory(new System.IO.DirectoryInfo(strUploFilesPath));
string strfilename = Convert.ToString(intDetailID) + "_" + GetRandomPassword() + Path.GetExtension(TicketFileUpload.FileName).ToLower();
strUploFilesPath = strUploFilesPath + @"\" + strfilename;
TicketFileUpload.SaveAs(strUploFilesPath);
HelpDesk_Attachment objHelpDesk_Attachment = new HelpDesk_Attachment();
objHelpDesk_Attachment.DetailID = intDetailID;
objHelpDesk_Attachment.FileName = strfilename;
objHelpDesk_Attachment.OriginalFileName = TicketFileUpload.FileName;
objHelpDesk_Attachment.AttachmentPath = strUploFilesPath;
objHelpDesk_Attachment.UserID = UserId;
objHelpDeskDALDataContext.HelpDesk_Attachments.InsertOnSubmit(objHelpDesk_Attachment);
objHelpDeskDALDataContext.SubmitChanges();
}
protected void btnInsertRole_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
// See if Role already exists
HelpDesk_Role colHelpDesk_Roles = (from HelpDesk_Roles in objHelpDeskDALDataContext.HelpDesk_Roles
where HelpDesk_Roles.PortalID == PortalId
where HelpDesk_Roles.RoleID == Convert.ToInt32(ddlRole.SelectedValue)
select HelpDesk_Roles).FirstOrDefault();
if (colHelpDesk_Roles != null)
{
RoleController objRoleController = new RoleController();
lblRoleError.Text = String.Format(Localization.GetString("RoleAlreadyAdded.Text", LocalResourceFile), objRoleController.GetRole(Convert.ToInt32(ddlRole.SelectedValue), PortalId).RoleName);
}
else
{
HelpDesk_Role objHelpDesk_Role = new HelpDesk_Role();
objHelpDesk_Role.PortalID = PortalId;
objHelpDesk_Role.RoleID = Convert.ToInt32(ddlRole.SelectedValue);
objHelpDeskDALDataContext.HelpDesk_Roles.InsertOnSubmit(objHelpDesk_Role);
objHelpDeskDALDataContext.SubmitChanges();
lvRoles.DataBind();
}
}
private string GetParentCategoryID(string strParentCategoryID)
{
// This is to ensure that the ParentCategoryID does exist and has not been deleted since the last time the form was loaded
int ParentCategoryID = 0;
if (strParentCategoryID != "0")
{
ParentCategoryID = Convert.ToInt32(strParentCategoryID);
}
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.CategoryID == ParentCategoryID
select HelpDesk_Categories).FirstOrDefault();
string strResultParentCategoryID = "0";
if (result != null)
{
strResultParentCategoryID = result.CategoryID.ToString();
}
return(strResultParentCategoryID);
}
private void SaveTags(int intTaskID)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var ExistingTaskCategories = from HelpDesk_TaskCategories in objHelpDeskDALDataContext.HelpDesk_TaskCategories
where HelpDesk_TaskCategories.TaskID == intTaskID
select HelpDesk_TaskCategories;
// Delete all existing TaskCategories
if (ExistingTaskCategories != null)
{
objHelpDeskDALDataContext.HelpDesk_TaskCategories.DeleteAllOnSubmit(ExistingTaskCategories);
objHelpDeskDALDataContext.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)
{
HelpDesk_TaskCategory objHelpDesk_TaskCategory = new HelpDesk_TaskCategory();
objHelpDesk_TaskCategory.TaskID = intTaskID;
objHelpDesk_TaskCategory.CategoryID = Convert.ToInt32(node.Value);
objHelpDeskDALDataContext.HelpDesk_TaskCategories.InsertOnSubmit(objHelpDesk_TaskCategory);
objHelpDeskDALDataContext.SubmitChanges();
}
}
}
private void UploadFileCommentEdit(int intDetailID)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
string strUploFilesPath = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
where HelpDesk_Settings.SettingName == "UploFilesPath"
select HelpDesk_Settings).FirstOrDefault().SettingValue;
EnsureDirectory(new System.IO.DirectoryInfo(strUploFilesPath));
string strfilename = Convert.ToString(intDetailID) + "_" + GetRandomPassword() + Path.GetExtension(fuAttachment.FileName).ToLower();
strUploFilesPath = strUploFilesPath + @"\" + strfilename;
fuAttachment.SaveAs(strUploFilesPath);
HelpDesk_Attachment objHelpDesk_Attachment = new HelpDesk_Attachment();
objHelpDesk_Attachment.DetailID = intDetailID;
objHelpDesk_Attachment.FileName = strfilename;
objHelpDesk_Attachment.OriginalFileName = fuAttachment.FileName;
objHelpDesk_Attachment.AttachmentPath = strUploFilesPath;
objHelpDesk_Attachment.UserID = UserId;
objHelpDeskDALDataContext.HelpDesk_Attachments.InsertOnSubmit(objHelpDesk_Attachment);
objHelpDeskDALDataContext.SubmitChanges();
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString("UploadedFile.Text.", LocalResourceFile), GetUserName(), fuAttachment.FileName));
}
// Tags
#region DisplayCategoryTree
private void DisplayCategoryTree()
{
bool boolUserAssignedToTask = false;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Task objHelpDesk_Tasks = (from HelpDesk_Tasks in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_Tasks).FirstOrDefault();
//Is user in the Assigned Role?
RoleController objRoleController = new RoleController();
RoleInfo objRoleInfo = objRoleController.GetRole(objHelpDesk_Tasks.AssignedRoleID, PortalId);
if (objRoleInfo != null)
{
if (UserInfo.IsInRole(objRoleInfo.RoleName))
{
boolUserAssignedToTask = true;
}
}
if (boolUserAssignedToTask || UserInfo.IsInRole(GetAdminRole()) || UserInfo.IsInRole("Administrators") || UserInfo.IsSuperUser)
{
// 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 (objHelpDesk_Tasks.HelpDesk_TaskCategories.Select(x => x.CategoryID).ToArray <int>().Count() > 0)
{
int[] ArrStrCategories = objHelpDesk_Tasks.HelpDesk_TaskCategories.Select(x => x.CategoryID).ToArray <int>();
int?[] ArrIntHelpDesk = Array.ConvertAll <int, int?>(ArrStrCategories, new Converter <int, int?>(ConvertToNullableInt));
TagsTreeExistingTasks.SelectedCategories = ArrIntHelpDesk;
}
// Set visibility of Tags
bool RequestorR7_HelpDesk = (TagsTreeExistingTasks.DisplayType == "Administrator") ? false : true;
int CountOfHelpDesk = (from WebserverCategories in CategoriesTable.GetCategoriesTable(PortalId, RequestorR7_HelpDesk)
where WebserverCategories.PortalID == PortalId
where WebserverCategories.Level == 1
select WebserverCategories).Count();
imgTags.Visible = (CountOfHelpDesk > 0);
lbltxtTags.Visible = (CountOfHelpDesk > 0);
}
protected void LDSLogs_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_Logs in objHelpDeskDALDataContext.HelpDesk_Logs
where HelpDesk_Logs.TaskID == TaskID
select HelpDesk_Logs;
e.Result = result;
}
protected void LDSComments_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_TaskDetails
where HelpDesk_TaskDetails.TaskID == TaskID
where (HelpDesk_TaskDetails.DetailType == "Work")
select HelpDesk_TaskDetails;
e.Result = result;
}
private static IQueryable <HelpDesk_Category> GetEntireTable(int PortalID)
{
HelpDeskDALDataContext CategoryAdminDALDataContext = new HelpDeskDALDataContext();
IQueryable <HelpDesk_Category> EntireTable = (from WebserverCategories in CategoryAdminDALDataContext.HelpDesk_Categories
where WebserverCategories.PortalID == PortalID
select WebserverCategories).ToList().AsQueryable();
return(EntireTable);
}
private int?GetLevelOfParent(int?ParentCategoryID)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.CategoryID == ParentCategoryID
select HelpDesk_Categories).FirstOrDefault();
return((result == null) ? 0 : result.Level);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
if (btnUpdate.CommandName == "Update")
{
var result = (from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.CategoryID == Convert.ToInt32(txtCategoryID.Text)
select HelpDesk_Categories).FirstOrDefault();
result.CategoryName = txtCategory.Text.Trim();
result.ParentCategoryID = (GetParentCategoryID(ddlParentCategory.SelectedValue) == "0") ? (int?)null : Convert.ToInt32(ddlParentCategory.SelectedValue);
txtParentCategoryID.Text = (ddlParentCategory.SelectedValue == "0") ? "" : ddlParentCategory.SelectedValue;
result.Level = (ddlParentCategory.SelectedValue == "0") ? 1 : GetLevelOfParent(Convert.ToInt32(ddlParentCategory.SelectedValue)) + 1;
result.RequestorVisible = chkRequesterVisible.Checked;
result.Selectable = chkSelectable.Checked;
objHelpDeskDALDataContext.SubmitChanges();
// Update levels off all the Children
colProcessedCategoryIDs = new List <int>();
UpdateLevelOfChildren(result);
}
else
{
// This is a Save for a new Node
HelpDesk_Category objHelpDesk_Category = new HelpDesk_Category();
objHelpDesk_Category.PortalID = PortalId;
objHelpDesk_Category.CategoryName = txtCategory.Text.Trim();
objHelpDesk_Category.ParentCategoryID = (GetParentCategoryID(ddlParentCategory.SelectedValue) == "0") ? (int?)null : Convert.ToInt32(ddlParentCategory.SelectedValue);
objHelpDesk_Category.Level = (ddlParentCategory.SelectedValue == "0") ? 1 : GetLevelOfParent(Convert.ToInt32(ddlParentCategory.SelectedValue)) + 1;
objHelpDesk_Category.RequestorVisible = chkRequesterVisible.Checked;
objHelpDesk_Category.Selectable = chkSelectable.Checked;
objHelpDeskDALDataContext.HelpDesk_Categories.InsertOnSubmit(objHelpDesk_Category);
objHelpDeskDALDataContext.SubmitChanges();
// Set the Hidden CategoryID
txtParentCategoryID.Text = (objHelpDesk_Category.ParentCategoryID == null) ? "" : ddlParentCategory.SelectedValue;
txtCategoryID.Text = objHelpDesk_Category.CategoryID.ToString();
ResetForm();
}
RefreshCache();
DisplayHelpDesk();
// Set the Parent drop-down
if (txtParentCategoryID.Text != "")
{
ddlParentCategory.SelectedValue = txtParentCategoryID.Text;
}
}
public static void InsertLog(int TaskID, int UserID, string LogDescription)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Log objHelpDesk_Log = new HelpDesk_Log();
objHelpDesk_Log.DateCreated = DateTime.Now;
objHelpDesk_Log.LogDescription = Utils.StringLeft(LogDescription, 499);
objHelpDesk_Log.TaskID = TaskID;
objHelpDesk_Log.UserID = UserID;
objHelpDeskDALDataContext.HelpDesk_Logs.InsertOnSubmit(objHelpDesk_Log);
objHelpDeskDALDataContext.SubmitChanges();
}
private void UpdateComment()
{
try
{
// Try to Make Start and Stop Time
DateTime StartTime = Convert.ToDateTime(String.Format("{0} {1}", txtStartDayEdit.Text, txtStartTimeEdit.Text));
DateTime StopTime = Convert.ToDateTime(String.Format("{0} {1}", txtStopDayEdit.Text, txtStopTimeEdit.Text));
}
catch
{
lblErrorEditComment.Text = Localization.GetString("MustProvideValidStarAndStopTimes.Text", LocalResourceFile);
return;
}
if (txtDescription.Text.Trim().Length > 0)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
string strComment = txtDescription.Text.Trim();
// Save Task Details
var objHelpDesk_TaskDetail = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_TaskDetails
where HelpDesk_TaskDetails.DetailID == Convert.ToInt32(lblDetailID.Text)
select HelpDesk_TaskDetails).FirstOrDefault();
if (objHelpDesk_TaskDetail != null)
{
objHelpDesk_TaskDetail.TaskID = TaskID;
objHelpDesk_TaskDetail.Description = txtDescription.Text.Trim();
objHelpDesk_TaskDetail.UserID = UserId;
objHelpDesk_TaskDetail.DetailType = "Work";
objHelpDesk_TaskDetail.StartTime = Convert.ToDateTime(String.Format("{0} {1}", txtStartDayEdit.Text, txtStartTimeEdit.Text));
objHelpDesk_TaskDetail.StopTime = Convert.ToDateTime(String.Format("{0} {1}", txtStopDayEdit.Text, txtStopTimeEdit.Text));
objHelpDeskDALDataContext.SubmitChanges();
txtDescription.Text = "";
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString("UpdatedWorkComment.Text", LocalResourceFile), GetUserName()));
SetView("Default");
gvComments.DataBind();
}
}
else
{
lblErrorEditComment.Text = Localization.GetString("MustProvideADescription.Text", LocalResourceFile);
}
}
protected void btnUpdateAdminRole_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Setting objHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
where HelpDesk_Settings.SettingName == "AdminRole"
select HelpDesk_Settings).FirstOrDefault();
objHelpDesk_Setting.SettingValue = ddlAdminRole.SelectedValue;
objHelpDeskDALDataContext.SubmitChanges();
lblAdminRole.Text = Localization.GetString("Updated.Text", LocalResourceFile);
}
// Utility
#region GetAssignedRole
private int GetAssignedRole()
{
int intRole = -1;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails;
if (result != null)
{
intRole = result.FirstOrDefault().AssignedRoleID;
}
return(intRole);
}
private string GetDescriptionOfTicket()
{
string strDescription = "";
int intTaskId = Convert.ToInt32(Request.QueryString["TaskID"]);
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails).FirstOrDefault();
if (result != null)
{
strDescription = result.Description;
}
return(strDescription);
}
private void InsertComment()
{
if (txtComment.Text.Trim().Length > 0)
{
try
{
// Try to Make Start and Stop Time
DateTime StartTime = Convert.ToDateTime(String.Format("{0} {1}", txtStartDay.Text, txtStartTime.Text));
DateTime StopTime = Convert.ToDateTime(String.Format("{0} {1}", txtStopDay.Text, txtStopTime.Text));
}
catch
{
lblError.Text = Localization.GetString("MustProvideValidStarAndStopTimes.Text", LocalResourceFile);
return;
}
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
string strComment = txtComment.Text.Trim();
// Save Task Details
HelpDesk_TaskDetail objHelpDesk_TaskDetail = new HelpDesk_TaskDetail();
objHelpDesk_TaskDetail.TaskID = TaskID;
objHelpDesk_TaskDetail.Description = txtComment.Text.Trim();
objHelpDesk_TaskDetail.InsertDate = DateTime.Now;
objHelpDesk_TaskDetail.UserID = UserId;
objHelpDesk_TaskDetail.DetailType = "Work";
objHelpDesk_TaskDetail.StartTime = Convert.ToDateTime(String.Format("{0} {1}", txtStartDay.Text, txtStartTime.Text));
objHelpDesk_TaskDetail.StopTime = Convert.ToDateTime(String.Format("{0} {1}", txtStopDay.Text, txtStopTime.Text));
objHelpDeskDALDataContext.HelpDesk_TaskDetails.InsertOnSubmit(objHelpDesk_TaskDetail);
objHelpDeskDALDataContext.SubmitChanges();
txtComment.Text = "";
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString("InsertedWorkComment.Text", LocalResourceFile), GetUserName()));
gvComments.DataBind();
}
else
{
lblError.Text = Localization.GetString("MustProvideADescription.Text", LocalResourceFile);
}
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var objHelpDesk_TaskDetail = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_TaskDetails
where HelpDesk_TaskDetails.DetailID == Convert.ToInt32(lblDetailID.Text)
select HelpDesk_TaskDetails).FirstOrDefault();
// Delete any Attachments
if (objHelpDesk_TaskDetail.HelpDesk_Attachments.Count > 0)
{
HelpDesk_Attachment objHelpDesk_Attachment = objHelpDesk_TaskDetail.HelpDesk_Attachments.FirstOrDefault();
string strOriginalFileName = objHelpDesk_Attachment.OriginalFileName;
string strFile = objHelpDesk_Attachment.AttachmentPath;
try
{
// Delete file
if (strFile != "")
{
File.Delete(strFile);
}
}
catch (Exception exc)
{
Exceptions.ProcessModuleLoadException(this, exc);
}
objHelpDeskDALDataContext.HelpDesk_Attachments.DeleteOnSubmit(objHelpDesk_Attachment);
objHelpDeskDALDataContext.SubmitChanges();
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString("DeletedFile.Text", LocalResourceFile), GetUserName(), strOriginalFileName));
}
// Delete the Record
objHelpDeskDALDataContext.HelpDesk_TaskDetails.DeleteOnSubmit(objHelpDesk_TaskDetail);
objHelpDeskDALDataContext.SubmitChanges();
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString("DeletedComment.Text", LocalResourceFile), GetUserName(), txtDescription.Text));
SetView("Default");
gvComments.DataBind();
}
protected void LDSComments_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_TaskDetails
where HelpDesk_TaskDetails.TaskID == TaskID
where (HelpDesk_TaskDetails.DetailType == "Comment" || HelpDesk_TaskDetails.DetailType == "Comment-Visible")
select HelpDesk_TaskDetails;
// If View only mode
if (ViewOnly)
{
result = from TaskDetails in result
where TaskDetails.DetailType == "Comment-Visible"
select TaskDetails;
}
e.Result = result;
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var objHelpDesk_TaskDetail = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_TaskDetails
where HelpDesk_TaskDetails.DetailID == Convert.ToInt32(lblDetailID.Text)
select HelpDesk_TaskDetails).FirstOrDefault();
// Delete the Record
objHelpDeskDALDataContext.HelpDesk_TaskDetails.DeleteOnSubmit(objHelpDesk_TaskDetail);
objHelpDeskDALDataContext.SubmitChanges();
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString("DeletedWorkComment.Text", LocalResourceFile), GetUserName(), txtDescription.Text));
SetView("Default");
gvComments.DataBind();
}
private bool UserIsRequestor()
{
bool isRequestor = false;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails;
if (result != null)
{
if (UserId == result.FirstOrDefault().RequesterUserID)
{
isRequestor = true;
}
}
return(isRequestor);
}
private void DisplayComment()
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var objHelpDesk_TaskDetail = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_TaskDetails
where HelpDesk_TaskDetails.DetailID == Convert.ToInt32(lblDetailID.Text)
select HelpDesk_TaskDetails).FirstOrDefault();
if (objHelpDesk_TaskDetail != null)
{
txtDescription.Text = objHelpDesk_TaskDetail.Description;
lblDisplayUser.Text = GetUserName(objHelpDesk_TaskDetail.UserID);
txtStartDayEdit.Text = objHelpDesk_TaskDetail.StartTime.Value.ToShortDateString();
txtStopDayEdit.Text = objHelpDesk_TaskDetail.StopTime.Value.ToShortDateString();
txtStartTimeEdit.Text = objHelpDesk_TaskDetail.StartTime.Value.ToShortTimeString();
txtStopTimeEdit.Text = objHelpDesk_TaskDetail.StopTime.Value.ToShortTimeString();
lblInsertDate.Text = String.Format("{0} {1}", objHelpDesk_TaskDetail.InsertDate.ToLongDateString(), objHelpDesk_TaskDetail.InsertDate.ToLongTimeString());
}
}
private string GetAdminRole()
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
List <HelpDesk_Setting> colHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
select HelpDesk_Settings).ToList();
HelpDesk_Setting objHelpDesk_Setting = colHelpDesk_Setting.Where(x => x.SettingName == "AdminRole").FirstOrDefault();
string strAdminRoleID = "Administrators";
if (objHelpDesk_Setting != null)
{
strAdminRoleID = objHelpDesk_Setting.SettingValue;
}
return(strAdminRoleID);
}
private void DisplayUploadedFilesPath()
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
// Uploaded Files Path
HelpDesk_Setting objHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
where HelpDesk_Settings.SettingName == "UploFilesPath"
select HelpDesk_Settings).FirstOrDefault();
txtUploadedFilesPath.Text = objHelpDesk_Setting.SettingValue;
// Upload Permissions
HelpDesk_Setting UploadPermissionHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
where HelpDesk_Settings.SettingName == "UploadPermission"
select HelpDesk_Settings).FirstOrDefault();
ddlUploadPermission.SelectedValue = UploadPermissionHelpDesk_Setting.SettingValue;
}
// Utility
#region GetEmailOfRequestor
private string GetEmailOfRequestor()
{
string strEmail = "";
int intTaskId = Convert.ToInt32(Request.QueryString["TaskID"]);
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails).FirstOrDefault();
if (result != null)
{
if (result.RequesterUserID == -1)
{
try
{
strEmail = result.RequesterEmail;
}
catch (Exception)
{
// User no longer exists
strEmail = "";
}
}
else
{
try
{
strEmail = //UserController.GetUser(PortalId, result.RequesterUserID, false).Email;
UserController.GetUserById(PortalId, result.RequesterUserID).Email;
}
catch (Exception)
{
// User no longer exists
strEmail = "";
}
}
}
return(strEmail);
}
private void NotifyRequestorOfComment(string strComment)
{
string strEmail = GetEmailOfRequestor();
if (strEmail != "")
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails).FirstOrDefault();
if (result != null)
{
string strLinkUrl = "";
if (result.RequesterUserID > -1)
{
// This is a registred User / Provide link to ticket
strLinkUrl = Utils.FixURLLink(DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "EditTask", "mid=" + ModuleID.ToString(), String.Format(@"&TaskID={0}", TaskID)), PortalSettings.PortalAlias.HTTPAlias);
}
else
{
// This is NOT a registred User / Provide link to ticket with a password
strLinkUrl = Utils.FixURLLink(DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "EditTask", "mid=" + ModuleID.ToString(), String.Format(@"&TaskID={0}&TP={1}", TaskID, result.TicketPassword)), PortalSettings.PortalAlias.HTTPAlias);
}
string strDescription = result.Description;
string strSubject = String.Format(Localization.GetString("HelpDeskTicketAtHasBeenupdated.Text", LocalResourceFile), Request.QueryString["TaskID"], PortalSettings.PortalAlias.HTTPAlias);
string strBody = String.Format(Localization.GetString("HelpDeskTicketHasBeenupdated.Text", LocalResourceFile), Request.QueryString["TaskID"], strDescription);
strBody = strBody + Environment.NewLine + Environment.NewLine;
strBody = strBody + Localization.GetString("Comments.Text", LocalResourceFile) + Environment.NewLine;
strBody = strBody + strComment;
strBody = strBody + Environment.NewLine + Environment.NewLine;
strBody = strBody + String.Format(Localization.GetString("YouMaySeeFullStatusHere.Text", LocalResourceFile), strLinkUrl);
DotNetNuke.Services.Mail.Mail.SendMail(PortalSettings.Email, strEmail, "", strSubject, strBody, "", "HTML", "", "", "", "");
Log.InsertLog(Convert.ToInt32(Request.QueryString["TaskID"]), UserId, String.Format(Localization.GetString("RequestorWasEmailed.Text", LocalResourceFile), strEmail, strComment));
}
}
}
private void LoadRolesDropDown()
{
RoleController objRoleController = new RoleController();
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
List <HelpDesk_Role> colHelpDesk_Roles = (from HelpDesk_Roles in objHelpDeskDALDataContext.HelpDesk_Roles
where HelpDesk_Roles.PortalID == PortalId
select HelpDesk_Roles).ToList();
// Create a ListItemCollection to hold the Roles
ListItemCollection colListItemCollection = new ListItemCollection();
// Add the Roles to the List
foreach (HelpDesk_Role objHelpDesk_Role in colHelpDesk_Roles)
{
try
{
RoleInfo objRoleInfo = objRoleController.GetRole(Convert.ToInt32(objHelpDesk_Role.RoleID), PortalId);
ListItem RoleListItem = new ListItem();
RoleListItem.Text = objRoleInfo.RoleName;
RoleListItem.Value = objHelpDesk_Role.RoleID.ToString();
ddlAssigned.Items.Add(RoleListItem);
}
catch
{
// Role no longer exists in Portal
ListItem RoleListItem = new ListItem();
RoleListItem.Text = Localization.GetString("DeletedRole.Text", LocalResourceFile);
RoleListItem.Value = objHelpDesk_Role.RoleID.ToString();
ddlAssigned.Items.Add(RoleListItem);
}
}
// Add UnAssigned
ListItem UnassignedRoleListItem = new ListItem();
UnassignedRoleListItem.Text = Localization.GetString("Unassigned.Text", LocalResourceFile);
UnassignedRoleListItem.Value = "-1";
ddlAssigned.Items.Add(UnassignedRoleListItem);
}
protected void btnUploadedFiles_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Setting UploFilesHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
where HelpDesk_Settings.SettingName == "UploFilesPath"
select HelpDesk_Settings).FirstOrDefault();
UploFilesHelpDesk_Setting.SettingValue = txtUploadedFilesPath.Text.Trim();
objHelpDeskDALDataContext.SubmitChanges();
HelpDesk_Setting UploadPermissionHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
where HelpDesk_Settings.SettingName == "UploadPermission"
select HelpDesk_Settings).FirstOrDefault();
UploadPermissionHelpDesk_Setting.SettingValue = ddlUploadPermission.SelectedValue;
objHelpDeskDALDataContext.SubmitChanges();
lblUploadedFilesPath.Text = Localization.GetString("Updated.Text", LocalResourceFile);
}
