private void Add_Button_Click(object sender, RoutedEventArgs e) { MainWindow main = Application.Current.Windows.OfType <MainWindow>().First(); inbook _inbook = new inbook() { bibtexkey = bibtexKey_Txt.Text, title = title_Txt.Text, year = year_Txt.Text != "" ? Convert.ToInt32(year_Txt.Text) : null as int?, chapter = chapter_Txt.Text != "" ? Convert.ToInt32(chapter_Txt.Text) : null as int?, month = month_Txt.Text != "" ? Convert.ToInt32(month_Txt.Text) : null as int?, volume = volume_Txt.Text != "" ? Convert.ToInt32(volume_Txt.Text) : null as int?, author = author_Txt.Text, address = address_Txt.Text, edition = edition_Txt.Text != "" ? Convert.ToInt32(edition_Txt.Text) : null as int?, note = note_Txt.Text, publisher = publisher_Txt.Text, series = series_Txt.Text != "" ? Convert.ToInt32(series_Txt.Text) : null as int?, type = type_Txt.Text, entrytype = GetEntryType.GetValueByEnum(GetEntryType.EntryType.InBook) }; bool result = AllFieldEmpty(); if (!result) { _inBookService.Add(_inbook); SetFieldClear(); UIElement parent = App.Current.MainWindow; parent.IsEnabled = true; main.DataGridMain.ItemsSource = GetEntryType.GetAllByTypes(); this.Close(); } else { if (MessageBox.Show("Are you Sure to create a empty .bib", "Question", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.No) { //do no stuff return; } else { _inBookService.Add(_inbook); SetFieldClear(); main.DataGridMain.ItemsSource = GetEntryType.GetAllByTypes(); UIElement parent = App.Current.MainWindow; parent.IsEnabled = true; this.Close(); //do yes stuff } } }
public void Add(inbook entity) { _iConnection.ExecuteScalar <inbook>( "INSERT INTO inbook (chapter, author, month, note, title, volume, year, address, type," + " bibtexkey, entrytype ,publisher, series, edition) VALUES( @chapter, @author, @month, @note, @title," + " @volume, @year, @address, @type, @bibtexkey, @entrytype, @publisher, @series, @edition)", new { entity.entrytype, entity.bibtexkey, entity.author, entity.address, entity.chapter, entity.publisher, entity.series, entity.type, entity.title, entity.month, entity.note, entity.volume, entity.edition, entity.year }); }
public void Update(inbook entity) { _iConnection.ExecuteScalar <inbook>( "UPDATE inbook SET author=@author, entrytype=@entrytype, bibtexkey=@bibtexkey, " + " month=@month, note=@note, chapter=@chapter, publisher=@publisher, series=@series, type=@type," + "title=@title, address=@address, edition=@edition, volume=@volume, year=@year where ID = @ID", new { entity.entrytype, entity.bibtexkey, entity.author, entity.address, entity.chapter, entity.publisher, entity.series, entity.type, entity.title, entity.month, entity.note, entity.volume, entity.edition, entity.year, entity.ID }); }
public InBookView() { _inBookService = InstanceFactory.GetInstance <DapperInbookDal>(); InitializeComponent(); DataContext = new inbook(); }