public bool Register(User_Model usr, int fk)
{
try
{
System.Data.DataRow c = conn.EjecutarConsulta("select id_Persona as t from Persona where Identificacion=" + fk).Rows[0];
conn.EjecutarOperacion("call insert_Usuario('" + usr.Email + "','" + usr.Password + "'," + int.Parse(c["t"].ToString()) + ")");
return(true);
}
catch (Exception e)
{
return(false);
}
}
public bool CrearPersona(People_Model pm)
{
try
{
System.Data.DataRow dd = conn.EjecutarConsulta("SELECT id_Genero as t FROM Genero WHERE Tipo='" + pm.Genero + "';").Rows[0];
int fk_genero = int.Parse(dd["t"].ToString());
conn.EjecutarOperacion("CALL insert_Persona('" + pm.Fecha_Nacimiento + "'," + pm.Identificacion + ",'" + pm.Nombre1 + "','" + pm.Nombre2 + "','" + pm.Apellido1 + "','" + pm.Apellido2 + "'," + pm.Telefono + "," + fk_genero + ")");
return(conn.EjecutarOperacion("CALL insert_Usuario('" + pm.Email + "','" + pm.Password + "'," + fk_genero + ");"));
}
catch (Exception)
{
return(false);
}
}
public System.Data.DataTable getVistas()
{
return(con.EjecutarConsulta("SELECT * FROM Vistas"));
}
public System.Data.DataTable GetMenu(int rol)
{
return(con.EjecutarConsulta("SELECT DISTINCT v.Url AS 'Url_Vista', v.Titulo AS 'Titulo_Vista', v.Fabicon AS 'Fabicon', sv.Url AS 'Url_SubVista', sv.Titulo AS 'Titulo_SubVista' FROM Rol AS r INNER JOIN Vistas_Roles AS vr ON vr.fk_Rol = r.id_Rol INNER JOIN Sub_Vistas AS sv ON vr.fk_SubVista = sv.id_SubVista INNER JOIN Vistas AS v ON sv.fk_Vista = v.id_Vista WHERE r.id_Rol = " + rol + "; "));
}
public string[] getParameter()
{
System.Data.DataTable temp = con.EjecutarConsulta("SELECT Icono, Nombre FROM Empresa WHERE id_Empresa=1");
string[] ret = { temp.Rows[0].ToString(), temp.Rows[1].ToString() };
return(ret);
}
