private void SeeSelectedElan_Load(object sender, EventArgs e)
{
listView1.Columns.Add("Id");
listView1.Columns.Add("Elan Adi");
listView1.Columns.Add("Shirket Adi");
listView1.Columns.Add("Ish Adi");
listView1.Columns.Add("Melumat");
listView1.Columns.Add("Sheher");
listView1.Columns.Add("Maash");
listView1.Columns.Add("Yash");
listView1.Columns.Add("Tecrube");
listView1.Columns.Add("Telephone");
listView1.Columns.Add("Muraciet Et");
using (HrConnect db = new HrConnect())
{
var elan = db.Elans.FirstOrDefault(x => x.Id == elanId);
listView1.Items.Add(new ListViewItem(new string[] {
elan.Id.ToString(),
elan.ElanName,
elan.ShirketName,
elan.Workname,
elan.Description,
elan.City,
elan.Salary,
elan.Age.ToString(),
elan.Experience,
elan.Telephone,
"Muraciet et"
}));
}
}
private void EnUygunIsh_Load(object sender, EventArgs e)
{
listView1.Columns.Add("Elan adi");
listView1.Columns.Add("Shirket adi");
listView1.Columns.Add("Ish adi");
listView1.Columns.Add("Description");
listView1.Columns.Add("Sheher");
listView1.Columns.Add("Maash ");
listView1.Columns.Add("Yash");
listView1.Columns.Add("Tecrube");
listView1.Columns.Add("Tehsil");
listView1.Columns.Add("Telephone");
using (HrConnect db = new HrConnect())
{
var cv = db.Cvs.FirstOrDefault(x => x.Userid == Helper.userId);
string workName = cv.WorkName;
string educationName = cv.EducationName;
var elans = db.Elans.Where(x => x.Workname == workName || x.Education == educationName).ToList();
if (elans.Count >= 1)
{
foreach (var item in elans)
{
listView1.Items.Add(new ListViewItem(new string[] { item.ElanName, item.ShirketName,
item.Workname, item.Description, item.City, item.Salary, item.Age.ToString(), item.Experience,
item.Education, item.Telephone.ToString() }));
}
}
else
{
MessageBox.Show("Uygun ish tapilmadi");
}
}
}
private void SeeappliedElan_Load(object sender, EventArgs e)
{
listView1.Columns.Add("Elan adi");
listView1.Columns.Add("Shirket adi");
listView1.Columns.Add("Ish adi");
listView1.Columns.Add("Description");
listView1.Columns.Add("City");
listView1.Columns.Add("Salary");
listView1.Columns.Add("Telephone");
using (HrConnect db = new HrConnect()){
var cv = db.Cvs.Include("Elans").FirstOrDefault(x => x.Userid == Helper.userId);
var elans = cv.Elans.ToList();
foreach (var item in elans)
{
listView1.Items.Add(new ListViewItem(new string[] { item.ElanName, item.ShirketName
, item.Workname, item.Description, item.City, item.Salary, item.Telephone }));
}
}
}
private void button1_Click(object sender, EventArgs e)
{
var username = userName.Text;
var passwordBox = password.Text;
using (HrConnect db = new HrConnect())
{
var result = db.Users.Count(x => x.Username == username && x.Password == passwordBox);
if (result == 1)
{
var myUser = db.Users.FirstOrDefault(x => x.Username == username && x.Password == passwordBox);
Helper.userId = myUser.Id;
MessageBox.Show(myUser.Id.ToString());
if (myUser.WhichUser == 1)
{
var cvLook = new seeCv(myUser.Id);
cvLook.Show();
this.Hide();
}
else if (myUser.WhichUser == 2)
{
var allelans = new SeeAllElansIshveren();
allelans.Show();
this.Hide();
}
}
}
}
private void clickMe_Click(object sender, EventArgs e)
{
string name = nameBox.Text;
string surname = surnameTextbox.Text;
string gender = sexBox.Text.Substring(2);
int age = Convert.ToInt32(ageBox.Value);
int education = Convert.ToInt32(educationBox.Text.Substring(0, 1));
string ishTecrubesi = experienceBox.Text;
int work = Convert.ToInt32(categoryBox.Text.Substring(0, 1));
string city = cityBox.Text;
string minSalary = minSalaryBox.Value.ToString();
string cellphone = cellPhone.Text;
using (HrConnect db = new HrConnect())
{
var cvs = db.Cvs.ToList();
var result = cvs.Where(x => x.Userid == Helper.userId).ToList();
if (result.Count > 0)
{
MessageBox.Show("Bu usernamenin uygun cv si var");
}
else
{
string workName = db.Works.FirstOrDefault(x => x.Id == work).WorkName;
string educationName = db.Educations.FirstOrDefault(x => x.Id == education).EducationName;
db.Cvs.Add(new Cv()
{
CvName = name,
CvSurname = surname,
CvSex = gender,
CvAge = age,
EducationName = educationName,
CvWorkExperiment = ishTecrubesi,
WorkName = workName,
CvCity = city,
CvMinSalary = minSalary,
ContactPhone = cellphone,
Userid = Helper.userId
});
db.SaveChanges();
nameBox.Text = "";
surnameTextbox.Text = "";
sexBox.Text = "";
ageBox.Value = 0;
educationBox.Text = "";
experienceBox.Text = "";
categoryBox.Text = "";
cityBox.Text = "";
minSalaryBox.Value = 0;
cellPhone.Text = "";
}
}
}
private void SeeAllELans_Load(object sender, EventArgs e)
{
listView1.Columns.Add("Id");
listView1.Columns.Add("Name");
using (HrConnect db = new HrConnect())
{
var elans = db.Elans.ToList();
foreach (var item in elans)
{
listView1.Items.Add(new ListViewItem(new string[]
{
item.Id.ToString(),
item.ElanName.ToString()
}));
}
}
}
private void listviewClick(object sender, EventArgs e)
{
var selectedItem = Convert.ToInt32(listView1.SelectedItems[0].Text);
using (HrConnect db = new HrConnect())
{
var elan = db.Elans.FirstOrDefault(x => x.Id == selectedItem);
var cv = db.Cvs.FirstOrDefault(x => x.Userid == Helper.userId);
MessageBox.Show(elan.Id.ToString() + "Elan Id");
MessageBox.Show(cv.Id.ToString() + "Cv id");
//db.Elans.Remove(elan);
//elan.Cvs.Add(cv);
//db.Elans.Add(elan);
db.Elans.FirstOrDefault(x => x.Id == selectedItem).Cvs.Add(cv);
db.SaveChanges();
}
}
private void SeeAllElansIshveren_Load(object sender, EventArgs e)
{
listView1.Columns.Add("Id");
listView1.Columns.Add("Name");
using (HrConnect db = new HrConnect())
{
var elans = db.Elans.Where(x => x.Userid == Helper.userId).ToList();
foreach (var item in elans)
{
listView1.Items.Add(new ListViewItem(new string[]
{
item.Id.ToString(),
item.ElanName.ToString()
}));
}
}
}
private void AddCv_Load(object sender, EventArgs e)
{
sexBox.Items.Add("1.Kisi");
sexBox.Items.Add("2.Qadin");
educationBox.Items.Add("1.Orta");
educationBox.Items.Add("2.Natamam Ali");
educationBox.Items.Add("3.Ali");
experienceBox.Items.Add("1 ilden asagi");
experienceBox.Items.Add("1 ilden 3 - ile qeder");
experienceBox.Items.Add("3 ilden - 5 ile qeder");
experienceBox.Items.Add(" 5 ilden daha cox");
using (HrConnect db = new HrConnect())
{
foreach (var work in db.Works)
{
categoryBox.Items.Add(work.Id + "." + work.WorkName);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
foreach (ListViewItem item in listView1.Items)
{
listView1.Items.Remove(item);
}
using (HrConnect db = new HrConnect())
{
var educationName = comboBox1.Text;
var elans = db.Elans.Where(x => x.Education == educationName).ToList();
foreach (var item in elans)
{
listView1.Items.Add(new ListViewItem(new string[] { item.ElanName,
item.ShirketName, item.Workname, item.Description, item.City,
item.Salary, item.Age.ToString(), item.Experience, item.Education, item.Telephone }));
}
}
}
private void AddElan_Load(object sender, EventArgs e)
{
using (HrConnect db = new HrConnect())
{
var categories = db.Works.ToList();
foreach (var item in categories)
{
kateqoriaBox.Items.Add(item.Id + "." + item.WorkName);
}
var tehsils = db.Educations.ToList();
foreach (var item in tehsils)
{
educationBox.Items.Add(item.Id + "." + item.EducationName);
}
experienceBox.Items.Add("1 ilden asagi");
experienceBox.Items.Add("1 ilden 3 - ile qeder");
experienceBox.Items.Add("3 ilden - 5 ile qeder");
experienceBox.Items.Add(" 5 ilden daha cox");
}
}
private void SearchIsh_Load(object sender, EventArgs e)
{
using (HrConnect db = new HrConnect())
{
var educations = db.Educations.ToList();
foreach (var item in educations)
{
comboBox1.Items.Add(item.EducationName);
}
listView1.Columns.Add("Elan Adi ");
listView1.Columns.Add("Shirket Adi ");
listView1.Columns.Add("Ish Adi ");
listView1.Columns.Add("Description ");
listView1.Columns.Add("City ");
listView1.Columns.Add("Maash ");
listView1.Columns.Add("Yash ");
listView1.Columns.Add("Tecrube ");
listView1.Columns.Add("Tehsil ");
listView1.Columns.Add("Telephone ");
}
}
private void SeeAppliedCvs_Load(object sender, EventArgs e)
{
listView1.Columns.Add("Elan adi");
listView1.Columns.Add("Ishci adi");
listView1.Columns.Add("Ishci Familyasi");
listView1.Columns.Add("Yas");
listView1.Columns.Add("Cins");
listView1.Columns.Add("Tecrube");
listView1.Columns.Add("Sheher");
listView1.Columns.Add("Minimum maash");
listView1.Columns.Add("Telephone nomresi");
listView1.Columns.Add("WorkName");
using (HrConnect db = new HrConnect())
{
var elans = db.Elans.Include("Cvs").Where(x => x.Userid == Helper.userId).ToList();
foreach (var elan in elans)
{
string[] listviewitem = new string[10];
listviewitem[0] = elan.ElanName;
foreach (var cv in elan.Cvs)
{
listviewitem[1] = cv.CvName;
listviewitem[2] = cv.CvSurname;
listviewitem[3] = cv.CvAge.ToString();
listviewitem[4] = cv.CvSex;
listviewitem[5] = cv.CvWorkExperiment;
listviewitem[6] = cv.CvCity;
listviewitem[7] = cv.CvMinSalary;
listviewitem[8] = cv.ContactPhone;
listviewitem[9] = cv.WorkName;
listView1.Items.Add(new ListViewItem(new string[] { listviewitem[0],
listviewitem[1], listviewitem[2], listviewitem[3], listviewitem[4],
listviewitem[5], listviewitem[6], listviewitem[7], listviewitem[8], listviewitem[9] }));
}
}
}
}
private void button1_Click_1(object sender, EventArgs e)
{
string elanName = elanAdi.Text;
string shirketName = sirketAdi.Text;
string workName = kateqoriaBox.Text.Substring(2);
string description = ishInfo.Text;
string city = cityBox.Text;
int salary = Convert.ToInt32(maashBox.Value);
int age = Convert.ToInt32(yashBox.Value);
string educationName = educationBox.Text.Substring(2);
string tecrube = experienceBox.Text;
string phone = phoneBox.Text;
using (HrConnect db = new HrConnect())
{
db.Elans.Add(new Elan {
ElanName = elanName,
ShirketName = shirketName,
Workname = workName,
Education = educationName,
Description = description,
City = city,
Salary = salary.ToString(),
Age = age,
Experience = tecrube,
Telephone = phone,
Userid = Helper.userId
});
db.SaveChanges();
elanAdi.Text = "";
sirketAdi.Text = "";
ishInfo.Text = "";
cityBox.Text = "";
maashBox.Value = 0;
yashBox.Value = 0;
}
}
private void button1_Click(object sender, EventArgs e)
{
HrConnect db = new HrConnect();
var username = usernameLabel.Text;
var email = emailLabel.Text;
var passwordFirst = passwordLabel.Text;
var passwordSecond = secondPassword.Text;
string random = randomTextBox.Text;
int whichUser = Convert.ToInt32(statusBox.Text.Substring(0, 1));
if (emailChecker(email) && passwordChecker(passwordFirst) && identicPasswordChecker(passwordFirst, passwordSecond) && randomChecker(random) && username.Length >= 4)
{
var users = db.Users.ToList();
if (users.Exists(x => x.Username == username))
{
MessageBox.Show("Bele Username artig var");
}
else if (users.Exists(x => x.Email == email))
{
MessageBox.Show("Bele email var");
}
else
{
db.Users.Add(new User()
{
Username = username,
Email = email,
Password = passwordFirst,
WhichUser = whichUser
});
db.SaveChanges();
var secondusers = db.Users.ToList();
Helper.userId = secondusers[secondusers.Count - 1].Id;
MessageBox.Show(Helper.userId.ToString());
db.Dispose();
usernameLabel.Text = "";
emailLabel.Text = "";
passwordLabel.Text = "";
secondPassword.Text = "";
randomLabel.Text = "";
if (whichUser == 1)
{
var ishciMain = new IshciMain();
ishciMain.Show();
this.Hide();
}
else
{
var ishverenMain = new IshverenMain();
ishverenMain.Show();
this.Hide();
}
}
}
else
{
MessageBox.Show("Melumatlar yanlishdir");
}
}
