public int mtdRegPer(EClPersonal objeperso)
{
string inser = "Insert Into Personal (Documento, Nombre, Apellido, Telefono, Email, Direccion, GrupoSanguineo, IdARP) Values ('" + objeperso.Documento + "','" + objeperso.Nombre + "','" + objeperso.Apellido + "','" + objeperso.Telefono + "','" + objeperso.Email + "','" + objeperso.Direccion + "','" + objeperso.GrupoSanguineo + "','" + objeperso.IdARP + "')";
conexion = conex.mtdconexion();
cmdregper = new SqlCommand(inser, conexion);
conexion.Open();
int reg = cmdregper.ExecuteNonQuery();
conexion.Close();
return(reg);
}
public object mtdlistar(string docum = "", string nombre = "", string apelli = "", string tel = "", string email = "", string direccion = "", string grup = "")
{
string consul = "";
if (docum != "")
{
consul = "Select * From Personal Where Documento = '" + docum + "'";
}
else if (nombre != "")
{
consul = "Select * From Personal Where Nombre = '" + nombre + "'";
}
else if (apelli != "")
{
consul = "Select * From Personal Where Apellido = '" + apelli + "'";
}
else if (tel != "")
{
consul = "Select * From Personal Where Telefono = '" + tel + "' ";
}
else if (email != "")
{
consul = "Select * From Personal Where Email = '" + email + "' ";
}
else if (direccion != "")
{
consul = "Select * From Personal Where Direccion = '" + direccion + "' ";
}
else if (grup != "")
{
consul = "Select * From Personal Where GrupoSanguineo = '" + grup + "' ";
}
else
{
consul = "Select * From Personal";
}
DataTable tblPer = new DataTable();
conexion = conex.mtdconexion();
adapper = new SqlDataAdapter(consul, conexion);
conexion.Open();
adapper.Fill(tblPer);
conexion.Close();
List <EClPersonal> list = new List <EClPersonal>();
foreach (DataRow fil in tblPer.Rows)
{
EClPersonal objeperosona = new EClPersonal();
//objeperosona.IdPersonal = int.Parse(fil["IdPersonal"].ToString());
objeperosona.Documento = fil["Documento"].ToString();
objeperosona.Nombre = fil["Nombre"].ToString();
objeperosona.Apellido = fil["Apellido"].ToString();
objeperosona.Telefono = fil["Telefono"].ToString();
objeperosona.Email = fil["Email"].ToString();
objeperosona.Direccion = fil["Direccion"].ToString();
objeperosona.GrupoSanguineo = fil["GrupoSanguineo"].ToString();
objeperosona.IdARP = int.Parse(fil["IdARP"].ToString());
list.Add(objeperosona);
}
return(list);
}
public object mtddatos(EClPersonal objEPersonal)
{
return(objDPersonal.mtdRegPer(objEPersonal));
}
