/// <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(); }