private void SuitForm_Load(object sender, EventArgs e)
{
try {
ReportViewer _reportViewer1 = new ReportViewer();
_reportViewer1.ProcessingMode = ProcessingMode.Local;
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>8.27in</PageWidth>" +
" <PageHeight>11.69in</PageHeight>" +
" <MarginTop>0in</MarginTop>" +
" <MarginLeft>0in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytesa;
try
{
_reportViewer1.LocalReport.ReportPath = @"C:\Users\admin\Desktop\LevanProjects\CreatePdf\Sarcheli\Sarcheli.rdlc";
// C:\Users\admin\Desktop\LevanProjects\CreatePdf\Sarcheli
_reportViewer1.LocalReport.Refresh();
bytesa = _reportViewer1.LocalReport.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
// using (FileStream fs = new FileStream(@"C:\Users\PAB\Desktop\Levan\sarcheli\PDF\" + Suits[i].ToString() + "_" + DateTime.Now.ToString("dd.MM.yyyy") + ".PDF", FileMode.Create))
//using (FileStream fs = new FileStream(@"C:\Users\admin\Desktop\hotels\" + Suits[i].ToString() + "_" + DateTime.Now.ToString("dd.MM.yyyy") + ".PDF", FileMode.Create))
{
//fs.Write(bytesa, 0, bytesa.Length);
//fs.Close();
//fs.Dispose();
bytesa = null;
_reportViewer1.Refresh();
_reportViewer1.Clear();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public PenjualanForm(ReportViewer report)
{
InitializeComponent();
this.DataContext = new PenjualanViewModel();
reportViewer = report;
report.Clear();
reportViewer.LocalReport.ReportEmbeddedResource = "MainApp.Reports.Layouts.Penjualan.rdlc";
reportViewer.SetDisplayMode(DisplayMode.PrintLayout);
reportViewer.ZoomMode = ZoomMode.PageWidth;
}
private void btnClear_Click(object sender, RoutedEventArgs e)
{
cmbBank.Text = "";
cmbBranch.Text = "";
cmbNubeBranch.Text = "";
dtpDOB.Text = "";
lblState.Visibility = Visibility.Collapsed;
chkMelaka.Visibility = Visibility.Collapsed;
chkNegeriSembilan.Visibility = Visibility.Collapsed;
ReportViewer.Clear();
}
public BorderelCargo(ReportViewer report)
{
InitializeComponent();
vm = new BorderelViewModel();
reportViewer = report;
reportViewer.Clear();
reportViewer.RefreshReport();
this.DataContext = vm;
reportViewer.LocalReport.ReportEmbeddedResource = "MainApp.Reports.Layouts.BorderelCargoLayout.rdlc";
reportViewer.SetDisplayMode(DisplayMode.PrintLayout);
reportViewer.ZoomMode = ZoomMode.PageWidth;
}
private void btnClear_Click(object sender, RoutedEventArgs e)
{
try
{
cmbNubeBranch.Text = "";
cmbBank.Text = "";
cmbBranch.Text = "";
txtMemberNo.Text = "";
ReportViewer.Clear();
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
private void button3_Click(object sender, RoutedEventArgs e)
{
host.Visibility = Visibility.Visible;
ReportViewer.Reset();
Connection con = new Connection();
con.open_connection();
OdbcCommand cmd1 = new OdbcCommand("select user_name,designation,last_login from log_table", con.conn);
OdbcDataAdapter da = new OdbcDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
ReportViewer.Clear();
ReportDataSource ds = new ReportDataSource("DataSet1", dt);
ReportViewer.LocalReport.DataSources.Add(ds);
ReportViewer.LocalReport.ReportEmbeddedResource = "Project_Transport.Report1.rdlc";
ReportViewer.RefreshReport();
}
public static byte[] RenderToPdf(ReportViewerData rd)
{
var rv = new ReportViewer();
foreach (var source in rd.Sources)
{
rv.LocalReport.DataSources.Add(new ReportDataSource(source.Key, source.Value));
}
//reportViewer1.LocalReport.ReportEmbeddedResource = "KlonsF.Reports.Report1.rdlc";
rv.LocalReport.ReportPath = MyData.GetBasePath() + "\\Reports\\" + rd.FileName + ".rdlc";
if (rd.ReportParameters != null)
{
rv.LocalReport.SetParameters(rd.ReportParameters);
}
rv.LocalReport.SubreportProcessing += (sender, e) =>
{
rd.SubreportProcessing(e);
};
var ret = rv.LocalReport.Render(format: "PDF", deviceInfo: "");
rv.Clear();
return(ret);
}
private void Form2_Load(object sender, EventArgs e)
{
try
{
List <int> Suits = new List <int>();
ReportViewer rv1 = new ReportViewer();
LegalCounselTableAdapters.GetSuitInfoTableAdapter GetSuitInfoAll = new LegalCounselTableAdapters.GetSuitInfoTableAdapter();
var SuitIds = GetSuitInfoAll.GetData(null);
foreach (var item in SuitIds)
{
Suits.Add(item.ID);
}
for (int i = 0; i < Suits.Count; i++)
{
ReportDataSource GetSuitInfo1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitInfoTableAdapter GetSuitInfo = new LegalCounselTableAdapters.GetSuitInfoTableAdapter();
GetSuitInfo1.Name = "GetSuitInfo";
GetSuitInfo1.Value = GetSuitInfo.GetData(Suits[i]);
int StageCount = Convert.ToInt32(GetSuitInfo.GetData(Suits[i])[0].StageCount);
ReportDataSource GetSuitAgents1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitAgentsTableAdapter GetSuitAgents = new LegalCounselTableAdapters.GetSuitAgentsTableAdapter();
GetSuitAgents1.Name = "GetSuitAgents";
GetSuitAgents1.Value = GetSuitAgents.GetData(Suits[i]);
List <GetSuitCircumstances> GetSuitCircumstancesList = new List <Sarcheli.GetSuitCircumstances>();
LegalCounselTableAdapters.GetSuitCircumstancesTableAdapter GetSuitCircumstances = new LegalCounselTableAdapters.GetSuitCircumstancesTableAdapter();
ReportDataSource GetSuitCircumstances1 = new ReportDataSource();
GetSuitCircumstances1.Name = "GetSuitCircumstances";
DataTable Data = new DataTable();
Data.Columns.Add("suitid");
Data.Columns.Add("stageid");
Data.Columns.Add("Circumstance");
Data.Columns.Add("activeid");
Data.Columns.Add("priority");
Data.Columns.Add("TextPriority");
for (int j = 1; j <= StageCount; j++)
{
var cumstances = GetSuitCircumstances.GetData(Suits[i], j);
foreach (var item in cumstances)
{
Data.Rows.Add(item.ItemArray);
}
}
GetSuitCircumstances1.Value = Data;
ReportDataSource GetSuitDebtors1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitDebtorsTableAdapter GetSuitDebtors = new LegalCounselTableAdapters.GetSuitDebtorsTableAdapter();
GetSuitDebtors1.Name = "GetSuitDebtors";
GetSuitDebtors1.Value = GetSuitDebtors.GetData(Suits[i]);
ReportDataSource GetSuitOverview1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitOverviewTableAdapter GetSuitOverview = new LegalCounselTableAdapters.GetSuitOverviewTableAdapter();
GetSuitOverview1.Name = "GetSuitOverview";
GetSuitOverview1.Value = GetSuitOverview.GetData(Suits[i]);
ReportDataSource GetSuitRequests1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitRequestsTableAdapter GetSuitRequests = new LegalCounselTableAdapters.GetSuitRequestsTableAdapter();
GetSuitRequests1.Name = "GetSuitRequests";
DataTable Requests = new DataTable();
Requests.Columns.Add("article");
Requests.Columns.Add("activeid");
Requests.Columns.Add("priority");
Requests.Columns.Add("TextPriority");
for (int j = 1; j <= 3; j++)
{
var SuitRequest = GetSuitRequests.GetData(Suits[i], j);
foreach (var item in SuitRequest)
{
Requests.Rows.Add(item.ItemArray);
}
}
GetSuitRequests1.Value = Requests;
int StageCountPetitions = Convert.ToInt32(GetSuitInfo.GetData(Suits[i])[0].StageCountPetitions);
ReportDataSource GetSuitPetitions1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitPetitionsTableAdapter GetSuitPetitions = new LegalCounselTableAdapters.GetSuitPetitionsTableAdapter();
GetSuitPetitions1.Name = "GetSuitPetitions";
DataTable Petitions = new DataTable();
Petitions.Columns.Add("article");
Petitions.Columns.Add("activeid");
Petitions.Columns.Add("priority");
Petitions.Columns.Add("TextPriority");
for (int j = 1; j <= StageCountPetitions; j++)
{
var Petition = GetSuitPetitions.GetData(Suits[i], j);
foreach (var item in Petition)
{
Petitions.Rows.Add(item.ItemArray);
}
}
GetSuitPetitions1.Value = Petitions;
ReportDataSource GetSuitActivesInfo1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitActivesInfoTableAdapter GetSuitActivesInfo = new LegalCounselTableAdapters.GetSuitActivesInfoTableAdapter();
GetSuitActivesInfo1.Name = "GetSuitActivesInfo";
GetSuitActivesInfo1.Value = GetSuitActivesInfo.GetData(Suits[i]);
ReportDataSource GetSuitAttachments1 = new ReportDataSource();
LegalCounselTableAdapters.GetSuitAttachmentsTableAdapter GetSuitAttachments = new LegalCounselTableAdapters.GetSuitAttachmentsTableAdapter();
GetSuitAttachments1.Name = "GetSuitAttachments";
GetSuitAttachments1.Value = GetSuitAttachments.GetData(Suits[i]);
ReportViewer _reportViewer1 = new ReportViewer();
_reportViewer1.ProcessingMode = ProcessingMode.Local;
_reportViewer1.LocalReport.ReportPath = @"C:\Users\PAB\Desktop\Levan\pdfgenerator (2)\pdfgenerator (2)\pdfgenerator\New folder\CreatePdf\Sarcheli\Sarcheli2.rdlc";
// _reportViewer1.LocalReport.ReportPath = @"C:\Users\admin\Desktop\pdfgenerator (2)\pdfgenerator (2)\pdfgenerator\New folder\CreatePdf\Sarcheli\Sarcheli2.rdlc";
_reportViewer1.RefreshReport();
_reportViewer1.Clear();
// var rv1 = new LocalReport();
_reportViewer1.LocalReport.DataSources.Add(GetSuitInfo1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitAgents1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitCircumstances1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitDebtors1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitOverview1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitRequests1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitPetitions1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitActivesInfo1);
_reportViewer1.LocalReport.DataSources.Add(GetSuitAttachments1);
GetSuitInfo1 = null;
GetSuitAgents1 = null;
GetSuitCircumstances1 = null;
GetSuitDebtors1 = null;
GetSuitOverview1 = null;
GetSuitRequests1 = null;
GetSuitPetitions1 = null;
GetSuitActivesInfo1 = null;
GetSuitAttachments1 = null;
// _reportViewer1.LocalReport.ReportPath = string.Format(@"C:\Users\admin\Downloads\pdfgenerator (2)\pdfgenerator\New folder\CreatePdf\Sarcheli\Sarcheli.rdlc");
string deviceInfo =
"<DeviceInfo>" +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>8.27in</PageWidth>" +
" <PageHeight>11.69in</PageHeight>" +
" <MarginTop>0in</MarginTop>" +
" <MarginLeft>0in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytesa;
try
{
_reportViewer1.LocalReport.Refresh();
bytesa = _reportViewer1.LocalReport.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
using (FileStream fs = new FileStream(@"C:\Users\PAB\Desktop\Levan\sarcheli\PDF\" + Suits[i].ToString() + "_" + DateTime.Now.ToString("dd.MM.yyyy") + ".PDF", FileMode.Create))
//using (FileStream fs = new FileStream(@"C:\Users\admin\Desktop\hotels\" + Suits[i].ToString() + "_" + DateTime.Now.ToString("dd.MM.yyyy") + ".PDF", FileMode.Create))
{
fs.Write(bytesa, 0, bytesa.Length);
fs.Close();
fs.Dispose();
bytesa = null;
_reportViewer1.Refresh();
_reportViewer1.Clear();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SuitForm_Load(object sender, EventArgs e)
{
try
{
DataSet1 ds = new DataSet1();
List <int> Suits = new List <int>();
DataSet1TableAdapters.getSimplifiedProccesDataTableAdapter GetSuitInfoAll = new DataSet1TableAdapters.getSimplifiedProccesDataTableAdapter();
var SuitIds = GetSuitInfoAll.GetData(null);
foreach (var item in SuitIds)
{
Suits.Add(item.ID);
}
for (int i = 0; i < Suits.Count; i++)
{
ReportDataSource GetSuitInfo1 = new ReportDataSource();
DataSet1TableAdapters.getSimplifiedProccesDataTableAdapter GetSuitInfo = new DataSet1TableAdapters.getSimplifiedProccesDataTableAdapter();
GetSuitInfo1.Name = "getSimplifiedProccesData";
GetSuitInfo1.Value = GetSuitInfo.GetData(Suits[i]);
ReportViewer _reportViewer1 = new ReportViewer(); //
_reportViewer1.ProcessingMode = ProcessingMode.Local;
// var DesktopPath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
string DesktopPath = @"C:\Users\Administrator\Desktop\CreatePDF\PDF";
string _Path = Directory.GetCurrentDirectory();
// _Path = _Path.Replace(@"bin\Debug", "Suit.rdlc");
//chemi
// _reportViewer1.LocalReport.ReportPath = @"C:\Users\admin\Desktop\LevanProjects\CreatePdf\Suit\Suit.rdlc";
//gio C:\Users\PAB\Desktop\suit
_reportViewer1.LocalReport.ReportPath = @"C:\Users\Administrator\Desktop\CreatePDF\RDLC\Suit.rdlc";
_reportViewer1.RefreshReport();
_reportViewer1.Clear();
_reportViewer1.LocalReport.DataSources.Add(GetSuitInfo1);
GetSuitInfo1 = null;
string deviceInfo =
"<DeviceInfo> " +
" <OutputFormat>EMF</OutputFormat>" +
" <PageWidth>8.27in</PageWidth>" +
" <PageHeight>11.69in</PageHeight>" +
" <MarginTop>0in</MarginTop>" +
" <MarginLeft>0in</MarginLeft>" +
" <MarginRight>0in</MarginRight>" +
" <MarginBottom>0in</MarginBottom>" +
"</DeviceInfo>";
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;
byte[] bytesa;
try
{
// C:\Users\admin\Desktop\LevanProjects\CreatePdf\Sarcheli
_reportViewer1.LocalReport.Refresh();
bytesa = _reportViewer1.LocalReport.Render("PDF", deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
}
catch (Exception ex)
{
throw new Exception(ex.InnerException.ToString());
}
using (FileStream fs = new FileStream(DesktopPath + @"\" + Suits[i] + ".PDF", FileMode.Create))
//using (FileStream fs = new FileStream(@"C:\Users\admin\Desktop\hotels\" + Suits[i].ToString() + "_" + DateTime.Now.ToString("dd.MM.yyyy") + ".PDF", FileMode.Create))
{
fs.Write(bytesa, 0, bytesa.Length);
fs.Close();
fs.Dispose();
bytesa = null;
_reportViewer1.Refresh();
_reportViewer1.Clear();
}
}
DataSet1TableAdapters.getSimplifiedProccesDoucmentationTableAdapter ProccesDocumentation = new DataSet1TableAdapters.getSimplifiedProccesDoucmentationTableAdapter();
ProccesDocumentation.GetData();
ConcatenatePDF();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Load_Tyre_Back_Click(object sender, RoutedEventArgs e)
{
ReportViewer.Clear();
host.Visibility = Visibility.Hidden;
back.Visibility = Visibility.Hidden;
}
void print_data()
{
ReportParameter[] param = new ReportParameter[63];
try
{
List <string> date = new List <string>();
Connection con = new Connection();
con.connection_string();
OdbcCommand cmd1 = new OdbcCommand("select fl_date,fr_date,fbl_date,fbr_date,cl_date,cr_date,bfol_date,bfil_date,bfor_date,bfir_date,bbol_date,bbil_date,bbor_date,bbir_date,add_date from load_tyre where vechile_no='" + tyre_vehicle_number.Text + "'", con.str);
OdbcDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
for (int j = 0; j < 15; j++)
{
date.Add(dr1[j].ToString());
}
}
con.close_string();
con.connection_string();
OdbcCommand cmd = new OdbcCommand("select fl_id,fr_id,fbl_id,fbr_id,cl_id,cr_id,bfol_id,bfil_id,bfir_id,bfor_id,bbol_id,bbil_id,bbir_id,bbor_id,add_id from load_tyre where vechile_no='" + tyre_vehicle_number.Text + "'", con.str);
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
int p = 0, q = 1, r = 2, s = 3;
for (int i = 0; i < 15; i++)
{
int A = p + 1, B = q + 1, C = r + 1, D = s + 1;
string id = dr[i].ToString();
if (!string.IsNullOrWhiteSpace(id))
{
OdbcCommand cmd2 = new OdbcCommand("select no,starting_km,company from load_tyre_details where id=" + id + "", con.str);
OdbcDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
if (!string.IsNullOrWhiteSpace(dr2[0].ToString()))
{
param[p] = new ReportParameter("param" + A + "", dr2[0].ToString());
param[q] = new ReportParameter("param" + B + "", dr2[1].ToString());
param[r] = new ReportParameter("param" + C + "", dr2[2].ToString());
param[s] = new ReportParameter("param" + D + "", Convert.ToDateTime(date[i]).ToString("dd/MM/yyyy"));
}
else
{
param[p] = new ReportParameter("param" + A + "", " ");
param[q] = new ReportParameter("param" + B + "", " ");
param[r] = new ReportParameter("param" + C + "", " ");
param[s] = new ReportParameter("param" + D + "", " ");
}
}
}
else
{
param[p] = new ReportParameter("param" + A + "", " ");
param[q] = new ReportParameter("param" + B + "", " ");
param[r] = new ReportParameter("param" + C + "", " ");
param[s] = new ReportParameter("param" + D + "", " ");
}
p += 4; q += 4; r += 4; s += 4;
}
}
ReportViewer.Clear();
ReportViewer.LocalReport.ReportEmbeddedResource = "Project_Transport.load_tyre.rdlc";
param[60] = new ReportParameter("param61", Properties.Settings.Default.Title.ToString());
param[61] = new ReportParameter("param62", (tyre_vehicle_number.Text).ToString());
param[62] = new ReportParameter("param63", Convert.ToDateTime(DateTime.Now).ToString("dd/MM/yyyy"));
ReportViewer.LocalReport.SetParameters(param);
ReportViewer.RefreshReport();
}
catch (OdbcException ex)
{
MessageBox.Show("Error :" + ex);
}
}
private void button2_Click(object sender, RoutedEventArgs e)
{
host.Visibility = Visibility.Hidden;
ReportViewer.Clear();
}
