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();
}
