//ref
//http://www.dotblogs.com.tw/jojo/archive/2010/01/06/12855.aspx
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
ReportDocument cryRpt = new ReportDocument();//請引用CrystalDecisions.CrystalReports.Engine
string cmd = System.IO.Path.Combine(System.Windows.Forms.Application.StartupPath, "CR_param.rpt");
cryRpt.Load(cmd);
//set db
CrystalDecisions.Shared.TableLogOnInfo myLoginInfo = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in cryRpt.Database.Tables)
{
myLoginInfo.ConnectionInfo.ServerName = "SERV16";
myLoginInfo.ConnectionInfo.UserID = "sa";
myLoginInfo.ConnectionInfo.Password = "******";
myTable.ApplyLogOnInfo(myLoginInfo);
}
//set param
//首先您必須先加入CrystalDecisions.Shared及CrystalDecisions.CrystalReports.Engine參考:
ParameterValues values = new ParameterValues();
ParameterDiscreteValue value = new ParameterDiscreteValue();
value.Value = "TEST";
values.Add(value);
cryRpt.DataDefinition.ParameterFields["param"].ApplyCurrentValues(values);
//
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
// This method will allow you may easily set report datasource based on your current SqlServerConnetion
public static void SetSqlConnection(CrystalDecisions.CrystalReports.Engine.ReportClass MyReport, SqlConnection MySqlConnection)
{
// You may even test SqlConnection before using it.
SqlConnectionStringBuilder SqlConnectionStringBuilder = new SqlConnectionStringBuilder(MySqlConnection.ConnectionString);
string ServerName = SqlConnectionStringBuilder.DataSource;
string DatabaseName = SqlConnectionStringBuilder.InitialCatalog;
Boolean IntegratedSecurity = SqlConnectionStringBuilder.IntegratedSecurity;
string UserID = SqlConnectionStringBuilder.UserID;
string Password = SqlConnectionStringBuilder.Password;
// Of course, you may add extra settings here :D
// On Crystal Reports, connection must be set individually for each table defined on the report document
foreach (CrystalDecisions.CrystalReports.Engine.Table Table in MyReport.Database.Tables)
{
CrystalDecisions.Shared.TableLogOnInfo TableLogOnInfo = Table.LogOnInfo;
TableLogOnInfo.ConnectionInfo.ServerName = ServerName;
TableLogOnInfo.ConnectionInfo.DatabaseName = DatabaseName;
TableLogOnInfo.ConnectionInfo.IntegratedSecurity = IntegratedSecurity;
if (IntegratedSecurity != true)
{
TableLogOnInfo.ConnectionInfo.UserID = UserID;
TableLogOnInfo.ConnectionInfo.Password = Password;
}
Table.ApplyLogOnInfo(TableLogOnInfo);
}
}
public frmRelBasicos(string pArquivo, string pTitulo)
{
InitializeComponent();
relArquivo = pArquivo;
relTitulo = pTitulo;
this.Text = pTitulo;
//Objeto com informações de conexão para as tabelas do rpt
conexaoCrystal = new CrystalDecisions.Shared.ConnectionInfo();
conexaoCrystal.ServerName = @"(local)\SQLEXPRESS";
conexaoCrystal.UserID = "sa";
conexaoCrystal.Password = "******";
conexaoCrystal.DatabaseName = "Copa2010";
//Carregar o arquivo do rpt pArquivo
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Application.StartupPath + @"..\..\..\Relatorios\" + relArquivo);
//Informe o rpt com as informações de conexão
CrystalDecisions.Shared.TableLogOnInfo logonInfo = new CrystalDecisions.Shared.TableLogOnInfo();
logonInfo.ConnectionInfo = conexaoCrystal;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in report.Database.Tables)
{
table.LogOnInfo.ConnectionInfo = conexaoCrystal;
table.ApplyLogOnInfo(logonInfo);
}
//Liga ao Visualizador
crvRel.ReportSource = report;
}
private void Form2_Load(object sender, EventArgs e)
{
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_List_Hoghogh1.Database.Tables.Count - 1; intCounter++)
{
report_List_Hoghogh1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
paramField1.Name = "@noe";
paramDiscreteValue1.Value = sarbarg;
paramField1.CurrentValues.Add(paramDiscreteValue1);
paramFields.Add(paramField1);
crystalReportViewer1.ReportSource = report_List_Hoghogh1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
public void SetDataSource(CrystalReport_tkLoaiMonAn report, string serverName, string databaseName)
{
// Set the connection for the main report.
report.DataSourceConnections[0].SetConnection(serverName, databaseName, true);
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
ConnectionInfo connectionInfo = new ConnectionInfo();
CrystalDecisions.Shared.TableLogOnInfo tlicurrent = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table table in report.Database.Tables)
{
connectionInfo.DatabaseName = databaseName;
connectionInfo.ServerName = serverName;
connectionInfo.IntegratedSecurity = true;
tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo.ServerName = serverName;
table.ApplyLogOnInfo(tableLogonInfo);
table.Location = tableLogonInfo.ConnectionInfo.DatabaseName + ".dbo." +
table.Location.Substring(table.Location.LastIndexOf(".") + 1);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
li = new TableLogOnInfo();
PDCFolder.PDCLoanListing cr = new PDCFolder.PDCLoanListing();
li.ConnectionInfo.IntegratedSecurity = false;
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM vw_PDCManagementV2_SearchLoanType WHERE ChequeDate Between '" + dtLoanFrom.Text + "' and '" + dtLoanTo.Text + "'", con);
DataTable dt = new DataTable();
DataSet ds = new DataSet();
li = new TableLogOnInfo();
li.ConnectionInfo.IntegratedSecurity = false;
adapter.Fill(ds, "vw_PDCManagementReportV2");
dt = ds.Tables["vw_PDCManagementReportV2"];
cr.SetDataSource(ds.Tables["vw_PDCManagementReportV2"]);
//PARAMETERS
cr.SetParameterValue("pdcDate", "PDC FROM : " + dtLoanFrom.Text + " To " + dtLoanTo.Text);
cr.SetParameterValue("printedBy", Classes.clsUser.Username.ToString());
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
crystalReportViewer1.ReportSource = cr;
}
}
protected void CrystalReportViewer1_Navigate(object source, CrystalDecisions.Web.NavigateEventArgs e)
{
getQueryString();
printData();
crConnectionInfo.DatabaseName = strDbname;
crConnectionInfo.ServerName = strServername;
crConnectionInfo.UserID = strDbuser;
crConnectionInfo.Password = strDbpassword;
crTables = oRpt.Database.Tables;
//apply logon info
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in oRpt.Database.Tables)
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
//apply logon info for sub report
//foreach (Section crSection in oRpt.ReportDefinition.Sections)
//{
// foreach (ReportObject crReportObject in crSection.ReportObjects)
// {
// if (crReportObject.Kind == ReportObjectKind.SubreportObject)
// {
// SubreportObject crSubReportObj = (SubreportObject)(crReportObject);
// foreach (CrystalDecisions.CrystalReports.Engine.Table oTable in crSubReportObj.OpenSubreport(crSubReportObj.SubreportName).Database.Tables)
// {
// crTableLogOnInfo = oTable.LogOnInfo;
// crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
// oTable.ApplyLogOnInfo(crTableLogOnInfo);
// }
// }
// }
//}
string strReportDirectoryTempPhysicalPath = Server.MapPath(this.ReportDirectoryTemp);
Helper.DeleteUnusedFile(strReportDirectoryTempPhysicalPath, ReportAliveTime);
string strFilename;
strFilename = "report_" + DateTime.Now.ToString("yyyyMMddHH-mm-ss");
oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("~/temp/") + strFilename + ".pdf");
//lnkPdfFile.NavigateUrl = "~/temp/" + strFilename + ".pdf";
//imgPdf.Src = "~/images/icon_pdf.gif";
//lnkExcelFile.Visible = false;
//if (ViewState["report_code"].ToString() == "Rep_exceldebitall")
//{
// oRpt.ExportToDisk(ExportFormatType.ExcelRecord, Server.MapPath("~/temp/") + strFilename + ".xls");
// lnkExcelFile.NavigateUrl = "~/temp/" + strFilename + ".xls";
// imgExcel.Src = "~/images/icon_excel.gif";
// lnkExcelFile.Visible = true;
//}
//CrystalReportViewer1.ReportSource = oRpt;
}
private void GenerarPDF(int PlantillaID)
{
try
{
//string SPath = this.saveFileDialog1.FileName = "Cotizacion_Nro_" + this.saveFileDialog1.FileName; // Default file name
//this.saveFileDialog1.DefaultExt = ".PDF"; // Default file extension
//this.saveFileDialog1.Filter = "Text documents (.pdf)|*.pdf"; // Filter files by extension
//if (this.saveFileDialog1.ShowDialog() != DialogResult.Cancel)
//{
string SPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "\\PDF\\" + "Reclamo.pdf"; // = "Cotizacion_Nro_" + _nroCotizacion; // Default file name
ReportDocument objReport = new ReportDocument();
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "InformeReclamoMercaderia.rpt";
objReport.Load(reportPath);
this.progressBar1.Step = 30;
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
CrystalDecisions.Shared.TableLogOnInfo logoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false; //cambiado a false por la linea de arriba
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
//PRIMER PARAMTRO
objReport.SetParameterValue(0, PlantillaID);
this.progressBar1.Value = 40;
//GUARDO EN FORMATO PDF
objReport.ExportToDisk(ExportFormatType.PortableDocFormat, SPath.ToString());
this.progressBar1.Value = 60;
EnviarMail(SPath);
//MessageBox.Show("Se generó el archivo PDF: ", "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ChangeReportDataBase(ReportDocument myReport, string servername, string sa, string pwd)
{
CrystalDecisions.Shared.TableLogOnInfo myLoginInfo = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in myReport.Database.Tables)
{
myLoginInfo.ConnectionInfo.ServerName = servername;
myLoginInfo.ConnectionInfo.UserID = sa;
myLoginInfo.ConnectionInfo.Password = pwd;
myTable.ApplyLogOnInfo(myLoginInfo);
}
}
private void GenerarPDFProveedor(string codEmp, int _nroCotizacion)
{
try
{
//string SPath = this.saveFileDialog1.FileName = "Cotizacion_Nro_" + this.saveFileDialog1.FileName; // Default file name
this.saveFileDialog1.DefaultExt = ".PDF"; // Default file extension
this.saveFileDialog1.Filter = "Text documents (.pdf)|*.pdf"; // Filter files by extension
if (this.saveFileDialog1.ShowDialog() != DialogResult.Cancel)
{
string SPath = this.saveFileDialog1.FileName; // = "Cotizacion_Nro_" + _nroCotizacion; // Default file name
ReportDocument objReport = new ReportDocument();
String reportPath = ConfigurationManager.AppSettings["Reports"] + "\\Reporting\\" + "PedidoCotizacion.rpt";
objReport.Load(reportPath);
objReport.Refresh();
objReport.ReportOptions.EnableSaveDataWithReport = false;
// PARAMETROS DE CONEXION
CrystalDecisions.Shared.TableLogOnInfo logoninfo = new CrystalDecisions.Shared.TableLogOnInfo();
logoninfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings["CatalogSTACATALINA"];
logoninfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["Source"];
logoninfo.ConnectionInfo.UserID = ConfigurationManager.AppSettings["User ID"];
logoninfo.ConnectionInfo.Password = ConfigurationManager.AppSettings["Password"];
logoninfo.ConnectionInfo.IntegratedSecurity = false; //cambiado a false por la linea de arriba
Tables tables = objReport.Database.Tables;
foreach (Table table in tables)
{
table.ApplyLogOnInfo(logoninfo);
}
//PRIMER PARAMTRO
objReport.SetParameterValue(0, codEmp.Trim());
objReport.SetParameterValue(1, _nroCotizacion);
//GUARDO EN FORMATO PDF
objReport.ExportToDisk(ExportFormatType.PortableDocFormat, SPath.ToString());
MessageBox.Show("Se generó el pedido de Cotización Nro: " + _nroCotizacion, "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void Form3_Load(object sender, EventArgs e)
{
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_BimehReport1.Database.Tables.Count - 1; intCounter++)
{
report_BimehReport1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
crystalReportViewer1.ReportSource = report_BimehReport1;
}
private void SetTableLogin(CrystalDecisions.CrystalReports.Engine.Table table)
{
CrystalDecisions.Shared.TableLogOnInfo tliCurrent = table.LogOnInfo;
string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
var builder = new SqlConnectionStringBuilder(connectionString);
//var dataSource = builder.DataSource;
tliCurrent.ConnectionInfo.UserID = builder.UserID; //"sa";
tliCurrent.ConnectionInfo.Password = builder.Password; //"aziz123";
tliCurrent.ConnectionInfo.DatabaseName = builder.InitialCatalog; //"Restaurant_DB"; //Database is not needed for Oracle & MS Access
tliCurrent.ConnectionInfo.ServerName = builder.DataSource; //"NIMBLE\\SQL2K8";
table.ApplyLogOnInfo(tliCurrent);
}
public static void SetTableLogin(CrystalDecisions.CrystalReports.Engine.Table table)
{
CrystalDecisions.Shared.TableLogOnInfo tliCurrent = table.LogOnInfo;
tliCurrent.ConnectionInfo.UserID = builder.UserID;
tliCurrent.ConnectionInfo.Password = builder.Password;
if (builder.InitialCatalog != null)
{
tliCurrent.ConnectionInfo.DatabaseName = builder.InitialCatalog;
}
if (builder.DataSource != null)
{
tliCurrent.ConnectionInfo.ServerName = builder.DataSource;
}
table.ApplyLogOnInfo(tliCurrent);
}
public static void SetReportSourceLocal(ref ReportClass report)
{
ConnectionInfo crConnection = new ConnectionInfo();
crConnection.ServerName = LocalServerName;
crConnection.DatabaseName = LocalDatabaseName;
crConnection.UserID = LocalUserID;
crConnection.Password = LocalPassword;
CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
{
CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = crConnection;
table.ApplyLogOnInfo(tableLogonInfo);
}
}
private void btnVisualizar_Click(object sender, EventArgs e)
{
//Objeto com informações de conexão para as tabelas do rpt
conexaoCrystal = new CrystalDecisions.Shared.ConnectionInfo();
conexaoCrystal.ServerName = @"(local)\SQLEXPRESS";
conexaoCrystal.UserID = "sa";
conexaoCrystal.Password = "******";
conexaoCrystal.DatabaseName = "Copa2010";
//Carregar o arquivo do rpt pArquivo
CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
report.Load(Application.StartupPath + @"..\..\..\Relatorios\relJogadores.rpt");
//Alimenta os parametros
ParameterField pEquipe;
pEquipe = report.ParameterFields["pEquipe"];
try
{
if (cbEquipe.SelectedValue.ToString().Trim() != "0")
{
pEquipe.CurrentValues.AddValue(cbEquipe.GetItemText(cbEquipe.SelectedItem));
}
else
{
pEquipe.CurrentValues.AddValue("");
}
}
catch (Exception ex)
{
Console.Write("Erro: " + ex.Message.ToString());
}
//Informe o rpt com as informações de conexão
CrystalDecisions.Shared.TableLogOnInfo logonInfo = new CrystalDecisions.Shared.TableLogOnInfo();
logonInfo.ConnectionInfo = conexaoCrystal;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in report.Database.Tables)
{
table.LogOnInfo.ConnectionInfo = conexaoCrystal;
table.ApplyLogOnInfo(logonInfo);
}
//Liga ao Visualizador
this.crvRelJogadores.ReportSource = report;
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var Entity = new RTMEntities();
var report = new RTM.Report.GenralRep.Contractors_();
////////Login Info
ConnectionInfo crConnection = new ConnectionInfo();
crConnection.ServerName = @"GIS-SERVER";
crConnection.DatabaseName = "ratec";
crConnection.UserID = "ratec";
crConnection.Password = "******";
CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
{
CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = crConnection;
table.ApplyLogOnInfo(tableLogonInfo);
}
////////
//report.SetDatabaseLogon("ratec", "ratec");
var result = (from items in MyList
select new cc
{
CompanyName = items.CompanyName != null?(string)items.CompanyName:"-",
NationalIdNumber = items.NationalIdNumber != null ? (string)items.NationalIdNumber : "-",
CompanyType = items.CompanyType != null ? (string)items.CompanyType : "-",
Telephone = items.Telephone != null?(string)items.Telephone:"-",
Fax = items.Fax != null?(string)items.Fax:"-",
CeoEmailAddress = items.CeoEmailAddress != null?(string)items.CeoEmailAddress:"-",
CompanyField1 = items.CompanyField1 != null?(string)items.CompanyField1:"-",
CompanyBase1 = items.CompanyBase1 != null?(int)items.CompanyBase1:5,
Design = items.Design != null?(bool)items.Design:false,
Procurement = items.Procurement != null?(bool)items.Procurement:false,
BuildAndOperation = items.BuildAndOperation != null?(bool)items.BuildAndOperation:false,
Finance = items.Finance != null?(bool)items.Finance:false,
ContractorId = (int)items.ContractorId,
}).ToList();
report.SetDataSource(result);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
//public virtual void RefreshReport ();
private void ConfigureCrystalReports()
{
ReportDocument Report = new ReportDocument();
string strFiltro;
try
{
strFiltro = "{vwSTNuevoReporteLiquidacion.Folio} = " + _Folio + "and {vwSTNuevoReporteLiquidacion.AñoAtt} = " + _AñoAtt + "";
this.cvrReporte.SelectionFormula = strFiltro;
Report.Load(Modulo.GLOBAL_RutaReportes + "\\" + "ImprimeLiquidacionServicioTecnico.rpt");
cvrReporte.ReportSource = Report;
foreach (Table TablaActual in Report.Database.Tables)
{
LoginActual = TablaActual.LogOnInfo;
LoginActual.ConnectionInfo.ServerName = LiquidacionSTN.Modulo.GLOBAL_Servidor;
LoginActual.ConnectionInfo.DatabaseName = LiquidacionSTN.Modulo.GlOBAL_Database;
LoginActual.ConnectionInfo.UserID = Modulo.GLOBAL_UsuarioReporte;
LoginActual.ConnectionInfo.Password = Modulo.GLOBAL_PasswordReporte;
TablaActual.ApplyLogOnInfo(LoginActual);
}
this.cvrReporte.Dock = DockStyle.Fill;
this.cvrReporte.RefreshReport();
this.cvrReporte.Show();
}
catch (CrystalDecisions.CrystalReports.Engine.LoadSaveReportException Ex)
{
MessageBox.Show("Ruta del reporte Incorrecta" + Ex.Message, "Servicios Técnicos", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception Except)
{
MessageBox.Show("Error al cargar el reporte" + Except.Message + Except.Source, "Servicios Técnicos", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected override void ExportReportUsingCrystal(string reportPath, ExportFormatType reportType)
{
string absolutePathFilename1 = string.Empty;
absolutePathFilename1 = reportPath;
Page1 = new LLPotential();
DiskFileDestinationOptions destinationOptions = new DiskFileDestinationOptions();
CrystalDecisions.Shared.TableLogOnInfo
myLogin = new CrystalDecisions.Shared.TableLogOnInfo();
myLogin.ConnectionInfo.UserID = ConfigurationManager.AppSettings["CrystalUser"];
myLogin.ConnectionInfo.Password = ConfigurationManager.AppSettings["CrystalPassword"];
myLogin.ConnectionInfo.DatabaseName = "";
myLogin.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["CrystalDB"];
for (int i = 0; i < Page1.Database.Tables.Count; i++)
{
Page1.Database.Tables[i].ApplyLogOnInfo(myLogin);
}
SetReportParameters();
Page1.ExportOptions.ExportFormatType = reportType;
Page1.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
try
{
destinationOptions.DiskFileName = absolutePathFilename1;
Page1.ExportOptions.DestinationOptions = destinationOptions;
Page1.Export();
}
catch (Exception ex)
{
throw new ApplicationException("An unexpected error occurred trying to export the report: " + ex.ToString());
}
finally
{
}
}
public void SetDatabase(ReportDocument Rpt)
{
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
CrystalDecisions.Shared.TableLogOnInfos MyTableLogOnInfos = new CrystalDecisions.Shared.TableLogOnInfos();
CrystalDecisions.Shared.TableLogOnInfo MyTableLogOnInfo = new CrystalDecisions.Shared.TableLogOnInfo();
CrystalDecisions.Shared.ConnectionInfo MyConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
//conStr = Session["Connectionstring"].ToString();
MyTableLogOnInfo.ConnectionInfo = SetConnectionString(MyConnectionInfo, ConnectionString);
MyTableLogOnInfos.Add(MyTableLogOnInfo);
AdminActivityCRViewer.LogOnInfo = MyTableLogOnInfos;
crDatabase = Rpt.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
MyTableLogOnInfo = crTable.LogOnInfo;
MyTableLogOnInfo.ConnectionInfo = MyConnectionInfo;
crTable.ApplyLogOnInfo(MyTableLogOnInfo);
}
setParameters(Rpt);
}
//ref
//http://www.dotblogs.com.tw/jojo/archive/2010/01/06/12855.aspx
private void crystalReportViewer1_Load(object sender, EventArgs e)
{
ReportDocument cryRpt = new ReportDocument();//請引用CrystalDecisions.CrystalReports.Engine
string cmd = System.IO.Path.Combine(System.Windows.Forms.Application.StartupPath, "CR.rpt");
cryRpt.Load(cmd);
//set db
CrystalDecisions.Shared.TableLogOnInfo myLoginInfo = new CrystalDecisions.Shared.TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in cryRpt.Database.Tables)
{
myLoginInfo.ConnectionInfo.ServerName = "SERV16";
myLoginInfo.ConnectionInfo.UserID = "sa";
myLoginInfo.ConnectionInfo.Password = "******";
myTable.ApplyLogOnInfo(myLoginInfo);
}
//
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();
}
// private void ConfigureCrystalReports()
// {
// Try
// {
// ConnectionInfo myConnectionInfo = new ConnectionInfo();
// // Dim rpt As New rptCardPrinting()
// Tables myTables = myReportDocument.Database.Tables;
// foreach (Table myTable in myTables)
// {
// //For Each myTable As CrystalDecisions.CrystalReports.Engine.Table In myTables
// TableLogOnInfo myTableLogonInfo = myTable.LogOnInfo;
// myConnectionInfo.ServerName = MyModules.ServerName;
// myConnectionInfo.DatabaseName = "";
// myConnectionInfo.UserID = MyModules.UserID;
// myConnectionInfo.Password = MyModules.Password;
// myTableLogonInfo.ConnectionInfo = myConnectionInfo;
// myTable.ApplyLogOnInfo(myTableLogonInfo);
// }
// // frmReportViewer.CrystalReportViewer1.ReportSource = rpt
// //rpt.SetParameterValue("prt", txtCnicPassport.Text)
// //rpt.PrintToPrinter(1, False, 0, 0)
// //rpt.Close()
// //rpt.Dispose()
// ex As Exception
// MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
//End Try
// }
private void ConfigureCrystalReports()
{
try
{
int intCounter = 0;
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.DatabaseName = MyModules.AttachName;
ConInfo.ConnectionInfo.ServerName = MyModules.ServerName;
if (MyModules.IntegratedSecurity)
{
ConInfo.ConnectionInfo.IntegratedSecurity = true;
}
else
{
ConInfo.ConnectionInfo.Password = MyModules.Password;
ConInfo.ConnectionInfo.UserID = MyModules.UserID;
}
myReportDocument.DataSourceConnections.Clear();
for (intCounter = 0; intCounter < myReportDocument.Database.Tables.Count; intCounter++)
{
myReportDocument.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
if (RptDestination == "Printer")
{
// You can change more print options via PrintOptions property of ReportDocument
// myCrystalReportViewer.PrintReport()
myReportDocument.PrintToPrinter(1, true, 0, 0);
myReportDocument.Close();
}
return;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
li = new TableLogOnInfo();
PDCFolder.PDCLoanListing cr = new PDCFolder.PDCLoanListing();
li.ConnectionInfo.IntegratedSecurity = false;
//PARAMETERS
cr.SetParameterValue("pdcDate", "PDC FROM : " + dtLoanFrom.Text + " To " + dtLoanTo.Text);
cr.SetParameterValue("printedBy", Classes.clsUser.Username.ToString());
cr.SetParameterValue("@loanDateFrom", dtLoanFrom.Text);
cr.SetParameterValue("@loanDateTo", dtLoanTo.Text);
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
crystalReportViewer1.ReportSource = cr;
}
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
var report = new RTM.Report.GenralRep.WebDocRecieve();
//report.SetDatabaseLogon("ratec", "ratec");
ConnectionInfo crConnection = new ConnectionInfo();
crConnection.ServerName = @"GIS-SERVER";
crConnection.DatabaseName = "ratec";
crConnection.UserID = "ratec";
crConnection.Password = "******";
CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
{
CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = crConnection;
table.ApplyLogOnInfo(tableLogonInfo);
}
foreach (TenderingFileDownload t in MyList)
{
t.PersianDate = DateConverter.ConvertDate(t.date);
}
report.SetDataSource(MyList);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (txtLoanNo.Text == "")
{
Alert.show("Loan No. is required.", Alert.AlertType.error);
return;
}
//Check if the loan no is in database
if (clsPLBI.checkLoanNo(txtLoanNo.Text) != true)
{
Alert.show("Loan No. is required.", Alert.AlertType.error);
return;
}
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
CrystalDecisions.Shared.TableLogOnInfo li;
string str = "SELECT * FROM vw_CoMakers WHERE Loan_No = '" + txtLoanNo.Text + "'";
//=======================================================
// for sub report
//=======================================================
SqlDataAdapter subreportAdapter = new SqlDataAdapter(str, con);
DataTable dtsubreport = new DataTable();
DataSet dsSubreport = new DataSet();
DataSet ds = new DataSet();
//=============================================================
ReportsForms.PLBI cr = new ReportsForms.PLBI();
li = new TableLogOnInfo();
li.ConnectionInfo.IntegratedSecurity = false;
//=========================================
// sub report
//=========================================
subreportAdapter.Fill(dsSubreport, "vw_CoMakers");
dtsubreport = dsSubreport.Tables["vw_CoMakers"];
cr.Subreports[0].SetDataSource(dsSubreport.Tables["vw_CoMakers"]);
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
//============================================================
//Generate BIlling and Collection for 6 and 2 mons
//============================================================
SqlCommand cmdGetLoans = new SqlCommand();
cmdGetLoans.Connection = con;
cmdGetLoans.CommandText = "sp_ReturnLoanBalancesREPORT";
cmdGetLoans.CommandType = CommandType.StoredProcedure;
cmdGetLoans.Parameters.AddWithValue("@userid", clsPLBI.userid(txtLoanNo.Text));
SqlDataAdapter adapter = new SqlDataAdapter(cmdGetLoans);
DataSet dsList = new DataSet();
adapter.Fill(dsList);
//Variables
billing6Mons = 0;
billing2Mons = 0;
collection2Mons = 0;
collection6Mons = 0;
//====================================
// FOR 6 MONTHS FIRST
//====================================
for (int x = 0; x < dsList.Tables[0].Rows.Count; x++)
{
semiOrmonth = 0;
fstBckt = 0;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_ReturnListDatesForBillingPLBI";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userid", clsPLBI.userid(txtLoanNo.Text));
cmd.Parameters.AddWithValue("@loan_No", dsList.Tables[0].Rows[x]["Loan_No"].ToString());
cmd.Parameters.AddWithValue("@ReleasedDate", dsList.Tables[0].Rows[x]["ReleaseDate"].ToString());
SqlDataAdapter adapterList = new SqlDataAdapter(cmd);
DataTable dtCnt = new DataTable();
adapterList.Fill(dtCnt);
if (dtCnt.Rows.Count > 0)
{
if (checkIfNonPayroll() == true)
{
//FOR NON PAYROLL COMPUTATION
semiOrmonth = Convert.ToDouble(dsList.Tables[0].Rows[x]["Monthly_Amort"].ToString());
}
else
{
//PAYROLL COMPUTATION
semiOrmonth = Convert.ToDouble(dsList.Tables[0].Rows[x]["Semi_Monthly_Amort"].ToString());
}
//Compute
fstBckt = Convert.ToDouble(dtCnt.Rows.Count) * semiOrmonth;
billing6Mons += fstBckt;
}
}
//====================================
// FOR 2 MONTHS FIRST
//====================================
for (int x = 0; x < dsList.Tables[0].Rows.Count; x++)
{
semiOrmonth = 0;
fstBckt = 0;
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_ReturnListDatesForBillingPLBI2months";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userid", clsPLBI.userid(txtLoanNo.Text));
cmd.Parameters.AddWithValue("@loan_No", dsList.Tables[0].Rows[x]["Loan_No"].ToString());
cmd.Parameters.AddWithValue("@ReleasedDate", dsList.Tables[0].Rows[x]["ReleaseDate"].ToString());
SqlDataAdapter adapterList = new SqlDataAdapter(cmd);
DataTable dtCnt = new DataTable();
adapterList.Fill(dtCnt);
if (dtCnt.Rows.Count > 0)
{
if (checkIfNonPayroll() == true)
{
//FOR NON PAYROLL COMPUTATION
semiOrmonth = Convert.ToDouble(dsList.Tables[0].Rows[x]["Monthly_Amort"].ToString());
}
else
{
//PAYROLL COMPUTATION
semiOrmonth = Convert.ToDouble(dsList.Tables[0].Rows[x]["Semi_Monthly_Amort"].ToString());
}
//Compute
fstBckt = Convert.ToDouble(dtCnt.Rows.Count) * semiOrmonth;
billing2Mons += fstBckt;
}
}
//====================================
// FOR 6 MONTHS FIRST COLELCTION
//====================================
for (int x = 0; x < dsList.Tables[0].Rows.Count; x++)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_ReturnListDatesForCollectionPLBI6months";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userid", clsPLBI.userid(txtLoanNo.Text));
cmd.Parameters.AddWithValue("@loan_No", dsList.Tables[0].Rows[x]["Loan_No"].ToString());
cmd.Parameters.AddWithValue("@ReleasedDate", dsList.Tables[0].Rows[x]["ReleaseDate"].ToString());
cmd.Parameters.AddWithValue("@account_Dr", dsList.Tables[0].Rows[x]["CurrentDr"].ToString());
cmd.Parameters.AddWithValue("@pastDueCr", dsList.Tables[0].Rows[x]["PastDueDr"].ToString());
SqlDataAdapter adapterList = new SqlDataAdapter(cmd);
DataTable dtCnt = new DataTable();
adapterList.Fill(dtCnt);
collection6Mons += Convert.ToDouble(dtCnt.Rows[0].ItemArray[0].ToString());
}
//====================================
// FOR 2 MONTHS FIRST COLELCTION
//====================================
for (int x = 0; x < dsList.Tables[0].Rows.Count; x++)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_ReturnListDatesForCollectionPLBI2months";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@userid", clsPLBI.userid(txtLoanNo.Text));
cmd.Parameters.AddWithValue("@loan_No", dsList.Tables[0].Rows[x]["Loan_No"].ToString());
cmd.Parameters.AddWithValue("@ReleasedDate", dsList.Tables[0].Rows[x]["ReleaseDate"].ToString());
cmd.Parameters.AddWithValue("@account_Dr", dsList.Tables[0].Rows[x]["CurrentDr"].ToString());
cmd.Parameters.AddWithValue("@pastDueCr", dsList.Tables[0].Rows[x]["PastDueDr"].ToString());
SqlDataAdapter adapterList = new SqlDataAdapter(cmd);
DataTable dtCnt = new DataTable();
adapterList.Fill(dtCnt);
collection2Mons += Convert.ToDouble(dtCnt.Rows[0].ItemArray[0].ToString());
}
//====================================================
// END GETTING COLLECTION AND BILLING
//====================================================
//PARAMETERS
cr.SetParameterValue("employeeID", clsPLBI.empid(txtLoanNo.Text));
cr.SetParameterValue("name", clsPLBI.namewithcompany(txtLoanNo.Text));
cr.SetParameterValue("loanNoType", clsPLBI.loanNoType(txtLoanNo.Text));
cr.SetParameterValue("membershipDate", clsPLBI.memDate(txtLoanNo.Text));
cr.SetParameterValue("pmsDate", clsPLBI.pmsDate(txtLoanNo.Text));
cr.SetParameterValue("sc", clsPLBI.shareCapital(txtLoanNo.Text));
cr.SetParameterValue("sd", clsPLBI.savings(txtLoanNo.Text));
cr.SetParameterValue("sc_perday", clsPLBI.scPerDay(txtLoanNo.Text));
cr.SetParameterValue("sd_perday", clsPLBI.SavingsPerday(txtLoanNo.Text));
cr.SetParameterValue("BANK", clsPLBI.Bank(txtLoanNo.Text));
cr.SetParameterValue("bank_accnt", clsPLBI.Atm(txtLoanNo.Text));
cr.SetParameterValue("BillingFor6Mons", Convert.ToDecimal(Convert.ToString(decimal.Round(Convert.ToDecimal(billing6Mons), 2))).ToString("#,0.00"));
cr.SetParameterValue("BillingFor2Mons", Convert.ToDecimal(Convert.ToString(decimal.Round(Convert.ToDecimal(billing2Mons), 2))).ToString("#,0.00"));
cr.SetParameterValue("CollectionFor6Mons", Convert.ToDecimal(Convert.ToString(decimal.Round(Convert.ToDecimal(collection6Mons), 2))).ToString("#,0.00"));
cr.SetParameterValue("collectionlast2", Convert.ToDecimal(Convert.ToString(decimal.Round(Convert.ToDecimal(collection2Mons), 2))).ToString("#,0.00"));
//SETTING THE RATE AND COLLECTION PERCENTAGE
collectionPercent = 0;
if (collection6Mons == 0 && billing6Mons == 0)
{
collection6Mons = 1;
billing6Mons = 1;
}
collectionPercent = collection6Mons / billing6Mons;
collectionPercent = collectionPercent * 100;
if (Convert.ToDecimal(Convert.ToString(decimal.Round(Convert.ToDecimal(collectionPercent), 2))) > 90)
{
cr.SetParameterValue("rate", "A");
cr.SetParameterValue("collection%", Convert.ToDecimal(Convert.ToString(decimal.Round(Convert.ToDecimal(collectionPercent), 2))));
}
else
{
cr.SetParameterValue("rate", "B");
cr.SetParameterValue("collection%", Convert.ToDecimal(Convert.ToString(decimal.Round(Convert.ToDecimal(collectionPercent), 2))));
}
cr.SetParameterValue("printedBy", Classes.clsUser.Username.ToString());
cr.SetParameterValue("sc_date", "10/15/2017");
cr.SetParameterValue("sd_date", "10/15/2017");
cr.SetParameterValue("@userid", clsPLBI.userid(txtLoanNo.Text));
cr.SetParameterValue("dateHired", clsPLBI.dateHired(txtLoanNo.Text));
cr.SetParameterValue("Salary", clsPLBI.salary(txtLoanNo.Text));
cr.SetParameterValue("yearsInService", clsPLBI.noOfyearsService(txtLoanNo.Text));
crystalReportViewer1.ReportSource = cr;
}
}
protected override void ExportReportUsingCrystal(string reportPath, ExportFormatType reportType)
{
string absolutePathFilename1 = string.Empty;
//string absolutePathFilename2 = string.Empty;
//string absolutePathFilename3 = string.Empty;
//string absolutePathFilename4 = string.Empty;
//string absolutePathFilename5 = string.Empty;
absolutePathFilename1 = reportPath;
//absolutePathFilename1 = System.IO.Path.GetTempFileName();
//absolutePathFilename2 = System.IO.Path.GetTempFileName();
//absolutePathFilename3 = System.IO.Path.GetTempFileName();
//absolutePathFilename4 = System.IO.Path.GetTempFileName();
//absolutePathFilename5 = System.IO.Path.GetTempFileName();
Page1 = new LessonLearned();
//Page2 = new OutstandingLCAnalysis2();
//Page3 = new SyndicatedCreditFacilitiesStatus3();
//Page4 = new DemandCreditFacilitiesStatus4();
//Page5 = new SignoffPage5();
DiskFileDestinationOptions destinationOptions = new DiskFileDestinationOptions();
CrystalDecisions.Shared.TableLogOnInfo
myLogin = new CrystalDecisions.Shared.TableLogOnInfo();
myLogin.ConnectionInfo.UserID = ConfigurationManager.AppSettings["CrystalUser"];
myLogin.ConnectionInfo.Password = ConfigurationManager.AppSettings["CrystalPassword"];
myLogin.ConnectionInfo.DatabaseName = "";
myLogin.ConnectionInfo.ServerName = ConfigurationManager.AppSettings["CrystalDB"];
for (int i = 0; i < Page1.Database.Tables.Count; i++)
{
Page1.Database.Tables[i].ApplyLogOnInfo(myLogin);
}
SetReportParameters();
Page1.ExportOptions.ExportFormatType = reportType;
Page1.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
try
{
destinationOptions.DiskFileName = absolutePathFilename1;
Page1.ExportOptions.DestinationOptions = destinationOptions;
Page1.Export();
}
catch (Exception ex)
{
throw new ApplicationException("An unexpected error occurred trying to export the report: " + ex.ToString());
}
finally
{
//if (System.IO.File.Exists(absolutePathFilename1))
// System.IO.File.Delete(absolutePathFilename1);
}
//rpp CrystalReportDocument.SetDataSource(ReportData);
//if (CrystalReportDocument.Subreports.Count > 0)
//{
// PopulateSubreportData(CrystalReportDocument);
//}
//Set the datasource for the report
//CrystalReportDocument.ExportOptions.DestinationOptions = destinationOptions;
//CrystalReportDocument.ExportOptions.ExportFormatType = reportType;
//CrystalReportDocument.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
//Assign the export options so we can export to pdf file
//destinationOptions.DiskFileName = reportPath;
//Export the report
//try
//{
// //CrystalReportDocument.SetDatabaseLogon
// //CrystalReportDocument.ExportToStream(CrystalReportDocument.ExportOptions.ExportFormatType);
// CrystalReportDocument.Export();
//}
//catch (Exception ex)
//{
// throw new ApplicationException("An unexpected error occurred trying to export the report: " + ex.ToString());
//}
}
public void loadBPIReport()
{
//=====Move to tempBPI
movetoTempBPI();
CrystalDecisions.Shared.TableLogOnInfo li;
//Get BPI Bank Information
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
adapter = new SqlDataAdapter("SELECT * FROM Bank WHERE Bank_Code ='BPI'", con);
DataTable dt = new DataTable();
adapter.Fill(dt);
//==========================================================================
// Ceiling
//==========================================================================
SqlDataAdapter adapterCeiling = new SqlDataAdapter("select min(Amount) from tempBPI", con);
DataTable dtCeling = new DataTable();
adapterCeiling.Fill(dtCeling);
//==========================================================================
// Get the total sum of accnt no
//==========================================================================
SqlDataAdapter adapterAccntNo = new SqlDataAdapter("SELECT sum(CONVERT(BIGINT,accntNo)) from TempBPI ", con);
DataTable dtAccnt = new DataTable();
adapterAccntNo.Fill(dtAccnt);
//==========================================================================
// Get the total sum of amount
//==========================================================================
SqlDataAdapter adpAmount = new SqlDataAdapter("SELECT sum(amount) from TempBPI ", con);
DataTable dtAmount = new DataTable();
adpAmount.Fill(dtAmount);
string contactPerson = dt.Rows[0].ItemArray[7].ToString();
string bnkName = dt.Rows[0].ItemArray[1].ToString();
string branchName = dt.Rows[0].ItemArray[2].ToString();
ReportsForms.rptBPIListing cr = new ReportsForms.rptBPIListing();
ReportsForms.rptBPI rpt = new ReportsForms.rptBPI();
li = new TableLogOnInfo();
li.ConnectionInfo.IntegratedSecurity = false;
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
cr.SetParameterValue("maincontactperson", contactPerson);
cr.SetParameterValue("mainbankName", bnkName);
cr.SetParameterValue("mainbranch", branchName);
//==============param for listing
cr.SetParameterValue("paramCompanyCode", txtCompanyCOde.Text);
cr.SetParameterValue("paramBatch", txtTrans.Text);
cr.SetParameterValue("paramAccntNo", txtAccountNo.Text);
cr.SetParameterValue("paramCeiling", Convert.ToDecimal(dtCeling.Rows[0].ItemArray[0].ToString()).ToString("#,0.00"));
cr.SetParameterValue("paramTotal", Convert.ToDecimal(dtAmount.Rows[0].ItemArray[0].ToString()).ToString("#,0.00"));
cr.SetParameterValue("paramAccntSum", Convert.ToInt64(dtAccnt.Rows[0].ItemArray[0].ToString()));
try
{
string num = txtDepositAmount.Text;
string word;
if (txtDepositAmount.Text == "")
{
txtDepositAmount.Text = "";
}
else
{
number = decimal.Parse(num.ToString());
if (number.ToString() == "0")
{
MessageBox.Show("The number in currency fomat is \nZero Only");
}
else
{
word = Classes.clsSavingsDataEntry.ConvertToWords(number.ToString());
}
}
Console.ReadKey();
}
catch (System.Exception ex)
{
}
string Msg = Classes.clsSavingsDataEntry.ConvertToWords(number.ToString()) + " (P " + txtDepositAmount.Text + ")";
cr.SetParameterValue("mainmsg", Msg);
cr.SetParameterValue("mainaccntNumber", txtAccountNo.Text);
cr.SetParameterValue("mainpurpose", "loans/savings/refund");
string dref = DateTime.Now.ToString("yyyy-MM-dd");
cr.SetParameterValue("mainrefno", "Reference No: BPI" + dref.Replace("-", "") + txtTrans.Text);
//Signature
cr.SetParameterValue("mainsig1Name", sig1name.Text);
cr.SetParameterValue("mainsig1pos", sig1pos.Text);
cr.SetParameterValue("mainsig2name", sig2name.Text);
cr.SetParameterValue("mainsig2pos", sig2pos.Text);
cr.SetParameterValue("mainsig3name", sig3name.Text);
cr.SetParameterValue("mainsig3pos", sig3pos.Text);
rpt.crystalReportViewer1.ReportSource = cr;
rpt.ShowDialog();
}
}
public void loadBDOReport()
{
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
CrystalDecisions.Shared.TableLogOnInfo li;
//===============================================
// GETTING BANK INFO
//===============================================
adapter = new SqlDataAdapter("SELECT * FROM Bank WHERE Bank_Code ='BDO'", con);
DataTable dt = new DataTable();
adapter.Fill(dt);
//===============================================
// STRING QUERY
//===============================================
int icount = 0;
purpose = "";
foreach (ListViewItem lItem in listView1.Items)
{
if (lItem.Checked == true)
{
icount = icount + 1;
}
}
for (int i = 0; i < listView1.Items.Count; i++)
{
if (listView1.Items[i].Checked == true)
{
purpose += "'" + getBetween(listView1.Items[i].Text, "-") + "'";
if (i != icount - 1)
{
purpose += " , ";
}
}
}
string str = "select distinct account_No,sum(Amount) as Amount,Name FROM ATM where Bank_Code='" + cmbBank.Text + "' and Deposited is null and purpose in (" + purpose + ") GROUP BY Account_No,Name Order by Name ASC";
SqlDataAdapter adapter1 = new SqlDataAdapter(str, con);
DataTable dt1 = new DataTable();
DataSet ds = new DataSet();
string contactPerson = dt.Rows[0].ItemArray[7].ToString();
string bnkName = dt.Rows[0].ItemArray[1].ToString();
string branchName = dt.Rows[0].ItemArray[2].ToString();
ReportsForms.rptBDOListing cr = new ReportsForms.rptBDOListing();
ReportsForms.rptBDO rpt = new ReportsForms.rptBDO();
li = new TableLogOnInfo();
li.ConnectionInfo.IntegratedSecurity = false;
adapter1.Fill(ds, "ATM");
dt = ds.Tables["ATM"];
cr.SetDataSource(ds.Tables["ATM"]);
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
cr.SetParameterValue("maincontactperson", contactPerson);
cr.SetParameterValue("mainbankName", bnkName);
cr.SetParameterValue("mainbranch", branchName);
try
{
string num = txtDepositAmount.Text;
string word;
if (txtDepositAmount.Text == "")
{
txtDepositAmount.Text = "";
}
else
{
number = decimal.Parse(num.ToString());
if (number.ToString() == "0")
{
MessageBox.Show("The number in currency fomat is \nZero Only");
}
else
{
word = Classes.clsSavingsDataEntry.ConvertToWords(number.ToString());
}
}
Console.ReadKey();
}
catch (System.Exception ex)
{
}
string Msg = Classes.clsSavingsDataEntry.ConvertToWords(number.ToString()) + " (P " + txtDepositAmount.Text + ")";
cr.SetParameterValue("mainmsg", Msg);
cr.SetParameterValue("mainaccntNumber", txtAccountNo.Text);
cr.SetParameterValue("mainpurpose", "loans/savings/refund");
string dref = DateTime.Now.ToString("yyyy-MM-dd");
cr.SetParameterValue("mainrefno", "Reference No: BDO" + dref.Replace("-", "") + txtTrans.Text);
//Signature
cr.SetParameterValue("mainsig1Name", sig1name.Text);
cr.SetParameterValue("mainsig1pos", sig1pos.Text);
cr.SetParameterValue("mainsig2name", sig2name.Text);
cr.SetParameterValue("mainsig2pos", sig2pos.Text);
cr.SetParameterValue("mainsig3name", sig3name.Text);
cr.SetParameterValue("mainsig3pos", sig3pos.Text);
rpt.crystalReportViewer1.ReportSource = cr;
rpt.ShowDialog();
}
}
public ActionResult PrintPO(string id)
{
try
{
string[] parameters = id.Split('|');
string oConnStr = ConfigurationManager.ConnectionStrings["MHConnStr"].ToString();
string rutaRpt = "";
byte[] response = null;
string ImgPath = "";
switch (parameters[1])
{
case "Pes":
ImgPath = ConfigurationManager.AppSettings["ProductImgPath"].ToString();
rutaRpt = Server.MapPath(ConfigurationManager.AppSettings["ProductRptNameES"].ToString());
break;
case "Pen":
ImgPath = ConfigurationManager.AppSettings["ProductImgPath"].ToString();
rutaRpt = Server.MapPath(ConfigurationManager.AppSettings["ProductRptNameEN"].ToString());
break;
case "Mes":
ImgPath = ConfigurationManager.AppSettings["MaterialImgPath"].ToString();
rutaRpt = Server.MapPath(ConfigurationManager.AppSettings["MaterialRptNameES"].ToString());
break;
case "Men":
ImgPath = ConfigurationManager.AppSettings["MaterialImgPath"].ToString();
rutaRpt = Server.MapPath(ConfigurationManager.AppSettings["MaterialRptNameEN"].ToString());
break;
default:
break;
}
//if (parameters[1] == "P")
//{
// ImgPath = ConfigurationManager.AppSettings["ProductImgPath"].ToString();
// rutaRpt = Server.MapPath(ConfigurationManager.AppSettings["ProductRptName"].ToString());
//}
//else
//{
// ImgPath = ConfigurationManager.AppSettings["MaterialImgPath"].ToString();
// rutaRpt = Server.MapPath(ConfigurationManager.AppSettings["MaterialRptName"].ToString());
//}
ReportDocument rpt = new ReportDocument();
SqlConnectionStringBuilder oConnBuilder = new SqlConnectionStringBuilder(oConnStr);
rpt.Load(rutaRpt);
ParameterDiscreteValue pedidoDiscreteValue = new ParameterDiscreteValue();
pedidoDiscreteValue.Value = parameters[0];
rpt.SetParameterValue("pedido", pedidoDiscreteValue);
ParameterDiscreteValue rutaImgDiscreteValue = new ParameterDiscreteValue();
rutaImgDiscreteValue.Value = ImgPath;
rpt.SetParameterValue("rutaImg", rutaImgDiscreteValue);
CrystalDecisions.Shared.ConnectionInfo connectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
connectionInfo.DatabaseName = oConnBuilder.InitialCatalog;
connectionInfo.UserID = oConnBuilder.UserID;
connectionInfo.Password = oConnBuilder.Password;
connectionInfo.ServerName = oConnBuilder.DataSource;
Tables tables = rpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)
{
CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
table.ApplyLogOnInfo(tableLogonInfo);
}
for (int i = 0; i < rpt.DataSourceConnections.Count; i++)
{
rpt.DataSourceConnections[i].SetConnection(oConnBuilder.DataSource, oConnBuilder.InitialCatalog, oConnBuilder.UserID, oConnBuilder.Password);
}
rpt.SetDatabaseLogon(oConnBuilder.UserID, oConnBuilder.Password, oConnBuilder.DataSource, oConnBuilder.InitialCatalog);
using (Stream strMemory = rpt.ExportToStream(ExportFormatType.PortableDocFormat))
{
response = new byte[strMemory.Length];
strMemory.Read(response, 0, (int)strMemory.Length);
}
return(new FileContentResult(response, "application/pdf"));
}
catch (Exception ex)
{
string error = ex.Message + " :::---::: " + ex.StackTrace;
System.Text.ASCIIEncoding codificador = new System.Text.ASCIIEncoding();
byte[] response = codificador.GetBytes(error);
return(new FileContentResult(response, "text/plain"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("th-TH");
//lblError.Text = string.Empty;
if (!IsPostBack)
{
getQueryString();
printData();
crConnectionInfo.DatabaseName = strDbname;
crConnectionInfo.ServerName = strServername;
crConnectionInfo.UserID = strDbuser;
crConnectionInfo.Password = strDbpassword;
crTables = oRpt.Database.Tables;
//apply logon info
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in oRpt.Database.Tables)
{
crTableLogOnInfo = crTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
crTable.ApplyLogOnInfo(crTableLogOnInfo);
}
//apply logon info for sub report
foreach (Section crSection in oRpt.ReportDefinition.Sections)
{
foreach (ReportObject crReportObject in crSection.ReportObjects)
{
if (crReportObject.Kind == ReportObjectKind.SubreportObject)
{
SubreportObject crSubReportObj = (SubreportObject)(crReportObject);
foreach (CrystalDecisions.CrystalReports.Engine.Table oTable in crSubReportObj.OpenSubreport(crSubReportObj.SubreportName).Database.Tables)
{
crTableLogOnInfo = oTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
oTable.ApplyLogOnInfo(crTableLogOnInfo);
}
}
}
}
string strReportDirectoryTempPhysicalPath = Server.MapPath(this.ReportDirectoryTemp);
Helper.DeleteUnusedFile(strReportDirectoryTempPhysicalPath, ReportAliveTime);
string strFilename;
strFilename = "report_" + DateTime.Now.ToString("yyyyMMddHH-mm-ss-fff");
var pathPdf = "~/temp/" + strFilename + ".pdf";
oRpt.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath(pathPdf));
var pathExcel = "~/temp/" + strFilename + ".xls";
oRpt.ExportToDisk(ExportFormatType.ExcelRecord, Server.MapPath(pathExcel));
Session["ExportPdfUrl"] = pathPdf;
Session["ExportExcelUrl"] = pathExcel;
if (Helper.CStr(Session["ExportExcel"]) == "true")
{
Session["ExportExcel"] = null;
//var strMyScript = "window.opener.__doPostBack('ctl00$ASPxRoundPanel1$ASPxRoundPanel2$ContentPlaceHolder1$LinkButton1','');window.close();return false;";
var strMyScript = "window.opener.__doPostBack('ctl00$ASPxRoundPanel1$ASPxRoundPanel2$ContentPlaceHolder1$LinkButton1','');window.close();";
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", strMyScript, true);
}
else
{
Response.Redirect(pathPdf);
}
//Server.Transfer(path);
//lnkPdfFile.NavigateUrl = "~/temp/" + strFilename + ".pdf";
//imgPdf.Src = "~/images/icon_pdf.gif";
//lnkExcelFile.Visible = false;
//CrystalReportViewer1.ReportSource = oRpt;
}
}
public void loadReport()
{
updateTableLess();
CrystalDecisions.Shared.TableLogOnInfo li;
string str = "SELECT * FROM Loan_Amortization WHERE encoded_by = '" + Classes.clsUser.Username.ToString() + "' order by balance desc";
string strSubreport = "SELECT * FROM loan_amort_less WHERE Loan_Type = '" + cmbLoanType.SelectedValue + "' and encoded_by ='" + Classes.clsUser.Username + "'";
//=======================================================
// for sub report
//=======================================================
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
SqlDataAdapter subreportAdapter = new SqlDataAdapter(strSubreport, con);
DataTable dtsubreport = new DataTable();
DataSet dsSubreport = new DataSet();
//=======================================================
// getting the less total
//=======================================================
SqlDataAdapter lessadapter = new SqlDataAdapter("SELECT sum(Amount) FROM loan_amort_less WHERE Loan_Type = '" + cmbLoanType.SelectedValue + "' and encoded_by ='" + Classes.clsUser.Username + "'", con);
DataTable dtLess = new DataTable();
lessadapter.Fill(dtLess);
less = 0;
if (dtLess.Rows[0].ItemArray[0].ToString() != DBNull.Value.ToString())
{
less = Convert.ToDouble(dtLess.Rows[0].ItemArray[0].ToString());
}
SqlDataAdapter adapter1 = new SqlDataAdapter(str, con);
DataTable dt1 = new DataTable();
DataSet ds = new DataSet();
LoanReports.loanAmortization cr = new LoanReports.loanAmortization();
li = new TableLogOnInfo();
li.ConnectionInfo.IntegratedSecurity = false;
//=========================================
// sub report
//=========================================
subreportAdapter.Fill(ds, "loan_amort_less");
dtsubreport = dsSubreport.Tables["loan_amort_less"];
cr.Subreports[0].SetDataSource(ds.Tables["loan_amort_less"]);
adapter1.Fill(ds, "Loan_Amortization");
dt = ds.Tables["Loan_Amortization"];
cr.SetDataSource(ds.Tables["Loan_Amortization"]);
//cr.SetDatabaseLogon("sa", "SYSADMIN", "192.168.255.176", "PECCI-NEW");
cr.SetDatabaseLogon(global.username, global.pass, global.datasource, global.initialCatalog);
//Signature
cr.SetParameterValue("LoanAmount", txtLoanAmount.Text);
cr.SetParameterValue("AnnualInterest", interestRate.Text);
cr.SetParameterValue("TermInMons", txtTerminMos.Text);
cr.SetParameterValue("MonthlyPayment", txtMonthlyPayment.Text);
cr.SetParameterValue("NoOfPayments", txtTerminMos.Text);
cr.SetParameterValue("TotalPayments", txtTotalPayment.Text);
cr.SetParameterValue("TotalInterest", txtInterest.Text);
//If Loan PLAR is RENEW then change the service fee amount
if (plarRenew == true)
{
lessTotal = Convert.ToDouble(txtLoanAmount.Text) - plarExistingBalance;
lessTotal = lessTotal * Convert.ToDouble(clsParameter.serviceFee());
//testing for plarbalance
MessageBox.Show(plarExistingBalance.ToString("#,0.00"));
}
else
{
//For LOANS NOT REQUIRED SERVICE FEE
SqlDataAdapter adapterNoFee = new SqlDataAdapter("SELECT VAL FROM Parameter WHERE val = '" + cmbLoanType.SelectedValue.ToString() + "' and Description = 'No Service Fee'", con);
DataTable dtNoFee = new DataTable();
adapterNoFee.Fill(dtNoFee);
if (dtNoFee.Rows.Count > 0)
{
lessTotal = Convert.ToDouble(txtLoanAmount.Text) * 0.00;
}
else
{
lessTotal = Convert.ToDouble(txtLoanAmount.Text) * Convert.ToDouble(clsParameter.serviceFee());
}
}
netAmount = Convert.ToDouble(txtLoanAmount.Text) - lessTotal;
netAmount = netAmount - less; //Less all the loans and other deductions
cr.SetParameterValue("LessServiceFee", Convert.ToString(Convert.ToDecimal(lessTotal).ToString("#,0.00")));
cr.SetParameterValue("TotalNet", Convert.ToString(Convert.ToDecimal(netAmount).ToString("#,0.00")));
crystalReportViewer1.ReportSource = cr;
}
}
private void AllPrint_Load(object sender, EventArgs e)
{
if (selkar == "Report_Groupby_List")
{
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
paramField1.Name = "@noe";
paramDiscreteValue1.Value = sarbarg;
paramField1.CurrentValues.Add(paramDiscreteValue1);
paramFields.Add(paramField1);
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_Groupby_List1.Database.Tables.Count - 1; intCounter++)
{
report_Groupby_List1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
report_Groupby_List1.RecordSelectionFormula = recore_sel;
crystalReportViewer1.ReportSource = report_Groupby_List1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
if (selkar == "Report_Fish_2_Hoghogh")
{
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
paramField1.Name = "@hogog";
paramField1.ReportName = "Amin_mazaya";
paramDiscreteValue1.Value = "م%";
paramField1.CurrentValues.Add(paramDiscreteValue1);
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue2 = new ParameterDiscreteValue();
paramField2.Name = "@hogog";
paramField2.ReportName = "Amin_Kosorat";
paramDiscreteValue2.Value = "%ات";
paramField2.CurrentValues.Add(paramDiscreteValue2);
paramFields.Add(paramField2);
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue3 = new ParameterDiscreteValue();
paramField3.Name = "@noe";
paramDiscreteValue3.Value = sarbarg;
paramField3.CurrentValues.Add(paramDiscreteValue3);
paramFields.Add(paramField3);
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_Fish_2_Hoghogh1.Database.Tables.Count - 1; intCounter++)
{
report_Fish_2_Hoghogh1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
report_Fish_2_Hoghogh1.RecordSelectionFormula = recore_sel;
crystalReportViewer1.ReportSource = report_Fish_2_Hoghogh1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
if (selkar == "Report_Garardad")
{
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField1 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
paramField1.Name = "@hogog";
paramField1.ReportName = "Amin_mazaya";
paramDiscreteValue1.Value = "%";
paramField1.CurrentValues.Add(paramDiscreteValue1);
paramFields.Add(paramField1);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue2 = new ParameterDiscreteValue();
paramField2.Name = "@type1";
paramField2.ReportName = "Amin_mazaya";
paramDiscreteValue2.Value = "2";
paramField2.CurrentValues.Add(paramDiscreteValue2);
paramFields.Add(paramField2);
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_Garardad1.Database.Tables.Count - 1; intCounter++)
{
report_Garardad1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
report_Garardad1.RecordSelectionFormula = recore_sel;
crystalReportViewer1.ReportSource = report_Garardad1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
if (selkar == "Report_Groupby_Moon")
{
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue3 = new ParameterDiscreteValue();
paramField3.Name = "@noe";
paramDiscreteValue3.Value = sarbarg;
paramField3.CurrentValues.Add(paramDiscreteValue3);
paramFields.Add(paramField3);
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_Groupby_Moon1.Database.Tables.Count - 1; intCounter++)
{
report_Groupby_Moon1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
report_Groupby_Moon1.RecordSelectionFormula = recore_sel;
crystalReportViewer1.ReportSource = report_Groupby_Moon1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
if (selkar == "Report_Karkard")
{
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue3 = new ParameterDiscreteValue();
paramField3.Name = "@noe";
paramDiscreteValue3.Value = sarbarg;
paramField3.CurrentValues.Add(paramDiscreteValue3);
paramFields.Add(paramField3);
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_Karkard1.Database.Tables.Count - 1; intCounter++)
{
report_Karkard1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
report_Karkard1.RecordSelectionFormula = recore_sel;
crystalReportViewer1.ReportSource = report_Karkard1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
if (selkar == "Report_Groupby_Moon_Chart")
{
ParameterFields paramFields = new ParameterFields();
paramFields.Clear();
ParameterField paramField3 = new ParameterField();
ParameterDiscreteValue paramDiscreteValue3 = new ParameterDiscreteValue();
paramField3.Name = "@noe";
paramDiscreteValue3.Value = sarbarg;
paramField3.CurrentValues.Add(paramDiscreteValue3);
paramFields.Add(paramField3);
CrystalDecisions.Shared.TableLogOnInfo ConInfo = new CrystalDecisions.Shared.TableLogOnInfo();
ConInfo.ConnectionInfo.UserID = DB_Base.Constr3;
ConInfo.ConnectionInfo.Password = DB_Base.Constr4;
ConInfo.ConnectionInfo.ServerName = DB_Base.Constr0;
ConInfo.ConnectionInfo.DatabaseName = DB_Base.Constr1;
for (int intCounter = 0; intCounter <= report_Groupby_Moon_Chart1.Database.Tables.Count - 1; intCounter++)
{
report_Groupby_Moon_Chart1.Database.Tables[intCounter].ApplyLogOnInfo(ConInfo);
}
report_Groupby_Moon_Chart1.RecordSelectionFormula = recore_sel;
crystalReportViewer1.ReportSource = report_Groupby_Moon_Chart1;
crystalReportViewer1.ParameterFieldInfo = paramFields;
}
}
