/// <inheritdoc /> public async Task <IEnumerable <PhoneItem> > GetPhonesAsync(string place, string post, string name) { List <PhoneItem> phones = null; using (var context = new PhoneContextApi()) { phones = Mapper.Map <IEnumerable <Phone>, List <PhoneItem> >(await context.Phones.Include(p => p.Place).Where(p => p.IsDeleted != 1).ToListAsync()); } //phones = phones.Take(100).ToList(); if (place != null && place != "Объект" && place != "null" && place != "undefined") { phones = phones.Where(p => p.Place != null).Where(p => p.Place.ToLower() == place.ToLower()).ToList(); } if (post != null && post != "null" && post != "undefined") { phones = phones.Where(p => p.Post != null).Where(p => p.Post.ToLower().Contains(post.ToLower())).ToList(); } if (name != null && name != "null" && name != "undefined") { phones = phones.Where(p => p.Name != null).Where(p => p.Name.ToLower().Contains(name.ToLower())).ToList(); } return(phones); }
/// <inheritdoc /> public async Task <IEnumerable <Place> > GetPlacesAsync() { using (var context = new PhoneContextApi()) { return(await context.Places.Where(p => p.IsDeleted == 0).ToListAsync()); } }
/// <inheritdoc /> public async Task AddPlaceAsync(Place place) { using (var context = new PhoneContextApi()) { context.Places.Add(place); await context.SaveChangesAsync(); } }
/// <inheritdoc /> public async Task <List <PhoneItem> > GetPhonesAsync() { using (var context = new PhoneContextApi()) { var phones = Mapper.Map <IEnumerable <Phone>, List <PhoneItem> >(await context.Phones.Include(p => p.Place).Where(p => p.IsDeleted != 1).ToListAsync()); return(phones); } }
/// <inheritdoc /> public async Task UpdatePlaceAsync(int id, Place place) { using (var context = new PhoneContextApi()) { context.Entry(place).State = EntityState.Modified; var placeInDb = await context.Places.FirstOrDefaultAsync(p => p.Id == id); await context.SaveChangesAsync(); } }
/// <inheritdoc /> public async Task DeletePhoneAsynk(int id) { using (var context = new PhoneContextApi()) { var phone = await context.Phones.FirstOrDefaultAsync(p => p.Id == id); phone.IsDeleted = 1; context.Entry(phone).State = EntityState.Modified; await context.SaveChangesAsync(); } }
/// <inheritdoc /> public async Task AddPhoneAsync(PhoneItem phoneitem) { using (var context = new PhoneContextApi()) { var place = await context.Places.FirstOrDefaultAsync(p => p.Name == phoneitem.Place); var phone = new Phone() { Name = phoneitem.Name, Post = phoneitem.Post, Department = phoneitem.Department, Description = phoneitem.Description, Nomer = phoneitem.Nomer, PlaceId = place.Id }; context.Phones.Add(phone); await context.SaveChangesAsync(); } }
/// <inheritdoc /> public async Task UpdatePhoneAsync(int id, PhoneItem phoneitem) { using (var context = new PhoneContextApi()) { var place = await context.Places.FirstOrDefaultAsync(p => p.Name == phoneitem.Place); var phone = new Phone() { Id = phoneitem.Id, Name = phoneitem.Name, Post = phoneitem.Post, Department = phoneitem.Department, Description = phoneitem.Description, Nomer = phoneitem.Nomer, PlaceId = place.Id }; context.Entry(phone).State = EntityState.Modified; var phoneInDb = await context.Phones.FirstOrDefaultAsync(p => p.Id == id); await context.SaveChangesAsync(); } }