private dynamic ParseDelete(string statement) { dynamic delete = new ExpandoObject(); delete.Type = "DELETE"; if (!statement.Contains("WHERE")) { var tableName = SubstringExtensions.Between(statement, "DELETE FROM", ";", true); delete.Table = tableName; } else { var tableName = SubstringExtensions.Between(statement, "DELETE FROM", "WHERE", true); delete.Table = tableName; dynamic wherExpandoObject = new ExpandoObject(); var whereText = SubstringExtensions.Between(statement, "WHERE", ";", true); int counter = 0; foreach (var oper in ComparisonOperators) { if (whereText.Contains(oper)) { dynamic critera = new ExpandoObject(); critera.Left = SubstringExtensions.Before(whereText, oper); critera.Operator = oper; critera.Right = SubstringExtensions.After(whereText, oper); AddProperty(wherExpandoObject, counter++.ToString(), critera); } } AddProperty(delete, "Where", wherExpandoObject); } return(delete); }
/// <summary> /// Clears and re-creates the dropdown selection of League of Legends versions /// </summary> internal void UpdateMainTopBarVersions() { try { //Get current selected verions string currentVersion = ""; if (dropDownButtonRiotVersion.Text.Contains(" ")) { currentVersion = SubstringExtensions.Before(dropDownButtonRiotVersion.Text, " "); } else { currentVersion = dropDownButtonRiotVersion.Text; } //If the selected version is still current then add back in the " Current LoL" if (currentVersion == form1.getAllVersionAvailable.realm.V) { currentVersion += " Current LoL"; } popupMenuVersions.ItemLinks.Clear(); foreach (string s in form1.getAllVersionAvailable.versions) { BarButtonItem barButtonItemNew = new BarButtonItem(); if (form1.getAllVersionAvailable.realm.V == s) { barButtonItemNew.Caption = s + " Current LoL"; if (currentVersion.Length < 2) { dropDownButtonRiotVersion.Text = barButtonItemNew.Caption; } else { dropDownButtonRiotVersion.Text = currentVersion; } } else { barButtonItemNew.Caption = s; } barButtonItemNew.ItemClick += barButtonItemVersionList_ItemClick; barButtonItemNew.Name = s; popupMenuVersions.AddItem(barButtonItemNew); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private static void ItemCorrection(ItemStatic temp) { string descriptionMain; List <string> uniqueDescriptions = new List <string>(); if (temp.SanitizedDescription.Contains("UNIQUE")) { descriptionMain = SubstringExtensions.Before(temp.SanitizedDescription, "UNIQUE"); int i = 0; while ((i = temp.Description.IndexOf("UNIQUE", i)) != -1) { int j = temp.Description.IndexOf("<br>", i); if (j == -1) { j = temp.Description.Length; } string uniqueDescription = temp.Description.Substring(i, j - i); if (!uniqueDescription.Contains("UNIQUE Active") && //Todo: All of these should instead of being ignored should be filtered on the Stats Tab and Activatable Items or On/Off !uniqueDescription.Contains("UNIQUE Passive - Point Runner:") && !uniqueDescription.Contains("UNIQUE Passive - Furor:") && !uniqueDescription.Contains("UNIQUE Passive - Captain:") && !uniqueDescription.Contains("UNIQUE Passive - Spellblade:") && !uniqueDescription.Contains("Falling below 50% Health grants")) { uniqueDescriptions.Add(uniqueDescription); } i++; } } else { descriptionMain = temp.SanitizedDescription; } StatCorrection(descriptionMain, temp.Stats); int ind = 0; temp.UniqueStats = new List <KeyValuePair <string, StatsStatic> >(); foreach (string s in uniqueDescriptions) { if (s.Contains("UNIQUE Passive:") || s.Contains("UNIQUE Aura:")) { if (temp.Name.Contains("Ionia")) { string tempNametest = SubstringExtensions.Before(temp.Name, " - "); } else { string tempNametest = temp.Name; } string tempName = (temp.Name.Contains(" - ")) ? SubstringExtensions.Before(temp.Name, " - ") : temp.Name; temp.UniqueStats.Add(new KeyValuePair <string, StatsStatic>(tempName + "~" + s, new StatsStatic())); } else if (s.Contains("UNIQUE Passive - Enhanced Movement")) { temp.UniqueStats.Add(new KeyValuePair <string, StatsStatic>(SubstringExtensions.Before(s, ":"), new StatsStatic())); temp.UniqueStats[ind].Value.FlatMovementSpeedMod = temp.Stats.FlatMovementSpeedMod; temp.Stats.FlatMovementSpeedMod = 0.0; } else { temp.UniqueStats.Add(new KeyValuePair <string, StatsStatic>(SubstringExtensions.Before(s, ":"), new StatsStatic())); } StatCorrection(s, temp.UniqueStats[ind].Value); ind++; } }