public void ShouldNotHaveFrameworkAndStandardsSelectorsWhenTraineeship()
{
//Arrange
var viewModel = new Fixture().Build <TrainingDetailsViewModel>()
.With(vm => vm.VacancyType, VacancyType.Traineeship)
.Create();
var details = new TrainingDetails();
//Act
var view = details.RenderAsHtml(viewModel);
//Assert
view.GetElementbyId("training-type-frameworks-panel").Should().BeNull();
view.GetElementbyId("training-type-standards-panel").Should().BeNull();
var frameworkCodeName = view.GetElementbyId("FrameworkCodeName");
frameworkCodeName.Should().NotBeNull();
frameworkCodeName.Attributes["type"].Value.Should().Be("hidden");
var standardId = view.GetElementbyId("StandardId");
standardId.Should().NotBeNull();
standardId.Attributes["type"].Value.Should().Be("hidden");
var apprenticeshipLevel = view.GetElementbyId("ApprenticeshipLevel");
apprenticeshipLevel.Should().NotBeNull();
apprenticeshipLevel.Attributes["type"].Value.Should().Be("hidden");
}
public void ShouldHaveFrameworksAndStandardsSelectorsWhenApprenticeship()
{
//Arrange
var viewModel = new Fixture().Build <TrainingDetailsViewModel>()
.With(vm => vm.VacancyType, VacancyType.Apprenticeship)
.Create();
var details = new TrainingDetails();
//Act
var view = details.RenderAsHtml(viewModel);
//Assert
view.GetElementbyId("training-type-frameworks-panel").Should().NotBeNull();
view.GetElementbyId("training-type-frameworks-panel").Attributes["class"].Value.Should().Contain("toggle-content");
view.GetElementbyId("training-type-standards-panel").Should().NotBeNull();
view.GetElementbyId("training-type-standards-panel").Attributes["class"].Value.Should().Contain("toggle-content");
var frameworkCodeName = view.GetElementbyId("FrameworkCodeName");
frameworkCodeName.Should().NotBeNull();
frameworkCodeName.Name.Should().Be("select");
var standardId = view.GetElementbyId("StandardId");
standardId.Should().NotBeNull();
standardId.Name.Should().Be("select");
view.GetElementbyId("apprenticeship-level-intermediate").Should().NotBeNull();
view.GetElementbyId("apprenticeship-level-advanced").Should().NotBeNull();
view.GetElementbyId("apprenticeship-level-higher").Should().NotBeNull();
view.GetElementbyId("apprenticeship-level-degree").Should().NotBeNull();
}
public ApiResponseWrapper <TrainingResponse> SaveTrainingData(TrainingDetailsRequest request)
{
ApiResponseWrapper <TrainingResponse> response = new ApiResponseWrapper <TrainingResponse>();
Validation validation = ValidateData(request);
if (validation.IsValidationFailed)
{
response.SetFailure(new TrainingResponse(), validation);
}
else
{
TrainingDetails newTrainingDetails = _mapper.Map <TrainingDetailsRequest, TrainingDetails>(request);
int TrainingId = _TrainingAppModule.Save(newTrainingDetails);
if (TrainingId > 0)
{
TrainingResponse responseData = new TrainingResponse()
{
TrainingId = TrainingId,
TrainingDays = DateDifference(request)
};
response.SetSuccess(responseData);
}
else
{
response.SetException(new TrainingResponse());
}
}
return(response);
}
public TrainingDetailsViewModel(MerkatoDbContext context, TrainingDetails B) : this(context)
{
this.Id = B.Id;
this.TrainingId = B.TrainingId;
this.Question = B.Question;
this.AnswerValues = B.AnswerValues;
this.AnswerPoint = B.AnswerPoint;
this.AnswerCorrect = B.AnswerCorrect;
}
public string Put(int id, [FromBody] Object val)
{
try
{
Trainee trainee = new Trainee();
var value = (Newtonsoft.Json.Linq.JObject)val;
if (!BE.Tools.CheckID_IL(uint.Parse((String)value["id"])))
{
return("Invalid Id!");
}
// BL.FactoryBl.GetObject.AddTester(value);
foreach (var prop in trainee.GetType().GetProperties())
{
if ((value[ToLower(prop.Name)]) is JArray)
{
var list = (value[ToLower(prop.Name)]).Select((license) => {
TrainingDetails td = new TrainingDetails();
td.GearType = (Gear)Convert.ChangeType((license["gearType"]), typeof(Gear));
td.License = (LicenseType)Convert.ChangeType(license["license"], typeof(LicenseType));
td.NumberOfLessons = (int)Convert.ChangeType((license["numberOfLessons"]), typeof(int));
return(td);
});
trainee.LicenseTypeLearning = new List <TrainingDetails>();
foreach (var td in list)
{
trainee.LicenseTypeLearning.Add(td);
}
}
else if (prop.Name == "Address")
{
prop.SetValue(trainee, new Address((value[ToLower(prop.Name)].ToString())));
}
else if (prop.Name != "Schedule")
{
try
{
prop.SetValue(trainee, Convert.ChangeType((value[ToLower(prop.Name)]), prop.PropertyType));
}
catch (Exception ex) { }
}
}
trainee.LicenseType = new List <LicenseType>();
// System.Threading.Thread.Sleep(2000);
bl.UpdateTrainee(trainee);
return("OK");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public TrainingDetails GetModel()
{
TrainingDetails b = new TrainingDetails();
b.Id = this.Id;
b.TrainingId = this.TrainingId;
b.Question = this.Question;
b.AnswerValues = this.AnswerValues;
b.AnswerPoint = this.AnswerPoint;
b.AnswerCorrect = this.AnswerCorrect;
return(b);
}
public async Task <ActionResult> Train()
{
string authoringKey = ConfigurationManager.AppSettings["AuthoringKey"].ToString();
string appID = ConfigurationManager.AppSettings["LuisAppID"].ToString();
string appVersion = ConfigurationManager.AppSettings["AppVersion"].ToString();
string appHost = ConfigurationManager.AppSettings["LuisHost"].ToString();
TrainingDetails train = await LuisTrain(appID, appVersion, authoringKey);
string result = train.Status;
return(RedirectToAction("List", "Utterance", new { result = result }));
}
public void ShouldNotHaveTrainingTypeSelectorWhenTraineeship()
{
//Arrange
var viewModel = new Fixture().Build <TrainingDetailsViewModel>()
.With(vm => vm.VacancyType, VacancyType.Traineeship)
.Create();
var details = new TrainingDetails();
//Act
var view = details.RenderAsHtml(viewModel);
//Assert
view.GetElementbyId("training-type-frameworks").Should().BeNull();
view.GetElementbyId("training-type-standards").Should().BeNull();
}
public int Save(TrainingDetails request)
{
try
{
request.IsActive = true;
request.CreatedBy = "System";
request.CreatedOn = DateTime.Now;
_context.Add(request);
int val = _context.SaveChanges();
return(request.Id);
}
catch (Exception ex)
{
return(-1);
}
}
public void ShouldHaveSectorSelectorWhenTraineeship()
{
//Arrange
var viewModel = new Fixture().Build <TrainingDetailsViewModel>()
.With(vm => vm.VacancyType, VacancyType.Traineeship)
.Create();
var details = new TrainingDetails();
//Act
var view = details.RenderAsHtml(viewModel);
//Assert
var sectorCodeName = view.GetElementbyId("SectorCodeName");
sectorCodeName.Should().NotBeNull();
sectorCodeName.Name.Should().Be("select");
}
public void Import(Context context, string path)
{
//@"C:\Users\KSIUDA\Desktop\SQL\Training List.xlsx"
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(path);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
int colCount = xlRange.Columns.Count;
var trainings = new List <Tuple <int, string> >();
var consultants = new List <Tuple <int, string> >();
var blanks = new List <int>();
for (int row = 3; row <= rowCount; row++)
{
string training = "";
string instructor = "";
string duration = "";
string type = "";
for (int column = 2; column < 8; column++)
{
if (column == 2)
{
if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null)
{
string value = xlRange.Cells[row, column].Value2.ToString();
if (value.ToUpper() != value)
{
training = value;
}
else if (value.ToUpper() == value && value.Length < 7)
{
training = value;
}
else
{
blanks.Add(row);
}
}
}
if (column == 3)
{
if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null)
{
string value = xlRange.Cells[row, column].Value2.ToString();
if (value.ToUpper() != value)
{
type = value;
}
}
}
if (column == 6)
{
if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null)
{
string value = xlRange.Cells[row, column].Value2.ToString();
if (value.ToUpper() != value)
{
instructor = value;
}
}
}
if (column == 7)
{
if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null)
{
string value = xlRange.Cells[row, column].Value2.ToString();
duration = value;
}
}
}
if (instructor != "" || training != "")
{
if (instructor == "")
{
instructor = "None";
}
if (duration == "")
{
duration = null;
}
Int32.TryParse(duration, out int dur);
trainings.Add(Tuple.Create(trainings.Count() + 1, training));
var Training = new Trainings
{
Name = training,
Type = type,
Trainer = instructor,
Duration = dur,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
context.Trainings.Add(Training);
context.SaveChanges();
}
}
for (int row = 1; row <= 1; row++)
{
string consultant = "";
for (int column = 10; column <= colCount; column++)
{
string value = xlRange.Cells[row, column].Value2.ToString();
consultant = value;
consultants.Add(Tuple.Create(consultants.Count() + 1, consultant));
var Consultant = new Consultants
{
Name = consultant,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
context.Consultants.Add(Consultant);
context.SaveChanges();
}
}
foreach (var consultant in consultants)
{
int blank = 0;
int id;
for (int row = 3; row <= trainings.Count() + 2 + blanks.Count(); row++)
{
string trainingState = "";
int counter = row - 2;
for (int column = 10 + consultant.Item1 - 1; column < 10 + consultant.Item1; column++)
{
if (xlRange.Cells[row, column] != null && xlRange.Cells[row, column].Value2 != null)
{
string value = xlRange.Cells[row, column].Value2.ToString();
trainingState = value;
if (trainingState == "")
{
blank++;
}
else
{
id = counter - blank;
var query = trainings.AsEnumerable();
var trainigname = from train in query
where train.Item1 == id
select train.Item2;
string name = String.Join("", trainigname);
var TrainingDetails = new TrainingDetails
{
TrainingName = name,
ConsultantName = consultant.Item2,
Status = trainingState,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
context.TrainingDetails.Add(TrainingDetails);
context.SaveChanges();
}
}
else
{
blank++;
}
}
}
}
}
