My datagrid
Result:
MY part code need to modify:
//Adding Header row
foreach (DataGridViewColumn column in ItemsDataGridView.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText, calibri10bold3));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.VerticalAlignment = Element.ALIGN_CENTER;
cell.BackgroundColor = new iTextSharp.text.BaseColor(243, 70, 5); //255, 165, 61 //243, 70, 5
pdfTable.AddCell(cell);
}
//Adding DataRow
foreach (DataGridViewRow row in ItemsDataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri2));
cell2.HorizontalAlignment = Element.ALIGN_RIGHT;
cell2.VerticalAlignment = Element.ALIGN_MIDDLE;
pdfTable.AddCell(cell2);
}
}
Complete code:
//Creating iTextSharp Table from the DataTable data
//Console.WriteLine(drzaveDataGridView.ColumnCount); test za itext sharp
PdfPTable pdfTable = new PdfPTable(ItemsDataGridView.ColumnCount);
pdfTable.DefaultCell.Padding = 2; //odstojanje od linija unutar tabele
pdfTable.WidthPercentage = 100;
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT; //datagreed tabela
pdfTable.DefaultCell.BorderWidth = 1;
float[] sirina = new float[] { 0f, 20f, 35f, 0f, 0f, 135f, 30f, 40f, 0f, 50f, 42f, 40f, 35f, 40f, 40f, 50f, 50f, 0f, 0f, 0f, 0f, 0f, 0f, 0f, 0f };
pdfTable.SetWidths(sirina);
BaseFont bfCalibri = BaseFont.CreateFont("c:\\windows\\fonts\\calibri.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
iTextSharp.text.Font calibri = new iTextSharp.text.Font(bfCalibri, 9, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibrinormal = new iTextSharp.text.Font(bfCalibri, 9, iTextSharp.text.Font.NORMAL);
iTextSharp.text.Font calibri10bold2 = new iTextSharp.text.Font(bfCalibri, 9, iTextSharp.text.Font.BOLD, iTextSharp.text.BaseColor.BLACK);
iTextSharp.text.Font calibri10bold3 = new iTextSharp.text.Font(bfCalibri, 8, iTextSharp.text.Font.NORMAL, iTextSharp.text.BaseColor.WHITE);
iTextSharp.text.Font calibri2 = new iTextSharp.text.Font(bfCalibri, 7, iTextSharp.text.Font.ITALIC);
//Adding Header row
foreach (DataGridViewColumn column in ItemsDataGridView.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText, calibri10bold3));
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.VerticalAlignment = Element.ALIGN_CENTER;
cell.BackgroundColor = new iTextSharp.text.BaseColor(243, 70, 5); //255, 165, 61 //243, 70, 5
pdfTable.AddCell(cell)
}
//Adding DataRow
foreach (DataGridViewRow row in ItemsDataGridView.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
PdfPCell cell2 = new PdfPCell(new Phrase(cell.Value.ToString(), calibri2));
cell2.HorizontalAlignment = Element.ALIGN_RIGHT;
cell2.VerticalAlignment = Element.ALIGN_MIDDLE;
pdfTable.AddCell(cell2);
}
}
PdfPTable pdfTable2 = new PdfPTable(2);
pdfTable2.SetWidths(new int[] { 1, 2 }); // kolone
pdfTable2.DefaultCell.Padding = 1; //odstojanje od linija unutar tabele
pdfTable2.WidthPercentage = 29.62f;
pdfTable2.HorizontalAlignment = Element.ALIGN_RIGHT;
pdfTable2.DefaultCell.BorderWidth = .5f;
// float[] sirina2 = new float[] { 75.59f, 85f };
float[] sirina2 = new float[] { 80f, 100f };
pdfTable2.SetWidths(sirina2);
// Next we need to add rows and columns to the above table object.This can be added by using the AddCell method of the above table object.
//pdfTable2.AddCell("IZNOS BEZ PDV:");
// pdfTable2.AddCell(iznos_bez_pdvTextBox.Text.ToString() + " KM");
// pdfTable2.AddCell("IZNOS PDV");
//pdfTable2.AddCell(pdvTextBox1.Text.ToString() + " KM");
// pdfTable2.AddCell("UKUPNO");
// pdfTable2.AddCell(iznos_sa_pdvTextBox1.Text.ToString() + " KM");
// PdfPCell cellid = new PdfPCell(new Phrase("ID", calibri));
// pdfTable2.AddCell(cellid);
// cellid.HorizontalAlignment = Element.ALIGN_RIGHT;
// cellid.BackgroundColor = BaseColor.LIGHT_GRAY;
// cellid.BorderWidth = 1;
// cellid.BorderColor = BaseColor.BLUE;
// cellid.Padding = 5;
// pdfTable2.AddCell(cellid);
// PdfPCell pdv_cell_pdf = new PdfPCell(new Phrase("PDV: ", calibri));
// pdfTable2.AddCell(pdv_cell_pdf);
// pdv_cell_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
// pdv_cell_pdf.BackgroundColor = BaseColor.GREEN;
// pdv_cell_pdf.BorderWidth = 0.5f;
// pdv_cell_pdf.BorderColor = BaseColor.BLUE;
// pdv_cell_pdf.Padding = 5;
// pdfTable2.AddCell("Ukupno bez PDV");
PdfPCell ukupno_bez_pdv_cell2_pdf = new PdfPCell(new Phrase("Ukupno bez PDV:", calibri10bold2));
PdfPCell ukupno_bez_pdv_cell_pdf = new PdfPCell(new Phrase(IznosSaRabatomBezPdvTextBox.Text.ToString() + " KM", calibri10bold2));
ukupno_bez_pdv_cell2_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
ukupno_bez_pdv_cell_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
// ukupno_bez_pdv_cell_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_bez_pdv_cell2_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_bez_pdv_cell2_pdf.BorderWidth = 1;
//ukupno_bez_pdv_cell_pdf.BorderColor = BaseColor.BLACK;
//ukupno_bez_pdv_cell2_pdf.Padding = 5;
// pdfTable2.AddCell(ukupno_bez_pdv_cell_pdf);
pdfTable2.AddCell(ukupno_bez_pdv_cell2_pdf);
pdfTable2.AddCell(ukupno_bez_pdv_cell_pdf);
PdfPCell pdv_cell5_pdf = new PdfPCell(new Phrase("PDV: ", calibri10bold2));
PdfPCell pdv_cell6_pdf = new PdfPCell(new Phrase(PdvTextBox.Text.ToString() + " KM", calibri10bold2));
pdv_cell5_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
pdv_cell6_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
// pdv_cell5_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// pdv_cell6_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// pdv_cell6_pdf.BorderWidth = 3;
// pdv_cell6_pdf.BorderColor = BaseColor.BLUE;
// pdv_cell6_pdf.Padding = 5;
// pdfTable2.AddCell(pdv_cell6_pdf);
pdfTable2.AddCell(pdv_cell5_pdf);
pdfTable2.AddCell(pdv_cell6_pdf);
PdfPCell ukupno_sa_pdv_cell3_pdf = new PdfPCell(new Phrase("UKUPNO: ", calibri10bold2));
PdfPCell ukupno_sa_pdv_cell4_pdf = new PdfPCell(new Phrase(IznosSaPdvTextBox.Text.ToString() + " KM", calibri10bold2));
ukupno_sa_pdv_cell3_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
ukupno_sa_pdv_cell3_pdf.VerticalAlignment = Element.ALIGN_MIDDLE;
ukupno_sa_pdv_cell4_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
ukupno_sa_pdv_cell4_pdf.VerticalAlignment = Element.ALIGN_MIDDLE;
// ukupno_sa_pdv_cell3_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_sa_pdv_cell4_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_sa_pdv_cell4_pdf.BorderWidth = 3;
ukupno_sa_pdv_cell4_pdf.BorderColor = BaseColor.BLACK;
ukupno_sa_pdv_cell3_pdf.Padding = 1;
ukupno_sa_pdv_cell4_pdf.Padding = 1;
pdfTable2.AddCell(ukupno_sa_pdv_cell3_pdf);
pdfTable2.AddCell(ukupno_sa_pdv_cell4_pdf);
// tabela za obracun poreza
PdfPTable pdvTable = new PdfPTable(2);
pdvTable.SetWidths(new int[] { 1, 2 }); // kolone
pdvTable.DefaultCell.Padding = 1; //odstojanje od linija unutar tabele
pdvTable.WidthPercentage = 30f;
pdvTable.HorizontalAlignment = Element.ALIGN_LEFT;
pdvTable.DefaultCell.BorderWidth = .5f;
float[] sirinapdv = new float[] { 75.59f, 85f };
pdvTable.SetWidths(sirinapdv);
//header
PdfPCell cellpdv = new PdfPCell(new Phrase("Kalkulacija poreza", calibri10bold3));
cellpdv.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185); //255, 165, 61 //243, 70, 5
cellpdv.Colspan = 2;
cellpdv.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right
cellpdv.VerticalAlignment = 1; //0=Left, 1=Centre, 2=Right
pdvTable.AddCell(cellpdv);
// Next we need to add rows and columns to the above table object.This can be added by using the AddCell method of the above table object.
//pdvTable.AddCell("IZNOS BEZ PDV:");
// pdvTable.AddCell(iznos_bez_pdvTextBox.Text.ToString() + " KM");
// pdvTable.AddCell("IZNOS PDV");
//pdvTable.AddCell(pdvTextBox1.Text.ToString() + " KM");
// pdvTable.AddCell("UKUPNO");
// pdvTable.AddCell(iznos_sa_pdvTextBox1.Text.ToString() + " KM");
// PdfPCell cellid = new PdfPCell(new Phrase("ID", calibri));
// pdvTable.AddCell(cellid);
// cellid.HorizontalAlignment = Element.ALIGN_RIGHT;
// cellid.BackgroundColor = BaseColor.LIGHT_GRAY;
// cellid.BorderWidth = 1;
// cellid.BorderColor = BaseColor.BLUE;
// cellid.Padding = 5;
// pdvTable.AddCell(cellid);
// PdfPCell pdv_cell_pdf = new PdfPCell(new Phrase("PDV: ", calibri));
// pdvTable.AddCell(pdv_cell_pdf);
// pdv_cell_pdf.HorizontalAlignment = Element.ALIGN_RIGHT;
// pdv_cell_pdf.BackgroundColor = BaseColor.GREEN;
// pdv_cell_pdf.BorderWidth = 0.5f;
// pdv_cell_pdf.BorderColor = BaseColor.BLUE;
// pdv_cell_pdf.Padding = 5;
// pdvTable.AddCell("Ukupno bez PDV");
PdfPCell ukupno_bez_pdv_cell_pdf_pdv23 = new PdfPCell(new Phrase("Osnovica PDV:", calibri2));
PdfPCell ukupno_bez_pdv_cell_pdf_pdv24 = new PdfPCell(new Phrase(IznosSaRabatomBezPdvTextBox.Text.ToString() + " KM", calibri2));
ukupno_bez_pdv_cell_pdf_pdv23.HorizontalAlignment = Element.ALIGN_CENTER;
ukupno_bez_pdv_cell_pdf_pdv24.HorizontalAlignment = Element.ALIGN_CENTER;
// ukupno_bez_pdv_cell_pdf_pdv.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_bez_pdv_cell_pdf_pdv2.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_bez_pdv_cell_pdf_pdv.BorderWidth = 1;
//ukupno_bez_pdv_cell_pdf_pdv.BorderColor = BaseColor.BLACK;
//ukupno_bez_pdv_cell_pdf_pdv.Padding = 5;
// pdvTable.AddCell(ukupno_bez_pdv_cell_pdf);
pdvTable.AddCell(ukupno_bez_pdv_cell_pdf_pdv23);
pdvTable.AddCell(ukupno_bez_pdv_cell_pdf_pdv24);
PdfPCell pdv_cell7_pdf = new PdfPCell(new Phrase("Iznos PDV: ", calibri2));
PdfPCell pdv_cell8_pdf = new PdfPCell(new Phrase(PdvTextBox.Text.ToString() + " KM", calibri2));
pdv_cell7_pdf.HorizontalAlignment = Element.ALIGN_CENTER;
pdv_cell8_pdf.HorizontalAlignment = Element.ALIGN_CENTER;
// pdv_cell5_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// pdv_cell6_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// pdv_cell6_pdf.BorderWidth = 3;
// pdv_cell6_pdf.BorderColor = BaseColor.BLUE;
// pdv_cell6_pdf.Padding = 5;
// pdfTable2.AddCell(pdv_cell6_pdf);
pdvTable.AddCell(pdv_cell7_pdf);
pdvTable.AddCell(pdv_cell8_pdf);
PdfPCell ukupno_sa_pdv_cell9_pdf = new PdfPCell(new Phrase("Ukupno sa PDV: ", calibri2));
PdfPCell ukupno_sa_pdv_cell10_pdf = new PdfPCell(new Phrase(IznosSaPdvTextBox.Text.ToString() + " KM", calibri2));
ukupno_sa_pdv_cell9_pdf.HorizontalAlignment = Element.ALIGN_CENTER;
ukupno_sa_pdv_cell10_pdf.VerticalAlignment = Element.ALIGN_CENTER;
ukupno_sa_pdv_cell10_pdf.HorizontalAlignment = Element.ALIGN_CENTER;
ukupno_sa_pdv_cell9_pdf.VerticalAlignment = Element.ALIGN_CENTER;
// ukupno_sa_pdv_cell3_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_sa_pdv_cell4_pdf.BackgroundColor = new iTextSharp.text.BaseColor(41, 128, 185);
// ukupno_sa_pdv_cell4_pdf.BorderWidth = 3;
ukupno_sa_pdv_cell10_pdf.BorderColor = BaseColor.BLACK;
ukupno_sa_pdv_cell10_pdf.Padding = 1;
ukupno_sa_pdv_cell9_pdf.Padding = 1;
pdvTable.AddCell(ukupno_sa_pdv_cell9_pdf);
pdvTable.AddCell(ukupno_sa_pdv_cell10_pdf);
string korisnik_programa = "";
using (SqlConnection openCon = new SqlConnection(Con))
{
SqlDataReader reader;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select puno_ime from podaci_o_korisniku";
cmd.Connection = openCon;
openCon.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
korisnik_programa = reader[0].ToString();
}
openCon.Close();
}
string adresa = "";
using (SqlConnection openCon = new SqlConnection(Con))
{
SqlDataReader reader;
SqlCommand cmd2 = new SqlCommand();
cmd2.CommandText = "select adresa from podaci_o_korisniku";
cmd2.Connection = openCon;
openCon.Open();
reader = cmd2.ExecuteReader();
while (reader.Read())
{
adresa = reader[0].ToString();
}
openCon.Close();
}
string jib2 = "";
using (SqlConnection openCon = new SqlConnection(Con))
{
SqlDataReader reader;
SqlCommand cmd3 = new SqlCommand();
cmd3.CommandText = "select jib2 from podaci_o_korisniku";
cmd3.Connection = openCon;
openCon.Open();
reader = cmd3.ExecuteReader();
while (reader.Read())
{
jib2 = reader[0].ToString();
}
openCon.Close();
}
string pib2 = "";
using (SqlConnection openCon2 = new SqlConnection(Con))
{
SqlDataReader reader2;
SqlCommand cmd4 = new SqlCommand();
cmd4.CommandText = "select pib2 from podaci_o_korisniku";
cmd4.Connection = openCon2;
openCon2.Open();
reader2 = cmd4.ExecuteReader();
while (reader2.Read())
{
pib2 = reader2[0].ToString();
}
openCon2.Close();
}
string mesto = "";
using (SqlConnection openCon3 = new SqlConnection(Con))
{
SqlDataReader reader3;
SqlCommand cmd5 = new SqlCommand();
cmd5.CommandText = "select mesto from podaci_o_korisniku";
cmd5.Connection = openCon3;
openCon3.Open();
reader3 = cmd5.ExecuteReader();
while (reader3.Read())
{
mesto = reader3[0].ToString();
}
openCon3.Close();
}
string ziro_racun2 = "";
using (SqlConnection openCon6 = new SqlConnection(Con))
{
SqlDataReader reader6;
SqlCommand cmd6 = new SqlCommand();
cmd6.CommandText = "select ziro_racun2 from podaci_o_korisniku";
cmd6.Connection = openCon6;
openCon6.Open();
reader6 = cmd6.ExecuteReader();
while (reader6.Read())
{
ziro_racun2 = reader6[0].ToString();
}
openCon6.Close();
}
string e_mail = "";
using (SqlConnection openCon7 = new SqlConnection(Con))
{
SqlDataReader reader7;
SqlCommand cmd7 = new SqlCommand();
cmd7.CommandText = "select e_mail from podaci_o_korisniku";
cmd7.Connection = openCon7;
openCon7.Open();
reader7 = cmd7.ExecuteReader();
while (reader7.Read())
{
e_mail = reader7[0].ToString();
}
openCon7.Close();
}
string redni_broj = "";
using (SqlConnection openCon8 = new SqlConnection(Con))
{
SqlDataReader reader8;
SqlCommand cmd8 = new SqlCommand();
cmd8.CommandText = "select FORMAT(redni_broj, '00000') from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd8.Connection = openCon8;
openCon8.Open();
reader8 = cmd8.ExecuteReader();
while (reader8.Read())
{
redni_broj = reader8[0].ToString();
}
openCon8.Close();
}
string kupac = "";
using (SqlConnection openCon9 = new SqlConnection(Con))
{
SqlDataReader reader9;
SqlCommand cmd9 = new SqlCommand();
cmd9.CommandText = "select poslovni_partner from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd9.Connection = openCon9;
openCon9.Open();
reader9 = cmd9.ExecuteReader();
while (reader9.Read())
{
kupac = reader9[0].ToString();
}
openCon9.Close();
}
string datum = "";
using (SqlConnection openCon10 = new SqlConnection(Con))
{
SqlDataReader reader10;
SqlCommand cmd10 = new SqlCommand();
// cmd10.CommandText = "select datum from mp_racun_lista where id=" + id_fakture;
cmd10.CommandText = "SELECT CONVERT(VARCHAR(10), datum , 104) from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd10.Connection = openCon10;
openCon10.Open();
reader10 = cmd10.ExecuteReader();
while (reader10.Read())
{
datum = reader10[0].ToString();
}
openCon10.Close();
}
string valuta_placanja_pdf = "";
using (SqlConnection openCon11 = new SqlConnection(Con))
{
SqlDataReader reader11;
SqlCommand cmd11 = new SqlCommand();
cmd11.CommandText = "SELECT CONVERT(VARCHAR(10), valuta_placanja , 104) AS [DD.MM.YYYY] from .mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd11.Connection = openCon11;
openCon11.Open();
reader11 = cmd11.ExecuteReader();
while (reader11.Read())
{
valuta_placanja_pdf = reader11[0].ToString();
}
openCon11.Close();
}
//string mesto_izdavanja_pdf = "";
//using (SqlConnection openCon12 = new SqlConnection(con))
//{
// SqlDataReader reader12;
// SqlCommand cmd12 = new SqlCommand();
// cmd12.CommandText = "select mesto_izdavanja from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
// cmd12.Connection = openCon12;
// openCon12.Open();
// reader12 = cmd12.ExecuteReader();
// while (reader12.Read())
// {
// mesto_izdavanja_pdf = reader12[0].ToString();
// }
// openCon12.Close();
//}
//string fakturisao_pdf = "";
//using (SqlConnection openCon13 = new SqlConnection(con))
//{
// SqlDataReader reader13;
// SqlCommand cmd13 = new SqlCommand();
// cmd13.CommandText = "select fakturisao from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
// cmd13.Connection = openCon13;
// openCon13.Open();
// reader13 = cmd13.ExecuteReader();
// while (reader13.Read())
// {
// fakturisao_pdf = reader13[0].ToString();
// }
// openCon13.Close();
//}
string slogan_korisnika = "";
using (SqlConnection openCon14 = new SqlConnection(Con))
{
SqlDataReader reader14;
SqlCommand cmd14 = new SqlCommand();
cmd14.CommandText = "select slogan_korisnika from podaci_o_korisniku";
cmd14.Connection = openCon14;
openCon14.Open();
reader14 = cmd14.ExecuteReader();
while (reader14.Read())
{
slogan_korisnika = reader14[0].ToString();
}
openCon14.Close();
}
string jib_pdf = "";
using (SqlConnection openCon15 = new SqlConnection(Con))
{
SqlDataReader reader15;
SqlCommand cmd15 = new SqlCommand();
cmd15.CommandText = "select jib from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd15.Connection = openCon15;
openCon15.Open();
reader15 = cmd15.ExecuteReader();
while (reader15.Read())
{
jib_pdf = reader15[0].ToString();
}
openCon15.Close();
}
string pib_pdf = "";
using (SqlConnection openCon16 = new SqlConnection(Con))
{
SqlDataReader reader16;
SqlCommand cmd16 = new SqlCommand();
cmd16.CommandText = "select pib from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd16.Connection = openCon16;
openCon16.Open();
reader16 = cmd16.ExecuteReader();
while (reader16.Read())
{
pib_pdf = reader16[0].ToString();
}
openCon16.Close();
}
//string postanski_broj_kupca_pdf = "";
//using (SqlConnection openCon17 = new SqlConnection(con))
//{
// SqlDataReader reader17;
// SqlCommand cmd17 = new SqlCommand();
// cmd17.CommandText = "select postanski_broj_kupca from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
// cmd17.Connection = openCon17;
// openCon17.Open();
// reader17 = cmd17.ExecuteReader();
// while (reader17.Read())
// {
// postanski_broj_kupca_pdf = reader17[0].ToString();
// }
// openCon17.Close();
//}
string adresa_kupca_pdf = "";
using (SqlConnection openCon18 = new SqlConnection(Con))
{
SqlDataReader reader18;
SqlCommand cmd18 = new SqlCommand();
cmd18.CommandText = "select adresa from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd18.Connection = openCon18;
openCon18.Open();
reader18 = cmd18.ExecuteReader();
while (reader18.Read())
{
adresa_kupca_pdf = reader18[0].ToString();
}
openCon18.Close();
}
string mesto_kupca_pdf = "";
using (SqlConnection openCon19 = new SqlConnection(Con))
{
SqlDataReader reader19;
SqlCommand cmd19 = new SqlCommand();
cmd19.CommandText = "select mesto from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd19.Connection = openCon19;
openCon19.Open();
reader19 = cmd19.ExecuteReader();
while (reader19.Read())
{
mesto_kupca_pdf = reader19[0].ToString();
}
openCon19.Close();
}
string drzava_kupca_pdf = "";
using (SqlConnection openCon20 = new SqlConnection(Con))
{
SqlDataReader reader20;
SqlCommand cmd20 = new SqlCommand();
cmd20.CommandText = "select drzava from dbo.mp_ulazni_racun_roba_lista where id=" + id_fakture;
cmd20.Connection = openCon20;
openCon20.Open();
reader20 = cmd20.ExecuteReader();
while (reader20.Read())
{
drzava_kupca_pdf = reader20[0].ToString();
}
openCon20.Close();
}
byte[] Memorandum = null;
using (SqlConnection openCon21 = new SqlConnection(Con))
using (SqlCommand cmd21 = new SqlCommand())
{
cmd21.CommandText = "select memorandum from podaci_o_korisniku";
cmd21.Connection = openCon21;
openCon21.Open();
using (SqlDataReader reader21 = cmd21.ExecuteReader())
{
if (reader21.Read() && !reader21.IsDBNull(0))
{
Memorandum = (byte[])reader21[0];
}
else
{
Memorandum = null;
}
}
}
if (Memorandum == null)
{
MessageBox.Show("Ucitajte zaglavlje kako biste odštampali dokument!" + "\n" + "Zaglavlje možete ucitati u:" + "\n" + "Šifarnici /1500 Osnovni podaci / 1501 Podaci o korisniku ", "Informacija", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
iTextSharp.text.Image logo = iTextSharp.text.Image.GetInstance(Memorandum);
//Exporting to PDF
//drzava_kupca
string folderPath = "C:\\Program files\\BSS\\PDFs\\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "Ulazni racun - ROBA.pdf", FileMode.Create))
{
iTextSharp.text.Font calibriTitle = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibriSubTitle = new iTextSharp.text.Font(bfCalibri, 12);
iTextSharp.text.Font calibriSubTitle2 = new iTextSharp.text.Font(bfCalibri, 10);
iTextSharp.text.Font calibriSubTitlebold = new iTextSharp.text.Font(bfCalibri, 14, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibri10bold = new iTextSharp.text.Font(bfCalibri, 10, iTextSharp.text.Font.BOLD);
iTextSharp.text.Font calibri22bold = new iTextSharp.text.Font(bfCalibri, 22, iTextSharp.text.Font.BOLDITALIC);
Document pdfDoc = new Document(PageSize.A4, 20f, 15f, 10f, 130f);
PdfWriter writer = PdfWriter.GetInstance(pdfDoc, stream);
// PdfWriter.GetInstance(pdfDoc, stream, writer);
pdfDoc.Open();
logo.ScaleAbsolute(550, 110);
logo.SetAbsolutePosition(25, 700);
pdfDoc.Add(logo);
//pdfDoc.Add(new ListItem(" "));
//pdfDoc.Add(new ListItem(" "));
//pdfDoc.Add(new ListItem(korisnik_programa, calibriTitle));
//pdfDoc.Add(new ListItem(adresa, calibriSubTitle));
//pdfDoc.Add(new ListItem(mesto, calibriSubTitle));
//pdfDoc.Add(new ListItem("JIB:" + " " + jib2, calibriSubTitle));
//pdfDoc.Add(new ListItem("PIB:" + " " + pib2, calibriSubTitle));
//pdfDoc.Add(new ListItem("Žiro-racun:" + " " + ziro_racun2, calibriSubTitle));
//pdfDoc.Add(new ListItem("E-mail:" + " " + e_mail, calibriSubTitle));
// pdfDoc.Add(new ListItem(" "));
// pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" Ulazni racun - ROBA Broj: " + DateTime.Now.Year + " - 2101 - " + redni_broj, calibriSubTitlebold));
// pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" Dokument - 2101 Dobavljac: " + kupac, calibri10bold));
pdfDoc.Add(new ListItem(" Datum: " + datum + " JIB: " + jib_pdf, calibriSubTitle2));
pdfDoc.Add(new ListItem(" Valuta placanja: " + valuta_placanja_pdf + " PIB: " + pib_pdf, calibriSubTitle2));
pdfDoc.Add(new ListItem(" Adresa: " + adresa_kupca_pdf, calibriSubTitle2));
pdfDoc.Add(new ListItem(" Mesto: " + mesto_kupca_pdf, calibriSubTitle2));
pdfDoc.Add(new ListItem(" " + drzava_kupca_pdf, calibriSubTitle2));
// pdfDoc.Add(new ListItem(" Ugovor: " + ugovorTextBox.Text + " ", calibriSubTitle2));
// pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
pdfDoc.Add(new ListItem(" "));
// pdfDoc.Add(new ListItem(" "));
// pdfDoc.Add(pdfTable);
//pdfDoc.Add(pdfTable);
//pdfDoc.Add(pdfTable2);
//pdfDoc.Add(pdvTable);
// pdfDoc.Add(new ListItem("Broj fiskalnog racuna: " + fiskalni_brojTextBox.Text, calibri));
pdfDoc.Add(new ListItem("", calibri));
//pdfDoc.Add(new ListItem("Napomena: NISMO U SISTEMU PDV-a.", calibri));
// pdfDoc.Add(new ListItem("Napomena: " + ugovorTextBox.Text, calibri));
PdfContentByte cb = writer.DirectContent;
PdfContentByte cb1 = writer.DirectContent;
cb.SetColorStroke(new BaseColor(41, 128, 185));// boja linija
iTextSharp.text.Rectangle fakturisao = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 520f, 50f);
iTextSharp.text.Rectangle primio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 60f, 50f);
iTextSharp.text.Rectangle otpremio = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 40f, 17f, pdfDoc.PageSize.Width - 130f, 50f); //vedran mocic
iTextSharp.text.Rectangle mp = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 75f, pdfDoc.PageSize.Width - 235f, 50f); //mp
iTextSharp.text.Rectangle ukupno_za_uplatu = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 462f, 590f);
// iTextSharp.text.Rectangle slogan_korisnika2 = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 340f, 10f, pdfDoc.PageSize.Width - 20f, 10f);
// iTextSharp.text.Rectangle jib_pdf_ispis= new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 140f, 120f, pdfDoc.PageSize.Width - 289f, 620f);
// iTextSharp.text.Rectangle pib_pdf_ispis = new iTextSharp.text.Rectangle(pdfDoc.PageSize.Width - 100f, 120f, pdfDoc.PageSize.Width - 40f, 620f);
cb1.SetLineWidth(2);
cb1.RoundRectangle(17f, 548f, 260f, 100f, 10f); // podaci o placanju rectangle
cb1.Stroke();
cb1.SetLineWidth(2);
cb1.RoundRectangle(320f, 548f, 260f, 100f, 10f); // kupac rectangle
cb1.Stroke();
//cb1.SetLineWidth(2);
// cb1.RoundRectangle(130f, 548f, 150f, 30f, 10f); // ukupno za uplatu rectangle
// cb1.Stroke();
//cb.SetColorStroke(new CMYKColor(1f, 0f, 0f, 0f));// boja linija
// cb.SetColorStroke(new BaseColor(41,128,185));// boja linija
// cb.SetColorFill(new CMYKColor(0f, 0f, 1f, 0f));
cb1.SetLineWidth(2);
cb1.RoundRectangle(10f, 691f, 570f, 140f, 10f); // zaglavlje rectangle
cb1.Stroke();
cb.SetLineWidth(1);
cb.MoveTo(10f, 683f); //linija gornja zaglavlje
cb.LineTo(580f, 683f);
cb.Stroke();
cb.SetLineWidth(1);
cb.MoveTo(10f, 659f); // linija donja zaglavlje
cb.LineTo(580f, 659f);
cb.Stroke();
cb.SetLineWidth(0.5);
cb1.RoundRectangle(415f, 30f, 160f, 60f, 10f);// primio rectangle
cb1.Stroke();
cb.SetLineWidth(1);
cb.MoveTo(15f, 535f);// linija izmedju kupac rectangle i tabele
cb.LineTo(585f, 535f);
cb.Stroke();
pdfDoc.Add(pdfTable);
pdfDoc.Add(pdfTable2);
pdfDoc.Add(pdvTable);
//cb.SetLineWidth(0.5);
//cb1.RoundRectangle(220f, 30f, 160f, 60f, 10f);// otpremio rectangle
//cb1.Stroke();
//cb.SetLineWidth(0.5);
//cb.RoundRectangle(20f, 30f, 160f, 60f, 10f); // fakturisao rectangle
//cb.Stroke();
// You can add text inside this rectangle like this:
ColumnText ct = new ColumnText(cb);
ct.SetSimpleColumn(primio);
ct.AddElement(new Paragraph(" Primio: ", calibri10bold));
ct.Go();
//ct.SetSimpleColumn(jib_pdf_ispis);
//ct.AddElement(new Paragraph(" JIB:" + jib_pdf, calibri10bold));
// ct.Go();
//ct.SetSimpleColumn(pib_pdf_ispis);
// ct.AddElement(new Paragraph(" PIB:" + pib_pdf, calibri10bold));
// ct.Go();
// ColumnText ct2 = new ColumnText(cb);
// ct.SetSimpleColumn(fakturisao);
// ct.AddElement(new Paragraph("Fakturisao: ", calibri10bold));
// ct.AddElement(new Paragraph("Fakturisao: " + fakturisao_pdf, calibriSubTitle));
// ct.Go();
// ct.SetSimpleColumn(slogan_korisnika2); //slogan_korisnika text
// ct.AddElement(new Paragraph(slogan_korisnika, calibri10bold));
// ct.Go();
//ct.SetSimpleColumn(otpremio);// Vedran Mocic
//ct.AddElement(new Paragraph(fakturisaoComboBox.Text, calibri10bold));
//ct.Go();
ct.SetSimpleColumn(mp);// Vedran Mocic
ct.AddElement(new Paragraph("M.P.", calibri10bold));
ct.Go();
//ct.SetSimpleColumn(ukupno_za_uplatu);// otpremio text
// ct.AddElement(new Paragraph(iznos_sa_pdvTextBox.Text.ToString(), calibri22bold));
//ct.Go();
// pdfDoc.Add(pdfTable);
// pdfDoc.Add(pdfTable2);
//cb.SetColorStroke(new BaseColor(41, 128, 185));// boja linija
//pdfDoc.Add(pdfTable2);
//cb.MoveTo(30f, 45f); // linija donja fakturisao
// cb.LineTo(170f, 45f);
// cb.Stroke();
cb.MoveTo(425f, 45f); // linija donja primio
cb.LineTo(565f, 45f);
cb.Stroke();
//cb.MoveTo(230f, 45f); // linija donja otpremio
//cb.LineTo(370f, 45f);
//cb.Stroke();
cb.SetLineWidth(0.5);
cb.MoveTo(20f, 20f); // linija donja slogan firme
cb.LineTo(580f, 20f);
cb.Stroke();
// cb.SetLineWidth(0.5);
// cb.MoveTo(5f, 5f); //linija korisnik programa
// cb.LineTo(5f, 820f);
// cb.Stroke();
pdfDoc.Close();
stream.Close();
System.Diagnostics.Process.Start(folderPath + "Ulazni racun - ROBA.pdf");
}
}
Result I need:
Thank you