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