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