private void AllReport_Load(object sender, EventArgs e)
{
CrystalReport2 objRpt = new CrystalReport2();
string appPath = Path.GetDirectoryName(Application.ExecutablePath);
String ConnStr = @"Data Source=" + appPath + @"\dbcar.s3db ;Version=3;";
System.Data.SQLite.SQLiteConnection myConnection = new System.Data.SQLite.SQLiteConnection(ConnStr);
String Query1 = "SELECT * FROM Donaciones";
System.Data.SQLite.SQLiteDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter(Query1, ConnStr);
DataSet Ds = new DataSet();
// here my_dt is the name of the DataTable which we
// created in the designer view.
adapter.Fill(Ds, "my_dt");
// Setting data source of our report object
objRpt.SetDataSource(Ds);
// Binding the crystalReportViewer with our report object.
this.crystalReportViewer1.ReportSource = objRpt;
objRpt.Refresh();
}
private void button2_Click(object sender, EventArgs e)
{
var Stomach = new Stomach
{
Name = TName.Text,
Age = TAge.Text,
Gender = CGender.Text,
FileNo = TFileNo.Text,
Date = dateTimePicker1.Value,
Premedication = TPremedication.Text,
Scope = CScope.Text,
ReferredDoctor = TReferredDoctor.Text,
ClinicalData = TClinicalData.Text,
GEJ = TGEJ.Text,
Esophagus = TEsophagus.Text,
StomachDetails = TStomach.Text,
D1 = TD1.Text,
D2 = TD2.Text,
Conclusion = TConclusion.Text,
Assistant = TAssistant.Text,
Endoscopist = TEndoscopist.Text,
};
_context.Stomaches.Add(Stomach);
_context.SaveChanges();
CrystalReport2 cr = new CrystalReport2();
cr.SetParameterValue("@Id", Stomach.Id);
var ForCr = new ReportViewerForm();
ForCr.crystalReportViewer1.ReportSource = cr;
ForCr.crystalReportViewer1.Refresh();
ForCr.Show();
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DataTable t = ds.Tables.Add("DataTable1");
t.Columns.Add("Id");
t.Columns.Add("Name");
DataRow r;
int i = 0;
for (i = 0; i <= 9; i++)
{
r = t.NewRow();
r["Id"] = Convert.ToString(i);
r["Name"] = "Item" + i;
t.Rows.Add(r);
}
CrystalReport2 objRpt = new CrystalReport2();
objRpt.Load();
objRpt.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CrystalDecisions.ReportSource.ICachedReport.CreateReport()
{
CrystalReport2 rpt = new CrystalReport2();
rpt.Site = this.Site;
return(rpt);
}
private void MainForm_Load(object sender, EventArgs e)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationDbContext"].ToString();
string sqlSelect =
"select b.CHeadName BankName,SUM(t.DeepositBalance) as CreditBalance from dbBankinfo b join tblBankTransaction t on b.ID=t.BankId where t.Date BETWEEN '2019-03-07' AND '2019-06-22' group by b.CHeadName;" +
"select b.CHeadName BankName,SUM(t.WithdrawBalance) as DebitBalance from dbBankinfo b join tblBankTransaction t on b.ID=t.BankId where t.Date BETWEEN '2019-03-07' AND '2019-06-22' group by b.CHeadName;" +
"select p.PartyName ClientName,SUM(t.ReciveAmount)as PaidAmount from dbPartyInfo p join tblAccountTransaction t on p.Id=t.CustomerId where t.MakeDate BETWEEN '2019-03-07' AND '2019-06-22'group by p.PartyName;" +
"select p.PartyName ClientName,sum(t.GrandTotal)-SUM(t.ReciveAmount)as ReceivableAmount from dbPartyInfo p join tblAccountTransaction t on p.Id=t.CustomerId where t.MakeDate BETWEEN '2019-03-07' AND '2019-06-22' group by p.PartyName;" +
"select Balance as CashInHand, TotalSale,ClientDebit,BankDebit,ExpenseDebit, Part1 as TotalDebit,BankCredit,ClientCredit,labour as Labour, ExpenseCredit, Part2 as TotalCredit,CashInHand as CurrentCashInHand from tblBalanceSheet where MakeDate='2019-04-01';" +
"select PrevAccReceiv as PreviousAccountReceive, TAR as TodayAccountReceive, CashCollected, Summary TotalAccountReceive from tblBalanceSheet where MakeDate='2019-04-01';";
SqlConnection sqlConnection = new SqlConnection(connectString);
sqlConnection.Open();
SqlDataAdapter da = new SqlDataAdapter(sqlSelect, connectString);
da.SelectCommand.CommandType = CommandType.Text;
DataSet ds = new DataSet();
da.Fill(ds);
sqlConnection.Close();
CrystalReport2 crystalReport = new CrystalReport2();
crystalReport.Database.Tables["BankCredit"].SetDataSource(ds.Tables[0]);
crystalReport.Database.Tables["BankDebit"].SetDataSource(ds.Tables[1]);
crystalReport.Database.Tables["ClientPaidAmount"].SetDataSource(ds.Tables[2]);
crystalReport.Database.Tables["ClientReceivableAmount"].SetDataSource(ds.Tables[3]);
crystalReport.Database.Tables["BalanceSheet"].SetDataSource(ds.Tables[4]);
crystalReport.Database.Tables["Summary"].SetDataSource(ds.Tables[5]);
this.crystalReportViewer1.ReportSource = crystalReport;
this.crystalReportViewer1.RefreshReport();
}
private void Report2WithSqlConn()
{
string quary = "SELECT * FROM [CV] WHERE [CvID] = " + CVForm.CvID;
string connectionString = "Data Source=DESKTOP-N7PU9BJ;Initial Catalog=ProfessionalCV;Integrated Security=True;";
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(quary, con);
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds, "CV");
for (var i = 0; i < ds.Tables["CV"].Rows.Count; i++)
{
if (ds.Tables["CV"].Rows[i]["FilePath"] != null)
{
if (!string.IsNullOrEmpty(ds.Tables["CV"].Rows[i]["FilePath"].ToString()))
{
string strFilePath = Application.StartupPath + ds.Tables["CV"].Rows[i]["FilePath"].ToString();
if (File.Exists(strFilePath))
{
ds.Tables["CV"].Rows[i]["FilePath"] = strFilePath;
}
}
}
}
CrystalReport2 cr2 = new CrystalReport2();
cr2.SetDataSource(ds);
crystalReportViewer1.ReportSource = cr2;
con.Close();
crystalReportViewer1.Refresh();
}
//ReportDocument cryrpt = new ReportDocument();
public cristalreport()
{
InitializeComponent();
CrystalReport2 cryrpt = new CrystalReport2();
//cryrpt.SetDataSource(dst);
crystalReportViewer1.ReportSource = cryrpt;
}
private void Rapor2_Load(object sender, EventArgs e)
{
SqlDataAdapter adtr = new SqlDataAdapter("select * from personel", con);
adtr.Fill(tablo);
CrystalReport2 rapor2 = new CrystalReport2();
rapor2.SetDataSource(tablo);
crystalReportViewer1.ReportSource = rapor2;
}
private void CreateReport(string dt)
{
Data data = new Data();
var result = (from supp in data.Inf_LK
where supp.LK_Time_Add >= dt1.Value && supp.LK_Time_Add <= dt2.Value
select new { supp.LK_Id, supp.LK_Name, supp.LK_Number, supp.LK_Price, supp.LK_Producer, supp.WareHouse_Id });
CrystalReport2 rp = new CrystalReport2();
rp.SetDataSource(result);
crystalReportViewer2.ReportSource = rp;
}
public ReportePlanificacionFuncionario()
{
InitializeComponent();
CrystalReport2 cr = new CrystalReport2();
cr.SetDataSource(Controlador.getControlador().obtenerListaFuncionarios());
cr.SetDatabaseLogon("user", "user");
/// foreach(CrystalDecisions.CrystalReports.Engine.ReportDocument sr in cr.Subreports)
// sr.SetDataSource(
crystalReportViewer1.ReportSource = cr;
crystalReportViewer1.Refresh();
crystalReportViewer1.Show();
}
public ActionResult GenerateReport2()
{
DB50Entities db = new DB50Entities();
var c = db.Report2();
CrystalReport2 r = new CrystalReport2();
r.Load();
Stream s = r.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
return(File(s, "application/pdf"));
}
private void SellReprotUI_Load(object sender, EventArgs e)
{
try
{
CrystalReport2 objRpt = new CrystalReport2();
objRpt.SetDataSource(atempSell);
crystalReportViewer1.ReportSource = objRpt;
crystalReportViewer1.Refresh();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//mycode
private void Report()
{
ParameterField paramField1 = new ParameterField();
//creating an object of ParameterFields class
ParameterFields paramFields1 = new ParameterFields();
//creating an object of ParameterDiscreteValue class
ParameterDiscreteValue paramDiscreteValue1 = new ParameterDiscreteValue();
//set the parameter field name
paramField1.Name = "id";
//set the parameter value
paramDiscreteValue1.Value = quotationId;
//add the parameter value in the ParameterField object
paramField1.CurrentValues.Add(paramDiscreteValue1);
//add the parameter in the ParameterFields object
paramFields1.Add(paramField1);
ReportView f2 = new ReportView();
TableLogOnInfos reportLogonInfos = new TableLogOnInfos();
TableLogOnInfo reportLogonInfo = new TableLogOnInfo();
ConnectionInfo reportConInfo = new ConnectionInfo();
Tables tables = default(Tables);
// Table table = default(Table);
var with1 = reportConInfo;
with1.ServerName = "tcp:KyotoServer,49172";
with1.DatabaseName = "NewProductList";
with1.UserID = "sa";
with1.Password = "******";
CrystalReport2 cr = new CrystalReport2();
tables = cr.Database.Tables;
foreach (Table table in tables)
{
reportLogonInfo = table.LogOnInfo;
reportLogonInfo.ConnectionInfo = reportConInfo;
table.ApplyLogOnInfo(reportLogonInfo);
}
f2.crystalReportViewer1.ParameterFieldInfo = paramFields1;
f2.crystalReportViewer1.ReportSource = cr;
this.Visible = false;
f2.ShowDialog();
this.Visible = true;
}
public void imprimer()
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from conge where N_conge='" + tnconge.Text + "'", con);
DataSet ds = new DataSet();
da.Fill(ds, "conge");
CrystalReport2 m = new CrystalReport2();
m.SetDataSource(ds);
christal_report f = new christal_report(m);
f.Show();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXmlSchema("Sample.xml");
CrystalReport2 cr = new CrystalReport2();
cr.SetDataSource(ds);
cr.SetParameterValue("total", label2.Text);
cr.PrintToPrinter(1, false, 0, 0);
//cr.PrintOptions.PaperSize = PaperSize.PaperA5;
//cr.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait;
ds.Tables.Remove(dt);
}
private void btnstart_Click(object sender, EventArgs e)
{
fromdate = DateTimePicker1.Value.Year + "-" + DateTimePicker1.Value.Month + "-" + DateTimePicker1.Value.Day;
todate = DateTimePicker2.Value.Year + "-" + DateTimePicker2.Value.Month + "-" + DateTimePicker2.Value.Day;
con.Open();
DataTable dt = new DataTable();
cmd = new SqlCommand("select * from stocks where Date between '" + fromdate + "'and'" + todate + "'", con);
dr = new SqlDataAdapter(cmd);
dr.Fill(dt);
CrystalReport2 cr = new CrystalReport2();
cr.Database.Tables["stocks"].SetDataSource(dt);
this.crystalReportViewer1.ReportSource = cr;
con.Close();
}
/// <summary>
/// Download PDF of all loans
/// </summary>
/// <returns></returns>
public ActionResult ExportLoans()
{
List <Loan> allCustomer = new List <Loan>();
allCustomer = db.Loans.ToList();
CrystalReport2 rd = new CrystalReport2();
rd.Load(Path.Combine(Server.MapPath("~/CrystalReports"), "ReportCustomer.rpt"));
rd.SetDataSource(allCustomer);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "Loanlist.pdf"));
}
private void Grid_Loaded(object sender, RoutedEventArgs e)
{
User u = new User();
DataRow dr = u.singleUser(i.Refuser);
DataTable user = new DataTable();
user.Columns.Add("iduser", Type.GetType("System.Int32"));
user.Columns.Add("nombre", Type.GetType("System.String"));
user.Columns.Add("apellidos", Type.GetType("System.String"));
user.Columns.Add("email", Type.GetType("System.String"));
user.Columns.Add("telefono", Type.GetType("System.Int32"));
DataRow drf = user.NewRow();
drf[0] = dr[0];
drf[1] = dr[1];
drf[2] = dr[2];
drf[3] = dr[3];
drf[4] = dr[4];
user.Rows.Add(drf);
dr = i.singleInvoice(i.Idinvoice);
DataTable invo = new DataTable();
invo.Columns.Add("idinvoice", Type.GetType("System.Int32"));
invo.Columns.Add("mes", Type.GetType("System.Int32"));
invo.Columns.Add("año", Type.GetType("System.Int32"));
drf = invo.NewRow();
drf[0] = dr[0];
drf[1] = dr[2];
drf[2] = dr[3];
invo.Rows.Add(drf);
InvoiceItem ii = new InvoiceItem();
DataTable items = ii.mostrarDatos(i.Idinvoice);
items.Columns[0].ColumnName = "idinvoiceitem";
items.Columns[1].ColumnName = "nombre";
items.Columns[2].ColumnName = "precio";
DataTable emp = new DataTable();
emp.Columns.Add("nombre", Type.GetType("System.String"));
emp.Columns.Add("direccion", Type.GetType("System.String"));
emp.Columns.Add("telefono", Type.GetType("System.String"));
emp.Columns.Add("email", Type.GetType("System.String"));
emp.Columns.Add("cif", Type.GetType("System.String"));
drf = emp.NewRow();
drf[0] = Propiedades.getNombreEmpresa();
drf[1] = Propiedades.getDireccion();
drf[2] = Propiedades.getTelefono();
drf[3] = Propiedades.getEmail();
drf[4] = Propiedades.getCif();
emp.Rows.Add(drf);
if (tipo == 0)
{
CrystalReport1 report = new CrystalReport1();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
CReportViewer.ViewerCore.ReportSource = report;
}
else
{
CrystalReport2 report = new CrystalReport2();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
CReportViewer.ViewerCore.ReportSource = report;
}
}
private void enviarPDF(int id, int tipo)
{
i.recoverInvoice(id);
DataRow dr = u.singleUser(i.Refuser);
u.recoverUser(i.Refuser);
DataTable user = new DataTable();
user.Columns.Add("iduser", Type.GetType("System.Int32"));
user.Columns.Add("nombre", Type.GetType("System.String"));
user.Columns.Add("apellidos", Type.GetType("System.String"));
user.Columns.Add("email", Type.GetType("System.String"));
user.Columns.Add("telefono", Type.GetType("System.Int32"));
DataRow drf = user.NewRow();
drf[0] = dr[0];
drf[1] = dr[1];
drf[2] = dr[2];
drf[3] = dr[3];
drf[4] = dr[4];
user.Rows.Add(drf);
dr = i.singleInvoice(i.Idinvoice);
DataTable invo = new DataTable();
invo.Columns.Add("idinvoice", Type.GetType("System.Int32"));
invo.Columns.Add("mes", Type.GetType("System.Int32"));
invo.Columns.Add("año", Type.GetType("System.Int32"));
drf = invo.NewRow();
drf[0] = dr[0];
drf[1] = dr[2];
drf[2] = dr[3];
invo.Rows.Add(drf);
InvoiceItem ii = new InvoiceItem();
DataTable items = ii.mostrarDatos(i.Idinvoice);
items.Columns[0].ColumnName = "idinvoiceitem";
items.Columns[1].ColumnName = "nombre";
items.Columns[2].ColumnName = "precio";
DataTable emp = new DataTable();
emp.Columns.Add("nombre", Type.GetType("System.String"));
emp.Columns.Add("direccion", Type.GetType("System.String"));
emp.Columns.Add("telefono", Type.GetType("System.String"));
emp.Columns.Add("email", Type.GetType("System.String"));
emp.Columns.Add("cif", Type.GetType("System.String"));
drf = emp.NewRow();
drf[0] = Propiedades.getNombreEmpresa();
drf[1] = Propiedades.getDireccion();
drf[2] = Propiedades.getTelefono();
drf[3] = Propiedades.getEmail();
drf[4] = Propiedades.getCif();
emp.Rows.Add(drf);
if (tipo == 0)
{
CrystalReport1 report = new CrystalReport1();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
Stream tmp = report.ExportToStream(ExportFormatType.PortableDocFormat);
enviarMensaje(tmp);
}
else
{
CrystalReport2 report = new CrystalReport2();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
Stream tmp = report.ExportToStream(ExportFormatType.PortableDocFormat);
enviarMensaje(tmp);
}
}
