private void Sil_Click(object sender, RoutedEventArgs e)
{
if (id == 0)
{
MessageBox.Show("Tabloda bir satır seçin !");
}
else
{
SqlConnection connn = new SqlConnection("Data Source=pc-name;Initial Catalog=SampleDatabase;Integrated Security=True");
connn.Open();
SqlCommand cmd = new SqlCommand("Delete from Kampanyalar where ID=" + id, connn);
cmd.ExecuteNonQuery();
connn.Close();
int max = Convert.ToInt32(id);
ek_sil(max);
MessageBox.Show("Kayit Silindi !");
string CmdString = string.Empty;
goster_control = true;
Kampanya_Goster.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
Temizle.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
id = 0;
}
}
private void Guncelle_click(object sender, RoutedEventArgs e)
{
if (id == 0)
{
MessageBox.Show("Tabladon Bir satir Secin");
}
else
{
int i = 0;
int z = 0;
for (i = 0; i < 7; i++)
{
if (tb_check[i])
{
z++;
}
}
if (z <= 6)
{
MessageBox.Show("Eksik Veya Yanlış Doldurdugunuz Bilgiler Var(Hepsinin Yanında Tik işareti olduğundan Emin olun) !");
}
else
{
string CmdString = string.Empty;
SqlConnection connnn = new SqlConnection("Data Source=pc-name;Initial Catalog=SampleDatabase;Integrated Security=True");
connnn.Open();
CmdString = "Update Kampanyalar Set KampanyaAdı=@KampanyaAdı,TutarMin=@TutarMin,TutarMax=@TutarMax,TarihBaslangic=@TarihBaslangic,TarihBitis=@TarihBitis,TaksitSayisi=@TaksitSayisi,MCC=@MCC,Ucret=@Ucret,Faiz=@Faiz where ID=" + id;
SqlCommand cmd = new SqlCommand(CmdString, connnn);
cmd.Parameters.AddWithValue("KampanyaAdı", KampanyaAdi_textbox.Text);
cmd.Parameters.AddWithValue("TutarMin", TutarAraligi_textbox1.Text);
cmd.Parameters.AddWithValue("TutarMax", TutarAraligi_textbox2.Text);
cmd.Parameters.AddWithValue("TarihBaslangic", Tarih_Baslangic.SelectedDate);
cmd.Parameters.AddWithValue("TarihBitis", Tarih_Bitis.SelectedDate);
cmd.Parameters.AddWithValue("TaksitSayisi", Taksit_Sayisi_Textbox.Text);
cmd.Parameters.AddWithValue("MCC", Mcc_comboBox.SelectedItem.ToString());
cmd.Parameters.AddWithValue("Ucret", Ucret_TextBox.Text);
cmd.Parameters.AddWithValue("Faiz", Faiz_TextBox.Text);
cmd.ExecuteNonQuery();
int max = Convert.ToInt32(id);
ek_guncelle(max);
connnn.Close();
MessageBox.Show("Kayit Guncellendi !");
Temizle.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
goster_control = true;
Kampanya_Goster.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
id = 0;
}
}
}
public Window1()
{
InitializeComponent();
Mcc_comboBox.Items.Add("Bakkal");
Mcc_comboBox.Items.Add("Kırtasiye");
Mcc_comboBox.Items.Add("Giyim");
Mcc_comboBox.Items.Add("Otomobil");
Mcc_comboBox.Items.Add("Züccaciye");
Mcc_comboBox.Background = Brushes.LightSteelBlue;
Taksit_Sayisi_Textbox.Background = Brushes.LightSteelBlue;
Tarih_Baslangic.Background = Brushes.LightSteelBlue;
Faiz_TextBox.Background = Brushes.LightSteelBlue;
Ucret_TextBox.Background = Brushes.LightSteelBlue;
KampanyaAdi_textbox.Background = Brushes.LightSteelBlue;
TutarAraligi_textbox2.Background = Brushes.LightSteelBlue;
TutarAraligi_textbox1.Background = Brushes.LightSteelBlue;
kapat();
Kampanya_Goster.RaiseEvent(new RoutedEventArgs(Button.ClickEvent));
}
