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