private void button8_Click(object sender, EventArgs e) { try { string DELETE = string.Format("delete from BATCH where BATCHID= ('{0}')", Convert.ToInt32(BatchIDtextbox.Text)); EventMangementSystemClass.DeleteQuery(DELETE); BatchIDtextbox.Clear(); textBox3.Clear(); dateTimePicker1.ResetText(); COMPANY_BATCH_PACKING_Load(sender, e); dataGridView3.Refresh(); } catch (Exception EX) { MessageBox.Show(EX.Message); } }
private void button7_Click(object sender, EventArgs e) { try { System.DateTime sdate = default(System.DateTime); sdate = dateTimePicker1.Value; System.DateTime sdate1 = default(System.DateTime); sdate1 = dateTimePicker1.Value; System.DateTime sdate2 = default(System.DateTime); sdate2 = dateTimePicker1.Value; string updatequery = string.Format("UPDATE BATCH SET BATCHNAME = ('{0}'),BATCHDATE = ('{1}') WHERE BATCHID = ('{2}')", textBox3.Text, sdate, Convert.ToInt32(BatchIDtextbox.Text)); EventMangementSystemClass.Update(updatequery); BatchIDtextbox.Clear(); textBox3.Clear(); dateTimePicker1.ResetText(); COMPANY_BATCH_PACKING_Load(sender, e); dataGridView3.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button9_Click(object sender, EventArgs e) { try { System.DateTime sdate = default(System.DateTime); sdate = dateTimePicker1.Value; System.DateTime sdate1 = default(System.DateTime); sdate1 = dateTimePicker1.Value; System.DateTime sdate2 = default(System.DateTime); sdate2 = dateTimePicker1.Value; string addquery = string.Format("insert into BATCH(BATCHNAME,BATCHDATE) values ('{0}','{1}')", textBox3.Text, sdate); EventMangementSystemClass.Add(addquery); BatchIDtextbox.Clear(); textBox3.Clear(); dateTimePicker1.ResetText(); COMPANY_BATCH_PACKING_Load(sender, e); dataGridView3.Refresh(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }