private void StokDuzenle_Load(object sender, EventArgs e)
{
cbMiktarBirim.DataSource = Enum.GetNames(typeof(MalzemeMiktarBirim));
cbKdv.DisplayMember = "Description";
cbKdv.ValueMember = "Value";
cbKdv.DataSource = Enum.GetValues(typeof(KDV))
.Cast <Enum>()
.Select(value => new
{
(Attribute.GetCustomAttribute(value.GetType().GetField(value.ToString()), typeof(DescriptionAttribute)) as DescriptionAttribute).Description,
value
})
.OrderBy(item => item.value)
.ToList();
cellsOfSelectedItem = stokListesi.getSelectedItem().Item2;
txtStokKod.Text = cellsOfSelectedItem[1].Value.ToString();
txtStokAdi.Text = cellsOfSelectedItem[2].Value.ToString();
cbMiktarBirim.SelectedIndex = cbMiktarBirim.FindString(cellsOfSelectedItem[3].Value.ToString());
txtBirimFiyat.Text = cellsOfSelectedItem[5].Value.ToString();
cbKdv.SelectedIndex = (cellsOfSelectedItem[6].Value.ToString() == GetDesc.GetEnumDescription(KDV.Dahil))? 1 : 0;
dtpGelisTarih.Value = DateTime.Parse(cellsOfSelectedItem[7].Value.ToString());
txtAmbalajBilgi.Text = cellsOfSelectedItem[8].Value.ToString();
txtMalzSerisi.Text = cellsOfSelectedItem[9].Value.ToString();
txtMalzCinsi.Text = cellsOfSelectedItem[10].Value.ToString();
txtMalzOlcu.Text = cellsOfSelectedItem[11].Value.ToString();
txtEtiketBilgi.Text = cellsOfSelectedItem[12].Value.ToString();
txtAciklama.Text = cellsOfSelectedItem[13].Value.ToString();
}
private void StokDepoListesi_Load(object sender, EventArgs e)
{
cellsOfSelectedItem = stokListesi.getSelectedItem().Item2;
txtStokKod.Text = cellsOfSelectedItem[1].Value.ToString();
txtStokAdi.Text = cellsOfSelectedItem[2].Value.ToString();
txtStokBirim.Text = cellsOfSelectedItem[3].Value.ToString();
Styler.gridViewCommonStyle(stokDepoListGridView);
listStokDepo();
}
private void btnStokListesi_Click(object sender, EventArgs e)
{
try
{
StokListesi stokList = new StokListesi(1);
stokList.ShowDialog();
selectedItem = stokList.getSelectedItem();
if (selectedItem != null)
{
btnListeyeEkle.Text = "LİSTEYE EKLE";
txtStokKodu.Text = selectedItem.Item2["STOK_KODU"].Value.ToString();
txtStokAdi.Text = selectedItem.Item2["STOK_ADI"].Value.ToString();
txtStokBirim.Text = selectedItem.Item2["MIKTAR_BIRIM"].Value.ToString();
txtBirimFiyat.Text = selectedItem.Item2["BIRIM_FIYAT"].Value.ToString();
sqlCmd = new SqlCommand("SELECT STD.STOK_DEPO_INCKEY, D.DEPO_ADI FROM STOK_DEPO STD JOIN DEPO D ON D.DEPO_INCKEY=STD.DEPO_INCKEY WHERE STD.STOK_INCKEY=@stok_inckey", Program.connection);
sqlCmd.Parameters.AddWithValue("@stok_inckey", selectedItem.Item2["STOK_INCKEY"].Value.ToString());
SqlDataReader dataReader = sqlCmd.ExecuteReader();
cbStokDepo.Items.Clear();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
cbStokDepo.Items.Add(dataReader["STOK_DEPO_INCKEY"].ToString() + " - " + dataReader["DEPO_ADI"].ToString());
}
}
cbStokDepo.SelectedIndex = 0;
txtStokMiktar.Text = "0";
stokGuncelle = new Tuple <bool, int>(false, -1);
}
}catch (Exception ex)
{
Notification.messageBoxError(ex.Message);
}
}
