public List <EArl> mtdbuscaridarl(int id)
{
List <EArl> listaid = new List <EArl>();
string consulta = "Select ARL From ARL where IdArl =" + id + "";
conexion.Open();
adapt = new SqlDataAdapter(consulta, conexion);
tblarl = new DataTable();
adaparl.Fill(tblarl);
conexion.Close();
foreach (DataRow fila in tblarl.Rows)
{
EArl arl = new EArl();
arl.ARL = fila["ARL"].ToString();
listaid.Add(arl);
}
return(listaid);
}
public object mtdlistararl(string Arl = "")
{
string sql = "";
if (Arl != "")
{
sql = "Select * From ARL Where ARL = '" + Arl + "'";
}
else
{
sql = "Select * From ARL";
}
DataTable tblarp = new DataTable();
conexion.Open();
adaparl = new SqlDataAdapter(sql, conexion);
adaparl.Fill(tblarp);
conexion.Close();
List <EArl> lista = new List <EArl>();
foreach (DataRow fila in tblarp.Rows)
{
EArl objarl = new EArl();
objarl.IdArl = int.Parse(fila["IdArl"].ToString());
objarl.ARL = fila["ARL"].ToString();
lista.Add(objarl);
}
return(lista);
}
public int mtdRegistArl(EArl objEArl)
{
string consulta = "Insert Into ARL (ARL) Values ('" + objEArl.ARL + "')";
conexion.Open();
comandoRegistro = new SqlCommand(consulta, conexion);
int reg = comandoRegistro.ExecuteNonQuery();
conexion.Close();
return(reg);
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Trim() == "")
{
MessageBox.Show("Faltan algunos campos por completar", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
EArl ARL = new EArl();
ARL.ARL = textBox1.Text;
larl.mttdatos(ARL);
MessageBox.Show("ARL registrada correctamente");
textBox1.Clear();
}
}
private void btnmodi_Click(object sender, EventArgs e)
{
if (txtarl.Text.Trim() == "")
{
MessageBox.Show("Faltan algunos campos por completar", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
if (MessageBox.Show("Esta a punto de cambiar un registro, desea continuar?", "◄ ALERTA | ShieldTech Team ►", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
ClArl arl = new ClArl();
EArl eu = new EArl();
int Id = 0;
Id = int.Parse(txtid.Text);
eu.ARL = txtarl.Text;
string sql = "Update ARL set ARL='" + eu.ARL + "' Where IdArl='" + Id + "'";
arl.mtdUpdateARL(sql);
MessageBox.Show("Registro guardado exitosamente!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public object mttdatos(EArl objEARL)
{
return(clarl.mtdRegistArl(objEARL));
}
