private int Them_sinh_vien(phongban phongban)
        {
            try
            {
                using (SqlConnection connection =
                           new SqlConnection(@"Server=DESKTOP-2SVCGMM\SQLEXPRESS;Database=quanlicanbo;
        Integrated Security=SSPI"))
                    using (SqlCommand command = new SqlCommand("INSERT INTO phongban(phongbanID,tenphongban )" + "VALUES(@phongbanID,@tenphongban );", connection))
                    {
                        command.Parameters.Add("phongbanID", SqlDbType.Char, 10).Value =
                            phongban.phongbanID;
                        object dbtenphongban = phongban.tenphongban;
                        if (dbtenphongban == null)
                        {
                            dbtenphongban = DBNull.Value;
                        }

                        command.Parameters.Add("tenphongban", SqlDbType.NVarChar, 30).Value = dbtenphongban;



                        connection.Open();
                        return(command.ExecuteNonQuery());
                    }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Loi khi mo  ket noi:" + ex.Message);
                return(-1);
            }
        }
 private void btnDulieu_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         List <phongban> DanhSachPhongBan = new List <phongban>();
         using (SqlConnection connection =
                    new SqlConnection(@"Server=DESKTOP-2SVCGMM\SQLEXPRESS;Database=quanlicanbo;
                          Integrated Security=SSPI"))
             using (SqlCommand command =
                        new SqlCommand("SELECT phongbanID, tenphongban from phongban; ", connection))
             {
                 connection.Open();
                 using (SqlDataReader reader = command.ExecuteReader())
                 {
                     while (reader.Read())
                     {
                         var pb = new phongban();
                         pb.phongbanID  = reader.GetString(0);
                         pb.tenphongban = reader.GetString(1);
                         DanhSachPhongBan.Add(pb);
                     }
                 }
             }
         MessageBox.Show("Mo va dong co so du lieu thanh cong.");
         Dulieu.ItemsSource = DanhSachPhongBan;
     }
     catch (Exception ex)
     {
         MessageBox.Show("Loi khi mo ket noi: " + ex.Message);
     }
 }
        private void btnXoa_Click(object sender, RoutedEventArgs e)
        {
            phongban pb = new phongban();

            pb.phongbanID = tbxPhongBAn.Text;
            if (Xoa_sinh_vien(pb) > 0)
            {
                MessageBox.Show("Du lieu duoc xoa thanh cong!");
            }
        }
        private void tbnThem_Click(object sender, RoutedEventArgs e)
        {
            phongban pb = new phongban();

            pb.phongbanID  = tbxPhongBAn.Text;
            pb.tenphongban = tbxTenPhong.Text;
            if (Them_sinh_vien(pb) > 0)
            {
                MessageBox.Show("Du lieu duoc them thanh cong!");
            }
        }
        private void btnCapNhat_Click(object sender, RoutedEventArgs e)
        {
            phongban pb = new phongban();

            pb.phongbanID  = tbxPhongBAn.Text;
            pb.tenphongban = tbxTenPhong.Text;

            if (Cap_nhat_sinh_vien(pb) > 0)
            {
                MessageBox.Show("Du lieu duoc cap nhat thanh cong!");
            }
        }
 private int Cap_nhat_sinh_vien(phongban phongban)
 {
     try
     {
         using (SqlConnection connection =
                    new SqlConnection(@"Server=DESKTOP-2SVCGMM\SQLEXPRESS;Database=quanlicanbo; Integrated Security=SSPI"))
             using (SqlCommand command = new SqlCommand("UPDATE phongban " + "SET tenphongban = @tenphongban " + "WHERE phongbanID = @phongbanID", connection))
             {
                 command.Parameters.Add("phongbanID", SqlDbType.Char, 10).Value = phongban.phongbanID; command.Parameters.Add("tenphongban", SqlDbType.NVarChar, 30).Value = phongban.tenphongban;
                 connection.Open();
                 return(command.ExecuteNonQuery());
             }
     }
     catch (Exception ex)
     {
         MessageBox.Show("Loi khi mo  ket noi:" + ex.Message);
         return(-1);
     }
 }