public void PostPersonaxRol([FromBody] PersonaxRol persona)
{
System.Data.SqlClient.SqlConnection conn;
SqlCommand command;
conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True");
conn.Open();
SqlParameter IdCedula = new SqlParameter("@IdCedula", System.Data.SqlDbType.Int);
IdCedula.Value = persona.IdCedula;
SqlParameter IdRol = new SqlParameter("@IdRol", System.Data.SqlDbType.Int);
IdRol.Value = persona.IdRol;
command = new SqlCommand("insert into PersonaxRol(IdCedula, IdRol) VALUES (@IdCedula,@IdRol)", conn);
command.Parameters.Add(IdCedula);
command.Parameters.Add(IdRol);
command.ExecuteNonQuery();
conn.Close();
}
public List <PersonaxRol> GetAllPersonasxRol()
{
System.Data.SqlClient.SqlConnection conn;
SqlCommand command;
SqlDataReader read;
conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True");
conn.Open();
command = new SqlCommand("SELECT * from PersonaxRol", conn);
read = command.ExecuteReader();
List <PersonaxRol> ListPersonas = new List <PersonaxRol>();
while (read.Read())
{
PersonaxRol persona = new PersonaxRol();
persona.IdCedula = Convert.ToInt32(read["IdCedula"]);
persona.IdRol = Convert.ToInt32(read["IdRol"]);
persona.LogicDelete = Convert.ToBoolean(read["LogicDelete"]);
ListPersonas.Add(persona);
}
read.Close();
conn.Close();
return(ListPersonas);
}
public void UpdatePersonaxRol([FromBody] PersonaxRol rol)
{
System.Data.SqlClient.SqlConnection conn;
SqlCommand command;
conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True");
conn.Open();
String comm = "Update PersonaxRol SET IdRol=" + rol.IdRol + " WHERE IdCedula=" + rol.IdCedula;
command = new SqlCommand(comm, conn);
command.ExecuteNonQuery();
conn.Close();
}
public PersonaxRol GetPersonaxRol(int id)
{
System.Data.SqlClient.SqlConnection conn;
SqlCommand command;
SqlDataReader read;
conn = new SqlConnection("Data Source=(local);Initial Catalog=Proyecto1;Integrated Security=True");
conn.Open();
command = new SqlCommand("SELECT * from PersonaxRol where LogicDelete = 0 and IdCedula=" + id.ToString(), conn);
read = command.ExecuteReader();
PersonaxRol persona = new PersonaxRol();
while (read.Read())
{
persona.IdCedula = Convert.ToInt32(read["IdCedula"]);
persona.IdRol = Convert.ToInt32(read["IdRol"]);
persona.LogicDelete = Convert.ToBoolean(read["LogicDelete"]);
}
read.Close();
conn.Close();
return(persona);
}
public void UpdatePersonaxRol([FromBody] PersonaxRol pxr)
{
PersonaxRolService con = new PersonaxRolService();
con.UpdatePersonaxRol(pxr);
}
public void PostPersona([FromBody] PersonaxRol persona)
{
PersonaxRolService con = new PersonaxRolService();
con.PostPersonaxRol(persona);
}
