public void AddContractEmployeLink(GetContractEmploye link) { Employe defaultEmploye = db.Employers.Include(data => data.Contracts).FirstOrDefault(data => data.Id == link.EmployeId); ViewContracts contract = new ViewContracts(); this.AddContract(contract); db.SaveChanges(); Contract defaultContract = db.Contracts.Include(data => data.Employe).Include(data => data.Supply).Last(); ContractsEmploye CE = new ContractsEmploye() { ContractId = defaultContract.Id, EmployeId = link.EmployeId }; defaultEmploye.Contracts.Add(CE); db.Entry(defaultEmploye).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(); } }