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