public static void Main(string[] args)
{
//CreateWebHostBuilder(args).Build().Run();
IWebHost host = CreateWebHostBuilder(args).Build();
using (IServiceScope scope = host.Services.CreateScope())
{
IServiceProvider services = scope.ServiceProvider;
try
{
DatabaseContext context = services.GetRequiredService <DatabaseContext>();
RoleManager <IdentityRole> roleManager = services.GetRequiredService <RoleManager <IdentityRole> >();
UserManager <ApplicationUser> userManager = services.GetRequiredService <UserManager <ApplicationUser> >();
SampleData.Initialize(context, roleManager, userManager);
ICategoryService categoryService = services.GetRequiredService <ICategoryService>();
IRegionService regionService = services.GetRequiredService <IRegionService>();
ICacheService cacheService = new CacheService();
cacheService.CacheCategories(categoryService);
cacheService.CacheRegions(regionService);
Microsoft.EntityFrameworkCore.DbSet <ApplicationUser> a = context.ApplicationUsers;
}
catch (Exception ex)
{
ILogger <Program> logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred while seeding the database.");
}
}
host.Run();
}
public static Page <T> GetPage <T>(this Microsoft.EntityFrameworkCore.DbSet <T> list, int page_index, int page_size, Func <T, object> order_by_selector)
where T : class
{
var res = list.OrderBy(order_by_selector)
.Skip(page_index * page_size)
.Take(page_size)
.ToArray();
if (res == null || res.Length == 0)
{
return(null);
}
var tot_items = list.Count();
var tot_pages = tot_items / page_size;
if (tot_items < page_size)
{
tot_pages = 1;
}
return(new Page <T>()
{
Index = page_index, Items = res, TotalPages = tot_pages
});
}
public DBMsSqlAuthRepository(string connectionstring, IOptions <AuthTokenOptions> tokenOption)
{
AuthorizaionContext = new AuthorizationContext(connectionstring);
TokenOption = tokenOption;
DbUser = AuthorizaionContext.User;
DbRole = AuthorizaionContext.Role;
DbUserRole = AuthorizaionContext.UserRole;
}
/// <summary>
/// <see cref="OnGetJednostki"/>
/// </summary>
/// <param name="jednostki">Zestaw jednostek z bazy danych.</param>
/// <returns>Lista jednostek kontrolowanych.</returns>
private IEnumerable <JednostkaKontrolowana> PrepareJednostki(Microsoft.EntityFrameworkCore.DbSet <JednostkaKontrolowana> jednostki)
{
var jednostkiKontrolowane = jednostki.ToList();
jednostkiKontrolowane.RemoveAt(0);
return(jednostkiKontrolowane.OrderBy(j => j.Nazwa).Prepend(new JednostkaKontrolowana()
{
Id = 0,
Nazwa = "Wybierz"
}));
}
public MotorBikeApiController(ApplicationDbContext appDbContext)
{
_appDdContext = appDbContext;
try
{
_bikes = _appDdContext.MotorBikes;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private static List <DTO.BatchDTO> buildVM(Microsoft.EntityFrameworkCore.DbSet <Batch> batches)
{
return(batches.Select(b => new DTO.BatchDTO
{
Id = b.Id,
Sku = b.Sku,
Name = b.Name,
FormSize = b.FormSize,
Quantity = b.Quantity,
Location = b.Location,
WholesalePrice = b.WholesalePrice
}).ToList());
}
public override void InitDb(WebCoreDbContext context)
{
Microsoft.EntityFrameworkCore.DbSet <MasterList> masterList = context.MasterLists;
if (masterList.Count() == 0)
{
masterList.Add(new MasterList()
{
Group = ConstantConfig.MasterListMasterGroup,
Value = ConstantConfig.MasterListMasterGroup,
RecordStatus = ConstantConfig.RecordStatusConfig.Active,
OrderNo = 0
});
context.SaveChanges();
}
}
protected void PrepareGalleriesList(IList <SelectListItem> items, bool withSpecialDefaultItem = true, string defaultItemText = null)
{
if (items == null)
{
throw new ArgumentNullException(nameof(items));
}
Microsoft.EntityFrameworkCore.DbSet <PhotoGallery> availableEtitors = _context.PhotoGalleries;
foreach (PhotoGallery item in availableEtitors)
{
items.Add(new SelectListItem {
Value = item.Id.ToString(), Text = item.Name
});
}
PrepareDefaultItem(items, withSpecialDefaultItem, defaultItemText);
}
/// <summary>
/// Get an entity if already existing or add it and return it's context if it doesn't already exist.
/// </summary>
/// <typeparam name="TEntity">Type of the data entity.</typeparam>
/// <param name="set">The databsae set to perform the query on.</param>
/// <param name="entity">The entity to perform the query on.</param>
/// <param name="identifierFunction">How the entity is unique.</param>
/// <returns>The instance of the processed entity.</returns>
public static TEntity GetOrAdd <TEntity>(this Microsoft.EntityFrameworkCore.DbSet <TEntity> set, TEntity entity, Func <TEntity, bool> identifierFunction) where TEntity : class
{
// Get the existing entity if any, else get null
TEntity existingEntity = set
.FirstOrDefault(identifierFunction);
// If there is an existing entity, return it
if (existingEntity != null)
{
return(existingEntity);
}
// If no entity of this kind exists, create it and return it
set.Add(entity);
return(entity);
}
public async Task Should_Get_List()
{
// Arrange
Venue venue = VenueSeedData.WeiherhofSchule;
Microsoft.EntityFrameworkCore.DbSet <Venue> mockVenues = MockDbSets.Venues;
mockVenues.FindAsync(Arg.Any <Guid>()).Returns(venue);
_arpaContext.Venues.Returns(mockVenues);
// Act
IImmutableList <Room> result = await _handler.Handle(
new Rooms.Query(venue.Id),
new CancellationToken());
// Assert
result.Should().BeEquivalentTo(venue.Rooms);
}
public static Option <Page <T> > GetPage <T>(this Microsoft.EntityFrameworkCore.DbSet <T> List, int Page_index, int page_size, Func <T, object> order_by_selector, Func <T, bool> filter_by_selector, bool descending)
where T : class
{
IOrderedEnumerable <T> resTMP;
if (descending)
{
resTMP = List
.Where(filter_by_selector)
.OrderByDescending(order_by_selector);
}
else
{
resTMP = List
.Where(filter_by_selector)
.OrderBy(order_by_selector);
}
T[] res = resTMP
.Skip(Page_index * page_size)
.Take(page_size)
.ToArray();
if (res == null || res.Length == 0)
{
return(new Empty <Page <T> >());
}
var tot_items = resTMP.Count();
var tot_pages = tot_items / page_size;
if (tot_items < page_size)
{
tot_pages = 1;
}
return(new Some <Page <T> >(new Page <T>()
{
Index = Page_index, Items = res, TotalPages = tot_pages
}));
}
public IActionResult EventRequests() //this is the administrator one to view requests and approve them just list each request, with a button for approval/denial, and status approved denied, denied get removed from this page
{
//logged in / out checking
bool Logged = isUserLoggedIn();
if (Logged == false)
{
ViewBag.LoggedInQ = "False";
}
//obtain security level of logged in user
var SecurityLevel = HttpContext.Session.Get("SecurityLevel");
string sSecurityLevel = Encoding.ASCII.GetString(SecurityLevel, 0, SecurityLevel.Length);
ViewBag.SecurityLevel = sSecurityLevel;
var isUserAdmin = sSecurityLevel;
if (isUserAdmin != "admin")
{
return(RedirectToAction("Error", "Home"));
}
List <Event> forView = new List <Event>();
Microsoft.EntityFrameworkCore.DbSet <Event> table = DatabaseContext.Events;
foreach (var alpha in table)
{
if (alpha.AcceptedQ == "Awaiting Approval" || alpha.AcceptedQ == "Denied")
{
forView.Add(alpha);
}
}
ViewData["EventTable"] = forView;
return(View());
}
static void PrintTable <T>(Microsoft.EntityFrameworkCore.DbSet <T> table) where T : class
{
/*
* IEnumerable<FieldList> properties = from p in typeof(T).GetProperties()
* where (from a in p.GetCustomAttributes(false)
* where a is EdmScalarPropertyAttribute
* select true).FirstOrDefault()
* select new FieldList
* {
* FieldName = p.Name,
* FieldType = p.PropertyType,
* FieldPK = p.GetCustomAttributes(false).Where(a => a is EdmScalarPropertyAttribute && ((EdmScalarPropertyAttribute)a).EntityKeyProperty).Count() > 0
* };
*/
var names = typeof(T).GetProperties().Select(property => property.Name).ToArray();
var consoleTable = new ConsoleTable(names);
var counter = 0;
foreach (var row in table)
{
var rowType = row.GetType();
var values = new object[names.Length];
counter = 0;
foreach (var name in names)
{
var value = rowType.GetProperty(name).GetValue(row);
values[counter] = value;
counter++;
}
consoleTable.AddRow(values);
}
consoleTable.Write(Format.MarkDown);
}
public Repository(EfContext context)
{
_context = context;
_entities = context.Set <TEntity>();
}
/// <summary>
/// Initializes a new instance of the <see cref="Repository<T>"/> class.
/// </summary>
/// <param name="dbContext">The db context.</param>
public Repository(UnitOfWork dbContext)
{
_dbContext = dbContext as UnitOfWork;
_dbSet = _dbContext.CreateDbSet <T>();
}
public BaseRepository(ApplicationContext context)
{
this.context = context;
this.dbSet = context.Set <T> ();
}
public static IQueryable <TResult> Select <TSource, TResult>(this Microsoft.EntityFrameworkCore.DbSet <TSource> obj, System.Linq.Expressions.Expression <Func <TSource, TResult> > predicate) where TSource : class
{
return(Queryable.Select(obj, predicate));
}
public static Page <T> GetPage <T>(this Microsoft.EntityFrameworkCore.DbSet <T> list, int page_index, int page_size, Func <T, object> order_by_selector, bool descending = false, Func <T, bool> filter_by_predicate = null)
where T : class
{
var res = list.OrderBy(order_by_selector)
.Skip(page_index * page_size)
.Take(page_size)
.ToArray();
if (descending == true)
{
res = list.OrderByDescending(order_by_selector)
.Skip(page_index * page_size)
.Take(page_size)
.ToArray();
}
var tot_items = list.Count();
if (descending == true)
{
if (filter_by_predicate != null)
{
res = list.Where(filter_by_predicate)
.OrderByDescending(order_by_selector)
.Skip(page_index * page_size)
.Take(page_size)
.ToArray();
tot_items = list.Where(filter_by_predicate)
.Count();
}
}
else
{
if (filter_by_predicate != null)
{
res = list.Where(filter_by_predicate)
.OrderBy(order_by_selector)
.Skip(page_index * page_size)
.Take(page_size)
.ToArray();
tot_items = list.Where(filter_by_predicate)
.Count();
}
}
if (res == null || res.Length == 0)
{
return(null);
}
var tot_pages = tot_items / page_size;
if (tot_items < page_size)
{
tot_pages = 1;
}
return(new Page <T>()
{
index = page_index, items = res, totalPages = tot_pages
});
}
public static Task <TEntity> FirstOrDefaultAsync <TEntity>(this Microsoft.EntityFrameworkCore.DbSet <TEntity> obj) where TEntity : class
{
return(Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.FirstOrDefaultAsync(obj));
}
public static Task <TEntity> FirstOrDefaultAsync <TEntity>(this Microsoft.EntityFrameworkCore.DbSet <TEntity> obj, System.Linq.Expressions.Expression <Func <TEntity, bool> > predicate) where TEntity : class
{
return(Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.FirstOrDefaultAsync(obj, predicate));
}
public static IQueryable <bool> Select <TEntity>(this Microsoft.EntityFrameworkCore.DbSet <TEntity> obj, System.Linq.Expressions.Expression <Func <TEntity, bool> > selector) where TEntity : class
{
return(System.Linq.Queryable.Select(obj, selector));
}
public FamilyRepository(DataContext context)
{
_context = context;
this.dbSet = context.Set <Family>();
}
public BaseRepository(ApplicationContext contexto)
{
this.contexto = contexto;
this.dbSet = contexto.Set <T>();
}
public override void InitDb(WebCoreDbContext context)
{
Microsoft.EntityFrameworkCore.DbSet <Language> languages = context.Languages;
if (languages.Count() == 0)
{
languages.Add(new Language()
{
LangCode = "ar-AE", LangName = "Arabic (U.A.E.)"
});
languages.Add(new Language()
{
LangCode = "ar-BH", LangName = "Arabic (Bahrain)"
});
languages.Add(new Language()
{
LangCode = "ar-DZ", LangName = "Arabic (Algeria)"
});
languages.Add(new Language()
{
LangCode = "ar-EG", LangName = "Arabic (Egypt)"
});
languages.Add(new Language()
{
LangCode = "ar-IQ", LangName = "Arabic (Iraq)"
});
languages.Add(new Language()
{
LangCode = "ar-JO", LangName = "Arabic (Jordan)"
});
languages.Add(new Language()
{
LangCode = "ar-KW", LangName = "Arabic (Kuwait)"
});
languages.Add(new Language()
{
LangCode = "ar-LB", LangName = "Arabic (Lebanon)"
});
languages.Add(new Language()
{
LangCode = "ar-LY", LangName = "Arabic (Libya)"
});
languages.Add(new Language()
{
LangCode = "ar-MA", LangName = "Arabic (Morocco)"
});
languages.Add(new Language()
{
LangCode = "ar-OM", LangName = "Arabic (Oman)"
});
languages.Add(new Language()
{
LangCode = "ar-QA", LangName = "Arabic (Qatar)"
});
languages.Add(new Language()
{
LangCode = "ar-SA", LangName = "Arabic (Saudi Arabia)"
});
languages.Add(new Language()
{
LangCode = "ar-SY", LangName = "Arabic (Syria)"
});
languages.Add(new Language()
{
LangCode = "ar-TN", LangName = "Arabic (Tunisia)"
});
languages.Add(new Language()
{
LangCode = "ar-YE", LangName = "Arabic (Yemen)"
});
languages.Add(new Language()
{
LangCode = "az-AZ", LangName = "Azeri (Latin) (Azerbaijan)"
});
languages.Add(new Language()
{
LangCode = "az-AZ", LangName = "Azeri (Cyrillic) (Azerbaijan)"
});
languages.Add(new Language()
{
LangCode = "be-BY", LangName = "Belarusian (Belarus)"
});
languages.Add(new Language()
{
LangCode = "bg-BG", LangName = "Bulgarian (Bulgaria)"
});
languages.Add(new Language()
{
LangCode = "bs-BA", LangName = "Bosnian (Bosnia and Herzegovina)"
});
languages.Add(new Language()
{
LangCode = "ca-ES", LangName = "Catalan (Spain)"
});
languages.Add(new Language()
{
LangCode = "cs-CZ", LangName = "Czech (Czech Republic)"
});
languages.Add(new Language()
{
LangCode = "cy-GB", LangName = "Welsh (United Kingdom)"
});
languages.Add(new Language()
{
LangCode = "da-DK", LangName = "Danish (Denmark)"
});
languages.Add(new Language()
{
LangCode = "de-AT", LangName = "German (Austria)"
});
languages.Add(new Language()
{
LangCode = "de-CH", LangName = "German (Switzerland)"
});
languages.Add(new Language()
{
LangCode = "de-DE", LangName = "German (Germany)"
});
languages.Add(new Language()
{
LangCode = "de-LI", LangName = "German (Liechtenstein)"
});
languages.Add(new Language()
{
LangCode = "de-LU", LangName = "German (Luxembourg)"
});
languages.Add(new Language()
{
LangCode = "dv-MV", LangName = "Divehi (Maldives)"
});
languages.Add(new Language()
{
LangCode = "el-GR", LangName = "Greek (Greece)"
});
languages.Add(new Language()
{
LangCode = "en-AU", LangName = "English (Australia)"
});
languages.Add(new Language()
{
LangCode = "en-BZ", LangName = "English (Belize)"
});
languages.Add(new Language()
{
LangCode = "en-CA", LangName = "English (Canada)"
});
languages.Add(new Language()
{
LangCode = "en-CB", LangName = "English (Caribbean)"
});
languages.Add(new Language()
{
LangCode = "en-GB", LangName = "English (United Kingdom)"
});
languages.Add(new Language()
{
LangCode = "en-IE", LangName = "English (Ireland)"
});
languages.Add(new Language()
{
LangCode = "en-JM", LangName = "English (Jamaica)"
});
languages.Add(new Language()
{
LangCode = "en-NZ", LangName = "English (New Zealand)"
});
languages.Add(new Language()
{
LangCode = "en-PH", LangName = "English (Republic of the Philippines)"
});
languages.Add(new Language()
{
LangCode = "en-TT", LangName = "English (Trinidad and Tobago)"
});
languages.Add(new Language()
{
LangCode = "en-US", LangName = "English (United States)"
});
languages.Add(new Language()
{
LangCode = "en-ZA", LangName = "English (South Africa)"
});
languages.Add(new Language()
{
LangCode = "en-ZW", LangName = "English (Zimbabwe)"
});
languages.Add(new Language()
{
LangCode = "es-AR", LangName = "Spanish (Argentina)"
});
languages.Add(new Language()
{
LangCode = "es-BO", LangName = "Spanish (Bolivia)"
});
languages.Add(new Language()
{
LangCode = "es-CL", LangName = "Spanish (Chile)"
});
languages.Add(new Language()
{
LangCode = "es-CO", LangName = "Spanish (Colombia)"
});
languages.Add(new Language()
{
LangCode = "es-CR", LangName = "Spanish (Costa Rica)"
});
languages.Add(new Language()
{
LangCode = "es-DO", LangName = "Spanish (Dominican Republic)"
});
languages.Add(new Language()
{
LangCode = "es-EC", LangName = "Spanish (Ecuador)"
});
languages.Add(new Language()
{
LangCode = "es-ES", LangName = "Spanish (Castilian)"
});
languages.Add(new Language()
{
LangCode = "es-ES", LangName = "Spanish (Spain)"
});
languages.Add(new Language()
{
LangCode = "es-GT", LangName = "Spanish (Guatemala)"
});
languages.Add(new Language()
{
LangCode = "es-HN", LangName = "Spanish (Honduras)"
});
languages.Add(new Language()
{
LangCode = "es-MX", LangName = "Spanish (Mexico)"
});
languages.Add(new Language()
{
LangCode = "es-NI", LangName = "Spanish (Nicaragua)"
});
languages.Add(new Language()
{
LangCode = "es-PA", LangName = "Spanish (Panama)"
});
languages.Add(new Language()
{
LangCode = "es-PE", LangName = "Spanish (Peru)"
});
languages.Add(new Language()
{
LangCode = "es-PR", LangName = "Spanish (Puerto Rico)"
});
languages.Add(new Language()
{
LangCode = "es-PY", LangName = "Spanish (Paraguay)"
});
languages.Add(new Language()
{
LangCode = "es-SV", LangName = "Spanish (El Salvador)"
});
languages.Add(new Language()
{
LangCode = "es-UY", LangName = "Spanish (Uruguay)"
});
languages.Add(new Language()
{
LangCode = "es-VE", LangName = "Spanish (Venezuela)"
});
languages.Add(new Language()
{
LangCode = "et-EE", LangName = "Estonian (Estonia)"
});
languages.Add(new Language()
{
LangCode = "eu-ES", LangName = "Basque (Spain)"
});
languages.Add(new Language()
{
LangCode = "fa-IR", LangName = "Farsi (Iran)"
});
languages.Add(new Language()
{
LangCode = "fi-FI", LangName = "Finnish (Finland)"
});
languages.Add(new Language()
{
LangCode = "fo-FO", LangName = "Faroese (Faroe Islands)"
});
languages.Add(new Language()
{
LangCode = "fr-BE", LangName = "French (Belgium)"
});
languages.Add(new Language()
{
LangCode = "fr-CA", LangName = "French (Canada)"
});
languages.Add(new Language()
{
LangCode = "fr-CH", LangName = "French (Switzerland)"
});
languages.Add(new Language()
{
LangCode = "fr-FR", LangName = "French (France)"
});
languages.Add(new Language()
{
LangCode = "fr-LU", LangName = "French (Luxembourg)"
});
languages.Add(new Language()
{
LangCode = "fr-MC", LangName = "French (Principality of Monaco)"
});
languages.Add(new Language()
{
LangCode = "gl-ES", LangName = "Galician (Spain)"
});
languages.Add(new Language()
{
LangCode = "gu-IN", LangName = "Gujarati (India)"
});
languages.Add(new Language()
{
LangCode = "he-IL", LangName = "Hebrew (Israel)"
});
languages.Add(new Language()
{
LangCode = "hi-IN", LangName = "Hindi (India)"
});
languages.Add(new Language()
{
LangCode = "hr-BA", LangName = "Croatian (Bosnia and Herzegovina)"
});
languages.Add(new Language()
{
LangCode = "hr-HR", LangName = "Croatian (Croatia)"
});
languages.Add(new Language()
{
LangCode = "hu-HU", LangName = "Hungarian (Hungary)"
});
languages.Add(new Language()
{
LangCode = "hy-AM", LangName = "Armenian (Armenia)"
});
languages.Add(new Language()
{
LangCode = "id-ID", LangName = "Indonesian (Indonesia)"
});
languages.Add(new Language()
{
LangCode = "is-IS", LangName = "Icelandic (Iceland)"
});
languages.Add(new Language()
{
LangCode = "it-CH", LangName = "Italian (Switzerland)"
});
languages.Add(new Language()
{
LangCode = "it-IT", LangName = "Italian (Italy)"
});
languages.Add(new Language()
{
LangCode = "ja-JP", LangName = "Japanese (Japan)"
});
languages.Add(new Language()
{
LangCode = "ka-GE", LangName = "Georgian (Georgia)"
});
languages.Add(new Language()
{
LangCode = "kk-KZ", LangName = "Kazakh (Kazakhstan)"
});
languages.Add(new Language()
{
LangCode = "kn-IN", LangName = "Kannada (India)"
});
languages.Add(new Language()
{
LangCode = "ko-KR", LangName = "Korean (Korea)"
});
languages.Add(new Language()
{
LangCode = "kok-I", LangName = "Konkani (India)"
});
languages.Add(new Language()
{
LangCode = "ky-KG", LangName = "Kyrgyz (Kyrgyzstan)"
});
languages.Add(new Language()
{
LangCode = "lt-LT", LangName = "Lithuanian (Lithuania)"
});
languages.Add(new Language()
{
LangCode = "lv-LV", LangName = "Latvian (Latvia)"
});
languages.Add(new Language()
{
LangCode = "mi-NZ", LangName = "Maori (New Zealand)"
});
languages.Add(new Language()
{
LangCode = "mk-MK", LangName = "FYRO Macedonian (Former Yugoslav Republic of Macedonia)"
});
languages.Add(new Language()
{
LangCode = "mn-MN", LangName = "Mongolian (Mongolia)"
});
languages.Add(new Language()
{
LangCode = "mr-IN", LangName = "Marathi (India)"
});
languages.Add(new Language()
{
LangCode = "ms-BN", LangName = "Malay (Brunei Darussalam)"
});
languages.Add(new Language()
{
LangCode = "ms-MY", LangName = "Malay (Malaysia)"
});
languages.Add(new Language()
{
LangCode = "mt-MT", LangName = "Maltese (Malta)"
});
languages.Add(new Language()
{
LangCode = "nb-NO", LangName = "Norwegian (Bokm?l) (Norway)"
});
languages.Add(new Language()
{
LangCode = "nl-BE", LangName = "Dutch (Belgium)"
});
languages.Add(new Language()
{
LangCode = "nl-NL", LangName = "Dutch (Netherlands)"
});
languages.Add(new Language()
{
LangCode = "nn-NO", LangName = "Norwegian (Nynorsk) (Norway)"
});
languages.Add(new Language()
{
LangCode = "ns-ZA", LangName = "Northern Sotho (South Africa)"
});
languages.Add(new Language()
{
LangCode = "pa-IN", LangName = "Punjabi (India)"
});
languages.Add(new Language()
{
LangCode = "pl-PL", LangName = "Polish (Poland)"
});
languages.Add(new Language()
{
LangCode = "ps-AR", LangName = "Pashto (Afghanistan)"
});
languages.Add(new Language()
{
LangCode = "pt-BR", LangName = "Portuguese (Brazil)"
});
languages.Add(new Language()
{
LangCode = "pt-PT", LangName = "Portuguese (Portugal)"
});
languages.Add(new Language()
{
LangCode = "qu-BO", LangName = "Quechua (Bolivia)"
});
languages.Add(new Language()
{
LangCode = "qu-EC", LangName = "Quechua (Ecuador)"
});
languages.Add(new Language()
{
LangCode = "qu-PE", LangName = "Quechua (Peru)"
});
languages.Add(new Language()
{
LangCode = "ro-RO", LangName = "Romanian (Romania)"
});
languages.Add(new Language()
{
LangCode = "ru-RU", LangName = "Russian (Russia)"
});
languages.Add(new Language()
{
LangCode = "sa-IN", LangName = "Sanskrit (India)"
});
languages.Add(new Language()
{
LangCode = "se-FI", LangName = "Sami (Northern) (Finland)"
});
languages.Add(new Language()
{
LangCode = "se-FI", LangName = "Sami (Skolt) (Finland)"
});
languages.Add(new Language()
{
LangCode = "se-FI", LangName = "Sami (Inari) (Finland)"
});
languages.Add(new Language()
{
LangCode = "se-NO", LangName = "Sami (Northern) (Norway)"
});
languages.Add(new Language()
{
LangCode = "se-NO", LangName = "Sami (Lule) (Norway)"
});
languages.Add(new Language()
{
LangCode = "se-NO", LangName = "Sami (Southern) (Norway)"
});
languages.Add(new Language()
{
LangCode = "se-SE", LangName = "Sami (Northern) (Sweden)"
});
languages.Add(new Language()
{
LangCode = "se-SE", LangName = "Sami (Lule) (Sweden)"
});
languages.Add(new Language()
{
LangCode = "se-SE", LangName = "Sami (Southern) (Sweden)"
});
languages.Add(new Language()
{
LangCode = "sk-SK", LangName = "Slovak (Slovakia)"
});
languages.Add(new Language()
{
LangCode = "sl-SI", LangName = "Slovenian (Slovenia)"
});
languages.Add(new Language()
{
LangCode = "sq-AL", LangName = "Albanian (Albania)"
});
languages.Add(new Language()
{
LangCode = "sr-BA", LangName = "Serbian (Latin) (Bosnia and Herzegovina)"
});
languages.Add(new Language()
{
LangCode = "sr-BA", LangName = "Serbian (Cyrillic) (Bosnia and Herzegovina)"
});
languages.Add(new Language()
{
LangCode = "sr-SP", LangName = "Serbian (Latin) (Serbia and Montenegro)"
});
languages.Add(new Language()
{
LangCode = "sr-SP", LangName = "Serbian (Cyrillic) (Serbia and Montenegro)"
});
languages.Add(new Language()
{
LangCode = "sv-FI", LangName = "Swedish (Finland)"
});
languages.Add(new Language()
{
LangCode = "sv-SE", LangName = "Swedish (Sweden)"
});
languages.Add(new Language()
{
LangCode = "sw-KE", LangName = "Swahili (Kenya)"
});
languages.Add(new Language()
{
LangCode = "syr-S", LangName = "Syriac (Syria)"
});
languages.Add(new Language()
{
LangCode = "ta-IN", LangName = "Tamil (India)"
});
languages.Add(new Language()
{
LangCode = "te-IN", LangName = "Telugu (India)"
});
languages.Add(new Language()
{
LangCode = "th-TH", LangName = "Thai (Thailand)"
});
languages.Add(new Language()
{
LangCode = "tl-PH", LangName = "Tagalog (Philippines)"
});
languages.Add(new Language()
{
LangCode = "tn-ZA", LangName = "Tswana (South Africa)"
});
languages.Add(new Language()
{
LangCode = "tr-TR", LangName = "Turkish (Turkey)"
});
languages.Add(new Language()
{
LangCode = "tt-RU", LangName = "Tatar (Russia)"
});
languages.Add(new Language()
{
LangCode = "uk-UA", LangName = "Ukrainian (Ukraine)"
});
languages.Add(new Language()
{
LangCode = "ur-PK", LangName = "Urdu (Islamic Republic of Pakistan)"
});
languages.Add(new Language()
{
LangCode = "uz-UZ", LangName = "Uzbek (Latin) (Uzbekistan)"
});
languages.Add(new Language()
{
LangCode = "uz-UZ", LangName = "Uzbek (Cyrillic) (Uzbekistan)"
});
languages.Add(new Language()
{
LangCode = "vi-VN", LangName = "Vietnamese (Viet Nam)"
});
languages.Add(new Language()
{
LangCode = "xh-ZA", LangName = "Xhosa (South Africa)"
});
languages.Add(new Language()
{
LangCode = "zh-CN", LangName = "Chinese (S)"
});
languages.Add(new Language()
{
LangCode = "zh-HK", LangName = "Chinese (Hong Kong)"
});
languages.Add(new Language()
{
LangCode = "zh-MO", LangName = "Chinese (Macau)"
});
languages.Add(new Language()
{
LangCode = "zh-SG", LangName = "Chinese (Singapore)"
});
languages.Add(new Language()
{
LangCode = "zh-TW", LangName = "Chinese (T)"
});
languages.Add(new Language()
{
LangCode = "zu-ZA", LangName = "Zulu (South Africa)"
});
context.SaveChanges();
}
}
public BaseRepository(ApplicationContext context, IConfiguration configuration)
{
this.configuration = configuration;
this.context = context;
dbSet = context.Set <T>();
}
public static IAsyncEnumerable <TEntity> AsAsyncEnumerable <TEntity>(this Microsoft.EntityFrameworkCore.DbSet <TEntity> obj) where TEntity : class
{
return(Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.AsAsyncEnumerable(obj));
}
public BaseRepository(ApplicationContext contexto)
{
this.contexto = contexto;
// comando para não permitir que elementos duplicados entrem no banco
dbSet = contexto.Set <T>();
}
public static IQueryable <TEntity> Where <TEntity>(this Microsoft.EntityFrameworkCore.DbSet <TEntity> obj, System.Linq.Expressions.Expression <Func <TEntity, bool> > predicate) where TEntity : class
{
return(System.Linq.Queryable.Where(obj, predicate));
}
public static void Clear <T>(this Microsoft.EntityFrameworkCore.DbSet <T> dbSet) where T : BaseEntity
{
dbSet.RemoveRange(dbSet);
}
