static void CreateDummyData()
{
DropTables();
CreateTables();
var oList = new List <Operator>()
{
new Operator()
{
Name = "aaa", CertificationNumber = "123"
},
new Operator()
{
Name = "bbb"
},
new Operator()
{
Name = "ccc"
}
};
_db.InsertAll(oList);
var sList = new List <Sprayer>()
{
new Sprayer()
{
Name = "1"
},
new Sprayer()
{
Name = "2"
},
new Sprayer()
{
Name = "3"
},
};
_db.InsertAll(sList);
var obList = new List <OrchardBlock>()
{
new OrchardBlock()
{
Name = "b1"
},
new OrchardBlock()
{
Name = "b2"
},
new OrchardBlock()
{
Name = "b3"
},
};
_db.InsertAll(obList);
}
public KspMods(string a_InstallationDirectory, string a_ModPath )
{
InstallationDirectory = a_InstallationDirectory;
ModDirectory = a_ModPath;
db = new SQLiteConnection("kmm.sqlite");
// make sure the table exists
if (db.GetTableInfo("KMMInfo").Count == 0)
{
db.CreateTable<KMMInfo>();
}
var tables = new Type[] { typeof(InstalledMods), typeof(ModFiles), typeof(InstalledFiles) };
foreach (var table in tables)
{
var info = db.GetTableInfo(table.Name);
if (info.Count == 0)
db.CreateTable(table);
}
// oh noez it does not match
if (db.Table<KMMInfo>().Count() == 0 || db.Table<KMMInfo>().First().Version != GetAssemblyVersion())
{
// salvage data
var installed_mods = db.Table<InstalledMods>().ToList();
db.DropTable<InstalledMods>();
db.CreateTable<InstalledMods>();
db.InsertAll(installed_mods);
var mod_files = db.Table<ModFiles>().ToList();
db.DropTable<ModFiles>();
db.CreateTable<ModFiles>();
db.InsertAll(mod_files);
var installed_files = db.Table<InstalledFiles>().ToList();
db.DropTable<InstalledFiles>();
db.CreateTable<InstalledFiles>();
db.InsertAll(installed_files);
}
// make sure the table is filled
if (db.Table<KMMInfo>().Count() == 0)
{
var nfo = new KMMInfo()
{
Version = GetAssemblyVersion()
};
db.Insert(nfo);
}
}
private static void Seed(string pathToDB)
{
var sqlPath = System.IO.Path.GetDirectoryName(System.Diagnostics.Process.GetCurrentProcess().MainModule.FileName) + "\\predefineddata.sql";
if (File.Exists(sqlPath))
{
// Predefined Data exists.
// Read it and Save predefined data.
var commands = File.ReadAllText(sqlPath);
var statements = commands.Split(new[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
using (var db = new SQLite.SQLiteConnection(pathToDB))
{
try
{
foreach (var statement in statements)
{
//Console.WriteLine(statement);
db.Execute(statement);
}
}
catch (Exception ex)
{
Console.WriteLine("Exception: " + ex.Message);
}
}
}
else
{
// No Predefined Data exists.
// Generate base data and Store it.
var environmentalStandards = CrystalClearDBUtil.GenerateBaseDataForEnvironmentalStandard();
var oxygenSolubilities = CrystalClearDBUtil.GenerateBaseDataForOxygenSolubility();
var oxygenDOs = CrystalClearDBUtil.GenerateBaseDataForOxygenDO();
var indices = CrystalClearDBUtil.GenerateBaseDataForBaseIndex();
try
{
using (var db = new SQLite.SQLiteConnection(pathToDB))
{
db.InsertAll(environmentalStandards);
db.InsertAll(oxygenSolubilities);
db.InsertAll(oxygenDOs);
db.InsertAll(indices);
}
}
catch (Exception ex)
{
Console.WriteLine("Exception: " + ex.Message);
}
}
}
// This method checks to see if the database exists, and if it doesn't, it creates
// it and inserts some data
protected void CheckAndCreateDatabase(string dbName)
{
// create a connection object. if the database doesn't exist, it will create
// a blank database
using(SQLiteConnection db = new SQLiteConnection (GetDBPath (dbName)))
{
// create the tables
db.CreateTable<Person> ();
// skip inserting data if it already exists
if(db.Table<Person>().Count() > 0)
return;
// declare vars
List<Person> people = new List<Person> ();
Person person;
// create a list of people that we're going to insert
person = new Person () { FirstName = "Peter", LastName = "Gabriel" };
people.Add (person);
person = new Person () { FirstName = "Thom", LastName = "Yorke" };
people.Add (person);
person = new Person () { FirstName = "J", LastName = "Spaceman" };
people.Add (person);
person = new Person () { FirstName = "Benjamin", LastName = "Gibbard" };
people.Add (person);
// insert our people
db.InsertAll (people);
// close the connection
db.Close ();
}
}
public IActionResult Post([FromBody] List <Master> tasksobj)
{
if (tasksobj != null)
{
var res = db.InsertAll(tasksobj);
}
return(Ok());
}
public static void SaveEvents (List<Event> eventsList)
{
string path = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.Personal), "Event.sqlite");
var db = new SQLiteConnection (path);
db.DropTable<Event> ();
db.CreateTable<Event> ();
db.InsertAll (eventsList);
}
public bool InsertAll(IEnumerable objects, Type objectType)
{
bool returnResult = false;
var insertResult = 0;
try
{
using (SQLConnection = new SQLiteConnection(DatabasePath))
{
insertResult = SQLConnection.InsertAll(objects, objectType);
}
returnResult = true;
}
catch (Exception)
{
returnResult = false;
}
return(returnResult);
}
public static void createDatabase(string strTblName)
{
try
{
var connection = new SQLiteConnection(path);
if(!isTableExisting(strTblName)){
if(strTblName == "Trivia"){
connection.CreateTable<Trivia>();
fillTrivia();
}else if(strTblName == "Tip"){
connection.CreateTable<Tip>();
fillTip();
}else if(strTblName == "Phrases"){
connection.CreateTable<Phrases>();
fillPhrases();
}else if(strTblName == "Dictionary"){
connection.CreateTable<Dictionary>();
fillDictionary();
}else if(strTblName == "Coins"){
connection.CreateTable<Coins>();
var data = new List<Coins> {new Coins { CoinsCount = 0}};
try
{
var db = new SQLiteConnection(path);
if (db.InsertAll(data) != 0){
db.UpdateAll(data);
}
}
catch (SQLiteException ex)
{
Console.Write (ex.Message);
}
}
}
}
catch (SQLiteException)
{
}
}
//------------------------------------------------------------------------//
//not used yet
public bool insert_update_all(IEnumerable<ShopItem> data)
{
try
{
var db = new SQLiteConnection(m_db_path);
if (db.InsertAll(data) != 0)
db.UpdateAll(data);
return true;
}
catch (SQLiteException ex)
{
Console.WriteLine("exception handled while inserting data:{0}", ex.Message);
return false;
}
}
public void SaveAnimationUndoInfo(List<UndoInfo> undoInfo)
{
lock (this.dbLock)
{
using (SQLiteConnection sqlCon = new SQLiteConnection(this.AnimationDBPath))
{
sqlCon.Execute(WZConstants.DBClauseSyncOff);
sqlCon.BeginTransaction();
try
{
sqlCon.Execute("DELETE FROM UndoInfo");
sqlCon.InsertAll(undoInfo);
sqlCon.Commit();
} catch (Exception ex)
{
sqlCon.Rollback();
#if(DEBUG)
Console.WriteLine("Error inserting undo info objects! {0}--{1}", ex.Message, ex.StackTrace);
#endif
}//end try catch
}//end using sqlCon
}//end lock
}
private static void ProcessFolder(SQLiteConnection db, DriveInformation drive, List<string> arrHeaders, DirectoryInfo directory)
{
try {
if (!directory.Exists)
return;
if (IgnoreFolder(directory)) {
return;
}
//go get the cached items for the folder.
var directoryId = DatabaseLookups.GetDirectoryId(db, drive, directory);
var cmd = db.CreateCommand("Select * from " + typeof(FileInformation).Name + " Where DriveId = ? AND DirectoryId = ?", drive.DriveId, directoryId);
var databaseFiles = cmd.ExecuteQuery<FileInformation>();
//obtain the file metadata for all of the files in the directory so we can determine if we care about this folder.
var processList = GetFilesToProcess(databaseFiles, arrHeaders, directory);
if (processList.Count > 0) {
db.BeginTransaction();
Shell32.Shell shell = new Shell32.Shell();
Shell32.Folder folder = shell.NameSpace(directory.FullName);
foreach (var item in processList) {
try {
var fi = item.FileInfo;
var headerList = new List<FileAttributeInformation>();
for (int i = 0; i < arrHeaders.Count; i++) {
var header = arrHeaders[i];
if (!IgnoreHeader(header)) {
var value = folder.GetDetailsOf(item.FolderItem, i);
if (!string.IsNullOrWhiteSpace(value)) {
headerList.Add(new FileAttributeInformation() {
AttributeId = DatabaseLookups.GetAttributeId(db, header),
Value = value
});
}
}
}
//this should have been already checked but we want to be safe.
if (fi.Exists) {
var fileInfo = databaseFiles.FirstOrDefault(info => info.FileName.Equals(fi.Name, StringComparison.OrdinalIgnoreCase));
if (fileInfo == null) {
fileInfo = new FileInformation() {
DriveId = drive.DriveId,
DirectoryId = directoryId,
FileName = fi.Name
};
SetFileInformation(fi, fileInfo);
db.Insert(fileInfo);
Console.WriteLine("Inserted:" + fi.FullName);
}
else {
SetFileInformation(fi, fileInfo);
db.Update(fileInfo);
var deleteCount = db.Execute("Delete from " + typeof(FileAttributeInformation).Name + " WHERE FileId = ?", fileInfo.FileId);
Console.WriteLine("Changed:" + fi.FullName);
}
//save the headers
headerList.ForEach(hl => hl.FileId = fileInfo.FileId);
db.InsertAll(headerList);
}
}
catch (Exception ex) {
Console.WriteLine(ex.ToString());
}
}
db.Commit();
}
//see if we have any additional folders. If we get access denied it will throw an error
try {
foreach (var subDirectory in directory.GetDirectories()) {
ProcessFolder(db, drive, arrHeaders, subDirectory);
}
}
catch (Exception ex) {
Console.WriteLine(ex.ToString());
}
}
catch (UnauthorizedAccessException) {
}
catch (Exception ex) {
Console.WriteLine(ex.ToString());
}
}
public void InsertOrUpdateAnimation(AnimationInfo animationInfo)
{
lock (this.dbLock)
{
using (SQLiteConnection sqlCon = new SQLiteConnection(this.AnimationDBPath))
{
sqlCon.Execute(WZConstants.DBClauseSyncOff);
Type animationInfoType = typeof(AnimationInfo);
Type frameInfoType = typeof(FrameInfo);
Type layerInfoType = typeof(LayerInfo);
Type drInfoType = typeof(DrawingInfo);
Type trInfoType = typeof(TransitionInfo);
Type trSettingsType = typeof(TransitionEffectSettings);
Type brushItemType = typeof(BrushItem);
Type audioItemType = typeof(AnimationAudioInfo);
sqlCon.BeginTransaction();
try
{
//
// AnimationInfo
//
if (sqlCon.Execute("UPDATE AnimationInfo SET " +
"MessageGuid=?, " +
"StepNumber=?, " +
"CreatedOn=?, " +
"OriginalCanvasSizeWidth=?, " +
"OriginalCanvasSizeHeight=?, " +
"IsEditing=?, " +
"IsSent=? " +
"WHERE DBID=?",
animationInfo.MessageGuid,
animationInfo.StepNumber,
animationInfo.CreatedOn,
animationInfo.OriginalCanvasSizeWidth,
animationInfo.OriginalCanvasSizeHeight,
animationInfo.IsEditing,
animationInfo.IsSent,
animationInfo.DBID) == 0)
{
sqlCon.Insert(animationInfo, animationInfoType);
}//end if
foreach (FrameInfo eachFrameInfo in animationInfo.FrameItems.Values)
{
eachFrameInfo.AnimationDBID = animationInfo.DBID;
if (sqlCon.Execute("UPDATE FrameInfo SET " +
"ID=?, " +
"AnimationDBID=? " +
"WHERE DBID=?",
eachFrameInfo.ID,
eachFrameInfo.AnimationDBID,
eachFrameInfo.DBID) == 0)
{
sqlCon.Insert(eachFrameInfo, frameInfoType);
}//end if
foreach (LayerInfo eachLayerInfo in eachFrameInfo.Layers.Values)
{
eachLayerInfo.FrameDBID = eachFrameInfo.DBID;
if (sqlCon.Execute("UPDATE LayerInfo SET " +
"ID=?, " +
"FrameDBID=?, " +
"CanvasSizeWidth=?, " +
"CanvasSizeHeight=?, " +
"IsCanvasActive=? " +
"WHERE DBID=?",
eachLayerInfo.ID,
eachLayerInfo.FrameDBID,
eachLayerInfo.CanvasSizeWidth,
eachLayerInfo.CanvasSizeHeight,
eachLayerInfo.IsCanvasActive,
eachLayerInfo.DBID) == 0)
{
sqlCon.Insert(eachLayerInfo, layerInfoType);
}//end if
foreach (DrawingInfo eachDrawingInfo in eachLayerInfo.DrawingItems.Values)
{
eachDrawingInfo.LayerDBID = eachLayerInfo.DBID;
if (null != eachDrawingInfo.Brush)
{
if (sqlCon.Execute("UPDATE BrushItem SET " +
"Thickness=?, " +
"BrushType=?, " +
"BrushImageBuffer=?, " +
"BrushColorBuffer=?, " +
"InactiveBrushColorBuffer=?, " +
"IsSprayBrushActive=? " +
"WHERE DBID=?",
eachDrawingInfo.Brush.Thickness,
eachDrawingInfo.Brush.BrushType,
eachDrawingInfo.Brush.BrushImageBuffer,
eachDrawingInfo.Brush.BrushColorBuffer,
eachDrawingInfo.Brush.InactiveBrushColorBuffer,
eachDrawingInfo.Brush.IsSprayBrushActive,
eachDrawingInfo.Brush.DBID) == 0)
{
sqlCon.Insert(eachDrawingInfo.Brush, brushItemType);
}//end sqlCon
eachDrawingInfo.BrushItemDBID = eachDrawingInfo.Brush.DBID;
}//end if
if (sqlCon.Execute("UPDATE DrawingInfo SET " +
"DrawingID=?, " +
"LayerDBID=?, " +
"BrushItemDBID=?, " +
"LineColorBuffer=?, " +
"DrawingType=?, " +
"ImageBuffer=?, " +
"ImageFrameX=?, " +
"ImageFrameY=?, " +
"ImageFrameWidth=?, " +
"ImageFrameHeight=?, " +
"RotationAngle=?, " +
"RotatedImageBoxX=?, " +
"RotatedImageBoxY=?, " +
"RotatedImageBoxWidth=?, " +
"RotatedImageBoxHeight=?, " +
"ContentPackItemID=?, " +
"CalloutText=?, " +
"CalloutTextRectX=?, " +
"CalloutTextRectY=?, " +
"CalloutTextRectWidth=?, " +
"CalloutTextRectHeight=? " +
"WHERE DBID=?",
eachDrawingInfo.DrawingID,
eachDrawingInfo.LayerDBID,
eachDrawingInfo.BrushItemDBID,
eachDrawingInfo.LineColorBuffer,
eachDrawingInfo.DrawingType,
eachDrawingInfo.ImageBuffer,
eachDrawingInfo.ImageFrameX,
eachDrawingInfo.ImageFrameY,
eachDrawingInfo.ImageFrameWidth,
eachDrawingInfo.ImageFrameHeight,
eachDrawingInfo.RotationAngle,
eachDrawingInfo.RotatedImageBoxX,
eachDrawingInfo.RotatedImageBoxY,
eachDrawingInfo.RotatedImageBoxWidth,
eachDrawingInfo.RotatedImageBoxHeight,
eachDrawingInfo.ContentPackItemID,
eachDrawingInfo.CalloutText,
eachDrawingInfo.CalloutTextRectX,
eachDrawingInfo.CalloutTextRectY,
eachDrawingInfo.CalloutTextRectWidth,
eachDrawingInfo.CalloutTextRectHeight,
eachDrawingInfo.DBID) == 0)
{
sqlCon.Insert(eachDrawingInfo, drInfoType);
}//end if
if (eachDrawingInfo.DrawingType == DrawingLayerType.Drawing)
{
List<PathPointDB> drPoints = eachDrawingInfo.GetPathPointsForDB();
// DELETE path points for this drawing item. No need to try to update each one individually.
sqlCon.Execute("DELETE FROM PathPointDB WHERE DrawingInfoDBID=?", eachDrawingInfo.DBID);
// And INSERT
sqlCon.InsertAll(drPoints);
}//end if
}//end foreach
foreach (TransitionInfo eachTrInfo in eachLayerInfo.Transitions.Values)
{
eachTrInfo.LayerDBID = eachLayerInfo.DBID;
if (sqlCon.Execute("UPDATE TransitionInfo SET " +
"ID=?, " +
"LayerDBID=?, " +
"FadeOpacity=?, " +
"RotationAngle=?, " +
"EndSizeWidth=?, " +
"EndSizeHeight=?, " +
"EndSizeFixedPointX=?, " +
"EndSizeFixedPointY=?, " +
"EndLocationX=?, " +
"EndLocationY=? " +
"WHERE DBID=?",
eachTrInfo.ID,
eachTrInfo.LayerDBID,
eachTrInfo.FadeOpacity,
eachTrInfo.RotationAngle,
eachTrInfo.EndSizeWidth,
eachTrInfo.EndSizeHeight,
eachTrInfo.EndSizeFixedPointX,
eachTrInfo.EndSizeFixedPointY,
eachTrInfo.EndLocationX,
eachTrInfo.EndLocationY,
eachTrInfo.DBID) == 0)
{
sqlCon.Insert(eachTrInfo, trInfoType);
}//end if
foreach (TransitionEffectSettings eachTrSetting in eachTrInfo.Settings.Values)
{
eachTrSetting.TransitionInfoDBID = eachTrInfo.DBID;
if (sqlCon.Execute("UPDATE TransitionEffectSettings SET " +
"TransitionID=?, " +
"TransitionInfoDBID=?, " +
"FrameID=?, " +
"LayerID=?, " +
"EffectType=?, " +
"Duration=?, " +
"RotationCount=?, " +
"Delay=? " +
"WHERE DBID=?",
eachTrSetting.TransitionID,
eachTrSetting.TransitionInfoDBID,
eachTrSetting.FrameID,
eachTrSetting.LayerID,
eachTrSetting.EffectType,
eachTrSetting.Duration,
eachTrSetting.RotationCount,
eachTrSetting.Delay,
eachTrSetting.DBID) == 0)
{
sqlCon.Insert(eachTrSetting, trSettingsType);
}//end if
}//end foreach
}//end foreach
}//end foreach
}//end foreach
foreach (AnimationAudioInfo eachAudioItem in animationInfo.AudioItems.Values)
{
FrameInfo frameItem = null;
if (animationInfo.FrameItems.TryGetValue(eachAudioItem.FrameID, out frameItem))
{
eachAudioItem.FrameDBID = frameItem.DBID;
}//end if
if (sqlCon.Execute("UPDATE AnimationAudioInfo SET " +
"ID=?, " +
"FrameID=?, " +
"FrameDBID=?, " +
"AudioBuffer=?, " +
"Duration=? " +
"WHERE DBID=?",
eachAudioItem.ID,
eachAudioItem.FrameID,
eachAudioItem.FrameDBID,
eachAudioItem.AudioBuffer,
eachAudioItem.Duration,
eachAudioItem.DBID) == 0)
{
sqlCon.Insert(eachAudioItem, audioItemType);
}//end if
}//end foreach
sqlCon.Commit();
} catch (Exception ex)
{
sqlCon.Rollback();
throw ex;
}//end try catch
}//end using sqlCon
}//end lock
}
public void InsertOutgoingMessage(MessageDB message)
{
lock (this.dbLock)
{
using (SQLiteConnection sqlCon = new SQLiteConnection(this.DBPath))
{
sqlCon.Execute(WZConstants.DBClauseSyncOff);
sqlCon.BeginTransaction();
try
{
message.IsOutgoing = true;
sqlCon.Insert(message, typeof(MessageDB));
sqlCon.InsertAll(message.MessageStepDBList);
sqlCon.InsertAll(message.MessageRecipientDBList);
sqlCon.Commit();
} catch (Exception ex)
{
#if(DEBUG)
Console.WriteLine("Error in InsertOutgoingMessage! {0}--{1}", ex.Message, ex.StackTrace);
#endif
sqlCon.Rollback();
}//end try catch
}//end using sqlCon
}//end lock
}
/// <summary>
/// Inserts newly received messages to the database.
/// </summary>
/// <param name='messageList'>
/// The newly received messages.
/// </param>
public void InsertNewMessages(List<Message> messageList)
{
lock (this.dbLock)
{
using (SQLiteConnection sqlCon = new SQLiteConnection(this.DBPath))
{
sqlCon.Execute(WZConstants.DBClauseSyncOff);
sqlCon.BeginTransaction();
try
{
Type messageDBType = typeof(MessageDB);
foreach (Message eachMessage in messageList)
{
MessageDB eachMessageDb = MessageDB.ConvertFromMessage(eachMessage);
sqlCon.Insert(eachMessageDb, messageDBType);
sqlCon.InsertAll(eachMessageDb.MessageStepDBList);
sqlCon.InsertAll(eachMessageDb.MessageRecipientDBList);
}//end foreach
sqlCon.Commit();
} catch (Exception ex)
{
#if(DEBUG)
Console.WriteLine("Error in InsertNewMessages! {0}--{1}", ex.Message, ex.StackTrace);
#endif
sqlCon.Rollback();
}//end try catch
}//end using sqlCon
}//end lock
}
public void InsertNewPollingSteps(List<PollingStepDB> pollingSteps)
{
lock (this.dbLock)
{
using (SQLiteConnection sqlCon = new SQLiteConnection(this.DBPath))
{
sqlCon.Execute(WZConstants.DBClauseSyncOff);
sqlCon.BeginTransaction();
try
{
sqlCon.InsertAll(pollingSteps);
sqlCon.Commit();
} catch (Exception ex)
{
#if(DEBUG)
Console.WriteLine("Error in InsertNewPollingSteps! {0}--{1}", ex.Message, ex.StackTrace);
#endif
sqlCon.Rollback();
}//end try catch
}//end using sqlCon
}//end lock
}
public static void fillDictionary()
{
var mlistWords = new List<Dictionary> {
new Dictionary {TagalogWord = " abril ", CebuanoWord = " abril ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " agad ", CebuanoWord = " dayon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " agosto ", CebuanoWord = " agosto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ahas ", CebuanoWord = " halas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " aking ", CebuanoWord = " akong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ako ", CebuanoWord = " nako ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " alalahanin ", CebuanoWord = " hinumdomi ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " alerto ", CebuanoWord = " alisto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " alok ", CebuanoWord = " ikalahad ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ampalaya ", CebuanoWord = " ampalaya ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ampalaya ", CebuanoWord = " amplaya ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " anak ", CebuanoWord = " anak ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " anay ", CebuanoWord = " anay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " andito ", CebuanoWord = " ania ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ang ", CebuanoWord = " ang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ang ", CebuanoWord = " ang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " aniya ", CebuanoWord = " ania ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ano ", CebuanoWord = " unsa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ano ", CebuanoWord = " unsa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ano ", CebuanoWord = " unsa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ano ", CebuanoWord = " unsa'y ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " anuman ", CebuanoWord = " sapayan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " araw ", CebuanoWord = " adlaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " araw-araw ", CebuanoWord = " adlaw-adlaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " asawa ", CebuanoWord = " banay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " aso ", CebuanoWord = " iro ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ayusin ", CebuanoWord = " pag-ayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " baba ", CebuanoWord = " suwang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " babaan ", CebuanoWord = " pagkanaog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " babae ", CebuanoWord = " babaye ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " babae ", CebuanoWord = " babae ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " babay ", CebuanoWord = " babayon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " baboy ", CebuanoWord = " baboy ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bagalan ", CebuanoWord = " paghinay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bagaman ", CebuanoWord = " bisan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bago ", CebuanoWord = " bag-o ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bahala ", CebuanoWord = " bahala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " baka ", CebuanoWord = " baka ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bakit ", CebuanoWord = " ngano ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bakit ", CebuanoWord = " ngano ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bakit ", CebuanoWord = " nganong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " balakang ", CebuanoWord = " bat'ang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " balikat ", CebuanoWord = " abaga ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bangga ", CebuanoWord = " bangga ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " basahin ", CebuanoWord = " pagbasa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bastos ", CebuanoWord = " bastos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bawang ", CebuanoWord = " ahos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bawasan ", CebuanoWord = " kuhaan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bawa't ", CebuanoWord = " matag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bayaw ", CebuanoWord = " bayaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " baywang ", CebuanoWord = " hawak ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bibig ", CebuanoWord = " baba ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bigote ", CebuanoWord = " bigote ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " binti ", CebuanoWord = " paa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bisperas ", CebuanoWord = " bisperas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " biyenan ", CebuanoWord = " ugangan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " biyernes ", CebuanoWord = " biyernes ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " braso ", CebuanoWord = " bukton ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " buhok ", CebuanoWord = " buhok ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bukang-liwayway ", CebuanoWord = " kaadlawon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bukas ", CebuanoWord = " ugma ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bukas ", CebuanoWord = " ugma ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " buksan ", CebuanoWord = " ablihi ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bungantulog ", CebuanoWord = " rawraw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " bungo ", CebuanoWord = " bagol-bagol ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " buo ", CebuanoWord = " tibuuk ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " butiki ", CebuanoWord = " tabili ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " buwan ", CebuanoWord = " bulan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " buwan ", CebuanoWord = " bulan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " candy ", CebuanoWord = " kamilitos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " cauliflower ", CebuanoWord = " koliplor ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " daan ", CebuanoWord = " dalan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " daga ", CebuanoWord = " ilaga ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " dagdagan ", CebuanoWord = " dugangan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " dala ", CebuanoWord = " dala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " daliri ", CebuanoWord = " tudlo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " dibdib ", CebuanoWord = " dughan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " dila ", CebuanoWord = " dila ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " din ", CebuanoWord = " ra ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " diretso ", CebuanoWord = " diretso ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " disyembre ", CebuanoWord = " disyembre ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " diyan ", CebuanoWord = " diha ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " dumating ", CebuanoWord = " miabot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " dumating ", CebuanoWord = " miabot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " enero ", CebuanoWord = " enero ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gabi ", CebuanoWord = " gabii ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gagamba ", CebuanoWord = " lawa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gagamitin ", CebuanoWord = " idapat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gagawin ", CebuanoWord = " buhaton ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " galing ", CebuanoWord = " gikan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " galit ", CebuanoWord = " nasuko ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " galit ", CebuanoWord = " naglagot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gamugamo ", CebuanoWord = " anunugba ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ganoon ", CebuanoWord = " ma-o ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " garbanzo beans ", CebuanoWord = " garbanzos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gastador ", CebuanoWord = " gastador ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gilagid ", CebuanoWord = " lagos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gilid ", CebuanoWord = " daplin ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gilid ", CebuanoWord = " kilid ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gitna ", CebuanoWord = " tungang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gumawa ", CebuanoWord = " buhaton ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gumising ", CebuanoWord = " magmata ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gusto ", CebuanoWord = " gusto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gusto ", CebuanoWord = " gusto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " gwapo ", CebuanoWord = " gwapo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " habag ", CebuanoWord = " looy ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " halik ", CebuanoWord = " halok ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hambog ", CebuanoWord = " hambogero ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hamog ", CebuanoWord = " yamog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hapon ", CebuanoWord = " hapon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " harap ", CebuanoWord = " atbang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hating ", CebuanoWord = " tungang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hawak ", CebuanoWord = " gunit ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hila ", CebuanoWord = " bira ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hilain ", CebuanoWord = " ibira ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hindi ", CebuanoWord = " dili ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hipag ", CebuanoWord = " bilas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hugas ", CebuanoWord = " hugas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hulyo ", CebuanoWord = " hulyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " hunyo ", CebuanoWord = " hunyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " huwebes ", CebuanoWord = " huwebes ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " iba ", CebuanoWord = " ubang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ibaba ", CebuanoWord = " ipaubos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ibigay ", CebuanoWord = " ihatag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ibon ", CebuanoWord = " langgam ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ikaw ", CebuanoWord = " ikaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ikaw ", CebuanoWord = " ikaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ilong ", CebuanoWord = " ilong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " inaasahan ", CebuanoWord = " naglaum ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " inom ", CebuanoWord = " inom ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ipagbili ", CebuanoWord = " pagbaligya ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ipakilala ", CebuanoWord = " ipaila ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ipakita ", CebuanoWord = " ipakita ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ipis ", CebuanoWord = " uk'uk ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " isa ", CebuanoWord = " usa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " isagawa ", CebuanoWord = " himoon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " isara ", CebuanoWord = " isara ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " itaas ", CebuanoWord = " ipataas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " itago ", CebuanoWord = " itago ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " itik ", CebuanoWord = " itik ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ito ", CebuanoWord = " kini ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " itulak ", CebuanoWord = " itulod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " iyak ", CebuanoWord = " hilak ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " iyo ", CebuanoWord = " imong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " iyo ", CebuanoWord = " imo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " iyon ", CebuanoWord = " kana ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " iyong ", CebuanoWord = " imong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " iyong ", CebuanoWord = " kanang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kaakit-akit ", CebuanoWord = " makadani ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kabute ", CebuanoWord = " libgos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kabutihan ", CebuanoWord = " kamaayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kahapon ", CebuanoWord = " gahapon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kahapon ", CebuanoWord = " kagahapon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kaibigan ", CebuanoWord = " higala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kaibigan ", CebuanoWord = " higala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kaibigan ", CebuanoWord = " amigo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kailan ", CebuanoWord = " kanus'a ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kailan ", CebuanoWord = " anus'a ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kailangan ", CebuanoWord = " magkinahanglan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kakain ", CebuanoWord = " mangaon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kakilala ", CebuanoWord = " kaila ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kalabitin ", CebuanoWord = " tandog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kalagayan ", CebuanoWord = " kahimtag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kalayo ", CebuanoWord = " kalayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kaliwa ", CebuanoWord = " wala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kamag-anak ", CebuanoWord = " paryente ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kamakailan ", CebuanoWord = " bag-oha'y ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kamay ", CebuanoWord = " kamot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kamay ", CebuanoWord = " kamot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kamote ", CebuanoWord = " kamote ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kanan ", CebuanoWord = " too ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kanta ", CebuanoWord = " kanta ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kapatid ", CebuanoWord = " igsoon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kapatid ", CebuanoWord = " igsoong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kapitbahay ", CebuanoWord = " silingan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kasama ", CebuanoWord = " kauban ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kasama ", CebuanoWord = " kuyog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kasama ", CebuanoWord = " uban ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kaya ", CebuanoWord = " busa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kilay ", CebuanoWord = " kilay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kuhain ", CebuanoWord = " bakwi-a ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kuko ", CebuanoWord = " kuko ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kuliglig ", CebuanoWord = " kuliklik ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kumain ", CebuanoWord = " nanga'on ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kumakain ", CebuanoWord = " mokaon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kumusta ", CebuanoWord = " komusta ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kuneho ", CebuanoWord = " koneho ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kung ", CebuanoWord = " kon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kung ", CebuanoWord = " kon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kuwago ", CebuanoWord = " mang'ak ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " kwento ", CebuanoWord = " sugilanon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " laban ", CebuanoWord = " batok ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " labanos ", CebuanoWord = " rabanos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " labas ", CebuanoWord = " lab-as ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lakad ", CebuanoWord = " padayon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lakad ", CebuanoWord = " lakaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lakad ", CebuanoWord = " mouban ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lakad ", CebuanoWord = " lakaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lalaki ", CebuanoWord = " lalaki ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lalaki ", CebuanoWord = " lalaki ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lalaki ", CebuanoWord = " lalakiha ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lalamunan ", CebuanoWord = " tutunlan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " langgam ", CebuanoWord = " hulmigas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " langoy ", CebuanoWord = " langoy ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lasa ", CebuanoWord = " lami ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " leeg ", CebuanoWord = " liog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " letsugas ", CebuanoWord = " letsugas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " liko ", CebuanoWord = " liko ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " likod ", CebuanoWord = " luyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " linggo ", CebuanoWord = " domingo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " linggo ", CebuanoWord = " semana ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lion ", CebuanoWord = " liyon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lola ", CebuanoWord = " lola ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lolo ", CebuanoWord = " lolo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " luma ", CebuanoWord = " daan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " lunes ", CebuanoWord = " lunes ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " luya ", CebuanoWord = " luy-a ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maalat ", CebuanoWord = " parat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maanghang ", CebuanoWord = " halang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maasim ", CebuanoWord = " aslom ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabagal ", CebuanoWord = " hinay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabagal ", CebuanoWord = " hinayon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabait ", CebuanoWord = " buotan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabilis ", CebuanoWord = " paspas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabuhay ", CebuanoWord = " mabuhi ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabuti ", CebuanoWord = " maayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabuti ", CebuanoWord = " buyno ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mabuti ", CebuanoWord = " maayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magagawa ", CebuanoWord = " mahimo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mag-alala ", CebuanoWord = " mabalaka ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magalit ", CebuanoWord = " masuko ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maganda ", CebuanoWord = " katahom ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maganda ", CebuanoWord = " ka-guapa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maganda ", CebuanoWord = " pagkaanindot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maganda ", CebuanoWord = " gwapa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maganda ", CebuanoWord = " matahom ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maganda ", CebuanoWord = " maanyag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magbantay ", CebuanoWord = " pagbantay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maghintay ", CebuanoWord = " paghulat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maghintay ", CebuanoWord = " magpaabot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maghiwalay ", CebuanoWord = " magbulag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maging malungkot ", CebuanoWord = " maguul ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mag-ingat ", CebuanoWord = " pag-amping ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magkano ", CebuanoWord = " pila ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magkaroon ", CebuanoWord = " naa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magmamadali ", CebuanoWord = " pagdali ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magsalita ", CebuanoWord = " sulti ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magsalita ", CebuanoWord = " sulti ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magsama ", CebuanoWord = " mag-uban ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magulang ", CebuanoWord = " ginikanan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magulang ", CebuanoWord = " ginikan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " magulang ", CebuanoWord = " ginikanan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mahal ", CebuanoWord = " mahal ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mahalaga ", CebuanoWord = " mahinungdanon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mahirap ", CebuanoWord = " lisod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mahirap ", CebuanoWord = " gahi ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mahirap ", CebuanoWord = " pobre ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mahirap ", CebuanoWord = " kabus ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mahirap ", CebuanoWord = " pobre ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maigsi ", CebuanoWord = " mubo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maikli ", CebuanoWord = " mubo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maingat ", CebuanoWord = " mainampingon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maintindihan ", CebuanoWord = " mahibalo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maintindihan ", CebuanoWord = " masayod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " makasarili ", CebuanoWord = " hikawan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " makatanggap ", CebuanoWord = " modawat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " makita ", CebuanoWord = " motan-aw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " malaki ", CebuanoWord = " dako ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " malaki ", CebuanoWord = " dako ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " malamig ", CebuanoWord = " makamig ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maliit ", CebuanoWord = " gamay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maliit ", CebuanoWord = " gamay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " malungkot ", CebuanoWord = " magul'anon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " malusog ", CebuanoWord = " himsog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mamalo ", CebuanoWord = " latus ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mamatay ", CebuanoWord = " mamatay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mamaya ", CebuanoWord = " taod-taod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mamaya na ", CebuanoWord = " unya ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " manok ", CebuanoWord = " manok ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " manugang na babae ", CebuanoWord = " binalaye ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " manugang na lalaki ", CebuanoWord = " masamong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapagbigay ", CebuanoWord = " mahinatagon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapagpakumbaba ", CebuanoWord = " maaghup ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapait ", CebuanoWord = " pait ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapakla ", CebuanoWord = " aplod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapasikat ", CebuanoWord = " garboso ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapayat ", CebuanoWord = " daut ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapayat ", CebuanoWord = " niwang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mapera ", CebuanoWord = " dato ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " marami ", CebuanoWord = " daghan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " marso ", CebuanoWord = " marso ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " martes ", CebuanoWord = " martes ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masalita ", CebuanoWord = " tabi-an ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masama ", CebuanoWord = " daotan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masasabi ", CebuanoWord = " ikasulti ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masaya ", CebuanoWord = " nalipay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masaya ", CebuanoWord = " magpalipayon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masaya ", CebuanoWord = " malipayon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masipag ", CebuanoWord = " kugihan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " masusunod ", CebuanoWord = " masunod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mata ", CebuanoWord = " mata ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mataas ", CebuanoWord = " taas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mataba ", CebuanoWord = " tambok ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matalino ", CebuanoWord = " utokan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matalino ", CebuanoWord = " maantigo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matalino ", CebuanoWord = " makahibalo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matamis ", CebuanoWord = " pagkatam-is ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matatakot ", CebuanoWord = " nahadlok ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matipid ", CebuanoWord = " daginutan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matulog ", CebuanoWord = " matulog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " matulungin ", CebuanoWord = " matinabangon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " maunawain ", CebuanoWord = " masinabtanon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mawalan ", CebuanoWord = " pakawala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mayaman ", CebuanoWord = " dato ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mayaman ", CebuanoWord = " sapian ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mayo ", CebuanoWord = " mayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mayroon ", CebuanoWord = " dunay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " miyerkules ", CebuanoWord = " miyerkules ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mo ", CebuanoWord = " nimo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mo ", CebuanoWord = " mo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " monggo ", CebuanoWord = " monggo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mukha ", CebuanoWord = " aping ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mura ", CebuanoWord = " barato ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " mustasa ", CebuanoWord = " mostasa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " na ", CebuanoWord = " na ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " na ", CebuanoWord = " nga ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagagalak ", CebuanoWord = " malipay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nag-anyaya ", CebuanoWord = " miagda ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagdadalawang-isip ", CebuanoWord = " nagduha-duha ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " naglakad-lakad ", CebuanoWord = " nagsuroy-suroy ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagpadala ", CebuanoWord = " nagpadala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagsabi ", CebuanoWord = " nagsulti ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagsabi ", CebuanoWord = " nag'ingon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagtatago ", CebuanoWord = " nagtago ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagtataka ", CebuanoWord = " nahibulong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nagtataka ", CebuanoWord = " natingala ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nais ", CebuanoWord = " buut ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nakaraan ", CebuanoWord = " miaging ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nakaraan ", CebuanoWord = " miaging ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nakatira ", CebuanoWord = " nagpuyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nakatira ", CebuanoWord = " magpuyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nakuha ", CebuanoWord = " nagkuha ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nalaman ", CebuanoWord = " pagkahibalo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nanalo ", CebuanoWord = " midaog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nanalo ", CebuanoWord = " nakadaog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nanay ", CebuanoWord = " inahan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nanginginig ", CebuanoWord = " nagpangurog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nangyari ", CebuanoWord = " nahitabo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nangyari ", CebuanoWord = " pagkahitabo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " napaka ", CebuanoWord = " kaayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nasa ", CebuanoWord = " anaa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " natanggap ", CebuanoWord = " nadawat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " natanggap ", CebuanoWord = " nadawat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ng ", CebuanoWord = " og ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ngayon ", CebuanoWord = " karon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ngayon ", CebuanoWord = " karon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ngayong araw ", CebuanoWord = " karong adlawa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ngayong gabi ", CebuanoWord = " karong gabii ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ngipin ", CebuanoWord = " ngipon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ngiti ", CebuanoWord = " pahiyom ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " niyan ", CebuanoWord = " niana ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " nobyembre ", CebuanoWord = " nobyembre ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " noo ", CebuanoWord = " agtang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " noong ", CebuanoWord = " niadtong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " oktubre ", CebuanoWord = " oktubre ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paa ", CebuanoWord = " tiil ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paalam ", CebuanoWord = " adiyos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paano ", CebuanoWord = " unsaon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paano ", CebuanoWord = " giunsa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paano ", CebuanoWord = " naunsa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paano ", CebuanoWord = " unsaon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pabaya ", CebuanoWord = " dangag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pabili ", CebuanoWord = " paliton ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pag-asa ", CebuanoWord = " paglaum ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pagdating ", CebuanoWord = " pag-abot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pagitan ", CebuanoWord = " kapulihay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pagkakamali ", CebuanoWord = " pagkasayup ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pakiusap ", CebuanoWord = " palihug ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " palagi ", CebuanoWord = " kanunay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " palagi ", CebuanoWord = " kanunay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " palaka ", CebuanoWord = " baki ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " palakaibigan ", CebuanoWord = " mahigalahon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " palakaibigan ", CebuanoWord = " mahigalahon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " palakpak ", CebuanoWord = " pakpak ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " palitan ", CebuanoWord = " pag-ilis ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pamangkin ", CebuanoWord = " pag-umangkon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pamilya ", CebuanoWord = " banay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pangalan ", CebuanoWord = " ngalan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pangalan ", CebuanoWord = " ngalan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pangit ", CebuanoWord = " ngil'ad ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pangit ", CebuanoWord = " kamaot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pangit ", CebuanoWord = " laksot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pangit ", CebuanoWord = " ma-ot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " panika ", CebuanoWord = " kulaknit ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paradahan ", CebuanoWord = " paradahan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paruparu ", CebuanoWord = " kabakaba ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " patawarin ", CebuanoWord = " gikasubo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " patola ", CebuanoWord = " sikwa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " patungo ", CebuanoWord = " paingon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " patungo ", CebuanoWord = " padulong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " paumanhin ", CebuanoWord = " tabi ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pebrero ", CebuanoWord = " pebrero ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pechay ", CebuanoWord = " petsay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " piga ", CebuanoWord = " puga ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pili ", CebuanoWord = " pili ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pilipitin ", CebuanoWord = " salapid ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pinsan ", CebuanoWord = " ig'agaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pipino ", CebuanoWord = " pipino ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " presyo ", CebuanoWord = " presyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " problema ", CebuanoWord = " kabilinggan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pulso ", CebuanoWord = " pulso ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pumunta ", CebuanoWord = " nangadto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pupunta ", CebuanoWord = " mangatdo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " puro ", CebuanoWord = " pulus ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pusa ", CebuanoWord = " iring ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " puso ng saging ", CebuanoWord = " puso sa saging ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " pusod ", CebuanoWord = " pusod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " repolyo ", CebuanoWord = " repolyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sa ", CebuanoWord = " sa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sa atin ", CebuanoWord = " kanato ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sa katunayan ", CebuanoWord = " gayod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " saan ", CebuanoWord = " asa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " saan ", CebuanoWord = " hain ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " saan ", CebuanoWord = " hain ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " saan ", CebuanoWord = " asa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " saan ", CebuanoWord = " diin ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sabado ", CebuanoWord = " sabado ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sabihin ", CebuanoWord = " ipasabot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sakayan ", CebuanoWord = " pagsakay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sakitin ", CebuanoWord = " masakiton ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " salamat ", CebuanoWord = " salamat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " samahan ", CebuanoWord = " ubanan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sampal ", CebuanoWord = " sagpa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sasabihin ", CebuanoWord = " sultihan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sasama ", CebuanoWord = " mokuyog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sasama ", CebuanoWord = " manguyog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sayaw ", CebuanoWord = " sayaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sayo ", CebuanoWord = " sayo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " septyempre ", CebuanoWord = " septyempre ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sibuyas ", CebuanoWord = " sibuyas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sigaw ", CebuanoWord = " singgit ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sige ", CebuanoWord = " sige ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sigurado ", CebuanoWord = " segurado ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sikat ", CebuanoWord = " gibantog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sinabi ", CebuanoWord = " gisultihan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sinagot ", CebuanoWord = " balusi ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sino ", CebuanoWord = " kinsa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sino ", CebuanoWord = " kinsa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sinsero ", CebuanoWord = " matinuuron ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sipa ", CebuanoWord = " sipa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sitaw ", CebuanoWord = " balatong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " spinach ", CebuanoWord = " ispinaka ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " suka ", CebuanoWord = " suka ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sulatan ", CebuanoWord = " sulati ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sumagot ", CebuanoWord = " pagtubag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sumagot ", CebuanoWord = " mosugot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sumisigaw ", CebuanoWord = " nagsinggit ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sunod ", CebuanoWord = " sunod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " suntok ", CebuanoWord = " sumbag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " suso ", CebuanoWord = " umang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " susulatan ", CebuanoWord = " mosulat ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " sususod ", CebuanoWord = " umaabot ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " taas ", CebuanoWord = " taas ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tahimik ", CebuanoWord = " hilumon ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tainga ", CebuanoWord = " dalunggan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " takbo ", CebuanoWord = " dagan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " talaga ", CebuanoWord = " lagi ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " talaga ", CebuanoWord = " bitaw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " talon ", CebuanoWord = " lukso ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tamad ", CebuanoWord = " tapulan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tamis ", CebuanoWord = " tam-is ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tanggihan ", CebuanoWord = " mobalibad ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tanghali ", CebuanoWord = " udto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tanghali ", CebuanoWord = " udto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tanghali ", CebuanoWord = " udto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " taon ", CebuanoWord = " tuig ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tapon ", CebuanoWord = " labay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tara na ", CebuanoWord = " tana ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tatakan ", CebuanoWord = " tindak ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tatay ", CebuanoWord = " amahan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tawa ", CebuanoWord = " katawa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tawag ", CebuanoWord = " tawag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tigil ", CebuanoWord = " hunong ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tinatanong ", CebuanoWord = " nangutana ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tingnan ", CebuanoWord = " tan'awa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tita ", CebuanoWord = " tiya ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tita ", CebuanoWord = " iyaan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tito ", CebuanoWord = " tiyo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tito ", CebuanoWord = " uyuan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tiyan ", CebuanoWord = " tiyan ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " totoo ", CebuanoWord = " tinuod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tuhod ", CebuanoWord = " tuhod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tulak ", CebuanoWord = " tulod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tumango ", CebuanoWord = " tando ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tumatawa ", CebuanoWord = " nagkatawa ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tumayo ", CebuanoWord = " pagtindog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tumayo ", CebuanoWord = " tindog ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tumingin ", CebuanoWord = " tan-aw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tumitingin ", CebuanoWord = " nagtan-aw ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " tunay ", CebuanoWord = " diay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ubo ", CebuanoWord = " ubo ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " ulit ", CebuanoWord = " usab ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " umaga ", CebuanoWord = " buntag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " umaga ", CebuanoWord = " buntag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " umalis ", CebuanoWord = " miadto ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " umiiyak ", CebuanoWord = " naghilak ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " unggoy ", CebuanoWord = " unggoy ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " upang ", CebuanoWord = " aron ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " upo ", CebuanoWord = " lingkod ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " upo ", CebuanoWord = " tabayag ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " wala ", CebuanoWord = " wala'y ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " wala ", CebuanoWord = " gidili ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " walang kuwenta ", CebuanoWord = " binuang ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " walis ", CebuanoWord = " silhig ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " wow ", CebuanoWord = " ayay ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " yakap ", CebuanoWord = " gakos ", Cost = 0, Status = 0},
new Dictionary {TagalogWord = " yan ", CebuanoWord = " niana ", Cost = 0, Status = 0},
};
try
{
var db = new SQLiteConnection(path);
if (db.InsertAll(mlistWords) != 0)
{
db.UpdateAll(mlistWords);
}
}
catch (SQLiteException)
{
}
}
//-----------Insert an ArrayList and update Databse---------//
private string insertUpdateAllData(IEnumerable<User> data, string path)
{
try
{
var db = new SQLiteConnection(path);
if (db.InsertAll(data) != 0)
db.UpdateAll(data);
return "List of data inserted or updated";
}
catch (SQLiteException ex)
{
return ex.Message;
}
}
//end of Trivia Database
//Tip Database
private static void fillTip(){
var data = new List<Tip>
{
new Tip { TipPhrase = "TIP 01: Kumausap ng mga taong mahusay mag-Cebuano"},
new Tip { TipPhrase = "TIP 02: Wag pwersahin ang sarili sa pagkatuto"},
new Tip { TipPhrase = "TIP 03: Magsimula muna sa mga ordinaryong salita"},
new Tip { TipPhrase = "TIP 04: Basahin at gamitin ang diskyunaryo sa app na ito"},
new Tip { TipPhrase = "TIP 05: Mag-ensayo ng mga pangungusap sa iyong isip"},
new Tip { TipPhrase = "TIP 06: Tanggapin lamang na natural magkamali sa umpisa"},
new Tip { TipPhrase = "TIP 07: Ang tamang pagbigkas sa mga salita ay mahalaga"},
new Tip { TipPhrase = "TIP 08: Pakinggan mabuti ang mga tamang pagbigkas na maririnig dito"},
new Tip { TipPhrase = "TIP 09: Ang madalas na paggamit ng mga natutunang salita ay makakatulong"},
new Tip { TipPhrase = "TIP 10: Makinig o manuod ng mga palabas o tugtuging Cebuano"},
new Tip { TipPhrase = "TIP 11: Gawing masaya ang pagkatuto ng Cebuano"},
new Tip { TipPhrase = "TIP 12: Ang mga naipong \"coins\" ay maaring ipambili ng mga salita o ekspresyon"}
};
try
{
var db = new SQLiteConnection(path);
if (db.InsertAll(data) != 0){
db.UpdateAll(data);
}
}
catch (SQLiteException ex)
{
Console.Write (ex.Message);
}
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
// Create your application here
SetContentView(Resource.Layout.Update);
var buttonUpdate = FindViewById<Button>(Resource.Id.buttonUpdate);
var textViewCurrentVersion = FindViewById<TextView>(Resource.Id.textViewCurrentVersion);
var textViewLatestVersion = FindViewById<TextView>(Resource.Id.textViewLatestVersion);
var progressBarUpdate = FindViewById<ProgressBar>(Resource.Id.progressBarUpdate);
var buttonAppUpdate = FindViewById<Button>(Resource.Id.buttonAppUpdate);
var textViewCurrentAppVersion = FindViewById<TextView>(Resource.Id.textViewCurrentAppVersion);
var textViewLatestAppVersion = FindViewById<TextView>(Resource.Id.textViewLatestAppVersion);
progressBarUpdate.Visibility = ViewStates.Invisible;
var preference = GetSharedPreferences("settings", FileCreationMode.WorldWriteable);
var editor = preference.Edit();
if (!preference.Contains("version"))
{
editor.PutString("version", "20150504");
editor.Commit();
}
textViewCurrentVersion.Text = preference.GetString("version", "20150504");
editor.PutString("appVersion", PackageManager.GetPackageInfo(PackageName, 0).VersionName);
editor.Commit();
textViewCurrentAppVersion.Text = preference.GetString("appVersion", "0");
buttonUpdate.Click += async (sender, e) =>
{
try
{
buttonUpdate.Enabled = false;
buttonUpdate.Text = "正在更新";
var requestVersion = WebRequest.Create("http://kidfruit.github.io/WisdriContacts/LatestDataVersion.txt?" + Guid.NewGuid().ToString());
requestVersion.Method = "GET";
using (var response = await requestVersion.GetResponseAsync())
{
using (var responseStream = response.GetResponseStream())
{
using (var sr = new StreamReader(responseStream, Encoding.UTF8))
{
var receive = sr.ReadToEnd();
textViewLatestVersion.Text = receive;
}
}
}
if (!string.IsNullOrEmpty(textViewLatestVersion.Text.Trim()) &&
textViewCurrentVersion.Text != textViewLatestVersion.Text)
{
progressBarUpdate.Visibility = ViewStates.Visible;
var request = WebRequest.Create("http://kidfruit.github.io/WisdriContacts/data.txt?" + Guid.NewGuid().ToString());
request.Method = "GET";
using (var response = await request.GetResponseAsync())
{
using (var responseStream = response.GetResponseStream())
{
using (var sr = new StreamReader(responseStream, Encoding.GetEncoding("UTF-8")))
{
int count = 0;
long length = responseStream.Length;
byte[] receiveStream = new byte[length];
progressBarUpdate.Visibility = ViewStates.Visible;
progressBarUpdate.Indeterminate = false;
progressBarUpdate.Max = (int)length;
progressBarUpdate.Progress = 0;
while (true)
{
int readLength = (int)(length - count > 1000 ? 1000 : length - count);
int num = await responseStream.ReadAsync(receiveStream, count, readLength);
if (num == 0)
break;
count += num;
progressBarUpdate.Progress = count;
}
var receive = Encoding.UTF8.GetString(receiveStream, 0, (int)length);
//var receive = await sr.ReadToEndAsync();
var byteValue = Convert.FromBase64String(receive);
string decodeReceive = Encoding.UTF8.GetString(byteValue, 0, byteValue.Length);
var personList = JsonConvert.DeserializeObject<List<PERSON>>(decodeReceive);
var dbFile = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "contacts.db");
using (SQLiteConnection conn = new SQLiteConnection(dbFile))
{
try
{
var sql = "delete from PERSON";
int oldDataCount = conn.Execute(sql);
new AlertDialog.Builder(this).SetMessage(string.Format("旧数据有{0}条", oldDataCount)).Show();
sql = "DROP TABLE [PERSON];";
conn.Execute(sql);
sql = @"CREATE TABLE [PERSON] (
[ID] nvarchar(2147483647) NOT NULL
, [NAME] nvarchar(2147483647) NULL
, [DEPARTMENT] nvarchar(2147483647) NULL
, [MOBILE_PHONE] nvarchar(2147483647) NULL
, [VIRTUAL_PHONE] nvarchar(2147483647) NULL
, [POSITION] nvarchar(2147483647) NULL
, [REGION] nvarchar(2147483647) NULL
, [OFFICE_PHONE] nvarchar(2147483647) NULL
, [INNER_PHONE] nvarchar(2147483647) NULL
, [PY] nvarchar(2147483647) NULL
, [CAR] nvarchar(2147483647) NULL
, CONSTRAINT [sqlite_autoindex_PERSON_1] PRIMARY KEY ([ID])
);";
conn.Execute(sql);
conn.BeginTransaction();
conn.InsertAll(personList);
textViewCurrentVersion.Text = textViewLatestVersion.Text;
editor.PutString("version", textViewCurrentVersion.Text);
editor.Commit();
sql = "select count(ID) from PERSON";
int newDataCount = conn.ExecuteScalar<int>(sql);
new AlertDialog.Builder(this).SetMessage(string.Format("新数据有{0}条", newDataCount)).Show();
conn.Commit();
new AlertDialog.Builder(this).SetMessage("更新完毕").SetPositiveButton("确定", delegate
{
}).Show();
}
catch (Exception ex)
{
conn.Rollback();
new AlertDialog.Builder(this).SetMessage(ex.Message).Show();
}
}
}
}
}
}
else
{
new AlertDialog.Builder(this).SetMessage("无需更新").Show();
}
}
catch (System.Exception ex)
{
new AlertDialog.Builder(this).SetMessage(ex.Message).Show();
}
finally
{
progressBarUpdate.Visibility = ViewStates.Invisible;
buttonUpdate.Enabled = true;
buttonUpdate.Text = "更新数据";
}
};
buttonAppUpdate.Click += async (sender, e) =>
{
try
{
buttonAppUpdate.Enabled = false;
var requestAppVersion = WebRequest.Create("http://kidfruit.github.io/WisdriContacts/LatestAndroidVersion.txt?" + Guid.NewGuid().ToString());
requestAppVersion.Method = "GET";
using (var response = await requestAppVersion.GetResponseAsync())
{
using (var responseStream = response.GetResponseStream())
{
using (var sr = new StreamReader(responseStream, Encoding.UTF8))
{
var receive = sr.ReadToEnd();
textViewLatestAppVersion.Text = receive;
}
}
}
buttonAppUpdate.Enabled = true;
if (!string.IsNullOrEmpty(textViewLatestAppVersion.Text.Trim()) &&
textViewCurrentAppVersion.Text != textViewLatestAppVersion.Text)
{
var uri = Android.Net.Uri.Parse("http://pan.baidu.com/s/1ntypvj7");
var intent = new Intent(Intent.ActionView, uri);
StartActivity(intent);
new AlertDialog.Builder(this).SetMessage("下载更新包").Show();
}
else
{
new AlertDialog.Builder(this).SetMessage("无需更新").Show();
}
}
catch (System.Exception ex)
{
new AlertDialog.Builder(this).SetMessage(ex.Message).Show();
}
finally
{
progressBarUpdate.Visibility = ViewStates.Invisible;
}
};
}
private void SetupDb()
{
string dbname = "onerm.db";
string documents = Environment.GetFolderPath (Environment.SpecialFolder.Personal); // This goes to the documents directory for your app
string dbPath = Path.Combine (documents, dbname);
db = new SQLiteConnection (dbPath);
db.CreateTable<Exercise> ();
this.exercises = db.Query<Exercise> ("select * from Exercise");
// populate the database
if (exercises.Count () < 3) {
Exercise bench = new Exercise {
Name = "Bench Press"
};
Exercise squat = new Exercise {
Name = "Squat"
};
Exercise deadlift = new Exercise {
Name = "Deadlift"
};
db.InsertAll(new[] { bench, squat, deadlift }, false);
this.exercises = db.Query<Exercise> ("select * from Exercise");
}
}
//Trivia Database
private static void fillTrivia(){
var data = new List<Trivia>
{
new Trivia { TrivPhrase = "#001 Alam mo bang ang Cebuano ay tinatawag ring Bisaya?"},
new Trivia { TrivPhrase = "#002 Alam mo bang mahigit kumulang 20 milyong tao ang gumagamit sa dialektong Cebuano?"},
new Trivia { TrivPhrase = "#003 Alam mo bang ang araw ng pagkakatatag ng Cebu ay sa ika-6 ng Agosto?"},
new Trivia { TrivPhrase = "#004 Alam mo bang sa Cebu naganap ang paglalaban nina Lapu-Lapu at Magellan?"},
new Trivia { TrivPhrase = "#005 Alam mo bang nasa Cebu ang pinakamatandang relikang Kristiyano ng Pilipinas?"},
new Trivia { TrivPhrase = "#006 Alam mo bang nataguriang Queen City of the South ang Cebu?"},
new Trivia { TrivPhrase = "#007 Alam mo bang ang mga sinunang Cebuano ay gumagamit ng alahas na yari sa ari ng hayop o tao?"},
new Trivia { TrivPhrase = "#008 Alam mo bang karamihan sa mga salitang Cebuano ay sa wikang Espanyol rin nagmula?"},
new Trivia { TrivPhrase = "#009 Alam mo bang ang Cebuano ay unang isinulat ni Antonio Pigafetta?"},
new Trivia { TrivPhrase = "#010 Alam mo bang ang dialektong Cebuano ay mayroon lamang tatlong patinig noong panahon ng mga Espanyol?"},
new Trivia { TrivPhrase = "#011 Alam mo bang may tinatawag ring Mindanao Cebuano, Luzon Cebuano, and Negrense Cebuano?"},
new Trivia { TrivPhrase = "#012 Alam mo bang kaisa ang Cebuano sa Borneo-Philippines Languages?"},
new Trivia { TrivPhrase = "#013 Alam mo bang ang Cebuano ay may 16 na katinig at limang patinig?"},
new Trivia { TrivPhrase = "#014 Alam mo bang ang tawag sa mga nagsasalita ng Cebuano sa Luzon at Mindanao ay Binisaya?"},
new Trivia { TrivPhrase = "#015 Alam mo bang ang tawag sa mga nagsasalita ng Cebuano sa Bohol ay Bol-anon?"},
new Trivia { TrivPhrase = "#016 Alam mo bang ang Cebuano ang pangunahing dialekto sa Western Leyte?"},
new Trivia { TrivPhrase = "#017 Alam mo bang noong 18th century nagsimulang gamitin ng mga Misyonaryong Espanyol ang dialektong Cebuano sa pagsusulat?"}
};
try
{
var db = new SQLiteConnection(path);
if (db.InsertAll(data) != 0){
db.UpdateAll(data);
}
}
catch (SQLiteException ex)
{
Console.Write (ex.Message);
}
}
public static void fillPhrases(){
var peopleList = new List<Phrases>
{
new Phrases { TagalogPhrase = "Magandang Hapon", CebuanoPhrase = "Maayong hapon.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Magandang Araw", CebuanoPhrase = "Maayong adlaw sa imo.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Magandang Gabi", CebuanoPhrase = "Maayong gabii.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Goodluck", CebuanoPhrase = "Maayo unta swertihon!", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Magandang Umaga", CebuanoPhrase = "Maayong buntag.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Hello, Kumusta ka?", CebuanoPhrase = "Uy, kumusta man ka?", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Hindi ko maintindihan.", CebuanoPhrase = "Wala ko kasabot.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Naiintidihan ko.", CebuanoPhrase = "Nakasabot ko.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Ayos lang ako.", CebuanoPhrase = "Maayo man ko.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Matagal na panahong di nagkita.", CebuanoPhrase = "Dugayng panahon wala ta nagkita", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Ang pangalan ko ay Juan.", CebuanoPhrase = "Ang akong ngalan kay Juan.", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Maligayang Pagdating.", CebuanoPhrase = "Maayong pag-abot", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Anong pangalan mo?", CebuanoPhrase = "Unsa'y imong ngalan?", Cost = 0, Status = 0},
new Phrases { TagalogPhrase = "Taga-saan ka?", CebuanoPhrase = "Taga-asa ka?", Cost = 0, Status = 0}
};
try
{
var db = new SQLiteConnection(path);
if (db.InsertAll(peopleList) != 0)
{
db.UpdateAll(peopleList);
}
}
catch (SQLiteException)
{
}
}
public static void AggiungiTutti(List<customers> c)
{
string dbPath = Path.Combine (Environment.GetFolderPath (Environment.SpecialFolder.Personal), "cust.db");
var db = new SQLiteConnection (dbPath);
db.InsertAll (c);
}
private static void CreateDataFromServerInformation()
{
// Populate the manga list from the server information
WebData web = new WebData();
IEnumerable<Manga> mangas = web.GetMangas();
// HACK: Disabled for testing, if hitting the real server this will produce more than 20k web calls to get images for all the mangas.
// Get additional summary and background images from the server
//LocalData.UpdateImageFolderFromServer(backgroundFolder, Constants.DefaultImageName, () => web.GetDefaultBackgroundImages()).Wait();
//LocalData.UpdateImageFolderFromServer(summaryFolder, Constants.DefaultImageName, () => web.GetDefaultSummaryImages()).Wait();
foreach (var manga in mangas)
{
CreateSummaryImageFromRemoteUrl(manga); // TODO: this is not necessary once we have GetSummaryImages working in the server
//LocalData.UpdateImageFolderFromServer(backgroundFolder, manga.Title, () => web.GetBackgroundImages(manga)).Wait();
//LocalData.UpdateImageFolderFromServer(summaryFolder, manga.Title, () => web.GetSummaryImages(manga)).Wait();
}
// Add mangas to the database
using (SQLiteConnection db = new SQLiteConnection(Path.Combine(ApplicationData.Current.LocalFolder.Path, Constants.DbName)))
{
db.CreateTable<LocalDataVersion>();
db.CreateTable<Manga>();
db.CreateTable<Provider>();
db.Insert(new LocalDataVersion(web.MangaListVersion));
db.InsertAll(mangas);
}
}