private void StokListeyiYukle()
{
//if (txtArama.Text == "") // bu olmayınca ufak bi sıkıntısı vardı geçti
//{
// StokListe.Arama = "";
//}
try
{
//if (StokListe.dtStok.Rows.Count != 0)
{
gcUrunListesi.DataSource = StokListe.StokAra(SqlConnections.GetAresUTSqlConnection());
}
if (gvUrunListesi.SelectedRowsCount == 0)
{
pictureEdit1.EditValue = null;
lblFiyati.Text = "";
lblRafyeri.Text = "";
lblStokAdi.Text = "";
return;
}
AlanlariYenidenBinle();
gvResimYukle();
}
catch (Exception)
{
throw;
}
}
private void AresUTSil() // önceki vt yi siliyor
{
SqlTransaction Tr = SqlConnections.GetAresUTSqlConnection().BeginTransaction();
SqlCommand cmd = new SqlCommand("USE AresUrunTanitim delete from Stok delete from Resim", SqlConnections.GetAresUTSqlConnection(), Tr);
cmd.ExecuteNonQuery();
Tr.Commit();
}
private void frmUrunListesi_Load(object sender, EventArgs e)
{
BaglantiAres = SqlConnections.GetAresSqlConnection();
BaglantiAresUT = SqlConnections.GetAresUTSqlConnection();
if (BaglantiAres.State == ConnectionState.Closed)
{
BaglantiAres.Open();
}
if (BaglantiAresUT.State == ConnectionState.Closed)
{
BaglantiAresUT.Open();
}
GridDoldur();
}
private void frmAnaFormParametre_Load(object sender, EventArgs e)
{
XmlOku();
BaglantiAres = SqlConnections.GetAresSqlConnection();
BaglantiAresUT = SqlConnections.GetAresUTSqlConnection();
if (BaglantiAres.State == ConnectionState.Closed)
{
BaglantiAres.Open();
}
if (BaglantiAresUT.State == ConnectionState.Closed)
{
BaglantiAresUT.Open();
}
FiyatTanimlariniGetir();
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
BaglantiAres = SqlConnections.GetAresSqlConnection();
BaglantiAresUT = SqlConnections.GetAresUTSqlConnection();
if (BaglantiAres.State == ConnectionState.Closed)
{
BaglantiAres.Open();
}
if (BaglantiAresUT.State == ConnectionState.Closed)
{
BaglantiAresUT.Open();
}
StokListe = new csStok(SqlConnections.GetAresUTSqlConnection());
txtArama_TextChanged(null, null);
gvResimYukle();
txtArama.DataBindings.Add("EditValue", StokListe, "Arama", true, DataSourceUpdateMode.OnPropertyChanged);
AlanlariYenidenBinle();
timer1.Start();
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
}
private void gvResimYukle()
{
if (gvUrunListesi.SelectedRowsCount > 0)
{
da = new SqlDataAdapter("select * from Resim where StokID = @StokID", SqlConnections.GetAresUTSqlConnection());
da.SelectCommand.Parameters.Add("@StokID", SqlDbType.Int).Value = gvUrunListesi.GetFocusedRowCellValue("StokID");
dtResim = new DataTable();
da.Fill(dtResim);
gcResimler.DataSource = dtResim;
if (dtResim.Rows.Count > 0)
{
pictureEdit1.DataBindings.Clear();
pictureEdit1.DataBindings.Add("EditValue", dtResim, "Resim", true, DataSourceUpdateMode.OnPropertyChanged);
}
else
{
pictureEdit1.DataBindings.Clear();
pictureEdit1.EditValue = null;
}
}
}