private void SiparisDetayGuncelle_Load(object sender, EventArgs e)
{
guncellenen = orderProcessing.siparisDetayGetir(detayId);
txtSiparisGuncelleUrunID.Text = guncellenen.UrunId;
txtSiparisUrunAdiGuncelle.Text = guncellenen.urunAdı1;
txtSiparisUrunAdediGuncelle.Text = guncellenen.UrunAdet;
txtToplamFiyatGuncelle.Text = guncellenen.DetayFiyat.ToString();
}
public void SipariseUrunEkle(List <UrunModel> urunlist, List <SiparisDetayModel> siparisListesi, String urunAdi, String seciliUrun, String numUrunAdeti, float urunFiyat)
{
SiparisDetayModel eklenecekUrun = new SiparisDetayModel();
eklenecekUrun.urunAdı1 = urunAdi;
eklenecekUrun.UrunId = seciliUrun;
eklenecekUrun.UrunAdet = numUrunAdeti;
eklenecekUrun.DetayFiyat = urunFiyat * Convert.ToInt32(numUrunAdeti);
siparisListesi.Add(eklenecekUrun);
}
public SiparisDetayModel siparisDetayGetir(String detayId)
{
SiparisDetayModel siparisDetay = new SiparisDetayModel();
sqlConnection.Connection().Open();
SqlCommand orderDetailId = new SqlCommand("select detayID,urunAd,urunAdet,detayFiyat from tblSiparisDetay INNER JOIN tblurunler ON tblSiparisDetay.urunID=tblurunler.urunID WHERE detayID=@p1", sqlConnection.Connection());
orderDetailId.Parameters.AddWithValue("@p1", detayId);
SqlDataReader data = orderDetailId.ExecuteReader();
while (data.Read())
{
siparisDetay.UrunId = data[0].ToString();
siparisDetay.urunAdı1 = data[1].ToString();
siparisDetay.UrunAdet = data[2].ToString();
siparisDetay.DetayFiyat = (float)Double.Parse(data[3].ToString());
}
sqlConnection.Connection().Close();
return(siparisDetay);
}
public void siparisDeteylariGetir(DataGridView dataGridView, String siparisId, List <SiparisDetayModel> list)
{
list.Clear();
sqlConnection.Connection().Open();
SqlCommand siparisDetayGetir = new SqlCommand("select detayID,urunAd,urunAdet,detayFiyat from tblSiparisDetay INNER JOIN tblurunler on tblSiparisDetay.urunID=tblurunler.urunID WHERE siparisID=@p1", sqlConnection.Connection());
siparisDetayGetir.Parameters.AddWithValue("@p1", siparisId);
SqlDataReader data = siparisDetayGetir.ExecuteReader();
while (data.Read())
{
SiparisDetayModel siparisDetay = new SiparisDetayModel();
siparisDetay.UrunId = data[0].ToString();
siparisDetay.urunAdı1 = data[1].ToString();
siparisDetay.UrunAdet = data[2].ToString();
siparisDetay.DetayFiyat = (float)Double.Parse(data[3].ToString());
list.Add(siparisDetay);
}
dataGridView.DataSource = list;
sqlConnection.Connection().Close();
}
