private bool UpdateElements(EntityBundle item) { if (item.elementsDirty) { if (this.DeleteElements(item.Id)) { try { NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString); cmd.CommandText = Db.InsertElement; foreach (BundleElement cur in item.Elements) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("id", cur.BundleId); cmd.Parameters.AddWithValue("esid", cur.EntityId.DataStoreIdentity); cmd.Parameters.AddWithValue("eid", cur.EntityId.Identity); cmd.Parameters.AddWithValue("name", cur.LocalKey); cmd.Parameters.AddWithValue("val", cur.DisplayName); Db.ExecuteNonQuery(cmd); } item.elementsDirty = false; return(true); } catch { } } } return(false); }
public EntityBundle Get(Guid id) { if (!Guid.Empty.Equals(id) && this.CanGet()) { NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString); cmd.CommandText = Db.SelectBundle + Db.SelectById; cmd.Parameters.AddWithValue("id", id); NpgsqlDataReader rdr = Db.ExecuteReader(cmd); EntityBundle o = null; if (rdr != null) { try { if (rdr.Read()) { o = EntityBundleBuilder.Instance.Build(rdr); } if (cmd.Connection.State == System.Data.ConnectionState.Open) { cmd.Connection.Close(); } } catch { } finally { cmd.Dispose(); } } return(o); } return(null); }
public bool CanDelete(EntityBundle bundle) { if (bundle != null && this.CanDelete()) { return(true); //TODO -- implement this } return(false); }
public bool Delete(EntityBundle item) { if (item != null && this.CanDelete(item)) { return(this.Delete(item.Id)); } return(false); }
public bool Update(EntityBundle item) { if (item != null && this.CanUpdate(item)) { try { NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString); cmd.CommandText = Db.UpdateBundle; cmd.Parameters.AddWithValue("id", item.Id); cmd.Parameters.AddWithValue("name", item.Name); cmd.Parameters.AddWithValue("osid", item.PrincipalOrgId.DataStoreIdentity); cmd.Parameters.AddWithValue("oid", item.PrincipalOrgId.Identity); Db.ExecuteNonQuery(cmd); return(this.UpdateElements(item)); } catch { } } return(false); }