public void updateItemOnList() { DataGridView dataGridView = stokListesi.getDataGrid(); int rowIndex = stokListesi.getSelectedItem().Item1; dataGridView[1, rowIndex].Value = txtStokKod.Text; dataGridView[2, rowIndex].Value = txtStokAdi.Text; dataGridView[3, rowIndex].Value = cbMiktarBirim.SelectedValue; dataGridView[5, rowIndex].Value = txtBirimFiyat.Text; dataGridView[6, rowIndex].Value = cbKdv.SelectedValue; dataGridView[7, rowIndex].Value = dtpGelisTarih.Value; dataGridView[8, rowIndex].Value = txtAmbalajBilgi.Text; dataGridView[9, rowIndex].Value = txtMalzSerisi.Text; dataGridView[10, rowIndex].Value = txtMalzCinsi.Text; dataGridView[11, rowIndex].Value = txtMalzOlcu.Text; dataGridView[12, rowIndex].Value = txtEtiketBilgi.Text; dataGridView[13, rowIndex].Value = txtAciklama.Text; dataGridView[16, rowIndex].Value = Program.kullanici.Item2; dataGridView[17, rowIndex].Value = DateTime.Now.ToString("dd.MM.yyyy HH:mm"); }
private void silBttn_Click(object sender, EventArgs e) { if (stokDepoListGridView.SelectedRows.Count == 1) { try { DialogResult dialogResult = MessageBox.Show("SİLMEK İSTEDİĞİNİZDEN EMİN MİSİNİZ ?", "UYARI", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { int deletedStokDepoInckey = Int32.Parse(stokDepoListGridView.SelectedRows[0].Cells[0].Value.ToString()); sqlCmd = new SqlCommand("DELETE FROM STOK_DEPO WHERE STOK_DEPO_INCKEY = @stok_depo_inckey", Program.connection); sqlCmd.Parameters.Add("@stok_depo_inckey", SqlDbType.Int).Value = deletedStokDepoInckey; int affectedRows = sqlCmd.ExecuteNonQuery(); if (affectedRows > 0) { sqlCmd = new SqlCommand("SELECT COUNT(STOK_DEPO_INCKEY) FROM STOK_DEPO WHERE STOK_INCKEY = @stok_inckey", Program.connection); sqlCmd.Parameters.Add("@stok_inckey", SqlDbType.Int).Value = Convert.ToInt32(cellsOfSelectedItem[0].Value.ToString()); if (Convert.ToInt32(sqlCmd.ExecuteScalar()) == 0) { sqlCmd = new SqlCommand("DELETE FROM STOK WHERE STOK_INCKEY = @stok_inckey", Program.connection); sqlCmd.Parameters.Add("@stok_inckey", SqlDbType.Int).Value = Convert.ToInt32(cellsOfSelectedItem[0].Value.ToString()); sqlCmd.ExecuteNonQuery(); stokListesi.getDataGrid().Rows.RemoveAt(stokListesi.getSelectedItem().Item1); } stokDepoListGridView.Rows.RemoveAt(rowIndex); Notification.messageBox("STOK DEPO KAYDI BAŞARIYLA SİLİNDİ."); } else { Notification.messageBoxError("Bir sorun oluştu, stok depo silinemedi."); } } } catch (Exception ex) { Notification.messageBoxError(ex.Message); } } else { Notification.messageBoxError("BİR SORUN OLUŞTU, KAYIT SEÇİLEMEDİ !"); } }