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