public VegPlotType GetPlotType(CompoundIdentity id)
{
if (!id.IsNullOrEmpty() && Db.DataStoreIdentity.Equals(id.DataStoreIdentity) && this.CanGet())
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.SelectPlotType + Db.Where + Db.WhereId;
cmd.Parameters.AddWithValue("id", id.Identity);
NpgsqlDataReader rdr = Db.ExecuteReader(cmd);
VegPlotType o = null;
if (rdr != null)
{
try
{
rdr.Read();
o = this.plotBuilder.Build(rdr);
if (cmd.Connection.State == System.Data.ConnectionState.Open)
{
cmd.Connection.Close();
}
}
catch
{ }
finally
{
cmd.Dispose();
}
}
return(o);
}
return(null);
}
public bool CanDelete(VegPlotType item)
{
if (item != null && Db.DataStoreIdentity.Equals(item.Identity.DataStoreIdentity))
{
return(this.CanDelete());
}
return(false);
}
public bool DeletePlotType(CompoundIdentity id)
{
VegPlotType tmp = this.GetPlotType(id);
if (tmp != null)
{
return(Delete(tmp));
}
return(false);
}
public static JObject ToJson(VegPlotType plot)
{
if (plot != null)
{
JObject o = new JObject();
o.Add(JsonUtils.Id, JsonUtils.ToJson(plot.Identity));
o.Add(JsonUtils.Name, plot.Name);
if (plot.Description != null)
{
o.Add(JsonUtils.Description, plot.Description);
}
return(o);
}
return(null);
}
public bool Delete(VegPlotType item)
{
if (item != null && this.CanDelete(item))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.DeletePlotType;
cmd.Parameters.AddWithValue("id", item.Identity.Identity);
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
