//submit button tab1 click
private void buttonSubmitApplication_Click(object sender, EventArgs e)
{
bool containsLetter = false; //phone no validating
string phoneNumber = textBoxContact.Text.Trim();
if (phoneNumber.Length < 10)
containsLetter = true;
else
{
for (int i = 0; i < phoneNumber.Length; i++)
{
if (!char.IsNumber(phoneNumber[i]))
{
containsLetter = true;
}
}
}
if (containsLetter)
{
MessageBox.Show("Please enter all the data before submission and make sure contact no and NIC no is valid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
bool nicwrong = false; //nic validating
string nic = textBoxNIC.Text;
if (nic.Length < 10)
nicwrong = true;
else
{
for (int i = 0; i < 9; i++)
{
if (!char.IsNumber(nic[i]))
{
nicwrong = true;
}
}
if (nic[9] != 'V' && nic[9] != 'v')
nicwrong = true;
}
if (nicwrong)
{
MessageBox.Show("Please enter all the data before submission and make sure NIC no is in correct format", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (valid()) //validating of required fields filled
{
ApplicationRow approw;
int refno;
if (dbmap.hasEntry("reference"))
{
refno = int.Parse(dbmap.get("no", "reference"));//get a reference no from database 'mapno'
int upref = refno + 1;
dbmap.update("no", "reference", upref.ToString());
}
else
{
dbmap.insert(new MapnoRow("reference",10001));
refno = 10000;
}
if (comboCategory.SelectedIndex == 0) //add data to database 'applicaton' if domestoc category
{
ApplicationForm app = new ApplicationForm(comboTitle.SelectedItem.ToString(), textBoxName.Text, textBoxNIC.Text,
comboCategory.SelectedItem.ToString(), textBoxAddressConnection.Text, textBoxGramaNiladhari.Text, textBoxDivisionalSec.Text,
textBoxDistrict.Text, textBoxAddressMail.Text, textBoxEmail.Text, int.Parse(textBoxContact.Text),
comboBoxApplicantType.SelectedItem.ToString(), checkBoxDocsSubmitted.Checked, checkBoxPreviousConnection.Checked, textBoxPreviousAccountNo.Text,
comboBoxPreviousCategory.SelectedItem.ToString(), refno);//reference 0*************dn
approw = new ApplicationRow(app.title, app.name, app.nic, app.category, app.address,
app.gramaDivision, app.divisionalSecretariat, app.district, app.mail, app.email, app.contact,
app.applicantType, app.submittedDocs, app.preaccountNo, app.preCategory, app.refno, null, null, 0, 0);
dbapp.insert(approw);
}
else //add data to database 'applicaton' if business category
{
BusinessApplicationForm app1 = new BusinessApplicationForm(comboTitle.SelectedItem.ToString(), textBoxName.Text, textBoxNIC.Text,
comboCategory.SelectedItem.ToString(), textBoxAddressConnection.Text, textBoxGramaNiladhari.Text, textBoxDivisionalSec.Text,
textBoxDistrict.Text, textBoxAddressMail.Text, textBoxEmail.Text, int.Parse(textBoxContact.Text),
comboBoxApplicantType.SelectedItem.ToString(), checkBoxDocsSubmitted.Checked, checkBoxPreviousConnection.Checked, textBoxPreviousAccountNo.Text,
comboBoxPreviousCategory.SelectedItem.ToString(), textBox1Company.Text, textBoxPost.Text, refno);//reference 0****dn
approw = new ApplicationRow(app1.title, app1.name, app1.nic, app1.category, app1.address,
app1.gramaDivision, app1.divisionalSecretariat, app1.district, app1.mail, app1.email, app1.contact,
app1.applicantType, app1.submittedDocs, app1.preaccountNo, app1.preCategory, app1.refno,
app1.company, app1.post, 0, 0);
dbapp.insert(approw);
}
//show the reference no via message box
MessageBox.Show("Your Connection Reference No is: " + refno, "Reference Number", MessageBoxButtons.OK);
button2Click(); //clear all fields
}
else //show an error message if not completed the application
MessageBox.Show("Please enter all the required data before submission", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
private void buttonSubmitApplication_Click(object sender, EventArgs e) //submit button tab1 click
{
bool containsLetter = false; //phone no validating
string phoneNumber = textBoxContact.Text.Trim();
if (phoneNumber.Length < 10)
{
containsLetter = true;
}
else
{
for (int i = 0; i < phoneNumber.Length; i++)
{
if (!char.IsNumber(phoneNumber[i]))
{
containsLetter = true;
}
}
}
if (containsLetter)
{
MessageBox.Show("Please enter all the data before submission and make sure contact no and NIC no is valid", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
bool nicwrong = false; //nic validating
string nic = textBoxNIC.Text;
if (nic.Length < 10)
{
nicwrong = true;
}
else
{
for (int i = 0; i < 9; i++)
{
if (!char.IsNumber(nic[i]))
{
nicwrong = true;
}
}
if (nic[9] != 'V' && nic[9] != 'v')
{
nicwrong = true;
}
}
if (nicwrong)
{
MessageBox.Show("Please enter all the data before submission and make sure NIC no is in correct format", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (valid()) //validating of required fields filled
{
ApplicationRow approw;
int refno;
if (dbmap.hasEntry("reference"))
{
refno = int.Parse(dbmap.get("no", "reference"));//get a reference no from database 'mapno'
int upref = refno + 1;
dbmap.update("no", "reference", upref.ToString());
}
else
{
dbmap.insert(new MapnoRow("reference", 10001));
refno = 10000;
}
if (comboCategory.SelectedIndex == 0) //add data to database 'applicaton' if domestoc category
{
ApplicationForm app = new ApplicationForm(comboTitle.SelectedItem.ToString(), textBoxName.Text, textBoxNIC.Text,
comboCategory.SelectedItem.ToString(), textBoxAddressConnection.Text, textBoxGramaNiladhari.Text, textBoxDivisionalSec.Text,
textBoxDistrict.Text, textBoxAddressMail.Text, textBoxEmail.Text, int.Parse(textBoxContact.Text),
comboBoxApplicantType.SelectedItem.ToString(), checkBoxDocsSubmitted.Checked, checkBoxPreviousConnection.Checked, textBoxPreviousAccountNo.Text,
comboBoxPreviousCategory.SelectedItem.ToString(), refno);//reference 0*************dn
approw = new ApplicationRow(app.title, app.name, app.nic, app.category, app.address,
app.gramaDivision, app.divisionalSecretariat, app.district, app.mail, app.email, app.contact,
app.applicantType, app.submittedDocs, app.preaccountNo, app.preCategory, app.refno, null, null, 0, 0);
dbapp.insert(approw);
}
else //add data to database 'applicaton' if business category
{
BusinessApplicationForm app1 = new BusinessApplicationForm(comboTitle.SelectedItem.ToString(), textBoxName.Text, textBoxNIC.Text,
comboCategory.SelectedItem.ToString(), textBoxAddressConnection.Text, textBoxGramaNiladhari.Text, textBoxDivisionalSec.Text,
textBoxDistrict.Text, textBoxAddressMail.Text, textBoxEmail.Text, int.Parse(textBoxContact.Text),
comboBoxApplicantType.SelectedItem.ToString(), checkBoxDocsSubmitted.Checked, checkBoxPreviousConnection.Checked, textBoxPreviousAccountNo.Text,
comboBoxPreviousCategory.SelectedItem.ToString(), textBox1Company.Text, textBoxPost.Text, refno);//reference 0****dn
approw = new ApplicationRow(app1.title, app1.name, app1.nic, app1.category, app1.address,
app1.gramaDivision, app1.divisionalSecretariat, app1.district, app1.mail, app1.email, app1.contact,
app1.applicantType, app1.submittedDocs, app1.preaccountNo, app1.preCategory, app1.refno,
app1.company, app1.post, 0, 0);
dbapp.insert(approw);
}
//show the reference no via message box
MessageBox.Show("Your Connection Reference No is: " + refno, "Reference Number", MessageBoxButtons.OK);
button2Click(); //clear all fields
}
else //show an error message if not completed the application
{
MessageBox.Show("Please enter all the required data before submission", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}