public void UpdateProjectToCompany(ProjectCompany projectCompany, DateProjectCompany dateProjectCompany) { using (var ctx = new SystemCompanyEntities()) { var PC = ctx.ProjectCompanies.First( pC => pC.idProject == projectCompany.idProject && pC.idCompany == projectCompany.idCompany); PC.idProject = projectCompany.idProject; PC.idCompany = projectCompany.idCompany; PC.priceType = projectCompany.priceType; PC.paid = projectCompany.paid; PC.destination = projectCompany.destination; PC.discriptions = projectCompany.discriptions; ctx.SaveChanges(); var DPC = ctx.DateProjectCompany.First( dpC => dpC.idProject == dateProjectCompany.idProject && dpC.idCompany == dateProjectCompany.idCompany); DPC.idCompany = dateProjectCompany.idCompany; DPC.idProject = dateProjectCompany.idProject; DPC.DateStartProject = dateProjectCompany.DateStartProject; DPC.DateFinishProject = dateProjectCompany.DateFinishProject; ctx.SaveChanges(); } }
public void InsertProjectToCompany(ProjectCompany projectCompany, DateProjectCompany dateProjectCompany) { using (var ctx = new SystemCompanyEntities()) { ctx.AddToProjectCompanies(projectCompany); ctx.SaveChanges(); ctx.AddToDateProjectCompany(dateProjectCompany); ctx.SaveChanges(); } }