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