private void PersonelGuncelle()
{
try
{
DateTime selectedDate = Convert.ToDateTime(calendarControl.SelectionStart.ToShortDateString());
if (string.IsNullOrEmpty(txtAdi.Text) || string.IsNullOrEmpty(txtSoyadi.Text) || string.IsNullOrEmpty(txtTelefon.Text))
{
MessageBox.Show("Personel Bilgileri Boş Geçilemez !");
}
if (selectedDate > DateTime.Now)
{
MessageBox.Show("İşe giriş tarihi bugünden daha sonraki bir tarih olamaz!");
}
Personeller personel = new Personeller
{
personelID = int.Parse(txtPersonelID.Text),
adi = txtAdi.Text,
soyadi = txtSoyadi.Text,
cepTelefonu = txtTelefon.Text,
departmanID = Convert.ToInt32(cmbDepartmanGuncelle.SelectedValue),
iseGirisTarihi = selectedDate
};
PersonelController.PersonelGuncelle(personel);
MessageBox.Show("Personel Başarıyla Güncellendi !", "İşlem Başarılı !", MessageBoxButtons.OK, MessageBoxIcon.Information);
PersonelListele();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Hata Meydana Geldi !", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void PersonelDetayForm_Load(object sender, EventArgs e)
{
var result = PersonelController.PersonelGetir(kisiId);
lbl_AdSoyad.Text = "Ad Soyad: " + result.Personel.Ad + " " + result.Personel.Soyad;
lbl_KullaniciAdi.Text = "Kullanıcı Adı: " + result.Kullanici.KullaniciAdi;
lbl_Rol.Text = "Kullanıcı Türü: " + result.Rol.RolAdi;
var result2 = PersonelController.KullaniciSorumluDepartmanlar(kisiId);
DataTable dt = new DataTable();
dt.Columns.Add("DepartmanId", typeof(int));
dt.Columns.Add("DepartmanAdi", typeof(string));
dt.Columns.Add("AdSoyad", typeof(string));
foreach (var item in result2)
{
dt.Rows.Add(item.Departman.DepartmanId, item.Departman.DepartmanAdi, item.Personel.Ad + " " + item.Personel.Soyad);
}
grid_PersonelDepartman.DataSource = dt;
gridView_personelDepartman.Columns["DepartmanId"].Visible = false;
var result1 = PersonelController.KullaniciZimmetleri(kisiId);
DataTable dtDemirbas = new DataTable();
dtDemirbas.Columns.Add("DemirbasKodu", typeof(string));
dtDemirbas.Columns.Add("DemirbasAdi", typeof(string));
foreach (var item in result1)
{
dtDemirbas.Rows.Add(item.Demirbas.DemirbasKodu, item.Demirbas.DemirbasAdi);
}
grid_personeldemirbas.DataSource = dtDemirbas;
}
private void userCheck(string role)
{
if (role == "p")
{
var x = PersonelController.setPersonelById(userId);
setUser(x.personelId, x.personelName, x.personelSurname, x.personelMail, x.personelTeam, x.personelStartDate, x.personelLocation);
setPersonProjects(userId);
setPersonTasks(userId);
}
else if (role == "pm")
{
var x = ProjectManagerController.setProjectManagerByUserId(userId);
setUser(x.projectManagerId, x.projectManagerName, x.projectManagerSurname
, x.projectManagerEmail, x.projectManagerTeam, x.projectManagerStartDate,
x.projectManagerLocation);
setProjectManagerProjects(userId);
setProjectManagerTasks(userId);
}
else
{
var x = ManagerController.setManager(userId);
setUser(x.managerId, x.managerName, x.managerSurname, x.managerMail,
x.managerTeam, x.managerStartDate, x.managerLocation);
setProjects();
tabControl1.TabPages.Remove(tabPage2);
}
}
private void DepartmanDuzenleForm_Load(object sender, EventArgs e)
{
if (LoginForm._session == eRoller.SatisSorumlusu.ToString())
{
btn_Ekle.Enabled = false;
btn_DepartmanSil.Enabled = false;
}
Tools.ComboBoxSirketGetir(cmb_Sirket);
var result = DepartmanController.DepartmanDetayiGetir(_departmanId);
txt_DepartmanAdi.Text = result.Departman.DepartmanAdi;
cmb_Sirket.SelectedValue = result.Departman.Sirketler.SirketId;
cmb_Departman.SelectedValue = result.Departman.DepartmanId;
var kullanicilariListele = PersonelController.KullanicilariListele();
DataTable dtKullancilar = new DataTable("personeller");
dtKullancilar.Columns.Add("Ad", typeof(string));
dtKullancilar.Columns.Add("Soyad", typeof(string));
dtKullancilar.Columns.Add("PersonelId", typeof(int));
foreach (var item in kullanicilariListele)
{
dtKullancilar.Rows.Add(item.Ad, item.Soyad, item.PersonelId);
}
grid_Kisiler.DataSource = dtKullancilar;
}
private void DepartmanKisiYetkilendirForm_Load(object sender, EventArgs e)
{
var DepartmanlarListesi = DepartmanController.TumDepartmanlariGetir();
DataTable dtBitenStokList = new DataTable("departmanListesi");
dtBitenStokList.Columns.Add("DepartmanId", typeof(int));
dtBitenStokList.Columns.Add("DepartmanAdi", typeof(string));
dtBitenStokList.Columns.Add("SirketAdi", typeof(string));
foreach (var item in DepartmanlarListesi)
{
dtBitenStokList.Rows.Add(item.Departman.DepartmanId, item.Departman.DepartmanAdi /*,item.Departman.Sirketler.SirketAdi*/);
}
grid_DepartmanListesi.DataSource = dtBitenStokList;
// gridView_DepartmanListesi.Columns["departmanId"].Visible = false;
var kullanicilariListele = PersonelController.KullanicilariListele();
DataTable dtKullancilar = new DataTable("personeller");
dtKullancilar.Columns.Add("Ad", typeof(string));
dtKullancilar.Columns.Add("Soyad", typeof(string));
dtKullancilar.Columns.Add("PersonelId", typeof(int));
foreach (var item in kullanicilariListele)
{
dtKullancilar.Rows.Add(item.Ad, item.Soyad, item.PersonelId);
}
grid_personelListesi.DataSource = dtKullancilar;
}
private void setUser(int id)
{
if (role == "p")
{
var person = PersonelController.setPersonelById(id);
textBoxName.Text = person.personelName;
textBoxSurname.Text = person.personelSurname;
textBoxTeam.Text = person.personelTeam;
textBoxEmail.Text = person.personelMail;
textBoxLocation.Text = person.personelLocation;
dateTimePickerSD.Value = person.personelStartDate;
}
else if (role == "pm")
{
var pm = ProjectManagerController.setProjectManagerByUserId(id);
textBoxName.Text = pm.projectManagerName;
textBoxSurname.Text = pm.projectManagerSurname;
textBoxTeam.Text = pm.projectManagerTeam;
textBoxEmail.Text = pm.projectManagerEmail;
textBoxLocation.Text = pm.projectManagerLocation;
dateTimePickerSD.Value = pm.projectManagerStartDate;
}
else
{
var m = ManagerController.setManager(id);
textBoxName.Text = m.managerName;
textBoxSurname.Text = m.managerSurname;
textBoxTeam.Text = m.managerTeam;
textBoxEmail.Text = m.managerMail;
textBoxLocation.Text = m.managerLocation;
dateTimePickerSD.Value = m.managerStartDate;
}
}
public void GetStaff()
{
PersonelController controller = new PersonelController();
IEnumerable <PersonelModel> result = controller.Get();
Assert.IsNotNull(result);
Assert.AreNotEqual(0, result.Count());
}
private void buttonDeleteP_Click(object sender, EventArgs e)
{
if (Controller.Controller.question())
{
PersonelController.deletePersonel(userId);
listPeople();
}
}
public FormIseGirisCikis(int olusturanPersonelId)
{
InitializeComponent();
_personelC = new PersonelController();
_personelIseGirisCikisC = new PersonelIseGirisCikisController();
_personelUnvanDepartmanC = new PersonelUnvanDepartmanDtoController();
_olusturanPersonelId = olusturanPersonelId;
FormuYenile();
}
public void GetById()
{
PersonelController controller = new PersonelController();
string result = controller.Get("0016508").StaffNameThai;
Assert.IsNotNull(result);
Assert.AreEqual("นิติวัฒน์", result);
}
public void GetByName()
{
PersonelController controller = new PersonelController();
IEnumerable <PersonelModel> result = controller.GetByName("นิติวัฒน์");
Assert.IsNotNull(result);
Assert.AreEqual(1, result.Count());
}
private void setComboBoxPersonel()
{
var personellist = PersonelController.listPersonel();
foreach (var personel in personellist)
{
pID.Add(personel.personelId);
comboBoxPersonel.Items.Add(personel.personelName + " " + personel.personelSurname);
}
}
public FormPersonelGoruntule(int olusturanPersonel)
{
InitializeComponent();
_unC = new UnvanController();
_depC = new DepartmanController();
_pc = new PersonelController();
_pgDTOc = new PersonelGoruntuleDTOController();
_persID = olusturanPersonel;
_cc = new CariUyeController();
_pitc = new PersonelIsTanimController();
_cubc = new CariUyeBilgileriController();
}
private void setComboBoxPersonText(int id, string role)
{
if (role == "p")
{
var user = PersonelController.setPersonelById(id);
comboBoxPersonel.Text = user.personelName + " " + user.personelSurname;
}
else
{
var user = ProjectManagerController.setProjectManagerByUserId(id);
comboBoxPersonel.Text = user.projectManagerName + " " + user.projectManagerSurname;
}
}
public void Init()
{
//directory.getcurrentdirectory()
var configurationbuilder = new ConfigurationBuilder()
.SetBasePath(@"D:\ERP\ERP.HRM.WebAPI")
.AddJsonFile("appsettings.json", optional: true);
var configuration = configurationbuilder.Build();
var optionsbuilder = new DbContextOptionsBuilder <HRMContext>()
.UseSqlServer(configuration.GetConnectionString("DefaultConnection"));
_unitofwork = new UnitOfWork(new HRMContext(optionsbuilder.Options));
_controller = new PersonelController(configuration, _mapper, _unitofwork, _userService);
}
private void PersonelListeForm_Load(object sender, EventArgs e)
{
var result = PersonelController.KullanicilariListele();
DataTable dtKullancilar = new DataTable("personller");
dtKullancilar.Columns.Add("Ad", typeof(string));
dtKullancilar.Columns.Add("Soyad", typeof(string));
dtKullancilar.Columns.Add("PersonelId", typeof(int));
foreach (var item in result)
{
dtKullancilar.Rows.Add(item.Ad, item.Soyad, item.PersonelId);
}
grid_Personel.DataSource = dtKullancilar;
gridView_Personel.Columns["PersonelId"].Visible = false;
}
private void btnPersonelEkle_Click(object sender, EventArgs e)
{
try
{
DateTime selectedDate = Convert.ToDateTime(calendarControl2.SelectionStart.ToShortDateString());
if (string.IsNullOrEmpty(cmbDepartmanSec.SelectedValue.ToString()))
{
throw new ValidationException("Lütfen Departman Bilgilerini Kontrol Ediniz !");
}
if (string.IsNullOrEmpty(cmbDepartmanSec.Text))
{
throw new ValidationException("Lütfen Departman Seçiniz !");
}
if (string.IsNullOrEmpty(txtPersonelAd.Text))
{
throw new ValidationException("Lütfen Ad Bilgisini Kontrol Ediniz !");
}
if (string.IsNullOrEmpty(txtPersonelSoyad.Text))
{
throw new ValidationException("Lütfen Soyad Bilgisini Kontrol Ediniz !");
}
if (string.IsNullOrEmpty(txtCepTelefonu.Text))
{
throw new ValidationException("Lütfen Cep Telefonu Bilgisini Kontrol Ediniz !");
}
if (selectedDate > DateTime.Now)
{
throw new ValidationException("İşe giriş tarihi bugünden daha sonraki bir tarih olamaz!");
}
Personeller personel = new Personeller
{
adi = txtPersonelAd.Text,
soyadi = txtPersonelSoyad.Text,
cepTelefonu = txtCepTelefonu.Text,
departmanID = Convert.ToInt32(cmbDepartmanSec.SelectedValue),
iseGirisTarihi = selectedDate
};
PersonelController.PersonelEkle(personel);
MessageBox.Show("Personel Başarıyla Eklendi !", "Personel Eklendi !", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Giriş Bilgilerini Kontrol Ediniz !", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void update()
{
if (role == "pm")
{
ProjectManagerController.updateProjectManager(textBoxName.Text, textBoxSurname.Text, textBoxEmail.Text, textBoxLocation.Text);
MessageBox.Show("Successful");
}
else if (role == "p")
{
PersonelController.updatePersonel(textBoxName.Text, textBoxSurname.Text, textBoxEmail.Text, textBoxLocation.Text);
MessageBox.Show("Successful");
}
else
{
ManagerController.updateManager(textBoxName.Text, textBoxSurname.Text, textBoxEmail.Text, textBoxTeam.Text, textBoxLocation.Text);
MessageBox.Show("Successful");
}
}
public FormPersonelEkle(int olusturanPersenel)
{
InitializeComponent();
_pcDtoCon = new PersonelCariDtoController();
_pcDto = new PersonelCariDTO();
_uc = new UnvanController();
_dc = new DepartmanController();
_pc = new PersonelController();
_btc = new BankaTanimController();
_pcDto.OlusturanPersonelID = olusturanPersenel;
Helper.BindComboBox <Unvan>(_uc.GetUnvan(), cmbUnvan, "GorevAdi", "Id");
Helper.BindComboBox <Departman>(_dc.AktifDepartmanlariGetir(), cmbDepartman, "DepartmanAdi", "Id");
Helper.BindComboBox <Personel>(_pc.AktifPersonelleriGetir(), cmbYonetici, "FullName", "Id");
Helper.BindComboBox <BankaTanim>(_btc.AktifBankaGetir(), cmbBankaAdi, "BankaAdi", "ID");
cmbUnvan.SelectedIndex = -1;
cmbDepartman.SelectedIndex = -1;
cmbYonetici.SelectedIndex = -1;
cmbBankaAdi.SelectedIndex = -1;
}
private void btn_PersonelEkle_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txt_PersonelAdi.Text) || string.IsNullOrEmpty(txt_PersonelSoyadi.Text))
{
throw new ValidationException("Personel Bilgileri Boş Geçilemez !");
}
Kullanicilar kullanicilar = new Kullanicilar();
kullanicilar.Personeller.Ad = txt_PersonelAdi.Text;
kullanicilar.Personeller.Soyad = txt_PersonelSoyadi.Text;
PersonelController.PersonelEkle(kullanicilar);
MessageBox.Show("Personel Bilgileri Başarıyla Eklendi !", "İşlem Başarılı !", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Hata Meydana Geldi !", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (control())
{
setProperty();
if (role == "p")
{
if (state == "new")
{
PersonelController.createPersonel(name, surname, team, mail, location);
this.Close();
}
PersonelController.editPersonel(name, surname, mail, team, location);
this.Close();
}
else if (role == "pm")
{
if (state == "new")
{
ProjectManagerController.createProjectManager(name, surname, mail, team, location);
this.Close();
}
ProjectManagerController.editProjectManager(name, surname, mail, team, location);
this.Close();
}
else
{
if (state == "new")
{
ManagerController.createManager(name, surname, team, mail, location);
this.Close();
}
ManagerController.updateManager(name, surname, mail, team, location);
this.Close();
}
}
else
{
MessageBox.Show("Lütfen bütün alanları doldurunuz.");
}
}
private void BtnPersonelSil_Click(object sender, EventArgs e)
{
DialogResult sonuc = MessageBox.Show(txtAdi.Text + " İsimli Personel Silinsin Mi ?", "Karar ?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (sonuc == DialogResult.Yes)
{
PersonelController.PersonelSil(int.Parse(txtPersonelID.Text));
MessageBox.Show(txtAdi.Text + " " + txtSoyadi.Text + " İsimli Personel Silindi !", "İşlem Başarılı !", MessageBoxButtons.OK, MessageBoxIcon.Information);
PersonelListele();
}
List <Zimmetler> zimmetler;
zimmetler = ZimmetController.ZimmetListele();
foreach (Zimmetler z in zimmetler)
{
if (z.personelID == int.Parse(txtPersonelID.Text))
{
AtikController.AtikEkle(z.zimmetID);
}
}
}
private void listPeople()
{
dataGridViewPeople.DataSource = PersonelController.listPersonel();
this.dataGridViewPeople.Columns["tbl_TaskforPersonel"].Visible = false;
this.dataGridViewPeople.Columns["tbl_Project"].Visible = false;
}
public static void ComboBoxPersonelGetir(ComboBox cmb)
{
cmb.DataSource = PersonelController.PersonelListele();
cmb.DisplayMember = "adi";
cmb.ValueMember = "personelID";
}
private void listPeople(int id)
{
dataGridViewPeople.DataSource = PersonelController.listPersonelByProjectId(id);
}
private void listView(int id)
{
dataGridViewPerson.DataSource = PersonelController.reportPersosProject(id);
dataGridViewTask.DataSource = TaskController.reportTaskinProject(id);
}
private int setPersonId(int id)
{
return(PersonelController.getPersonIdByTaskId(id));
}
private void listPeople(int id)
{
dataGridViewAP.DataSource = PersonelController.listAvailablePersonel(id);
}
