/// <summary> /// Insert /// </summary> /// <param name="CommentId"></param> /// <returns></returns> public Message Insert(JobRequestComment objUI) { Message msg = null; try { if (objUI != null) { // Set more info dbContext.JobRequestComments.InsertOnSubmit(objUI); dbContext.SubmitChanges(); // Show success message msg = new Message(MessageConstants.I0001, MessageType.Info, objUI.Poster,"added a comment"); } } catch { // Show system error msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }
public Message UpdateForApproval(JobRequest objUI, JobRequestComment objComment) { Message msg = null; DbTransaction trans = null; try { dbContext.Connection.Open(); trans = dbContext.Connection.BeginTransaction(); dbContext.Transaction = trans; if (objUI != null) { JobRequest objDb = GetById(objUI.ID); if (objDb != null) { #region Insert Comment if (objComment != null && !string.IsNullOrEmpty(objComment.Contents)) { JRCommentDao commentDao = new JRCommentDao(); commentDao.Insert(objComment); } #endregion // Check valid update date if (IsValidUpdateDate(objUI, objDb, out msg)) { new JobRequestLogDao().WriteUpdateLogForRoleManager(objUI, ELogAction.Update); objDb.WFResolutionID = objUI.WFResolutionID; //if (!string.IsNullOrEmpty(objUI.Approval)) //{ // objDb.Approval = objUI.Approval; //} objDb.WFResolution = objUI.WFResolution; objDb.AssignID = objUI.AssignID; objDb.AssignRole = objUI.AssignRole; objDb.InvolveID = objUI.InvolveID; objDb.InvolveRole = objUI.InvolveRole; objDb.InvolveDate = objUI.InvolveDate; objDb.UpdateDate = DateTime.Now; dbContext.SubmitChanges(); msg = new Message(MessageConstants.I0001, MessageType.Info, " Job Request '" + Constants.JOB_REQUEST_PREFIX + objUI.ID + "'", "updated"); trans.Commit(); } else { trans.Rollback(); } } } } catch { // Rollback transaction if (trans != null) { trans.Rollback(); } // Show system error msg = new Message(MessageConstants.E0007, MessageType.Error); } finally { if ((trans.Connection != null) && (trans.Connection.State == System.Data.ConnectionState.Open)) { trans.Connection.Close(); } } return msg; }