protected void LDSLogs_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_Logs in objHelpDeskDALDataContext.HelpDesk_Logs
where HelpDesk_Logs.TaskID == TaskID
select HelpDesk_Logs;
e.Result = result;
}
private static IQueryable<HelpDesk_Category> GetEntireRequestorTable(int PortalID)
{
HelpDeskDALDataContext CategoryAdminDALDataContext = new HelpDeskDALDataContext();
IQueryable<HelpDesk_Category> EntireTable = (from WebserverCategories in CategoryAdminDALDataContext.HelpDesk_Categories
where WebserverCategories.PortalID == PortalID
where WebserverCategories.RequestorVisible == true
select WebserverCategories).ToList().AsQueryable();
return EntireTable;
}
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 void SaveTags(int intTaskID)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
TreeView objTreeView = (TreeView)TagsTree.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();
}
}
}
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));
}
// Display Ticket Data
#region DisplayTicketData
private void DisplayTicketData()
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Task objHelpDesk_Tasks = (from HelpDesk_Tasks in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_Tasks).FirstOrDefault();
// Name is editable only if user is Anonymous
if (objHelpDesk_Tasks.RequesterUserID == -1)
{
txtEmail.Visible = true;
txtName.Visible = true;
lblEmail.Visible = false;
lblName.Visible = false;
txtEmail.Text = objHelpDesk_Tasks.RequesterEmail;
txtName.Text = objHelpDesk_Tasks.RequesterName;
}
else
{
txtEmail.Visible = false;
txtName.Visible = false;
lblEmail.Visible = true;
lblName.Visible = true;
UserInfo objRequester = //UserController.GetUser(PortalId, objHelpDesk_Tasks.RequesterUserID, false);
UserController.GetUserById (PortalId, objHelpDesk_Tasks.RequesterUserID);
if (objRequester != null)
{
lblEmail.Text = objRequester.Email; // UserController.GetUser(PortalId, objHelpDesk_Tasks.RequesterUserID, false).Email;
lblName.Text = objRequester.DisplayName; // UserController.GetUser(PortalId, objHelpDesk_Tasks.RequesterUserID, false).DisplayName;
}
else
{
lblName.Text = "[User Deleted]";
}
}
lblTask.Text = objHelpDesk_Tasks.TaskID.ToString();
lblCreated.Text = String.Format(Localization.GetString("Created.Text", LocalResourceFile), objHelpDesk_Tasks.CreatedDate.ToShortDateString(), objHelpDesk_Tasks.CreatedDate.ToShortTimeString());
ddlStatus.SelectedValue = objHelpDesk_Tasks.Status;
ddlPriority.SelectedValue = objHelpDesk_Tasks.Priority;
txtDescription.Text = objHelpDesk_Tasks.Description;
txtPhone.Text = objHelpDesk_Tasks.RequesterPhone;
txtDueDate.Text = (objHelpDesk_Tasks.DueDate.HasValue) ? objHelpDesk_Tasks.DueDate.Value.ToShortDateString() : "";
txtStart.Text = (objHelpDesk_Tasks.EstimatedStart.HasValue) ? objHelpDesk_Tasks.EstimatedStart.Value.ToShortDateString() : "";
txtComplete.Text = (objHelpDesk_Tasks.EstimatedCompletion.HasValue) ? objHelpDesk_Tasks.EstimatedCompletion.Value.ToShortDateString() : "";
txtEstimate.Text = (objHelpDesk_Tasks.EstimatedHours.HasValue) ? objHelpDesk_Tasks.EstimatedHours.Value.ToString() : "";
ListItem TmpRoleListItem = ddlAssigned.Items.FindByValue(objHelpDesk_Tasks.AssignedRoleID.ToString());
if (TmpRoleListItem == null)
{
// Value was not found so add it
RoleController objRoleController = new RoleController();
RoleInfo objRoleInfo = objRoleController.GetRole(objHelpDesk_Tasks.AssignedRoleID, PortalId);
if (objRoleInfo != null)
{
ListItem RoleListItem = new ListItem();
RoleListItem.Text = objRoleInfo.RoleName;
RoleListItem.Value = objHelpDesk_Tasks.AssignedRoleID.ToString();
ddlAssigned.Items.Add(RoleListItem);
ddlAssigned.SelectedValue = objHelpDesk_Tasks.AssignedRoleID.ToString();
}
else
{
// Role no longer exists in Portal
ddlAssigned.SelectedValue = "-1";
}
}
else
{
// The Value already exists so set it
ddlAssigned.SelectedValue = objHelpDesk_Tasks.AssignedRoleID.ToString();
}
}
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();
}
}
}
private void LoadRolesDropDown()
{
RoleController objRoleController = new RoleController();
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
List<HelpDesk_Role> colHelpDesk_Roles = (from HelpDesk_Roles in objHelpDeskDALDataContext.HelpDesk_Roles
where HelpDesk_Roles.PortalID == PortalId
select HelpDesk_Roles).ToList();
// Create a ListItemCollection to hold the Roles
ListItemCollection colListItemCollection = new ListItemCollection();
// Add the Roles to the List
foreach (HelpDesk_Role objHelpDesk_Role in colHelpDesk_Roles)
{
try
{
RoleInfo objRoleInfo = objRoleController.GetRole(Convert.ToInt32(objHelpDesk_Role.RoleID), PortalId);
ListItem RoleListItem = new ListItem();
RoleListItem.Text = objRoleInfo.RoleName;
RoleListItem.Value = objHelpDesk_Role.RoleID.ToString();
ddlAssigned.Items.Add(RoleListItem);
}
catch
{
// Role no longer exists in Portal
ListItem RoleListItem = new ListItem();
RoleListItem.Text = Localization.GetString("DeletedRole.Text", LocalResourceFile);
RoleListItem.Value = objHelpDesk_Role.RoleID.ToString();
ddlAssigned.Items.Add(RoleListItem);
}
}
// Add UnAssigned
ListItem UnassignedRoleListItem = new ListItem();
UnassignedRoleListItem.Text = Localization.GetString("Unassigned.Text", LocalResourceFile);
UnassignedRoleListItem.Value = "-1";
ddlAssigned.Items.Add(UnassignedRoleListItem);
}
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;
}
protected void LDSComments_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_TaskDetails
where HelpDesk_TaskDetails.TaskID == TaskID
where (HelpDesk_TaskDetails.DetailType == "Comment" || HelpDesk_TaskDetails.DetailType == "Comment-Visible")
select HelpDesk_TaskDetails;
// If View only mode
if (ViewOnly)
{
result = from TaskDetails in result
where TaskDetails.DetailType == "Comment-Visible"
select TaskDetails;
}
e.Result = result;
}
private bool UserIsRequestor()
{
bool isRequestor = false;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails;
if (result != null)
{
if (UserId == result.FirstOrDefault().RequesterUserID)
{
isRequestor = true;
}
}
return isRequestor;
}
private string GetAdminRole()
{
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();
HelpDesk_Setting objHelpDesk_Setting = colHelpDesk_Setting.Where(x => x.SettingName == "AdminRole").FirstOrDefault();
string strAdminRoleID = "Administrators";
if (objHelpDesk_Setting != null)
{
strAdminRoleID = objHelpDesk_Setting.SettingValue;
}
return strAdminRoleID;
}
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 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 string GetDescriptionOfTicket()
{
string strDescription = "";
int intTaskId = Convert.ToInt32(Request.QueryString["TaskID"]);
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails).FirstOrDefault();
if (result != null)
{
strDescription = result.Description;
}
return strDescription;
}
private void DisplayCategoryTree()
{
if (UserInfo.IsInRole(GetAdminRole()) || UserInfo.IsInRole("Administrators") || UserInfo.IsSuperUser)
{
TagsTree.Visible = true;
TagsTree.TagID = -1;
TagsTree.DisplayType = "Administrator";
TagsTree.Expand = false;
TagsTreeExistingTasks.Visible = true;
TagsTreeExistingTasks.TagID = -1;
TagsTreeExistingTasks.DisplayType = "Administrator";
TagsTreeExistingTasks.Expand = false;
}
else
{
TagsTree.Visible = true;
TagsTree.TagID = -1;
TagsTree.DisplayType = "Requestor";
TagsTree.Expand = false;
TagsTreeExistingTasks.Visible = true;
TagsTreeExistingTasks.TagID = -1;
TagsTreeExistingTasks.DisplayType = "Requestor";
TagsTreeExistingTasks.Expand = false;
}
// Only Logged in users can have saved Categories in the Tag tree
if ((UserId > -1) && (SearchCriteria.Categories != null))
{
if (SearchCriteria.Categories.Trim() != "")
{
char[] delimiterChars = { ',' };
string[] ArrStrCategories = SearchCriteria.Categories.Split(delimiterChars);
// Convert the Categories selected from the Tags tree to an array of integers
int?[] ArrIntHelpDesk = Array.ConvertAll<string, int?>(ArrStrCategories, new Converter<string, int?>(ConvertStringToNullableInt));
TagsTreeExistingTasks.SelectedCategories = ArrIntHelpDesk;
}
}
// Set visibility of Tags
bool RequestorR7_HelpDesk = (TagsTreeExistingTasks.DisplayType == "Administrator") ? false : true;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
int CountOfHelpDesk = (from WebserverCategories in CategoriesTable.GetCategoriesTable(PortalId, RequestorR7_HelpDesk)
where WebserverCategories.PortalID == PortalId
where WebserverCategories.Level == 1
select WebserverCategories).Count();
imgTags.Visible = (CountOfHelpDesk > 0);
img2Tags.Visible = (CountOfHelpDesk > 0);
lblCheckTags.Visible = (CountOfHelpDesk > 0);
lblSearchTags.Visible = (CountOfHelpDesk > 0);
}
private void NotifyRequestorOfComment(string strComment)
{
string strEmail = GetEmailOfRequestor();
if (strEmail != "")
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails).FirstOrDefault();
if (result != null)
{
string strLinkUrl = "";
if (result.RequesterUserID > -1)
{
// This is a registred User / Provide link to ticket
strLinkUrl = Utils.FixURLLink(DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "EditTask", "mid=" + ModuleID.ToString(), String.Format(@"&TaskID={0}", TaskID)), PortalSettings.PortalAlias.HTTPAlias);
}
else
{
// This is NOT a registred User / Provide link to ticket with a password
strLinkUrl = Utils.FixURLLink(DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "EditTask", "mid=" + ModuleID.ToString(), String.Format(@"&TaskID={0}&TP={1}", TaskID, result.TicketPassword)), PortalSettings.PortalAlias.HTTPAlias);
}
string strDescription = result.Description;
string strSubject = String.Format(Localization.GetString("HelpDeskTicketAtHasBeenupdated.Text", LocalResourceFile), Request.QueryString["TaskID"], PortalSettings.PortalAlias.HTTPAlias);
string strBody = String.Format(Localization.GetString("HelpDeskTicketHasBeenupdated.Text", LocalResourceFile), Request.QueryString["TaskID"], strDescription);
strBody = strBody + Environment.NewLine + Environment.NewLine;
strBody = strBody + Localization.GetString("Comments.Text", LocalResourceFile) + Environment.NewLine;
strBody = strBody + strComment;
strBody = strBody + Environment.NewLine + Environment.NewLine;
strBody = strBody + String.Format(Localization.GetString("YouMaySeeFullStatusHere.Text", LocalResourceFile), strLinkUrl);
DotNetNuke.Services.Mail.Mail.SendMail(PortalSettings.Email, strEmail, "", strSubject, strBody, "", "HTML", "", "", "", "");
Log.InsertLog(Convert.ToInt32(Request.QueryString["TaskID"]), UserId, String.Format(Localization.GetString("RequestorWasEmailed.Text", LocalResourceFile), strEmail, strComment));
}
}
}
// 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();
}
private int GetAssignedRole()
{
int intRole = -1;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails;
if (result != null)
{
intRole = result.FirstOrDefault().AssignedRoleID;
}
return intRole;
}
private void DisplayComment()
{
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();
if (objHelpDesk_TaskDetail != null)
{
txtDescription.Text = objHelpDesk_TaskDetail.Description;
lblDisplayUser.Text = GetUserName(objHelpDesk_TaskDetail.UserID);
lblInsertDate.Text = String.Format("{0} {1}", objHelpDesk_TaskDetail.InsertDate.ToLongDateString(), objHelpDesk_TaskDetail.InsertDate.ToLongTimeString());
chkCommentVisibleEdit.Checked = (objHelpDesk_TaskDetail.DetailType == "Comment") ? false : true;
if (!ViewOnly)
{
ImgEmailUser.Visible = (objHelpDesk_TaskDetail.DetailType == "Comment") ? false : true;
lnkUpdateRequestor.Visible = (objHelpDesk_TaskDetail.DetailType == "Comment") ? false : true;
}
// Only set the Display of the Email to Requestor link if it is already showing
if (lnkUpdateRequestor.Visible)
{
// Only Display Email to Requestor link if chkCommentVisibleEdit is checked
lnkUpdateRequestor.Visible = chkCommentVisibleEdit.Checked;
ImgEmailUser.Visible = chkCommentVisibleEdit.Checked;
}
if (objHelpDesk_TaskDetail.HelpDesk_Attachments.Count > 0)
{
// There is a atachment
pnlAttachFile.Visible = false;
pnlDisplayFile.Visible = true;
lnkFileAttachment.Text = objHelpDesk_TaskDetail.HelpDesk_Attachments.FirstOrDefault().OriginalFileName;
lnkFileAttachment.CommandArgument = objHelpDesk_TaskDetail.HelpDesk_Attachments.FirstOrDefault().AttachmentID.ToString();
/*
#region Attachment URL
var commandArgument = objHelpDesk_TaskDetail.HelpDesk_Attachments.FirstOrDefault().AttachmentID.ToString();
var objHelpDesk_Attachment = objHelpDesk_TaskDetail.HelpDesk_Attachments.FirstOrDefault();
if (objHelpDesk_Attachment != null)
{
var strPath = objHelpDesk_Attachment.AttachmentPath;
var strOriginalFileName = objHelpDesk_Attachment.OriginalFileName;
lnkFileAttachment.Visible = true;
lnkFileAttachment.NavigateUrl = "/DesktopModules/R7.HelpDesk/R7.HelpDesk/Upload/" +
}
else
lnkFileAttachment.Visible = false;
#endregion */
}
else
{
// Only do this if not in View Only Mode
if (!ViewOnly)
{
// There is not a file attached
pnlAttachFile.Visible = true;
pnlDisplayFile.Visible = false;
}
else
{
pnlDisplayFile.Visible = false;
}
}
}
}
// Utility
#region GetEmailOfRequestor
private string GetEmailOfRequestor()
{
string strEmail = "";
int intTaskId = Convert.ToInt32(Request.QueryString["TaskID"]);
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var result = (from HelpDesk_TaskDetails in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_TaskDetails.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_TaskDetails).FirstOrDefault();
if (result != null)
{
if (result.RequesterUserID == -1)
{
try
{
strEmail = result.RequesterEmail;
}
catch (Exception)
{
// User no longer exists
strEmail = "";
}
}
else
{
try
{
strEmail = //UserController.GetUser(PortalId, result.RequesterUserID, false).Email;
UserController.GetUserById(PortalId, result.RequesterUserID).Email;
}
catch (Exception)
{
// User no longer exists
strEmail = "";
}
}
}
return strEmail;
}
protected void lnkFileAttachment_Click(object sender, EventArgs e)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
var objHelpDesk_Attachment = (from HelpDesk_Attachments in objHelpDeskDALDataContext.HelpDesk_Attachments
where HelpDesk_Attachments.AttachmentID == Convert.ToInt32(lnkFileAttachment.CommandArgument)
select HelpDesk_Attachments).FirstOrDefault();
if (objHelpDesk_Attachment != null)
{
string strPath = objHelpDesk_Attachment.AttachmentPath;
string strOriginalFileName = objHelpDesk_Attachment.OriginalFileName;
try
{
Response.Clear();
//Respons.ClearHeaders();
//Response.HeaderEncoding = System.Text.Encoding.UTF8;
// Patch info from here:
// http://gordievskiy.blogspot.ru/2009/12/content-disposition-attachment-filename.html
var attachmentFilename = strOriginalFileName;
//attachmentFilename = Request.Browser.Browser;
if (Request.Browser.Browser.Contains("MSIE") || Request.Browser.Browser.StartsWith("IE"))
{
attachmentFilename = Server.UrlEncode(attachmentFilename);
if (!string.IsNullOrEmpty(attachmentFilename))
attachmentFilename = attachmentFilename.Replace("+", "%20");
}
Response.AddHeader("content-disposition", string.Format("attachment; filename=\"{0}\"", attachmentFilename));
//Response.ClearContent();
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = Utils.GetMimeType(Path.GetExtension(strPath).ToLower());
var sourceFile = new FileStream(strPath, FileMode.Open, FileAccess.Read, FileShare.Read);
var fileSize = (int)sourceFile.Length;
//var reader = new BinaryReader(sourceFile);
/*
// read by 4k blocks
const int blockSize = 4096;
var buffer = new byte[blockSize];
int bytesRead;
var bytesLeft = (int)sourceFile.Length;
do
{
bytesRead = sourceFile.Read(buffer, 0, (bytesLeft > blockSize)? blockSize : bytesLeft);
if (bytesRead > 0)
{
bytesLeft -= bytesRead;
if (bytesRead < blockSize)
Array.Resize<byte>(ref buffer, bytesRead);
Response.BinaryWrite(buffer);
}
} while (bytesLeft >= 0);
sourceFile.Close();
*/
var data = new byte[fileSize];
sourceFile.Read(data, 0, fileSize);
sourceFile.Close();
Response.BinaryWrite(data);
Response.Flush();
Response.Close();
}
catch (Exception ex)
{
// lblError.Text = ex.Message + "<br />" + ex.StackTrace;
Response.Clear();
Response.Write (ex.Message + "<br />" + ex.StackTrace);
Response.Flush();
Response.Close();
}
}
}
private bool CheckSecurity()
{
bool boolPassedSecurity = false;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Task objHelpDesk_Tasks = (from HelpDesk_Tasks in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_Tasks).FirstOrDefault();
if (objHelpDesk_Tasks == null)
{
pnlEditTask.Visible = false;
Response.Redirect(DotNetNuke.Common.Globals.NavigateURL());
}
// User not logged in
if (UserId == -1)
{
// Must have the valid password
if (Request.QueryString["TP"] != null)
{
// Check the password for this Ticket
if (objHelpDesk_Tasks.TicketPassword == Convert.ToString(Request.QueryString["TP"]))
{
boolPassedSecurity = true;
}
else
{
boolPassedSecurity = false;
}
}
}
// User is logged in
if (UserId > -1)
{
// Is user an Admin?
string strAdminRoleID = GetAdminRole();
if (UserInfo.IsInRole(strAdminRoleID) || UserInfo.IsInRole("Administrators") || UserInfo.IsSuperUser)
{
boolPassedSecurity = true;
CommentsControl.ViewOnly = false;
}
// Is user the Requestor?
if (UserId == objHelpDesk_Tasks.RequesterUserID)
{
boolPassedSecurity = true;
}
//Is user in the Assigned Role?
RoleController objRoleController = new RoleController();
RoleInfo objRoleInfo = objRoleController.GetRole(objHelpDesk_Tasks.AssignedRoleID, PortalId);
if (objRoleInfo != null)
{
if (UserInfo.IsInRole(objRoleInfo.RoleName))
{
boolPassedSecurity = true;
CommentsControl.ViewOnly = false;
}
}
// Does user have a valid temporary password?
if (Request.QueryString["TP"] != null)
{
// Check the password for this Ticket
if (objHelpDesk_Tasks.TicketPassword == Convert.ToString(Request.QueryString["TP"]))
{
boolPassedSecurity = true;
}
else
{
boolPassedSecurity = false;
}
}
}
return boolPassedSecurity;
}
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();
}
// Tags
#region DisplayCategoryTree
private void DisplayCategoryTree()
{
bool boolUserAssignedToTask = false;
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_Task objHelpDesk_Tasks = (from HelpDesk_Tasks in objHelpDeskDALDataContext.HelpDesk_Tasks
where HelpDesk_Tasks.TaskID == Convert.ToInt32(Request.QueryString["TaskID"])
select HelpDesk_Tasks).FirstOrDefault();
//Is user in the Assigned Role?
RoleController objRoleController = new RoleController();
RoleInfo objRoleInfo = objRoleController.GetRole(objHelpDesk_Tasks.AssignedRoleID, PortalId);
if (objRoleInfo != null)
{
if (UserInfo.IsInRole(objRoleInfo.RoleName))
{
boolUserAssignedToTask = true;
}
}
if (boolUserAssignedToTask || UserInfo.IsInRole(GetAdminRole()) || UserInfo.IsInRole("Administrators") || UserInfo.IsSuperUser)
{
// Show all Tags
TagsTreeExistingTasks.Visible = true;
TagsTreeExistingTasks.TagID = Convert.ToInt32(Request.QueryString["TaskID"]);
TagsTreeExistingTasks.DisplayType = "Administrator";
TagsTreeExistingTasks.Expand = false;
}
else
{
// Show only Visible Tags
TagsTreeExistingTasks.Visible = true;
TagsTreeExistingTasks.TagID = Convert.ToInt32(Request.QueryString["TaskID"]);
TagsTreeExistingTasks.DisplayType = "Requestor";
TagsTreeExistingTasks.Expand = false;
}
// Select Existing values
if (objHelpDesk_Tasks.HelpDesk_TaskCategories.Select(x => x.CategoryID).ToArray<int>().Count() > 0)
{
int[] ArrStrCategories = objHelpDesk_Tasks.HelpDesk_TaskCategories.Select(x => x.CategoryID).ToArray<int>();
int?[] ArrIntHelpDesk = Array.ConvertAll<int, int?>(ArrStrCategories, new Converter<int, int?>(ConvertToNullableInt));
TagsTreeExistingTasks.SelectedCategories = ArrIntHelpDesk;
}
// Set visibility of Tags
bool RequestorR7_HelpDesk = (TagsTreeExistingTasks.DisplayType == "Administrator") ? false : true;
int CountOfHelpDesk = (from WebserverCategories in CategoriesTable.GetCategoriesTable(PortalId, RequestorR7_HelpDesk)
where WebserverCategories.PortalID == PortalId
where WebserverCategories.Level == 1
select WebserverCategories).Count();
imgTags.Visible = (CountOfHelpDesk > 0);
lbltxtTags.Visible = (CountOfHelpDesk > 0);
}
private void SaveLastSearchCriteria(HelpDesk_LastSearch UpdateHelpDesk_LastSearch)
{
HelpDeskDALDataContext objHelpDeskDALDataContext = new HelpDeskDALDataContext();
HelpDesk_LastSearch objHelpDesk_LastSearch = (from HelpDesk_LastSearches in objHelpDeskDALDataContext.HelpDesk_LastSearches
where HelpDesk_LastSearches.PortalID == PortalId
where HelpDesk_LastSearches.UserID == UserId
select HelpDesk_LastSearches).FirstOrDefault();
if (objHelpDesk_LastSearch == null)
{
objHelpDesk_LastSearch = new HelpDesk_LastSearch();
objHelpDesk_LastSearch.UserID = UserId;
objHelpDesk_LastSearch.PortalID = PortalId;
objHelpDeskDALDataContext.HelpDesk_LastSearches.InsertOnSubmit(objHelpDesk_LastSearch);
objHelpDeskDALDataContext.SubmitChanges();
}
objHelpDesk_LastSearch.AssignedRoleID = UpdateHelpDesk_LastSearch.AssignedRoleID;
objHelpDesk_LastSearch.Categories = UpdateHelpDesk_LastSearch.Categories;
objHelpDesk_LastSearch.CreatedDate = UpdateHelpDesk_LastSearch.CreatedDate;
objHelpDesk_LastSearch.SearchText = UpdateHelpDesk_LastSearch.SearchText;
objHelpDesk_LastSearch.DueDate = UpdateHelpDesk_LastSearch.DueDate;
objHelpDesk_LastSearch.Priority = UpdateHelpDesk_LastSearch.Priority;
objHelpDesk_LastSearch.Status = UpdateHelpDesk_LastSearch.Status;
objHelpDesk_LastSearch.CurrentPage = UpdateHelpDesk_LastSearch.CurrentPage;
objHelpDesk_LastSearch.PageSize = Convert.ToInt32(ddlPageSize.SelectedValue);
objHelpDeskDALDataContext.SubmitChanges();
}
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;
}
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();
}
}
}
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 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;
}
