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