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)); }