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(); } }