//public async Task<List<DocumentoPagi>> ObtenerPaginas(string arcCod)
public List <DocumentoPagi> ObtenerPaginas(string arcCod)
{
List <DocumentoPagi> data = new List <DocumentoPagi>();
try
{
using (HValles_AfsDataContext db = new HValles_AfsDataContext())
{
db.Database.OpenConnection();
DbCommand cmd = db.Database.GetDbConnection().CreateCommand();
cmd.CommandText = "API.getDocumentosPaginas";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter("@ARC_COD", arcCod));
using (var reader = cmd.ExecuteReader())
{
data = reader.MapToList <DocumentoPagi>();
}
}
return(data);
}
catch (Exception)
{
throw;
}
}
public List <UserLib> LibreriaPorUsuario(string usr_cod)
{
try
{
List <UserLib> ls;
using (HValles_AfsDataContext db = new HValles_AfsDataContext())
{
db.Database.OpenConnection();
DbCommand cmd = db.Database.GetDbConnection().CreateCommand();
cmd.CommandText = "API.getLibUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@USR_COD", usr_cod));
using (var reader = cmd.ExecuteReader())
{
//ExecuteReade
ls = reader.MapToList <UserLib>();
}
}
return(ls);
}
catch (Exception ex)
{
throw;
}
}
public async Task <Dashboard> GetDashboards()
{
Dashboard dashboard = new Dashboard();
try
{
using (HValles_AfsDataContext db = new HValles_AfsDataContext())
{
db.Database.OpenConnection();
DbCommand cmd = db.Database.GetDbConnection().CreateCommand();
cmd.CommandText = "API.getDashboard";
cmd.CommandType = CommandType.StoredProcedure;
using (var reader = await cmd.ExecuteReaderAsync())
{
while (reader.Read())
{
//var a = reader[0];
dashboard.INDICES = reader["INDICES"].ToString();
dashboard.DOCUMENTOS = reader["DOCUMENTOS"].ToString();
dashboard.PAGINAS = reader["PAGINAS"].ToString();
dashboard.DISCO = reader["DISCO"].ToString();
}
}
}
return(dashboard);
}
catch (Exception ex)
{
throw;
}
}
public async Task <List <DocumentosRecientes> > GetDocumentosRecientes()
{
List <DocumentosRecientes> documento = new List <DocumentosRecientes>();
try
{
using (HValles_AfsDataContext db = new HValles_AfsDataContext())
{
db.Database.OpenConnection();
DbCommand cmd = db.Database.GetDbConnection().CreateCommand();
cmd.CommandText = "API.getDocumentosRecientes";
cmd.CommandType = CommandType.StoredProcedure;
using (var reader = await cmd.ExecuteReaderAsync())
{
while (reader.Read())
{
documento = reader.MapToList <DocumentosRecientes>();
}
}
}
return(documento);
}
catch (Exception ex)
{
var a = ex;
throw;
}
}
public List <MetaData> ObtenerMedaData(string libCod, string arcCod, string palabra)
{
List <MetaData> data = new List <MetaData>();
try
{
using (HValles_AfsDataContext db = new HValles_AfsDataContext())
{
db.Database.OpenConnection();
DbCommand cmd = db.Database.GetDbConnection().CreateCommand();
cmd.CommandText = "API.getDocumentosMetaData";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter("@LIB_COD", libCod));
cmd.Parameters.Add(new SqlParameter("@ARC_COD", arcCod));
cmd.Parameters.Add(new SqlParameter("@DIC_PALABRA", palabra));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
data = reader.MapToList <MetaData>();
}
}
}
return(data);
}
catch (Exception)
{
throw;
}
}
public SearchController(
IConfiguration configuration,
HValles_AfsDataContext context,
IMapper maper
)
{
_configuration = configuration;
_context = context;
_maper = maper;
}
public async Task <List <Documento> > BusquedaRapida(string usr_cod, string palabra)
{
List <Documento> documento = new List <Documento>();
try
{
using (HValles_AfsDataContext db = new HValles_AfsDataContext())
{
db.Database.OpenConnection();
DbCommand cmd = db.Database.GetDbConnection().CreateCommand();
cmd.CommandText = "API.getDocumentos";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter("@USR_COD", usr_cod));
cmd.Parameters.Add(new SqlParameter("@OPERACION", "OB"));
cmd.Parameters.Add(new SqlParameter("@DIC_PALABRA", palabra));
cmd.Parameters.Add(new SqlParameter("@outID", SqlDbType.Int, 30));
cmd.Parameters["@outID"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@outMensaje", SqlDbType.VarChar, 30));
cmd.Parameters["@outMensaje"].Direction = ParameterDirection.Output;
using (var reader = await cmd.ExecuteReaderAsync())
{
// documento = reader.MapToList<Documento>();
while (reader.Read())
{
//var a = reader[0];
documento.Add(new Documento()
{
arcCod = reader["arcCod"].ToString(),
hex = reader["hex"].ToString(),
libCod = reader["libCod"].ToString(),
libNombre = reader["libNombre"].ToString(),
arcPaginas = Convert.ToInt32(reader["arcPaginas"].ToString()),
pagNombre = reader["pagNombre"].ToString(),
pagMini = reader["pagMini"].ToString(),
metadata = _data.ObtenerMedaData(reader["libCod"].ToString(), reader["arcCod"].ToString(), palabra),
});
}
}
}
return(documento);
}
catch (Exception ex)
{
throw;
}
}
public UserInfo Login(UserInfo user)
{
UserInfo info = new UserInfo();
try
{
using (var ctx = new HValles_AfsDataContext())
{
info = ctx.AfsSvrUsu.Where(x => x.UsrNombre == user.Username && x.UsrClave == _enc.HashString(user.Password))
.Select(x => new UserInfo {
Username = x.UsrCodigo,
Password = user.Password,
usr_cod = x.UsrCod
}).FirstOrDefault();
}
return(info);
}
catch (Exception ex)
{
throw;
}
}
