using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public class Persona
{
private static SqlConnection con = new SqlConnection("Data Source=DIEGO-PC\\SQLEXPRESS;Initial Catalog=BDPRUEBA;Integrated Security=True");
private int idPerson;
public int IdPerson
{
get {return idPerson;}
set {idPerson = value;}
}
private int cI;
public int CI
{
get {return cI;}
set {cI = value;}
}
private string pat;
public string Pat
{
get {return pat;}
set {pat = value;}
}
private string mat;
public string Mat
{
get {return mat;}
set {mat = value;}
}
private string nom;
public string Nom
{
get {return nom;}
set {nom = value;}
}
private string email;
public string Email
{
get {return email;}
set {email = value;}
}
private DateTime fechanac;
public DateTime Fechanac
{
get {return fechanac;}
set {fechanac = value;}
}
public static Persona GetPersona(int idPersona)
{
try
{
Persona objPersona = null;
con.Open();
DataTable dt = new DataTable();
string Query = "Select * from persona where id_persona = " + idPersona;
SqlCommand cmd = new SqlCommand(Query, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);
SqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
objPersona = new Persona();
objPersona.IdPerson = Convert.ToInt32(dt.Rows[0]["id_persona"]);
objPersona.CI = Convert.ToInt32(dt.Rows[0]["ci_persona"]);
objPersona.Pat = Convert.ToString(dt.Rows[0]["paterno"]);
objPersona.Mat = Convert.ToString(dt.Rows[0]["materno"]);
objPersona.Nom = Convert.ToString(dt.Rows[0]["nombre"]);
objPersona.Email = Convert.ToString(dt.Rows[0]["email"]);
objPersona.Fechanac = Convert.ToDateTime(dt.Rows[0]["fecha_nacimiento"]);
}
return objPersona;
}
catch
{
return null;
}
}
public static List<Login> GetListLogin(int idPersona)
{
try
{
List<Login> listlogin = null;
con.Open();
DataTable dt = new DataTable();
string Query = "Select p.nombre, p.paterno, p.materno,p.ci_persona, l.id_persona, l.id_rol, l.fechareg, l.usuario, l.password from login l inner join persona p on l.id_persona = p.id_persona and p.id_persona =" + idPersona;
SqlCommand cmd = new SqlCommand(Query, con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter SqlDa = new SqlDataAdapter(cmd);
SqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
listlogin = new List<Login>();
foreach (DataRow item in dt.Rows)
{
Login objLogin = new Login();
//objLogin.IdLogin = Convert.ToInt32(item["id_login"]);
objLogin.Nom = Convert.ToString(item["nombre"]);
objLogin.Pat = Convert.ToString(item["paterno"]);
objLogin.Mat = Convert.ToString(item["materno"]);
objLogin.CI = Convert.ToInt32(item["ci_persona"]);
objLogin.IdPersona = Convert.ToInt32(item["id_persona"]);
objLogin.IdRol = Convert.ToInt32(item["id_rol"]);
objLogin.FechaReg = Convert.ToDateTime(item["fechareg"]);
objLogin.Usuario = Convert.ToString(item["usuario"]);
objLogin.Pasword = Convert.ToString(item["password"]);
listlogin.Add(objLogin);
}
}
return listlogin;
}
catch
{
return null;
}
}
}
}
No hay comentarios.:
Publicar un comentario