/// <summary>
/// method - get all brands include models for every brand (form database)
/// </summary>
/// <returns></returns>
public async Task <IList <Brand> > GetAllBrandsWithModelsAsync()
{
var brandsWithModels = this.brands.All().Include(x => x.Models);
var allBrandsWithModels = await EfExtensions.ToListAsyncSafe <Brand>(brandsWithModels);
return(allBrandsWithModels);
}
/// <summary>
/// method - get all brands from database
/// </summary>
/// <returns></returns>
public async Task <IList <BrandIndexDtoModel> > GetAllBrandsWithImageAsync()
{
var brandsAll = this.brands.All();
var allBrands = await EfExtensions.ToListAsyncSafe <Brand>(brandsAll);
var result = BrandServiceIndexMapper.Map(allBrands);
return(result);
}
/// <summary>
/// get all users from database and return users count
/// </summary>
/// <returns></returns>
public async Task <int> GetCountOfUsers()
{
var users = this.repository.All();
var usersAll = await EfExtensions.ToListAsyncSafe <ApplicationUser>(users);
int count = usersAll.Count();
return(count);
}
/// <summary>
/// method - check in databse, is there a brand with a name which we take like a param
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public async Task <bool> IfBrandExistsAsync(string name)
{
var brandsAll = this.brands.All();
var allBrands = await EfExtensions.ToListAsyncSafe <Brand>(brandsAll);
bool checkBrand = allBrands.Any(x => x.Name.ToUpper() == name.ToUpper());
return(checkBrand);
}
/// <summary>
/// method - find and get brand by id param from database
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <BrandUpdateDtoModel> GetBrandByIdAsync(int id)
{
var brandsAll = this.brands.All();
var allBrands = await EfExtensions.ToListAsyncSafe <Brand>(brandsAll);
var currentBrand = allBrands.FirstOrDefault(x => x.Id == id);
var brandDto = BrandServiceUpdateDtoMapper.Map(currentBrand);
return(brandDto);
}
/// <summary>
/// method - get brands with their images from database
/// </summary>
/// <returns></returns>
public async Task <IList <BrandWithLogoDtoModel> > GetBrandsWithLogos()
{
var brandsAll = this.brands.All();
var allBrands = await EfExtensions.ToListAsyncSafe <Brand>(brandsAll);
var allOrderedBrands = allBrands.OrderBy(x => x.Name).ToList();
var brandsWithLogos = GetBrandsWithLogoMapper.Map(allOrderedBrands);
return(brandsWithLogos);
}
/// <summary>
/// method - find and get brand by name param from database
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public async Task <Brand> GetBrandByNameAsync(string name)
{
var brandsWithModels = this.brands.All();
var allBrandsWithModels = await EfExtensions.ToListAsyncSafe <Brand>(brandsWithModels);
var currentBrand = allBrandsWithModels.FirstOrDefault(x => x.Name == name);
//var currentBrand = await this.brands.All().FirstOrDefaultAsync(x => x.Name == name);
return(currentBrand);
}
/// <summary>
/// method - check in databese is there same brand, like param model
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <int> SameBrandCount(BrandUpdateDtoModel model)
{
var brandsAll = this.brands.AllAsNoTracking();
var allBrands = await EfExtensions.ToListAsyncSafe <Brand>(brandsAll);
var sameBrandCount = allBrands.Where(x => x.Name == model.BrandName
& x.ImageAddress == model.ImageAddress)
.Count();
return(sameBrandCount);
}
/// <summary>
/// method - get all brans from database and return all brands names
/// </summary>
/// <returns></returns>
public async Task <IList <string> > GetBrandNamesAsync()
{
var brandsAll = this.brands.All();
var allBrands = await EfExtensions.ToListAsyncSafe <Brand>(brandsAll);
var brandNames = allBrands.Select(b => b.Name).OrderBy(b => b).ToList();
//var brandNames = await this.brands.All().Select(b => b.Name).OrderBy(b => b).ToListAsync();
return(brandNames);
}
/// <summary>
/// method - find and get brand by name param from database, return brand id param
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public async Task <int> GetBrandIdByNameAsync(string name)
{
var brandsAll = this.brands.All();
var allBrands = await EfExtensions.ToListAsyncSafe <Brand>(brandsAll);
var currentBrand = allBrands.FirstOrDefault(x => x.Name == name);
//var currentBrand = await this.brands.All().FirstOrDefaultAsync(x => x.Name == name);
var brandId = currentBrand.Id;
return(brandId);
}
protected void AddChangesToLog()
{
foreach (var entry in DbContext.ChangeTracker.Entries())
{
if (entry.State == EntityState.Modified)
{
foreach (var change in EfExtensions.GetChanges(DbContext, entry))
{
ChangeLogRepository.Add(change);
}
}
}
}
/// <summary>
/// get user authorize status by username from database
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public async Task <bool?> GetAuthorizeStatusByUserNameAsync(string userName)
{
var users = this.repository.All();
var usersAll = await EfExtensions.ToListAsyncSafe <ApplicationUser>(users);
var user = usersAll.SingleOrDefault(x => x.UserName == userName);
if (user == null)
{
return(null);
}
return(user.IsAuthorize);
}
/// <summary>
/// change user authorize status in database
/// </summary>
/// <param name="userId"></param>
/// <param name="value"></param>
/// <returns></returns>
public async Task <bool> ChangeUserIsAuthorizeSatusByUserIdAsync(string userId, string value)
{
var users = this.repository.All();
var usersAll = await EfExtensions.ToListAsyncSafe <ApplicationUser>(users);
var user = usersAll.SingleOrDefault(x => x.Id == userId);
bool.TryParse(value, out bool result);
user.IsAuthorize = result;
await this.repository.SaveAsync();
return(true);
}
public void ObjectStateUnchangedd_ConvertedToEfStateUnchanged()
{
var efSate = EfExtensions.ConvertToEFState(ObjectState.UNCHANGED);
efSate.Should().Be(EntityState.Unchanged);
}
public void ObjectStateDeleted_ConvertedToEfStateDelated()
{
var efSate = EfExtensions.ConvertToEFState(ObjectState.DELETED);
efSate.Should().Be(EntityState.Deleted);
}
public void ObjectStateModified_ConvertedToEfStateModified()
{
var efSate = EfExtensions.ConvertToEFState(ObjectState.MODIFIED);
efSate.Should().Be(EntityState.Modified);
}
public void ObjectStateNew_ConvertedToEfStateAdded()
{
var efSate = EfExtensions.ConvertToEFState(ObjectState.NEW);
efSate.Should().Be(EntityState.Added);
}
