private void metroButton2_Click(object sender, EventArgs e)
{
DBCustomer c = new DBCustomer();
cusno = c.getCusNo(cmbcusnic.SelectedItem.ToString());
DBSales s = new DBSales();
DR = s.getSalesOrder(cusno);
while (DR.Read())
{
cmbsorder.Items.Add(Convert.ToInt32(DR[0]));
}
}
private void btnok_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0 || comboBox1.Text.Length != 10)
{
MessageBox.Show("Please select a NIC", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
DBCustomer cus = new DBCustomer();
nic = comboBox1.SelectedItem.ToString();
no = cus.getCusNo(nic);
Sales_Orders s = new Sales_Orders();
s.Show();
s.setid(u_id, no);
this.Hide();
}
}
private void mtUpdate_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Do you want to update?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr.ToString() == "Yes")
{
if (String.IsNullOrEmpty(txtname.Text) || String.IsNullOrEmpty(txtadd.Text) || String.IsNullOrEmpty(txtnic.Text) || txttele.Text.Length != 10)
{
MessageBox.Show("Check if all the fields are filled", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
String name = txtname.Text;
String add = txtadd.Text;
String nic = txtnic.Text;
DBCustomer di = new DBCustomer();
int tele = Convert.ToInt32(txttele.Text);
int no = di.getCusNo(nic);
int line = di.updateCustomer(name, add, nic, tele, u_id, no);
if (line == 1)
{
MessageBox.Show("Data entered successfully", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception)
{
MessageBox.Show("Error,please try again", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
UpdateCustomer upd = new UpdateCustomer();
this.Hide();
upd.Show();
upd.setid(u_id);
}