private void BayiGuncelle_Load(object sender, EventArgs e)
{
bayi = dealerOperations.BayiGetir(bayiID.ToString());
txtBayiIDGuncelle.Text = bayi.BayiId;
txtBayiAdGuncelle.Text = bayi.BayiAd;
txtBayiAdresGuncelle.Text = bayi.BayiAdres;
txtBayiEpostaGuncelle.Text = bayi.BayiEposta;
txtBayiTelGuncelle.Text = bayi.BayiTel;
}
public void cmbBxSiparisiVerenBayiItemsAdd(ComboBox cmbBxSiparisiVerenBayi, List <Bayi> bayiList)
{
sqlConnection.Connection().Open();
SqlCommand urungetir = new SqlCommand("select * from tblBayiler", sqlConnection.Connection());
SqlDataReader data = urungetir.ExecuteReader();
while (data.Read())
{
Bayi bayi = new Bayi();
bayi.BayiId = data[0].ToString();
bayi.BayiAd = data[1].ToString();
bayi.BayiEposta = data[2].ToString();
bayi.BayiAdres = data[3].ToString();
bayi.BayiTel = data[4].ToString();
bayiList.Add(bayi);
cmbBxSiparisiVerenBayi.Items.Add(bayi.BayiAd);
}
sqlConnection.Connection().Close();
}
public void bayileriGetir(DataGridView datagrid)
{
List <Bayi> bayilerList = new List <Bayi>();
sqlConnection.Connection().Open();
SqlCommand urungetir = new SqlCommand("select * from tblBayiler", sqlConnection.Connection());
SqlDataReader data = urungetir.ExecuteReader();
while (data.Read())
{
Bayi bayi = new Bayi();
bayi.BayiId = data[0].ToString();
bayi.BayiAd = data[1].ToString();
bayi.BayiEposta = data[2].ToString();
bayi.BayiAdres = data[3].ToString();
bayi.BayiTel = data[4].ToString();
bayilerList.Add(bayi);
}
sqlConnection.Connection().Close();
datagrid.DataSource = bayilerList;
}
public Bayi BayiGetir(String Id)
{
Bayi seciliBayi = new Bayi();
sqlConnection.Connection().Open();
SqlCommand seciliBayigetir = new SqlCommand("select * from tblBayiler where BayiID = @p1", sqlConnection.Connection());
seciliBayigetir.Parameters.AddWithValue("@p1", Id);
SqlDataReader data = seciliBayigetir.ExecuteReader();
while (data.Read())
{
seciliBayi.BayiId = data[0].ToString();
seciliBayi.BayiAd = data[1].ToString();
seciliBayi.BayiEposta = data[2].ToString();
seciliBayi.BayiAdres = data[3].ToString();
seciliBayi.BayiTel = data[4].ToString();
}
sqlConnection.Connection().Close();
return(seciliBayi);
}
