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İ !");
}
}
