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;
}
ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();
string strComment = txtComment.Text.Trim();
// Save Task Details
ITILServiceDesk_TaskDetail objITILServiceDesk_TaskDetail = new ITILServiceDesk_TaskDetail();
objITILServiceDesk_TaskDetail.TaskID = TaskID;
objITILServiceDesk_TaskDetail.Description = txtComment.Text.Trim();
objITILServiceDesk_TaskDetail.InsertDate = DateTime.Now;
objITILServiceDesk_TaskDetail.UserID = UserId;
objITILServiceDesk_TaskDetail.DetailType = "Work";
objITILServiceDesk_TaskDetail.StartTime = Convert.ToDateTime(String.Format("{0} {1}", txtStartDay.Text, txtStartTime.Text));
objITILServiceDesk_TaskDetail.StopTime = Convert.ToDateTime(String.Format("{0} {1}", txtStopDay.Text, txtStopTime.Text));
objServiceDeskDALDataContext.ITILServiceDesk_TaskDetails.InsertOnSubmit(objITILServiceDesk_TaskDetail);
objServiceDeskDALDataContext.SubmitChanges();
txtComment.Text = "";
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format("{0} inserted Work comment.", GetUserName()));
gvComments.DataBind();
}
else
{
lblError.Text = Localization.GetString("MustProvideADescription.Text", LocalResourceFile);
}
}
static string GetCommentsOfTicket(int TaskId)
{
string strComments = "";
ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();
ITILServiceDesk_TaskDetail objITILServiceDesk_TaskDetail = (from ITILServiceDesk_TaskDetails in objServiceDeskDALDataContext.ITILServiceDesk_TaskDetails
where ITILServiceDesk_TaskDetails.TaskID == TaskId
where (ITILServiceDesk_TaskDetails.DetailType == "Comment" || ITILServiceDesk_TaskDetails.DetailType == "Comment-Visible")
orderby ITILServiceDesk_TaskDetails.DetailID descending
select ITILServiceDesk_TaskDetails).FirstOrDefault();
if (objITILServiceDesk_TaskDetail != null)
{
strComments = objITILServiceDesk_TaskDetail.Description;
}
return(strComments);
}
private void InsertComment()
{
// Validate file upload
if (TicketFileUpload.HasFile)
{
// ITIL Customization - use DNN host setting for file extension
string fileName = TicketFileUpload.PostedFile.FileName;
string extension = Path.GetExtension(fileName);
if (!Utility.IsAllowedExtension(fileName, extension))
{
string ErrorMessage = string.Format(Localization.GetExceptionMessage("AddFileExtensionNotAllowed", "The extension '{0}' is not allowed. The file has not been added."), extension);
lblError.Text = ErrorMessage;
return;
}
}
if (txtComment.Text.Trim().Length > 0)
{
ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();
string strComment = txtComment.Text.Trim();
// Save Task Details
ITILServiceDesk_TaskDetail objITILServiceDesk_TaskDetail = new ITILServiceDesk_TaskDetail();
objITILServiceDesk_TaskDetail.TaskID = TaskID;
objITILServiceDesk_TaskDetail.Description = txtComment.Text.Trim();
objITILServiceDesk_TaskDetail.InsertDate = DateTime.Now;
objITILServiceDesk_TaskDetail.UserID = UserId;
if (chkCommentVisible.Checked)
{
objITILServiceDesk_TaskDetail.DetailType = "Comment-Visible";
}
else
{
objITILServiceDesk_TaskDetail.DetailType = "Comment";
}
objServiceDeskDALDataContext.ITILServiceDesk_TaskDetails.InsertOnSubmit(objITILServiceDesk_TaskDetail);
objServiceDeskDALDataContext.SubmitChanges();
txtComment.Text = "";
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format("{0} inserted comment.", GetUserName()));
// Upload the File
if (TicketFileUpload.HasFile)
{
UploadFile(objITILServiceDesk_TaskDetail.DetailID);
// Insert Log
Log.InsertLog(TaskID, UserId, String.Format("{0} uploaded file '{1}'.", GetUserName(), TicketFileUpload.FileName));
}
if (UserIsRequestor())
{
NotifyAssignedGroupOfComment(strComment);
}
gvComments.DataBind();
}
}
