/// <summary> /// Insert a DBInstancedItem into table /// </summary> /// <param name="item"> /// Item to write /// </param> public static void Save(DBInstancedItem item) { try { using (IDbConnection conn = Connector.GetConnection()) { conn.Execute( "INSERT INTO instanceditems (containertype,containerinstance,containerplacement,itemtype,iteminstance" + ",lowid,highid,quality,multiplecount,x,y,z,headingx,headingy,headingz,headingw,stats) VALUES (@conttype," + " @continstance, @contplacement, @itype, @iinstance, @low, @high, @ql, @mc, @ix, @iy, @iz, @hx, @hy, @hz, @hw, @st)", new { conttype = item.containertype, continstance = item.containerinstance, contplacement = item.containerplacement, itype = item.itemtype, iinstance = item.iteminstance, low = item.lowid, high = item.highid, ql = item.quality, mc = item.multiplecount, ix = item.x, iy = item.y, iz = item.z, hx = item.headingx, hy = item.headingy, hz = item.headingz, hw = item.headingw, st = item.stats }); } } catch (Exception e) { LogUtil.ErrorException(e); throw; } }
/// <summary> /// </summary> /// <returns> /// </returns> public virtual bool Write() { List<DBInstancedItem> DBinstanced = new List<DBInstancedItem>(); List<DBItem> DBuninstanced = new List<DBItem>(); foreach (KeyValuePair<int, IItem> kv in this.Content) { if (kv.Value.Identity.Type != IdentityType.None) { DBInstancedItem dbi = new DBInstancedItem { containerinstance = this.Identity.Instance, containertype = (int)this.Identity.Type, containerplacement = kv.Key, itemtype = (int)kv.Value.Identity.Type, Id = kv.Value.Identity.Instance, lowid = kv.Value.LowID, highid = kv.Value.HighID, quality = kv.Value.Quality, multiplecount = kv.Value.MultipleCount, stats = new Binary(kv.Value.GetItemAttributes()) }; DBinstanced.Add(dbi); } else { DBItem dbi = new DBItem { containerinstance = this.Identity.Instance, containertype = (int)this.Identity.Type, containerplacement = kv.Key, lowid = kv.Value.LowID, highid = kv.Value.HighID, quality = kv.Value.Quality, multiplecount = kv.Value.MultipleCount }; DBuninstanced.Add(dbi); } } ItemDao.Instance.Save(DBuninstanced, null, null); InstancedItemDao.Instance.Save(DBinstanced, null, null); return true; }
/// <summary> /// Insert a DBInstancedItem into table /// </summary> /// <param name="item"> /// Item to write /// </param> public static void Save(DBInstancedItem item) { try { using (IDbConnection conn = Connector.GetConnection()) { conn.Execute( "INSERT INTO instanceditems (containertype,containerinstance,containerplacement,itemtype,iteminstance" + ",lowid,highid,quality,multiplecount,x,y,z,headingx,headingy,headingz,headingw,stats) VALUES (@conttype," + " @continstance, @contplacement, @itype, @iinstance, @low, @high, @ql, @mc, @ix, @iy, @iz, @hx, @hy, @hz, @hw, @st)", new { conttype = item.containertype, continstance = item.containerinstance, contplacement = item.containerplacement, itype = item.itemtype, iinstance = item.iteminstance, low = item.lowid, high = item.highid, ql = item.quality, mc = item.multiplecount, ix = item.x, iy = item.y, iz = item.z, hx = item.headingx, hy = item.headingy, hz = item.headingz, hw = item.headingw, st = item.stats }); } } catch (Exception e) { LogUtil.ErrorException(e); throw; } }