public ProjectManager GetProjectPlanForProjectID(int ID, PROJECT_PLAN_TYPE planType) { TBL_MP_PMC_Project_Planning model = null; ProjectManager _manager = null; try { model = _dbContext.TBL_MP_PMC_Project_Planning.Where(x => x.FK_ProjectID == ID).Where(x => x.ProjectPlanType == (int)planType).FirstOrDefault(); if (model != null) { MemoryStream ms2 = new MemoryStream(); byte[] buf = model.ProjectPlan; ms2.Write(buf, 0, buf.Length); ms2.Seek(0, 0); BinaryFormatter b = new BinaryFormatter(); _manager = (ProjectManager)b.Deserialize(ms2); ms2.Close(); } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceProject::GetProjectPlanofProjectID", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_manager); }
public bool UpdateProjectPlanning(int projectID, ProjectManager _mManager, PROJECT_PLAN_TYPE SelectedPlanType) { bool result = false; TBL_MP_PMC_Project_Planning model = null; try { MemoryStream ms = new MemoryStream(); BinaryFormatter b = new BinaryFormatter(); b.Serialize(ms, _mManager); ms.Seek(0, 0); byte[] arrProject = ms.ToArray(); model = _dbContext.TBL_MP_PMC_Project_Planning.Where(x => x.FK_ProjectID == projectID).Where(x => x.ProjectPlanType == (int)SelectedPlanType).FirstOrDefault(); if (model == null) { model = new TBL_MP_PMC_Project_Planning() { FK_ProjectID = projectID } } ; model.ProjectPlan = arrProject; model.ProjectPlanType = (int)SelectedPlanType; if (model.PK_ProjectPlanID == 0) { _dbContext.TBL_MP_PMC_Project_Planning.Add(model); } _dbContext.SaveChanges(); ms.Close(); result = true; } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceProject::UpdateProjectPlanning", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }