public override FieldTeam Create(string name, string description)
{
if (!string.IsNullOrEmpty(name) && this.CanCreate())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertFieldTeam;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("sid", Db.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("name", name);
if (string.IsNullOrEmpty(description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", description);
}
Db.ExecuteNonQuery(cmd);
return(new FieldTeam(new CompoundIdentity(Db.DataStoreIdentity, id), name, description));
}
catch
{ }
}
return(null);
}
protected override bool Initialize()
{
lock (this)
{
if (!this.initialized)
{
ConfigurationProviderBase config = ConfigurationManager.Instance.GetProvider();
if (config != null)
{
ConfigurationParameter param = config.Get(typeof(PgUserPasswordHistoryProviderFactory), "connectionString");
if (param != null)
{
string tName = param.Value as string;
if (!string.IsNullOrEmpty(tName))
{
if (NpgSqlCommandUtils.TestConnection(tName))
{
Db.ConnectionString = tName;
this.initialized = true;
return(true);
}
}
}
}
}
}
return(false);
}
public override OrganizationAliasScheme Create(Organization owner, string name, string description)
{
if (owner != null && !owner.Identity.IsNullOrEmpty() && !string.IsNullOrEmpty(name) && this.CanCreate())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertAliasScheme;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("sid", Db.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("osid", owner.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", owner.Identity.Identity);
cmd.Parameters.AddWithValue("name", name);
if (string.IsNullOrEmpty(description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", description);
}
Db.ExecuteNonQuery(cmd);
return(new OrganizationAliasScheme(new CompoundIdentity(Db.DataStoreIdentity, id), owner.Identity, name, description));
}
catch
{ }
}
return(null);
}
public override bool Update(ProjectStatusType statusType)
{
if (statusType != null && !statusType.Identity.IsNullOrEmpty() && CanUpdate(statusType))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateStatTyp;
cmd.Parameters.AddWithValue("sid", statusType.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", statusType.Identity.Identity);
cmd.Parameters.AddWithValue("name", statusType.Name);
if (string.IsNullOrEmpty(statusType.Description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", statusType.Description);
}
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public override bool Update(InstrumentFamily org)
{
if (org != null && this.CanUpdate(org))
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateInstrumentFamily + Db.SelectById;
cmd.Parameters.AddWithValue("name", org.Name);
if (!string.IsNullOrEmpty(org.Description))
{
cmd.Parameters.AddWithValue("desc", org.Description);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
if (org.ParentId != null)
{
cmd.Parameters.AddWithValue("pid", org.ParentId.Identity);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("pid", NpgsqlTypes.NpgsqlDbType.Uuid));
}
cmd.Parameters.AddWithValue("id", org.Identity.Identity);
Db.ExecuteNonQuery(cmd);
return(true);
}
return(false);
}
public override bool Update(Taxonomy taxonomy)
{
if (taxonomy != null && this.CanUpdate(taxonomy))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateTaxonomy + Db.SelectById;
cmd.Parameters.AddWithValue("name", taxonomy.Name);
if (string.IsNullOrEmpty(taxonomy.Description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", taxonomy.Description);
}
cmd.Parameters.AddWithValue("id", taxonomy.Identity.Identity);
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public override OrganizationHierarchy Create(string hierarchyName, Organization owningOrg)
{
if (owningOrg != null && !owningOrg.Identity.IsNullOrEmpty() && !string.IsNullOrEmpty(hierarchyName) && this.CanCreate())
{
if (!this.Exists(hierarchyName))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.Insert;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("sid", Db.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("osid", owningOrg.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", owningOrg.Identity.Identity);
cmd.Parameters.AddWithValue("name", hierarchyName);
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
Db.ExecuteNonQuery(cmd);
return(new PgOrgHierarchy(this.Context, new CompoundIdentity(Db.DataStoreIdentity, id), owningOrg.Identity, hierarchyName, null));
}
catch
{ }
}
}
return(null);
}
public override TaxaDomain Create(string name, CompoundIdentity taxonomyId, string description)
{
if (!string.IsNullOrEmpty(name) && this.CanCreate())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertDomain;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("name", name);
if (string.IsNullOrEmpty(description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", description);
}
cmd.Parameters.AddWithValue("tid", taxonomyId.Identity);
Db.ExecuteNonQuery(cmd);
return(new TaxaDomain(new CompoundIdentity(Db.SysId, id), new CompoundIdentity(Db.SysId, taxonomyId.Identity),
name, description));
}
catch
{ }
}
return(null);
}
internal static void AddParam(NpgsqlCommand cmd, string minName, string maxName, ValueRange <float> val)
{
if (val == null)
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(minName, NpgsqlTypes.NpgsqlDbType.Real));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(maxName, NpgsqlTypes.NpgsqlDbType.Real));
}
else
{
if (float.IsNegativeInfinity(val.Min))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(minName, NpgsqlTypes.NpgsqlDbType.Real));
}
else
{
cmd.Parameters.AddWithValue(minName, val.Min);
}
if (float.IsPositiveInfinity(val.Max))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(maxName, NpgsqlTypes.NpgsqlDbType.Real));
}
else
{
cmd.Parameters.AddWithValue(maxName, val.Max);
}
}
}
public override bool UpdateInfo()
{
if (this.CanUpdateInfo())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.Update;
cmd.Parameters.AddWithValue("sid", this.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", this.Identity.Identity);
cmd.Parameters.AddWithValue("osid", this.OwningOrgId.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", this.OwningOrgId.Identity);
cmd.Parameters.AddWithValue("name", this.Name);
if (string.IsNullOrEmpty(this.Description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", this.Description);
}
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public override bool Update(OrganizationAliasScheme org)
{
if (org != null && !org.Identity.IsNullOrEmpty() && CanUpdate(org))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateAliasScheme;
cmd.Parameters.AddWithValue("sid", org.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", org.Identity.Identity);
cmd.Parameters.AddWithValue("osid", org.OwningOrganizationIdentity.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", org.OwningOrganizationIdentity.Identity);
cmd.Parameters.AddWithValue("name", org.Name);
if (string.IsNullOrEmpty(org.Description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", org.Description);
}
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public WaterQualityDeployment Create(string name, CompoundIdentity sampleEventId, CompoundIdentity siteId, CompoundIdentity sensorId, DateRange range, string description, bool isPrivate)
{
if (!string.IsNullOrEmpty(name) && !sampleEventId.IsNullOrEmpty() && !siteId.IsNullOrEmpty() && !sensorId.IsNullOrEmpty() && range != null && this.CanCreate())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertDeployment;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("sid", Db.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("n", name);
cmd.Parameters.AddWithValue("esid", sampleEventId.DataStoreIdentity);
cmd.Parameters.AddWithValue("eid", sampleEventId.Identity);
cmd.Parameters.AddWithValue("sitesid", siteId.DataStoreIdentity);
cmd.Parameters.AddWithValue("siteid", siteId.Identity);
cmd.Parameters.AddWithValue("isid", sensorId.DataStoreIdentity);
cmd.Parameters.AddWithValue("iid", sensorId.Identity);
if (range.StartDate.HasValue)
{
cmd.Parameters.AddWithValue("start", range.StartDate.Value);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("start", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
}
if (range.EndDate.HasValue)
{
cmd.Parameters.AddWithValue("end", range.EndDate.Value);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("end", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
}
if (string.IsNullOrEmpty(description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("d", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("d", description);
}
cmd.Parameters.AddWithValue("priv", isPrivate);
Db.ExecuteNonQuery(cmd);
return(new WaterQualityDeployment(new CompoundIdentity(Db.DataStoreIdentity, id), name, sampleEventId, siteId, sensorId, range, description, isPrivate));
}
catch
{ }
}
return(null);
}
public bool Update(WaterQualityDeployment item)
{
if (item != null && this.CanUpdate(item))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateDeployment;
cmd.Parameters.AddWithValue("sid", item.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", item.Identity.Identity);
cmd.Parameters.AddWithValue("n", item.Name);
cmd.Parameters.AddWithValue("esid", item.SampleEventId.DataStoreIdentity);
cmd.Parameters.AddWithValue("eid", item.SampleEventId.Identity);
cmd.Parameters.AddWithValue("sitesid", item.SiteId.DataStoreIdentity);
cmd.Parameters.AddWithValue("siteid", item.SiteId.Identity);
cmd.Parameters.AddWithValue("isid", item.SensorId.DataStoreIdentity);
cmd.Parameters.AddWithValue("iid", item.SensorId.Identity);
if (item.Range.StartDate.HasValue)
{
cmd.Parameters.AddWithValue("start", item.Range.StartDate.Value);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("start", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
}
if (item.Range.EndDate.HasValue)
{
cmd.Parameters.AddWithValue("end", item.Range.EndDate.Value);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("end", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
}
if (string.IsNullOrEmpty(item.Description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("d", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("d", item.Description);
}
cmd.Parameters.AddWithValue("priv", item.IsPrivate);
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
internal static void AddParam(NpgsqlCommand cmd, string name, string val)
{
if (string.IsNullOrEmpty(val))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(name, NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue(name, val);
}
}
internal static void AddParam(NpgsqlCommand cmd, string name, float val)
{
if (Numerics.MathUtils.IsInfiniteOrNaN(val))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(name, NpgsqlTypes.NpgsqlDbType.Real));
}
else
{
cmd.Parameters.AddWithValue(name, val);
}
}
internal static void AddParam(NpgsqlCommand cmd, string name, uint?val)
{
if (val.HasValue)
{
cmd.Parameters.AddWithValue(name, (int)val); //treat it like a signed int with implicit range limit
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(name, NpgsqlTypes.NpgsqlDbType.Integer));
}
}
internal static void AddParam(NpgsqlCommand cmd, string idName, CompoundIdentity val)
{
if (val.IsNullOrEmpty())
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(idName, NpgsqlTypes.NpgsqlDbType.Uuid));
}
else
{
cmd.Parameters.AddWithValue(idName, val.Identity);
}
}
internal static void AddParam(NpgsqlCommand cmd, string name, Guid val)
{
if (Guid.Empty.Equals(val))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(name, NpgsqlTypes.NpgsqlDbType.Uuid));
}
else
{
cmd.Parameters.AddWithValue(name, val);
}
}
internal static void AddParam(NpgsqlCommand cmd, string name, bool?val)
{
if (val.HasValue)
{
cmd.Parameters.AddWithValue(name, val);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(name, NpgsqlTypes.NpgsqlDbType.Boolean));
}
}
public override FieldTrip Create(string name, CompoundIdentity activityId, CompoundIdentity principalOrgId, ValueRange <DateTime> dateRange, string description)
{
if (!activityId.IsNullOrEmpty() && !principalOrgId.IsNullOrEmpty() && !string.IsNullOrEmpty(name) && this.CanCreate())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertTrip;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("sid", Db.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("fasid", activityId.DataStoreIdentity);
cmd.Parameters.AddWithValue("faid", activityId.Identity);
cmd.Parameters.AddWithValue("osid", principalOrgId.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", principalOrgId.Identity);
if (dateRange != null)
{
dateRange = Db.CleanRange(dateRange);
cmd.Parameters.AddWithValue("start", dateRange.Min);
cmd.Parameters.AddWithValue("end", dateRange.Max);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("start", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("end", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
}
cmd.Parameters.AddWithValue("name", name);
if (string.IsNullOrEmpty(description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", description);
}
Db.ExecuteNonQuery(cmd);
return(new FieldTrip(new CompoundIdentity(Db.DataStoreIdentity, id), name, activityId, principalOrgId, dateRange, description));
}
catch
{ }
}
return(null);
}
public override Project Create(string name, CompoundIdentity principalOrgId, Project parentProject, string description)
{
if (!string.IsNullOrEmpty(name) && !principalOrgId.IsNullOrEmpty() && this.CanCreate())
{
try
{
CompoundIdentity parentId = null;
if (parentProject != null)
{
parentId = parentProject.Identity;
}
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertProj;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("sid", Db.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("name", name);
cmd.Parameters.AddWithValue("osid", principalOrgId.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", principalOrgId.Identity);
if (parentId.IsNullOrEmpty())
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("psid", NpgsqlTypes.NpgsqlDbType.Uuid));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("pid", NpgsqlTypes.NpgsqlDbType.Uuid));
}
else
{
cmd.Parameters.AddWithValue("psid", parentId.DataStoreIdentity);
cmd.Parameters.AddWithValue("pid", parentId.Identity);
}
if (string.IsNullOrEmpty(description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", description);
}
Db.ExecuteNonQuery(cmd);
return(new Project(new CompoundIdentity(Db.DataStoreIdentity, id), name, principalOrgId, parentId, description));
}
catch
{ }
}
return(null);
}
protected override void InitializeImpl()
{
lock (instance)
{
if (RuntimeUtils.Initializable(this.State))
{
string meth = "Initialize";
this.State = RunState.Initializing;
this.logger = LogManager.Instance.GetProvider(typeof(EntityBundleManager));
Log(meth, LogLevel.Info, "Called");
ConfigurationProviderBase config = ConfigurationManager.Instance.GetProvider();
if (config != null)
{
ConfigurationParameter param = config.Get(typeof(EntityBundleProvider), "connectionString");
if (param != null)
{
string tName = param.Value as string;
if (!string.IsNullOrEmpty(tName))
{
if (NpgSqlCommandUtils.TestConnection(tName))
{
Db.ConnectionString = tName;
Log(meth, LogLevel.Info, "Succeeded");
this.State = RunState.Initialized;
return;
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get connectionString param value");
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get connectionString param");
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get ConfigurationProvider");
}
this.State = RunState.FailedInitializing;
}
}
}
public override Sensor Create(CompoundIdentity id, CompoundIdentity instrumentId, CompoundIdentity ownerId, string name, CompoundIdentity typeId, string description, string serialNumber, CompoundIdentity manufId)
{
if (!string.IsNullOrEmpty(name) && instrumentId != null && ownerId != null && typeId != null && this.CanCreate())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertSensor;
cmd.Parameters.AddWithValue("id", id.Identity);
cmd.Parameters.AddWithValue("iid", instrumentId.Identity);
cmd.Parameters.AddWithValue("osid", ownerId.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", ownerId.Identity);
cmd.Parameters.AddWithValue("name", name);
cmd.Parameters.AddWithValue("tid", typeId.Identity);
if (string.IsNullOrEmpty(description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", description);
}
if (string.IsNullOrEmpty(serialNumber))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("sn", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("sn", serialNumber);
}
if (manufId.IsNullOrEmpty())
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("msid", NpgsqlTypes.NpgsqlDbType.Uuid));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("mid", NpgsqlTypes.NpgsqlDbType.Uuid));
}
else
{
cmd.Parameters.AddWithValue("msid", manufId.DataStoreIdentity);
cmd.Parameters.AddWithValue("mid", manufId.Identity);
}
Db.ExecuteNonQuery(cmd);
return(new Sensor(id, instrumentId, ownerId, name, typeId, description, serialNumber, manufId));
}
catch
{ }
}
return(null);
}
protected override void InitializeImpl()
{
lock (instance)
{
if (RuntimeUtils.Initializable(this.State))
{
string meth = "Initialize";
this.State = RunState.Initializing;
this.logger = LogManager.Instance.GetProvider(typeof(UserAffilationSecurityManager));
Log(meth, LogLevel.Info, "Called");
ConfigurationProviderBase config = ConfigurationManager.Instance.GetProvider();
if (config != null)
{
ConfigurationParameter param = config.Get(NameReflectionUtils.GetType(TypeNameReference.Parse("Osrs.WellKnown.FieldActivities.Providers.PgFieldActivityProviderFactory, Osrs.WellKnown.FieldActivities.Providers.Postgres")), "connectionString");
if (param != null)
{
string tName = param.Value as string;
if (!string.IsNullOrEmpty(tName))
{
if (NpgSqlCommandUtils.TestConnection(tName))
{
Db.ConnectionString = tName;
this.initialized = true;
this.State = RunState.Initialized;
return;
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get connectionString param value");
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get connectionString param");
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get ConfigurationProvider");
}
this.State = RunState.FailedInitializing;
}
}
}
public override bool Update(Sensor item)
{
if (item != null && this.CanUpdate(item))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateSensor + Db.SelectById;
cmd.Parameters.AddWithValue("iid", item.InstrumentIdentity.Identity);
cmd.Parameters.AddWithValue("osid", item.OwningOrganizationIdentity.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", item.OwningOrganizationIdentity.Identity);
cmd.Parameters.AddWithValue("name", item.Name);
cmd.Parameters.AddWithValue("tid", item.SensorTypeIdentity.Identity);
if (string.IsNullOrEmpty(item.Description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", item.Description);
}
if (string.IsNullOrEmpty(item.SerialNumber))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("sn", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("sn", item.SerialNumber);
}
if (item.ManufacturerId.IsNullOrEmpty())
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("msid", NpgsqlTypes.NpgsqlDbType.Uuid));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("mid", NpgsqlTypes.NpgsqlDbType.Uuid));
}
else
{
cmd.Parameters.AddWithValue("msid", item.ManufacturerId.DataStoreIdentity);
cmd.Parameters.AddWithValue("mid", item.ManufacturerId.Identity);
}
cmd.Parameters.AddWithValue("id", item.Identity.Identity);
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public override bool Update(SamplingEvent item)
{
if (item != null && this.CanUpdate(item))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateEvent;
cmd.Parameters.AddWithValue("sid", item.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", item.Identity.Identity);
cmd.Parameters.AddWithValue("ftsid", item.FieldTripId.DataStoreIdentity);
cmd.Parameters.AddWithValue("ftid", item.FieldTripId.Identity);
cmd.Parameters.AddWithValue("osid", item.PrincipalOrgId.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", item.PrincipalOrgId.Identity);
cmd.Parameters.AddWithValue("name", item.Name);
if (string.IsNullOrEmpty(item.Description))
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
else
{
cmd.Parameters.AddWithValue("desc", item.Description);
}
if (item.DateRange != null)
{
item.DateRange = Db.CleanRange(item.DateRange);
cmd.Parameters.AddWithValue("start", item.DateRange.Min);
cmd.Parameters.AddWithValue("end", item.DateRange.Max);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("start", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("end", NpgsqlTypes.NpgsqlDbType.TimestampTZ));
}
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
protected override bool Initialize()
{
lock (instance)
{
if (!this.initialized)
{
string meth = "Initialize";
this.logger = LogManager.Instance.GetProvider(myType);
Log(meth, LogLevel.Info, "Called");
ConfigurationProviderBase config = ConfigurationManager.Instance.GetProvider();
if (config != null)
{
ConfigurationParameter param = config.Get(myType, "connectionString");
if (param != null)
{
string tName = param.Value as string;
if (!string.IsNullOrEmpty(tName))
{
if (NpgSqlCommandUtils.TestConnection(tName))
{
Db.ConnectionString = tName;
this.initialized = true;
return(true);
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get connectionString param value");
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get connectionString param");
}
}
else
{
Log(meth, LogLevel.Error, "Failed to get ConfigurationProvider");
}
}
}
return(false);
}
internal static void AddParam(NpgsqlCommand cmd, string name, Point2 <double> location)
{
if (location != null)
{
NpgsqlTypes.PostgisPoint geom = Osrs.Numerics.Spatial.Postgres.NpgSpatialUtils.ToPGis(location);
if (geom != null)
{
cmd.Parameters.AddWithValue(name, geom);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(name, NpgsqlTypes.NpgsqlDbType.Geometry));
}
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam(name, NpgsqlTypes.NpgsqlDbType.Geometry));
}
}
public override bool UpdateStatus(ProjectStatus status)
{
if (status != null && this.CanUpdate())
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateStat;
Guid id = Guid.NewGuid();
cmd.Parameters.AddWithValue("sid", status.ProjectIdentity.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", status.ProjectIdentity.Identity);
cmd.Parameters.AddWithValue("eid", status.Identity);
if (!string.IsNullOrEmpty(status.Text))
{
cmd.Parameters.AddWithValue("name", status.Text);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("name", NpgsqlTypes.NpgsqlDbType.Varchar));
}
cmd.Parameters.AddWithValue("when", status.StatusDate);
if (status.StatusTypeIdentity.IsNullOrEmpty())
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("stsid", NpgsqlTypes.NpgsqlDbType.Uuid));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("stid", NpgsqlTypes.NpgsqlDbType.Uuid));
}
else
{
cmd.Parameters.AddWithValue("stsid", status.StatusTypeIdentity.DataStoreIdentity);
cmd.Parameters.AddWithValue("stid", status.StatusTypeIdentity.Identity);
}
Db.ExecuteNonQuery(cmd);
return(true);
}
catch
{ }
}
return(false);
}
public override bool Update(Project org)
{
if (org != null && this.CanUpdate(org))
{
try
{
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.UpdateProj;
cmd.Parameters.AddWithValue("sid", org.Identity.DataStoreIdentity);
cmd.Parameters.AddWithValue("id", org.Identity.Identity);
cmd.Parameters.AddWithValue("name", org.Name);
cmd.Parameters.AddWithValue("osid", org.PrincipalOrganization.DataStoreIdentity);
cmd.Parameters.AddWithValue("oid", org.PrincipalOrganization.Identity);
if (org.ParentId.IsNullOrEmpty())
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("psid", NpgsqlTypes.NpgsqlDbType.Uuid));
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("pid", NpgsqlTypes.NpgsqlDbType.Uuid));
}
else
{
cmd.Parameters.AddWithValue("psid", org.ParentId.DataStoreIdentity);
cmd.Parameters.AddWithValue("pid", org.ParentId.Identity);
}
if (!string.IsNullOrEmpty(org.Description))
{
cmd.Parameters.AddWithValue("desc", org.Description);
}
else
{
cmd.Parameters.Add(NpgSqlCommandUtils.GetNullInParam("desc", NpgsqlTypes.NpgsqlDbType.Varchar));
}
Db.ExecuteNonQuery(cmd);
Db.ReplaceAffiliates(org);
return(true);
}
catch
{ }
}
return(false);
}
