public void DatabaseSingleItem()
{
Guid projectId = ProjectTestUtilities.CreateFullDbHierarchy();
Project sourceObject = null;
using (var db = new TestModelContext())
{
sourceObject = db.Projects.Find(projectId);
}
object result = _expander.Expand(sourceObject, includes: PropertyReference.Parse($"[{nameof(ProjectProjection.Name)}]"));
result.ShouldNotBeNull();
ProjectProjection projection = result as ProjectProjection;
projection.ShouldNotBeNull();
// Verify the properties in this object were projected correctly
projection.Name.ShouldBe(sourceObject.Name);
projection.Description.ShouldBeNull();
// And verify the navigation property was retrieved correctly
projection.Environments.ShouldBeNull();
projection.CredentialDefinitions.ShouldBeNull();
projection.Sections.ShouldBeNull();
}
protected void btnSaveEstimation_OnClick(object sender, EventArgs e)
{
var projectId = _projId;
var userId = _userId;
var projectParamater = new ProjectProjection();
var accomodation = accommodation;
var vehicleDeatils = vehicle;
var employ = employees;
var printMaterial = material;
var refresh = refreshment;
var fieldWork = fieldwork;
var teleph = telephone;
projectParamater.proj_id = (int)projectId;
projectParamater.employees = employ.Text;
projectParamater.vehicle = vehicleDeatils.Text;
projectParamater.accomodation = accomodation.Text;
projectParamater.print_material = printMaterial.Text;
projectParamater.refreshments = refresh.Text;
projectParamater.telephone = teleph.Text;
projectParamater.wifi_data = fieldWork.Text;
projectParamater.user_id = userId;
projectParamater.created_at = DateTime.Today;
projectParamater.modified_at = DateTime.Today;
_insedlu.ProjectProjections.Add(projectParamater);
_insedlu.SaveChangesAsync();
MakeReadOnly();
}
protected void projection_OnClick(object sender, EventArgs e)
{
var query = Request.QueryString;
var id = Convert.ToInt32(query.Get("id"));
var userId = Convert.ToInt32(Session["ID"]);
var projId = id;
//save project projection
var accomo = accomodation.Text;
var vehCle = vehicle.Text;
var empl = employees.Text;
var tel = telephone.Text;
var dataWifi = data.Text;
var refresh = refreshment.Text;
var printM = printmaterial.Text;
var projections = new ProjectProjection();
if (!string.IsNullOrEmpty(accomo))
{
projections.accomodation = accomo;
}
if (!string.IsNullOrEmpty(vehCle))
{
projections.vehicle = vehCle;
}
if (!string.IsNullOrEmpty(empl))
{
projections.employees = empl;
}
if (!string.IsNullOrEmpty(tel))
{
projections.telephone = tel;
}
if (!string.IsNullOrEmpty(dataWifi))
{
projections.wifi_data = dataWifi;
}
if (!string.IsNullOrEmpty(refresh))
{
projections.refreshments = refresh;
}
if (!string.IsNullOrEmpty(printM))
{
projections.print_material = printM;
}
projections.created_at = DateTime.Today;
projections.modified_at = DateTime.Today;
projections.proj_id = projId;
projections.user_id = userId;
_insendluEntities.ProjectProjections.Add(projections);
_insendluEntities.SaveChanges();
}
public ProjectProjection Get(EntityId id)
{
var project = _context.ProjectsProjection
.FirstOrDefault(ac => ac.Id.Equals(id.Value));
if (project == null)
{
ProjectProjection.Empty();
}
return(project);
}
public void DatabaseNestedList()
{
Guid projectId = ProjectTestUtilities.CreateFullDbHierarchy();
Project sourceObject = null;
using (var db = new TestModelContext())
{
sourceObject = db.Projects.Find(projectId);
}
var includeValues = $"{nameof(CredentialKeyValueProjection.Key)}";
var includeCredentials = $"{nameof(CredentialProjection.Values)}[{includeValues}]";
var includeEnvironments = $"{nameof(EnvironmentProjection.Name)},{nameof(EnvironmentProjection.Credentials)}[{includeCredentials}]";
var includeCredentialDefinitions = $"{nameof(CredentialDefinitionProjection.Name)},{nameof(CredentialDefinitionProjection.Type)}";
var includeProject = $"{nameof(ProjectProjection.Name)},{nameof(ProjectProjection.CredentialDefinitions)}[{includeCredentialDefinitions}],{nameof(ProjectProjection.Environments)}[{includeEnvironments}]";
object result = _expander.Expand(sourceObject, includes: PropertyReference.Parse($"[{includeProject}]"));
result.ShouldNotBeNull();
ProjectProjection projection = result as ProjectProjection;
projection.ShouldNotBeNull();
projection.ShouldNotBeNull();
// Verify the properties in this object were projected correctly
projection.Name.ShouldBe(sourceObject.Name);
projection.Description.ShouldBeNull();
// And verify each navigation property was retrieved correctly
projection.CredentialDefinitions.ShouldNotBeNull();
projection.CredentialDefinitions.Count.ShouldBe(1);
projection.CredentialDefinitions.First().Name.ShouldBe("Creds");
projection.CredentialDefinitions.First().DisplayName.ShouldBeNull();
projection.CredentialDefinitions.First().Type.ShouldNotBeNull();
projection.CredentialDefinitions.First().Type.Name.ShouldBe("CredType");
projection.Environments.ShouldNotBeNull();
projection.Environments.Count.ShouldBe(1);
projection.Environments.First().Name.ShouldBe("EnvironmentName");
projection.Environments.First().BaseUrl.ShouldBeNull();
projection.Environments.First().Credentials.ShouldNotBeNull();
projection.Environments.First().Credentials.Count.ShouldBe(1);
projection.Environments.First().Credentials.First().Id.ShouldBe(Guid.Empty);
projection.Environments.First().Credentials.First().Definition.ShouldBeNull();
projection.Environments.First().Credentials.First().Values.ShouldNotBeNull();
projection.Environments.First().Credentials.First().Values.Count.ShouldBe(1);
projection.Environments.First().Credentials.First().Values.First().Key.ShouldBe("Key");
projection.Environments.First().Credentials.First().Values.First().Value.ShouldBeNull();
}
public void Add(ProjectProjection entity)
{
var oldState =
_context.ProjectsProjection
.FirstOrDefault(b => b.Id == entity.Id);
if (oldState == null)
{
_context.ProjectsProjection.Add(entity);
}
else
{
_context.Entry(oldState).CurrentValues.SetValues(entity);
}
}
public ProjectProjection ProjectProjection(int projId)
{
var projectProject = new ProjectProjection();
var pp = (from projP in _insendluEntities.ProjectProjections
where projP.proj_id == projId
select projP).FirstOrDefault();
if (pp != null)
{
return(pp);
}
return(projectProject);
}
public void EntityFrameworkMappingConfig()
{
Guid projectId = ProjectTestUtilities.CreateFullDbHierarchy();
Project sourceObject = null;
using (var db = new TestModelContext())
{
sourceObject = db.Projects.Find(projectId);
}
var includeProject = $"{nameof(ProjectProjection.Name)},{nameof(ProjectProjection.Id)}";
object result = _expander.Expand(sourceObject, includes: PropertyReference.Parse($"[{includeProject}]"));
result.ShouldNotBeNull();
ProjectProjection projection = result as ProjectProjection;
projection.ShouldNotBeNull();
projection.Name.ShouldBe(sourceObject.Name);
projection.Id.ShouldNotBe(sourceObject.Id);
}
protected override void ExecuteHandle(ProjectDetailUpdatedEvent @event)
{
var project = _projectSession.Repository.Get(@event.Id);
var projection = new ProjectProjection(
project.Id,
@event.Name.Value,
project.Code,
@event.Budget.Value,
project.StartDate,
project.ClientId,
project.ClientName,
@event.Owner.Value,
@event.OrderNumber.Value,
project.Status,
project.StatusName,
@event.Version.Value);
_projectSession.Repository.Add(projection);
_projectSession.SaveChanges();
}
protected override void ExecuteHandle(ProjectAddedEvent @event)
{
var client = _userSession.Repository.Get(@event.ClientId);
var projection = new ProjectProjection(
@event.Id.Value,
@event.Name.Value,
@event.Code.Value,
@event.Budget.Value,
@event.StartDate.Value,
@event.ClientId.Value,
client.Name,
@event.Owner.Value,
@event.OrderNumber.Value,
@event.Status.Value,
@event.Status.ToString(),
@event.Version.Value);
_projectSession.Repository.Add(projection);
_projectSession.SaveChanges();
}
public void Remove(ProjectProjection entity)
{
_context.ProjectsProjection.Remove(entity);
}
