/// <summary> /// Insert /// </summary> /// <param name="CommentId"></param> /// <returns></returns> public Message Insert(PRComment objUI) { Message msg = null; try { if (objUI != null) { // Set more info dbContext.PRComments.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 SaveControlToDB(FormCollection form, PerformanceReview pr, PRComment comment, bool isInsert) { Message msg = null; List<EForm_Detail> detailList = new List<EForm_Detail>(); string EformID = form.Get("Hidden1"); for (int i = 0; i < form.Count; i++) { string controlID = form.GetKey(i); bool flag = false; foreach (String str in control) { if (controlID.StartsWith(str)) { flag = true; break; } } if (flag) { CRM.Models.EForm_Detail detailItem = new Models.EForm_Detail(); string value = form.Get(controlID); if (controlID.StartsWith("CheckBox")) { value = value.Split(Convert.ToChar(","))[0]; } detailItem.ControlID = controlID; detailItem.Value = value; detailItem.EFormID = Int32.Parse(EformID); detailList.Add(detailItem); } } CRM.Models.EformDao efDao = new EformDao(); msg = isInsert == true ? efDao.Inser(detailList, pr, comment) : efDao.Update(detailList, pr, comment); return msg; }
public Message Inser(List<EForm_Detail> objList, PerformanceReview pr, PRComment comment) { Message msg = null; DbTransaction trans = null; try { dbContext.Connection.Open(); trans = dbContext.Connection.BeginTransaction(); dbContext.Transaction = trans; new PerformanceReviewDao().UpdateResolution(pr, comment); msg = Inser(objList); trans.Commit(); } catch (Exception) { // Show system error msg = new Message(MessageConstants.E0007, MessageType.Error); trans.Rollback(); } return msg; }
public Message Update(List<EForm_Detail> newList, PerformanceReview pr, PRComment comment) { Message msg = null; DbTransaction trans = null; bool canSuccess = true; try { dbContext.Connection.Open(); trans = dbContext.Connection.BeginTransaction(); dbContext.Transaction = trans; List<EForm_Detail> oldList = dbContext.EForm_Details.Where(e => e.EFormID == newList[0].EFormID).ToList(); dbContext.EForm_Details.DeleteAllOnSubmit(oldList); dbContext.EForm_Details.InsertAllOnSubmit(newList); dbContext.SubmitChanges(); new PerformanceReviewDao().UpdateResolution(pr, comment); if (canSuccess) { // Show succes message msg = new Message(MessageConstants.I0001, MessageType.Info, "Interview", "updated"); trans.Commit(); } else { trans.Rollback(); } } catch (Exception) { canSuccess = false; if (trans != null) trans.Rollback(); // Show system error msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }
/// <summary> /// Get list for manager /// </summary> /// <param name="empNameOrId"></param> /// <param name="status"></param> /// <param name="needSetup"></param> /// <returns></returns> public Message UpdateResolution(PerformanceReview objUI, PRComment objComment) { Message msg = null; DbTransaction trans = null; dbContext.Connection.Open(); trans = dbContext.Connection.BeginTransaction(); dbContext.Transaction = trans; try { PerformanceReview objDb = GetById(objUI.ID); if (objDb != null) { objDb.WFResolutionID = objUI.WFResolutionID; objDb.AssignID = objUI.ManagerID; objDb.AssignRole = objUI.AssignRole; objDb.InvolveID = objUI.InvolveID; objDb.InvolveRole = objUI.InvolveRole; objDb.InvolveDate = objUI.InvolveDate; objDb.InvolveResolution = objUI.InvolveResolution; objDb.UpdatedBy = objUI.UpdatedBy; objDb.UpdateDate = DateTime.Now; if (objComment != null) { InsertComment(objComment); } dbContext.SubmitChanges(); msg = new Message(MessageConstants.I0001, MessageType.Info, "Performance Review '" + objUI.ID + "'", "updated"); trans.Commit(); } } catch { if (trans != null) trans.Rollback(); // Show system error msg = new Message(MessageConstants.E0007, MessageType.Error); } return msg; }
/// <summary> /// Insert comment /// </summary> /// <param name="obj"></param> public void InsertComment(PRComment obj) { if (obj != null) { dbContext.PRComments.InsertOnSubmit(obj); dbContext.SubmitChanges(); } }