private void CargarCombos()
{
SubSonic.Select ef = new SubSonic.Select();
ef.From(SysEfector.Schema);
//ef.Where(SysEfector.Columns.IdZona).IsEqualTo(9);
ef.OrderAsc("nombre");
ddlEfector.DataSource = ef.ExecuteTypedList <SysEfector>();
ddlEfector.DataBind();
ddlEfector.Items.Insert(0, new ListItem("TODOS", "0"));
SubSonic.Select e = new SubSonic.Select();
e.From(SysEstado.Schema);
List <SysEstado> estados = e.ExecuteTypedList <SysEstado>();
ddlEstado.DataSource = estados;
ddlEstado.DataBind();
ddlEstado.Items.Insert(0, new ListItem("TODOS", "0"));
SubSonic.Select s = new SubSonic.Select();
s.From(SysSexo.Schema);
List <SysSexo> sexos = s.ExecuteTypedList <SysSexo>();
ddlSexo.DataSource = sexos;
ddlSexo.DataBind();
ddlSexo.Items.Insert(0, new ListItem("TODOS", "0"));
}
private void cargaEntidades()
{
SubSonic.Select b = new SubSonic.Select();
b.From(RisEntidad.Schema);
var listaEstudios = b.ExecuteTypedList <RisEntidad>();
gdvEntidades.DataSource = listaEstudios;
gdvEntidades.DataBind();
}
private void cargaComiteEtica()
{
SubSonic.Select b = new SubSonic.Select();
b.From(RisComiteEtica.Schema);
var listaComiteEtica = b.ExecuteTypedList <RisComiteEtica>();
gdvComiteEtica.DataSource = listaComiteEtica;
gdvComiteEtica.DataBind();
}
private void cargaAreasTematicas()
{
SubSonic.Select b = new SubSonic.Select();
b.From(RisAreaTematica.Schema);
var listaAreasTematicas = b.ExecuteTypedList <RisAreaTematica>();
gdvAreaTematica.DataSource = listaAreasTematicas;
gdvAreaTematica.DataBind();
}
private void cargaProfesion()
{
SubSonic.Select b = new SubSonic.Select();
b.From(RisProfesion.Schema);
var listaProfesion = b.ExecuteTypedList <RisProfesion>();
gdvProfesion.DataSource = listaProfesion;
gdvProfesion.DataBind();
}
public static List<AplicationRole> GetRolesListByUser(int IdUser)
{
SubSonic.SqlQuery currentSelect = new SubSonic.Select()
.From(AplicationRole.Schema)
.InnerJoin(UserByRole.IdAplicationRoleColumn, AplicationRole.IdAplicationRoleColumn)
.Where(UserByRole.IdUserColumn).IsEqualTo(IdUser)
.OrderAsc(AplicationRole.Columns.Description);
return currentSelect.ExecuteTypedList<AplicationRole>();
}
public static List<Area> GetAreasListByUser(int IdUser)
{
SubSonic.SqlQuery currentSelect = new SubSonic.Select()
.From(Area.Schema)
.InnerJoin(UserByArea.IdAreaColumn, Area.IdAreaColumn)
.Where(UserByArea.IdUserColumn).IsEqualTo(IdUser)
.OrderAsc(Area.Columns.Description);
return currentSelect.ExecuteTypedList<Area>();
}
private void CargarPaciente(SysPaciente pac)
{
lblDoc.Text = pac.NumeroDocumento.ToString();
lblApellido.Text = pac.Apellido;
lblNombres.Text = pac.Nombre;
lblFNac.Text = pac.FechaNacimiento.ToShortDateString();
lblSexo.Text = pac.SysSexo.Nombre;
lblContacto.Text = pac.InformacionContacto.ToString();
SubSonic.Select q = new SubSonic.Select();
q.From(SysRelHistoriaClinicaEfector.Schema);
q.Where(SysRelHistoriaClinicaEfector.Columns.IdPaciente).IsEqualTo(pac.IdPaciente);
q.And(SysRelHistoriaClinicaEfector.Columns.IdEfector).IsEqualTo(SSOHelper.CurrentIdentity.IdEfector);
List <SysRelHistoriaClinicaEfector> lista = q.ExecuteTypedList <SysRelHistoriaClinicaEfector>();
if (lista.Count > 0)
{
lblFecha.Text = lista[0].FechaRegistro.ToShortDateString();
lbltHC.Text = lista[0].HistoriaClinica.ToString();
}
}
