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