public List <AdressClient> FindAdressClient()
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.AdressClients.ToList());
}
}
public List <User> FindUserUsingRelationID(int relationID)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Users.Where(z => z.userID == relationID).ToList());
}
}
public AdressClient FindAdressClientUsingID(int ID)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.AdressClients.Find(ID));
}
}
public List <Client> FindClient()
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Clients.ToList());
}
}
public List <GroupAccess> FindGroupAccess()
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Groups.ToList());
}
}
public User FindUserUsingID(int ID)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Users.Find(ID));
}
}
public FormControlConform FindFormulControlConformUsingID(int id)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.FormControlConforms.Find(id));
}
}
public Client FindClientUsingID(int id)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Clients.Find(id));
}
}
//enlever List<>
public List <AdressClient> FindAdressClientUsingClientIDRelationID(int ClientID, int RelationID)
{
using (VeoliaContext db = new VeoliaContext())
{ //enlever .ToList()
return(db.AdressClients.Where(n => n.clientID == ClientID).ToList()); //.Where(n => n.relationFormAdress.Find(RelationID));
}
}
public List <Client> FindClientUsingUserID(int userID)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Clients.Where(n => n.userId == userID).ToList());
}
}
public Recommandation FindRecommandationUsingID(int id)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Recommandations.Find(id));
}
}
public List <AdressClient> FindAdressClientUsingClientID(int ClientID)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.AdressClients.Where(z => z.clientID == ClientID).ToList());
}
}
public List <RelationFormAdress> FindRelationFormAdress()
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.RelationFormAdresss.ToList());
}
}
public List <User> FindUser()
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.Users.ToList());
}
}
public List <RelationUserGroupAccess> FindRelationUserGroupUsingGroupID(int groupId)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.RelationGroupAccesss.Where(n => n.groupAccessID == groupId).ToList());
}
}
public List <RelationUserGroupAccess> FindRelationUserGroup()
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.RelationGroupAccesss.ToList());
}
}
public FormDiagnosticANC FindFormDiagnosticmUsingID(int id)
{
using (VeoliaContext db = new VeoliaContext())
{
return(db.FormDiagnosticANCs.Find(id));
}
}
public void SaveUpdateRecommandation(Recommandation recom)
{
using (VeoliaContext db = new VeoliaContext())
{
db.Entry(recom).State = EntityState.Modified;
db.SaveChanges();
}
}
public void SaveUpdateRelationFormAdress(RelationFormAdress relation)
{
using (VeoliaContext db = new VeoliaContext())
{
db.Entry(relation).State = EntityState.Modified;
db.SaveChanges();
}
}
public void SaveUpdateFormDiagnostic(FormDiagnosticANC formul)
{
using (VeoliaContext db = new VeoliaContext())
{
db.Entry(formul).State = EntityState.Modified;
db.SaveChanges();
}
}
public void SaveUpdateFormControlConform(FormControlConform formul)
{
using (VeoliaContext db = new VeoliaContext())
{
db.Entry(formul).State = EntityState.Modified;
db.SaveChanges();
}
}
public void SaveUpdateClient(Client client)
{
using (VeoliaContext db = new VeoliaContext())
{
db.Entry(client).State = EntityState.Modified;
db.SaveChanges();
}
}
public void SaveUpdateUser(User user)
{
using (VeoliaContext db = new VeoliaContext())
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
}
public void DeleteAdress(int adressID)
{
using (VeoliaContext db = new VeoliaContext())
{
AdressClient adress = db.AdressClients.Find(adressID);
db.Entry(adress).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void DeleteClient(int ID)
{
using (VeoliaContext db = new VeoliaContext())
{
Client client = db.Clients.Find(ID);
db.Entry(client).State = EntityState.Deleted;
db.SaveChanges();
}
}
public int SaveNewClient(Client client)
{
using (VeoliaContext db = new VeoliaContext())
{
Client addedone = db.Clients.Add(client);
db.SaveChanges();
return(addedone.clientID);
}
}
public int SaveNewAdress(AdressClient adress)
{
using (VeoliaContext db = new VeoliaContext())
{
AdressClient addAdress = db.AdressClients.Add(adress);
db.SaveChanges();
return(addAdress.clientID);
}
}
public void SaveUpdateAdress(int adressID, AdressClient newadress)
{
using (VeoliaContext db = new VeoliaContext())
{
AdressClient adress = db.AdressClients.Find(adressID);
db.Entry(newadress).State = EntityState.Modified;
db.SaveChanges();
}
}
public int SaveNewUser(User user)
{
using (VeoliaContext db = new VeoliaContext())
{
User NewUser = db.Users.Add(user);
db.SaveChanges();
return(NewUser.userID);
}
}
public void DeleteUser(int userID)
{
using (VeoliaContext db = new VeoliaContext())
{
User user = db.Users.Find(userID);
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
}
}