public void AddSupplyOrganizationLink(GetSupplyOrganization link)
{
Supply defaultSupply = db.Supplies.Include(data => data.Contract).Include(data => data.Organization).FirstOrDefault(data => data.Id == link.SupplyId);
SupplyOrganizations SO = new SupplyOrganizations()
{
OrganizationId = link.OrganizationId, SupplyId = defaultSupply.Id
};
defaultSupply.Organization.Add(SO);
db.Entry(defaultSupply).State = EntityState.Modified;
db.SaveChanges();
}
public DbService(DataContext dataContext)
{
db = dataContext;
if (!db.Employers.Any())
{
db.Employers.Add(new Employe()
{
EmployeFullName = "Solovyov Andrey Uladimiravich", DepartamentId = "IT", Qualification = "Engeneer", MoneyProfit = 100, Premials = 10, Month = "October"
});
db.Organizations.Add(new Organization()
{
Adress = "Test adress", Sity = "N", CountryCode = 555, Phone = "555-35-35", Email = "*****@*****.**"
});
db.Supplies.Add(new Supply()
{
HardwareType = "IBM PC", UsersReview = "None"
});
db.Contracts.Add(new Contract());
db.SaveChanges();
Employe defaultEmploye = db.Employers.Include(data => data.Contracts).FirstOrDefault();
Contract defaultContract = db.Contracts.Include(data => data.Employe).Include(data => data.Supply).FirstOrDefault();
Organization defaultOrganization = db.Organizations.Include(data => data.Supply).FirstOrDefault();
Supply defaultSupply = db.Supplies.Include(data => data.Organization).Include(data => data.Contract).FirstOrDefault();
ContractsEmploye CElink = new ContractsEmploye()
{
ContractId = defaultContract.Id, EmployeId = defaultEmploye.Id
};
SupplyContract SClink = new SupplyContract()
{
ContractId = defaultContract.Id, SupplyId = defaultSupply.Id
};
SupplyOrganizations SOlink = new SupplyOrganizations()
{
SupplyId = defaultSupply.Id, OrganizationId = defaultOrganization.Id
};
defaultEmploye.Contracts.Add(CElink);
defaultContract.Supply = SClink;
defaultSupply.Organization.Add(SOlink);
///modify
db.Entry(defaultEmploye).State = EntityState.Modified; //look for mistakes
db.Entry(defaultContract).State = EntityState.Modified; //
db.Entry(defaultSupply).State = EntityState.Modified; //
db.SaveChanges();
}
}
