private void deployRptToolStripMenuItem_Click(object sender, EventArgs e)
{
if (!FXFW.SqlDB.ChangeBasicSSRSAuthType())
{
MessageBox.Show("لم يتم تعديل صلاحيات خادم التقارير ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
FXFW.Settings rpt = new FXFW.Settings();
string reportserver = FXFW.SqlDB.ReportURL.Replace("http://", "");
reportserver = reportserver.Substring(0, reportserver.IndexOf("/"));
string[] arr = FXFW.SqlDB.ReportURL.Split(Convert.ToChar("/"));
rpt.GlobalSettings(reportserver, arr[arr.Length - 1]);
System.Data.SqlClient.SqlConnectionStringBuilder constring = new System.Data.SqlClient.SqlConnectionStringBuilder(FXFW.SqlDB.SqlConStr);
string constringpro = string.Format(@"data source={0};initial catalog={1}", constring.DataSource, constring.InitialCatalog);
rpt.CreateDataSource("DataSourceschoolStore", true, true, "Data Sources", constringpro, FXFW.Settings.CredentialRetrievalValues.Store, false, constring.UserID, constring.Password);
FXFW.Settings.Report[] reports = null;
foreach (FXFW.SqlDB.SQLReportsStr item in FXFW.SqlDB.SQLRep)
{
if (reports == null)
{
Array.Resize <FXFW.Settings.Report>(ref reports, 1);
}
else
{
Array.Resize <FXFW.Settings.Report>(ref reports, reports.Length + 1);
}
reports[reports.Length - 1].Name = item.RepFileName.Replace(".rdl", "");
reports[reports.Length - 1].FilePathValue = @"\rdl\" + item.RepFileName;
}
rpt.CreateReport("GroupDS", "DataSourceschoolStore", FXFW.SqlDB.ReportPath, 10080, reports);
FXFW.SqlDB.DeploySSRSReports(rpt);
FXFW.SqlDB.ChangeBasicSSRSAuthType();
}
private void navBarItemDeployRpt_LinkClicked(object sender, DevExpress.XtraNavBar.NavBarLinkEventArgs e)
{
try
{
if (!FXFW.SqlDB.ChangeBasicSSRSAuthType())
MessageBox.Show("لم يتم تعديل صلاحيات خادم التقارير ", "خطـــــــــــاء", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "خطـــــــــــاء", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
FXFW.Settings rpt = new FXFW.Settings();
string reportserver = FXFW.SqlDB.ReportURL.Replace("http://", "");
reportserver = reportserver.Substring(0, reportserver.IndexOf("/"));
string[] arr = FXFW.SqlDB.ReportURL.Split(Convert.ToChar("/"));
rpt.GlobalSettings(reportserver, arr[arr.Length - 1]);
System.Data.SqlClient.SqlConnectionStringBuilder constring = new System.Data.SqlClient.SqlConnectionStringBuilder(FXFW.SqlDB.SqlConStr);
string constringpro = string.Format(@"data source={0};initial catalog={1}", constring.DataSource, constring.InitialCatalog);
rpt.CreateDataSource("DataSourceStAccount", true, true, "Data Sources", constringpro, FXFW.Settings.CredentialRetrievalValues.Store, false, constring.UserID, constring.Password);
FXFW.Settings.Report[] reports = null;
foreach (FXFW.SqlDB.SQLReportsStr item in FXFW.SqlDB.SQLRep)
{
if (reports == null)
Array.Resize<FXFW.Settings.Report>(ref reports, 1);
else
Array.Resize<FXFW.Settings.Report>(ref reports, reports.Length + 1);
reports[reports.Length - 1].Name = item.RepFileName.Replace(".rdl", "");
reports[reports.Length - 1].FilePathValue = @"\rdl\" + item.RepFileName;
}
rpt.CreateReport("GroupDS", "DataSourceStAccount", FXFW.SqlDB.ReportPath, 10080, reports);
FXFW.SqlDB.DeploySSRSReports(rpt);
FXFW.SqlDB.ChangePublicSSRSAuthType();
}