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();
}
// 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();
}
private void InsertComment()
{
// Validate file upload
if (TicketFileUpload.HasFile)
{
/*if (
string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".gif", true) != 0
& string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".jpg", true) != 0
& string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".jpeg", true) != 0
& string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".doc", true) != 0
& string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".docx", true) != 0
& string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".xls", true) != 0
& string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".xlsx", true) != 0
& string.Compare(Path.GetExtension(TicketFileUpload.FileName).ToLower(), ".pdf", true) != 0
)*/
if(!Utils.IsFileAllowed(TicketFileUpload.FileName))
{
lblError.Text = Localization.GetString ("FileExtensionIsNotAllowed.Text", LocalResourceFile);
// lblError.Text = "Only .gif, .jpg, .jpeg, .doc, .docx, .xls, .xlsx, .pdf files may be used.";
return;
}
}
if (txtComment.Text.Trim().Length > 0)
{
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;
if (chkCommentVisible.Checked)
{
objHelpDesk_TaskDetail.DetailType = "Comment-Visible";
}
else
{
objHelpDesk_TaskDetail.DetailType = "Comment";
}
objHelpDeskDALDataContext.HelpDesk_TaskDetails.InsertOnSubmit(objHelpDesk_TaskDetail);
objHelpDeskDALDataContext.SubmitChanges();
txtComment.Text = "";
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString ("InsertedComment.Text", LocalResourceFile), GetUserName()));
// Upload the File
if (TicketFileUpload.HasFile)
{
UploadFile(objHelpDesk_TaskDetail.DetailID);
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString ("UploadedFile.Text", LocalResourceFile), GetUserName(), TicketFileUpload.FileName));
}
if (UserIsRequestor())
{
NotifyAssignedGroupOfComment(strComment);
}
gvComments.DataBind();
}
}
private List<HelpDesk_Setting> GetSettings()
{
// Get Settings
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();
if (colHelpDesk_Setting.Count == 0)
{
// Create Default vaules
HelpDesk_Setting objHelpDesk_Setting1 = new HelpDesk_Setting();
objHelpDesk_Setting1.PortalID = PortalId;
objHelpDesk_Setting1.SettingName = "AdminRole";
objHelpDesk_Setting1.SettingValue = "Administrators";
objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting1);
objHelpDeskDALDataContext.SubmitChanges();
HelpDesk_Setting objHelpDesk_Setting2 = new HelpDesk_Setting();
objHelpDesk_Setting2.PortalID = PortalId;
objHelpDesk_Setting2.SettingName = "UploFilesPath";
objHelpDesk_Setting2.SettingValue = Server.MapPath("~/DesktopModules/R7.HelpDesk/R7.HelpDesk/Upload");
objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting2);
objHelpDeskDALDataContext.SubmitChanges();
colHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
select HelpDesk_Settings).ToList();
}
// Upload Permission
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();
if (UploadPermissionHelpDesk_Setting != null)
{
// Add to collection
colHelpDesk_Setting.Add(UploadPermissionHelpDesk_Setting);
}
else
{
// Add Default value
HelpDesk_Setting objHelpDesk_Setting = new HelpDesk_Setting();
objHelpDesk_Setting.SettingName = "UploadPermission";
objHelpDesk_Setting.SettingValue = "All";
objHelpDesk_Setting.PortalID = PortalId;
objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting);
objHelpDeskDALDataContext.SubmitChanges();
// Add to collection
colHelpDesk_Setting.Add(objHelpDesk_Setting);
}
return colHelpDesk_Setting;
}
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);
}
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 List<HelpDesk_Setting> GetSettings()
{
// Get Settings
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();
if (colHelpDesk_Setting.Count == 0)
{
// Create Default vaules
HelpDesk_Setting objHelpDesk_Setting1 = new HelpDesk_Setting();
objHelpDesk_Setting1.PortalID = PortalId;
objHelpDesk_Setting1.SettingName = "AdminRole";
objHelpDesk_Setting1.SettingValue = "Administrators";
objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting1);
objHelpDeskDALDataContext.SubmitChanges();
HelpDesk_Setting objHelpDesk_Setting2 = new HelpDesk_Setting();
objHelpDesk_Setting2.PortalID = PortalId;
objHelpDesk_Setting2.SettingName = "UploFilesPath";
objHelpDesk_Setting2.SettingValue = Server.MapPath("~/DesktopModules/R7.HelpDesk/R7.HelpDesk/Upload");
objHelpDeskDALDataContext.HelpDesk_Settings.InsertOnSubmit(objHelpDesk_Setting2);
objHelpDeskDALDataContext.SubmitChanges();
colHelpDesk_Setting = (from HelpDesk_Settings in objHelpDeskDALDataContext.HelpDesk_Settings
where HelpDesk_Settings.PortalID == PortalId
select HelpDesk_Settings).ToList();
}
return colHelpDesk_Setting;
}
private void UpdateComment()
{
// Validate file upload
if (fuAttachment.HasFile)
{
/*if (
string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".gif", true) != 0
& string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".jpg", true) != 0
& string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".jpeg", true) != 0
& string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".doc", true) != 0
& string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".docx", true) != 0
& string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".xls", true) != 0
& string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".xlsx", true) != 0
& string.Compare(Path.GetExtension(fuAttachment.FileName).ToLower(), ".pdf", true) != 0
)*/
if(!Utils.IsFileAllowed(TicketFileUpload.FileName))
{
lblError.Text = Localization.GetString ("FileExtensionIsNotAllowed.Text", LocalResourceFile);
// lblError.Text = "Only .gif, .jpg, .jpeg, .doc, .docx, .xls, .xlsx, .pdf files may be used.";
return;
}
}
if (!string.IsNullOrWhiteSpace(txtDescription.Text))
// 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;
if (chkCommentVisibleEdit.Checked)
{
objHelpDesk_TaskDetail.DetailType = "Comment-Visible";
}
else
{
objHelpDesk_TaskDetail.DetailType = "Comment";
}
objHelpDeskDALDataContext.SubmitChanges();
txtDescription.Text = "";
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format(Localization.GetString ("UpdatedComment.Text", LocalResourceFile), GetUserName()));
// Upload the File
if (fuAttachment.HasFile)
{
UploadFileCommentEdit(objHelpDesk_TaskDetail.DetailID);
}
SetView("Default");
gvComments.DataBind();
}
}
}
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 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 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 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();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
// Get the node
var result = (from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.CategoryID == Convert.ToInt32(txtCategoryID.Text)
select HelpDesk_Categories).FirstOrDefault();
// Make a Temp object to use to update the child nodes
HelpDesk_Category TmpHelpDesk_Category = new HelpDesk_Category();
TmpHelpDesk_Category.CategoryID = result.CategoryID;
if (result.ParentCategoryID == null)
{
TmpHelpDesk_Category.Level = 0;
}
else
{
TmpHelpDesk_Category.Level = GetLevelOfParent(result.ParentCategoryID);
}
// Get all TaskCategories that use the Node
var colTaskCategories = from HelpDesk_TaskCategories in objHelpDeskDALDataContext.HelpDesk_TaskCategories
where HelpDesk_TaskCategories.CategoryID == Convert.ToInt32(txtCategoryID.Text)
select HelpDesk_TaskCategories;
// Delete them
objHelpDeskDALDataContext.HelpDesk_TaskCategories.DeleteAllOnSubmit(colTaskCategories);
objHelpDeskDALDataContext.SubmitChanges();
// Delete the node
objHelpDeskDALDataContext.HelpDesk_Categories.DeleteOnSubmit(result);
objHelpDeskDALDataContext.SubmitChanges();
// Update levels of all the Children
UpdateLevelOfChildren(TmpHelpDesk_Category);
// Update all the children nodes to give them a new parent
var CategoryChildren = from HelpDesk_Categories in objHelpDeskDALDataContext.HelpDesk_Categories
where HelpDesk_Categories.ParentCategoryID == result.CategoryID
select HelpDesk_Categories;
// Loop thru each item
foreach (var objCategory in CategoryChildren)
{
objCategory.ParentCategoryID = result.ParentCategoryID;
objHelpDeskDALDataContext.SubmitChanges();
}
// Delete the Catagory from any Ticket that uses it
var DeleteHelpDesk_TaskCategories = from HelpDesk_TaskCategories in objHelpDeskDALDataContext.HelpDesk_TaskCategories
where HelpDesk_TaskCategories.CategoryID == TmpHelpDesk_Category.CategoryID
select HelpDesk_TaskCategories;
objHelpDeskDALDataContext.HelpDesk_TaskCategories.DeleteAllOnSubmit(DeleteHelpDesk_TaskCategories);
objHelpDeskDALDataContext.SubmitChanges();
RefreshCache();
// Set the CategoryID
txtCategoryID.Text = (result.ParentCategoryID == null) ? "" : result.ParentCategoryID.ToString();
DisplayHelpDesk();
SelectTreeNode();
}
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);
}
}
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;
}
}
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 imgDelete_Click(object sender, System.Web.UI.ImageClickEventArgs 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 Attachment
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));
pnlAttachFile.Visible = true;
pnlDisplayFile.Visible = false;
}
}
private HelpDesk_LastSearch GetLastSearchCriteria()
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_LastSearch objHelpDesk_LastSearch = (from HelpDesk_LastSearches in objHelpDeskDALDataContext.HelpDesk_LastSearches
where HelpDesk_LastSearches.PortalID == PortalId
where HelpDesk_LastSearches.UserID == UserId
select HelpDesk_LastSearches).FirstOrDefault();
if (objHelpDesk_LastSearch == null)
{
HelpDesk_LastSearch InsertHelpDesk_LastSearch = new HelpDesk_LastSearch();
InsertHelpDesk_LastSearch.UserID = UserId;
InsertHelpDesk_LastSearch.PortalID = PortalId;
objHelpDeskDALDataContext.HelpDesk_LastSearches.InsertOnSubmit(InsertHelpDesk_LastSearch);
// Only save is user is logged in
if (UserId > -1)
{
objHelpDeskDALDataContext.SubmitChanges();
}
return InsertHelpDesk_LastSearch;
}
else
{
return objHelpDesk_LastSearch;
}
}
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));
}
private void SaveLastSearchCriteria(HelpDesk_LastSearch UpdateHelpDesk_LastSearch)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_LastSearch objHelpDesk_LastSearch = (from HelpDesk_LastSearches in objHelpDeskDALDataContext.HelpDesk_LastSearches
where HelpDesk_LastSearches.PortalID == PortalId
where HelpDesk_LastSearches.UserID == UserId
select HelpDesk_LastSearches).FirstOrDefault();
if (objHelpDesk_LastSearch == null)
{
objHelpDesk_LastSearch = new HelpDesk_LastSearch();
objHelpDesk_LastSearch.UserID = UserId;
objHelpDesk_LastSearch.PortalID = PortalId;
objHelpDeskDALDataContext.HelpDesk_LastSearches.InsertOnSubmit(objHelpDesk_LastSearch);
objHelpDeskDALDataContext.SubmitChanges();
}
objHelpDesk_LastSearch.AssignedRoleID = UpdateHelpDesk_LastSearch.AssignedRoleID;
objHelpDesk_LastSearch.Categories = UpdateHelpDesk_LastSearch.Categories;
objHelpDesk_LastSearch.CreatedDate = UpdateHelpDesk_LastSearch.CreatedDate;
objHelpDesk_LastSearch.SearchText = UpdateHelpDesk_LastSearch.SearchText;
objHelpDesk_LastSearch.DueDate = UpdateHelpDesk_LastSearch.DueDate;
objHelpDesk_LastSearch.Priority = UpdateHelpDesk_LastSearch.Priority;
objHelpDesk_LastSearch.Status = UpdateHelpDesk_LastSearch.Status;
objHelpDesk_LastSearch.CurrentPage = UpdateHelpDesk_LastSearch.CurrentPage;
objHelpDesk_LastSearch.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue);
objHelpDeskDALDataContext.SubmitChanges();
}
private int SaveTicketForm()
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Task objHelpDesk_Task = (from HelpDesk_Tasks in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_Tasks).FirstOrDefault();
// Save original Assigned Group
int intOriginalAssignedGroup = objHelpDesk_Task.AssignedRoleID;
// Save Task
objHelpDesk_Task.Status = ddlStatus.SelectedValue;
objHelpDesk_Task.Description = txtDescription.Text;
objHelpDesk_Task.PortalID = PortalId;
objHelpDesk_Task.Priority = ddlPriority.SelectedValue;
objHelpDesk_Task.RequesterPhone = txtPhone.Text;
objHelpDesk_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
objHelpDesk_Task.RequesterEmail = txtEmail.Text;
objHelpDesk_Task.RequesterName = txtName.Text;
objHelpDesk_Task.RequesterUserID = -1;
}
// DueDate
if (txtDueDate.Text.Trim().Length > 1)
{
objHelpDesk_Task.DueDate = Convert.ToDateTime(txtDueDate.Text.Trim());
}
else
{
objHelpDesk_Task.DueDate = null;
}
// EstimatedStart
if (txtStart.Text.Trim().Length > 1)
{
objHelpDesk_Task.EstimatedStart = Convert.ToDateTime(txtStart.Text.Trim());
}
else
{
objHelpDesk_Task.EstimatedStart = null;
}
// EstimatedCompletion
if (txtComplete.Text.Trim().Length > 1)
{
objHelpDesk_Task.EstimatedCompletion = Convert.ToDateTime(txtComplete.Text.Trim());
}
else
{
objHelpDesk_Task.EstimatedCompletion = null;
}
// EstimatedHours
if (txtEstimate.Text.Trim().Length > 0)
{
objHelpDesk_Task.EstimatedHours = Convert.ToInt32(txtEstimate.Text.Trim());
}
else
{
objHelpDesk_Task.EstimatedHours = null;
}
objHelpDeskDALDataContext.SubmitChanges();
// Notify Assigned Group
if (Convert.ToInt32(ddlAssigned.SelectedValue) > -1)
{
// Only notify if Assigned group has changed
if (intOriginalAssignedGroup != Convert.ToInt32(ddlAssigned.SelectedValue))
{
NotifyAssignedGroupOfAssignment();
}
}
// Insert Log
Log.InsertLog(objHelpDesk_Task.TaskID, UserId, String.Format(Localization.GetString("UpdatedTicket.Text", LocalResourceFile), UserInfo.DisplayName));
return objHelpDesk_Task.TaskID;
}
private int SaveNewTicketForm()
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
// Save Task
HelpDesk_Task objHelpDesk_Task = new HelpDesk_Task();
objHelpDesk_Task.Status = "New";
objHelpDesk_Task.CreatedDate = DateTime.Now;
objHelpDesk_Task.Description = txtDescription.Text;
objHelpDesk_Task.PortalID = PortalId;
objHelpDesk_Task.Priority = ddlPriority.SelectedValue;
objHelpDesk_Task.RequesterPhone = txtPhone.Text;
objHelpDesk_Task.AssignedRoleID = -1;
objHelpDesk_Task.TicketPassword = GetRandomPassword();
if (Convert.ToInt32(txtUserID.Text) == -1)
{
// User not logged in
objHelpDesk_Task.RequesterEmail = txtEmail.Text;
objHelpDesk_Task.RequesterName = txtName.Text;
objHelpDesk_Task.RequesterUserID = -1;
}
else
{
// User logged in
objHelpDesk_Task.RequesterUserID = Convert.ToInt32(txtUserID.Text);
objHelpDesk_Task.RequesterName = //UserController.GetUser(PortalId, Convert.ToInt32(txtUserID.Text), false).DisplayName;
UserController.GetUserById(PortalId, Convert.ToInt32(txtUserID.Text)).DisplayName;
}
if (txtDueDate.Text.Trim().Length > 1)
{
objHelpDesk_Task.DueDate = Convert.ToDateTime(txtDueDate.Text.Trim());
}
// If Admin panel is visible this is an admin
// Save the Status and Assignment
if (pnlAdminTicketStatus.Visible == true)
{
objHelpDesk_Task.AssignedRoleID = Convert.ToInt32(ddlAssignedAdmin.SelectedValue);
objHelpDesk_Task.Status = ddlStatusAdmin.SelectedValue;
}
objHelpDeskDALDataContext.HelpDesk_Tasks.InsertOnSubmit(objHelpDesk_Task);
objHelpDeskDALDataContext.SubmitChanges();
// Save Task Details
HelpDesk_TaskDetail objHelpDesk_TaskDetail = new HelpDesk_TaskDetail();
if ((txtDetails.Text.Trim().Length > 0) || (TicketFileUpload.HasFile))
{
objHelpDesk_TaskDetail.TaskID = objHelpDesk_Task.TaskID;
objHelpDesk_TaskDetail.Description = txtDetails.Text;
objHelpDesk_TaskDetail.DetailType = "Comment-Visible";
objHelpDesk_TaskDetail.InsertDate = DateTime.Now;
if (Convert.ToInt32(txtUserID.Text) == -1)
{
// User not logged in
objHelpDesk_TaskDetail.UserID = -1;
}
else
{
// User logged in
objHelpDesk_TaskDetail.UserID = Convert.ToInt32(txtUserID.Text);
}
objHelpDeskDALDataContext.HelpDesk_TaskDetails.InsertOnSubmit(objHelpDesk_TaskDetail);
objHelpDeskDALDataContext.SubmitChanges();
// Upload the File
if (TicketFileUpload.HasFile)
{
UploadFile(objHelpDesk_TaskDetail.DetailID);
// Insert Log
Log.InsertLog(objHelpDesk_Task.TaskID, UserId, String.Format(Localization.GetString("UploadedFile.Text", LocalResourceFile), GetUserName(), TicketFileUpload.FileName));
}
}
// Insert Log
Log.InsertLog(objHelpDesk_Task.TaskID, UserId, String.Format(Localization.GetString("CreatedTicket.Text", LocalResourceFile), GetUserName()));
return objHelpDesk_Task.TaskID;
}
private void SaveTags(int intTaskID)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
TreeView objTreeView = (TreeView)TagsTree.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();
}
}
}
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);
}
