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(); } } }
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; } }
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 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 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(); } }
// 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 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 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); }
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 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() { 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); }
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 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(); }
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 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); }
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(); } }
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 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 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); }