public void AddDepartment(DepartmentTable departmentTable)//departman ekleeme işlemi için yeniitablo oluştumayı denekalıtım almaya çalış
{
ConnectionControl();
SqlCommand command = new SqlCommand("Insert into DepartmentTable (Department) values (@department)", _connection);
command.Parameters.AddWithValue("@department", departmentTable.Department);
command.ExecuteNonQuery();
_connection.Close();
}
public void UpdateDepartment(DepartmentTable departmentTable)
{
ConnectionControl();
SqlCommand command = new SqlCommand("Update DepartmentTable set Department=@newDepartment where Department_Id=@department_ıd", _connection);
command.Parameters.AddWithValue("@newDepartment", AdminUI._txtYeniDepartman);
command.Parameters.AddWithValue("@department_ıd", departmentTable.Department_Id);
//command.Parameters.AddWithValue("@department", AdminUI.);
// command.Parameters.AddWithValue("@id", AdminDal._id.ToString());
command.ExecuteNonQuery();
_connection.Close();
}
private void btnDepartmentChooser_Click(object sender, EventArgs e)
{
///////////////////departman işlemleri
_txtYeniDepartman = txtDepartmentChooser.Text;
_txtEskiDepartman = txtPreview.Text;
if (cmbDepartmanEventsChoose.Text == "")
{
cmbDepartmanEventsChoose.SelectedIndex = 0;
}
else
{
if (txtDepartmentChooser.Text != null && _DepartmentIslemTuru == 0)//güncelleme
{
DepartmentTable departmentTable = new DepartmentTable
{
Department_Id = (int)dgwDepartmentSettings.CurrentRow.Cells["Department_Id"].Value,
};
departmentDal.UpdateDepartment(departmentTable);
}
else if (txtDepartmentChooser.Text != null && _DepartmentIslemTuru == 1)//ekleme
{
DepartmentTable departmentTable = new DepartmentTable
{
Department = txtDepartmentChooser.Text,
};
departmentDal.AddDepartment(departmentTable);
}
else if (txtDepartmentChooser.Text != null && _DepartmentIslemTuru == 2)//Silme
{
int deleteDepartment = Convert.ToInt32(dgwDepartmentSettings.CurrentRow.Cells["Department_Id"].Value);
departmentDal.DeleteDeparment(deleteDepartment);
if (Convert.ToInt32(DepartmentDal.sayım) > 0)
{
MessageBox.Show(DepartmentDal.mesaj.ToString());
}
else
{
MessageBox.Show("Departman Silindi");
}
}
else
{
cmbDepartmanEventsChoose.SelectedIndex = 0;
}
txtPreview.Clear();
txtDepartmentChooser.Clear();
DepartmentLoader();
}
}
