private void JobseekerApplied_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { var requested = db.CVs.Include("Vacancies").FirstOrDefault(x => x.UserId == user.ID); foreach (var item in requested.Vacancies) { allAppliedvac.Add(new AllAppliedvac() { ID = item.ID, JobTitle = item.JobTitle, Company = item.Company, Category = item.Category, City = item.City, Salary = item.Salary, Age = item.Age, Education = item.Education, Experience = item.Experience, Phone = item.Phone, About = item.About }); } } AppliedVacancy.DataSource = allAppliedvac; AppliedVacancy.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; }
private void AllVacancyPage_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { foreach (var item in db.Vacancies) { allVac.Add(new Allvac() { ID = item.ID, JobTitle = item.JobTitle, Company = item.Company, Category = item.Category, City = item.City, Salary = item.Salary, Age = item.Age, Education = item.Education, Experience = item.Experience, Phone = item.Phone, About = item.About }); } } ActiveVacancy.DataSource = allVac; ActiveVacancy.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; }
private void myVacancies_CellContentClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = this.myVacancies.Rows[e.RowIndex]; int ID = int.Parse(row.Cells["ID"].Value.ToString()); DialogResult result = MessageBox.Show($"Delete vacancy with id - {ID}", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { using (HrMatchContext db = new HrMatchContext()) { var delete = db.Database.ExecuteSqlCommand($"DELETE FROM Vacancies WHERE ID = {ID}"); try { if (delete > 0) { MessageBox.Show("Vacancy Deleted"); this.Dispose(); } else { MessageBox.Show("Vacancy not Deleted"); } } catch { MessageBox.Show("Can't find any Vacancy"); } } } }
private void suitableAnnouncements_Click(object sender, EventArgs e) { CV activeCV; IQueryable <Announcement> query; using (HrMatchContext db = new HrMatchContext()) { activeCV = db.CVs.FirstOrDefault(c => c.UserID == activeWorker.ID); if (activeCV != null) { query = db.Announcements .Where(a => (a.CategoryID == activeCV.CategoryID) && (a.Education == activeCV.Education || a.Experience == activeCV.Experience || a.Age == activeCV.Age || a.City == activeCV.City || a.Salary > activeCV.Salary)); if (query.Any(a => a.CategoryID == activeCV.CategoryID || a.Education == activeCV.Education || a.Experience == activeCV.Experience || a.Age >= activeCV.Age || a.City == activeCV.City || a.Salary >= activeCV.Salary)) { SuitableAnnouncementsForm suitableAnnouncementsForm = new SuitableAnnouncementsForm(activeWorker); suitableAnnouncementsForm.ShowDialog(); } else { MessageBox.Show("There is no Suitable Announcement for You.", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("You must add Your CV for showing Suitable Announcements", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void EmployerPendingPage_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { var myActiveVacancy = db.Vacancies.Include("CVs").Where(x => x.UserId == user.ID).ToList(); foreach (var vacancy in myActiveVacancy) { foreach (var cv in vacancy.CVs) { allPendingRequests.Add(new AllPendingRequests() { JobTitle = vacancy.JobTitle, ID = cv.ID, Name = cv.Name, Surname = cv.Surname, Gender = cv.Gender, City = cv.City, Category = cv.Category, Salary = cv.Salary, Age = cv.Age, Education = cv.Education, Experience = cv.Experience, Phone = cv.Phone, }); } } PendingRequests.DataSource = allPendingRequests; PendingRequests.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; } }
private void Form14_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { IQueryable <Announcement> query = db.Announcements; CV cv = db.CVs.FirstOrDefault(c => c.UserID == activeWorker.ID); foreach (var dbAnnouncement in query) { string categoryName = db.Categories.FirstOrDefault(c => c.ID.Equals(dbAnnouncement.CategoryID)).Name; string cityName = db.Cities.FirstOrDefault(c => c.ID.Equals(dbAnnouncement.CityID)).Name; ListViewItem listViewItem; if (cv != null && cv.CategoryID == dbAnnouncement.CategoryID) { string[] item = { "APPLY HERE", dbAnnouncement.Name, dbAnnouncement.CompanyName, categoryName, dbAnnouncement.Information, dbAnnouncement.Education, dbAnnouncement.Experience, dbAnnouncement.Age.ToString(), cityName, dbAnnouncement.Salary.ToString(), dbAnnouncement.PhoneNumber }; listViewItem = new ListViewItem(item); } else { string[] item = { "NOT SUITABLE FOR YOUR CV", dbAnnouncement.Name, dbAnnouncement.CompanyName, categoryName, dbAnnouncement.Information, dbAnnouncement.Education, dbAnnouncement.Experience, dbAnnouncement.Age.ToString(), cityName, dbAnnouncement.Salary.ToString(), dbAnnouncement.PhoneNumber }; listViewItem = new ListViewItem(item); } listView.Items.Add(listViewItem); } } }
public void AddtoListView() { using (HrMatchContext db = new HrMatchContext()) { foreach (var dbAnnouncement in query) { string categoryName = db.Categories.FirstOrDefault(c => c.ID.Equals(dbAnnouncement.CategoryID)).Name; string cityName = db.Cities.FirstOrDefault(c => c.ID.Equals(dbAnnouncement.CityID)).Name; ListViewItem listViewItem; if (HasCV() && cv.CategoryID == dbAnnouncement.CategoryID) { string[] item = { "APPLY HERE", dbAnnouncement.Name, dbAnnouncement.CompanyName, categoryName, dbAnnouncement.Information, dbAnnouncement.Education, dbAnnouncement.Experience, dbAnnouncement.Age.ToString(), cityName, dbAnnouncement.Salary.ToString(), dbAnnouncement.PhoneNumber }; listViewItem = new ListViewItem(item); } else { string[] item = { "NOT SUITABLE FOR YOUR CV", dbAnnouncement.Name, dbAnnouncement.CompanyName, categoryName, dbAnnouncement.Information, dbAnnouncement.Education, dbAnnouncement.Experience, dbAnnouncement.Age.ToString(), cityName, dbAnnouncement.Salary.ToString(), dbAnnouncement.PhoneNumber }; listViewItem = new ListViewItem(item); } listView.Items.Add(listViewItem); } } }
private void Form13_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { query = db.workersAnnouncements .Where(x => x.WorkerID == activeWorker.ID); List <Announcement> announcements = new List <Announcement>(); foreach (var dbworkerAnnouncement in query) { announcements.AddRange(db.Announcements.Where(a => a.ID == dbworkerAnnouncement.AnnouncementID)); } foreach (var dbAnnouncement in announcements) { string categoryName = db.Categories.FirstOrDefault(c => c.ID.Equals(dbAnnouncement.CategoryID)).Name; string cityName = db.Cities.FirstOrDefault(c => c.ID.Equals(dbAnnouncement.CityID)).Name; string[] item = { dbAnnouncement.Name, dbAnnouncement.CompanyName, categoryName, dbAnnouncement.Information, dbAnnouncement.Education, dbAnnouncement.Experience, dbAnnouncement.Age.ToString(), cityName, dbAnnouncement.Salary.ToString(), dbAnnouncement.PhoneNumber }; ListViewItem listViewItem = new ListViewItem(item); listView.Items.Add(listViewItem); } } }
private void EmployerVacanciesPage_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { var myVacancies = db.Vacancies.Where(x => x.UserId == user.ID).ToList(); foreach (var item in myVacancies) { myVac.Add(new MyVac() { ID = item.ID, JobTitle = item.JobTitle, Company = item.Company, Category = item.Category, City = item.City, Salary = item.Salary, Age = item.Age, Education = item.Education, Experience = item.Experience, Phone = item.Phone, About = item.About }); } } myVacancies.DataSource = myVac; myVacancies.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; }
private void CvInfoDelete_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Are you sure?", "Delete CV", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { using (HrMatchContext db = new HrMatchContext()) { var delete = db.Database.ExecuteSqlCommand($"DELETE FROM CVs WHERE UserID = {user.ID}"); try { if (delete > 0) { MessageBox.Show("Cv Deleted"); this.Dispose(); } else { MessageBox.Show("CV not Deleted"); } } catch { MessageBox.Show("Can't find any CV"); } } } }
private void button1_Click(object sender, EventArgs e) { if (CheckFields()) { using (HrMatchContext db = new HrMatchContext()) { int categoryID = db.Categories.FirstOrDefault(c => c.Name.Equals(category.Text)).ID; int cityID = db.Cities.FirstOrDefault(c => c.Name.Equals(city.Text)).ID; Byte.TryParse(age.Text, out byte Age); Decimal.TryParse(salary.Text, out decimal Salary); Announcement announcement = new Announcement(activeEmployer.ID, name.Text, company.Text, categoryID, information.Text, cityID, Age, education.Text, experience.Text, Salary, phoneNumber.Text); db.Announcements.Add(announcement); db.SaveChanges(); MessageBox.Show("Your Announcement is Successfully Added!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Information); name.Text = string.Empty; company.Text = string.Empty; category.Text = string.Empty; information.Text = string.Empty; city.Text = string.Empty; age.Text = string.Empty; education.Text = string.Empty; experience.Text = string.Empty; salary.Text = string.Empty; phoneNumber.Text = string.Empty; } } }
public bool CheckFields() { if (name.Text == string.Empty || company.Text == string.Empty || category.Text == string.Empty || information.Text == string.Empty || city.Text == string.Empty || age.Text == string.Empty || education.Text == string.Empty || experience.Text == string.Empty || salary.Text == string.Empty || phoneNumber.Text == string.Empty) { MessageBox.Show("All field must be filled!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } using (HrMatchContext db = new HrMatchContext()) { if (!db.Categories.Any(c => c.Name == category.Text)) { MessageBox.Show("'Category' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else if (!db.Cities.Any(c => c.Name == city.Text)) { MessageBox.Show("'City' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else if (!Byte.TryParse(age.Text, out byte Age)) { MessageBox.Show("'Age' field is not valid format! It must be a number!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else if (!education.Items.Contains(education.Text)) { MessageBox.Show("'Education' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else if (!experience.Items.Contains(experience.Text)) { MessageBox.Show("'Experience' field has not chosen correctly!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else if (!Decimal.TryParse(salary.Text, out decimal Salary)) { MessageBox.Show("Salary field is not valid format! It must be a number!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else if (!isValidPhoneNumber(phoneNumber.Text)) { MessageBox.Show("'Phone Number' field has not written correctly! Example: +994-55-555-55-55", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } return(true); } }
private void Form12_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { CV activeCV = db.CVs.FirstOrDefault(c => c.UserID == activeWorker.ID); query = db.Announcements .Where(a => (a.CategoryID == activeCV.CategoryID) && (a.Education == activeCV.Education || a.Experience == activeCV.Experience || a.Age == activeCV.Age || a.City == activeCV.City || a.Salary > activeCV.Salary)); AddtoListView(); } }
public static bool CheckAlreadyApply(User activeWorker, Announcement activeAnnouncement) { using (HrMatchContext db = new HrMatchContext()) { if (db.workersAnnouncements.Any(x => x.WorkerID == activeWorker.ID && x.AnnouncementID == activeAnnouncement.ID)) { return(true); } return(false); } }
private void Form3_Load(object sender, EventArgs e) { users = new List <User>(); using (db = new HrMatchContext()) { foreach (var user in db.Users) { User dbUser = new User(user.ID, user.Username, user.Email, user.Status, user.Password); users.Add(dbUser); } } }
public bool HasCV() { using (HrMatchContext db = new HrMatchContext()) { cv = db.CVs.FirstOrDefault(c => c.UserID == activeWorker.ID); if (cv != null) { return(true); } return(false); } }
private void listView_MouseClick(object sender, MouseEventArgs e) { if (cv != null) { for (int itemIndex = 0; itemIndex < listView.Items.Count; itemIndex++) { var rectangle = listView.GetItemRect(itemIndex); ListViewItem item = listView.Items[itemIndex]; var subItems = item.SubItems; if (rectangle.Contains(e.Location) && subItems[0].Text == "APPLY HERE") { DialogResult dialogResult = MessageBox.Show("Do You Want to Pass Apply Form?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult.Equals(DialogResult.Yes)) { string name = subItems[1].Text; string companyName = subItems[2].Text; string categoryName = subItems[3].Text; string information = subItems[4].Text; string education = subItems[5].Text; string experience = subItems[6].Text; byte age = Convert.ToByte(subItems[7].Text); string cityName = subItems[8].Text; decimal salary = Convert.ToDecimal(subItems[9].Text); string phoneNumber = subItems[10].Text; Announcement announcement; using (HrMatchContext db = new HrMatchContext()) { int categoryID = db.Categories.FirstOrDefault(c => c.Name.Equals(categoryName)).ID; int cityID = db.Cities.FirstOrDefault(c => c.Name.Equals(cityName)).ID; announcement = db.Announcements .FirstOrDefault(a => a.Name.Equals(name) && a.CompanyName.Equals(companyName) && a.CategoryID.Equals(categoryID) && a.CityID.Equals(cityID) && a.Information.Equals(information) && a.Education.Equals(education) && a.Experience.Equals(experience) && a.Age.Equals(age) && a.Salary.Equals(salary) && a.PhoneNumber.Equals(phoneNumber)); } Form11 form11 = new Form11(activeWorker, announcement); form11.ShowDialog(); } } } } else { MessageBox.Show("You must add Your CV for Any Apply!", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void myCvInfo_Click(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { CV cv = db.CVs.FirstOrDefault(c => c.UserId == user.ID); if (cv != null) { new JobseekerCvInfoPage(user).ShowDialog(); } else { MessageBox.Show("Can't find any CV - At First add CV", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void addCV_Click(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { CV cv = db.CVs.FirstOrDefault(c => c.UserId == user.ID); if (cv == null) { new JobseekerAddCVPage(user).ShowDialog(); } else { MessageBox.Show("You already have active CV - for change delete it", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void JobseekerJobForYouPage_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { var myCv = db.CVs.FirstOrDefault(c => c.UserId == user.ID); if (myCv != null) { var myCvVac = db.Vacancies.Where(x => x.Category == myCv.Category && x.City == myCv.City && x.Salary >= myCv.Salary ).ToList(); if (myCvVac.Count > 0) { foreach (var item in myCvVac) { vacForYou.Add(new VacForYou() { ID = item.ID, JobTitle = item.JobTitle, Company = item.Company, Category = item.Category, City = item.City, Salary = item.Salary, Age = item.Age, Education = item.Education, Experience = item.Experience, Phone = item.Phone, About = item.About }); } } else { MessageBox.Show("Can't find any Vacancy based your CV", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Dispose(); } } else { MessageBox.Show("Can't find any CV - At First add CV", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Dispose(); } } VacancyForYou.DataSource = vacForYou; VacancyForYou.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; }
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 CvInfoPage_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { CV cv = db.CVs.FirstOrDefault(c => c.UserId == user.ID); CvInfoName.Text = cv.Name; CvInfoSurname.Text = cv.Surname; CvInfoGender.Text = cv.Gender; CvInfoCity.Text = cv.City; CvInfoCategory.Text = cv.Category; CvInfoSalary.Text = cv.Salary.ToString(); CvInfoAge.Text = cv.Age.ToString(); CvInfoEducation.Text = cv.Education; CvInfoExperience.Text = cv.Experience; CvInfoPhone.Text = cv.Phone; } }
private void information_Click(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { CV cv = db.CVs.FirstOrDefault(c => c.UserID == activeWorker.ID); if (cv != null) { CVInformationForm cVInformationForm = new CVInformationForm(activeWorker); cVInformationForm.ShowDialog(); } else { MessageBox.Show("You haven't Added Your CV", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void Form8_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { foreach (var dbCategory in db.Categories) { category.Items.Add(dbCategory.Name); } foreach (var dbCity in db.Cities) { city.Items.Add(dbCity.Name); } } AddComboboxItems(); }
public void AddtoListView() { using (HrMatchContext db = new HrMatchContext()) { foreach (var dbCV in query) { string categoryName = db.Categories.FirstOrDefault(c => c.ID.Equals(dbCV.CategoryID)).Name; string cityName = db.Cities.FirstOrDefault(c => c.ID.Equals(dbCV.CityID)).Name; string[] item = { dbCV.Name, dbCV.Surname, dbCV.Gender, dbCV.Age.ToString(), dbCV.Education, dbCV.Experience, categoryName, cityName, dbCV.Salary.ToString(), dbCV.PhoneNumber }; ListViewItem listViewItem = new ListViewItem(item); listView.Items.Add(listViewItem); } } }
private void Form2_Load(object sender, EventArgs e) { users = new List <User>(); using (HrMatchContext db = new HrMatchContext()) { foreach (var user in db.Users) { User dbUser = new User(user.ID, user.Username, user.Email, user.Status, user.Password); users.Add(dbUser); } } status.Items.Add("Worker"); status.Items.Add("Employer"); CodeText.Text = GetRandomPassword(); }
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 appliedAnnouncements_Click(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { IQueryable <WorkersAnnouncements> query = db.workersAnnouncements .Where(x => x.WorkerID == activeWorker.ID); if (query.Any(x => x.WorkerID == activeWorker.ID)) { AppliedAnnouncementsForm appliedAnnouncementsForm = new AppliedAnnouncementsForm(activeWorker); appliedAnnouncementsForm.ShowDialog(); } else { MessageBox.Show("There is no Applied Announcement for You.", "Alert", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public bool CheckHasCV() { using (HrMatchContext db = new HrMatchContext()) { foreach (var dbCV in db.CVs) { if (dbCV.UserID.Equals(activeWorker.ID)) { UserCV = db.CVs.FirstOrDefault(c => c.UserID.Equals(activeWorker.ID)); categoryName = db.Categories.FirstOrDefault(c => c.ID.Equals(UserCV.CategoryID)).Name; cityName = db.Cities.FirstOrDefault(c => c.ID.Equals(UserCV.CityID)).Name; return(true); } } return(false); } }
private void Form7_Load(object sender, EventArgs e) { using (HrMatchContext db = new HrMatchContext()) { CV cv = db.CVs.FirstOrDefault(c => c.UserID == activeWorker.ID); title.Text = db.Users.FirstOrDefault(u => u.ID == cv.UserID).Username + "'s" + " " + "CV"; category.Text = db.Categories.FirstOrDefault(c => c.ID == cv.CategoryID).Name; city.Text = db.Cities.FirstOrDefault(c => c.ID == cv.CityID).Name; name.Text = cv.Name; surname.Text = cv.Surname; gender.Text = cv.Gender; age.Text = cv.Age.ToString(); education.Text = cv.Education; experience.Text = cv.Experience; salary.Text = cv.Salary.ToString(); phoneNumber.Text = cv.PhoneNumber; } }