public void InsertKeyRow(string tablename, StoredAttribute keyentry)
{
try
{
MySqlCommand odbccommand = new MySqlCommand("INSERT IGNORE INTO "
+ tablename
+ " ("
+ keyentry.name
+ ") VALUES ( ? )", connection);
odbccommand.Parameters.Add(new MySqlParameter(@"@" + keyentry.name, keyentry.type)).Value = keyentry.GetString();
DoQuery(odbccommand);
}
catch (Exception ex)
{
throw new Exception("Error with key value " + keyentry.GetString() + " for column " + keyentry.name + ": " + ex.Message);
}
}
protected List <Hashtable> Select(string tablename, StoredAttribute keyatt, bool selectall)
{
MySqlDataReader myReader;
DataTable dt = new DataTable();
List <Hashtable> hashlist = new List <Hashtable>();
try
{
string commandstr = "SELECT * FROM " + tablename;
if (!selectall)
{
commandstr += " WHERE " + keyatt.name + "= ? ";
}
MySqlCommand odbccommand = new MySqlCommand(commandstr, connection);
if (!selectall)
{
odbccommand.Parameters.Add(new MySqlParameter(@"@" + keyatt.name, keyatt.type)).Value = keyatt.GetString();
}
// load to dt
myReader = odbccommand.ExecuteReader();
dt.Load(myReader);
// actually let's make it a list of hashtables
hashlist = Util.convertDataTableToHashTables(dt);
myReader.Close();
}
catch (Exception ex)
{
throw new Exception("Error with key value " + keyatt.GetString() + " for column " + keyatt.name + ": " + ex.Message);
}
// I'll deal with the connection later if I remember. I probably won't remember.
myReader.Close();
return(hashlist);
}
public void UpdateRow(string tablename, StoredAttribute keyentry, List <StoredAttribute> attlist)
{
string eqstring = "";
attlist.Remove(keyentry);
foreach (StoredAttribute att in attlist)
{
if (eqstring.Length > 0)
{
eqstring = eqstring + ",";
}
eqstring = eqstring + att.name + "= ? ";
}
try
{
MySqlCommand odbccommand = new MySqlCommand("UPDATE " + tablename + " SET " + eqstring + " WHERE " + keyentry.name + "= ?", connection);
foreach (StoredAttribute att in attlist)
{
odbccommand.Parameters.Add(new MySqlParameter(@"@" + att.name, att.type)).Value = att.GetString();
}
//odbccommand = AddParameters( odbccommand, rowdict );
//odbccommand.Parameters.AddWithValue( "@sqlname", keyentry.SqlName );
//odbccommand.Parameters.AddWithValue( "?keyval", keyentry.value );
odbccommand.Parameters.Add(new MySqlParameter(@"@" + keyentry.name, keyentry.type)).Value = keyentry.GetString();
DoQuery(odbccommand);
}
catch (Exception ex)
{
throw new Exception("Error with updating row " + keyentry.ToString() + " in table " + tablename + ": " + ex.Message);
}
}