void onDelete0(object x)
{
var v = x; if (Debugger.IsAttached)
{
Debugger.Break();
}
Bpr.BeepOk();
var now = DateTime.Now;
CurMediaUnit.DeletedAt = now; //in case of exceptions at least the intent is recorded.
var rows = DbSaveMsgBox.TrySaveAsk(_db);
var ddir = @"C:\1\M.zDeleted";
if (!Directory.Exists(ddir))
{
Directory.CreateDirectory(ddir);
}
var file = (string.IsNullOrEmpty(CurMediaUnit.PathName) && !string.IsNullOrEmpty(CurMediaUnit.FileName)) ? Path.Combine(CurMediaUnit.PathName, CurMediaUnit.FileName) : CurMediaUnit.PathFileExtOrg;
var dest = Path.Combine(ddir, Path.GetFileName(file));
Task.Run(() => Task.Delay(5000)).ContinueWith(_ => File.Move(file, dest));
if (canMoveNext)
{
onMoveNext(x);
}
else if (canMovePrev)
{
onMovePrev(x);
}
}
void savePosIfLong()
{
if (CurMediaUnit.DurationSec > cAtLeast10Min && (CurMediaUnit.DurationSec - CurMediaUnit.CurPositionSec) < 60) // if a long multi-song unit and not very close to the end - save the position for the next start time
{
DbSaveMsgBox.TrySaveAsk(_db, "savePosIfLong()");
}
}
void addLike(int like1)
{
Bpr.BeepOk();
var now = DateTime.Now;
if (UserA)
{
_db.MuRateHists.Add(new MuRateHist {
DoneAt = now, MediaUnitID = CurMediaUnit.ID, LikeUnit = like1, CurPositionSec = _player.Position.TotalSeconds, DoneBy = "Alex"
});
}
if (UserM)
{
_db.MuRateHists.Add(new MuRateHist {
DoneAt = now, MediaUnitID = CurMediaUnit.ID, LikeUnit = like1, CurPositionSec = _player.Position.TotalSeconds, DoneBy = "Mei"
});
}
if (UserN)
{
_db.MuRateHists.Add(new MuRateHist {
DoneAt = now, MediaUnitID = CurMediaUnit.ID, LikeUnit = like1, CurPositionSec = _player.Position.TotalSeconds, DoneBy = "Nadine"
});
}
if (UserZ)
{
_db.MuRateHists.Add(new MuRateHist {
DoneAt = now, MediaUnitID = CurMediaUnit.ID, LikeUnit = like1, CurPositionSec = _player.Position.TotalSeconds, DoneBy = "Zoe"
});
}
var rows = DbSaveMsgBox.TrySaveAsk(_db);
}
void logAuditionCurPosn()
{
if (CurMediaUnit == null)
{
return;
}
if (CurMediaUnit.DurationSec > 0)
{
if ((CurMediaUnit.DurationSec < 600 && (CurMediaUnit.CurPositionSec / CurMediaUnit.DurationSec) > .5) || // if a muz piece - half counts as 1 audition
(CurMediaUnit.DurationSec >= 600 && (CurMediaUnit.DurationSec - CurMediaUnit.CurPositionSec) < 60)) // if a long muz piece or podcast - last minute could be advertising.
{
safeAddAudition(CurMediaUnit.ID);
CurMediaUnit.CurPositionSec = 0;
}
}
if (CurMediaUnit.CurPositionSec < 10)
{
VMPosn = CurMediaUnit.CurPositionSec = 0;
}
//Bpr.BeepOk();
DbSaveMsgBox.TrySaveAsk(_db, nameof(logAuditionCurPosn));
}
public void SmartCascadingDeleteOfAll(List <long> duplicateCrcsToRemove, int idToStay)
{
foreach (int idToLeave in duplicateCrcsToRemove)
{
SmartCascadingDelete(idToLeave, idToStay);
}
int rows = DbSaveMsgBox.CheckAskSave(_db);
}
void saveAllToDb_Speak()
{
var rows = DbSaveMsgBox.TrySaveAsk(_db);
Debug.WriteLine("{0} rows saved", rows);
if (_AudioRprtg)
{
synth.SpeakAsync($" {rows} rows saved. Position is {CurMediaUnit.CurPositionSec:N0} seconds.");
}
}
async void player_MediaFailed(object sender, System.Windows.ExceptionRoutedEventArgs e)
{
var now = DateTime.Now;
var exm = e.ErrorException.InnermostMessage();
ExceptionMsg = $"MediaFailed: {exm}";
CurMediaUnit.GenreID = 15; // exception: do not play next time ...until deliberately selected and fixed.
if (CurMediaUnit.Notes == null || !CurMediaUnit.Notes.Contains(exm))
{
var len = (CurMediaUnit.Notes == null ? 0 : CurMediaUnit.Notes.Length);
var errmsg = $" {now} {exm} ";
if (errmsg.Length < (1024 - len))
{
CurMediaUnit.Notes += $" {now} {exm} ";
}
else if (200 > (1024 - len))
{
CurMediaUnit.Notes += $" {now} {exm} ".Substring(0, 199);
}
}
if (!File.Exists(CurMediaUnit.PathFileExtOrg))
{
if (File.Exists(CurMediaUnit.PathFileExtOrg.ToLower().Replace("m:\\", "c:\\1\\m\\")))
{
_player.Source = new Uri(CurMediaUnit.PathFileExtOrg = CurMediaUnit.PathFileExtOrg.ToLower().Replace("m:\\", "c:\\1\\m\\"));
ExceptionMsg = $"MediaFailed: SOLVED: renamed M:\\ to C:\\1\\M\\ {_player.Source.LocalPath} ";
DbSaveMsgBox.TrySaveAsk(_db, ExceptionMsg);
await Task.Delay(500);
//synth.Speak("Restarting...");
playAndStartCounters();
return;
}
ExceptionMsg = string.Format("MediaFailed: File does not exist; marking that in DB. ");
CurMediaUnit.DeletedAt = now;
CurMediaUnit.Notes = FileSysProcessor.SAfeAddNote(CurMediaUnit, $" Found missing trying to play on {now.ToShortDateString()}.");
}
DbSaveMsgBox.TrySaveAsk(_db, ExceptionMsg);
if (canMoveNext)
{
onMoveNext(null);
playAndStartCounters();
}
}
public static void DoAll()
{
_now = DateTime.Now;
LoadFolderCsvsToDb(PreSet.PathToCibcVisa, "cibccreditcard*.ofx", Vs);
UpdateTxCoreWith_VI();
LoadFolderCsvsToDb(PreSet.PathToPcMaster, "report*.csv", Mc);
UpdateTxCoreWith_MC();
LoadFolderCsvsToDb(PreSet.PathToTdAavPro, "account*.csv", Td);
LoadFolderCsvsToDb(PreSet.PathToTdPerson, "account*.csv", Td);
UpdateTxCoreWith_TD();
DbSaveMsgBox.CheckAskSave(_db);
}
public static void SetNewName(int ID, string fullNewName, DdjEf4DBContext db)
{
//DdjEf4DBContext db = new DdjEf4DBContext();
var query = from ap in db.MediaUnits
where ap.ID == ID
select ap;
foreach (MediaUnit ap in query)
{
ap.PathFileExtOrg = fullNewName;
}
int rows = DbSaveMsgBox.CheckAskSave(db);
}
async void onReLoad(object s, RoutedEventArgs e)
{
switch (DbSaveMsgBox.CheckAskSave(_db))
{
case (int)MsgBoxDbRslt.Yes: break;
default: break;
case (int)MsgBoxDbRslt.Cancel: return;
case (int)MsgBoxDbRslt.No: break;
}
await reLoadTxCore();
onClear1(s, e);
}
async void onBalanceToDb(object s, RoutedEventArgs e)
{
try
{
bBalance.Visibility = Visibility.Collapsed;
await Task.Delay(9);
using (var db = A0DbContext.Create())
{
var tmsdb = db.TxMoneySrcs.FirstOrDefault(r => r.Id == _tmsId);
if (tmsdb != null)
{
tmsdb.IniBalance += _balDelta;
var rowsSaved = DbSaveMsgBox.CheckAskSave(db);
tBalance.Text = $"{rowsSaved} row saved.";
await reload();
chartuc.RmvSeries(_tmsFla);
addSeries(tmsdb.Id, tmsdb.Fla, tmsdb.IniBalance);
}
}
}
finally { /*bBalance.Visibility = Visibility.Visible;*/ }
}
void onCheckSave(object x)
{
DbSaveMsgBox.CheckAskSave(Db);
}
