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