private void btnSatinAl_Click(object sender, EventArgs e)
{
Random random = new Random();
int siparisNo = random.Next(1, 1000);
string query = "INSERT INTO Siparisler(MusteriId,SiparisNo,SiparisTarihi,Adet,Fiyat) VALUES (@MusteriId,@SiparisNo,@SiparisTarihi,@Adet,@Fiyat)";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@MusteriId", 1);
command.Parameters.AddWithValue("@SiparisNo", Convert.ToString(siparisNo));
command.Parameters.AddWithValue("@SiparisTarihi", 2021 - 03 - 12);
command.Parameters.AddWithValue("@Adet", Convert.ToInt32(txtAdet.Text));
command.Parameters.AddWithValue("@Fiyat", Convert.ToDecimal(txtBirimFiyati.Text));
connection.Open();
command.ExecuteNonQuery();
connection.Close();
frmSiparisler frmSiparisler = new frmSiparisler();
frmSiparisler.ShowDialog();
}
private void btnSiparisler_Click(object sender, EventArgs e)
{
frmSiparisler frmSiparisler = new frmSiparisler();
frmSiparisler.ShowDialog();
}
