private void button6_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
System.DateTime date2 = default(System.DateTime);
sdate = startdatetimepicker.Value;
date2 = lastdatetimepicker.Value;
string updatequery = string.Format("delete from CUSTOMER where CUSTOMERID = ('{0}')", Convert.ToInt32(customeridtextbox.Text));
EventMangementSystemClass.Update(updatequery);
customernametextbox.Clear();
customeridtextbox.Clear();
maskedTextBox2.Clear();
textBox2.Clear();
maskedTextBox1.Clear();
startdatetimepicker.ResetText();
STATUS.Clear();
lastdatetimepicker.ResetText();
CUSTOMER_INFORMATION_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button4_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
System.DateTime date2 = default(System.DateTime);
sdate = startdatetimepicker.Value;
date2 = lastdatetimepicker.Value;
string updatequery = string.Format("UPDATE customer SET NAME = ('{0}'), CONTACTNUMBER = ('{1}'), [ADDRESS] = ('{2}'), NIC = ('{3}'), JOINDATE = ('{4}'), [STATUS] = ('{5}'), LEAVEDATE = ('{6}') WHERE CUSTOMERID =('{7}')", customernametextbox.Text, maskedTextBox2.Text, textBox2.Text, maskedTextBox1.Text, sdate, STATUS.Text, date2, Convert.ToInt32(customeridtextbox.Text));
EventMangementSystemClass.Update(updatequery);
customernametextbox.Clear();
customeridtextbox.Clear();
maskedTextBox2.Clear();
textBox2.Clear();
maskedTextBox1.Clear();
startdatetimepicker.ResetText();
STATUS.Clear();
lastdatetimepicker.ResetText();
CUSTOMER_INFORMATION_Load(sender, e);
dataGridView2.Refresh();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
customernametextbox.Clear();
customeridtextbox.Clear();
maskedTextBox2.Clear();
textBox2.Clear();
maskedTextBox1.Clear();
startdatetimepicker.ResetText();
STATUS.Clear();
lastdatetimepicker.ResetText();
}