/// <summary>
/// Read uploaded nanos from database
/// TODO: catch exceptions
/// </summary>
public void readUploadedNanosfromSQL()
{
lock (UploadedNanos)
{
UploadedNanos.Clear();
SqlWrapper Sql = new SqlWrapper();
DataTable dt = Sql.ReadDT("SELECT nano FROM " + getSQLTablefromDynelType() + "uploadednanos WHERE ID=" + ID.ToString());
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
AOUploadedNanos au = new AOUploadedNanos();
au.Nano = (Int32)row["Nano"];
UploadedNanos.Add(au);
}
}
}
}
/// <summary>
/// Read uploaded nanos from database
/// TODO: catch exceptions
/// </summary>
public void ReadUploadedNanosFromSql()
{
lock (this.uploadedNanos)
{
this.uploadedNanos.Clear();
SqlWrapper Sql = new SqlWrapper();
DataTable dt =
Sql.ReadDatatable(
"SELECT nano FROM " + this.GetSqlTablefromDynelType() + "uploadednanos WHERE ID="
+ this.Id.ToString());
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
AOUploadedNanos au = new AOUploadedNanos { Nano = (Int32)row["Nano"] };
this.uploadedNanos.Add(au);
}
}
}
}
/// <summary>
/// Upload a nano
/// </summary>
/// <param name="_id">Nano-ID</param>
public void UploadNano(int _id)
{
lock (UploadedNanos)
{
AOUploadedNanos au = new AOUploadedNanos();
au.Nano = _id;
UploadedNanos.Remove(au); // In case its in already :)
UploadedNanos.Add(au);
}
}
/// <summary>
/// Upload a nano
/// </summary>
/// <param name="nanoId">Nano-ID</param>
public void UploadNano(int nanoId)
{
lock (this.uploadedNanos)
{
AOUploadedNanos au = new AOUploadedNanos { Nano = nanoId };
this.uploadedNanos.Remove(au); // In case its in already :)
this.uploadedNanos.Add(au);
}
this.WriteUploadedNanosToSql();
}
