private void UploadFileCommentEdit(int intDetailID) { ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext(); string strUploadefFilesPath = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings where ITILServiceDesk_Settings.PortalID == PortalId where ITILServiceDesk_Settings.SettingName == "UploadefFilesPath" select ITILServiceDesk_Settings).FirstOrDefault().SettingValue; EnsureDirectory(new System.IO.DirectoryInfo(strUploadefFilesPath)); string strfilename = Convert.ToString(intDetailID) + "_" + GetRandomPassword() + Path.GetExtension(fuAttachment.FileName).ToLower(); strUploadefFilesPath = strUploadefFilesPath + @"\" + strfilename; fuAttachment.SaveAs(strUploadefFilesPath); ITILServiceDesk_Attachment objITILServiceDesk_Attachment = new ITILServiceDesk_Attachment(); objITILServiceDesk_Attachment.DetailID = intDetailID; objITILServiceDesk_Attachment.FileName = strfilename; objITILServiceDesk_Attachment.OriginalFileName = fuAttachment.FileName; objITILServiceDesk_Attachment.AttachmentPath = strUploadefFilesPath; objITILServiceDesk_Attachment.UserID = UserId; objServiceDeskDALDataContext.ITILServiceDesk_Attachments.InsertOnSubmit(objITILServiceDesk_Attachment); objServiceDeskDALDataContext.SubmitChanges(); // Insert Log Log.InsertLog(TaskID, UserId, String.Format("{0} uploaded file '{1}'.", GetUserName(), fuAttachment.FileName)); }
protected void lnkDelete_Click(object sender, EventArgs e) { ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext(); var objITILServiceDesk_TaskDetail = (from ITILServiceDesk_TaskDetails in objServiceDeskDALDataContext.ITILServiceDesk_TaskDetails where ITILServiceDesk_TaskDetails.DetailID == Convert.ToInt32(lblDetailID.Text) select ITILServiceDesk_TaskDetails).FirstOrDefault(); // Delete any Attachments if (objITILServiceDesk_TaskDetail.ITILServiceDesk_Attachments.Count > 0) { ITILServiceDesk_Attachment objITILServiceDesk_Attachment = objITILServiceDesk_TaskDetail.ITILServiceDesk_Attachments.FirstOrDefault(); string strOriginalFileName = objITILServiceDesk_Attachment.OriginalFileName; string strFile = objITILServiceDesk_Attachment.AttachmentPath; try { // Delete file if (strFile != "") { File.Delete(strFile); } } catch (Exception exc) { Exceptions.ProcessModuleLoadException(this, exc); } objServiceDeskDALDataContext.ITILServiceDesk_Attachments.DeleteOnSubmit(objITILServiceDesk_Attachment); objServiceDeskDALDataContext.SubmitChanges(); // Insert Log Log.InsertLog(TaskID, UserId, String.Format("{0} deleted file '{1}'.", GetUserName(), strOriginalFileName)); } // Delete the Record objServiceDeskDALDataContext.ITILServiceDesk_TaskDetails.DeleteOnSubmit(objITILServiceDesk_TaskDetail); objServiceDeskDALDataContext.SubmitChanges(); // Insert Log Log.InsertLog(TaskID, UserId, String.Format("{0} deleted comment: {1}", GetUserName(), txtDescription.Text)); SetView("Default"); gvComments.DataBind(); }
protected void imgDelete_Click(object sender, System.Web.UI.ImageClickEventArgs e) { ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext(); var objITILServiceDesk_TaskDetail = (from ITILServiceDesk_TaskDetails in objServiceDeskDALDataContext.ITILServiceDesk_TaskDetails where ITILServiceDesk_TaskDetails.DetailID == Convert.ToInt32(lblDetailID.Text) select ITILServiceDesk_TaskDetails).FirstOrDefault(); // Delete Attachment if (objITILServiceDesk_TaskDetail.ITILServiceDesk_Attachments.Count > 0) { ITILServiceDesk_Attachment objITILServiceDesk_Attachment = objITILServiceDesk_TaskDetail.ITILServiceDesk_Attachments.FirstOrDefault(); string strOriginalFileName = objITILServiceDesk_Attachment.OriginalFileName; string strFile = objITILServiceDesk_Attachment.AttachmentPath; try { // Delete file if (strFile != "") { File.Delete(strFile); } } catch (Exception exc) { Exceptions.ProcessModuleLoadException(this, exc); } objServiceDeskDALDataContext.ITILServiceDesk_Attachments.DeleteOnSubmit(objITILServiceDesk_Attachment); objServiceDeskDALDataContext.SubmitChanges(); // Insert Log Log.InsertLog(TaskID, UserId, String.Format("{0} deleted file '{1}'.", GetUserName(), strOriginalFileName)); pnlAttachFile.Visible = true; pnlDisplayFile.Visible = false; } }