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)); }