partial void UpdateHelpDesk_TaskDetail(HelpDesk_TaskDetail instance);
partial void DeleteHelpDesk_TaskDetail(HelpDesk_TaskDetail instance);
partial void InsertHelpDesk_TaskDetail(HelpDesk_TaskDetail instance);
private void detach_HelpDesk_TaskDetails(HelpDesk_TaskDetail entity) { this.SendPropertyChanging(); entity.HelpDesk_Task = null; }
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 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 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); } }