public void DeletePersonel(PersonelTable personel) { ConnectionControl(); SqlCommand command = new SqlCommand("Delete From PersonelTable where Personel_Id=@personel_ıd", _connection); command.Parameters.AddWithValue("@personel_ıd", personel.Personel_Id); command.ExecuteNonQuery(); command.Dispose(); _connection.Close(); }
private void btnPersonelChange_Click(object sender, EventArgs e) { ///////////çalışan işlemleri if (_EmployeesIslemTuru == 0)//Güncelleme { PersonelTable personelTable = new PersonelTable { Personel_Id = (int)dgwEmployeess.CurrentRow.Cells["Personel_Id"].Value, Name = txtPersonelName.Text,//ıd i aldır Surname = txtPersonelSurname.Text, TelNumber = long.Parse(txtPersonelTel.Text), Department_Id = (int)cmbPersonelPosition.SelectedValue, ManagerName = cmbPersonelStatus.Text, }; personelDal.UpdatePersonel(personelTable); MessageBox.Show("Personel Güncellendi"); } else if (_EmployeesIslemTuru == 1)//Silme { // personelDal.DeletePersonel(deletePersonel); int deletePersonel = Convert.ToInt32(dgwEmployeess.CurrentRow.Cells["Personel_Id"].Value); string employeesName = dgwEmployeess.CurrentRow.Cells["Name"].Value.ToString(); string employeesSurname = dgwEmployeess.CurrentRow.Cells["Surname"].Value.ToString(); string managerStatusName = dgwEmployeess.CurrentRow.Cells["ManagerStatus"].Value.ToString(); string employeesNameSurname = employeesName + " " + employeesSurname; if (personelDal.ManagerController(employeesNameSurname) == true) { MessageBox.Show("Kullanıcı Yönetici", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { PersonelTable personelTable = new PersonelTable { Personel_Id = deletePersonel, }; personelDal.DeletePersonel(personelTable); MessageBox.Show("Kullanıcı silindi"); } } else if (_EmployeesIslemTuru == 2) { cmbEmployeesEventsChoose.SelectedIndex = 0; } else { cmbEmployeesEventsChoose.SelectedIndex = 0; } EmployeesLoader(); }
public void AddPersonel(PersonelTable personel)//departman olayını ayarla { ConnectionControl(); SqlCommand command = new SqlCommand("Insert into PersonelTable values(@name,@surname,@telnumber,@status,@department)", _connection); command.Parameters.AddWithValue("@name", personel.Name); command.Parameters.AddWithValue("@surname", personel.Surname); command.Parameters.AddWithValue("@telnumber", personel.TelNumber); command.Parameters.AddWithValue("@status", personel.ManagerName); command.Parameters.AddWithValue("@department", personel.Department_Id); command.ExecuteNonQuery(); command.Dispose(); _connection.Close(); }
public void UpdatePersonel(PersonelTable personel) { ConnectionControl(); SqlCommand command = new SqlCommand("Update PersonelTable set Name=@name,Surname=@surname,TelNumber=@telnumber,ManagerStatus=@managerStatus,Department_Id=@department_ıd where Personel_Id=@ıd", _connection); command.Parameters.AddWithValue("@name", personel.Name); command.Parameters.AddWithValue("@surname", personel.Surname); command.Parameters.AddWithValue("@telnumber", personel.TelNumber); command.Parameters.AddWithValue("@managerStatus", personel.ManagerName); command.Parameters.AddWithValue("@department_ıd", personel.Department_Id); command.Parameters.AddWithValue("@ıd", personel.Personel_Id); command.ExecuteNonQuery(); command.Dispose(); _connection.Close(); }