public HttpResponseMessage DeleteEducation(EducationModel model)
{
IUnitOfWork uWork = new UnitOfWork();
IEducationRepository education = new EducationRepository(uWork);
IEducationService educationService = new EducationService(education);
try
{
if (this.ModelState.IsValid)
{
var result = educationService.DeleteEducation(model);
if (result != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
else
{
string message = "Not deleted successfully";
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, message));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
}
}
public ActionResult Index(string resumeGUID)
{
try
{
if (resumeGUID == null || string.IsNullOrWhiteSpace(resumeGUID))
{
resumeGUID = "6257B7B5-C4D0-4D00-ACB4-350A95861B7F";
}
var viewModel = new EducationViewModel();
Repository _repositoryMain = new Repository(_connectionString);
EducationRepository _repository = new EducationRepository(_connectionString);
Applicant applicant = _repositoryMain.GetApplicant(resumeGUID);
List <EducationItem> educationList = _repository.GetEducationList();
viewModel.Applicant = applicant;
viewModel.Educations = educationList;
return(View(viewModel));
}
catch
{
return(View("Error"));
}
}
public HttpResponseMessage GetEducationModels(EducationModel model)
{
IUnitOfWork uWork = new UnitOfWork();
IEducationRepository education = new EducationRepository(uWork);
IEducationService educationService = new EducationService(education);
try
{
if (this.ModelState.IsValid)
{
var educationList = educationService.GetAllEducationList(model);
if (educationList != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, educationList));
}
else
{
string message = "Error in getting Data";
return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, message));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.InnerException.Message));
}
}
public void CreateReportWichEmptyDBTest()
{
// Arrange
var mockILoggerReportController = new Mock <ILogger <ReportController> >();
var mockILoggerEducationRepository = new Mock <ILogger <EducationRepository> >();
var mockILoggerModuleContext = new Mock <ILogger <WEBAPIContext> >();
DbContextOptionsBuilder <WEBAPIContext> optionsBuilder = new DbContextOptionsBuilder <WEBAPIContext>();
optionsBuilder.UseInMemoryDatabase("CreateReportCreateReportWichEmptyDBTestDb");
WEBAPIContext context = new WEBAPIContext(optionsBuilder.Options, mockILoggerModuleContext.Object);
var educationRepository = new EducationRepository(context, mockILoggerEducationRepository.Object);
var mockIReportSaver = new Mock <IReportSaver>();
List <LineOfReport> linesOfReportExpect = new List <LineOfReport>();
List <LineOfReport> linesOfReportAcnual = new List <LineOfReport>();
mockIReportSaver.Setup(d => d.Type).Returns("xml");
ReportController controller = new ReportController(educationRepository, mockILoggerReportController.Object, new List <IReportSaver> {
mockIReportSaver.Object
});
// Act
educationRepository.EnsureDeleted();
controller.CreateReport("Ivan Ivanov", "student", "xml");
// Assert
mockIReportSaver.Verify(rs => rs.SendReport(It.Is <ICollection <LineOfReport> >(lr => lr.Count == 0)));
}
// 焦點專欄 - 列表
public ActionResult EducationList(int?eduTypeID, int?page)
{
if (!eduTypeID.HasValue)
{
return(View());
}
//======語系取得========
string langCd = GetLang();
//======================
EducationListFilter filter = new EducationListFilter()
{
CurrentPage = page ?? 1,
LangCode = langCd
};
eduTypeID = eduTypeID ?? 1;
EducationRepository repo = new EducationRepository();
EducationResult mdoel = repo.GetList((int)eduTypeID, filter);
GetLang();
return(View(mdoel));
}
public void SendAllWarningsTest()
{
// Arrange
var mockILoggerFillDatabaseController = new Mock <ILogger <WarningSenderController> >();
var mockILoggerEducationRepository = new Mock <ILogger <EducationRepository> >();
var mockILoggerModuleContext = new Mock <ILogger <WEBAPIContext> >();
var mockILoggerSenderController = new Mock <ILogger <WarningSenderController> >();
var mockILoggerGetDataForWarning = new Mock <ILogger <GetDataForWarning> >();
var mockILoggerFD = new Mock <ILogger <FillDatabaseController> >();
var mockILoggerISendWarning = new Mock <ILogger <ISendWarning> >();
var mockISendWarning = new Mock <ISendWarning>();
Mapper mapper = new Mapper(new MapperConfiguration(cfg => cfg.CreateMap <Student, StudentBL>()));
DbContextOptionsBuilder <WEBAPIContext> optionsBuilder = new DbContextOptionsBuilder <WEBAPIContext>();
optionsBuilder.UseInMemoryDatabase("CreateReportSendAllWarningsTestDb");
WEBAPIContext context = new WEBAPIContext(optionsBuilder.Options, mockILoggerModuleContext.Object);
var educationRepository = new EducationRepository(context, mockILoggerEducationRepository.Object);
GetDataForWarning getDataForWarning = new GetDataForWarning(educationRepository, mockILoggerGetDataForWarning.Object, mapper);
WarningSenderController warningSenderController = new WarningSenderController(educationRepository, mockILoggerSenderController.Object, getDataForWarning, mockISendWarning.Object);
FillDatabaseController controllerFD = new FillDatabaseController(educationRepository, mockILoggerFD.Object);
// Act
controllerFD.FillDatabase();
warningSenderController.SendAllWarnings();
// Assert
mockISendWarning.Verify(sw => sw.SendWarningToStudents(It.Is <ICollection <StudentBL> >(s => s.Count == 3)));
}
public ActionResult DeleteEducation(Guid id)
{
var eduRepo = new EducationRepository();
eduRepo.DeleteEducation(id);
return(RedirectToAction("/", new { mode = "EditEducation" }));
}
public UnitOfWork(ApplicationDbContext db)
{
_db = db;
Education = new EducationRepository(_db);
Experience = new ExperienceRepository(_db);
User = new UserRepository(_db);
}
public JsonResult Education(int?draw, int?start, int?length, List <Dictionary <string, string> > order, List <Dictionary <string, string> > columns)
{
var search = Request["search[value]"];
var dir = order[0]["dir"].ToLower();
var column = columns[int.Parse(order[0]["column"])]["data"];
var dataTableData = new EducationRepository().GetPage(search, draw, start, length, dir, column);
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult EducationDetail(int?id)
{
EducationViewModel model = new EducationViewModel();
if (id.HasValue)
{
model = new EducationRepository().GetByID((int)id);
}
return(PartialView("_Education", model));
}
public ActionResult EducationCategory()
{
//======語系取得========
string langCd = GetLang();
//======================
EducationRepository repo = new EducationRepository();
var mdoel = repo.GetEducationCate(langCd);
return(View(mdoel));
}
public void EducationRepository_Remove_Exception2()
{
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Delete(guidToDelete)).Throws(new ArgumentNullException());
var repos = new EducationRepository(mockXml.Object);
repos.Remove(guidToDelete);
Assert.IsTrue(true);
}
public void EducationRepository_Remove_Works()
{
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Delete(guidToDelete));
var repos = new EducationRepository(mockXml.Object);
repos.Remove(guidToDelete); // If no exception thrown, it passes
Assert.IsTrue(true);
}
public async Task GetEducations()
{
// Arrange
var repo = new EducationRepository();
// Act
var result = await repo.GetEducations();
// Assert
Assert.Equal(2, result.Count);
}
public UnitOfWork(string connectionString)
{
this.connectionString = connectionString;
Persons = new PersonRepository(connectionString);
Educations = new EducationRepository(connectionString);
Insurances = new InsuranceRepository(connectionString);
Passports = new PassportRepository(connectionString);
PersonsPositions = new PersonPositionRepository(connectionString);
Positions = new PositionRepository(connectionString);
UserRole = new UserRoleRepository(connectionString);
}
public void EducationRepository_Update_Exception1()
{
Guid g = Guid.NewGuid();
IEducationEntity newEE = null; // bad!
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Update(g, newEE)).Throws(new ArgumentNullException());
var repos = new EducationRepository(mockXml.Object);
repos.Update(g, newEE);
}
public HomeController(ContactRepository contactRepository, PrivateInformationRepository privateInformationRepository, AchievementRepository achievementRepository, AdditionalInformationRepository additionalInformationRepository, EducationRepository educationRepository, EmploymentHistoryRepository employmentHistoryRepository, ProjectsRepository projectsRepository, TechnologyRepository technologyRepository)
{
_contactRepository = contactRepository;
_privateInformationRepository = privateInformationRepository;
_achievementRepository = achievementRepository;
_additionalInformationRepository = additionalInformationRepository;
_educationRepository = educationRepository;
_employmentHistoryRepository = employmentHistoryRepository;
_projectsRepository = projectsRepository;
_technologyRepository = technologyRepository;
}
public void EducationRepository_Add_Exception3()
{
EducationEntity ee = null; // bad!
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Insert(ee)).Throws <ArgumentNullException>();
var repos = new EducationRepository(mockXml.Object);
repos.Add(ee);
Assert.IsTrue(true);
}
public void InsertEducation(List <Education> educations)
{
EducationRepository <Education> edurepo = new EducationRepository <Education>();
foreach (var edu in educations)
{
if (!string.IsNullOrEmpty(edu.Institution))
{
edurepo.Insert(edu);
}
}
}
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 JsonResult SaveEducation(EducationViewModel model)
{
ResponseData result = new Models.ResponseData();
if (model.EduID != 0)
{
result = new EducationRepository().UpdateByEntity(model);
}
else
{
result = new EducationRepository().AddByEntity(model);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void EducationRepository_Update_Works()
{
Guid g = Guid.NewGuid();
IEducationEntity newEE = new EducationEntity {
Credential = "new", Institution = "new"
};
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Update(g, newEE));
var repos = new EducationRepository(mockXml.Object);
repos.Update(g, newEE);
Assert.IsTrue(true);
}
public void EducationRepository_Add_Exception1()
{
EducationEntity ee = new EducationEntity();
ee.Credential = null; // bad!
ee.Institution = "test institution";
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Insert(ee)).Throws <ArgumentException>();
var repos = new EducationRepository(mockXml.Object);
repos.Add(ee);
Assert.IsTrue(true);
}
public ActionResult AddEducation(EducationViewModel viewModel)
{
if (ModelState.IsValid)
{
var model = new Education();
viewModel.FillModel(model);
var eduRepo = new EducationRepository();
eduRepo.AddEducation(model);
}
var frontPageViewModel = GetFrontPageViewModel(PageViewMode.EditEducation);
frontPageViewModel.EducationBlock.NewEducation = viewModel;
return(View("Index", frontPageViewModel));
}
public void EducationRepository_Add_Works()
{
EducationEntity ee = new EducationEntity();
ee.Credential = "test credential";
ee.Institution = "test institution";
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Insert(ee));
var repos = new EducationRepository(mockXml.Object);
var id = repos.Add(ee);
Assert.IsInstanceOfType(id, typeof(Guid));
Assert.IsNotNull(id);
}
public void EducationRepository_Get_Works()
{
Guid g = Guid.NewGuid();
IEducationEntity ee = new EducationEntity {
Credential = "c", Institution = "i"
};
var mockXml = new Mock <IEducationXMLService>();
mockXml.Setup(T => T.Get(g)).Returns(ee);
var repos = new EducationRepository(mockXml.Object);
var edItem = repos.Get(g);
Assert.IsNotNull(edItem);
Assert.AreEqual("c", edItem.Credential);
Assert.AreEqual("i", edItem.Institution);
}
public void FillDatabaseTest()
{
// Arrange
var mockILoggerFillDatabaseController = new Mock <ILogger <FillDatabaseController> >();
var mockILoggerEducationRepository = new Mock <ILogger <EducationRepository> >();
var mockILoggerModuleContext = new Mock <ILogger <WEBAPIContext> >();
DbContextOptionsBuilder <WEBAPIContext> optionsBuilder = new DbContextOptionsBuilder <WEBAPIContext>();
optionsBuilder.UseInMemoryDatabase("FillDatabaseTestDb");
WEBAPIContext context = new WEBAPIContext(optionsBuilder.Options, mockILoggerModuleContext.Object);
var educationRepository = new EducationRepository(context, mockILoggerEducationRepository.Object);
FillDatabaseController controller = new FillDatabaseController(educationRepository, mockILoggerFillDatabaseController.Object);
List <Student> studentsExp = new List <Student>()
{
new Student()
{
FullName = "Ivan Ivanov", EMail = "*****@*****.**", Phone = "123456"
},
new Student()
{
FullName = "Nikolai Ivanov", EMail = "*****@*****.**", Phone = "123456"
},
new Student()
{
FullName = "Serdei Ivanov", EMail = "*****@*****.**", Phone = "123456"
},
new Student()
{
FullName = "Petr Ivanov", EMail = "*****@*****.**", Phone = "123456"
}
};
// Act
controller.FillDatabase();
var studentsActual = context.Students.ToList();
// Assert
Assert.Equal(studentsExp.Count, studentsActual.Count);
foreach (var studentActual in studentsActual)
{
var studentExpect = studentsExp.Find(s => s.FullName == studentActual.FullName);
Assert.NotNull(studentExpect);
Assert.Equal(studentExpect.EMail, studentActual.EMail);
Assert.Equal(studentExpect.Phone, studentActual.Phone);
}
}
private FrontPageViewModel GetFrontPageViewModel(PageViewMode?mode)
{
var repo = new PersonalInfoRepository();
var personalInfo = repo.GetPersonalInfo();
var eduRepo = new EducationRepository();
var educations = eduRepo.GetEducations();
var expRepo = new WorkExperienceRepository();
var experience = expRepo.GetWorkExperience();
var skillsRepo = new SkillsRepository();
var skills = skillsRepo.GetSkills();
ViewBag.Mode = mode ?? PageViewMode.View;
var frontPageViewModel = new FrontPageViewModel()
{
EducationBlock = new EducationListViewModel()
{
NewEducation = new EducationViewModel()
},
WorkExperienceBlock = new WorkExperienceListViewModel()
{
NewWorkExpirience = new WorkExperienceViewModel()
},
SkillCategoryBlock = new SkillsCategoryListViewModel()
{
NewSkillCategory = new SkillsCategoryViewModel(),
}
};
frontPageViewModel.PersonalInfo = new PersonalInfoViewModel(personalInfo);
frontPageViewModel.EducationBlock.EducationList = educations.Select(x => new EducationViewModel(x)).ToList();
frontPageViewModel.EducationBlock.NewEducation = new EducationViewModel();
frontPageViewModel.WorkExperienceBlock.WorkExperienceList = experience.Select(x => new WorkExperienceViewModel(x)).ToList();
frontPageViewModel.WorkExperienceBlock.NewWorkExpirience = new WorkExperienceViewModel();
frontPageViewModel.SkillCategoryBlock.SkillsCategoryList = skills.Select(x => new SkillsCategoryViewModel(x)).ToList();
frontPageViewModel.SkillCategoryBlock.NewSkillCategory = new SkillsCategoryViewModel();
return(frontPageViewModel);
}
// 焦點專欄 - 內容
public ActionResult EducationContent(int?eduTypeID, int?ID, int?pagingID)
{
if (!eduTypeID.HasValue || !ID.HasValue)
{
return(RedirectToAction("EducationList"));
}
//======語系取得========
string langCd = GetLang();
//======================
EducationRepository repo = new EducationRepository();
EducationContent model = repo.GetContentByID((int)eduTypeID, (int)ID, langCd);
if (pagingID != null)
{
model.PagingID = (int)pagingID;
var pagFirst = model.Data.PagingList.Where(s => s.ID == (int)pagingID).FirstOrDefault();
if (pagFirst == null)
{
return(RedirectToAction("FocusList", new { eduTypeID }));
}
pagFirst.Current = "current";
}
else
{
if (model.Data.PagingList.Count > 0)
{
model.Data.PagingList.First().Current = "current";
}
}
//=瀏覽記錄====================
DataTable d_log;
string err_msg = "";
DB.Log_Insert(eduTypeID.ToString(), "Edu");
d_log = DB.Log_List(ref err_msg, eduTypeID.ToString(), "Edu");
ViewData["log_count"] = d_log.Rows.Count.ToString();
//============================
return(View(model));
}
public ActionResult Detail(Guid id, string resumeGUID)
{
try
{
if (resumeGUID == null || string.IsNullOrWhiteSpace(resumeGUID))
{
resumeGUID = "6257B7B5-C4D0-4D00-ACB4-350A95861B7F";
}
var viewModel = new EducationDetailsViewModel();
Repository _repositoryMain = new Repository(_connectionString);
EducationRepository _repository = new EducationRepository(_connectionString);
Applicant applicant = _repositoryMain.GetApplicant(resumeGUID);
EducationItem education = _repository.GetEducationDetails(resumeGUID, id);
List <MinorItem> minorList = _repository.GetMinorList(id);
if (education.IsGraduated == true)
{
viewModel.Graduated = "Graduated";
}
else
{
viewModel.Graduated = "Did not Graduate";
}
viewModel.Title = "Richard M. Cano Resume";
viewModel.Applicant = applicant;
viewModel.Education = education;
viewModel.MinorList = minorList;
viewModel.Applicant = applicant;
return(View(viewModel));
}
catch (InvalidCastException e)
{
throw (e);
//return View("Error");
}
}
