public FilestoreFile Create(SampleEventMap map, EntityBundle sites, EntityBundle instruments)
{
if (this.CanModify(map))
{
Guid id = Guid.NewGuid();
WaterQualityDET det = new WaterQualityDET();
det.Id = id;
det.Owner = "originator:" + sites.PrincipalOrgId.Identity.ToString() + ":" + instruments.PrincipalOrgId.Identity.ToString();
int ct = 0;
foreach (BundleElement cur in sites.Elements)
{
SiteDTO tmp = new SiteDTO();
tmp.Key = cur.LocalKey;
tmp.Name = cur.DisplayName;
det.Sites.Add(tmp);
ct++;
}
if (ct > 0) //has to be elements in the collection
{
ct = 0;
foreach (BundleElement cur in instruments.Elements)
{
InstrumentDTO tmp = new InstrumentDTO();
tmp.Key = cur.LocalKey;
tmp.Name = cur.DisplayName;
det.Instruments.Add(tmp);
ct++;
}
if (ct > 0)
{
det.Validate();
if (det.ValidationIssues.Count == 0)
{
IFileStoreProvider prov = this.FileStore;
if (prov != null)
{
FilestoreFile fil = prov.Make(id);
if (fil != null)
{
ExcelWaterQualityDET excel = new ExcelWaterQualityDET(det);
excel.Save(fil);
fil.Flush();
fil.Seek(0, System.IO.SeekOrigin.Begin);
return(fil);
}
}
}
}
}
}
return(null);
}
public static void WriteFile(string fName)
{
WaterQualityDET det = new WaterQualityDET();
det.Id = Guid.NewGuid();
det.Owner = "Dr. Frank N. Furter, ESQ";
ExcelWaterQualityDET excel = new ExcelWaterQualityDET(det);
CreateListOfPhonyDeployments(det, 4);
CreateListOfPhonyMeasurements(det, 6);
CreateListOfPhonySites(det, 4);
CreateListOfPhonySensors(det, 6);
excel.Save(fName);
}
public static void ReadFile(string fName)
{
Console.WriteLine("reading workbook named [{0}]", fName);
WaterQualityDET det = new WaterQualityDET();
ExcelWaterQualityDET excel = new ExcelWaterQualityDET(det);
excel.Load(fName);
ValidationIssues issues = det.ValidationIssues;
if (issues.Count > 0)
{
foreach (ValidationIssue issue in issues)
{
Console.WriteLine(issue.IssueMessage);
}
//return;
}
Console.WriteLine("Custom property Name: {0}, Value: {1}", "oncorID", det.Id);
Console.WriteLine("Custom property Name: {0}, Value: {1}", "oncorOwner", det.Owner);
int count = 1;
foreach (var dto in det.Deployments.Values)
{
Console.WriteLine("Deployment Row: {0}, Value: {1}", count++, dto);
}
count = 1;
foreach (var dto in det.Measurements.Values)
{
Console.WriteLine("Measurement Row: {0}, Value: {1}", count++, dto);
}
count = 1;
foreach (var dto in det.Sites.Values)
{
Console.WriteLine("Site Row: {0}, Value: {1}", count++, dto);
}
count = 1;
foreach (var dto in det.Instruments.Values)
{
Console.WriteLine("Sensor Row: {0}, Value: {1}", count++, dto);
}
Console.WriteLine("Closing workbook named [{0}]", fName);
}
public override UpdateStatus Update(FilestoreFile tempFileUpload, SampleEventMap map)
{
if (tempFileUpload != null)
{
FilestoreFile oldFile = this.Get(map);
if (oldFile != null)
{
if (this.CanModify(map))
{
WaterQualityDET curdet = new WaterQualityDET();
ExcelWaterQualityDET curexcel = new ExcelWaterQualityDET(curdet);
curexcel.Load(tempFileUpload);
curdet.Validate();
ValidationIssues curIssues = curdet.ValidationIssues;
if (curIssues.Count < 1)
{
WaterQualityDET olddet = new WaterQualityDET();
ExcelWaterQualityDET excel = new ExcelWaterQualityDET(olddet);
excel.Load(oldFile);
olddet.Validate();
ValidationIssues issues = olddet.ValidationIssues;
if (issues.Count < 1) //should be this is the old file
{
UpdateStatus status = null;
if (olddet.Deployments.Count < 1) //old file has no data - bare det
{
if (curdet.Deployments.Count < 1) //nothing to do really, new file has no data either
{
olddet = null;
excel = null;
oldFile.Dispose();
curdet = null;
curexcel = null;
FileStoreManager.Instance.GetProvider().Delete(tempFileUpload);
status = new UpdateStatus(UpdateIssue.AllOk);
status.Add(new IssueNotice("NoDataInEither", "nothing to do"));
return(status);
}
SampleEventMapItem item = map.Get(KnownDetType.WaterQuality);
if (item != null)
{
olddet = null; //release old reference
excel = null; //release old reference
//ok, no data in old file, but data in new file -- we have work to do -- handle first-time data insertion
IWQDeploymentProvider depl = WaterQualityManager.Instance.GetDeploymentProvider(this.Context);
IWQMeasurementProvider meas = WaterQualityManager.Instance.GetMeasurementProvider(this.Context);
if (depl != null && meas != null)
{
if (depl.CanCreate() && meas.CanCreate())
{
List <EntityBundle> bundles = this.GetBundles(map, KnownDetType.WaterQuality);
if (bundles != null && bundles.Count == 2)
{
status = this.InitialLoad(map.SampleEventId, bundles[0], bundles[1], curdet, depl, meas, item.IsPrivate);
if (status != null && status.Issue == UpdateIssue.AllOk) //success, so we overwrite the file
{
curdet = null;
curexcel = null;
olddet = null;
excel = null;
IFileStoreProvider ip = FileStoreManager.Instance.GetProvider();
if (ip.Replace(tempFileUpload, oldFile)) //overwrite the existing file with the new one
{
tempFileUpload.Dispose();
oldFile.Dispose();
return(status); //we're done here
}
else
{
status = new UpdateStatus(UpdateIssue.DataIssue);
status.Add(new IssueNotice("File", "Failed to replace file"));
}
}
}
else
{
status = new UpdateStatus(UpdateIssue.DataIssue);
status.Add(new IssueNotice("Bundles", "Failed to get bundles"));
}
}
else
{
status = new UpdateStatus(UpdateIssue.Security);
status.Add(new IssueNotice("Permissions", "create denied"));
}
}
else
{
status = new UpdateStatus(UpdateIssue.SystemIssue);
status.Add(new IssueNotice("Failure", "Failed to get provider"));
}
}
else
{
status = new UpdateStatus(UpdateIssue.NoExistingFile);
status.Add(new IssueNotice("NoMapEntry", "Failed to find map reference"));
}
return(status);
}
else //crap -- this is an update where existing file already had data
{
IWQDeploymentProvider depl = WaterQualityManager.Instance.GetDeploymentProvider(this.Context);
IWQMeasurementProvider meas = WaterQualityManager.Instance.GetMeasurementProvider(this.Context);
if (depl != null && meas != null)
{
if (depl.CanCreate() && meas.CanCreate())
{
SampleEventMapItem item = map.Get(KnownDetType.WaterQuality);
List <EntityBundle> bundles = this.GetBundles(map, KnownDetType.WaterQuality);
if (item != null && bundles != null && bundles.Count == 2)
{
status = this.DeltaLoad(map.SampleEventId, bundles[0], bundles[1], curdet, olddet, depl, meas, map);
if (status != null && status.Issue == UpdateIssue.AllOk) //success, so we overwrite the file
{
curdet = null;
curexcel = null;
olddet = null;
excel = null;
//NOTE -- making new file the permanent file and removing old file, then updating map for new file
IFileStoreProvider ip = FileStoreManager.Instance.GetProvider();
if (ip.Replace(tempFileUpload, oldFile)) //overwrite the existing file with the new one
{
tempFileUpload.Dispose();
oldFile.Dispose();
//ip.Delete(tempFileUpload); //may still be references so delete can fail
return(status); //we're done here
}
else
{
status = new UpdateStatus(UpdateIssue.DataIssue);
status.Add(new IssueNotice("File", "Failed to replace file"));
}
}
}
else
{
status = new UpdateStatus(UpdateIssue.DataIssue);
status.Add(new IssueNotice("Bundles", "Failed to get bundles"));
}
}
else
{
status = new UpdateStatus(UpdateIssue.Security);
status.Add(new IssueNotice("Permissions", "create denied"));
}
}
else
{
status = new UpdateStatus(UpdateIssue.SystemIssue);
status.Add(new IssueNotice("Failure", "Failed to get provider"));
}
return(status);
}
}
else
{
UpdateStatus stat = new UpdateStatus(UpdateIssue.NoExistingFile);
foreach (ValidationIssue cur in issues)
{
stat.Add(new IssueNotice(cur.IssueCode.ToString(), cur.IssueMessage));
}
return(stat);
}
}
else
{
UpdateStatus stat = new UpdateStatus(UpdateIssue.FileValidationIssues);
foreach (ValidationIssue cur in curIssues)
{
stat.Add(new IssueNotice(cur.IssueCode.ToString(), cur.IssueMessage));
}
return(stat);
}
}
else
{
UpdateStatus status = new UpdateStatus(UpdateIssue.Security);
status.Add(new IssueNotice("Permissions", "create denied"));
return(status);
}
}
return(new UpdateStatus(UpdateIssue.NoExistingFile));
}
return(new UpdateStatus(UpdateIssue.NoFilePosted));
}
