private void ButtonBorrarFamiliar_Click(object sender, EventArgs e)
{
bool check = true;
string id = TextBoxCodigo.Text;
if (!EvaluateTextBox.EIntPositive(id, true, "id"))
{
check = false;
}
if (check)
{
SqlConnection connection = new SqlConnection(General_Values.str_connection);
connection.Open();
string str_consult = "DELETE FROM vinculo WHERE cod_miembro = " + this.Code + " AND cod_vinculo = " + id + ";";
SqlCommand consult = new SqlCommand(str_consult, connection);
consult.ExecuteNonQuery();
connection.Close();
connection.Open();
string str_consult1 = "DELETE FROM vinculo WHERE cod_miembro = " + id + " AND cod_vinculo = " + this.Code + ";";
SqlCommand consult1 = new SqlCommand(str_consult1, connection);
consult1.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Se borro Satisfactoriamnte");
RefreshPersonal();
}
}
private void ButtonAgregarAbuelo_Click(object sender, EventArgs e)
{
bool check = true;
int id = Value_id();
int vin;
string cod_vinculo = (TextBoxAbuelo.Text);
if (!EvaluateTextBox.EIntPositive(cod_vinculo, true, "Codigo Vinculo Conyuge"))
{
check = false;
}
else if (!Id.ExistsId("miembro", "codigo", cod_vinculo))
{
MessageBox.Show("No existe ID");
check = false;
}
if (check)
{
SqlConnection connection = new SqlConnection(General_Values.str_connection);
if (IsMale(int.Parse(cod_vinculo)))
{
vin = 7;
}
else
{
vin = 8;
}
connection.Open();
string str_consult2 = "INSERT INTO vinculo(id, vinculo, cod_vinculo, cod_miembro) VALUES(" +
id + ", " + vin + ", " + cod_vinculo + ", " + this.Code + ")";
SqlCommand consult2 = new SqlCommand(str_consult2, connection);
consult2.ExecuteNonQuery();
connection.Close();
id += 1;
if (IsMale(Code))
{
vin = 9;
}
else
{
vin = 10;
}
connection.Open();
string str_consult3 = "INSERT INTO vinculo(id, vinculo, cod_vinculo, cod_miembro) VALUES(" +
id + ", " + vin + ", " + this.Code + ", " + cod_vinculo + ")";
SqlCommand consult3 = new SqlCommand(str_consult3, connection);
consult3.ExecuteNonQuery();
connection.Close();
MessageBox.Show("Vinculo Agregado Satisfactoriamente");
RefreshPersonal();
}
}
private void ButtonCode_Click(object sender, EventArgs e)
{
bool check = true;
if (TextBoxCodigo.Text == "Ingrese Código")
{
MessageBox.Show("Ingrese Codigo");
check = false;
}
else if (!EvaluateTextBox.EIntPositive(TextBoxCodigo.Text, true, "Codigo"))
{
check = false;
}
else if (!Id.ExistsId("miembro", "codigo", TextBoxCodigo.Text))
{
MessageBox.Show("El Codigo ingresado No Existe");
check = false;
}
if (check)
{
MemberShow M_S = new MemberShow(int.Parse(TextBoxCodigo.Text));
M_S.ShowDialog();
}
}
private void ButtonVerComentarios_Click(object sender, EventArgs e)
{
bool check = true;
string id = TextBoxId.Text;
if (!EvaluateTextBox.EIntPositive(id, true, "ID"))
{
check = false;
}
if (check)
{
SqlConnection connection = new SqlConnection(General_Values.str_connection);
connection.Open();
string str_consult = "SELECT comentario FROM comentario WHERE id = " + id + ";";
SqlCommand consult = new SqlCommand(str_consult, connection);
SqlDataReader record = consult.ExecuteReader();
if (record.Read())
{
TextBoxVerComentario.Text = record["comentario"].ToString();
}
else
{
MessageBox.Show("ID ingresado INCORRECTO");
}
connection.Close();
}
}
private void ButtonVerDatos_Click(object sender, EventArgs e)
{
bool check = true;
string codigo = TextBoxCodigo.Text;
if (!EvaluateTextBox.EIntPositive(codigo, true, "Codigo"))
{
check = false;
}
else if (!Id.ExistsId("miembro", "codigo", codigo))
{
check = false;
}
if (check)
{
MemberShow M_S = new MemberShow(int.Parse(codigo));
M_S.ShowDialog();
}
}
private void ButtonEliminar_Click(object sender, EventArgs e)
{
bool check = true;
string id = TextBoxIdEliminar.Text;
if (!EvaluateTextBox.EIntPositive(id, true, "ID"))
{
check = false;
}
else if (!Id.ExistsId("ofrenda_misionera", "id", id))
{
check = false;
}
if (check)
{
Id.DeleteId("ofrenda_misionera", "id", int.Parse(id));
MessageBox.Show("Borrado Completo");
DataGridViewDiezmos.Rows.Clear();
}
}
private void ButtonBorrar_Click(object sender, EventArgs e)
{
bool check = true;
string id = TextBoxIdBorrar.Text;
if (!EvaluateTextBox.EIntPositive(id, true, "ID"))
{
check = false;
}
if (check)
{
if (Id.DeleteId("comentario", "id", int.Parse(id)))
{
MessageBox.Show("Borrado Exitoso");
}
else
{
MessageBox.Show("ID Ingresado INCORRECTO");
}
RefreshPersonal();
}
}
private void ButtonEliminarOfrenda_Click(object sender, EventArgs e)
{
bool check = true;
string id = TextBoxIdEliminarOfrenda.Text;
if (!EvaluateTextBox.EIntPositive(id, true, "ID"))
{
check = false;
}
if (!Id.ExistsId("ofrenda", "id", id))
{
MessageBox.Show("Id ingresado no Existe");
check = false;
}
if (check)
{
if (Id.DeleteId("ofrenda", "id", int.Parse(id)))
{
MessageBox.Show("ID eliminado correctamente");
}
}
RefreshPersonal();
}
private void ButtonAgregar_Click(object sender, EventArgs e)
{
bool check = true;
int id = Id.ValueId("ofrenda_pro_templo", "id");
string monto = TextBoxMonto.Text;
if (!EvaluateTextBox.EDecimal(monto, 10, 3, true, "Monto"))
{
check = false;
}
string mes = TextBoxMes.Text;
if (!EvaluateTextBox.EMounth(mes, true, "Mes"))
{
check = false;
}
string año = TextBoxAño.Text;
if (!EvaluateTextBox.EYear(año, true, "Año"))
{
check = false;
}
string fch_emision = "";
fch_emision += MonthCalendarEmision.SelectionStart.Year.ToString() + "-";
fch_emision += MonthCalendarEmision.SelectionStart.Month.ToString() + "-";
fch_emision += MonthCalendarEmision.SelectionStart.Day.ToString();
string cod_miembro = TextBoxCodigo.Text;
if (!EvaluateTextBox.EIntPositive(cod_miembro, true, "Codigo"))
{
check = false;
}
else if (!Id.ExistsId("miembro", "codigo", cod_miembro))
{
MessageBox.Show("Codigo no encontrado");
check = false;
}
if (check)
{
SqlConnection conexion = new SqlConnection(General_Values.str_connection);
conexion.Open();
string str_consult2 = "INSERT INTO ofrenda_pro_templo(id, monto, mes, año, fch_emision, cod_miembro) VALUES (" +
+id + ", " + monto + ", '" + mes + "', '" + año + "', '" + fch_emision + "', " + cod_miembro + ");";
SqlCommand consulta2 = new SqlCommand(str_consult2, conexion);
consulta2.ExecuteNonQuery();
MessageBox.Show("Los datos se guardaron correctamente");
conexion.Close();
this.Close();
}
}