/// <summary>
/// Computes and returns which radicals can still be used in a kanji filter in complement to the
/// given set of filters, and still return kanji results.
/// </summary>
public IEnumerable <RadicalEntity> GetAvailableRadicals(RadicalGroup[] radicals, string textFilter,
string meaningFilter, string anyReadingFilter, string onYomiFilter, string kunYomiFilter,
string nanoriFilter, int jlptLevel, int wkLevel)
{
// Compute the filters.
List <DaoParameter> parameters = new List <DaoParameter>();
string sqlFilter = KanjiDao.BuildKanjiFilterClauses(parameters, radicals, textFilter,
meaningFilter, anyReadingFilter, onYomiFilter, kunYomiFilter, nanoriFilter,
jlptLevel, wkLevel);
DaoConnection connection = null;
try
{
connection = DaoConnection.Open(DaoConnectionEnum.KanjiDatabase);
IEnumerable <NameValueCollection> results = connection.Query(
string.Format(
"SELECT DISTINCT ckr.{0} Id " + "FROM {1} k JOIN {2} ckr " + "ON (ckr.{3}=k.{4}) {5}",
SqlHelper.Field_Kanji_Radical_RadicalId,
SqlHelper.Table_Kanji,
SqlHelper.Table_Kanji_Radical,
SqlHelper.Field_Kanji_Radical_KanjiId,
SqlHelper.Field_Kanji_Id, sqlFilter),
parameters.ToArray());
RadicalBuilder radicalBuilder = new RadicalBuilder();
foreach (NameValueCollection nvcRadical in results)
{
RadicalEntity radical = radicalBuilder.BuildEntity(nvcRadical, null);
yield return(radical);
}
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
}
/// <summary>
/// Includes the kanji of the given vocab in the entity.
/// </summary>
private void IncludeKanji(DaoConnection connection, DaoConnection srsConnection,
VocabEntity vocab)
{
IEnumerable <NameValueCollection> results = connection.Query(
string.Format("SELECT k.* FROM {0} kv JOIN {1} k ON (k.{2}=kv.{3}) WHERE kv.{4}=@vid",
SqlHelper.Table_Kanji_Vocab,
SqlHelper.Table_Kanji,
SqlHelper.Field_Kanji_Id,
SqlHelper.Field_Kanji_Vocab_KanjiId,
SqlHelper.Field_Kanji_Vocab_VocabId),
new DaoParameter("@vid", vocab.ID));
KanjiBuilder kanjiBuilder = new KanjiBuilder();
foreach (NameValueCollection nvcKanji in results)
{
KanjiEntity kanji = kanjiBuilder.BuildEntity(nvcKanji, null);
KanjiDao.IncludeKanjiMeanings(connection, kanji);
KanjiDao.IncludeRadicals(connection, kanji);
KanjiDao.IncludeSrsEntries(srsConnection, kanji);
vocab.Kanji.Add(kanji);
}
}
/// <summary>
/// Background task work method.
/// </summary>
private void DoPrepareSvg(object sender, DoWorkEventArgs e)
{
// Lock to allow only one of these operations at a time.
lock (_updateLock)
{
KanjiDao dao = new KanjiDao();
// Get the kanji strokes.
KanjiStrokes strokes = dao.GetKanjiStrokes(_kanjiEntity.DbKanji.ID);
if (strokes != null && strokes.FramesSvg.Length > 0)
{
// If the strokes was successfuly retrieved, we have to read the compressed SVG contained inside.
SharpVectors.Renderers.Wpf.WpfDrawingSettings settings = new SharpVectors.Renderers.Wpf.WpfDrawingSettings();
using (FileSvgReader r = new FileSvgReader(settings))
{
// Unzip the stream and remove instances of "px" that are problematic for SharpVectors.
string svgString = StringCompressionHelper.Unzip(strokes.FramesSvg);
svgString = svgString.Replace("px", string.Empty);
StrokesCount = Regex.Matches(svgString, "<circle").Count;
using (MemoryStream stream = new MemoryStream(Encoding.UTF8.GetBytes(svgString)))
{
// Then read the stream to a DrawingGroup.
// We are forced to do this operation on the UI thread because DrawingGroups must
// be always manipulated by the same thread.
DispatcherHelper.Invoke(() =>
{
StrokesDrawingGroup = r.Read(stream);
SetCurrentStroke(1);
});
}
}
}
}
}
/// <summary>
/// Builds a ViewModel aimed at editing an existing SrsEntry,
/// or adding a pre-composed SrsEntry.
/// </summary>
/// <param name="entity">Entity to edit.</param>
public SrsEntryViewModel(SrsEntry entity)
{
// Initialize fields.
_entry = new ExtendedSrsEntry(entity);
_originalNextReviewDate = entity.NextAnswerDate;
_originalLevelValue = entity.CurrentGrade;
_associatedKanjiString = Entry.AssociatedKanji;
_associatedVocabString = Entry.AssociatedVocab;
_srsEntryDao = new SrsEntryDao();
_kanjiDao = new KanjiDao();
_vocabDao = new VocabDao();
if (IsNew)
{
Entry.Tags = Properties.Settings.Default.LastSrsTagsValue;
}
// Create the relay commands.
SubmitCommand = new RelayCommand(OnSubmit);
CancelCommand = new RelayCommand(OnCancel);
SrsProgressResetCommand = new RelayCommand(OnSrsProgressReset);
ApplyAssociatedKanjiCommand = new RelayCommand(OnApplyAssociatedKanji);
ApplyAssociatedVocabCommand = new RelayCommand(OnApplyAssociatedVocab);
ToggleSuspendCommand = new RelayCommand(OnToggleSuspend);
DeleteCommand = new RelayCommand(OnDelete);
ToggleDateEditCommand = new RelayCommand(OnToggleDateEdit);
DateToNowCommand = new RelayCommand(OnDateToNow);
DateToNeverCommand = new RelayCommand(OnDateToNever);
// Get the associated kanji or vocab.
GetAssociatedKanji();
GetAssociatedVocab();
// Initialize the VM.
_isFirstSrsLevelSelect = true;
SrsLevelPickerVm = new SrsLevelPickerViewModel();
SrsLevelPickerVm.SrsLevelSelected += OnSrsLevelSelected;
SrsLevelPickerVm.Initialize(_entry.CurrentGrade);
}
public KanjiBusiness()
{
_kanjiDao = new KanjiDao();
}