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();
}
}
}