public static bool UpdateApproversAndTasks(PMS.Model.DTO.Appraisal.Appraisal appraisal, List<PMS.Model.DTO.Appraisal.Approver> approvers, List<PMS.Model.DTO.Core.Task.Owner> taskOwners, out string message, out List<Model.DTO.Appraisal.Approver> oldApprovers) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); oldApprovers = null; try { if (!Lib.Utility.Common.IsNullOrEmptyList(approvers)) { oldApprovers = new List<DTO.Appraisal.Approver>(); IEnumerable<Model.Context.PMS_APPRAISAL_APPROVER> lst_approver_entities = from ent_approvers in dc_pms.PMS_APPRAISAL_APPROVER where ent_approvers.APPRAISAL_ID == appraisal.Id select ent_approvers; foreach (Model.Context.PMS_APPRAISAL_APPROVER ent_approver in lst_approver_entities) { oldApprovers.Add(Model.Mappers.PMSMapper.MapApproverEntityToDTO(ent_approver)); foreach (PMS.Model.DTO.Appraisal.Approver obj_approver in approvers) { if (ent_approver.ID == obj_approver.Id) { ent_approver.APPROVER_ID = obj_approver.EmployeeId; ent_approver.APPROVAL_LEVEL = obj_approver.ApprovalLevel; } } } if (!Lib.Utility.Common.IsNullOrEmptyList(taskOwners)) { List<Int32> lst_task_owner_ids = new List<Int32>(); foreach (PMS.Model.DTO.Core.Task.Owner obj_owners in taskOwners) { lst_task_owner_ids.Add(obj_owners.Id); } IEnumerable<Model.Context.TASK_OWNER> lst_owner_entities = dc_pms.TASK_OWNER.Where(rec => lst_task_owner_ids.Contains(rec.ID)); if (!Lib.Utility.Common.IsNullOrEmptyList(lst_owner_entities)) { foreach (Model.Context.TASK_OWNER ent_owner in lst_owner_entities) { foreach (PMS.Model.DTO.Core.Task.Owner obj_owners in taskOwners) { if (ent_owner.ID == obj_owners.Id) { ent_owner.EMPLOYEE_ID = obj_owners.EmployeeId; } } } } } dc_pms.SaveChanges(); } boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateCycle(PMS.Model.DTO.Cycle.Cycle cycle, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { foreach (PMS.Model.DTO.Cycle.Stage stage in cycle.CycleStages) { PMS.Model.Context.PMS_CYCLE_STAGE entity_cycle_stage = dc_pms.PMS_CYCLE_STAGE.FirstOrDefault(sec => sec.ID == stage.Id); entity_cycle_stage.START_DATE = stage.StartDate; entity_cycle_stage.END_DATE = stage.EndDate; } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalPerformanceCoachingComment(List<PMS.Model.DTO.Appraisal.PerformanceCoachingComment> updateList, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { if (!Lib.Utility.Common.IsNullOrEmptyList(updateList)) { foreach (PMS.Model.DTO.Appraisal.PerformanceCoachingComment obj_comment in updateList) { PMS.Model.Context.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT ent_comment = dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT.Where(rec => rec.ITEM_ID == obj_comment.AppraisalPerformanceCoaching.Id && rec.COMMENTED_BY_ID == obj_comment.Commentor.Id && rec.FORM_SAVE_ONLY == true).SingleOrDefault(); if (ent_comment != null) { if (!string.IsNullOrEmpty(obj_comment.Comments)) { ent_comment.COMMENT = obj_comment.Comments; ent_comment.COMMENTED_TIMESTAMP = obj_comment.CommentedTimestamp; } else { dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT.DeleteObject(ent_comment); } } else { if (!string.IsNullOrEmpty(obj_comment.Comments)) { ent_comment = Mappers.PMSMapper.MapAppraisalPerformanceCoachingCommentDTOToEntity(obj_comment); dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT.AddObject(ent_comment); } } } dc_pms.SaveChanges(); boo_success = true; } } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalPerformanceCoachingProgress(PMS.Model.DTO.Appraisal.PerformanceCoaching performanceCoaching, out string message) { bool boo_success = false; message = string.Empty; Model.Context.PMS_APPRAISAL_PERFORMANCE_COACHING entity; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { if (performanceCoaching != null) { entity = dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING.Where(rec => rec.APPRAISAL_ID == performanceCoaching.Appraisal.Id).SingleOrDefault(); entity.PROGRESS_UPDATE = performanceCoaching.Progress; dc_pms.SaveChanges(); boo_success = true; } } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool DeleteApprisalInCyle(List<int> cids, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { foreach (int cid in cids) { foreach (var item in dc_pms.PMS_APPRAISAL_TRAIL.Where(sec => sec.APPRAISAL_ID == cid)) { dc_pms.PMS_APPRAISAL_TRAIL.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_SECTION.Where(sec => sec.APPRAISAL_ID == cid)) { foreach (var childitem in dc_pms.PMS_APPRAISAL_SECTION_COMMENT.Where(sec => sec.SECTION_ID == item.ID)) { dc_pms.PMS_APPRAISAL_SECTION_COMMENT.DeleteObject(childitem); } dc_pms.PMS_APPRAISAL_SECTION.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_APPROVER.Where(sec => sec.APPRAISAL_ID == cid)) { dc_pms.PMS_APPRAISAL_APPROVER.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_STAGE.Where(sec => sec.APPRAISAL_ID == cid)) { dc_pms.PMS_APPRAISAL_STAGE.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_REVIEWER.Where(sec => sec.APPRAISAL_ID == cid)) { dc_pms.PMS_APPRAISAL_REVIEWER.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING.Where(sec => sec.APPRAISAL_ID == cid)) { foreach (var childitem in dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT.Where(sec => sec.ITEM_ID == item.ID)) { dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT.DeleteObject(childitem); } dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_KPI.Where(sec => sec.APPRAISAL_ID == cid)) { foreach (var childitem in dc_pms.PMS_APPRAISAL_KPI_COMMENT.Where(sec => sec.ITEM_ID == item.ID)) { dc_pms.PMS_APPRAISAL_KPI_COMMENT.DeleteObject(childitem); } dc_pms.PMS_APPRAISAL_KPI.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_CORE_VALUE.Where(sec => sec.APPRAISAL_ID == cid)) { foreach (var childitem in dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.Where(sec => sec.ITEM_ID == item.ID)) { dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.DeleteObject(childitem); } dc_pms.PMS_APPRAISAL_CORE_VALUE.DeleteObject(item); } foreach (var item in dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT.Where(sec => sec.APPRAISAL_ID == cid)) { foreach (var childitem in dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT_COMMENT.Where(sec => sec.ITEM_ID == item.ID)) { dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT_COMMENT.DeleteObject(childitem); } dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT.DeleteObject(item); } foreach (var item in dc_pms.TASKs.Where(sec => sec.RECORD_ID == cid && sec.MODULE_ID == eHR.PMS.Model.PMSConstants.MODULE_ID_PMS)) { foreach (var childitem in dc_pms.TASK_OWNER.Where(sec => sec.TASK_ID == item.ID)) { dc_pms.TASK_OWNER.DeleteObject(childitem); } dc_pms.TASKs.DeleteObject(item); } var appr = dc_pms.PMS_APPRAISAL.Where(sec => sec.ID == cid).FirstOrDefault(); dc_pms.PMS_APPRAISAL.DeleteObject(appr); } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalAndTask(PMS.Model.DTO.Appraisal.Appraisal appraisal, List<DTO.Core.Task.Task> completedTasks, List<DTO.Core.Task.Task> newTasks, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { Model.Context.PMS_APPRAISAL entity_appraisal = (from ent_appraisal in dc_pms.PMS_APPRAISAL where ent_appraisal.ID == appraisal.Id select ent_appraisal).SingleOrDefault(); entity_appraisal.STAGE_ID = appraisal.Stage.Id; entity_appraisal.STATUS_ID = appraisal.Status.Id; foreach (DTO.Core.Task.Task obj_task in completedTasks) { Model.Context.TASK entity_task = (from ent_task in dc_pms.TASKs where ent_task.ID == obj_task.Id select ent_task).SingleOrDefault(); entity_task.STATUS_ID = obj_task.Status.Id; } foreach (DTO.Core.Task.Task obj_task in newTasks) { Model.Context.TASK entity_task = Mappers.CoreMapper.MapTaskDTOToEntity(obj_task); dc_pms.TASKs.AddObject(entity_task); foreach (DTO.Core.Task.Owner obj_owner in obj_task.Owners) { Model.Context.TASK_OWNER entity_owner = Model.Mappers.CoreMapper.MapTaskOwnerDTOToEntity(obj_owner); entity_owner.TASK_ID = entity_task.ID; dc_pms.TASK_OWNER.AddObject(entity_owner); } } foreach (Model.DTO.Appraisal.Trail dto_appraisal_trail in appraisal.Trails) { if (dto_appraisal_trail.Id < 1) { Model.Context.PMS_APPRAISAL_TRAIL entity_appraisal_trail = Model.Mappers.PMSMapper.MapAppraisalTrailDTOToEntity(dto_appraisal_trail); entity_appraisal_trail.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_TRAIL.AddObject(entity_appraisal_trail); } } var lst_kpi_comments = dc_pms.PMS_APPRAISAL_KPI_COMMENT.Where(rec => rec.FORM_SAVE_ONLY == true); if (!Lib.Utility.Common.IsNullOrEmptyList(lst_kpi_comments)) { foreach (Context.PMS_APPRAISAL_KPI_COMMENT ent_comment in lst_kpi_comments) { if (string.IsNullOrEmpty(ent_comment.COMMENT)) { dc_pms.DeleteObject(ent_comment); } else { ent_comment.FORM_SAVE_ONLY = false; } } } var lst_core_value_comments = dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.Where(rec => rec.FORM_SAVE_ONLY == true); if (!Lib.Utility.Common.IsNullOrEmptyList(lst_core_value_comments)) { foreach (Context.PMS_APPRAISAL_CORE_VALUE_COMMENT ent_comment in lst_core_value_comments) { if (string.IsNullOrEmpty(ent_comment.COMMENT)) { dc_pms.DeleteObject(ent_comment); } else { ent_comment.FORM_SAVE_ONLY = false; } } } var lst_performance_coaching_comments = dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT.Where(rec => rec.FORM_SAVE_ONLY == true); if (!Lib.Utility.Common.IsNullOrEmptyList(lst_performance_coaching_comments)) { foreach (Context.PMS_APPRAISAL_PERFORMANCE_COACHING_COMMENT ent_comment in lst_performance_coaching_comments) { if (string.IsNullOrEmpty(ent_comment.COMMENT)) { dc_pms.DeleteObject(ent_comment); } else { ent_comment.FORM_SAVE_ONLY = false; } } } var lst_career_development_comments = dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT_COMMENT.Where(rec => rec.FORM_SAVE_ONLY == true); if (!Lib.Utility.Common.IsNullOrEmptyList(lst_career_development_comments)) { foreach (Context.PMS_APPRAISAL_CAREER_DEVELOPMENT_COMMENT ent_comment in lst_career_development_comments) { if (string.IsNullOrEmpty(ent_comment.COMMENT)) { dc_pms.DeleteObject(ent_comment); } else { ent_comment.FORM_SAVE_ONLY = false; } } } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalKPICommentForAjax(List<PMS.Model.DTO.Appraisal.KPIComment> updateList, List<PMS.Model.DTO.Appraisal.KPIComment> deleteList, out string message, out string newcommentsidarray) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); newcommentsidarray = string.Empty; StringBuilder sb_newkpiids = new StringBuilder(); try { if (!Lib.Utility.Common.IsNullOrEmptyList(updateList)) { foreach (PMS.Model.DTO.Appraisal.KPIComment obj_comment in updateList) { // there should only be 1 new comment for each appraisal kpi item PMS.Model.Context.PMS_APPRAISAL_KPI_COMMENT ent_comment = dc_pms.PMS_APPRAISAL_KPI_COMMENT.Where(rec => rec.ITEM_ID == obj_comment.AppraisalKPI.Id && rec.COMMENTED_BY_ID == obj_comment.Commentor.Id && rec.FORM_SAVE_ONLY == true).SingleOrDefault(); if (ent_comment != null) { if (!string.IsNullOrEmpty(obj_comment.Comments)) { ent_comment.COMMENT = obj_comment.Comments; ent_comment.COMMENTED_TIMESTAMP = obj_comment.CommentedTimestamp; } } else { ent_comment = Mappers.PMSMapper.MapAppraisalKPICommentDTOToEntity(obj_comment); dc_pms.PMS_APPRAISAL_KPI_COMMENT.AddObject(ent_comment); dc_pms.SaveChanges(); sb_newkpiids.Append(ent_comment.ID.ToString() + "-"); } } } if (!Lib.Utility.Common.IsNullOrEmptyList(deleteList)) { foreach (PMS.Model.DTO.Appraisal.KPIComment obj_comment in deleteList) { PMS.Model.Context.PMS_APPRAISAL_KPI_COMMENT ent_comment = dc_pms.PMS_APPRAISAL_KPI_COMMENT.Where(s => s.ID == obj_comment.Id).Single(); dc_pms.PMS_APPRAISAL_KPI_COMMENT.DeleteObject(ent_comment); } } dc_pms.SaveChanges(); newcommentsidarray = sb_newkpiids.ToString(); if (!string.IsNullOrEmpty(newcommentsidarray)) newcommentsidarray = newcommentsidarray.Substring(0, newcommentsidarray.Length - 1); boo_success = true; } catch (Exception exc) { message = exc.Message; boo_success = false; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateReviewersForAppraisal(int appraisalId, List<DTO.Appraisal.Reviewer> reviewers, out string message, out List<DTO.Appraisal.Reviewer> oldReviewers) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); oldReviewers = null; try { // remove all reviewers for appraisal IEnumerable<Model.Context.PMS_APPRAISAL_REVIEWER> lst_ent_reviewers = from ent_reviewers in dc_pms.PMS_APPRAISAL_REVIEWER where ent_reviewers.APPRAISAL_ID == appraisalId && ent_reviewers.IS_SMT == false select ent_reviewers; if (!Lib.Utility.Common.IsNullOrEmptyList(lst_ent_reviewers)) { oldReviewers = new List<DTO.Appraisal.Reviewer>(); foreach (Model.Context.PMS_APPRAISAL_REVIEWER ent_reviewer in lst_ent_reviewers) { oldReviewers.Add(Model.Mappers.PMSMapper.MapReviewerEntityToDTO(ent_reviewer)); dc_pms.PMS_APPRAISAL_REVIEWER.DeleteObject(ent_reviewer); } } // add new reviewers if (!Lib.Utility.Common.IsNullOrEmptyList(reviewers)) { foreach (DTO.Appraisal.Reviewer obj_reviewer in reviewers) { dc_pms.PMS_APPRAISAL_REVIEWER.AddObject(Mappers.PMSMapper.MapReviewerDTOTOEntity(obj_reviewer)); } } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalCoreValueComment(List<PMS.Model.DTO.Appraisal.CoreValueComment> updateList,List<PMS.Model.DTO.Appraisal.CoreValueComment> deleteList, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); bool updateflag = false; try { if (!Lib.Utility.Common.IsNullOrEmptyList(updateList)) { updateflag = true; foreach (PMS.Model.DTO.Appraisal.CoreValueComment obj_comment in updateList) { // there should only be 1 new comment for each appraisal kpi item PMS.Model.Context.PMS_APPRAISAL_CORE_VALUE_COMMENT ent_comment = dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.Where(rec => rec.ITEM_ID == obj_comment.AppraisalCoreValue.Id && rec.COMMENTED_BY_ID == obj_comment.Commentor.Id && rec.FORM_SAVE_ONLY == true).SingleOrDefault(); if (ent_comment != null) { ent_comment.COMMENT = obj_comment.Comments; ent_comment.COMMENTED_TIMESTAMP = obj_comment.CommentedTimestamp; } else { ent_comment = Mappers.PMSMapper.MapAppraisalCoreValueCommentDTOToEntity(obj_comment); dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.AddObject(ent_comment); } } } if (!Lib.Utility.Common.IsNullOrEmptyList(deleteList)) { updateflag = true; foreach (PMS.Model.DTO.Appraisal.CoreValueComment obj_comment in deleteList) { PMS.Model.Context.PMS_APPRAISAL_CORE_VALUE_COMMENT ent_comment = dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.Where(s => s.ID == obj_comment.Id).Single(); dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.DeleteObject(ent_comment); } } if(updateflag) dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalCoreValues(List<PMS.Model.DTO.Appraisal.CoreValue> insertList, List<PMS.Model.DTO.Appraisal.CoreValue> updateList, List<PMS.Model.DTO.Appraisal.CoreValue> deleteList, out string message) { bool boo_success = false; message = string.Empty; int int_appraisal_id = 0; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { if (!Lib.Utility.Common.IsNullOrEmptyList(insertList)) { foreach (PMS.Model.DTO.Appraisal.CoreValue obj_core_value in insertList) { dc_pms.PMS_APPRAISAL_CORE_VALUE.AddObject(Mappers.PMSMapper.MapAppraisalCoreValueDTOToEntity(obj_core_value)); int_appraisal_id = obj_core_value.Appraisal.Id; } } if (!Lib.Utility.Common.IsNullOrEmptyList(deleteList)) { foreach (PMS.Model.DTO.Appraisal.CoreValue obj_core_value in deleteList) { foreach (PMS.Model.Context.PMS_APPRAISAL_CORE_VALUE_COMMENT ent_comment in dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.Where(rec => rec.ITEM_ID == obj_core_value.Id)) { dc_pms.PMS_APPRAISAL_CORE_VALUE_COMMENT.DeleteObject(ent_comment); } Model.Context.PMS_APPRAISAL_CORE_VALUE entity = dc_pms.PMS_APPRAISAL_CORE_VALUE.Where(rec => rec.ID == obj_core_value.Id).Single(); dc_pms.PMS_APPRAISAL_CORE_VALUE.DeleteObject(entity); if (int_appraisal_id == 0) { int_appraisal_id = obj_core_value.Appraisal.Id; } } } if (!Lib.Utility.Common.IsNullOrEmptyList(updateList)) { foreach (PMS.Model.DTO.Appraisal.CoreValue obj_core_value in updateList) { Model.Context.PMS_APPRAISAL_CORE_VALUE entity = dc_pms.PMS_APPRAISAL_CORE_VALUE.Where(rec => rec.ID == obj_core_value.Id).Single(); //entity.COMPETENCY_MASTER_ID = obj_core_value.CoreValueCompetency.Id; entity.TARGET = obj_core_value.Target; entity.LEVEL_1_SCORE = obj_core_value.Level1Score; entity.LEVEL_2_SCORE = obj_core_value.Level2Score; entity.SELF_SCORE = obj_core_value.SelfScore; if (int_appraisal_id == 0) { int_appraisal_id = obj_core_value.Appraisal.Id; } } } if (int_appraisal_id > 0) { Model.Context.PMS_APPRAISAL ent_appraisal = dc_pms.PMS_APPRAISAL.Where(rec => rec.ID == int_appraisal_id).Single(); if (ent_appraisal.STATUS_ID == Model.PMSConstants.STATUS_ID_NEW) { ent_appraisal.STATUS_ID = PMS.Model.PMSConstants.STATUS_ID_DRAFT; } } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalCareerDevelopmentProgress(PMS.Model.DTO.Appraisal.CareerDevelopment careerDevelopment, out string message) { bool boo_success = false; message = string.Empty; Model.Context.PMS_APPRAISAL_CAREER_DEVELOPMENT entity; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { if (careerDevelopment != null) { entity = dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT.Where(rec => rec.APPRAISAL_ID == careerDevelopment.Appraisal.Id).SingleOrDefault(); entity.PROGRESS_UPDATE = careerDevelopment.Progress; dc_pms.SaveChanges(); boo_success = true; } } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalCareerDevelopment(PMS.Model.DTO.Appraisal.CareerDevelopment careerDevelopment, out string message) { bool boo_success = false; message = string.Empty; int int_appraisal_id = 0; Model.Context.PMS_APPRAISAL_CAREER_DEVELOPMENT entity; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { if (careerDevelopment != null) { entity = dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT.Where(rec => rec.APPRAISAL_ID == careerDevelopment.Appraisal.Id).SingleOrDefault(); if (entity == null) { entity = Mappers.PMSMapper.MapAppraisalCareerDevelopmentDTOToEntity(careerDevelopment); dc_pms.PMS_APPRAISAL_CAREER_DEVELOPMENT.AddObject(entity); } else { entity.SHORT_TERM_GOALS = careerDevelopment.ShortTermGoals; entity.LEARNING_PLAN = careerDevelopment.LearningPlans; entity.CAREER_PLAN = careerDevelopment.CareerPlans; } int_appraisal_id = careerDevelopment.Appraisal.Id; if (int_appraisal_id > 0) { Model.Context.PMS_APPRAISAL ent_appraisal = dc_pms.PMS_APPRAISAL.Where(rec => rec.ID == int_appraisal_id).Single(); if (ent_appraisal.STATUS_ID == Model.PMSConstants.STATUS_ID_NEW) { ent_appraisal.STATUS_ID = PMS.Model.PMSConstants.STATUS_ID_DRAFT; } } dc_pms.SaveChanges(); boo_success = true; } } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool AppraisalStageManager(List<DTO.Cycle.Cycle> cycles, List<DTO.Appraisal.Appraisal> appraisals, List<DTO.Core.Task.Task> newTasks, List<DTO.Core.Task.Task> deleteTasks) { bool boo_success = false; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); Model.Context.PMS_CYCLE ent_cycle; Model.Context.PMS_APPRAISAL ent_appraisal; if (!Lib.Utility.Common.IsNullOrEmptyList(cycles)) { foreach (Model.DTO.Cycle.Cycle obj_cycle in cycles) { ent_cycle = (from cyc in dc_pms.PMS_CYCLE where cyc.ID == obj_cycle.Id select cyc).Single(); ent_cycle.STAGE_ID = obj_cycle.Stage.Id; } } if (!Lib.Utility.Common.IsNullOrEmptyList(appraisals)) { foreach (DTO.Appraisal.Appraisal obj_appraisal in appraisals) { ent_appraisal = (from appr in dc_pms.PMS_APPRAISAL where appr.ID == obj_appraisal.Id select appr).Single(); ent_appraisal.STAGE_ID = obj_appraisal.Stage.Id; ent_appraisal.STATUS_ID = obj_appraisal.Status.Id; ent_appraisal.LOCKED = obj_appraisal.Locked; if (!Lib.Utility.Common.IsNullOrEmptyList(obj_appraisal.Trails)) { foreach (Model.DTO.Appraisal.Trail obj_trail in obj_appraisal.Trails) { if (obj_trail.Id == 0) { dc_pms.PMS_APPRAISAL_TRAIL.AddObject(Mappers.PMSMapper.MapAppraisalTrailDTOToEntity(obj_trail)); } } } } } dc_pms.SaveChanges(); if (!Lib.Utility.Common.IsNullOrEmptyList(newTasks)) { foreach (DTO.Core.Task.Task obj_task in newTasks) { Model.Context.TASK ent_task = Mappers.CoreMapper.MapTaskDTOToEntity(obj_task); dc_pms.TASKs.AddObject(ent_task); dc_pms.SaveChanges(); foreach (DTO.Core.Task.Owner obj_owner in obj_task.Owners) { Model.Context.TASK_OWNER ent_owner = Mappers.CoreMapper.MapTaskOwnerDTOToEntity(obj_owner); ent_owner.TASK_ID = ent_task.ID; dc_pms.TASK_OWNER.AddObject(ent_owner); } } dc_pms.SaveChanges(); } if (!Lib.Utility.Common.IsNullOrEmptyList(deleteTasks)) { foreach (DTO.Core.Task.Task obj_task in deleteTasks) { dc_pms.DeleteObject(Mappers.CoreMapper.MapTaskDTOToEntity(obj_task)); } dc_pms.SaveChanges(); } boo_success = true; return boo_success; }
public static bool UpdateCycleAndCreateAppraisalTasks(PMS.Model.DTO.Cycle.Cycle cycle, int cycleId, out string message,out List<DTO.Appraisal.Appraisal> NewAddAppraisals) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); NewAddAppraisals = new List<DTO.Appraisal.Appraisal>(); try { List<PMS.Model.Context.PMS_CYCLE_STAGE> stages = dc_pms.PMS_CYCLE_STAGE.Where(sec => sec.CYCLE_ID == cycleId).OrderBy(sec=>sec.STAGE_ID).ToList(); int index = 0; foreach (PMS.Model.Context.PMS_CYCLE_STAGE stage in stages) { stage.START_DATE = cycle.CycleStages[index].StartDate; stage.END_DATE = cycle.CycleStages[index].EndDate; index++; } dc_pms.SaveChanges(); message = Convert.ToString(cycleId); foreach (Model.DTO.Appraisal.Appraisal dto_appraisal in cycle.Appriasals) { Model.Context.PMS_APPRAISAL entity_appraisal = Mappers.PMSMapper.MapAppraisalDTOToEntity(dto_appraisal); entity_appraisal.CYCLE_ID = cycleId; dc_pms.PMS_APPRAISAL.AddObject(entity_appraisal); dc_pms.SaveChanges(); foreach (Model.DTO.Appraisal.Section dto_appraisal_section in dto_appraisal.AppraisalSections) { Model.Context.PMS_APPRAISAL_SECTION entity_appraisal_section = Model.Mappers.PMSMapper.MapAppraisalSectionDTOToEntity(dto_appraisal_section); entity_appraisal_section.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_SECTION.AddObject(entity_appraisal_section); } foreach (Model.DTO.Appraisal.Stage dto_appraisal_stage in dto_appraisal.AppraisalStages) { Model.Context.PMS_APPRAISAL_STAGE entity_appraisal_stage = Model.Mappers.PMSMapper.MapAppraisalStageDTOToEntity(dto_appraisal_stage); entity_appraisal_stage.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_STAGE.AddObject(entity_appraisal_stage); } foreach (Model.DTO.Appraisal.Trail dto_appraisal_trail in dto_appraisal.Trails) { Model.Context.PMS_APPRAISAL_TRAIL entity_appraisal_trail = Model.Mappers.PMSMapper.MapAppraisalTrailDTOToEntity(dto_appraisal_trail); entity_appraisal_trail.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_TRAIL.AddObject(entity_appraisal_trail); } foreach (Model.DTO.Appraisal.Approver dto_appraisal_approver in dto_appraisal.Approvers) { Model.Context.PMS_APPRAISAL_APPROVER entity_appraisal_approver = Model.Mappers.PMSMapper.MapApproverDTOToEntity(dto_appraisal_approver); entity_appraisal_approver.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_APPROVER.AddObject(entity_appraisal_approver); } if (!Lib.Utility.Common.IsNullOrEmptyList(dto_appraisal.Reviewers)) { foreach (Model.DTO.Appraisal.Reviewer dto_appraisal_reviewer in dto_appraisal.Reviewers) { Model.Context.PMS_APPRAISAL_REVIEWER entity_appraisal_reviewer = Model.Mappers.PMSMapper.MapReviewerDTOTOEntity(dto_appraisal_reviewer); entity_appraisal_reviewer.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_REVIEWER.AddObject(entity_appraisal_reviewer); } } NewAddAppraisals.Add(Mappers.PMSMapper.MapAppraisalEntityToDTO(entity_appraisal, true)); /* if (dto_appraisal.Task != null) { Model.Context.TASK entity_task = Mappers.CoreMapper.MapTaskDTOToEntity(dto_appraisal.Task); entity_task.RECORD_ID = entity_appraisal.ID; dc_pms.TASKs.AddObject(entity_task); foreach (Model.DTO.Core.Task.Owner obj_owner in dto_appraisal.Task.Owners) { Model.Context.TASK_OWNER entity_owner = Mappers.CoreMapper.MapTaskOwnerDTOToEntity(obj_owner); entity_owner.TASK_ID = entity_task.ID; dc_pms.TASK_OWNER.AddObject(entity_owner); } } */ } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalKPIProgress(List<PMS.Model.DTO.Appraisal.KPI> updateList, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { if (!Lib.Utility.Common.IsNullOrEmptyList(updateList)) { foreach (PMS.Model.DTO.Appraisal.KPI obj_kpi in updateList) { Model.Context.PMS_APPRAISAL_KPI entity = dc_pms.PMS_APPRAISAL_KPI.Where(rec => rec.ID == obj_kpi.Id).Single(); entity.PROGRESS_UPDATE = obj_kpi.Progress; } } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateCycleStages(List<PMS.Model.DTO.Cycle.Stage> cycleStages, List<PMS.Model.DTO.Appraisal.Appraisal> appraisals, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { foreach (PMS.Model.DTO.Cycle.Stage obj_cycle_stage in cycleStages) { PMS.Model.Context.PMS_CYCLE_STAGE ent_cycle_stage = dc_pms.PMS_CYCLE_STAGE.Where(rec => rec.ID == obj_cycle_stage.Id).Single(); ent_cycle_stage.START_DATE = obj_cycle_stage.StartDate; ent_cycle_stage.END_DATE = obj_cycle_stage.EndDate; ent_cycle_stage.PRE_START_EMAIL_SENT = obj_cycle_stage.PreStartEmailSent; ent_cycle_stage.SUBMISSION_DEADLINE = obj_cycle_stage.SubmissionDeadline; ent_cycle_stage.LEVEL_1_APPROVAL_DEADLINE = obj_cycle_stage.Level1ApprovalDeadline; ent_cycle_stage.LEVEL_2_APPROVAL_DEADLINE = obj_cycle_stage.Level2ApprovalDeadline; } if (!Lib.Utility.Common.IsNullOrEmptyList(appraisals)) { foreach (PMS.Model.DTO.Appraisal.Appraisal obj_appraisal in appraisals) { foreach (PMS.Model.DTO.Appraisal.Stage obj_appraisal_stage in obj_appraisal.AppraisalStages) { PMS.Model.Context.PMS_APPRAISAL_STAGE ent_appraisal_stage = dc_pms.PMS_APPRAISAL_STAGE.Where(rec => rec.ID == obj_appraisal_stage.Id).Single(); ent_appraisal_stage.START_DATE = obj_appraisal_stage.StartDate; ent_appraisal_stage.END_DATE = obj_appraisal_stage.EndDate; ent_appraisal_stage.SUBMISSION_DEADLINE = obj_appraisal_stage.SubmissionDeadline; ent_appraisal_stage.LEVEL_1_APPROVAL_DEADLINE = obj_appraisal_stage.Level1ApprovalDeadline; ent_appraisal_stage.LEVEL_2_APPROVAL_DEADLINE = obj_appraisal_stage.Level2ApprovalDeadline; } } } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalKPIsForAjax(List<PMS.Model.DTO.Appraisal.KPI> insertList, List<PMS.Model.DTO.Appraisal.KPI> updateList, List<PMS.Model.DTO.Appraisal.KPI> deleteList, out string message,out string newkpiids) { bool boo_success = false; message = string.Empty; int int_appraisal_id = 0; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); newkpiids = string.Empty; StringBuilder sb_newkpiids=new StringBuilder(); try { if (!Lib.Utility.Common.IsNullOrEmptyList(deleteList)) { foreach (PMS.Model.DTO.Appraisal.KPI obj_kpi in deleteList) { foreach (PMS.Model.Context.PMS_APPRAISAL_KPI_COMMENT ent_comment in dc_pms.PMS_APPRAISAL_KPI_COMMENT.Where(rec => rec.ITEM_ID == obj_kpi.Id)) { dc_pms.PMS_APPRAISAL_KPI_COMMENT.DeleteObject(ent_comment); } Model.Context.PMS_APPRAISAL_KPI entity = dc_pms.PMS_APPRAISAL_KPI.Where(rec => rec.ID == obj_kpi.Id).Single(); dc_pms.PMS_APPRAISAL_KPI.DeleteObject(entity); //if (int_appraisal_id == 0) { int_appraisal_id = obj_kpi.Appraisal.Id; } } } PMS.Model.Context.PMS_APPRAISAL_KPI tempentity=new Context.PMS_APPRAISAL_KPI(); if (!Lib.Utility.Common.IsNullOrEmptyList(insertList)) { foreach (PMS.Model.DTO.Appraisal.KPI obj_kpi in insertList) { tempentity=Mappers.PMSMapper.MapAppraisalKPIDTOToEntity(obj_kpi); dc_pms.PMS_APPRAISAL_KPI.AddObject(tempentity); dc_pms.SaveChanges(); int_appraisal_id = obj_kpi.Appraisal.Id; sb_newkpiids.Append(tempentity.ID.ToString() + "-"); } } if (!Lib.Utility.Common.IsNullOrEmptyList(updateList)) { foreach (PMS.Model.DTO.Appraisal.KPI obj_kpi in updateList) { Model.Context.PMS_APPRAISAL_KPI entity = dc_pms.PMS_APPRAISAL_KPI.Where(rec => rec.ID == obj_kpi.Id).Single(); entity.DESCRIPTION = obj_kpi.Description; entity.TARGET = obj_kpi.Target; entity.LEVEL_1_SCORE = obj_kpi.Level1Score; entity.LEVEL_2_SCORE = obj_kpi.Level2Score; entity.SELF_SCORE = obj_kpi.SelfScore; entity.PRIORITY_MASTER_ID = obj_kpi.Priority.Id; if (int_appraisal_id == 0) { int_appraisal_id = obj_kpi.Appraisal.Id; } } } if (int_appraisal_id > 0) { Model.Context.PMS_APPRAISAL ent_appraisal = dc_pms.PMS_APPRAISAL.Where(rec => rec.ID == int_appraisal_id).Single(); if (ent_appraisal.STATUS_ID == Model.PMSConstants.STATUS_ID_NEW) { ent_appraisal.STATUS_ID = PMS.Model.PMSConstants.STATUS_ID_DRAFT; } } dc_pms.SaveChanges(); newkpiids = sb_newkpiids.ToString(); if(!string.IsNullOrEmpty(newkpiids)) newkpiids = newkpiids.Substring(0, newkpiids.Length-1); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateSMTMember(PMS.Model.DTO.Appraisal.Appraisal appraisal, PMS.Model.DTO.Appraisal.Reviewer smtMember, out string message, out Model.DTO.Appraisal.Reviewer oldReviewer) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); oldReviewer = null; try { Model.Context.PMS_APPRAISAL_REVIEWER ent_reviewer = (from ent_reviewers in dc_pms.PMS_APPRAISAL_REVIEWER where ent_reviewers.APPRAISAL_ID == appraisal.Id && ent_reviewers.IS_SMT == true select ent_reviewers).SingleOrDefault(); if (ent_reviewer != null) { ent_reviewer.REVIEWER_ID = smtMember.EmployeeId; oldReviewer = Model.Mappers.PMSMapper.MapReviewerEntityToDTO(ent_reviewer); } else { Model.Context.PMS_APPRAISAL_REVIEWER ent_smt_reviewer = Model.Mappers.PMSMapper.MapReviewerDTOTOEntity(smtMember); dc_pms.PMS_APPRAISAL_REVIEWER.AddObject(ent_smt_reviewer); } dc_pms.SaveChanges(); } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateAppraisalPerformanceCoaching(PMS.Model.DTO.Appraisal.PerformanceCoaching performanceCoaching, out string message) { bool boo_success = false; message = string.Empty; int int_appraisal_id = 0; Model.Context.PMS_APPRAISAL_PERFORMANCE_COACHING entity; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { if (performanceCoaching != null) { entity = dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING.Where(rec => rec.APPRAISAL_ID == performanceCoaching.Appraisal.Id).SingleOrDefault(); if (entity == null) { entity = Mappers.PMSMapper.MapAppraisalPerformanceCoachingDTOToEntity(performanceCoaching); dc_pms.PMS_APPRAISAL_PERFORMANCE_COACHING.AddObject(entity); } else { entity.STRENGTH_AREA = performanceCoaching.AreasOfStrength; entity.IMPROVEMENT_AREA = performanceCoaching.AreasOfImprovement; } int_appraisal_id = performanceCoaching.Appraisal.Id; if (int_appraisal_id > 0) { Model.Context.PMS_APPRAISAL ent_appraisal = dc_pms.PMS_APPRAISAL.Where(rec => rec.ID == int_appraisal_id).Single(); if (ent_appraisal.STATUS_ID == Model.PMSConstants.STATUS_ID_NEW) { ent_appraisal.STATUS_ID = PMS.Model.PMSConstants.STATUS_ID_DRAFT; } } dc_pms.SaveChanges(); boo_success = true; } } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool InsertNewCycleAndCreateAppraisalTasks(PMS.Model.DTO.Cycle.Cycle cycle, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { PMS.Model.Context.PMS_CYCLE entity_cycle = Mappers.PMSMapper.MapCycleDTOToEntity(cycle, false); dc_pms.PMS_CYCLE.AddObject(entity_cycle); foreach (Model.DTO.Cycle.Stage dto_cycle_stage in cycle.CycleStages) { Model.Context.PMS_CYCLE_STAGE entity_cycle_stage = Mappers.PMSMapper.MapCycleStageDTOToEntity(dto_cycle_stage); entity_cycle_stage.CYCLE_ID = entity_cycle.ID; dc_pms.PMS_CYCLE_STAGE.AddObject(entity_cycle_stage); } dc_pms.SaveChanges(); message = Convert.ToString(entity_cycle.ID); foreach (Model.DTO.Appraisal.Appraisal dto_appraisal in cycle.Appriasals) { Model.Context.PMS_APPRAISAL entity_appraisal = Mappers.PMSMapper.MapAppraisalDTOToEntity(dto_appraisal); entity_appraisal.CYCLE_ID = entity_cycle.ID; dc_pms.PMS_APPRAISAL.AddObject(entity_appraisal); dc_pms.SaveChanges(); foreach (Model.DTO.Appraisal.Section dto_appraisal_section in dto_appraisal.AppraisalSections) { Model.Context.PMS_APPRAISAL_SECTION entity_appraisal_section = Model.Mappers.PMSMapper.MapAppraisalSectionDTOToEntity(dto_appraisal_section); entity_appraisal_section.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_SECTION.AddObject(entity_appraisal_section); } foreach (Model.DTO.Appraisal.Stage dto_appraisal_stage in dto_appraisal.AppraisalStages) { Model.Context.PMS_APPRAISAL_STAGE entity_appraisal_stage = Model.Mappers.PMSMapper.MapAppraisalStageDTOToEntity(dto_appraisal_stage); entity_appraisal_stage.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_STAGE.AddObject(entity_appraisal_stage); } foreach (Model.DTO.Appraisal.Trail dto_appraisal_trail in dto_appraisal.Trails) { Model.Context.PMS_APPRAISAL_TRAIL entity_appraisal_trail = Model.Mappers.PMSMapper.MapAppraisalTrailDTOToEntity(dto_appraisal_trail); entity_appraisal_trail.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_TRAIL.AddObject(entity_appraisal_trail); } foreach (Model.DTO.Appraisal.Approver dto_appraisal_approver in dto_appraisal.Approvers) { Model.Context.PMS_APPRAISAL_APPROVER entity_appraisal_approver = Model.Mappers.PMSMapper.MapApproverDTOToEntity(dto_appraisal_approver); entity_appraisal_approver.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_APPROVER.AddObject(entity_appraisal_approver); } foreach (Model.DTO.Appraisal.Reviewer dto_appraisal_reviewer in dto_appraisal.Reviewers) { Model.Context.PMS_APPRAISAL_REVIEWER entity_appraisal_reviewer = Model.Mappers.PMSMapper.MapReviewerDTOTOEntity(dto_appraisal_reviewer); entity_appraisal_reviewer.APPRAISAL_ID = entity_appraisal.ID; dc_pms.PMS_APPRAISAL_REVIEWER.AddObject(entity_appraisal_reviewer); } /* if (dto_appraisal.Task != null) { Model.Context.TASK entity_task = Mappers.CoreMapper.MapTaskDTOToEntity(dto_appraisal.Task); entity_task.RECORD_ID = entity_appraisal.ID; dc_pms.TASKs.AddObject(entity_task); foreach (Model.DTO.Core.Task.Owner obj_owner in dto_appraisal.Task.Owners) { Model.Context.TASK_OWNER entity_owner = Mappers.CoreMapper.MapTaskOwnerDTOToEntity(obj_owner); entity_owner.TASK_ID = entity_task.ID; dc_pms.TASK_OWNER.AddObject(entity_owner); } } */ } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; } finally { dc_pms.Dispose(); } return boo_success; }
public static bool UpdateEmployee(string[] result, out string message) { bool boo_success = false; message = string.Empty; PMS.Model.Context.PMSEntities dc_pms = new PMS.Model.Context.PMSEntities(); try { foreach (string str_string in result) { string[] kparray = str_string.Replace("\"", "").Split(','); int Id = Int32.Parse(kparray[0].Split(':')[1].Replace("}]", "").Trim()); string Email = kparray[1].Split(':')[1].Replace("}]", "").Trim(); string ContactNo = kparray[2].Split(':')[1].Replace("}]", "").Trim(); string SeatLocation = kparray[3].Split(':')[1].Replace("}]", "").Trim(); PMS.Model.Context.EMPLOYEE ent_employee = dc_pms.EMPLOYEEs.Where(rec => rec.ID == Id).SingleOrDefault(); ent_employee.OFFICE_EMAIL_ADDRESS = Email; ent_employee.OFFICE_TEL_NUMBER = ContactNo; ent_employee.OFFICE_SEAT_LOCATION = SeatLocation; } dc_pms.SaveChanges(); boo_success = true; } catch (Exception exc) { message = exc.Message; boo_success = false; } finally { dc_pms.Dispose(); } return boo_success; }