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