//Assumption: index should be valid
public void download(int index)
{
int curDid;
netDeck deck = (netDeck)remoteDecks[index];
try
{
deck.loadBLOB();
}
catch
{
MessageBox.Show("Failure Downloading Deck !!!", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
try
{
curDid = Util.parseBLOB(deck.getBLOB(), uid);
insertLocalDB.insertToUnranked(curDid, deck.id, netID, deck.netID);
deck.savePreview(curDid);
}
catch (Exception ex)
{
MessageBox.Show("Error Reading Malformed Deck !!!" + ex.Message, "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
MessageBox.Show(deck.title + " Downloaded Successfully !!!", "Success",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void Preview_Click(object sender, EventArgs e)
{
Bitmap preview;
TreeNode selectedNode = localTree.SelectedNode;
// Is the selected node a deck?
if (selectedNode != null && selectedNode.LastNode == null && selectedNode != localTree.TopNode)
{
netDeck ndeck = brwApp.downloadRankerPreview(Convert.ToInt32(selectedNode.Name));
label2.Text = ndeck.category;
label7.Text = ndeck.title;
if (ndeck.subcategory != null)
{
label8.Text = ndeck.subcategory;
}
else
{
label8.Text = "none";
}
label9.Text = "" + ndeck.rat;
preview = ndeck.preview;
pictureBox1.Image = preview;
}
else
{
MessageBox.Show("Please choose a valid unranked deck.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//Assumption: index should be valid
public netDeck downloadPreview(int index)
{
netDeck deck = (netDeck)remoteDecks[index];
try
{
deck.loadPreview();
return(deck);
}
catch
{
return(null);
}
}
//IF nuid == 0, getAllDecks belonging to all users
public static List <netDeck> getDecks(int nuid)
{
string SQL;
List <netDeck> deckList = new List <netDeck>();
MySqlCommand cmd = new MySqlCommand();
MySqlDataReader myData;
connect();
try
{
if (nuid == 0)
{
SQL = "SELECT ndid,cat,subcat,title,date,rat,num_v,nuid FROM networkdecks WHERE 1" + " ORDER BY cat, title";
}
else
{
SQL = "SELECT ndid,cat,subcat,title,date,rat,num_v,nuid FROM networkdecks WHERE nuid = " + Convert.ToString(nuid) + " ORDER BY cat, title";
}
cmd.Connection = conn;
cmd.CommandText = SQL;
myData = cmd.ExecuteReader();
while (myData.Read())
{
netDeck deck = new netDeck(myData.GetInt32(myData.GetOrdinal("ndid")),
myData.GetString(myData.GetOrdinal("cat")),
myData.GetString(myData.GetOrdinal("subcat")),
myData.GetString(myData.GetOrdinal("title")),
myData.GetString(myData.GetOrdinal("date")),
myData.GetFloat(myData.GetOrdinal("rat")),
myData.GetInt32(myData.GetOrdinal("num_v")),
myData.GetInt32(myData.GetOrdinal("nuid")));
deckList.Add(deck);
}
myData.Close();
conn.Close();
return(deckList);
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
conn.Close();
throw new Exception();
}
}
public netDeck downloadRankerPreview(int index)
{
Deck deck = (Deck)localDecks[index];
int remoteDeck = selectLocalDB.getRemoteDeck(deck.id);
netDeck ndeck = remoteDB.getSpecificDeck(remoteDeck);
try
{
ndeck.loadPreview();
return(ndeck);
}
catch
{
return(null);
}
}
//Assumption: index should be valid
public void delRemote(int index)
{
netDeck deck = (netDeck)remoteDecks[index];
try
{
remoteDB.deleteDeck(deck.id);
}
catch
{
MessageBox.Show("Error Deleting " + deck.title + "!!!", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
MessageBox.Show(deck.title + " Deleted Successfully !!!", "Success",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public static List <netDeck> searchDeck(string[] searchStr, string opt)
{
string SQL;
List <netDeck> deckList = new List <netDeck>();
MySqlCommand cmd = new MySqlCommand();
MySqlDataReader myData;
connect();
try
{
SQL = "SELECT ndid,cat,subcat,title,date,rat,num_v,nuid FROM networkdecks WHERE 0 ";
switch (opt)
{
case ("Category"):
foreach (string s in searchStr)
{
SQL += " OR LOWER(cat) LIKE " + "'%" + s.ToLower() + "%'";
}
break;
case ("Title"):
foreach (string s in searchStr)
{
SQL += " OR LOWER(title) LIKE " + "'%" + s.ToLower() + "%'";
}
break;
case ("Sub-Category"):
foreach (string s in searchStr)
{
SQL += " OR LOWER(subcat) LIKE " + "'%" + s.ToLower() + "%'";
}
break;
default:
SQL = "SELECT nd.ndid,cat,subcat,title,date,rat,num_v,nd.nuid FROM networkdecks nd, networkusers nu WHERE nu.nuid = nd.nuid AND (0";
foreach (string s in searchStr)
{
SQL += " OR LOWER(nu.nname) LIKE " + "'%" + s.ToLower() + "%'";
}
SQL += ")";
break;
}
SQL += " ORDER BY cat, title";
cmd.Connection = conn;
cmd.CommandText = SQL;
myData = cmd.ExecuteReader();
while (myData.Read())
{
netDeck deck = new netDeck(myData.GetInt32(myData.GetOrdinal("ndid")),
myData.GetString(myData.GetOrdinal("cat")),
myData.GetString(myData.GetOrdinal("subcat")),
myData.GetString(myData.GetOrdinal("title")),
myData.GetString(myData.GetOrdinal("date")),
myData.GetFloat(myData.GetOrdinal("rat")),
myData.GetInt32(myData.GetOrdinal("num_v")),
myData.GetInt32(myData.GetOrdinal("nuid")));
deckList.Add(deck);
}
myData.Close();
conn.Close();
return(deckList);
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
conn.Close();
throw new Exception();
}
}
