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