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