public void SetProjectAndCube(
string ProjectName,
string CubeName
)
{
AddOrUpdateProject(new Project()
{
ProjectName = ProjectName,
DateCreated = DateTime.Now,
DateModified = DateTime.Now
});
prj = dbc.Project
.Single(b => b.ProjectName == ProjectName)
;
AddOrUpdateObjCube(new ObjCube()
{
Name = CubeName,
ProjectId = prj.Id,
DateCreated = DateTime.Now,
DateModified = DateTime.Now
});
cb = dbc.ObjCube
.Single(b => b.Name == CubeName && b.ProjectId == prj.Id)
;
}
private void AddOrUpdateObjCube(ObjCube obj)
{
ObjCube result = dbc.ObjCube
.SingleOrDefault(b => b.Name == obj.Name && b.ProjectId == obj.ProjectId);
if (result == null)
{
dbc.ObjCube.Add(obj);
}
else
{
result.DateModified = DateTime.Now;
}
dbc.SaveChanges();
}
