public async Task <List <ApplicantViewModel> > ReadFromExcel(string TechName)
{
List <ApplicantViewModel> list = new List <ApplicantViewModel>();
try
{
for (int i = 2; i <= this.xlRange.Rows.Count; i++)
{
ApplicantViewModel applicant = (ApplicantViewModel)Activator.CreateInstance(typeof(ApplicantViewModel));
applicant.FirstName = xlRange.Cells[i, 1].Value2.ToString();
applicant.LastName = xlRange.Cells[i, 2].Value2.ToString();
applicant.Email = xlRange.Cells[i, 3].Value2.ToString();
applicant.Phone1 = xlRange.Cells[i, 4].Value2.ToString();
string sDate = xlRange.Cells[i, 9].Value2.ToString();
double date = double.Parse(sDate);
var dateTime = DateTime.FromOADate(date).ToShortDateString();
applicant.Date = Helper.GetDate(dateTime);
applicant.Description = xlRange.Cells[i, 8].Value2.ToString();
TechnologyController techctrl = new TechnologyController();
applicant.Technology = await techctrl.GetByNameAsync(TechName);
list.Add(applicant);
}
}
finally
{
this.xlWorkbook.Close();
}
return(list);
}
public TechnologyControllerTests()
{
_mockRepository = new Mock <ITechnologyRepository>();
_mockEntityRepository = new Mock <IEntityRepository>();
var mockConfiguration = new Mock <IConfiguration>();
var mockConfigurationSection = new Mock <IConfigurationSection>();
mockConfigurationSection.SetupGet(m => m.Value).Returns("5c73c15a8b89521e44e98806");
mockConfiguration.Setup(x => x.GetSection("ReferenceEntityId")).Returns(mockConfigurationSection.Object);
_controller = new TechnologyController(mockConfiguration.Object);
}
public void Get_ReturnAOkObjectResult_GetOneTechnologyByID()
{
//Arrange
var _skillRepository = new SkillRepository(DbContextMocker.GetTechnologyContext());
var _tecnologyController = new TechnologyController(_skillRepository);
// Act
var response = _tecnologyController.Get(1);
// Assert
Assert.IsType <OkObjectResult>(response);
}
public PersonsListWindow(MainWindow ParentWindow)
{
InitializeComponent();
this.UserControlsParent = ParentWindow;
// Excel icons Will be Always Hidden on Creating instance of this Window
ParentWindow.ExportGrid.Visibility = Visibility.Hidden;
ParentWindow.ImportGrid.Visibility = Visibility.Hidden;
TechnologyController tech = new TechnologyController();
Helpers.HelperMethodes.GetTechnologiesList(this.LessonsComboBox);
}
public void Get_ReturnOkObjectResult_GetTechnologyDetails_PerformanceTest()
{
//Arrange
var _skillRepository = new SkillRepository(DbContextMocker.GetTechnologyContext());
var _tecnologyController = new TechnologyController(_skillRepository);
// Act
var response = _tecnologyController.Get();
// Assert
var okObjectResult = Assert.IsType <OkObjectResult>(response);
var data = Assert.IsAssignableFrom <List <Skill> >(okObjectResult.Value);
Assert.True(data.Count >= 0);
}
public void Post_ReturnAOkResult_UpdateTechnology()
{
//Arrange
var _skillRepository = new SkillRepository(DbContextMocker.GetTechnologyContext());
var _tecnologyController = new TechnologyController(_skillRepository);
var testSkill = GetTestSkill();
testSkill.SkillId = 4;
testSkill.Prerequisites = "None";
// Act
var response = _tecnologyController.Post(4, testSkill);
// Assert
Assert.IsType <OkResult>(response);
}
public void Post_ReturnACreatedAtActionResult_AddTechnology()
{
//Arrange
var _skillRepository = new SkillRepository(DbContextMocker.GetTechnologyContext());
var _tecnologyController = new TechnologyController(_skillRepository);
var testSkill = GetTestSkill();
// Act
var response = _tecnologyController.Post(testSkill);
// Assert
var createdResult = Assert.IsType <CreatedAtActionResult>(response);
var insertedData = Assert.IsAssignableFrom <Skill>(createdResult.Value);
Assert.Equal(testSkill.Name, insertedData.Name);
}
private async void AddTechnologiesToComboBox(ComboBox comboBox)
{
TechnologyController technologyController = new TechnologyController();
comboBox.ItemsSource = await technologyController.GetAllAsync();
}
public TechControllerTest()
{
_repo = new Mock <ITechnologyRepository>();
_controller = new TechnologyController(_repo.Object);
}
public void TestInitialize()
{
_technologyService = Substitute.For <ITechnologyService>();
_controller = new TechnologyController(_technologyService);
}
private void AddEntityWindow_Loaded(object sender, RoutedEventArgs e)
{
AddStartedatDatePicker.SelectedDate = DateTime.Today;
TechnologyController ctrl = new TechnologyController();
}
public static async void GetTechnologiesList(ComboBox comboBox)
{
TechnologyController techctrl = new TechnologyController();
comboBox.ItemsSource = await techctrl.GetAllAsync();
}
