internal static StockEstimates Decode(string value)
{
if (string.IsNullOrEmpty(value))
{
return(new StockEstimates());
}
StockEstimates res = new StockEstimates();
StringReader sr = new StringReader(value);
string cur = sr.ReadLine();
while (cur != null)
{
string[] items = cur.Split(':');
string name = items[0];
if (items.Length > 2)
{
for (int i = 1; i < items.Length - 1; i++)
{
name = name + ':' + items[i];
}
}
float pro;
if (float.TryParse(items[items.Length - 1], out pro))
{
res[name] = pro;
}
cur = sr.ReadLine();
}
return(res);
}
static void Main(string[] args)
{
StockEstimates testing = new StockEstimates();
testing["goo"] = 0.5F;
testing["poo"] = 0F;
testing["moo"] = 1F;
foreach (StockEstimate cur in testing)
{
Console.WriteLine(cur.Stock + " " + cur.Probability);
}
ConfigurationManager.Instance.Bootstrap();
ConfigurationManager.Instance.Initialize();
ConfigurationManager.Instance.Start();
Console.WriteLine("Config state: " + ConfigurationManager.Instance.State);
LogManager.Instance.Bootstrap();
LogManager.Instance.Initialize();
LogManager.Instance.Start();
Console.WriteLine("Log state: " + LogManager.Instance.State);
AuthorizationManager.Instance.Bootstrap();
AuthorizationManager.Instance.Initialize();
AuthorizationManager.Instance.Start();
Console.WriteLine("Auth state: " + AuthorizationManager.Instance.State);
LocalSystemUser usr = new LocalSystemUser(SecurityUtils.AdminIdentity, "Admin", UserState.Active);
UserSecurityContext context = new UserSecurityContext(usr);
if (AuthorizationManager.Instance.State == Osrs.Runtime.RunState.Running)
{
//RegisterPermissions(context);
//Grant(context);
}
FishManager.Instance.Initialize();
Console.WriteLine("FishManager state: " + FishManager.Instance.State);
FishManager.Instance.Start();
Console.WriteLine("FishManager state: " + FishManager.Instance.State);
if (FishManager.Instance.State == Osrs.Runtime.RunState.Running)
{
ICatchEffortProvider depProv = FishManager.Instance.GetCatchEffortProvider(context);
if (depProv != null)
{
IFishProvider fProv = FishManager.Instance.GetFishProvider(context);
if (fProv != null)
{
depProv.Get();
Console.WriteLine("furray");
}
}
}
Console.WriteLine("ALL COMPLETE - Enter to exit");
Console.ReadLine();
}
internal static string Encode(StockEstimates value)
{
if (value == null)
{
return(string.Empty);
}
StringBuilder sb = new StringBuilder();
foreach (StockEstimate cur in value)
{
sb.Append(cur.Stock);
sb.Append(":");
sb.AppendLine(cur.Probability.ToString());
}
return(sb.ToString());
}
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);
}
public FishGenetics CreateFishGenetics(Guid fishId, string geneticSampleId, string labSampleId, StockEstimates estimates, string description)
{
if (!Guid.Empty.Equals(fishId) && estimates != null && this.CanCreate())
{
try
{
Guid id = Guid.NewGuid();
NpgsqlCommand cmd = Db.GetCmd(Db.ConnectionString);
cmd.CommandText = Db.InsertFishGenetics;
cmd.Parameters.AddWithValue("id", id);
cmd.Parameters.AddWithValue("fid", fishId);
Db.AddParam(cmd, "gen", geneticSampleId);
Db.AddParam(cmd, "lab", labSampleId);
cmd.Parameters.AddWithValue("stock", FishGeneticsBuilder.Encode(estimates)); //stringifies the estimates
Db.AddParam(cmd, "d", description);
Db.ExecuteNonQuery(cmd);
return(new FishGenetics(id, fishId, geneticSampleId, labSampleId, estimates, description));
}
catch
{ }
}
return(null);
}
public FishGenetics CreateFishGenetics(Guid fishId, string geneticSampleId, string labSampleId, StockEstimates estimates)
{
return(CreateFishGenetics(fishId, geneticSampleId, labSampleId, estimates, null));
}
public FishGenetics CreateFishGenetics(Guid fishId, StockEstimates estimates, string description)
{
return(CreateFishGenetics(fishId, null, null, estimates, description));
}
public FishGenetics CreateFishGenetics(Guid fishId, StockEstimates estimates)
{
return(CreateFishGenetics(fishId, null, null, estimates, null));
}
