public Utilisateur CheckExistUser(string login, string pwd) { try { using (var db = new XSoftContext()) { var res = db.Utilisateurs.Where(r => (r.User.Equals(login) && r.ModePasse.Equals(pwd) && r.Deleted == false)).FirstOrDefault(); return(res); } } catch (Exception ex) { throw ex; } }
public Client GetModificatorByClient(int id) { try { using (var db = new XSoftContext()) { var res = db.Clients.Where(r => r.MODIFICATEURId.Equals(id)).FirstOrDefault(); return(res); } } catch (Exception ex) { throw ex; } }
public Collaborateur GetUserByCollaborator(int id) { try { using (var db = new XSoftContext()) { var res = db.Collaborateurs.Where(r => r.UtilisateurId.Equals(id)).FirstOrDefault(); return(res); } } catch (Exception ex) { throw ex; } }
public Tiers GetCreatorByTiers(int id) { try { using (var db = new XSoftContext()) { var res = db.Tiers.Where(r => r.CREATEURId.Equals(id)).FirstOrDefault(); return(res); } } catch (Exception ex) { throw ex; } }
public Collaborateur GetUserByCollaborator(int id) { try { using (var db = new XSoftContext()) { var collaborateur = _context.Collaborateurs.FirstOrDefault(r => r.UtilisateurId.Equals(id)); return(collaborateur); } } catch (Exception ex) { throw ex; } }
public DetailDimension GetByDetailDimension(int id) { try { using (var db = new XSoftContext()) { var Tiers = _context.DetailDimensions.FirstOrDefault(r => r.DimensionId.Equals(id)); return(Tiers); } } catch (Exception ex) { throw ex; } }
public Tiers GetByTiers(int id) { try { using (var db = new XSoftContext()) { var Tiers = _context.Tiers.FirstOrDefault(r => r.FamilleTierId.Equals(id)); return(Tiers); } } catch (Exception ex) { throw ex; } }
public Famille CheckTaxeExistFamille(int id) { try { using (var db = new XSoftContext()) { var famille = _context.Famille.FirstOrDefault(r => r.TaxeVenteId.Equals(id) || r.TaxeAchatId.Equals(id)); return(famille); } } catch (Exception ex) { throw ex; } }
public Client GetByClient(int id) { try { using (var db = new XSoftContext()) { var client = _context.Clients.FirstOrDefault(r => r.CategorieTarifId.Equals(id)); return(client); } } catch (Exception ex) { throw ex; } }
public DeviseRepository(XSoftContext context) { _context = context; }
public EProtectionRepository(XSoftContext context) { _context = context; }
public CollaborateurRepository(XSoftContext context) { _context = context; }
public ParametresRepository(XSoftContext context) { _context = context; }
public TaxeRepository(XSoftContext context) { _context = context; }
public ClientRepository(XSoftContext context) { _context = context; }
public FournisseurRepository(XSoftContext context) { _context = context; }
public ClassificationArticleRepository(XSoftContext context) { _context = context; }
public UtilisateurRepository(XSoftContext context) { _context = context; }
public ContactRepository(XSoftContext context) { _context = context; }
public CategorieTarifRepository(XSoftContext context) { _context = context; }
public ArticleGeneriqueRepository(XSoftContext context) { _context = context; }
public DimensionRepository(XSoftContext context) { _context = context; }
public ModalitePaiementRepository(XSoftContext context) { _context = context; }
public FamilleTierRepository(XSoftContext context) { _context = context; }
public UniteRepository(XSoftContext context) { _context = context; }