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); } }