public ContentResult JSON() { using (var db = new baseContext()) { // var result = (from tags in db.membernews // orderby tags.date_Of_Comment ascending // select new { tags.title_selected_news, tags.like_dislike }).ToList(); double count = 50, y = 10; Random random = new Random(DateTime.Now.Millisecond); List <DataPoint> dataPoints; dataPoints = new List <DataPoint>(); for (int i = 0; i < count; i++) { y = y + (random.Next(0, 20) - 10); dataPoints.Add(new DataPoint(i, y)); } JsonSerializerSettings _jsonSetting = new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore }; return(Content(JsonConvert.SerializeObject(dataPoints, _jsonSetting), "application/json")); } }
// GET: Stat public ActionResult Index() { using (var db = new baseContext()) { var result = db.membernews.ToList(); var resultat1 = result.GroupBy(u => u.Id_News); List <MemberStatsModels> list = new List <MemberStatsModels>(); foreach (var membernew in resultat1) { String title = ""; int countLike = 0; int countDislike = 0; foreach (var membernew1 in membernew) { if (membernew1.like_dislike == 0) { countDislike = countDislike + 1; } else { countLike = countLike + 1; } title = membernew1.title_selected_news; } list.Add(new MemberStatsModels { title_selected_news = title, like_count = countLike, dislikke_count = countDislike }); } return(View(list)); } }
public PatternGenerator(int numberOfRowsToGenerate, DatabaseColumn column, baseContext ctx) { this.NumberOfRowsToGenerate = numberOfRowsToGenerate; this.Column = column; this.ctx = ctx; this.pattern = column.Pattern; }
public UserService(baseContext ctx, IOptions <AppSettings> appSettings) { this.ctx = ctx; //get logins _logins = ctx.Logins.ToList(); _appSettings = appSettings.Value; }
public PostgresqlDatabaseLoader(ConnectionTable connectionProps, int connectionId, List <Stereotype> stereotypes, List <GenerationMode> generationModes, List <NameMapping> mappings, baseContext ctx, string password) { this.connectionProps = connectionProps; this.connectionId = connectionId; this.stereotypes = stereotypes; this.generationModes = generationModes; this.mappings = mappings; this.ctx = ctx; this.password = password; }
public JsonResult GetData() { using (var db = new baseContext()) { var result = (from tags in db.membernews orderby tags.date_Of_Comment ascending select new { tags.title_selected_news, tags.like_dislike }).ToList(); return(Json(JsonConvert.SerializeObject(result), JsonRequestBehavior.AllowGet)); //return Content(JsonConvert.SerializeObject(_dataPoints), "application/json"); //JsonSerializerSettings _jsonSetting = new JsonSerializerSettings() { NullValueHandling = NullValueHandling.Ignore }; // return Content(JsonConvert.SerializeObject(result, _jsonSetting), "application/json"); } }
public FirstNameGenerator(baseContext ctx, bool unique) { this.random = new Random(); this.isUnique = unique; List <string> listOfAllFemaleNames = ctx.FirstNameFemaleGlobals.Select(c => c.Name).ToList(); List <string> listOfAllMaleNames = ctx.FirstNameMaleGlobals.Select(c => c.Name).ToList(); firstNames = new List <string>(); firstNames.AddRange(listOfAllMaleNames); firstNames.AddRange(listOfAllFemaleNames); this.alreadyUsedIndexes = new List <byte>(firstNames.Count()); for (int i = 0; i < firstNames.Count(); i++) { alreadyUsedIndexes.Add(0); } this.counter = 0; }
public static IKeywordGenerator getGenerator(string keyword, baseContext ctx, DatabaseColumn databaseColumn) { Regex r = new Regex(@"integer ?[0-9]*,?[0-9]*,?[0-9]*( u)?"); if (r.IsMatch(keyword)) { return(new IntegerGenerator(keyword)); } keyword = keyword.ToLower(); keyword = keyword.Trim(); string[] keywords; bool[] uniques; // Look for combined keywords if (keyword.Contains('|')) { keywords = keyword.Split('|'); } else { keywords = new string[1]; keywords[0] = keyword; } uniques = new bool[keywords.Length]; List <List <string> > listsOfValues = new List <List <string> >(keywords.Length); for (int i = 0; i < keywords.Length; i++) { string currentKeyword = keywords[i]; List <string> values; bool isUnique = currentKeyword.EndsWith(" u"); if (isUnique) { currentKeyword = currentKeyword[0..^ 2];
public static List <string> Generate(baseContext ctx, int numberOfRowsToGenerate, DatabaseColumn column, Dictionary <string, List <string> > valuesGeneratedForDatabase, int sqlPlatformId, DatabaseTable table) { List <string> listOfValues = new List <string>(); switch (column.GenerationModeId) { case SERIAL_ID: listOfValues = IntegerGeneratorsClass.GenerateListOfSerials(numberOfRowsToGenerate); break; case COUNTRY_NAME_RANDOM_ENGLISH_ID: listOfValues = new LimitCharactersDecorator(new RandomCountryesEnglish(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); //CountryGenerators.GenerateListOfRandomCountryesEnglish(numberOfRowsToGenerate, ctx, column.MaxNumber); break; case COUNTRY_NAME_SEQUENTIAL_ENGLISH_ID: listOfValues = new LimitCharactersDecorator(new SequentialCountryesEnglish(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); break; case COUNTRY_SHORT_RANDOM_ENGLISH_ID: listOfValues = new LimitCharactersDecorator(new RandomCountryShortsEnglish(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); break; case COUNTRY_SHORT_SEQUENTIAL_ENGLISH_ID: listOfValues = new LimitCharactersDecorator(new SequentialCountryShortsEnglish(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); break; case NAME_RANDOM_GLOBAL_ID: listOfValues = new LimitCharactersDecorator(new NamesRandomGlobal(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); //NameGenerators.GenerateListOfRandomNamesGlobal(numberOfRowsToGenerate, ctx); break; case NAME_FEMALE_RANDOM_GLOBAL_ID: listOfValues = new LimitCharactersDecorator(new FemaleNamesRandomGlobal(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); break; case NAME_MALE_RANDOM_GLOBAL_ID: listOfValues = new LimitCharactersDecorator(new MaleNamesGlobal(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); break; case LAST_NAME_RANDOM_GLOBAL_ID: listOfValues = new LimitCharactersDecorator(new LastNameRandomGlobal(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); break; case VARCHAR_PATTERN: listOfValues = new LimitCharactersDecorator(new PatternGenerator(numberOfRowsToGenerate, column, ctx)).GenerateVarchar(); break; case FOREIGN_KEY_RANDOM_ID: listOfValues = ForeignKeyGeneratorsClass.GenerateRandomValuesForForeignKey(numberOfRowsToGenerate, valuesGeneratedForDatabase, column, table); break; case FOREIGN_KEY_RANDOM_10PER_NULL_ID: listOfValues = ForeignKeyGeneratorsClass.GenerateRandomValuesForForeignKey10PercentNull(numberOfRowsToGenerate, valuesGeneratedForDatabase, column, table); break; case FOREIGN_KEY_ORDERED_UNIQUE: listOfValues = ForeignKeyGeneratorsClass.GenerateOrderedUniqueValuesForForeignKey(numberOfRowsToGenerate, valuesGeneratedForDatabase, column, table); break; case FOREIGN_KEY_ORDERED_REPEATED: listOfValues = ForeignKeyGeneratorsClass.GenerateOrderedRepeatedForeignKey(numberOfRowsToGenerate, valuesGeneratedForDatabase, column, table); break; case INTEGER_RANDOM_FROM_INTERVAL_ID: listOfValues = IntegerGeneratorsClass.GenerateListOfRandomIntegersInInterval(numberOfRowsToGenerate, column.MinNumber, column.MaxNumber, column, table, valuesGeneratedForDatabase); break; case INTEGER_ORDERED_REPEATED: listOfValues = IntegerGeneratorsClass.GenerateIncrementAfterN(numberOfRowsToGenerate, column); break; case INTEGER_COUNTRY_POPULATION: listOfValues = ctx.Countries.Select(c => c.Inhabitants.ToString()).ToList(); break; case SMALLINT_RANDOM_FROM_INTERVAL_ID: listOfValues = IntegerGeneratorsClass.GenerateListOfRandomShortsInInterval(numberOfRowsToGenerate, column.MinNumber, column.MaxNumber, column, table, valuesGeneratedForDatabase); break; case BIGINT_RANDOM: listOfValues = IntegerGeneratorsClass.GenerateListOfRandomLongsInInterval(numberOfRowsToGenerate, column.MinNumber, column.MaxNumber, column, table, valuesGeneratedForDatabase); break; case NUMBERIC_RANDOM_FROM_INTERVAL: listOfValues = NumericGeneratorsClass.GenerateListOfRandomNumbericFromInterval(numberOfRowsToGenerate, column, table, valuesGeneratedForDatabase); break; case FLOAT_RANDOM: listOfValues = NumericGeneratorsClass.GenerateListOfRandomNumbericFromInterval(numberOfRowsToGenerate, column, table, valuesGeneratedForDatabase); break; case DOUBLE_RANDOM: listOfValues = NumericGeneratorsClass.GenerateListOfRandomNumbericFromInterval(numberOfRowsToGenerate, column, table, valuesGeneratedForDatabase); break; case DATE_RANDOM_FROM_INTERVAL_ID: string sqlPlatformName = ctx.SqlPlatforms.Where(p => p.SqlPlatformId == sqlPlatformId).FirstOrDefault().Name; listOfValues = DateGeneratorsClass.GenerateListOfDatesInInterval(numberOfRowsToGenerate, column, table, sqlPlatformName, valuesGeneratedForDatabase); break; case TIMESTAMPWOTZ_RANDOM_FROM_INTERVAL_ID: sqlPlatformName = ctx.SqlPlatforms.Where(p => p.SqlPlatformId == sqlPlatformId).FirstOrDefault().Name; listOfValues = TimestampWOTZGenerator.GenerateListOfTimestampsWOTZInInterval(numberOfRowsToGenerate, sqlPlatformName, column, table, valuesGeneratedForDatabase); break; case INTERVAL_RANDOM_FROM_RANGE: sqlPlatformName = ctx.SqlPlatforms.Where(p => p.SqlPlatformId == sqlPlatformId).FirstOrDefault().Name; listOfValues = IntervalGeneratorClass.GenerateListOfIntervalsFromRange(numberOfRowsToGenerate, column.TimeFrom, column.TimeTo, sqlPlatformName); break; case BOOLEAN_TRUE: listOfValues = BooleanGeneratorsClass.GenerateListOfTrue(numberOfRowsToGenerate); break; case BOOLEAN_FALSE: listOfValues = BooleanGeneratorsClass.GenerateListOfFalse(numberOfRowsToGenerate); break; default: throw new GenerationException($"Invalid generation mode id: {column.GenerationModeId}"); } return(listOfValues); }
public RandomCountryesEnglish(int numberOfRowsToGenerate, DatabaseColumn column, baseContext ctx) { this.NumberOfRowsToGenerate = numberOfRowsToGenerate; this.Column = column; this.ctx = ctx; }
public AdminAuthorize() { AdminContext = new baseContext(); }
public RegisterController(baseContext ctx, IUserService userService) { this.ctx = ctx; _userService = userService; }
public FemaleNamesRandomGlobal(int numberOfRowsToGenerate, DatabaseColumn column, baseContext ctx) { this.NumberOfRowsToGenerate = numberOfRowsToGenerate; this.Column = column; this.ctx = ctx; }
public DatabaseFactory() { dataContext = new baseContext(); }
public ConnectionController(baseContext ctx) { this.ctx = ctx; }
public SequentialCountryShortsEnglish(int numberOfRowsToGenerate, DatabaseColumn column, baseContext ctx) { this.NumberOfRowsToGenerate = numberOfRowsToGenerate; this.Column = column; this.ctx = ctx; }
public CountryController(baseContext ctx) { this.ctx = ctx; }
public StereotypeController(baseContext ctx, IUserService userService) { this.ctx = ctx; _userService = userService; }
public UnitOfWork(IDatabaseFactory dbFactory) { this.dbFactory = dbFactory; dataContext = dbFactory.DataContext; }
public AdminController() { db_context = new baseContext(); }
public static async Task getSavedData(int connectionId, List <DatabaseTable> tablesDirectlyFromForeignDatabase, baseContext ctx) { //get stereotypes var stereotypes = await ctx.Stereotypes.ToListAsync(); ctx.Stereotypes.ToList(); //get stereotype mappings var mappings = await ctx.NameMappings.ToListAsync(); //load all tables stored for connection var storedTablesInApplicationDatabase = await ctx.DatabaseTables.Where(t => t.ConnectionId == connectionId).Include(t => t.DatabaseColumns).ToListAsync(); //for each stored table received from stored database look for stored values foreach (var tableFromForeignDatabase in tablesDirectlyFromForeignDatabase) { // Copy relevant information for table from application database. var tableFromApplicationDatabase = storedTablesInApplicationDatabase.Find(t => t == tableFromForeignDatabase); //if there is no table stored in application database then continue since we have no data for it if (tableFromApplicationDatabase == null) { continue; } tableFromForeignDatabase.CopyRelevantGenerationValues(tableFromApplicationDatabase); //if table exists look for any columns stored in application database which correspond with foreign database foreach (var columnFromForeignDatabase in tableFromForeignDatabase.DatabaseColumns) { //find coresponding column var columnFromApplicationDatabase = tableFromApplicationDatabase.DatabaseColumns.Where(c => c == columnFromForeignDatabase && c.TableId == tableFromApplicationDatabase.TableId).FirstOrDefault(); if (columnFromApplicationDatabase == null) { continue; } //if new column is confirmed to be of different ignore it if (columnFromApplicationDatabase != columnFromForeignDatabase) { continue; } //if columns is good copy values from it columnFromForeignDatabase.CopyRelevantGenerationValues(columnFromApplicationDatabase); } } return; }
public AdminNewsController() { bd_context = new baseContext(); }