public async Task EditStudentRecord_Should()
{
var name = Name.Create("Steve", "Miazga");
var email = Email.Create("*****@*****.**");
var student = new Student(name, email);
var exam = new Exam(5, "70-448", "Microsoft SQL Server 2008, Business Intelligence Development and Maintenance");
var certification = new Certification(4, "MCTS", "Microsoft Certified Technical Specialist in SQL Server 2008, Business Intelligence Development and Maintenance");
var certificationRequirement = new CertificationRequirement(certification, exam, null);
_mockStudentRepository.Setup(x => x.GetStudentById(1)).Returns(student);
_mockCertificationRepository.Setup(x => x.GetExamById(5)).Returns(exam);
_mockCertificationRepository.Setup(x => x.GetCertificationById(4)).Returns(certification);
_mockCertificationRepository.Setup(x => x.GetCertificationRequirementsAll()).Returns(new List <CertificationRequirement>()
{
certificationRequirement
});
var command = new EditStudentRecordCommand(1, "Steve", "Miazga", "*****@*****.**", null, new List <int>()
{
5
});
var handler = new EditStudentRecordCommandHandler(_mockStudentRepository.Object, _mockCertificationRepository.Object);
var result = await handler.Handle(command, CancellationToken.None);
_mockStudentRepository.Verify(x => x.Save(It.IsAny <Student>()), Times.Once);
_mockStudentRepository.Verify(x => x.SaveEntitiesAsync(), Times.Once);
}
public async Task <IActionResult> Edit(string id)
{
Certification certification = await _db.Certifications.FindAsync(id);
_db.Certifications.Where(x => x.Id == certification.Id).Include(x => x.Topic).Load();
if (certification == null)
{
return(NotFound());
}
var topic = _db.Topics.Select(x => x.Name).Where(x => x != certification.Topic.Name).ToList();
var users = _db.UserCertifications
.Where(e => e.CertificationId == certification.Id)
.Select(e => e.UserId)
.ToArray();
EditCertificationViewModel editCertificationViewModel = new EditCertificationViewModel {
Id = id,
Name = certification.Name,
Description = certification.Description,
DatetimeEnd = certification.DatetimeEnd,
Users = users,
TopicList = topic,
Topic = certification.Topic.Name
};
return(View(editCertificationViewModel));
}
public async Task CreateStudentRecord_Should()
{
var name = Name.Create("Steve", "Miazga");
var email = Email.Create("*****@*****.**");
var student = new Student(name, email);
var course = new Course(5, "Microsoft SQL Server Database Development");
var exam = new Exam(6, "70-433", "Microsoft SQL Server 2008, Database Development");
var certification = new Certification(5, "MCTS", "Microsoft Certified Technical Specialist in SQL Server 2008, Database Development");
var certificationRequirement = new CertificationRequirement(certification, exam, course);
_mockCertificationRepository.Setup(x => x.GetCourseById(5)).Returns(course);
_mockCertificationRepository.Setup(x => x.GetExamById(6)).Returns(exam);
_mockCertificationRepository.Setup(x => x.GetCertificationById(5)).Returns(certification);
_mockCertificationRepository.Setup(x => x.GetCertificationRequirementsAll()).Returns(new List <CertificationRequirement>()
{
certificationRequirement
});
var command = new CreateStudentRecordCommand("Steve", "Miazga", "*****@*****.**", new List <int>()
{
5
}, new List <int>()
{
6
});
var handler = new CreateStudentRecordCommandHandler(_mockStudentRepository.Object, _mockCertificationRepository.Object);
var result = await handler.Handle(command, CancellationToken.None);
_mockStudentRepository.Verify(x => x.Save(It.IsAny <Student>()), Times.Once);
_mockStudentRepository.Verify(x => x.SaveEntitiesAsync(), Times.Once);
}
public async Task <IActionResult> Pass(string id)
{
Certification certification = await _db.Certifications.FindAsync(id);
User user = await _userManager.FindByNameAsync(User.Identity.Name);
var questions = _db.Questions.Where(x => x.TopicId == certification.TopicId)
.Select(x => x.QuestionString).ToList();
var answers = new Dictionary <string, string>();
foreach (var item in questions)
{
answers.Add(item, "");
}
PassCertificationViewModel passCertification = new PassCertificationViewModel()
{
IdUser = user.Id,
IdCertification = certification.Id,
Name = certification.Name,
Answers = answers
};
return(View(passCertification));
}
public async Task <IActionResult> Pass(PassCertificationViewModel model)
{
if (model.IdUser != null)
{
Certification certification = await _db.Certifications.FindAsync(model.IdCertification);
Result result = new Result()
{
Id = Guid.NewGuid().ToString(),
CertificationId = model.IdCertification,
UserId = model.IdUser
};
await _db.Results.AddAsync(result);
var questions = _db.Questions.Where(x => x.TopicId == certification.TopicId).ToList();
foreach (var quest in questions)
{
Answer answer = new Answer {
Id = Guid.NewGuid().ToString(),
ResultId = result.Id,
QuestionId = quest.Id,
AnswerString = model.Answers[quest.QuestionString],
IsCorrect = model.Answers[quest.QuestionString].ToLower() == quest.AnswerString.ToLower()
};
await _db.Answers.AddAsync(answer);
}
await _db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Edit(int id, CertificationViewModel model)
{
if (ModelState.IsValid)
{
Certification certification = db.Certifications.Find(id);
if (certification == null)
{
return(HttpNotFound());
}
certification.CertificationType = model.CertificationType;
certification.StartDate = model.StartDate;
certification.EndDate = model.EndDate;
certification.UniversityRank = model.UniversityRank;
certification.Major = model.Major;
certification.GPA = model.GPA;
certification.Extracurricular = model.Extracurricular;
certification.InternationalUniversity = model.InternationalUniversity;
db.Entry(certification).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeId = new SelectList(db.Employees, "Id", "FullName");
ViewBag.CertificationId = new SelectList(db.Certifications, "CertificationId", "CertificationType");
ViewBag.CertificationId = new SelectList(db.Certifications, "CertificationId", "InternationalUniversity");
return(View(model));
}
/// <summary>
/// Details of each Certification.
/// </summary>
/// <param name="id">Employee Id</param>
/// <returns>Certification, Details view</returns>
// GET: Certification/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Certification certification = db.Certifications.Find(id);
if (certification == null)
{
return(HttpNotFound());
}
var model = new CertificationViewModel
{
Id = certification.CertificationId,
CertificationType = certification.CertificationType,
StartDate = certification.StartDate,
EndDate = certification.EndDate,
UniversityRank = certification.UniversityRank,
Major = certification.Major,
GPA = certification.GPA,
Extracurricular = certification.Extracurricular,
InternationalUniversity = certification.InternationalUniversity,
EmployeeName = certification.Employee.FullName,
};
return(View(model));
}
public void GivenUserShouldAbleToDeleteCertificationSucessfully()
{
//Delete Certification
Certification certiobj = new Certification();
certiobj.DeleteCertification();
}
public ActionResult Create(CertificationViewModel model)
{
if (ModelState.IsValid)
{
var certification = new Certification
{
CertificationType = model.CertificationType,
StartDate = model.StartDate,
EndDate = model.EndDate,
UniversityRank = model.UniversityRank,
Major = model.Major,
GPA = model.GPA,
Extracurricular = model.Extracurricular,
InternationalUniversity = model.InternationalUniversity,
EmployeeId = model.EmployeeId,
};
db.Certifications.Add(certification);
db.SaveChanges();
return(RedirectToAction("Index"));
}
var list = db.Employees.ToList().Select(e => new { e.Id, e.FullName });
ViewBag.EmployeeId = new SelectList(list, "Id", "FullName");
ViewBag.CertificationId = new SelectList(db.Certifications, "CertificationId", "CertificationType");
ViewBag.CertificationId = new SelectList(db.Certifications, "CertificationId", "InternationalUniversity");
return(View(model));
}
public void WhenUserClickOnUpdateCertificationButton()
{
//Edit Certification
Certification certiobj = new Certification();
certiobj.UpdateCertification();
}
public void ThenUserShouldAbleToEditCertificationSuccessfully()
{
//Verify Edited Certification
Certification certiobj = new Certification();
certiobj.VerifyEditedCertification();
}
public void GivenUserTryToEditTheCertificationRecord()
{
//Edit Certification
Certification certiobj = new Certification();
certiobj.EditCertification();
}
public void ThenUserShouldAbleToAddNewCertificationSuccessfully()
{
//Verify Added Certification
Certification certiobj = new Certification();
certiobj.VerifyCertification();
}
/// <summary>
/// ajax 上传资质文件，并保存在项目文档集合中
/// </summary>
public virtual ActionResult AsyncUpload(string companyid, string durationyears, string validationdate)
{
var id = Convert.ToInt32(companyid);
var date = DateTime.Parse(validationdate);
try
{
var newcertfile = new Certification
{
CompanyId = id,
CreatedBy = User.Identity.Name,
IsActive = true,
CreatedOn = DateTime.Now
};
HttpPostedFileBase uploadfile = Request.Files[0];
string mimeType = uploadfile.ContentType;
newcertfile.CertificationName = Path.GetFileNameWithoutExtension(uploadfile.FileName);
newcertfile.CertificationFilePath = _fileStore.SaveUploadedFile(uploadfile);
newcertfile.MimeType = mimeType;
newcertfile.ValidationDate = date;
newcertfile.DurationYears = Convert.ToInt32(durationyears);
Repository.Add(newcertfile);
Repository.Save();
return Content(newcertfile.CertificationName);// 必须返回信息，否则前端不能显示上传结果
}
catch
{
return Content("不能上传文件");
}
}
public void ThenIShouldBeAbleToAddACertificateSuccessfully()
{
//steps for certification
Certification certiObj = new Certification();
certiObj.EnterCertification(CommonDriver.Driver);
}
public async Task CertificationDateFilterTest()
{
var objA = new Certification()
{
Id = Guid.NewGuid(),
Name = "Test",
IsEnabled = true
};
using var srv = new TestServer(TestHostBuilder <Startup, UnigrationODataTestStartup>()
.ConfigureTestServices(x =>
{
ExecuteOnContext <CertificationsContext>(x, db =>
{
_ = db.Certifications.Add(objA);
});
})
);
var client = srv.CreateClient();
GenerateAuthHeader(client, GenerateTestToken(new[] {
new Claim(PermissionsFilterAttribute.DefaultPermissionClaimType, Permissions.ReadCertifications)
}));
var resp = await client.GetAsync($"odata/v1/{nameof(Certification)}s?filter=createdOnUtc%20gt%202019-01-02T00%3A00%3A00Z&$count=true");
var objB = await DeserializeResponseAsync <ODataEnvelope <Certification> >(resp);
Assert.AreEqual(1, objB.Value.Count());
//TODO: Research bug in EF In Memory Context Or OData
Assert.AreEqual(1, objB.Value.First().CreatedOnUtc.Year);
}
public ActionResult Certification(Certification certification)
{
certification.CertComplete = true;
if (Session == null)
{
return(RedirectToAction("HmError", "Hm"));
}
else
{
try
{
_certRepository.UpdateCertification(Session["LoginId"].ToString(), _utils.GetTaxyear(),
Session["AtCode"].ToString(), certification);
_certRepository.NotifyPreparerOnSubmit(Session["LoginId"].ToString(), _utils.GetTaxyear(),
certification.PreparerEmail);
}
catch (Exception)
{
throw;
}
}
TempData["YearValid"] = true;
TempData["TaxYear"] = _utils.GetTaxyear();
//return Json("Mainmenu");
return(RedirectToAction("Mainmenu"));
}
public int AddCertification(Certification input)
{
var id = _certificationRepository.InsertOrUpdateAndGetId(input);
_unitOfWorkManager.Current.SaveChanges();
return(id);
}
public void Addcertification()
{
Certification CertificObj = new Certification();
//Navigate to cerification tab
test = extent.StartTest("Cerification tab clicked");
CertificObj.NavigateToCertification();
//Add certification
test = extent.StartTest("Certification has been added");
CertificObj.AddCertification();
//Verify Certification added
test = extent.StartTest("Verify Certification has been added");
CertificObj.VerifyAddCertification();
//Edit Certification
test = extent.StartTest("Edit Certification ");
CertificObj.EditCertification();
//Verify Certification updated
test = extent.StartTest("Verify Certification has been updated");
CertificObj.VerifyEditCertification();
// Certification deleted
test = extent.StartTest(" Certification has been deleted");
CertificObj.DeleteCertification();
//Verify Certification has been deleted
test = extent.StartTest("Verify Certification has been deleted");
CertificObj.VerifyDeleteCertification();
}
public void Addcertificationdetails()
{
//Click on the "Certification" Link
Certification.Click();
Thread.Sleep(1000);
//Click on "Add New" Button
AddNew.Click();
Thread.Sleep(1300);
//Send data to the "Certification or Award" textbox
CertificateorAward.SendKeys("New Zealand Student Award for 2019");
Thread.Sleep(1300);
//Send data to the "Certified from (eg. Adobe)" textbox
Certifiedfrom.SendKeys("NZQA New Zealand");
Thread.Sleep(1300);
//Click on the "Certified year" Drop down and Select the "Year"
IWebElement Certifiedyear = Driver.driver.FindElement(By.XPath("//select[@name='certificationYear']"));
SelectElement Certifiedyear_dd = new SelectElement(Certifiedyear);
Certifiedyear_dd.SelectByValue("2017");
Thread.Sleep(1300);
Addnewcert.Click();
Thread.Sleep(1300);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Description,CompletionDate,Source")] Certification certification)
{
if (id != certification.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(certification);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CertificationExists(certification.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(certification));
}
public CertificationViewModel(Certification certification)
{
CertificationId = certification.CertificationId;
CertificationName = certification.CertificationName;
CertCategoryId = certification.CertCategory.CertCategoryId;
CertCategoryName = certification.CertCategory.CertCategoryName;
}
public static int CertificationCostOld(Certification certification)
{
switch (certification)
{
case Certification.JumboJets:
return(100000);
case Certification.GeneralAircraft:
return(25000);
case Certification.Ships:
return(20000);
case Certification.Boats:
return(5000);
case Certification.OversizeVehicles:
return(5000);
case Certification.None:
return(0);
default:
throw new ArgumentException(message: "invalid enum value");
}
}
public async Task GetEnabledCertificationTest()
{
var objA = new Certification()
{
Id = Guid.NewGuid(),
Name = "Test",
IsEnabled = true,
CreatedOnUtc = DateTime.UtcNow,
};
using var srv = new TestServer(TestHostBuilder <Startup, UnigrationODataTestStartup>()
.ConfigureTestServices(x =>
{
ExecuteOnContext <CertificationsContext>(x, db =>
{
_ = db.Certifications.Add(objA);
});
})
);
var client = srv.CreateClient();
GenerateAuthHeader(client, GenerateTestToken(new[] {
new Claim(PermissionsFilterAttribute.DefaultPermissionClaimType, Permissions.ReadCertifications)
}));
var resp = await client.GetStringAsync($"odata/v1/{nameof(Certification)}s?$count=true");
TestContext.WriteLine($"Server Reponse: {resp}");
Assert.IsFalse(resp.ToLower().Contains("updatedby"), $"Validation of {nameof(NrsrxODataSerializer)} failed.");
var envelope = JsonConvert.DeserializeObject <ODataEnvelope <Certification> >(resp);
Assert.AreEqual(objA.CreatedOnUtc, envelope.Value.First().CreatedOnUtc.ToUniversalTime());
}
// GET: Certifications/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Certification certification = await db.Certifications.FindAsync(id);
if (certification == null)
{
return(HttpNotFound());
}
ViewBag.Skilled = new List <SelectListItem>
{
new SelectListItem {
Text = "Advanced", Value = "Advanced"
},
new SelectListItem {
Text = "Beginner", Value = "Beginner"
},
new SelectListItem {
Text = "Intermediate", Value = "Intermediate"
},
new SelectListItem {
Text = "Novice", Value = "Novice"
},
new SelectListItem {
Text = "Expert", Value = "Expert"
}
};
//ViewBag.StaffId = new SelectList(db.Staffs, "StaffId", "FirstName", certification.StaffId);
return(View(certification));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,Description,CertificationType,DateAchieved,Skilled,StaffId,CreatedBy,CreatedOn,ModeifiedBy,ModifiedOn")] Certification certification)
{
if (ModelState.IsValid)
{
var user = User.Identity.Name;
certification.ModeifiedBy = user;
certification.ModifiedOn = DateTime.Today;
certification.StaffId = LegalGuideUtility.StaffId; //(string)ViewBag.StaffId;
db.Entry(certification).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Create", "Dependants"));
}
//ViewBag.StaffId = new SelectList(db.Staffs, "StaffId", "FirstName", certification.StaffId);
ViewBag.Skilled = new List <SelectListItem>
{
new SelectListItem {
Text = "Advanced", Value = "Advanced"
},
new SelectListItem {
Text = "Beginner", Value = "Beginner"
},
new SelectListItem {
Text = "Intermediate", Value = "Intermediate"
},
new SelectListItem {
Text = "Novice", Value = "Novice"
},
new SelectListItem {
Text = "Expert", Value = "Expert"
}
};
return(View(certification));
}
public async Task <IActionResult> Edit(int id, [Bind("CertificationId,CertificationName,Summary,ProfileId")] Certification certification)
{
if (id != certification.CertificationId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(certification);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CertificationExists(certification.CertificationId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index", "Certifications", new { id = certification.ProfileId }));
}
ViewData["ProfileId"] = new SelectList(_context.Profiles, "ProfileId", "ProfileId", certification.ProfileId);
return(View(certification));
}
/// <summary>
/// </summary>
/// <param name="Certinfo"></param>
/// <returns></returns>
/// <exception cref="ArgumentNullException">Certinfo</exception>
public string SaveCertificateInfo(ICertificateViewModel Certinfo)
{
if (Certinfo == null)
{
throw new ArgumentNullException(nameof(Certinfo));
}
var empty = string.Empty;
var insertToDb = new Certification
{
Certificate_Name = Certinfo.CertificationName,
Description = Certinfo.Description,
Year = Certinfo.Year,
UserId = Certinfo.UserId
};
try
{
using (
var result = (HRMSEntities)this.dbContextFactory.GetDbContext(ObjectContextType.HRMS))
{
result.Certifications.Add(insertToDb);
result.SaveChanges();
}
}
catch (Exception e)
{
empty = string.Format("save certificate info", e.Message, e.InnerException != null ? e.InnerException.Message : "");
}
return(empty);
}
public async Task CertificationSelectTest()
{
var objA = new Certification()
{
Id = Guid.NewGuid(),
Name = "Test",
IsEnabled = true
};
using var srv = new TestServer(TestHostBuilder <Startup, UnigrationODataTestStartup>()
.ConfigureTestServices(x =>
{
ExecuteOnContext <CertificationsContext>(x, db =>
{
_ = db.Certifications.Add(objA);
});
})
);
var client = srv.CreateClient();
GenerateAuthHeader(client, GenerateTestToken(new[] { new Claim(PermissionsFilterAttribute.DefaultPermissionClaimType, Permissions.ReadCertifications) }));
var resp = await client.GetAsync($"odata/v1/{nameof(Certification)}s?$select=id&$count=true");
var objB = await DeserializeResponseAsync <ODataEnvelope <Certification> >(resp);
Assert.AreEqual(1, objB.Value.Count());
Assert.IsNull(objB.Value.First().Name);
}
private void Encroll_Button_Click(object sender, EventArgs e)
{
var caConfig = this.CaConfigBindingSource[0] as CaConfig;
var keyLength = 2048;
var certification = new Certification();
var subjectBody = this.SubjectBodyBindingSource[0] as SubjectBody;
try
{
var create = certification.CreateRequest(subjectBody,
OID.ServerAuthentication.Oid,
keyLength);
this.richTextBox1.Text = create;
var send = certification.SendRequest(create, caConfig.Server, caConfig.TemplateName);
this.richTextBox2.Text = send;
certification.InstallAndDownload(send, caConfig.Password, caConfig.FriendlyName);
MessageBox.Show("Done!!");
}
catch (Exception ex)
{
MessageBox.Show($"{ex},{ex.HResult}");
}
}
private bool ValidateCertification(Certification validating)
{
//if (String.IsNullOrWhiteSpace(validating.Title))
//Validator.AddError("Title", "You must enter a title");
return(Validator.IsValid);
}
public ActionResult Create(CertificationModel certificationModel)
{
user = userServices.FindUser(this.User.Identity.Name);
if (ModelState.IsValid) {
Certification certification = new Certification();
certification.User = user;
certification.Title = certificationModel.Title;
certification.Notes = certificationModel.Notes;
certification.DiveAgency = diveAgencyServices.GetDiveAgency(certificationModel.DiveAgencyId);
certification.Created = DateTime.Now;
certification.LastModified = DateTime.Now;
certificationServices.Save(certification);
TempData[ControllerEnums.GlobalViewDataProperty.PageMessage.ToString()] = "The certification was successfully created.";
return RedirectToAction("Index");
}
certificationModel.DiveAgencyListItems = BuildList(null);
return View(certificationModel);
}
private void TransferFormValuesTo(Certification certificationToUpdate, CertificationModel certificationFromForm)
{
certificationToUpdate.Title = certificationFromForm.Title;
certificationToUpdate.Notes = certificationFromForm.Notes;
certificationToUpdate.LastModified = System.DateTime.Now;
}
/// <summary>
/// Initializes a new instance of the <see cref="StaffCertification"/> class.
/// </summary>
/// <param name="certification">
/// The certification.
/// </param>
/// <param name="effectiveDateRange">
/// The effective date range.
/// </param>
public StaffCertification( Certification certification, DateRange effectiveDateRange )
{
Check.IsNotNull ( certification, () => Certification );
_certification = certification;
_effectiveDateRange = effectiveDateRange;
}
