public ActionResult Create(PersonViewModel personVM)
{
if (ModelState.IsValid)
{
bool cvSaved = true;
string path = null;
if (personVM.CVFile != null)
{
path = Utils.Utils.CreatePath(Server, personVM.CVFile, Utils.AppConfig.CVFolderRelative);
cvSaved = dao.SaveFileOnServer(path, personVM.CVFile);
}
Person person = new Person()
{
CanContact = personVM.CanContact,
City = personVM.City,
CVPath = path,
Email = personVM.Email,
Name = personVM.Name,
PersonalDataProcessing = personVM.PersonalDataProcessing,
PhoneNumber = personVM.PhoneNumber,
Street = personVM.Street,
Surname = personVM.Surname,
Zip = personVM.Zip,
Candidates = new List <Candidate>(),
Notes = new List <PersonNote>(),
Tags = new List <SkillTag>(),
};
List <string> tagList = personVM.Tags.Split(new char[] { ';', ' ', ',' }).ToList <string>();
foreach (var tag in tagList)
{
if ((!string.IsNullOrEmpty(tag)) && (person.Tags.Where(x => x.Tag == tag).Count() <= 0))
{
SkillTag skillTag = new SkillTag()
{
People = new List <Person>(),
Tag = tag
};
skillTag.People.Add(person);
person.Tags.Add(skillTag);
}
}
ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
GIDOLog gl = new GIDOLog()
{
Author = user.FirstName + " " + user.Surname,
AuthorId = user.Id,
Date = DateTime.Now,
Changes = "Dodanie danych personalnych do bazy: " + Json(person)
};
dao.SaveGIDOLog(gl);
dao.SavePerson(person);
return(RedirectToAction("Index", "People"));
}
return(View("CreatePerson", personVM));
}
public async Task <ActionResult> AddTag(int id, string newTag)
{
Person person = dao.GetPersonById(id);
List <string> tagList = newTag.Split(new char[] { ';', ' ', ',' }).ToList <string>();
foreach (var tag in tagList)
{
if ((!string.IsNullOrEmpty(tag)) && (person.Tags.Where(x => x.Tag == tag).Count() <= 0))
{
SkillTag skillTag = new SkillTag()
{
People = new List <Person>(),
Tag = tag
};
skillTag.People.Add(person);
person.Tags.Add(skillTag);
}
}
dao.UpdatatePerson(person);
TagListViewModel model = new TagListViewModel()
{
Tags = person.Tags,
PersonId = person.Id
};
return(PartialView("_TagList", model));
}
/// <summary>
/// 添加标签的方法
/// </summary>
/// <param name="tags"></param>
/// <returns></returns>
public int AddTags(List <SkillTag> tags)
{
var result = 0;
foreach (var tag in tags)
{
SkillTag match = this.context.SkillTag.Where(r => r.TagName == tag.TagName).FirstOrDefault();
if (match == null)
{
tag.TagID = Guid.NewGuid().ToString();
this.context.SkillTag.Add(tag);
this.context.SkillTags.Add(new SkillTags()
{
PositionID = tag.PositionID, TagID = tag.TagID.ToString(), ID = Guid.NewGuid().ToString()
});
}
else
{
SkillTags tagMatch = this.context.SkillTags.Where(r => r.TagID == match.TagID && r.PositionID == tag.PositionID).FirstOrDefault();
if (tagMatch == null)
{
this.context.SkillTags.Add(new SkillTags()
{
PositionID = tag.PositionID, TagID = match.TagID, ID = Guid.NewGuid().ToString()
});
}
}
}
result = this.context.SaveChanges();
return(result);
}
public void TestMethod2()
{
SurveyContext context = new SurveyContext();
SkillTag skillTag = new SkillTag()
{
TagID = Guid.NewGuid().ToString(), TagName = "标签测试", Direction = "NET", CourseName = "ASP.NET"
};
SkillTag skillTag2 = new SkillTag()
{
TagID = Guid.NewGuid().ToString(), TagName = "标签测试", Direction = "NET", CourseName = "ASP.NET"
};
List <SkillTag> tags = new List <SkillTag>();
tags.Add(skillTag);
tags.Add(skillTag2);
context.SkillTag.AddRange(tags);
context.SkillTags.Add(new SkillTags()
{
ID = Guid.NewGuid().ToString(), TagID = skillTag.TagID, PositionID = Guid.NewGuid().ToString()
});
context.SkillTags.Add(new SkillTags()
{
ID = Guid.NewGuid().ToString(), TagID = skillTag2.TagID, PositionID = Guid.NewGuid().ToString()
});
var result = context.SaveChanges();
string json = JsonConvert.SerializeObject(result);
}
public async Task <IActionResult> PostArticle(NewArticleVM vm)
{
if (ModelState.IsValid)
{
string currentUserId = await OnGetSesstion();
var article = _mapper.Map <Article>(vm);
article.CreateTime = DateTime.Now;
article.Status = "active";
article.OriginalId = 0;
article.UserId = currentUserId;
_context.Article.Add(article);
_context.SaveChanges();
string[] tagArray = vm.Tags.Split(',');
foreach (string tag in tagArray)
{
var tagFromDB = _context.SkillTag.Where(x => x.SkillName == tag.ToLower()).SingleOrDefault();
if (tagFromDB == null)
{
SkillTag sktag = new SkillTag
{
ApprovedStatus = false,
SkillName = tag.ToLower(),
TimeApproved = DateTime.Now,
UserId = currentUserId
};
_context.SkillTag.Add(sktag);
_context.SaveChanges();
ArticleTag articleTag = new ArticleTag
{
TagId = sktag.SkillTagId,
ArticleId = article.Id
};
_context.ArticleTag.Add(articleTag);
_context.SaveChanges();
}
else
{
ArticleTag articleTag = new ArticleTag
{
TagId = tagFromDB.SkillTagId,
ArticleId = article.Id
};
_context.ArticleTag.Add(articleTag);
_context.SaveChanges();
}
}//Foreach for tags
ArticleCategory articleCategory = new ArticleCategory
{
ArticleId = article.Id,
CategoryId = vm.CategoryId
};
_context.ArticleCategory.Add(articleCategory);
article.OriginalId = article.Id;
_context.SaveChanges();
return(RedirectToAction($"ArticleSingle", new { id = article.Id, title = article.Title }));
}
return(View(vm));
}
public async Task <List <JobOffer> > GetBySkill(SkillTag skillTag)
{
var skill = await Context.Set <SkillTag>().FindAsync(skillTag.Id);
if (skill == null)
{
return(null);
}
return(skill.JobOffers);
}
public Skill()
{
m_eTag = SkillTag.MissingTag;
m_eParentTag = SkillTag.MissingTag;
m_fParentWeight = 0;
m_eRootSkillTag = SkillTag.MissingTag;
m_bIsActive = false;
m_lSupportSkills = new List<SupportSkill>();
m_sIconPath = "";
m_sName = "";
m_sDescription = "";
}
public async Task <ActionResult> DeleteTag(int personId, int tagId)
{
Person person = dao.GetPersonById(personId);
SkillTag tag = dao.GetTagById(tagId);
person.Tags.Remove(tag);
dao.RemoveTagById(tagId);
dao.UpdatatePerson(person);
return(new EmptyResult());
}
public async Task <IActionResult> PostQuestion(NewQuestionVM vm, string tags)
{
if (ModelState.IsValid)
{
var user = await OnGetSesstion();
UserQuestion userQuestion = new UserQuestion();
userQuestion.Title = vm.Title;
userQuestion.PostTime = DateTime.Now;
userQuestion.Description = HttpUtility.HtmlEncode(vm.Description);
userQuestion.UserId = user;
_context.UserQuestion.Add(userQuestion);
_context.SaveChanges();
string[] tagArray = tags.Split(',');
foreach (string tag in tagArray)
{
var tagFromDB = _context.SkillTag.Where(x => x.SkillName == tag.ToLower()).SingleOrDefault();
if (tagFromDB == null)
{
SkillTag sktag = new SkillTag
{
ApprovedStatus = false,
SkillName = tag.ToLower(),
TimeApproved = DateTime.Now,
UserId = user
};
_context.SkillTag.Add(sktag);
_context.SaveChanges();
QuestionSkill qs = new QuestionSkill
{
SkillTagId = sktag.SkillTagId,
UserQuestionId = userQuestion.UserQuestionId
};
_context.QuestionSkill.Add(qs);
_context.SaveChanges();
}
else
{
QuestionSkill qs = new QuestionSkill
{
SkillTagId = tagFromDB.SkillTagId,
UserQuestionId = userQuestion.UserQuestionId
};
_context.QuestionSkill.Add(qs);
_context.SaveChanges();
}
}
return(RedirectToAction($"QuestionDetail", new { id = _context.UserQuestion.OrderByDescending(c => c.UserQuestionId).FirstOrDefault().UserQuestionId }));
}
return(View("New", vm));
}
public void NotMatchCandidateWithoutApplicableSkill()
{
var skill = new SkillTag("TEST SKILL");
var candidate = new Candidate(1, "C1", new List <SkillTag>());
var candidates = new List <Candidate>()
{
candidate
};
var result = Logic.SkillMatcher.GetCandidatesMatchingSkill(skill, candidates);
Assert.False(result.Contains(candidate));
}
public void TestUpdateTag()
{
SkillTagDal dal = new SkillTagDal();
SkillTag tag = new SkillTag();
tag.TagID = "2c9a86d9-23a0-4bb0-9859-360613fe0b89";
tag.TagName = "Egret";
tag.TagType = "技术";
tag.CourseName = "C#";
tag.Direction = "NET";
int reuslt = dal.UpdateTag(tag);
var result = dal.context.SkillTag.ToList();
string json = JsonConvert.SerializeObject(reuslt);
}
public async Task CreateSkillAsync_SkillIsNotPreviouslySeeded_CreatesNewSkill()
{
var skill = new SkillTag {
Name = "Super Hero"
};
using (var unitOfWork = Initializer.Provider.Create())
{
repository.Create(skill);
await unitOfWork.Commit();
}
Assert.IsFalse(skill.Id.Equals(0));
}
public int UpdateTag(SkillTag tag)
{
SkillTag match = context.SkillTag.Where(r => r.TagID == tag.TagID).FirstOrDefault();
if (match != null)
{
match.TagName = tag.TagName;
match.TagType = tag.TagType;
match.Direction = tag.Direction;
match.CourseName = tag.CourseName;
match.Creatime = DateTime.Now;
}
context.Entry(match).State = EntityState.Modified;
return(context.SaveChanges());
}
public List <SkillTag> GetSkillTagsByPostId(int id)
{
using (var conn = Connection)
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT skillTag.id, skillTag.Title, skillTag.PostId, skillTag.SkillId, q.Id as QueId, q.Title as QueTItle, q.SkillId as QueSkill, p.Id as PId, p.Title as PTitle, p.SkillId as PSkillId
FROM SkillTag JOIN Post p ON p.SkillId = SkillTag.SkillId JOIN Question q ON q.SkillId = SkillTag.SkillId
WHERE SkillTag.PostId = @Id";
DbUtils.AddParameter(cmd, "@Id", id);
SkillTag skillTag = null;
var SkillTags = new List <SkillTag>();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
skillTag = new SkillTag()
{
Id = reader.GetInt32(reader.GetOrdinal("Id")),
Title = reader.GetString(reader.GetOrdinal("Title")),
PostId = reader.GetInt32(reader.GetOrdinal("PostId")),
SkillId = reader.GetInt32(reader.GetOrdinal("SkillId")),
Post = new Post()
{
Id = reader.GetInt32(reader.GetOrdinal("PId")),
Title = reader.GetString(reader.GetOrdinal("PTitle")),
SkillId = reader.GetInt32(reader.GetOrdinal("PSkillId"))
},
Question = new Question()
{
Id = reader.GetInt32(reader.GetOrdinal("QueId")),
Title = reader.GetString(reader.GetOrdinal("QueTitle")),
SkillId = reader.GetInt32(reader.GetOrdinal("QueSkill"))
}
};
SkillTags.Add(skillTag);
}
reader.Close();
return(SkillTags);
}
}
}
public void NotMatchNonApplicableSkillsWithCandidate()
{
var uniqueCandidateSkill = new SkillTag("C1 SKILL");
var candidate = new Candidate(1, "C1", new List <SkillTag> {
uniqueCandidateSkill
});
var nonApplicableSkills = new List <SkillTag>()
{
new SkillTag("TEST SKILL 1"),
new SkillTag("TEST SKILL 2"),
};
var result = Logic.SkillMatcher.GetSkillsMatchingCandidateSkills(candidate, nonApplicableSkills);
Assert.IsEmpty(result);
}
public SkillTag GetSkillByNameOrNew(string name)
{
name = name.CapitalizeFirst();
var tag = _context.SkillTags?.FirstOrDefault(x => x.Name == name);
if (tag == null)
{
tag = new SkillTag()
{
Name = name
};
_context.SkillTags.Add(tag);
_context.SaveChanges();
}
return(tag);
}
public void Add(SkillTag skillTag)
{
using (var conn = Connection)
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"INSERT INTO SkillTag (Title, PostId, SkillId)
OUTPUT INSERTED.ID
VALUES (@Title, @PostId, @SkillId)";
DbUtils.AddParameter(cmd, "@Title", skillTag.Title);
DbUtils.AddParameter(cmd, "@PostId", skillTag.PostId);
DbUtils.AddParameter(cmd, "@SkillId", skillTag.SkillId);
skillTag.Id = (int)cmd.ExecuteScalar();
}
}
}
private void AddSkillTag(Skill skill, List <string> tags)
{
if (skill.Id > 0)
{
_skillTagRepository.DeleteMulti(x => x.SkillId == skill.Id);
}
else
{
skill.SkillTags = new List <SkillTag>();
}
if (tags.Count > 0)
{
foreach (var newTag in tags)
{
var tag = new SkillTag();
tag.Tag = newTag;
skill.SkillTags.Add(tag);
}
}
}
public async Task UpdateUserAsync_UserIsPreviouslySeeded_UpdatesUser()
{
SkillTag updatedSkill;
SkillTag newSkill;
using (var uow = unitOfWorkProvider.Create())
{
newSkill = new SkillTag
{
Id = Initializer.JavaSkill.Id,
Name = "Java Super Hero"
};
repository.Update(newSkill);
await uow.Commit();
updatedSkill = await repository.GetAsync(Initializer.JavaSkill.Id);
}
Assert.IsTrue(newSkill.Name.Equals(updatedSkill.Name));
}
// Przykladowa funkcja ktora wyswietla wszystkie dostepne dane o umiejce.
public static void printSkillInfo(SkillTag a_eSkillTag)
{
// Jesli pierwszy element z enum SkillTag jest mniejszy od podanego (on ma index 0),
// lub jesli ostatni element z enum'a SkillTag jest wiekszy od podanego
// (TotalSkillCount to zawsze ostatni element, wiec definiuje ile lacznie jest skilli w drzewku)
// to znaczy, ze podales jako argument zlego skilla i na bank nie znajdziesz go w drzewku
if (SkillTag.MissingTag < a_eSkillTag && SkillTag.TotalSkillCount > a_eSkillTag)
{
Console.WriteLine("Name : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).Name);
Console.WriteLine("Description : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).Description);
Console.WriteLine("Tag : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).Tag);
Console.WriteLine("Parent tag : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).ParentTag);
Console.WriteLine("Root parent tag: {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).RootSkillTag);
Console.WriteLine("Parent weight : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).ParentWeight);
Console.WriteLine("Is active : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).IsSkillActive);
Console.WriteLine("Icon path : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).IconPath);
Console.WriteLine("Support amount : {0}", m_CSkillsMngr.getSkillInfo(a_eSkillTag).Support.Count);
// Jedna z dwoch opcji dobrania sie do supportow, obie tak samo dobre
foreach (Skill.SupportSkill element in m_CSkillsMngr.getSkillInfo(a_eSkillTag).Support)
{
Console.WriteLine("Support : {0} [weight: {1}]", element.Tag, element.Weight);
}
//foreach or this
//for (int i = 0; i < m_CSkillsMngr.getSkillInfo(a_eSkillTag).Support.Count; i++ )
//{
// Console.WriteLine("Support : {0} [weight: {1}]", m_CSkillsMngr.getSkillInfo(a_eSkillTag).Support[i].Tag, m_CSkillsMngr.getSkillInfo(a_eSkillTag).Support[i].Weight);
//}
Console.WriteLine();
}
else
{
Console.WriteLine("Wrong skill tag passed");
}
return;
}
public SupportSkill()
{
m_eTag = SkillTag.MissingTag;
m_fWeight = 0;
}
public static ICollection <Candidate> GetCandidatesMatchingSkill(SkillTag skill, IEnumerable <Candidate> candidates)
{
var matchingCandidates = candidates.Where(candidate => candidate.SkillTags.Contains(skill)).ToList();
return(matchingCandidates);
}
public async Task <IList <JobOfferDto> > GetBySkills(SkillTagDto skillTagDto)
{
SkillTag skillTag = Mapper.Map <SkillTag>(skillTagDto);
return(Mapper.Map <IList <JobOfferDto> >(await(jobOfferRepository.GetBySkill(skillTag))));
}
//public Character(UInt32 a_sCharacterDBIndex){}
public SkillParam getSkillParam(SkillTag a_oSkillTag)
{
return m_aSkills[(int)a_oSkillTag];
}
public void AddOwnSkillInProfile(UserProfile profile, SkillTag tag)
{
profile.OwnSkills.Add(tag);
_context.SaveChanges();
}
public void AddWantSkillInProfile(UserProfile profile, SkillTag tag)
{
profile.WantedSkills.Add(tag);
_context.Entry(profile).State = EntityState.Modified;
_context.SaveChanges();
}
public DeluxeJsonResult UpdateTag(SkillTag tag)
{
var result = SkillTagDal.Instance.UpdateTag(tag);
return(new DeluxeJsonResult(result));
}
public bool HasTag(SkillTag tag)
{
return(Tags.Get((int)tag));
}
public void SetTag(SkillTag tag, bool value)
{
Tags.Set((int)tag, value);
}
private static DbContext InitializeDatabase()
{
var context = new JobPortalDbContext(Effort.DbConnectionFactory.CreatePersistent(TestDbConnectionString));
context.Employers.RemoveRange(context.Employers);
context.Users.RemoveRange(context.Users);
context.Applicants.RemoveRange(context.Applicants);
context.JobOffers.RemoveRange(context.JobOffers);
context.JobApplications.RemoveRange(context.JobApplications);
context.Questions.RemoveRange(context.Questions);
context.QuestionAnswers.RemoveRange(context.QuestionAnswers);
context.SkillTags.RemoveRange(context.SkillTags);
context.SaveChanges();
#region employers
RedHatEmployer = new Employer
{
Name = "RedHat",
Address = "Brno, CzechRepublic",
Email = "*****@*****.**",
PhoneNumber = "+420 123 456 789",
PasswordHash = "password",
PasswordSalt = "password"
};
GoogleEmployer = new Employer
{
Name = "Google",
Address = "MountainView, CA",
Email = "*****@*****.**",
PhoneNumber = "+421 123 456 789",
PasswordHash = "password",
PasswordSalt = "password"
};
MicrosoftEmployer = new Employer
{
Name = "Microsoft",
Address = "Praha, CZ",
Email = "*****@*****.**",
PhoneNumber = "(425) 882-8080",
PasswordHash = "password",
PasswordSalt = "password"
};
context.Employers.Add(RedHatEmployer);
context.Employers.Add(GoogleEmployer);
context.Employers.Add(MicrosoftEmployer);
#endregion
#region skills
CSharpSkill = new SkillTag {
Name = "C#"
};
JavaSkill = new SkillTag {
Name = "Java"
};
PhpSkill = new SkillTag {
Name = "Php"
};
AngularSkill = new SkillTag {
Name = "Angular"
};
AndroidSkill = new SkillTag {
Name = "Android"
};
context.SkillTags.Add(CSharpSkill);
context.SkillTags.Add(JavaSkill);
context.SkillTags.Add(PhpSkill);
context.SkillTags.Add(AngularSkill);
context.SkillTags.Add(AndroidSkill);
#endregion
#region users
PiskulaUser = new User
{
FirstName = "Piskula",
LastName = "Zeleny",
Email = "*****@*****.**",
PhoneNumber = "+420 123 456 789",
Education = "High School of Live",
Skills = new List <SkillTag>
{
JavaSkill,
PhpSkill,
AngularSkill
},
PasswordHash = "password",
PasswordSalt = "password"
};
MadkiUser = new User
{
FirstName = "Madki",
LastName = "Programmer",
Email = "*****@*****.**",
PhoneNumber = "+421 999 666 789",
Education = "Programming High",
Skills = new List <SkillTag>
{
JavaSkill,
CSharpSkill,
AndroidSkill
},
PasswordHash = "password",
PasswordSalt = "password"
};
AnonymousUser = new Applicant()
{
FirstName = "Anonymous",
LastName = "Inkognito",
Email = "*****@*****.**",
PhoneNumber = "+420 5565893",
Education = "Secret"
};
context.Applicants.Add(PiskulaUser);
context.Applicants.Add(MadkiUser);
context.Applicants.Add(AnonymousUser);
#endregion
#region questions
JavaExperienceQuestion = new Question {
Text = "What is your exeperience with Java programming?"
};
JavaEeExperienceQuestion = new Question {
Text = "What is your exeperience with Java EE programming?"
};
CSharpExperienceQuestion = new Question {
Text = "What is your exeperience with .Net programming?"
};
WebEprienceQuestion = new Question {
Text = "What is your exeperience with web application programming?"
};
AndroidExperienceQuestion = new Question {
Text = "What is your exeperience with Android programming?"
};
SoftSkillQuestion = new Question {
Text = "Tell us about your soft skills"
};
HobbyQuesiton = new Question {
Text = "What is your hobby?"
};
context.Questions.Add(JavaExperienceQuestion);
context.Questions.Add(JavaEeExperienceQuestion);
context.Questions.Add(CSharpExperienceQuestion);
context.Questions.Add(WebEprienceQuestion);
context.Questions.Add(AndroidExperienceQuestion);
context.Questions.Add(SoftSkillQuestion);
context.Questions.Add(HobbyQuesiton);
#endregion
#region job offers
GoogleAndroidOffer = new JobOffer
{
Name = "Associate Android Developer",
Employer = GoogleEmployer,
Location = "Paris, FR",
Description = "Develop apps for Android - it will be fun!",
Skills = new List <SkillTag>
{
JavaSkill,
AndroidSkill
},
Questions = new List <Question>
{
SoftSkillQuestion,
JavaExperienceQuestion,
AndroidExperienceQuestion
}
};
MicrosoftCSharpOffer = new JobOffer
{
Name = "C# dev",
Employer = MicrosoftEmployer,
Location = "Seattle, WS",
Description = "Lets see sharp!",
Skills = new List <SkillTag>
{
CSharpSkill
},
Questions = new List <Question>
{
CSharpExperienceQuestion
}
};
MicrosoftManagerOffer = new JobOffer
{
Name = "Project manager junior",
Employer = MicrosoftEmployer,
Location = "Seattle 2, WS",
Description = "Manage amazing projects",
Skills = new List <SkillTag>
{
CSharpSkill
},
Questions = new List <Question>
{
SoftSkillQuestion,
HobbyQuesiton
}
};
RedHatQualityOffer = new JobOffer
{
Name = "Quality engineer",
Employer = RedHatEmployer,
Location = "Brno, CZ",
Description = "Quality matters",
Skills = new List <SkillTag>
{
JavaSkill
},
Questions = new List <Question>
{
SoftSkillQuestion,
JavaExperienceQuestion,
JavaEeExperienceQuestion
}
};
context.JobOffers.Add(GoogleAndroidOffer);
context.JobOffers.Add(MicrosoftCSharpOffer);
context.JobOffers.Add(MicrosoftManagerOffer);
context.JobOffers.Add(RedHatQualityOffer);
#endregion
#region applications
ApplicationRedHatQuality = new JobApplication
{
Applicant = MadkiUser,
JobOffer = RedHatQualityOffer,
JobApplicationStatus = JobApplicationStatus.Open
};
AnswersoftSkillsRedHat = new QuestionAnswer
{
Text = "Great",
Application = ApplicationRedHatQuality,
Question = SoftSkillQuestion
};
ÀnswersJavaRedHat = new QuestionAnswer
{
Text = "Very Good",
Application = ApplicationRedHatQuality,
Question = JavaExperienceQuestion
};
AnswerJavaEeRedHat = new QuestionAnswer
{
Text = "Basic",
Application = ApplicationRedHatQuality,
Question = JavaEeExperienceQuestion
};
ApplicationRedHatQuality.QuestionAnswers = new List <QuestionAnswer>
{
AnswersoftSkillsRedHat,
ÀnswersJavaRedHat,
AnswerJavaEeRedHat
};
context.QuestionAnswers.Add(AnswersoftSkillsRedHat);
context.QuestionAnswers.Add(AnswerJavaEeRedHat);
context.QuestionAnswers.Add(ÀnswersJavaRedHat);
context.JobApplications.Add(ApplicationRedHatQuality);
#endregion
context.SaveChanges();
return(context);
}
internal void AddSkill()
{
//Click on ShareSkill Tab
SkillTab.Click();
//Populate the Excel Sheet
GlobalDefinitions.ExcelLib.PopulateInCollection(Base.ExcelPath, "ShareSkill");
Thread.Sleep(1000);
//Add in ShareSkill Title
SkillTitle.SendKeys(GlobalDefinitions.ExcelLib.ReadData(2, "Title"));
Assert.That(SkillTitle != null);
//Add in ShareSkill Discription
SkillDescription.SendKeys(GlobalDefinitions.ExcelLib.ReadData(2, "Description"));
Assert.That(SkillDescription != null);
//Click on ShareSkill Category
SkillCategory.Click();
//Select Category
SkillCategory.SendKeys(Keys.ArrowDown + Keys.ArrowDown + Keys.Enter);
//Click on ShareSkill SubCategory
SkillSubCategory.Click();
//Select SubCategory
SkillSubCategory.SendKeys(Keys.ArrowDown + Keys.ArrowDown + Keys.Enter);
for (int i = 1; i < 3; i++)
{
//Click on ShareSkill Tag
SkillTag.Click();
if (i == 1)
{
//Add in Tag1
Thread.Sleep(1000);
SkillTag.SendKeys(GlobalDefinitions.ExcelLib.ReadData(2, "Tag1") + Keys.Enter);
}
else
{
//Add in Tag2
Thread.Sleep(1000);
SkillTag.SendKeys(GlobalDefinitions.ExcelLib.ReadData(2, "Tag2") + Keys.Enter);
}
}
//Click on redio button [One-off service]
ServiceType.Click();
//Click on redio button [On-site]
LocationType.Click();
//Add Start Date
StartDate.SendKeys("08/11/2019");
//Add End Date
EndDate.SendKeys("09/11/2019");
//Tick on weekdays checkbox, Add Start time and End time
for (int i = 1; i <= 7; i++)
{
Thread.Sleep(1000);
GlobalDefinitions.driver.FindElement(By.XPath("(//INPUT[@tabindex='0'])[" + (i + 4) + "]")).Click();
Thread.Sleep(1000);
GlobalDefinitions.driver.FindElement(By.XPath("(//INPUT[@name='StartTime'])[" + i + "]")).SendKeys("10:00AM");
Thread.Sleep(1000);
GlobalDefinitions.driver.FindElement(By.XPath("(//INPUT[@name='EndTime'])[" + i + "]")).SendKeys("08:00PM");
}
//Click on Skill Trade [Credit]
SkillTrade.Click();
//Add value in Credit
Credit.SendKeys("6");
//Upload File using AutoIT
UploadBtn.Click();
AutoItX3 autoIt = new AutoItX3();
autoIt.WinActivate("Open");
Thread.Sleep(1000);
autoIt.Send(@"C:\Users\nilay\Documents\Richa 2019\Richa Vyas-Test Analyst.pdf");
Thread.Sleep(1000);
autoIt.Send("{ENTER}");
//Click on Active [Active]
Active.Click();
//Click on Save Button
SaveBtn.Click();
}
public SupportSkill(SkillTag a_eTag, float a_fWeight)
{
m_eTag = a_eTag;
m_fWeight = a_fWeight;
}
protected override void Seed(JobPortalDbContext context)
{
#region employers
var redHat = new Employer
{
Name = "RedHat",
Address = "Brno, CzechRepublic",
Email = "*****@*****.**",
PhoneNumber = "+420 123 456 789",
PasswordHash = "rh_pwd",
PasswordSalt = "****"
};
var google = new Employer
{
Name = "Google",
Address = "MountainView, CA",
Email = "*****@*****.**",
PhoneNumber = "+421 123 456 789",
PasswordHash = "google_pwd",
PasswordSalt = "****"
};
var microsoft = new Employer
{
Name = "Microsoft",
Address = "Praha, CZ",
Email = "*****@*****.**",
PhoneNumber = "(425) 882-8080",
PasswordHash = "ms_pwd",
PasswordSalt = "****"
};
context.Employers.Add(redHat);
context.Employers.Add(google);
context.Employers.Add(microsoft);
#endregion
#region skills
var cSharp = new SkillTag {
Name = "C#"
};
var java = new SkillTag {
Name = "Java"
};
var php = new SkillTag {
Name = "Php"
};
var angular = new SkillTag {
Name = "Angular"
};
var android = new SkillTag {
Name = "Android"
};
context.SkillTags.Add(cSharp);
context.SkillTags.Add(java);
context.SkillTags.Add(php);
context.SkillTags.Add(angular);
context.SkillTags.Add(android);
#endregion
#region users
var piskula = new User
{
FirstName = "Piskula",
LastName = "Zeleny",
Email = "*****@*****.**",
PhoneNumber = "+420 123 456 789",
Education = "High School of Live",
Skills = new List <SkillTag>
{
java,
php,
angular
},
PasswordHash = "password",
PasswordSalt = "aaaa",
};
var madki = new User
{
FirstName = "Madki",
LastName = "Programmer",
Email = "*****@*****.**",
PhoneNumber = "+421 999 666 789",
Education = "Programming High",
Skills = new List <SkillTag>
{
java,
cSharp,
android
},
PasswordHash = "password",
PasswordSalt = "aaaa",
};
var anonymous = new Applicant()
{
FirstName = "Anonymous",
LastName = "Inkognito",
Email = "*****@*****.**",
PhoneNumber = "+420 5565893",
Education = "Secret"
};
context.Applicants.Add(piskula);
context.Applicants.Add(madki);
context.Applicants.Add(anonymous);
#endregion
#region questions
var javaExperience = new Question {
Text = "What is your exeperience with Java programming?"
};
var javaEeExperience = new Question {
Text = "What is your exeperience with Java EE programming?"
};
var cSharpExperience = new Question {
Text = "What is your exeperience with .Net programming?"
};
var webExperience = new Question {
Text = "What is your exeperience with web application programming?"
};
var androidExperience = new Question {
Text = "What is your exeperience with Android programming?"
};
var softSkills = new Question {
Text = "Tell us about your soft skills"
};
var hobby = new Question {
Text = "What is your hobby?"
};
context.Questions.Add(javaExperience);
context.Questions.Add(javaEeExperience);
context.Questions.Add(cSharpExperience);
context.Questions.Add(webExperience);
context.Questions.Add(androidExperience);
context.Questions.Add(softSkills);
context.Questions.Add(hobby);
#endregion
#region job offers
var googleAndroidOffer = new JobOffer
{
Name = "Associate Android Developer",
Employer = google,
Location = "Paris, FR",
Description = "Develop apps for Android - it will be fun!",
Skills = new List <SkillTag>
{
java,
android
},
Questions = new List <Question>
{
softSkills,
javaExperience,
androidExperience
}
};
var googleBackendOffer = new JobOffer
{
Name = "Java backend senior",
Employer = google,
Location = "Vienna, Austria",
Description = "Be a backend hero!",
Skills = new List <SkillTag>
{
java
},
Questions = new List <Question>
{
javaExperience,
javaEeExperience
}
};
var googleFronetEndOffer = new JobOffer
{
Name = "Javascript front end developer",
Employer = google,
Location = "San Francisco, CA",
Description = "Create amazing UI",
Skills = new List <SkillTag>
{
angular,
php
},
Questions = new List <Question>
{
webExperience,
softSkills,
hobby
}
};
var microsoftCsharpDev = new JobOffer
{
Name = "C# dev",
Employer = microsoft,
Location = "Seattle, WS",
Description = "Lets see sharp!",
Skills = new List <SkillTag>
{
cSharp
},
Questions = new List <Question>
{
cSharpExperience
}
};
var microsoftProjectManager = new JobOffer
{
Name = "Project manager junior",
Employer = microsoft,
Location = "Seattle 2, WS",
Description = "Manage amazing projects",
Skills = new List <SkillTag>
{
cSharp
},
Questions = new List <Question>
{
softSkills,
hobby
}
};
var redHatQalityEngineer = new JobOffer
{
Name = "Quality engineer",
Employer = redHat,
Location = "Brno, CZ",
Description = "Quality matters",
Skills = new List <SkillTag>
{
java
},
Questions = new List <Question>
{
softSkills,
javaExperience,
javaEeExperience
}
};
context.JobOffers.Add(googleAndroidOffer);
context.JobOffers.Add(googleBackendOffer);
context.JobOffers.Add(googleFronetEndOffer);
context.JobOffers.Add(microsoftCsharpDev);
context.JobOffers.Add(microsoftProjectManager);
context.JobOffers.Add(redHatQalityEngineer);
#endregion
#region applications
var applicationRedHatQuality = new JobApplication
{
Applicant = madki,
JobOffer = redHatQalityEngineer,
JobApplicationStatus = JobApplicationStatus.Open
};
var answersoftSkillsRedHat = new QuestionAnswer
{
Text = "Great",
Application = applicationRedHatQuality,
Question = softSkills
};
var answersJavaRedHat = new QuestionAnswer
{
Text = "Very Good",
Application = applicationRedHatQuality,
Question = javaExperience
};
var answerJavaEeRedHat = new QuestionAnswer
{
Text = "Basic",
Application = applicationRedHatQuality,
Question = javaEeExperience
};
applicationRedHatQuality.QuestionAnswers = new List <QuestionAnswer>
{
answersoftSkillsRedHat,
answerJavaEeRedHat,
answersJavaRedHat
};
context.QuestionAnswers.Add(answersoftSkillsRedHat);
context.QuestionAnswers.Add(answerJavaEeRedHat);
context.QuestionAnswers.Add(answersJavaRedHat);
context.JobApplications.Add(applicationRedHatQuality);
#endregion
base.Seed(context);
}
public void DeleteWantTagFromProfile(UserProfile profile, SkillTag tag)
{
profile.WantedSkills.Remove(tag);
_context.Entry(profile).State = EntityState.Modified;
_context.SaveChanges();
}
/* Returns Skill object
*/
public Skill getSkillInfo(SkillTag a_SkillTag)
{
return m_aSkillsInfo[(int)a_SkillTag];
}
public IActionResult Post(SkillTag SkillTag)
{
_skillTagRepository.Add(SkillTag);
return(CreatedAtAction("Details", new { id = SkillTag.Id }, SkillTag));
}
