private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
SingleContact sc = new SingleContact();
sc.Show();
this.Hide();
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null)
{
cid = al[e.RowIndex].ToString();
SingleContact sc = new SingleContact();
sc.Show();
this.Hide();
}
}
private void button3_Click(object sender, EventArgs e)
{
string ci = Contacts.cid;
string isEmer = "";
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Deepang\source\repos\OOSE Project\OOSE Project\DTC.mdf; Integrated Security = True";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT EmergencyContact FROM CONTACTS WHERE Id = @cid1";
cmd.Parameters.AddWithValue("@cid1", ci);
cmd.Connection = con;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
isEmer = rdr["EmergencyContact"].ToString();
}
rdr.Close();
con.Close();
cmd.CommandText = "UPDATE CONTACTS SET EmergencyContact = @emer WHERE Id = @cid";
cmd.Parameters.AddWithValue("@cid", ci);
if (isEmer.Equals("No "))
{
cmd.Parameters.AddWithValue("@emer", "Yes");
}
if (isEmer.Equals("Yes "))
{
cmd.Parameters.AddWithValue("@emer", "No");
}
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
SingleContact sc = new SingleContact();
sc.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
string field = listBox1.SelectedItem.ToString();
string ci = Contacts.cid;
string n = textBox1.Text;
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Deepang\source\repos\OOSE Project\OOSE Project\DTC.mdf; Integrated Security = True";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE CONTACTS SET " + field + " = @new WHERE Id = @cid";
cmd.Parameters.AddWithValue("@cid", ci);
cmd.Parameters.AddWithValue("@new", n);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
SingleContact sc = new SingleContact();
sc.Show();
this.Hide();
}