public ProjectCheckListModel GetProjectCheckListForProjectID(int projectID) { ProjectCheckListModel model = new ProjectCheckListModel(); try { TBL_MP_PMC_Project_CheckList dbModel = _dbContext.TBL_MP_PMC_Project_CheckList.Where(x => x.FK_ProjectID == projectID).FirstOrDefault(); if (dbModel == null) { model = GetDefaultProjectCheckList(); } else { string strJSON = dbModel.ProjectChecklist; model = JsonConvert.DeserializeObject <ProjectCheckListModel>(strJSON); } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceProjectCheckList::GetProjectCheckListForProjectID", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }
public bool UpdateProjectCheckListForProjectID(int projectID, ProjectCheckListModel model) { bool result = false; try { string strJSON = JsonConvert.SerializeObject(model); TBL_MP_PMC_Project_CheckList dbModel = _dbContext.TBL_MP_PMC_Project_CheckList.Where(x => x.FK_ProjectID == projectID).FirstOrDefault(); if (dbModel == null) { dbModel = new TBL_MP_PMC_Project_CheckList(); dbModel.FK_ProjectID = projectID; dbModel.ProjectChecklist = strJSON; _dbContext.TBL_MP_PMC_Project_CheckList.Add(dbModel); _dbContext.SaveChanges(); } else { dbModel.ProjectChecklist = strJSON; _dbContext.SaveChanges(); } result = true; } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceProjectCheckList::UpdateProjectCheckListForProjectID", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }