private SQLiteDataReader AddPackageWhenNew(ref DateTime filemod, ref bool mod, SqlCommands.LoadFileRow lfr)
{
SQLiteDataReader dr = lfr.Command.ExecuteReader(CommandBehavior.SingleResult);
if (!dr.HasRows)
{
dr.Close();
SqlCommands.AddFileRow afr = new SimPe.Database.SqlCommands.AddFileRow(sql);
afr.FileName = lfr.FileName;
afr.Modified = filemod;
afr.Command.ExecuteNonQuery();
dr = lfr.Command.ExecuteReader(CommandBehavior.SingleResult);
mod = true;
}
return(dr);
}
private long UpdatePackageModDate(string flname, ref DateTime filemod, ref bool mod, SqlCommands.LoadFileRow lfr, SQLiteDataReader dr)
{
if (dr.HasRows)
{
dr.Read();
Console.WriteLine(dr[2]);
long fid = (long)dr[0];
DateTime modified = (DateTime)dr[2];
//if (filemod > modified)
{
sw.WriteLine(); sw.WriteLine();
sw.WriteLine("--> " + flname + " ---------------------------------------------------------------");
Console.WriteLine("--> " + flname + " ---------------------------------------------------------------");
mod = true;
SqlCommands.UpdateFileModDate ufmd = new SimPe.Database.SqlCommands.UpdateFileModDate(sql);
ufmd.FileName = lfr.FileName;
ufmd.Modified = filemod;
//ufmd.Command.ExecuteNonQuery();
SqlCommands.RemoveResources rr = new SimPe.Database.SqlCommands.RemoveResources(sql);
rr.FileId = fid;
rr.CleanupPackageResources();
}
dr.Close();
return(fid);
}
dr.Close();
return(0);
}
