public void GetAllTypeJobsTest()
{
TypeJobRepository repository = new TypeJobRepository(resConnect);
string query = "SELECT * from dbo.Type_job";
List <TypeJob> loadList = new List <TypeJob>();
using (SqlConnection connection =
new SqlConnection(resConnect))
{
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
loadList.Add(
new TypeJob(
idTypeJob: (int)reader[0],
nameTypeJob: (string)reader[1]
)
);
}
reader.Close();
}
int count = repository.GetAllTypeJobs().Count;
Assert.AreEqual(count, loadList.Count);
}
public UnitOfWork(string connection)
{
PersonRepository = new PersonRepository(new DbConnectionFactory(connection));
LanguageRepository = new LanguageRepository(new DbConnectionFactory(connection));
ProfessionalSkillRepository = new ProfessionalSkillRepository(new DbConnectionFactory(connection));
EducationRepository = new EducationRepository(new DbConnectionFactory(connection));
JobRepository = new JobRepository(new DbConnectionFactory(connection));
TypeJobRepository = new TypeJobRepository(new DbConnectionFactory(connection));
WorkExpireanceRepository = new WorkExpireanceRepository(new DbConnectionFactory(connection));
InterviewRepository = new InterviewRepository(new DbConnectionFactory(connection));
LanguagesNameRepository = new TypeLanguageRepository(new DbConnectionFactory(connection));
LanguageLevelRepository = new LanguageLevelRepository(new DbConnectionFactory(connection));
TypeJobsNameRepository = new TypeJobsNameRepository(new DbConnectionFactory(connection));
}
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);
}
}
