private void Doc_PrintPage(object sender, PrintPageEventArgs e)
{
float x = e.MarginBounds.Left;
float y = e.MarginBounds.Top;
this.pblabel.Width = 180;
this.pblabel.Height = 180;
this.pblabel.SizeMode = PictureBoxSizeMode.StretchImage;
Bitmap bmp = new Bitmap(this.pblabel.Width, this.pblabel.Height);
this.pblabel.DrawToBitmap(bmp, new Rectangle(0, 0, this.pblabel.Width, this.pblabel.Height));
e.Graphics.DrawImage((Image)bmp, 180, 260);
//data label
String case_number = gcaseno;
String size = cbpackingsize.Text.Trim();
String grade = cbgrade.Text.Trim();
String box_number = gboxno;
String pieces = txtpieces.Text.Trim();
String boxweight = txtboxweight.Text.Trim();
String lotnumber = glotnumber;
String suppcode = txtsuppcode.Text.Trim();
String intlotcode = get_intlotcode();
String areacode = txtbatch.Text.Trim();
String expireddate = gbest_before_date.ToString("yyyy-MM-dd");
String fishingground = "";
String proddate = dateTimePicker1.Value.ToString("yyyy-MM-dd");
String certcode = "";
String certificate = cbcertificate.Text.Trim();
String species = "";
String id_species = "";
String packingbox = cbproductpacking.Text.Trim();
String producttype = cbproductname.Text.Trim();
String scientificname = "";
String origin = "";
String processedby = "";
String addresscompany = "";
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
data = frm.get_data_table_string("vw_packing_supplier", "case_number", case_number);
if (data.Count > 0)
{
origin = data[0][4].ToString();
fishingground = data[0][2].ToString();
certcode = data[0][6].ToString();
id_species = data[0][16].ToString();
}
data = frm.get_data_table_id("tbproductsetup", Int32.Parse(id_species));
if (data.Count > 0)
{
species = data[0][4].ToString();
}
data = frm.get_data_table_string("tbspecies", "speciesname", species.Trim());
if (data.Count > 0)
{
scientificname = data[0][4].ToString();
}
String companyreg = "";
data = frm.get_data_table_string("tbcompany", "", "");
if (data.Count > 0)
{
processedby = data[0][2].ToString();
addresscompany = data[0][7].ToString();
companyreg = data[0][15].ToString();
}
String batchcode = "";
data = frm.get_data_table_string("tbpacking", "case_number", case_number);
if (data.Count > 0)
{
batchcode = data[0][21].ToString();
}
string[] batch = batchcode.Split('-');
String ismix = "";
if (batch.Length > 1)
{
ismix = "MIX";
}
e.Graphics.DrawString("Case No.", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 38);
e.Graphics.DrawString(case_number, new Font("Arial", 22, FontStyle.Bold), Brushes.Black, 76, 24);
if (!certificate.Equals(""))
{
Pen selPen = new Pen(Color.Black);
e.Graphics.DrawRectangle(selPen, 325, 20, 38, 35);
e.Graphics.DrawString(certificate, new Font("Arial", 14, FontStyle.Bold), Brushes.Black, 330, 25);
selPen.Dispose();
}
if (!ismix.Equals(""))
{
e.Graphics.DrawString(ismix, new Font("Arial", 28, FontStyle.Bold), Brushes.Black, 300, 205);
}
producttype = producttype.ToUpper();
e.Graphics.DrawString(producttype, new Font("Arial", 15, FontStyle.Bold), Brushes.Black, 18, 70);
e.Graphics.DrawString("( " + scientificname + " )", new Font("Arial", 14, FontStyle.Bold), Brushes.Black, 90, 96);
e.Graphics.DrawString("Grade", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 140);
e.Graphics.DrawString(grade, new Font("Arial", 18, FontStyle.Bold), Brushes.Black, 16, 155);
e.Graphics.DrawString("Size", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 100, 140);
e.Graphics.DrawString(size, new Font("Arial", 18, FontStyle.Bold), Brushes.Black, 100, 155);
e.Graphics.DrawString("Net Weight (Kg)", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 210, 140);
e.Graphics.DrawString(boxweight, new Font("Arial", 18, FontStyle.Bold), Brushes.Black, 210, 155);
e.Graphics.DrawString("Pieces", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 320, 140);
e.Graphics.DrawString(pieces, new Font("Arial", 18, FontStyle.Bold), Brushes.Black, 320, 155);
e.Graphics.DrawString("Internal Lot Code", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 190);
e.Graphics.DrawString(intlotcode, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 16, 210);
e.Graphics.DrawString("Packing Size", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 240);
e.Graphics.DrawString(packingbox, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 16, 255);
e.Graphics.DrawString("Expiry Date", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 285);
e.Graphics.DrawString(expireddate, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 16, 300);
e.Graphics.DrawString("Production Date", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 330);
e.Graphics.DrawString(proddate, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 16, 345);
e.Graphics.DrawString("Origin", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 375);
e.Graphics.DrawString(origin, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 72, 375);
if (!certcode.Equals(""))
{
e.Graphics.DrawString(certificate + " Code", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 400);
e.Graphics.DrawString(certcode, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 80, 400);
}
e.Graphics.DrawString("Processed By", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 440);
e.Graphics.DrawString(processedby, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, 16, 465);
e.Graphics.DrawString(addresscompany, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 485);
if (!companyreg.Trim().Equals(""))
{
e.Graphics.DrawString("Vietnam Registration No", new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 16, 540);
e.Graphics.DrawString(companyreg, new Font("Arial", 10, FontStyle.Bold), Brushes.Black, 180, 540);
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dataGridView1.Columns["Delete"].Index && e.RowIndex >= 0)
{
DialogResult dialogResult = MessageBox.Show("Are you sure to delete user account " + this.dataGridView1.Rows[e.RowIndex].Cells[1].Value + "?", "Delete", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
MainMenu frm = new MainMenu();
Int32 id = frm.get_id_data_table("tbuser", "username", e.RowIndex);
string connString = Konek();
MySqlConnection conn3 = null;
conn3 = new MySqlConnection(connString);
conn3.Open();
MySqlCommand mySql = conn3.CreateCommand();
mySql.CommandText = "delete from tbuser where id=@id";
mySql.Parameters.AddWithValue("@id", id);
mySql.ExecuteNonQuery();
conn3.Close();
//Delete from Receive_Truck
dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[0].Index);
loaddatauser();
}
}
if (e.ColumnIndex == dataGridView1.Columns["Password"].Index && e.RowIndex >= 0)
{
DialogResult dialogResult = MessageBox.Show("Are you sure to change password for " + this.dataGridView1.Rows[e.RowIndex].Cells[1].Value + "?", "Change Password", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
panel2.Visible = true;
txtuseredit.Text = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
return;
}
}
if (e.ColumnIndex == 8 && e.RowIndex >= 0)
{
if (dataGridView1.Columns["Edit"].HeaderText.Equals("Edit"))
{
txtlongname.Text = this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
txtpersonalid.Text = this.dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
txtjobtitle.Text = this.dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
txtnationality.Text = this.dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
String tgl = this.dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString();
dateTimePicker1.Value = DateTime.Parse(tgl);
txtuserid.Text = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
txtuserid.Visible = false;
label7.Visible = false;
label8.Visible = false;
label9.Visible = false;
txtpassword.Visible = false;
txtretypepassword.Visible = false;
this.flag.Text = "edit";
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
Int32 id = frm.get_id_data_table("tbuser", "username", e.RowIndex);
data = frm.get_data_table_id("tbuser", id);
//data = frm.get_data_table_string("tbuser", "username", txtuserid.Text);
if (data[0][7] != null || !data[0][7].ToString().Equals(""))
{
comboBox1.Text = data[0][7].ToString();
}
else
{
comboBox1.Text = "Male";
}
txtnationality.Text = data[0][8].ToString();
txtpersonalid.Text = data[0][4].ToString();
if (data[0][10] != null)
{
dateTimePicker1.Value = Convert.ToDateTime(data[0][10]);
}
String useraccess = data[0][9].ToString();
load_access_user(useraccess);
/*
* if (useraccess.ToLowerInvariant().Contains("master"))
* {
* cmaster.Checked = true;
* }
* else
* {
* cmaster.Checked = false;
* }
*
* if (useraccess.ToLowerInvariant().Contains("receiving"))
* {
* creceiving.Checked = true;
* }
* else
* {
* creceiving.Checked = false;
* }
*
* if (useraccess.ToLowerInvariant().Contains("cutting"))
* {
* ccutting.Checked = true;
* }
* else
* {
* ccutting.Checked = false;
* }
*
* if (useraccess.ToLowerInvariant().Contains("retouching"))
* {
* cretouching.Checked = true;
* }
* else
* {
* cretouching.Checked = false;
* }
*
* if (useraccess.ToLowerInvariant().Contains("boxing"))
* {
* cpacking.Checked = true;
* }
* else
* {
* cpacking.Checked = false;
* }
*
* if (useraccess.ToLowerInvariant().Contains("boxing"))
* {
* cpacking.Checked = true;
* }
* else
* {
* cpacking.Checked = false;
* }
*
* if (useraccess.ToLowerInvariant().Contains("packing"))
* {
* cstuffing.Checked = true;
* }
* else
* {
* cstuffing.Checked = false;
* }
*
* if (useraccess.ToLowerInvariant().Contains("invoice"))
* {
* cpackinglist.Checked = true;
* }
* else
* {
* cpackinglist.Checked = false;
* }
*/
return;
}
}
}
private void generateqrlabel()
{
QrCodeEncodingOptions options = new QrCodeEncodingOptions
{
DisableECI = true,
CharacterSet = "UTF-8",
Width = 180,
Height = 180,
};
BarcodeWriter writer = new BarcodeWriter();
writer.Format = BarcodeFormat.QR_CODE;
writer.Options = options;
var qr = new ZXing.BarcodeWriter();
qr.Options = options;
qr.Format = ZXing.BarcodeFormat.QR_CODE;
//data label
String case_number = gcaseno;
String size = cbpackingsize.Text.Trim();
String grade = cbgrade.Text.Trim();
String box_number = gboxno;
String pieces = txtpieces.Text;
String boxweight = txtboxweight.Text;
String lotnumber = glotnumber;
String suppcode = txtsuppcode.Text;
String intlotcode = get_intlotcode();
String areacode = txtbatch.Text.Trim();
String expireddate = gbest_before_date.ToString("yyyy-MM-dd");
String fishingground = "";
String proddate = dateTimePicker1.Value.ToString("yyyy-MM-dd");
String certcode = "";
String species = "";
String id_species = "";
String packingbox = cbproductpacking.Text.Trim();
String producttype = cbproductname.Text.Trim();
String scientificname = "";
String origin = "";
String processedby = "";
String addresscompany = "";
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
data = frm.get_data_table_string("vw_packing_supplier", "case_number", case_number);
if (data.Count > 0)
{
origin = data[0][4].ToString();
fishingground = data[0][2].ToString();
certcode = data[0][6].ToString();
id_species = data[0][16].ToString();
}
data = frm.get_data_table_id("tbproductsetup", Int32.Parse(id_species));
if (data.Count > 0)
{
species = data[0][4].ToString();
}
String companyreg = "";
data = frm.get_data_table_string("tbcompany", "", "");
if (data.Count > 0)
{
companyreg = data[0][15].ToString();
}
data = frm.get_data_table_string("tbspecies", "speciesname", species.Trim());
if (data.Count > 0)
{
scientificname = data[0][4].ToString();
}
data = frm.get_data_table_string("tbcompany", "", "");
if (data.Count > 0)
{
processedby = data[0][2].ToString();
addresscompany = data[0][7].ToString();
}
String dataqr = "";
if (!certcode.Equals(""))
{
dataqr = case_number + "\r\n" + producttype + "\r\n" + scientificname + "\r\n" + packingbox + "\r\n" + grade + "\r\n" + size + "\r\n" + boxweight + "\r\n" + pieces + "\r\n" + origin + "\r\n" + intlotcode + "\r\n" + expireddate + "\r\n" + certcode + "\r\n" + processedby + "\r\n" + addresscompany;
}
else
{
dataqr = case_number + "\r\n" + producttype + "\r\n" + scientificname + "\r\n" + packingbox + "\r\n" + grade + "\r\n" + size + "\r\n" + boxweight + "\r\n" + pieces + "\r\n" + origin + "\r\n" + intlotcode + "\r\n" + expireddate + "\r\n" + processedby + "\r\n" + addresscompany;
}
dataqr = dataqr.Trim() + "\r\n" + "*" + case_number + "*" + "\r\n";
var result = new Bitmap(qr.Write(dataqr));
pblabel.Image = result;
for (int i = 0; i < 2; i++)
{
printlabel();
}
}
