private void Delete_Click(object sender, EventArgs e)
{
if (identifier.Text == "")
{
MessageBox.Show("The ID field is empty.");
return;
}
int result = contobj.DeleteContactbyID(Convert.ToInt32(identifier.Text));
if (result == 1)
{
MessageBox.Show("Contact deleted successfully.");
}
else
{
MessageBox.Show("This ID has not been found in the contacts list.");
}
Contactsgrid.DataSource = contobj.GetAllContacts();
Contactsgrid.Columns[0].HeaderText = "ID";
Contactsgrid.Columns[1].HeaderText = "First Name";
Contactsgrid.Columns[2].HeaderText = "Last Name";
Contactsgrid.Columns[3].HeaderText = "Phone Number";
Contactsgrid.Columns[4].HeaderText = "Email";
Contactsgrid.Columns[5].HeaderText = "Address";
Contactsgrid.Columns[6].HeaderText = "Status";
Contactsgrid.Refresh();
}
private void Get_Click(object sender, EventArgs e)
{
Contactsgrid.DataSource = contobj.GetContactByID(Convert.ToInt32(identifier.Text));
Contactsgrid.Columns[0].HeaderText = "ID";
Contactsgrid.Columns[1].HeaderText = "First Name";
Contactsgrid.Columns[2].HeaderText = "Last Name";
Contactsgrid.Columns[3].HeaderText = "Phone Number";
Contactsgrid.Columns[4].HeaderText = "Email";
Contactsgrid.Columns[5].HeaderText = "Address";
Contactsgrid.Columns[6].HeaderText = "Status";
Contactsgrid.Refresh();
}
private void Add_Click(object sender, EventArgs e)
{
string Fname, Lname;
Fname = FirstName.Text;
Lname = LastName.Text;
if (Fname == "" || Lname == "" || PhoneNumber.Text == "" || Email.Text == "" || Address.Text == "")
{
MessageBox.Show("Please enter all fields");
return;
}
if (Fname.Any(char.IsDigit))
{
MessageBox.Show("First name can't contain any digits.");
return;
}
if (Lname.Any(char.IsDigit))
{
MessageBox.Show("Last name can't contain any digits.");
return;
}
int result;
if (!(Int32.TryParse(PhoneNumber.Text, out result)))
{
MessageBox.Show("Phone Number must contain only digits.");
return;
}
int queryresult = contobj.AddContact(FirstName.Text, LastName.Text, Convert.ToInt32(PhoneNumber.Text), Email.Text, Address.Text, Status.Text);
if (queryresult == 1)
{
MessageBox.Show("Contact Added.");
}
else
{
MessageBox.Show("Contact Not Added.");
}
Contactsgrid.DataSource = contobj.GetAllContacts();
Contactsgrid.Columns[0].HeaderText = "ID";
Contactsgrid.Columns[1].HeaderText = "First Name";
Contactsgrid.Columns[2].HeaderText = "Last Name";
Contactsgrid.Columns[3].HeaderText = "Phone Number";
Contactsgrid.Columns[4].HeaderText = "Email";
Contactsgrid.Columns[5].HeaderText = "Address";
Contactsgrid.Columns[6].HeaderText = "Status";
Contactsgrid.Refresh();
}
private void button3_Click(object sender, EventArgs e)
{
//shows all the contacts
Contactsgrid.DataSource = contobj.GetAllContacts();
Contactsgrid.Columns[0].HeaderText = "ID";
Contactsgrid.Columns[1].HeaderText = "First Name";
Contactsgrid.Columns[2].HeaderText = "Last Name";
Contactsgrid.Columns[3].HeaderText = "Phone Number";
Contactsgrid.Columns[4].HeaderText = "Email";
Contactsgrid.Columns[5].HeaderText = "Address";
Contactsgrid.Columns[6].HeaderText = "Status";
Contactsgrid.Refresh();
}
