public void GetAllRelevancesTest()
{
RelevanceRepository repository = new RelevanceRepository(resConnect);
string query = "SELECT * from dbo.Relevance";
List <Relevance> loadList = new List <Relevance>();
using (SqlConnection connection =
new SqlConnection(resConnect))
{
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
loadList.Add(
new Relevance(
idRelevance: (int)reader[0],
levelRelevance: (string)reader[1]
)
);
}
reader.Close();
}
int count = repository.GetAllRelevances().Count;
Assert.AreEqual(count, loadList.Count);
}
public NoteViewModel(Note note, NoteRepository noteRepository, DateTime selectedDate)
{
this._note = note;
this.noteRepository = noteRepository;
this.selectedDate = selectedDate;
typeJobRepository = new TypeJobRepository(Properties.Resources.ConnectCommand);
progressRepository = new ProgressRepository(Properties.Resources.ConnectCommand);
relevanceRepository = new RelevanceRepository(Properties.Resources.ConnectCommand);
TimeStartHours = note.TimeStart.Hours.ToString();
TimeStartMinutes = note.TimeStart.Minutes.ToString();
TimeFinishHours = note.TimeFinish.Hours.ToString();
TimeFinishMinutes = note.TimeFinish.Minutes.ToString();
}
public void GenerateNotes(
NoteRepository noteRepository,
int countNotes
)
{
if (noteRepository == null || countNotes < 1)
{
throw new ArgumentException("noteRepository is null or countNotes <0");
}
Random saintRandom = new Random();
DateTime dateNote = DateTime.Now.AddDays(-1);
List <TypeJob> typeJobs = new TypeJobRepository(Properties.Resources.ConnectCommand).GetAllTypeJobs();
List <Relevance> relevances = new RelevanceRepository(Properties.Resources.ConnectCommand).GetAllRelevances();
List <Progress> progresses = new ProgressRepository(Properties.Resources.ConnectCommand).GetAllProgresses();
for (int i = 0; i < countNotes; i++)
{
noteRepository.RemoveNotes(dateNote);
int[] timeLines = GetTimeLines();
for (int j = 0; j < timeLines.Length - 1; j += 1)
{
Note note = new Note();
note.NoteDate = dateNote;
note.TypeJob = typeJobs[saintRandom.Next(1, 6)];
note.Relevance = relevances[saintRandom.Next(1, 4)];
note.Progress = progresses[saintRandom.Next(1, 4)];
note.TimeStart = new TimeSpan(timeLines[j], 1, 0);
note.TimeFinish = new TimeSpan(timeLines[j + 1], 0, 0);
noteRepository.AddNote(note);
}
dateNote = dateNote.AddDays(-1);
}
}
