public void GetAllTimesReturnsRightResult()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
ApplicationDbContext dbContext = new ApplicationDbContext(options);
List <SolveTime> solveTimes = new List <SolveTime>()
{
new SolveTime()
{
Id = 1
},
new SolveTime()
{
Id = 2
},
};
dbContext.SolveTimes.AddRange(solveTimes);
dbContext.SaveChanges();
TimesService timesService = new TimesService(dbContext);
List <SolveTime> resultSolveTimes = timesService.GetAllTimes();
Assert.AreEqual(solveTimes, resultSolveTimes);
}
public void AddTimeReturnsTrueWhenTimeIsAddedCorrectlly()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
ApplicationDbContext dbContext = new ApplicationDbContext(options);
TimesService timesService = new TimesService(dbContext);
string userId = "id";
SolveTime solveTime = new SolveTime()
{
};
User user = new User()
{
Id = userId
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
bool result = timesService.AddTime(solveTime, userId);
Assert.AreEqual(true, result);
}
public void AddTimeReturnsFalseWhenUserDoesntExist()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
ApplicationDbContext dbContext = new ApplicationDbContext(options);
TimesService timesService = new TimesService(dbContext);
string userId = "id";
SolveTime solveTime = new SolveTime()
{
Id = 1
};
User user = new User()
{
Id = userId
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
bool result = timesService.AddTime(solveTime, "randomId");
Assert.AreEqual(false, result);
}
public void AddTimeAddsTimeCorrectly()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
ApplicationDbContext dbContext = new ApplicationDbContext(options);
TimesService timesService = new TimesService(dbContext);
string userId = "id";
SolveTime solveTime = new SolveTime()
{
Id = 1
};
User user = new User()
{
Id = userId
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
timesService.AddTime(solveTime, userId);
int userSolveTimesCount = dbContext.Users.FirstOrDefault(u => u.Id == userId).SolveTimes.Count;
Assert.AreEqual(1, userSolveTimesCount);
}
public void GetAllUserTimesResutsRightResult()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
ApplicationDbContext dbContext = new ApplicationDbContext(options);
string username = "******";
List <SolveTime> solveTimes = new List <SolveTime>()
{
new SolveTime()
{
Id = 1
}
};
User user = new User()
{
UserName = username,
SolveTimes = solveTimes
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
TimesService timesService = new TimesService(dbContext);
List <SolveTime> resultSolveTimes = timesService.GetAllUserTimes(username);
Assert.AreEqual(solveTimes, resultSolveTimes);
}
private void GenerateList()
{
_service = new TimesService();
_competitionService = new CompetitionService();
_table = _competitionService.SelectCompetitionFinish();
_list = new List <string>();
_ids = new List <long>();
foreach (DataRow row in _table.Rows)
{
_ids.Add(long.Parse(row[_table.Columns.IndexOf("Competition_ID")].ToString()));
_list.Add(row[_table.Columns.IndexOf("Competition_Name")].ToString());
}
CompetitionList.ItemsSource = _list;
}
public AllTimes(CompetitionDto competition, IEnumerable <AbsoluteCategory> categories)
{
_competition = competition;
_categories = categories;
_tables = new DataTable[_categories.Count(), 2];
_service = new TimesService();
InitializeComponent();
//botones
var customButton = new Button {
Content = Properties.Resources.Close, Margin = new Thickness(4)
};
customButton.Click += (ss, ee) => { Close(); };
var printButton = new Button {
Content = Properties.Resources.Print, Margin = new Thickness(4)
};
printButton.Click += ButtonBase_OnClick;
Buttons = new[] { printButton, customButton };
for (var i = 0; i < _categories.Count(); i++)
{
for (var j = 0; j < 2; j++)
{
var dataGrid = new DataGrid();
dataGrid.Margin = new Thickness(10);
dataGrid.HorizontalAlignment = HorizontalAlignment.Stretch;
dataGrid.PreviewMouseWheel += DataGridOnPreviewMouseWheel;
GenerateDatagrid(i, j);
if (_tables[i, j] != null)
{
Layout.Children.Add(getLabel(i, j));
dataGrid.ItemsSource = _tables[i, j].DefaultView;
dataGrid.MinColumnWidth = 10;
Layout.Children.Add(dataGrid);
}
}
}
}
public void AddTimesReturnsRightResult()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
ApplicationDbContext dbContext = new ApplicationDbContext(options);
TimesService timesService = new TimesService(dbContext);
string userId = "id";
List <SolveTime> solveTimes = new List <SolveTime>()
{
new SolveTime()
{
Id = 1
},
new SolveTime()
{
Id = 2
},
};
User user = new User()
{
Id = userId,
};
dbContext.Users.Add(user);
dbContext.SaveChanges();
timesService.AddTimes(solveTimes, userId);
var userSolveTimesCount = dbContext
.Users
.FirstOrDefault(u => u.Id == userId)
.SolveTimes
.Count;
Assert.AreEqual(solveTimes.Count, userSolveTimesCount);
}
private void Initialize()
{
_service = new TimesService();
_competitionService = new CompetitionService();
_table = _competitionService.SelectCompetitionFinish();
_list = new List <string>();
_ids = new List <long>();
foreach (DataRow row in _table.Rows)
{
_ids.Add(long.Parse(row[_table.Columns.IndexOf("Competition_ID")].ToString()));
_list.Add(row[_table.Columns.IndexOf("Competition_Name")].ToString());
}
CompetitionList.ItemsSource = _list;
if (_list.Count > 0 && Competition == null)
{
CompetitionList.SelectedIndex = 0;
}
}
public LoadFilePartialTimes()
{
service = new AthletesService();
timesService = new TimesService();
InitializeComponent();
}