public string CreateSubscription(SubscritionValues subscrition) { ReportingService2010 rs = new ReportingService2010(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; string report = subscrition.Report; string desc = System.Net.CredentialCache.DefaultCredentials + " subscribed " + subscrition.Report + " to EMAIL"; string eventType = "TimedSubscription"; string scheduleXml = getScheduleXML(subscrition); ParameterValue[] extensionParams = new ParameterValue[7]; extensionParams[0] = new ParameterValue(); extensionParams[0].Name = "RenderFormat"; extensionParams[0].Value = "PDF"; extensionParams[1] = new ParameterValue(); extensionParams[1].Name = "TO"; extensionParams[1].Value = subscrition.TO; extensionParams[2] = new ParameterValue(); extensionParams[2].Name = "IncludeReport"; extensionParams[2].Value = "true"; extensionParams[3] = new ParameterValue(); extensionParams[3].Name = "Subject"; extensionParams[3].Value = subscrition.Subject; extensionParams[4] = new ParameterValue(); extensionParams[4].Name = "IncludeLink"; extensionParams[4].Value = "true"; extensionParams[5] = new ParameterValue(); extensionParams[5].Name = "CC"; extensionParams[5].Value = subscrition.CC; extensionParams[6] = new ParameterValue(); extensionParams[6].Name = "BCC"; extensionParams[6].Value = subscrition.BCC; string matchData = scheduleXml; ExtensionSettings extSettings = new ExtensionSettings(); extSettings.ParameterValues = extensionParams; extSettings.Extension = "Report Server Email"; ParameterValue[] parameters = new ParameterValue[subscrition.Parameters.Length]; for (int i = 0; i < subscrition.Parameters.Length;i++ ) { ParameterValue parameter = new ParameterValue(); parameter.Name = subscrition.Parameters[i].ParameterName; parameter.Value = subscrition.Parameters[i].ParameterValue; parameters[i] = parameter; } try { string subscriptionID =rs.CreateSubscription(report, extSettings, desc, eventType, matchData, parameters); Dips_progression_subscription ps = new Dips_progression_subscription(); ps.indicator = subscrition.ConditionIndicator; ps.location = subscrition.ConditionLocation; ps.operand = subscrition.ConditionOperand; if (subscrition.ConditionValue!=null && subscrition.ConditionValue != "") ps.value = Double.Parse(subscrition.ConditionValue); ps.subscription_id = subscriptionID; ps.last_updated_date = DateTime.Now; ps.status = "Added"; if (ps.indicator != null) { db.Dips_progression_subscription.Add(ps); db.SaveChanges(); } return subscriptionID; } catch (SoapException e) { Console.WriteLine(e.Message); return "Subscribe failed "+e.Message; } }
private DIPS.ReportService2010.CatalogItem[] ListChildren(string folder = "/") { ReportingService2010 rs = new ReportingService2010(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; List<CatalogItem> result = new List<CatalogItem>(); CatalogItem[] list = rs.ListChildren(folder, false); foreach (var item in list) { if (!item.Hidden) result.Add(item); } return result.ToArray(); }
public IEnumerable<Subscription> ListSubscribedReports() { ReportingService2010 rs = new ReportingService2010(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; return rs.ListMySubscriptions("/").OrderBy(subscription=>subscription.Report); }
public List<ItemParameter> GetReportParameters(string id) { if (id != "/") id = Base64Decode(id); ReportingService2010 rs = new ReportingService2010(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; bool forRendering = true; string historyID = null; ParameterValue[] values = null; DataSourceCredentials[] credentials = null; ItemParameter[] parameters = null; try { parameters = rs.GetItemParameters(id, historyID, forRendering, values, credentials); return parameters.ToList(); } catch (SoapException e) { Console.WriteLine(e.Detail.InnerXml.ToString()); return null; } }
public string DeleteSubscription(string id) { if (id != "/") id = Base64Decode(id); ReportingService2010 rs = new ReportingService2010(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; try { rs.DeleteSubscription(id); return "OK"; } catch (SoapException e) { Console.WriteLine(e.Detail.InnerXml.ToString()); return "e.Detail.InnerXml.ToString()"; } }
public ActionResult SubscribedReport() { ReportingService2010 rs = new ReportingService2010(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; return PartialView(rs.ListMySubscriptions("/").ToList()); }