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);
}
}
public void AddToTable(List <StoredAttribute> attlist, StoredAttribute key, string tablename)
{
//probably obsolete
//if( isfirstnode )
//{
//need to add columns for each row, because could be new column after first group
AddColumns(tablename, attlist);
//}
InsertKeyRow(tablename, key);
UpdateRow(tablename, key, attlist);
}
public void AddAttribute(StoredAttribute att, Hashtable ht)
{
object valobj = ht [att.name];
if (valobj != null)
{
string sval = valobj.ToString();
att.Set(sval);
attributes.Add(att);
}
}
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);
}
/// <summary>
/// Select by key overload
/// </summary>
/// <returns>Hashtable of results</returns>
/// <param name="tablename">Tablename.</param>
/// <param name="keyatt">Keyatt.</param>
public List <Hashtable> Select(string tablename, StoredAttribute keyatt)
{
return(Select(tablename, keyatt, false));
}
