public TecnologiaLicenciadaRepository()
{
dbGI = new GI_Context();
dbGI.Database.Log = Escribe.Write;
dbPI = new PI_Context();
dbGEN = new GEN_Context();
}
public async Task <List <int?> > GetDerechosAutorByCollate(string likeNombre)
{
try
{
PI_Context picontext = new PI_Context();
var palabras = likeNombre.Split(' ');
var query = "SELECT DerechosAutorId FROM PI.tab_DerechosAutor where Titulo collate Latin1_General_CI_AI LIKE '%";
foreach (var palabra in palabras)
{
query += palabra + "%' and Titulo collate Latin1_General_CI_AI LIKE '%";
}
var subconsulta = query.Substring(0, query.Length - 47);
var resultados = await picontext.Database.SqlQuery <int?>(subconsulta).ToListAsync();
return(resultados);
}
catch (Exception e)
{
throw new Exception(e.Message, e);
}
}
public TipoPIRepository()
{
_ctx = new PI_Context();
}
public DerechosAutorRepository()
{
_pictx = new PI_Context();
}
public AutoresExtPIPatrimonioRepository()
{
_ctx = new PI_Context();
}
public RequisicionesPIRepository()
{
_ctx = new PI_Context();
}
public AutoresIndustrialExtRepository()
{
_ctx = new PI_Context();
}
public TipoPropiedadIndustrialRepository()
{
_db = new PI_Context();
}
public RamaRepository()
{
_db = new PI_Context();
}
public AutoresIntDARepository()
{
_ctx = new PI_Context();
}
public EstadoDelProcesoRepository()
{
_db = new PI_Context();
}
public RamaDARepository()
{
_ctx = new PI_Context();
}
public PropiedadIndustrialRepository()
{
_pictx = new PI_Context();
}
public SolicitudesDARepository()
{
_ctx = new PI_Context();
}
public indicadoresPIRepository()
{
_pictx = new PI_Context();
}
public PIExternoRepository()
{
_ctx = new PI_Context();
}
public HistorialPIRepository()
{
_pictx = new PI_Context();
}
