private void button1_Click(object sender, EventArgs e)
{
int index = cbBillAmount.SelectedIndex;
switch (index)
{
case 0:
sda = ConsumerDB.getBAGT(Convert.ToDouble(txtBA.Text));
break;
case 1:
sda = ConsumerDB.getBALT(Convert.ToDouble(txtBA.Text));
break;
case 2:
sda = ConsumerDB.getBAGTE(Convert.ToDouble(txtBA.Text));
break;
case 3:
sda = ConsumerDB.getBALTE(Convert.ToDouble(txtBA.Text));
break;
case 4:
sda = ConsumerDB.getBAE(Convert.ToDouble(txtBA.Text));
break;
}
dataTable = new DataTable();
sda.Fill(dataTable);
dataGridBillAmount.DataSource = dataTable;
DBUtil.closeSqlConnection();
}
private void tbCityName_TextChanged(object sender, EventArgs e)
{
if (tbCityName.Text != "")
{
if (cbNameCity.SelectedIndex == 0)
{
sda = ConsumerDB.getConsumerFirstNameLike(tbCityName.Text);
}
else if (cbNameCity.SelectedIndex == 1)
{
sda = ConsumerDB.getConsumerLastNameLike(tbCityName.Text);
}
else if (cbNameCity.SelectedIndex == 2)
{
sda = ConsumerDB.getConsumerCityLike(tbCityName.Text);
}
dataTable = new DataTable();
sda.Fill(dataTable);
dataGridCityName.DataSource = dataTable;
DBUtil.closeSqlConnection();
}
else
{
dataGridCityName.DataSource = null;
}
}
private void btnDisplayAll_Click(object sender, EventArgs e)
{
sda = ConsumerDB.getAll();
dataTable = new DataTable();
sda.Fill(dataTable);
dataGridViewAll.DataSource = dataTable;
DBUtil.closeSqlConnection();
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (tbCID.Text.Length == 11)
{
ConsumerDB.deleteID(tbCID.Text);
DBUtil.closeSqlConnection();
btnDisplayAll_Click(null, null);
}
}
private void duedate_change(object sender, EventArgs e)
{
if (rbDefaulter.Checked)
{
sda = ConsumerDB.getDefaulter(DateTime.Now.Date);
}
else if (rbRegular.Checked)
{
sda = ConsumerDB.getRegular(DateTime.Now.Date);
}
dataTable = new DataTable();
sda.Fill(dataTable);
dataGridDueDate.DataSource = dataTable;
DBUtil.closeSqlConnection();
}
private void btnSearchID_Click(object sender, EventArgs e)
{
if (tbID.Text != "")
{
sda = ConsumerDB.getConsumerID(tbID.Text);
dataTable = new DataTable();
sda.Fill(dataTable);
dataGridConsumerID.DataSource = dataTable;
DBUtil.closeSqlConnection();
}
else
{
dataGridConsumerID.DataSource = null;
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (tbConsumerID.Text != "" && tbFirstName.Text != "" &&
tbLastName.Text != "" && tbCity.Text != "" && tbBillAmount.Text != "")
{
Consumer consumer = new Consumer();
try
{
consumer.setConsumerID(Convert.ToInt64(tbConsumerID.Text));
consumer.FirstName = tbFirstName.Text.ToUpper();
consumer.LastName = tbLastName.Text.ToUpper();
consumer.City = tbCity.Text.ToUpper();
consumer.BillAmount = Convert.ToDouble(tbBillAmount.Text);
DateTime date = dateTimePicker1.Value.Date;
consumer.DueDate = date;
ConsumerDB.add(consumer);
DialogResult result = MessageBox.Show("Record added to database", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (result == System.Windows.Forms.DialogResult.OK)
{
clearConsumerForm();
}
}
catch (ConsumerIDException)
{
MessageBox.Show("consumer ID should be 11 digits");
}
catch (System.FormatException)
{
MessageBox.Show("Consumer ID field cannot be empty");
}
catch (System.Data.SqlClient.SqlException)
{
MessageBox.Show("Consumer ID must be unique");
}
DBUtil.closeSqlConnection();
}
else
{
MessageBox.Show("No field should be empty", "Empty Field", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
