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