/// <summary> /// The method returns a list of filtered entities /// </summary> /// <param name="predicate">Filtering predicate</param> /// <returns>List of entities</returns> public IEnumerable <AspNetUsers> Get(Func <AspNetUsers, bool> predicate) { using (DbContext context = new DbContext()) { return(context.AspNetUsers.Where(u => u.ContragentId != null).ToList().Where(predicate).ToList()); } }
/// <summary> /// The method returns an entity by id /// </summary> /// <param name="id">Id of the entity</param> /// <returns>The entity</returns> public AspNetUsers Get(int id) { using (DbContext context = new DbContext()) { return(context.AspNetUsers.FirstOrDefault(c => c.ContragentId == id)); } }
/// <summary> /// The method returns a list of all entities /// </summary> /// <returns>List of all entities</returns> public List <AspNetUsers> Get() { using (DbContext context = new DbContext()) { return(context.AspNetUsers.Where(u => u.ContragentId != null).ToList()); } }
/// <summary> /// The method returns a list of filtered entities /// </summary> /// <param name="predicate">Filtering predicate</param> /// <returns>List of entities</returns> public IEnumerable <Offer> Get(Func <Offer, bool> predicate) { using (DbContext context = new DbContext()) { List <Offer> offers = context.Offers.Where(predicate).ToList(); return(offers); } }
/// <summary> /// The method returns a list of all entities /// </summary> /// <returns>List of all entities</returns> public List <Offer> Get() { using (DbContext context = new DbContext()) { List <Offer> offers = context.Offers.Where(o => o.OfrAuditRd == null).ToList(); return(offers); } }
/// <summary> /// The method returns an entity by id /// </summary> /// <param name="id">Id of the entity</param> /// <returns>The entity</returns> public Offer Get(int id) { using (DbContext context = new DbContext()) { Offer offer = context.Offers.FirstOrDefault(o => o.OfrId == id); return(offer); } }
/// <summary> /// The method removes an entity from the storage /// </summary> /// <param name="entity">The entity</param> public void Delete(Offer entity) { if (entity == null) { throw new ArgumentNullException(); } using (DbContext context = new DbContext()) { context.Offers.Remove(entity); context.SaveChangesAsync(); } }
/// <summary> /// The method removes an entity from the storage /// </summary> /// <param name="entity">The entity</param> public async void Delete(AspNetUsers entity) { if (entity == null) { throw new ArgumentNullException(); } using (DbContext context = new DbContext()) { if (string.IsNullOrEmpty(entity.Id)) { context.AspNetUsers.Remove(entity); } await context.SaveChangesAsync(); } }
/// <summary> /// The method writes an entity to the storage /// </summary> /// <param name="entity">The entity</param> public void Save(Offer entity) { if (entity == null) { throw new ArgumentNullException(); } if (entity.OfrId == 0) { entity.OfrAuditCd = DateTime.Now; } entity.OfrAuditMd = DateTime.Now; using (DbContext context = new DbContext()) { context.Offers.Add(entity); context.SaveChangesAsync(); } }
public ContragentsRepository() { _context = new DbContext(); }