private void textChanged(object sender, TextChangedEventArgs e)
{
string searching = searchBox.Text.ToUpper();
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var bands = db.GetCollection <Band>("Bands");
var queryBands = bands.FindAll();
if (searching != null)
{
List <Band> findBands = new List <Band>();
foreach (Band theBand in queryBands)
{
if (theBand.name.ToUpper().Contains(searching))
{
findBands.Add(theBand);
}
}
var bandList = findBands.OrderBy(x => x.name);
bandListView.ItemsSource = bandList;
}
else
{
var allBandList = queryBands.OrderBy(x => x.name).ToList();
bandListView.ItemsSource = allBandList;
}
}
}
private void deleteContactButtonClick(object sender, RoutedEventArgs e)
{
BandContact contactToDelete = (BandContact)contactListView.SelectedItem;
if (contactToDelete != null)
{
try
{
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var contacts = db.GetCollection <BandContact>("BandContacts");
MessageBoxResult myResult;
myResult = MessageBox.Show("Opravdu chcete smazat kontakt " + contactToDelete.fName + " " +
contactToDelete.lName + " ?", "Delete Confirmation", MessageBoxButton.OKCancel);
if (myResult == MessageBoxResult.OK)
{
contacts.Delete(contactToDelete._id);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Není vybrán kontakt!");
}
this.NavigationService.Navigate(new BandDetail(bandDetail));
}
/// <summary>
/// Export data tables to PDF.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void exportPDF(object sender, RoutedEventArgs e)
{
try
{
SaveFileDialog dialog = new SaveFileDialog();
dialog.Filter = "PDF(*.pdf)|*.pdf";
dialog.ShowDialog();
string path = dialog.FileName;
List <Band> bands;
ArrayList bandsToPdf = new ArrayList();
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var dbBands = db.GetCollection <Band>("Bands");
bands = dbBands.FindAll().ToList();
foreach (Band bandToProcess in bands)
{
bandsToPdf.Add(bandToProcess);
}
PdfExport.processBandsToPdf(bandsToPdf, path, 12);
}
}
catch (Exception ex)
{
this.NavigationService.Navigate(new BandsAdmin());
}
}
public void saveBandToDb(Band band)
{
try
{
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var bands = db.GetCollection <Band>("Bands");
bands.Upsert(band);
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Naplneni bandlistu datama z DB
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bandListInitialize(object sender, EventArgs e)
{
try
{
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var bands = db.GetCollection <Band>("Bands");
var queryBands = bands.FindAll();
var bandList = queryBands.OrderBy(x => x.name).ToList();
bandListView.ItemsSource = bandList;
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
}
public AddContact(int bandId)
{
contactBandId = bandId;
try
{
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var bands = db.GetCollection <Band>("Bands");
band = bands.FindById(contactBandId);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
InitializeComponent();
}
private void ListView_Loaded(object sender, RoutedEventArgs e)
{
try
{
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var bands = db.GetCollection <Band>("Bands");
var contacts = db.GetCollection <BandContact>("BandContacts");
var queryContacts = contacts.Find(x => x.bandId == bandDetail._id);
contactListView.ItemsSource = queryContacts;
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Mazani kapely.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void deleteBandButton_Click(object sender, RoutedEventArgs e)
{
object selectedRow = bandListView.SelectedItem;
Band band = (Band)selectedRow;
if (band != null)
{
try
{
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
MessageBoxResult myResult;
myResult = MessageBox.Show("Opravdu chcete smazat kapelu " + band.name + " ?", "Delete Confirmation", MessageBoxButton.OKCancel);
if (myResult == MessageBoxResult.OK)
{
var bands = db.GetCollection <Band>("Bands");
var contacts = db.GetCollection <BandContact>("BandContacts");
List <BandContact> contactsQuery = contacts.FindAll().ToList();
List <BandContact> contactsToDelete = contactsQuery.FindAll(delegate(BandContact bk)
{
return(bk.bandId == band._id);
});
foreach (BandContact contact in contactsToDelete)
{
contacts.Delete(contact._id);
}
bands.Delete(band._id);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Není vybrána kapela!");
}
this.NavigationService.Navigate(new BandsAdmin());
}
public Boolean checkIfBandExists(Band band)
{
Boolean bandExists = false;
try
{
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var bands = db.GetCollection <Band>("Bands");
var queryBands = bands.FindAll();
if (bands.Find(lookingBand => lookingBand.name == band.name).Any())
{
bandExists = true;
}
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
return(bandExists);
}
public static ArrayList findBandContacts(Band band)
{
ArrayList contacts = new ArrayList();
using (var db = new LiteDatabase(LiteDbConnection.getDbName()))
{
var dbContacts = db.GetCollection <BandContact>("BandContacts");
List <BandContact> contactsToReturn;
ArrayList bandContacts = new ArrayList();
List <BandContact> queryContacts = dbContacts.FindAll().ToList();
contactsToReturn = queryContacts.FindAll(delegate(BandContact bk)
{
return(bk.bandId == band._id);
});
foreach (BandContact contact in contactsToReturn)
{
contacts.Add(contact);
}
}
return(contacts);
}