Example #1
0
 public CatchEffort Get(CompoundIdentity id)
 {
     if (!id.IsNullOrEmpty() && Db.DataStoreIdentity.Equals(id.DataStoreIdentity) && this.CanGet())
     {
         NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
         cmd.CommandText = Db.SelectFishCatchEfforts + Db.Where + Db.WhereId;
         cmd.Parameters.AddWithValue("id", id.Identity);
         NpgsqlDataReader rdr = Db.ExecuteReader(cmd);
         CatchEffort      o   = null;
         if (rdr != null)
         {
             try
             {
                 rdr.Read();
                 o = this.builder.Build(rdr);
                 if (cmd.Connection.State == System.Data.ConnectionState.Open)
                 {
                     cmd.Connection.Close();
                 }
             }
             catch
             { }
             finally
             {
                 cmd.Dispose();
             }
         }
         return(o);
     }
     return(null);
 }
Example #2
0
        internal bool CanDelete(CompoundIdentity catchEffortId)
        {
            if (this.CanDelete())
            {
                if (!catchEffortId.Equals(lastCatchEffortId))
                {
                    this.lastCatchEffortId = catchEffortId;
                    CatchEffort depl = this.Get(catchEffortId);
                    if (depl != null)
                    {
                        this.lastEditPermission = this.CanDelete(depl);
                    }
                    else // can't get the effort, so it will always fail
                    {
                        this.lastEditPermission = false;
                    }

                    return(this.lastEditPermission);
                }
                else
                {
                    return(this.lastEditPermission); //same as last check
                }
            }
            return(false);
        }
Example #3
0
 public bool CanDelete(CatchEffort item)
 {
     if (item != null && Db.DataStoreIdentity.Equals(item.Identity.DataStoreIdentity))
     {
         if (this.CanDelete())
         {
             UserProvider prov = UserAffilationSecurityManager.Instance.GetProvider(this.Context);
             if (prov != null)
             {
                 return(prov.HasAffiliationForSampleEvent(item.SampleEventId, true));
             }
         }
     }
     return(false);
 }
Example #4
0
        public bool Delete(CatchEffort item)
        {
            if (item != null && this.CanDelete(item))
            {
                try
                {
                    NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
                    cmd.CommandText = Db.DeleteFishCatchEfforts;
                    cmd.Parameters.AddWithValue("id", item.Identity.Identity);
                    Db.ExecuteNonQuery(cmd);

                    cmd.Parameters.Clear();
                    cmd.Parameters.AddWithValue("ceid", item.Identity.Identity); //used for catches, counts, fish, hauls, etc.

                    cmd.CommandText = Db.DeleteFishCatchMetrics + Db.WhereEffort;
                    Db.ExecuteNonQuery(cmd);

                    cmd.CommandText = Db.DeleteFishCount + Db.WhereEffort;
                    Db.ExecuteNonQuery(cmd);

                    cmd.CommandText = Db.DeleteFishNetHaulEvent + Db.WhereEffort;
                    Db.ExecuteNonQuery(cmd);

                    //--items sub to fish do a where fishid in (select)
                    cmd.CommandText = Db.DeleteFishDiet + Db.WhereEffortIn;
                    Db.ExecuteNonQuery(cmd);

                    cmd.CommandText = Db.DeleteFishGenetics + Db.WhereEffortIn;
                    Db.ExecuteNonQuery(cmd);

                    cmd.CommandText = Db.DeleteFishIdTag + Db.WhereEffortIn;
                    Db.ExecuteNonQuery(cmd);
                    //--end all sub-items, now it's ok to remove the fish itself

                    cmd.CommandText = Db.DeleteFishIndividual + Db.WhereEffort;
                    Db.ExecuteNonQuery(cmd);
                    return(true);
                }
                catch
                { }
            }
            return(false);
        }
Example #5
0
 public IEnumerable <CatchEffort> GetForSite(CompoundIdentity siteId)
 {
     if (!siteId.IsNullOrEmpty() && this.CanGet())
     {
         NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
         cmd.CommandText = Db.SelectFishCatchEfforts + Db.Where + Db.WhereSite;
         cmd.Parameters.AddWithValue("sitesid", siteId.DataStoreIdentity);
         cmd.Parameters.AddWithValue("siteid", siteId.Identity);
         NpgsqlDataReader   rdr         = Db.ExecuteReader(cmd);
         CatchEffort        o           = null;
         List <CatchEffort> permissions = new List <CatchEffort>();
         if (rdr != null)
         {
             try
             {
                 while (rdr.Read())
                 {
                     o = this.builder.Build(rdr);
                     if (o != null)
                     {
                         permissions.Add(o);
                     }
                 }
                 if (cmd.Connection.State == System.Data.ConnectionState.Open)
                 {
                     cmd.Connection.Close();
                 }
             }
             catch
             { }
             finally
             {
                 cmd.Dispose();
             }
         }
         return(permissions);
     }
     return(null);
 }
Example #6
0
        //\"Id\", \"CatchEffortId\", \"TaxaSystemId\", \"TaxaId\", \"Count\", \"Description\"
        public FishCount Build(DbDataReader reader)
        {
            FishCount tmp = new FishCount(DbReaderUtils.GetGuid(reader, 0), new CompoundIdentity(Db.DataStoreIdentity, DbReaderUtils.GetGuid(reader, 1)), new CompoundIdentity(DbReaderUtils.GetGuid(reader, 2), DbReaderUtils.GetGuid(reader, 3)),
                                          (uint)DbReaderUtils.GetInt32(reader, 4), DbReaderUtils.GetString(reader, 5));

            if (!seen.Contains(tmp.CatchEffortId))
            {
                seen.Add(tmp.CatchEffortId);
                CatchEffort e = this.helperBuilder.Get(tmp.CatchEffortId);
                if (e != null)
                {
                    got.Add(tmp.CatchEffortId);
                }
            }

            if (!got.Contains(tmp.CatchEffortId))
            {
                return(null);
            }

            return(tmp);
        }
Example #7
0
        //\"Id\", \"CatchEffortId\", \"MetricType\", \"Value\", \"Description\"
        public CatchMetric Build(DbDataReader reader)
        {
            CatchMetric tmp = new CatchMetric(DbReaderUtils.GetGuid(reader, 0), new CompoundIdentity(Db.DataStoreIdentity, DbReaderUtils.GetGuid(reader, 1)),
                                              DbReaderUtils.GetSingle(reader, 3), DbReaderUtils.GetString(reader, 2), DbReaderUtils.GetString(reader, 4));

            if (!seen.Contains(tmp.CatchEffortId))
            {
                seen.Add(tmp.CatchEffortId);
                CatchEffort e = this.helperBuilder.Get(tmp.CatchEffortId);
                if (e != null)
                {
                    got.Add(tmp.CatchEffortId);
                }
            }

            if (!got.Contains(tmp.CatchEffortId))
            {
                return(null);
            }

            return(tmp);
        }
Example #8
0
        //\"Id\", \"CatchEffortId\", \"TaxaSystemId\", \"TaxaId\", \"LengthStandard\", \"LengthFork\", \"LengthTotal\", \"Weight\", \"AdClipped\", \"CWT\", \"Description\"
        public Fish Build(DbDataReader reader)
        {
            Fish tmp = new Fish(DbReaderUtils.GetGuid(reader, 0), new CompoundIdentity(Db.DataStoreIdentity, DbReaderUtils.GetGuid(reader, 1)), new CompoundIdentity(DbReaderUtils.GetGuid(reader, 2), DbReaderUtils.GetGuid(reader, 3)),
                                DbReaderUtils.GetSingle(reader, 4), DbReaderUtils.GetSingle(reader, 5), DbReaderUtils.GetSingle(reader, 6), DbReaderUtils.GetSingle(reader, 7), DbReaderUtils.GetNullableBoolean(reader, 8),
                                DbReaderUtils.GetNullableBoolean(reader, 9), DbReaderUtils.GetString(reader, 10));

            if (!seen.Contains(tmp.CatchEffortId))
            {
                seen.Add(tmp.CatchEffortId);
                CatchEffort e = this.helperBuilder.Get(tmp.CatchEffortId);
                if (e != null)
                {
                    got.Add(tmp.CatchEffortId);
                }
            }

            if (!got.Contains(tmp.CatchEffortId))
            {
                return(null);
            }

            return(tmp);
        }
Example #9
0
 public static JObject ToJson(CatchEffort effort)
 {
     if (effort != null)
     {
         JObject o = new JObject();
         o.Add(JsonUtils.Id, JsonUtils.ToJson(effort.Identity));
         o.Add("sampleeventid", JsonUtils.ToJson(effort.SampleEventId));
         o.Add("siteid", JsonUtils.ToJson(effort.SiteId));
         o.Add("sampledate", effort.SampleDate);
         if (effort.Location != null)
         {
             o.Add("location", effort.Location.ToString());
         }
         if (effort.CatchMethod != null)
         {
             o.Add("catchmethod", effort.CatchMethod);
         }
         if (effort.Strata != null)
         {
             o.Add("strata", effort.Strata);
         }
         o.Add("depth", effort.Depth);
         o.Add("ph", effort.pH);
         o.Add("temp", effort.Temp);
         o.Add("do", effort.DO);
         o.Add("salinity", effort.Salinity);
         o.Add("velocity", effort.Velocity);
         if (effort.Description != null)
         {
             o.Add(JsonUtils.Description, effort.Description);
         }
         o.Add("isprivate", effort.IsPrivate);
         return(o);
     }
     return(null);
 }
Example #10
0
        public bool Update(CatchEffort item)
        {
            if (item != null && this.CanUpdate(item))
            {
                try
                {
                    NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
                    cmd.CommandText = Db.UpdateFishCatchEfforts;

                    cmd.Parameters.AddWithValue("id", item.Identity.Identity);
                    cmd.Parameters.AddWithValue("esid", item.SampleEventId.DataStoreIdentity);
                    cmd.Parameters.AddWithValue("eid", item.SampleEventId.Identity);
                    Db.AddParam(cmd, "ssid", "sid", item.SiteId);
                    Db.AddParam(cmd, "when", item.SampleDate);
                    Db.AddParam(cmd, "loc", item.Location);
                    Db.AddParam(cmd, "method", item.CatchMethod);
                    Db.AddParam(cmd, "strata", item.Strata);
                    Db.AddParam(cmd, "depth", item.Depth);
                    Db.AddParam(cmd, "ph", item.pH);
                    Db.AddParam(cmd, "tmp", item.Temp);
                    Db.AddParam(cmd, "dox", item.DO);
                    Db.AddParam(cmd, "sal", item.Salinity);
                    Db.AddParam(cmd, "vel", item.Velocity);
                    Db.AddParam(cmd, "d", item.Description);

                    cmd.Parameters.AddWithValue("priv", item.IsPrivate);

                    Db.ExecuteNonQuery(cmd);

                    return(true);
                }
                catch
                { }
            }
            return(false);
        }
Example #11
0
        private UpdateStatus InitialLoad(CompoundIdentity seId, EntityBundle sites, EntityBundle nets, EntityBundle fishSpecies, EntityBundle macroSpecies, FishDET curdet, ICatchEffortProvider depl, ICatchHaulProvider haul, IFishProvider fish, bool isPrivate)
        {
            UpdateStatus stat = null;

            if (sites == null || nets == null || fishSpecies == null || seId == null || seId.IsEmpty || macroSpecies == null)
            {
                stat = new UpdateStatus(UpdateIssue.DataIssue);
                stat.Add(new IssueNotice("BundlesOrEvent", "Null value"));
            }
            else
            {
                //TODO -- may need to do case insensitive ops or not -- verify how excel part is implemented

                Dictionary <string, CompoundIdentity> deployIds = new Dictionary <string, CompoundIdentity>();
                BundleElement elem;
                foreach (CatchEffortDTO cur in curdet.CatchEfforts.Values)
                {
                    if (cur != null && !deployIds.ContainsKey(cur.CatchId))
                    {
                        elem = sites.Get(cur.SiteId);
                        if (elem != null)
                        {
                            CompoundIdentity siteId   = elem.EntityId;
                            Point2 <double>  tmpPoint = null;
                            if (cur.CatchX.HasValue && cur.CatchY.HasValue)
                            {
                                if (!(cur.CatchX.Value.IsInfiniteOrNaN() && cur.CatchY.Value.IsInfiniteOrNaN()))
                                {
                                    tmpPoint = GeometryFactory2Double.Instance.ConstructPoint(cur.CatchX.Value, cur.CatchY.Value);
                                }
                            }

                            double dep = cur.Depth.HasValue ? cur.Depth.Value : double.NaN;
                            double dox = cur.DO.HasValue ? cur.DO.Value : double.NaN;
                            double pH  = cur.pH.HasValue ? cur.pH.Value : double.NaN;
                            double sal = cur.Salinity.HasValue ? cur.Salinity.Value : double.NaN;
                            double tmp = cur.Temp.HasValue ? cur.Temp.Value : double.NaN;
                            double vel = cur.Velocity.HasValue ? cur.Velocity.Value : double.NaN;

                            CatchEffort cat = depl.Create(seId, siteId, cur.DateTime, cur.Comments, isPrivate, cur.CatchMethod, cur.HabitatStrata, tmpPoint, (float)dep, (float)pH, (float)tmp, (float)dox, (float)sal, (float)vel);
                            if (cat != null)
                            {
                                deployIds[cur.CatchId] = cat.Identity;
                            }
                            else
                            {
                                stat = Add("Create", "Deployment", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("SiteCode", "Empty or missing", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("CatchId", "Empty or missing", UpdateIssue.DataIssue, stat);
                    }
                }

                foreach (CatchMetricDTO cur in curdet.CatchMetrics.Values)
                {
                    if (cur != null && deployIds.ContainsKey(cur.CatchId))
                    {
                        CompoundIdentity depId = deployIds[cur.CatchId];
                        if (depId != null)
                        {
                            try
                            {
                                CatchMetric met = haul.CreateMetric(depId, (float)cur.Value, cur.MetricType, cur.Comments);
                                if (met == null)
                                {
                                    stat = Add("Create", "CatchMetric", UpdateIssue.DataIssue, stat);
                                }
                            }
                            catch
                            {
                                stat = Add("Create", "CatchMetric", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("CatchId", "Fail to lookup in CatchMetric", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("CatchId", "Fail to lookup in CatchMetric", UpdateIssue.DataIssue, stat);
                    }
                }

                foreach (NetHaulEventDTO cur in curdet.NetHaulEvents.Values)
                {
                    if (cur != null && deployIds.ContainsKey(cur.CatchId))
                    {
                        CompoundIdentity depId = deployIds[cur.CatchId];
                        if (depId != null)
                        {
                            elem = nets.Get(cur.NetId);
                            if (elem != null)
                            {
                                CompoundIdentity netId = elem.EntityId;
                                try
                                {
                                    double area = cur.AreaSampled.HasValue ? cur.AreaSampled.Value : double.NaN;
                                    double vol  = cur.VolumeSampled.HasValue ? cur.VolumeSampled.Value : double.NaN;

                                    NetHaulEvent met = haul.CreateHaul(depId, netId, (float)area, (float)vol, cur.Comments);
                                    if (met == null)
                                    {
                                        stat = Add("Create", "NetHaulEvent", UpdateIssue.DataIssue, stat);
                                    }
                                }
                                catch
                                {
                                    stat = Add("Create", "NetHaulEvent", UpdateIssue.DataIssue, stat);
                                }
                            }
                            else
                            {
                                stat = Add("NetId", "Fail to lookup in NetHaulEvent", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("CatchId", "Fail to lookup in NetHaulEvent", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("CatchId", "Fail to lookup in NetHaulEvent", UpdateIssue.DataIssue, stat);
                    }
                }

                foreach (FishCountDTO cur in curdet.FishCounts.Values)
                {
                    if (cur != null && deployIds.ContainsKey(cur.CatchId))
                    {
                        CompoundIdentity depId = deployIds[cur.CatchId];
                        if (depId != null)
                        {
                            elem = fishSpecies.Get(cur.SpeciesId);
                            if (elem != null)
                            {
                                CompoundIdentity fishId = elem.EntityId;
                                try
                                {
                                    FishCount met = haul.CreateFishCount(depId, fishId, cur.Count.HasValue?cur.Count.Value:0, cur.Comments);
                                    if (met == null)
                                    {
                                        stat = Add("Create", "FishCount", UpdateIssue.DataIssue, stat);
                                    }
                                }
                                catch
                                {
                                    stat = Add("Create", "FishCount", UpdateIssue.DataIssue, stat);
                                }
                            }
                            else
                            {
                                stat = Add("TaxaId", "Fail to lookup in FishCount", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("CatchId", "Fail to lookup in FishCount", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("CatchId", "Fail to lookup in FishCount", UpdateIssue.DataIssue, stat);
                    }
                }

                //keep track of all fishids as we go for lookups
                Dictionary <string, Guid> fishIds = new Dictionary <string, Guid>();
                foreach (FishDTO cur in curdet.Fish.Values)
                {
                    if (cur != null && deployIds.ContainsKey(cur.CatchId))
                    {
                        CompoundIdentity depId = deployIds[cur.CatchId];
                        if (depId != null)
                        {
                            elem = fishSpecies.Get(cur.SpeciesId);
                            if (elem != null)
                            {
                                CompoundIdentity fishId = elem.EntityId;
                                try
                                {
                                    double std = cur.LengthStandard.HasValue ? cur.LengthStandard.Value : double.NaN;
                                    double frk = cur.LengthFork.HasValue ? cur.LengthFork.Value : double.NaN;
                                    double tot = cur.LengthTotal.HasValue ? cur.LengthTotal.Value : double.NaN;
                                    double wei = cur.Mass.HasValue ? cur.Mass.Value : double.NaN;

                                    Osrs.Oncor.WellKnown.Fish.Fish met = fish.CreateFish(depId, fishId, (float)std, (float)frk, (float)tot, (float)wei, cur.AdClipped, cur.CodedWireTag, cur.Comments);
                                    fishIds[cur.FishId] = met.Identity;
                                    if (met == null)
                                    {
                                        stat = Add("Create", "Fish", UpdateIssue.DataIssue, stat);
                                    }
                                }
                                catch
                                {
                                    stat = Add("Create", "Fish", UpdateIssue.DataIssue, stat);
                                }
                            }
                            else
                            {
                                stat = Add("TaxaId", "Fail to lookup in Fish", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("CatchId", "Fail to lookup in Fish", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("CatchId", "Fail to lookup in Fish", UpdateIssue.DataIssue, stat);
                    }
                }

                foreach (DietDTO cur in curdet.Diet.Values)
                {
                    if (cur != null && fishIds.ContainsKey(cur.FishId))
                    {
                        Guid depId = fishIds[cur.FishId];
                        if (!Guid.Empty.Equals(depId))
                        {
                            elem = macroSpecies.Get(cur.SpeciesId);
                            if (elem != null || string.IsNullOrEmpty(cur.SpeciesId)) //allow for empty gut
                            {
                                CompoundIdentity taxaId;
                                if (elem != null)
                                {
                                    taxaId = elem.EntityId;
                                }
                                else
                                {
                                    taxaId = new CompoundIdentity(Guid.Empty, Guid.Empty);
                                }
                                try
                                {
                                    double sam = cur.SampleMass.HasValue ? cur.SampleMass.Value : double.NaN;
                                    double ind = cur.IndividualMass.HasValue ? cur.IndividualMass.Value : double.NaN;
                                    uint?  wh  = null;
                                    if (cur.WholeAnimalsWeighed.HasValue)
                                    {
                                        wh = (uint)cur.WholeAnimalsWeighed.Value;
                                    }

                                    FishDiet met = null;
                                    if (taxaId.IsEmpty)
                                    {
                                        if (cur.Count == 0) //the only way its legal
                                        {
                                            met = fish.CreateFishDiet(depId, taxaId, cur.GutSampleId, cur.VialId, cur.LifeStage, cur.Count, (float)sam, (float)ind, wh, cur.Comments);
                                        }
                                    }
                                    else
                                    {
                                        met = fish.CreateFishDiet(depId, taxaId, cur.GutSampleId, cur.VialId, cur.LifeStage, cur.Count, (float)sam, (float)ind, wh, cur.Comments);
                                    }

                                    if (met == null)
                                    {
                                        stat = Add("Create", "FishDiet", UpdateIssue.DataIssue, stat);
                                    }
                                }
                                catch
                                {
                                    stat = Add("Create", "FishDiet", UpdateIssue.DataIssue, stat);
                                }
                            }
                            else
                            {
                                stat = Add("TaxaId", "Fail to lookup in FishDiet", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("FishId", "Fail to lookup in FishDiet", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("FishId", "Fail to lookup in FishDiet", UpdateIssue.DataIssue, stat);
                    }
                }

                foreach (GeneticDTO cur in curdet.Genetics.Values)
                {
                    if (cur != null && fishIds.ContainsKey(cur.FishId))
                    {
                        Guid depId = fishIds[cur.FishId];
                        if (!Guid.Empty.Equals(depId))
                        {
                            try
                            {
                                StockEstimates est = new StockEstimates();
                                if (!string.IsNullOrEmpty(cur.BestStockEstimate) && cur.ProbabilityBest.HasValue)
                                {
                                    est[cur.BestStockEstimate] = (float)cur.ProbabilityBest.Value;
                                }
                                if (!string.IsNullOrEmpty(cur.SecondStockEstimate) && cur.ProbabilitySecondBest.HasValue)
                                {
                                    est[cur.SecondStockEstimate] = (float)cur.ProbabilitySecondBest.Value;
                                }
                                if (!string.IsNullOrEmpty(cur.ThirdStockEstimate) && cur.ProbabilityThirdBest.HasValue)
                                {
                                    est[cur.ThirdStockEstimate] = (float)cur.ProbabilityThirdBest.Value;
                                }

                                FishGenetics met = fish.CreateFishGenetics(depId, cur.GeneticSampleId, cur.LabSampleId, est, cur.Comments);
                                if (met == null)
                                {
                                    stat = Add("Create", "FishIdTag", UpdateIssue.DataIssue, stat);
                                }
                            }
                            catch
                            {
                                stat = Add("Create", "FishIdTag", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("FishId", "Fail to lookup in FishIdTag", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("FishId", "Fail to lookup in FishIdTag", UpdateIssue.DataIssue, stat);
                    }
                }

                foreach (IdTagDTO cur in curdet.IdTags.Values)
                {
                    if (cur != null && fishIds.ContainsKey(cur.FishId))
                    {
                        Guid depId = fishIds[cur.FishId];
                        if (!Guid.Empty.Equals(depId))
                        {
                            try
                            {
                                FishIdTag met = fish.CreateIdTag(depId, cur.TagCode, cur.TagType, cur.TagManufacturer, cur.Comments);
                                if (met == null)
                                {
                                    stat = Add("Create", "FishIdTag", UpdateIssue.DataIssue, stat);
                                }
                            }
                            catch
                            {
                                stat = Add("Create", "FishIdTag", UpdateIssue.DataIssue, stat);
                            }
                        }
                        else
                        {
                            stat = Add("FishId", "Fail to lookup in FishIdTag", UpdateIssue.DataIssue, stat);
                        }
                    }
                    else
                    {
                        stat = Add("FishId", "Fail to lookup in FishIdTag", UpdateIssue.DataIssue, stat);
                    }
                }

                if (stat == null)
                {
                    stat = new UpdateStatus(UpdateIssue.AllOk);
                    stat.Add(new IssueNotice("NoIssues", "No issues"));
                }
            }
            return(stat);
        }
Example #12
0
        public IEnumerable <CatchEffort> GetForSite(CompoundIdentity siteId, DateTime start, DateTime end)
        {
            if (!siteId.IsNullOrEmpty() && this.CanGet())
            {
                DateTime now = DateTime.UtcNow;
                string   sql = null;
                if (start > FishUtils.GlobalMinDate)
                {
                    sql = Db.Where + Db.WhereStart;
                }
                if (end < now)
                {
                    if (sql == null)
                    {
                        sql = Db.Where + Db.WhereEnd;
                    }
                    else //already have start
                    {
                        sql = sql + " AND " + Db.WhereEnd;
                    }
                }

                if (sql != null) //we need to have at least a start or end constraint that's limiting
                {
                    NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
                    cmd.CommandText = Db.SelectFishCatchEfforts + sql + " AND " + Db.WhereSite;
                    cmd.Parameters.AddWithValue("sitesid", siteId.DataStoreIdentity);
                    cmd.Parameters.AddWithValue("siteid", siteId.Identity);
                    if (start > FishUtils.GlobalMinDate)
                    {
                        cmd.Parameters.AddWithValue("start", start);
                    }
                    if (end < now)
                    {
                        cmd.Parameters.AddWithValue("end", end);
                    }
                    NpgsqlDataReader   rdr         = Db.ExecuteReader(cmd);
                    CatchEffort        o           = null;
                    List <CatchEffort> permissions = new List <CatchEffort>();
                    if (rdr != null)
                    {
                        try
                        {
                            while (rdr.Read())
                            {
                                o = this.builder.Build(rdr);
                                if (o != null)
                                {
                                    permissions.Add(o);
                                }
                            }
                            if (cmd.Connection.State == System.Data.ConnectionState.Open)
                            {
                                cmd.Connection.Close();
                            }
                        }
                        catch
                        { }
                        finally
                        {
                            cmd.Dispose();
                        }
                    }
                    return(permissions);
                }
            }
            return(null);
        }
Example #13
0
        public IEnumerable <CatchEffort> Get(DateTime start, DateTime end)
        {
            if (this.CanGet())
            {
                DateTime now = DateTime.UtcNow;
                string   sql = null;
                if (start > FishUtils.GlobalMinDate)
                {
                    sql = Db.Where + Db.WhereStart;
                }
                if (end < now)
                {
                    if (sql == null)
                    {
                        sql = Db.Where + Db.WhereEnd;
                    }
                    else //already have start
                    {
                        sql = sql + " AND " + Db.WhereEnd;
                    }
                }

                if (sql != null)
                {
                    NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
                    cmd.CommandText = Db.SelectFishCatchEfforts + sql;

                    if (start > FishUtils.GlobalMinDate)
                    {
                        cmd.Parameters.AddWithValue("start", start);
                    }
                    if (end < now)
                    {
                        cmd.Parameters.AddWithValue("end", end);
                    }

                    NpgsqlDataReader   rdr         = Db.ExecuteReader(cmd);
                    CatchEffort        o           = null;
                    List <CatchEffort> permissions = new List <CatchEffort>();
                    if (rdr != null)
                    {
                        try
                        {
                            while (rdr.Read())
                            {
                                o = this.builder.Build(rdr);
                                if (o != null)
                                {
                                    permissions.Add(o);
                                }
                            }
                            if (cmd.Connection.State == System.Data.ConnectionState.Open)
                            {
                                cmd.Connection.Close();
                            }
                        }
                        catch
                        { }
                        finally
                        {
                            cmd.Dispose();
                        }
                    }
                    return(permissions);
                }
            }
            return(null);
        }