public DodajKarnet(ZarzadzajKarnetami Zarzadzaj, bool IsEdit)
{
InitializeComponent();
this.Zarzadzaj = Zarzadzaj;
this.isEdit = IsEdit;
if (isEdit)
{
this.Title = "Edytuj";
btnOK.Content = "Aktualizuj";
DataRowView row = Zarzadzaj.lstKarnety.SelectedItem as DataRowView;
Karnet.DataContext = row;
editedRowId = (int)row["ID_Karnetu"];
}
else
{
this.Title = "Dodaj";
btnOK.Content = "Dodaj";
}
}
private void ZarzadzajKarnetami(object sender, RoutedEventArgs e)
{
ZarzadzajKarnetami dodaj1 = new ZarzadzajKarnetami(this.conn);
dodaj1.Show();
}
private void btnPrzypisz_Click(object sender, RoutedEventArgs e)
{
try
{
if (lstKlienci.SelectedItems.Count != 0)
{
DataRowView row = this.lstKlienci.SelectedItem as DataRowView;
this.editedRowId = (int)row["ID_Klienta"];
if (this.id_karnetu == 0)
{
ZarzadzajKarnetami wnd = new ZarzadzajKarnetami(this.editedRowId, this.conn);
wnd.Show();
this.Close();
}
else
{
//Przypisanie Karnetu
this.conn.Close();
this.conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = this.conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PrzypiszKarnetKlient";
SqlParameter ID_Karnetu = new SqlParameter();
ID_Karnetu.ParameterName = "@ID_Karnetu";
ID_Karnetu.SqlDbType = SqlDbType.Int;
ID_Karnetu.Direction = ParameterDirection.Input;
ID_Karnetu.Value = this.id_karnetu;
cmd.Parameters.Add(ID_Karnetu);
SqlParameter ID_Klienta = new SqlParameter();
ID_Klienta.ParameterName = "@ID_Klienta";
ID_Klienta.SqlDbType = SqlDbType.Int;
ID_Klienta.Direction = ParameterDirection.Input;
ID_Klienta.Value = this.editedRowId;
cmd.Parameters.Add(ID_Klienta);
SqlParameter parm = new SqlParameter("@result", SqlDbType.Int);
parm.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parm);
cmd.ExecuteNonQuery();
int retval = (int)parm.Value;
if (retval == 0)
{
MessageBox.Show("Osoba ma już taki karnet!", "Uwaga!", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
MessageBox.Show("Pomyślnie przypisano!", "Uwaga!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
else
{
MessageBox.Show("Aby przypisać karnet do klienta nalezy wybrać klienta ", "UWAGA!", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "UWAGA!", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
#endregion
}
