public void setInitialValue()
{
gbentry.Visible = true;
load_processing_company_cb();
List <object[]> data = new List <object[]>();
MainMenu frm = new MainMenu();
/*
* data = frm.get_data_table_string_byid_desc("tbprocessingcompany", "", "");
* cbreceived.Items.Clear();
* if (data.Count > 0)
* {
* for (int i = 0; i < data.Count; i++)
* {
* cbreceived.Items.Add(data[i][1].ToString().Trim());
* }
* }
*/
dateTimePicker1.Value = DateTime.Now;
data = frm.get_data_table_string_byid_desc("tbreceiving_box", "", "");
cbreceiving_recent.Items.Clear();
if (data.Count > 0)
{
for (int i = 0; i < data.Count; i++)
{
cbreceiving_recent.Items.Add(data[i][1].ToString().Trim());
}
}
}
private void load_processing_company_cb()
{
List <object[]> data1 = new List <object[]>();
MainMenu frm = new MainMenu();
data1 = frm.get_data_table_string_byid_desc("tbprocessingcompany", "", "");
cbreceived.Items.Clear();
if (data1.Count > 0)
{
for (int i = 0; i < data1.Count; i++)
{
cbreceived.Items.Add(data1[i][1].ToString().Trim());
}
}
}
public void loaddatacutdet()
{
//set grade empty
String intlotcode = lblInternalcode.Text.Trim();
//get data from table
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
data = frm.get_data_table_string_byid_desc("tbcuttingdetails", "intlotcode", intlotcode);
//Type RM
Int32 no = 0;
dataGridView1.Visible = true;
dataGridView1.Rows.Clear();
if (data.Count > 0)
{
dataGridView1.Rows.Add(data.Count);
for (int i = 0; i < data.Count; i++)
{
no = data.Count - i;
dataGridView1.Rows[i].Height = 50;
dataGridView1.Rows[i].Cells[0].Value = (no).ToString();
dataGridView1.Rows[i].Cells[1].Value = data[i][4].ToString();
dataGridView1.Rows[i].Cells[2].Value = data[i][5].ToString();
}
}
//Image img1 = picedit.Image;
//Bitmap bmp1 = new Bitmap(img1);
Edit_columnbutton();
//Image img = pictureBox2.Image;
//Bitmap bmp = new Bitmap(img);
Delete_columnbutton();
}
void cuttingentry(object sender, EventArgs e, String intlot)
{
String intlotcode = "";
String cutdate = "";
String supplier = "";
String tipe = "";
String species = "";
//var current = sender as Button;
//this.Hide();
//var frmCutting = new frmCutting();
//frmCutting.Closed += (s, args) => this.Close();
//rcv date
DateTime dt = DateTime.Now;
cutdate = dt.ToString("yyyy-MM-dd HH:mm tt");
// supplier
intlotcode = intlot;
List <object[]> data = new List <object[]>();
MainMenu frm = new MainMenu();
data = frm.get_data_table_string("tbreceiving", "intlotcode", intlotcode);
if (data.Count > 0)
{
tipe = data[0][3].ToString();
species = data[0][2].ToString();
supplier = data[0][5].ToString();
}
if (supplier.Equals(""))
{
supplier = frm.get_suppliername(intlotcode);
}
if (species.Equals(""))
{
data = frm.get_data_table_string_byid_desc("tbreceiving", "", "");
if (data.Count > 0)
{
species = data[0][2].ToString();
}
}
if (tipe.Equals(""))
{
data = frm.get_data_table_string("tbcuttingdetails", "intlotcode", intlotcode);
if (data.Count > 0)
{
tipe = data[0][3].ToString();
}
}
/*
*
* if (supplier.Equals(""))
* {
* data = frm.get_data_table_string("tbcuttingdetails", "intlotcode", intlotcode);
* if (data.Count > 0)
* {
* tipe = data[0][3].ToString();
* supplier = frm.get_suppliername(intlotcode);
* }
*
* data = frm.get_data_table_string_byid_desc("tbreceiving", "", "");
* if (data.Count > 0)
* {
* species = data[0][2].ToString();
* }
* }
*/
this.Hide();
frmCutting fc = new frmCutting();
fc.Closed += (s, args) => this.Close();
if (data.Count > 0)
{
fc.setInitialValue(tipe, species, intlotcode, supplier);
fc.loaddatacutdet();
fc.loaddatasummary();
fc.ShowDialog();
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Rows[e.RowIndex].Cells[1].Value == null)
{
return;
}
if (e.ColumnIndex == dataGridView1.Columns["Delete"].Index && e.RowIndex >= 0 && dataGridView1.Rows.Count > 0)
{
DialogResult dialogResult = MessageBox.Show("Are you sure to delete " + this.dataGridView1.Rows[e.RowIndex].Cells[1].Value + " , " + this.dataGridView1.Rows[e.RowIndex].Cells[2].Value + "Kg ?", "Delete", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Int32 n = e.RowIndex;
Int32 id = 0;
String intlotcode = lblInternalcode.Text.Trim();
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
if (textBox1.Text.Equals(""))
{
data = frm.get_data_table_string_byid_desc("tbcuttingdetails", "intlotcode", intlotcode);
}
else
{
data = frm.get_data_table_search("tbcuttingdetails", lblInternalcode.Text.Trim(), textBox1.Text.Trim());
}
//get_data_table_search(String tablename, String intlotcode, String value)
//data = frm.get_data_table_transaction("tbcuttingdetails", intlotcode, "seq1", "seq2");
for (int i = 0; i <= n; i++)
{
if (i == n)
{
id = Int32.Parse(data[i][0].ToString());
}
}
//frm.delete_table("tbcuttingdetails", "id", id.ToString());
String connString = Konek();
MySqlConnection conn5 = new MySqlConnection(connString);
conn5.Open();
try
{
MySqlCommand mySql3 = conn5.CreateCommand();
mySql3.CommandText = "update tbcuttingdetails set tipe=@tipe,grade=@grade,cweight=0,intlotcode=@intlotcode, moddatetime=@moddatetime where id=@id";
mySql3.Parameters.AddWithValue("@tipe", "");
mySql3.Parameters.AddWithValue("@grade", "");
mySql3.Parameters.AddWithValue("@intlotcode", "4del");
mySql3.Parameters.AddWithValue("@moddatetime", frm.get_server_time());
mySql3.Parameters.AddWithValue("@id", id.ToString());
mySql3.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (textBox1.Text.Equals(""))
{
loaddatacutdet();
}
else
{
loaddatasearch(textBox1.Text.Trim());
}
}
}
if (e.ColumnIndex == dataGridView1.Columns["Edit"].Index && e.RowIndex >= 0 && dataGridView1.Rows.Count > 0)
{
DialogResult dialogResult = MessageBox.Show("Are you sure to Edit " + this.dataGridView1.Rows[e.RowIndex].Cells[1].Value + " , " + this.dataGridView1.Rows[e.RowIndex].Cells[2].Value + "Kg ?", "Edit", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Int32 n = e.RowIndex;
Int32 id = 0;
String intlotcode = lblInternalcode.Text.Trim();
MainMenu frm = new MainMenu();
List <object[]> data = new List <object[]>();
if (textBox1.Text.Equals(""))
{
data = frm.get_data_table_string_byid_desc("tbcuttingdetails", "intlotcode", intlotcode);
}
else
{
data = frm.get_data_table_search("tbcuttingdetails", lblInternalcode.Text.Trim(), textBox1.Text.Trim());
}
for (int i = 0; i <= n; i++)
{
if (i == n)
{
id = Int32.Parse(data[i][0].ToString());
lblid.Text = id.ToString();
}
}
panel1.Visible = true;
txtgrade.Text = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
txtweightedit.Text = this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
}
}
}
