private void button1_Click(object sender, EventArgs e)
{
if (CheckFields())
{
using (HrMatchContext db = new HrMatchContext())
{
Byte.TryParse(age.Text, out byte Age);
Decimal.TryParse(salary.Text, out decimal Salary);
if (CheckHasCV())
{
categoryID = db.Categories.FirstOrDefault(c => c.Name.Equals(category.Text)).ID;
cityID = db.Cities.FirstOrDefault(c => c.Name.Equals(city.Text)).ID;
CV activeCV = db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID));
activeCV.CategoryID = categoryID;
activeCV.CityID = cityID;
activeCV.Name = name.Text;
activeCV.Surname = surname.Text;
activeCV.Gender = gender.Text;
activeCV.Age = Age;
activeCV.Education = education.Text;
activeCV.Experience = experience.Text;
activeCV.Salary = Salary;
activeCV.PhoneNumber = phoneNumber.Text;
MessageBox.Show("CV is Successfully Updated!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
int categoryID = db.Categories.FirstOrDefault(c => c.Name.Equals(category.Text)).ID;
int cityID = db.Cities.FirstOrDefault(c => c.Name.Equals(city.Text)).ID;
CV cv = new CV(activeWorker.ID, categoryID, cityID, name.Text, surname.Text, gender.Text, Age, education.Text, experience.Text, Salary, phoneNumber.Text);
db.CVs.Add(cv);
button1.Text = "UPDATE";
title.Text = "UPDATE CV";
MessageBox.Show("Your CV is Successfully Added!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
db.SaveChanges();
}
}
}
private void apply_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Do You Want to Apply this Announcement?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult.Equals(DialogResult.Yes))
{
using (HrMatchContext db = new HrMatchContext())
{
WorkersAnnouncements workersAnnouncements = new WorkersAnnouncements(activeWorker.ID, activeAnnouncement.ID);
db.workersAnnouncements.Add(workersAnnouncements);
db.SaveChanges();
}
apply.Visible = false;
alreadyApplied.Visible = true;
}
}
private void sendRequest_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Send request?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
using (HrMatchContext db = new HrMatchContext())
{
bool foundVac = db.Vacancies.ToList().Exists(x => x.ID == vacancyID.Value);
if (vacancyID.Value == 0 || !foundVac)
{
MessageBox.Show("Wrong Vacancy ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
var foundCv = db.CVs.FirstOrDefault(x => x.UserId == user.ID);
if (foundCv == null)
{
MessageBox.Show("You don't gave any active CV - please add CV at first", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
try
{
var requestVac = db.Vacancies.FirstOrDefault(x => x.ID == vacancyID.Value);
requestVac.CVs.Add(foundCv);
db.SaveChanges();
MessageBox.Show("Your request send", "Sucsess", MessageBoxButtons.OK, MessageBoxIcon.Information);
vacancyID.Value = 0;
}
catch
{
MessageBox.Show("You can't send request 2 times for one vacancy", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
}
}
private void addVacancy_Click(object sender, EventArgs e)
{
if (vacancyTitle.Text == "" || vacancyCompany.Text == "" || vacancyCategory.Text == "" || vacancyCity.Text == "" || vacancyEducation.Text == "" || vacancyExperience.Text == "" || vacancyAbout.Text == "")
{
ErrorMessage("Empty fields");
}
else if (!IsValidNumber(vacancyPhone.Text))
{
ErrorMessage("Wrong Phone number type");
}
else
{
using (HrMatchContext db = new HrMatchContext())
{
Vacancy vacancy = new Vacancy()
{
JobTitle = vacancyTitle.Text,
Company = vacancyCompany.Text,
Category = vacancyCategory.Text,
City = vacancyCity.Text,
Salary = int.Parse(vacancySalary.Value.ToString()),
Age = int.Parse(vacancyAge.Value.ToString()),
Education = vacancyEducation.Text,
Experience = vacancyExperience.Text,
Phone = vacancyPhone.Text,
About = vacancyAbout.Text,
UserId = user.ID
};
this.Dispose();
db.Vacancies.Add(vacancy);
db.SaveChanges();
MessageBox.Show("Vacancy Added", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
CheckHasCV();
if (CheckFields())
{
using (HrMatchContext db = new HrMatchContext())
{
if (db.Categories.Any(c => c.Name == category.Text))
{
if (db.Cities.Any(c => c.Name == city.Text))
{
if (gender.Text == "Man" || gender.Text == "Woman")
{
if (Byte.TryParse(age.Text, out byte Age))
{
if (education.Text == "Secondary education" || education.Text == "Incomplete Higher education" || education.Text == "High education")
{
if (experience.Text == "Less than 1 year" || experience.Text == "1 - 3 years" || experience.Text == "3 - 5 years" || experience.Text == "Greater than 5 years")
{
if (Decimal.TryParse(salary.Text, out decimal Salary))
{
if (isValidPhoneNumber(phoneNumber.Text))
{
if (hasCV)
{
categoryID = db.Categories.FirstOrDefault(c => c.Name.Equals(category.Text)).ID;
cityID = db.Cities.FirstOrDefault(c => c.Name.Equals(city.Text)).ID;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).CategoryID = categoryID;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).CityID = cityID;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).Name = name.Text;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).Surname = surname.Text;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).Gender = gender.Text;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).Age = Age;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).Education = education.Text;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).Experience = experience.Text;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).Salary = Salary;
db.CVs.FirstOrDefault(c => c.UserID.Equals(UserCV.UserID)).PhoneNumber = phoneNumber.Text;
MessageBox.Show("CV is Successfully Updated!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
int categoryID = db.Categories.FirstOrDefault(c => c.Name.Equals(category.Text)).ID;
int cityID = db.Cities.FirstOrDefault(c => c.Name.Equals(city.Text)).ID;
CV cv = new CV(activeWorker.ID, categoryID, cityID, name.Text, surname.Text, gender.Text, Age, education.Text, experience.Text, Salary, phoneNumber.Text);
db.CVs.Add(cv);
button1.Text = "UPDATE";
title.Text = "UPDATE CV";
MessageBox.Show("Your CV is Successfully Added!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
db.SaveChanges();
}
else
{
MessageBox.Show("'Phone Number' field has not written correctly! Example: +994-55-555-55-55", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Salary field is not valid format! It must be a number!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("'Experience' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("'Education' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("Age field is not valid format! It must be a number!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("'Gender' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("'City' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("'Category' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MessageBox.Show("All fields must be filled!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void SP_Signup_Click(object sender, EventArgs e)
{
var passChecker = @"^.*(?=.{4,15})(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[!*@#$%^&+=]).*$";
if (RandomCode.Text == SubmitCode.Text) //Randome Code Check -> Find "Generat code"
{
if (SP_Password.Text == SP_CPassword.Text) //Password Check
{
if (Role.Text != "") // Role Check
{
if (SP_Username.Text.Length > 4 || SP_Username.Text.Length < 20) //Username Check
{
if (Regex.IsMatch(SP_Password.Text, passChecker))
{
if (IsValidEmail(SP_Email.Text)) // Email format Check -> Find "Email format Check"
{
using (HrMatchContext db = new HrMatchContext())
{
bool emailCheck = db.Users.ToList().Exists(u => u.Email.ToLower().Equals(SP_Email.Text.ToLower()));
bool usernameCheck = db.Users.ToList().Exists(u => u.Username.ToLower().Equals(SP_Username.Text.ToLower()));
if (emailCheck)
{
ErrorMessage("This email address already exists.");
}
else if (usernameCheck)
{
ErrorMessage("This username already exists.");
}
else
{
User user = new User()
{
Username = SP_Username.Text,
Email = SP_Email.Text,
Role = Role.SelectedItem.ToString(),
Password = SP_Password.Text,
};
this.Dispose();
db.Users.Add(user);
db.SaveChanges();
MessageBox.Show("Thank you for registering. You may now Login.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
new LoginPage().ShowDialog();
}
}
}
else
{
ErrorMessage("Wrong Email format");
}
}
else
{
ErrorMessage("Your password must be 4-15 characters long, be of mixed case and also contain a digit and symbol.");
}
}
else
{
ErrorMessage("Username must contain 4-20 characters");
}
}
else
{
ErrorMessage("Choose Role");
}
}
else
{
ErrorMessage("Password does not match");
}
}
else
{
ErrorMessage("Verification code does not match");
}
}
