private void button1_Click(object sender, EventArgs e)
{
try
{
WeighbridgeEntry frm = new WeighbridgeEntry();
Document document = new Document();
PdfWriter writer = PdfWriter.GetInstance(document, new FileStream("C:/Report/WeighBridgeExitReport.pdf", FileMode.Create));
//PdfWriter writer = PdfWriter.GetInstance(document, outStream);
document.Open();
PdfContentByte cb = writer.DirectContent;
string constrg = constring();
MySqlConnection connection = new MySqlConnection(constrg);
connection.Open();
string regs = "^([B-Z]{1}[\\-]{1}[B-Z]{1})$";
string sqlRpt = "SELECT CONCAT(truck_entry_regs.truck_type,'-',truck_entry_regs.truck_no) AS truck_no," +
" truck_entry_regs.driver_name,truck_entry_regs.gweight_wbridge,truck_entry_regs.wbrdge_time1,truck_entry_regs.wbridg_user1," +
" truck_entry_regs.tr_weight,truck_entry_regs.tweight_wbridge,truck_entry_regs.wbrdge_time2,truck_entry_regs.wbridg_user2," +
" manifests.manifest,users.name" +
" FROM truck_entry_regs" +
" JOIN manifests ON manifests.id= truck_entry_regs.manf_id" +
" JOIN users ON truck_entry_regs.wbridg_user1 = users.id" +
" JOIN roles ON roles.id = users.role_id" +
" WHERE DATE(truck_entry_regs.wbrdge_time2)='" + fromDateTimePicker.Text + "' AND manifests.transshipment_flag = 0" +
" AND SUBSTRING_INDEX(SUBSTRING_INDEX(manifest,'/',2),'/',-1) NOT REGEXP'" + regs + "' " +
" ORDER BY truck_entry_regs.wbrdge_time1 DESC";
// MessageBox.Show(sqlRpt);
MySqlCommand command = new MySqlCommand(sqlRpt, connection);
PdfPTable tableHead = new PdfPTable(3);
PdfPTable table = new PdfPTable(10);
table.WidthPercentage = 100;
tableHead.WidthPercentage = 100;
float[] widths = { 1f, 2f, 2f, 1.7f, 1.7f, 1.7f, 1.5f, 1.7f, 1.7f, 3f };
float[] widthH = { 1.9f, 6f, 2.1f };
table.SetWidths(widths);
tableHead.SetWidths(widthH);
iTextSharp.text.Font fontH1 = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 10);
iTextSharp.text.Font cellFont = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 8);
iTextSharp.text.Image logo = iTextSharp.text.Image.GetInstance(@"logo.jpg");
logo.ScaleAbsolute(60, 60);
PdfPCell cellimage = new PdfPCell();
cellimage.Border = iTextSharp.text.Rectangle.NO_BORDER;
cellimage.HorizontalAlignment = 1;
cellimage.VerticalAlignment = 1;
cellimage.AddElement(logo);
tableHead.AddCell(cellimage);
PdfPTable inrtbl = new PdfPTable(1);
iTextSharp.text.Font fontTitle = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 13);
Paragraph para = new Paragraph("BANGLADESH LANDPORT AUTHORITY", fontTitle);
PdfPCell cellpara = new PdfPCell();
cellpara.Border = iTextSharp.text.Rectangle.NO_BORDER;
cellpara.AddElement(para);
cellpara.HorizontalAlignment = 1;
inrtbl.AddCell(cellpara);
iTextSharp.text.Font fontH2 = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 11);
Paragraph para2 = new Paragraph("Benapole Land Port, Jessore", fontH2);
para2.Alignment = 1;
PdfPCell cellpara2 = new PdfPCell();
cellpara2.Border = iTextSharp.text.Rectangle.NO_BORDER;
cellpara2.AddElement(para2);
cellpara2.HorizontalAlignment = 1;
inrtbl.AddCell(cellpara2);
Paragraph para3 = new Paragraph("Weight Bridge Exit Report\n\n", fontH2);
para3.Alignment = 1;
PdfPCell cellpara3 = new PdfPCell();
cellpara3.Border = iTextSharp.text.Rectangle.NO_BORDER;
cellpara3.AddElement(para3);
cellpara3.HorizontalAlignment = 1;
inrtbl.AddCell(cellpara3);
PdfPCell cellParagraph = new PdfPCell();
cellParagraph.Border = iTextSharp.text.Rectangle.NO_BORDER;
cellParagraph.HorizontalAlignment = 1;
cellParagraph.AddElement(inrtbl);
tableHead.AddCell(cellParagraph);
iTextSharp.text.Font timeFont = new iTextSharp.text.Font(iTextSharp.text.Font.FontFamily.TIMES_ROMAN, 8);
//var time = DateTime.Now;
string formattedTime = "\n\nTime: " + DateTime.Now.ToString() + " \n Scale: " + scaleName;
Paragraph timeParagraph = new Paragraph(formattedTime, timeFont);
PdfPCell cellbDT = new PdfPCell();
cellbDT.Border = iTextSharp.text.Rectangle.NO_BORDER;
cellbDT.HorizontalAlignment = 1;
cellbDT.AddElement(timeParagraph);
tableHead.AddCell(cellbDT);
document.Add(tableHead);
//Create a test paragraph
var p1 = new Paragraph("BANGLADESH LANDPORT AUTHORITY");
var p2 = new Paragraph("Benapole Land Port, Jessore");
var p3 = new Paragraph("Weight Bridge Exit Report");
p2.Font.Size = 10;
p3.Font.Size = 9;
p1.Alignment = Element.ALIGN_CENTER;
p2.Alignment = Element.ALIGN_CENTER;
p3.Alignment = Element.ALIGN_CENTER;
document.Add(new Chunk("\n"));
document.Add(new Chunk("\n"));
document.Add(new Chunk("\n"));
document.Add(new Chunk("\n"));
using (MySqlDataReader rdr = command.ExecuteReader())
{
table.AddCell(new PdfPCell(new Phrase("Serial No.", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Manifest No.", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Truck No.", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Driver Name", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Gross Weight.", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Entry Time", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Tare Weight", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Net Weight", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Exit Time", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase("Exit By", fontH1))).HorizontalAlignment = Element.ALIGN_CENTER;
int i = 1;
while (rdr.Read())
{
/* iterate once per row */
//Chunk pdfData = new Chunk(truck_type);
//document.Add(new Paragraph(pdfData));
//string manifest = rdr.GetString("manifest");
// tr-0, dri-1, gw-2, wbt1-3, tr-5, twb-6, wbt2-7, mani- 9, na-10
// Serial No. Manifest No. Truck No.DriverName Gross Weight Entry Time Tare Weight Net Weight
table.AddCell(new PdfPCell(new Phrase(i.ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(9).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(0).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(1).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(2).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(3).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(5).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(6).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(7).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
table.AddCell(new PdfPCell(new Phrase(rdr.GetValue(10).ToString(), cellFont))).HorizontalAlignment = Element.ALIGN_CENTER;
i++;
}
document.Add(table);
}
document.Close();
// string wantedPath = Path.GetDirectoryName(Path.GetDirectoryName(System.IO.Directory.GetCurrentDirectory()));
// MessageBox.Show(wantedPath);
// if (wantedPath != null)
// wantedPath = wantedPath.Replace("\\", "/");
//string pdfpath = wantedPath + "/bin/Debug/lib/exitReport.pdf";
// MessageBox.Show(pdfpath);
string pdfPath = "C:/Report/WeighBridgeExitReport.pdf";
System.Diagnostics.Process.Start(pdfPath);
// System.Server.MapPath("~/pdf");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
string constr = "";
if (textBox1.Text.Equals(""))
{
MessageBox.Show("Plesae enter Login ID;");
textBox1.Focus();
return;
}
if (textBox2.Text.Equals(""))
{
MessageBox.Show("Plesae enter Password;");
textBox2.Focus();
return;
}
int pass = 0;
constr = constring();
if (constr.Equals(""))
{
return;
}
MySqlConnection con = new MySqlConnection(constr);
string query = @"SELECT COUNT(*) AS cnt,u.id, pu.port_id,p.port_name,p.port_alias,
p.Operator_description,p.port_add1
FROM users AS u
JOIN port_user AS pu ON pu.user_id=u.id
JOIN ports AS p ON p.id = pu.port_id
WHERE u.username='******' AND u.password1=SHA1('" + textBox2.Text.Trim() + "') ";
MySqlCommand cmd = new MySqlCommand(query, con);
con.Open();
MySqlDataReader mred = cmd.ExecuteReader();
if (mred.Read())
{
//pass = mred.GetString("cnt");
pass = mred.GetInt16("cnt");
if (pass == 1)
{
//utility.UserId = mred.GetUInt16("id");
//utility.UserName = textBox1.Text;
//utility.PortId= mred.GetString("port_id");
//utility.PortName = mred.GetString("port_name");
//utility.PortAdress= mred.GetString("port_add1");
//MessageBox.Show(utility.UserName);
ReportViewForm rvForm = new ReportViewForm();
rvForm.username = textBox1.Text;
usr = textBox1.Text;
int userId = mred.GetUInt16("id");
WeighbridgeEntry frm = new WeighbridgeEntry();
this.Hide();
frm.userName = textBox1.Text;
frm.userID = userId;
frm.portName = mred.GetString("port_name");
frm.portId = mred.GetString("port_id");
frm.portAdress = mred.GetString("port_add1");
frm.constr = constr;
frm.Show();// this.Dispose();
}
else
{
MessageBox.Show("Wrong Password;");
textBox2.Focus();
con.Close();
return;
}
}
else
{
MessageBox.Show("Plesae enter Correct Login ID;");
textBox1.Focus();
con.Close();
return;
}
con.Close();
}
