private void searchMemberButton_Click(object sender, EventArgs e)
{
Membros.MembroSearch search = new Membros.MembroSearch(igrejaComboBox.Text);
search.ShowDialog();
int code = search.MemberCode;
if (code != 0)
{
loginInfo info = new loginInfo();
SqlDataReader usrRdr = null;
SqlConnection conn = new SqlConnection(info.GetStringConnection());
conn.Open();
SqlCommand comm1 = new SqlCommand("select * from Membros where Codigo=@codigo", conn);
comm1.Parameters.Add("@codigo", SqlDbType.VarChar).Value = code;
usrRdr = comm1.ExecuteReader();
if (usrRdr.HasRows)
{
while (usrRdr.Read())
{
int codigo = usrRdr.GetInt32(0);
codTextBox.Text = Convert.ToString(codigo);
respTextBox.Text = (string)usrRdr.GetString(1);
foneTextBox.Text = (string)usrRdr.GetString(13);
emailTextBox.Text = (string)usrRdr.GetString(21);
}
}
}
}
private void RedeWindowSearchMember_Click(object sender, EventArgs e)
{
if (celulaComboBox.SelectedValue != null)
{
GerenciamentoCelulas.Forms.Membros.MembroSearch search = new Membros.MembroSearch(igrejaComboBox.Text);
search.ShowDialog();
int newMember = search.MemberCode;
if (newMember != 0)
{
System.Windows.Forms.BindingSource membros;
Igrejafont10DataSetTableAdapters.Membros1TableAdapter membrosTableAdapter1;
membros = new System.Windows.Forms.BindingSource(this.components);
((System.ComponentModel.ISupportInitialize)(membros)).BeginInit();
membros.DataMember = "Membros1";
membros.DataSource = this.igrejafont10DataSet;
((System.ComponentModel.ISupportInitialize)(membros)).EndInit();
membrosTableAdapter1 = new GerenciamentoCelulas.Igrejafont10DataSetTableAdapters.Membros1TableAdapter();
membrosTableAdapter1.ClearBeforeFill = true;
membrosTableAdapter1.Fill(igrejafont10DataSet.Membros1);
membros.Position = membros.Find("Codigo", newMember.ToString());
DataRowView row = (DataRowView)membros.Current;
row["Celula"] = celulaComboBox.SelectedValue.ToString();
membros.EndEdit();
membrosTableAdapter1.Update(igrejafont10DataSet.Membros1);
membrosTableAdapter.FillBy(igrejafont10DataSet.Membros);
FiltraMembros();
}
}
else
{
MessageBox.Show("Por favor, selecione uma célula!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
