public void saveDetailEntry(HeroDetailsEntry DetailEntry)
{
try
{
using (SQLiteConnection conn = new SQLiteConnection(@"Data Source=" + dbPath + @"\gv.db;Version=3;New=False;Compress=True;"))
{
conn.Open();
using (SQLiteCommand cmd = conn.CreateCommand())
{
string commandText = "insert into Detail (HeroName, Updated, Enemy, TopMessage, BottomMessage, Progress) values (@HeroName, @Updated, @Enemy, @TopMessage, @BottomMessage, @Progress)";
cmd.Parameters.AddWithValue("@HeroName", this.Name);
cmd.Parameters.AddWithValue("@Updated", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@Enemy", (DetailEntry.Enemy ?? ""));
cmd.Parameters.AddWithValue("@TopMessage", (DetailEntry.TopMessage ?? ""));
cmd.Parameters.AddWithValue("@BottomMessage", (DetailEntry.BottomMessage ?? ""));
cmd.Parameters.AddWithValue("@Progress", DetailEntry.Progress.ToString());
cmd.CommandText = commandText;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
throw;
}
}
public void saveDetailEntry(HeroDetailsEntry DetailEntry)
{
try
{
using (SQLiteConnection conn = new SQLiteConnection(@"Data Source=" + dbPath + @"\gv.db;Version=3;New=False;Compress=True;"))
{
conn.Open();
using (SQLiteCommand cmd = conn.CreateCommand())
{
string commandText = "insert into Detail (HeroName, Updated, Enemy, TopMessage, BottomMessage, Progress) values (@HeroName, @Updated, @Enemy, @TopMessage, @BottomMessage, @Progress)";
cmd.Parameters.AddWithValue("@HeroName", this.Name);
cmd.Parameters.AddWithValue("@Updated", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("@Enemy", (DetailEntry.Enemy ?? ""));
cmd.Parameters.AddWithValue("@TopMessage", (DetailEntry.TopMessage ?? ""));
cmd.Parameters.AddWithValue("@BottomMessage", (DetailEntry.BottomMessage ?? ""));
cmd.Parameters.AddWithValue("@Progress", DetailEntry.Progress.ToString());
cmd.CommandText = commandText;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
throw;
}
}
private bool earthlyNews()
{
// Parse the rotating Earthly News section
try
{
HtmlElement elem = webBrowser1.Document.GetElementById("news");
if (elem != null)
{
if (elem.Children.Count > 1)
{
bool itemAdded = false;
HtmlElementCollection items = elem.Children[1].Children[0].Children;
HeroDetailsEntry details = new HeroDetailsEntry();
details.TopMessage = items[0].Children[0].InnerText;
details.Enemy = items[0].Children[1].InnerText;
string progress = items[0].Children[2].Title().Replace("%", "").Replace("NaN", "0");
details.Progress = int.Parse(progress);
details.BottomMessage = items[1].InnerText;
progress = items[2].Title().Replace("%", "").Replace("NaN", "0");
details.Progress2 = int.Parse(progress);
itemAdded = true;
if (itemAdded)
{
if (!hero.DetailsEntries.Contains(details))
{
hero.DetailsEntries.Add(details);
hero.saveDetailEntry(details);
}
}
if (hero.DetailsEntries.Count > 0)
tbxNews.Text = String.Format("{0}\r\n{1}",
String.IsNullOrEmpty(hero.DetailsEntries[hero.DetailsEntries.Count - 1].Enemy) ?
hero.DetailsEntries[hero.DetailsEntries.Count - 1].TopMessage :
hero.DetailsEntries[hero.DetailsEntries.Count - 1].Enemy,
hero.DetailsEntries[hero.DetailsEntries.Count - 1].BottomMessage);
}
}
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
throw;
}
}