/// <summary>
///
/// </summary>
private void GenerateReport()
{
var xm = new XmlDocument();
ConvertToXml(ref xm);
var xml = xm.InnerXml.ToString();
rptViewerCustomerLanguage.Visible = true;
rptViewerCustomerLanguage.ProcessingMode = ProcessingMode.Remote;
using (Models.ReportDatabaseEntities db = new Models.ReportDatabaseEntities())
{
WebReportServer rs = db.WebReportServers.SingleOrDefault();
WebReportCatalogue wc = (reportID != null) ? db.WebReportCatalogues.Where(K => K.ReportId_PK == reportID).SingleOrDefault() : db.WebReportCatalogues.SingleOrDefault();
rptViewerCustomerLanguage.ServerReport.ReportServerUrl = new Uri(rs.ServerURL);
rptViewerCustomerLanguage.ServerReport.ReportServerCredentials = new CustomReportCredentials(rs.UserID, rs.Password, rs.ServerName);
rptViewerCustomerLanguage.ServerReport.ReportPath = wc.ReportPath + wc.Name;
ReportDataSource dataSource = new ReportDataSource(rptName, db.Get_CustomerReportLanguages(paramValue));
}
//SqlCommand cmd = new SqlCommand();
//cmd.Parameters.Add(new SqlParameter("@cParams", paramValue));
//string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
//SqlConnection conn = new SqlConnection(connectionstring);
//conn.Open();
//cmd.Connection = conn;
//cmd.CommandText = "Get_CustomerReportLanguages";
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataSet ds = new DataSet();
//da.Fill(ds);
//rptViewerCustomerLanguage.ServerReport.datas.Clear();
//rptViewerCustomerLanguage.LocalReport.DataSources.Add(dataSource);
System.Collections.Generic.List <ReportParameter> lstParams = new List <ReportParameter>();
lstParams.Add(new ReportParameter("cParams", xml));
rptViewerCustomerLanguage.ServerReport.SetParameters(lstParams);
//Assembly assembly = Assembly.LoadFrom("MyReports.dll");
//Stream stream = assembly.GetManifestResourceStream("Reports.MyReport.rdlc");
//rptViewerCustomerLanguage.LocalReport.LoadReportDefinition(stream);
rptViewerCustomerLanguage.ShowParameterPrompts = false;
rptViewerCustomerLanguage.ShowPrintButton = true;
rptViewerCustomerLanguage.ServerReport.Refresh();
}
public List<DCControl> Create(Guid reportID)
{
ReportDatabaseEntities db = new ReportDatabaseEntities();
var result = new List<DCControl>();
var data = (from ctrl in db.WebReportParameters.ToList().OrderBy(k => k.OrderByControl).ToList()
join CP in db.WebReportParamCascadeMappings.ToList() on ctrl.RPId_PK equals CP.PRId_FK
where CP.ReportId_FK==reportID
&& ctrl.isActive== true
orderby CP.OrderByControl
select new { Control = ctrl, CParam = CP});
foreach(var d in data)
{
DCControl ddl;
switch (d.Control.Name )
{
case "Customer":
ddl = new CustomerDropDown();
ddl.Name = d.Control.Name;
ddl.Title = d.Control.Name;
ddl.ControlType.Options = (from c in db.Customers
select new OptionValue
{
DisplayUniqueID = c.CustomerId_PK,
DisplayValue = c.FirstName + " " + c.LastName,
ParentID = (Guid) c.CountryID_FK
}
).ToList<OptionValue>();
ddl.SelectedValue = ddl.ControlType.Options[0];
ddl.ngModel = ddl.SelectedValue.ToString();
break;
case "Country":
ddl = new CountryDropDown();
ddl.Name = d.Control.Name;
ddl.Title = d.Control.Name;
ddl.ControlType.Options = (from c in db.Countries
select new OptionValue
{
DisplayUniqueID = c.CountryId_PK,
DisplayValue = c.Name
}
).ToList<OptionValue>();
ddl.SelectedValue = ddl.ControlType.Options[0];
ddl.ngModel = ddl.SelectedValue.ToString();
break;
case "State":
ddl = new CountryDropDown();
ddl.Name = d.Control.Name;
ddl.Title = d.Control.Name;
ddl.ControlType.Options = (from c in db.States
select new OptionValue
{
DisplayUniqueID = c.StateId_PK,
DisplayValue = c.Name,
ParentID = (Guid) c.CountryID_FK
}
).ToList<OptionValue>();
ddl.SelectedValue = ddl.ControlType.Options[0];
ddl.ngModel = ddl.SelectedValue.ToString();
break;
case "City":
ddl = new CountryDropDown();
ddl.Name = d.Control.Name;
ddl.Title = d.Control.Name;
ddl.ControlType.Options = (from c in db.Cities
select new OptionValue
{
DisplayUniqueID = c.CityId_PK,
DisplayValue = c.Name,
ParentID = (Guid)c.StateID_FK
}
).ToList<OptionValue>();
ddl.SelectedValue = ddl.ControlType.Options[0];
ddl.ngModel = ddl.SelectedValue.ToString();
break;
case "Languages":
ddl = new LanguageCheckBox();
ddl.Name = d.Control.Name;
ddl.Title = d.Control.Name;
ddl.ControlType.Options = (from r in
((from c in db.Languages
select new LanguageList
{
LanguageId = c.LanguageId_PK,
Name = c.Name,
}).ToList())
select new OptionValue
{
DisplayUniqueID = r.LanguageId,
DisplayValue = r.Name
}
).ToList<OptionValue>();
break;
case "DateOfJoining":
ddl = new DateTimeBox();
ddl.Name = d.Control.Name;
ddl.Title = d.Control.Name;
break;
case "DateOfBirth":
ddl = new DateTimeBox();
ddl.Name = d.Control.Name;
ddl.Title = d.Control.Name;
break;
default:
ddl = null;
break;
}
if (ddl != null)
{
result.Add(ddl);
}
}
return result;
}
/// <summary>
///
/// </summary>
private void GenerateReport()
{
var xm = new XmlDocument();
ConvertToXml(ref xm);
var xml = xm.InnerXml.ToString();
rptViewerCustomerLanguage.Visible = true;
rptViewerCustomerLanguage.ProcessingMode = ProcessingMode.Remote;
using (Models.ReportDatabaseEntities db = new Models.ReportDatabaseEntities())
{
WebReportServer rs = db.WebReportServers.SingleOrDefault();
WebReportCatalogue wc = (reportID != null) ? db.WebReportCatalogues.Where(K=> K.ReportId_PK== reportID).SingleOrDefault() : db.WebReportCatalogues.SingleOrDefault();
rptViewerCustomerLanguage.ServerReport.ReportServerUrl = new Uri( rs.ServerURL);
rptViewerCustomerLanguage.ServerReport.ReportServerCredentials = new CustomReportCredentials(rs.UserID,rs.Password,rs.ServerName );
rptViewerCustomerLanguage.ServerReport.ReportPath = wc.ReportPath + wc.Name;
ReportDataSource dataSource = new ReportDataSource(rptName, db.Get_CustomerReportLanguages(paramValue));
}
//SqlCommand cmd = new SqlCommand();
//cmd.Parameters.Add(new SqlParameter("@cParams", paramValue));
//string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
//SqlConnection conn = new SqlConnection(connectionstring);
//conn.Open();
//cmd.Connection = conn;
//cmd.CommandText = "Get_CustomerReportLanguages";
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
//SqlDataAdapter da = new SqlDataAdapter(cmd);
//DataSet ds = new DataSet();
//da.Fill(ds);
//rptViewerCustomerLanguage.ServerReport.datas.Clear();
//rptViewerCustomerLanguage.LocalReport.DataSources.Add(dataSource);
System.Collections.Generic.List<ReportParameter> lstParams = new List<ReportParameter>();
lstParams.Add(new ReportParameter("cParams", xml));
rptViewerCustomerLanguage.ServerReport.SetParameters(lstParams);
//Assembly assembly = Assembly.LoadFrom("MyReports.dll");
//Stream stream = assembly.GetManifestResourceStream("Reports.MyReport.rdlc");
//rptViewerCustomerLanguage.LocalReport.LoadReportDefinition(stream);
rptViewerCustomerLanguage.ShowParameterPrompts = false;
rptViewerCustomerLanguage.ShowPrintButton = true;
rptViewerCustomerLanguage.ServerReport.Refresh();
}