public async Task <List <KnowledgeBasesModel> > GetKnowledgesBases()
{
List <KnowledgeBasesModel> _knowledgeBases = new List <KnowledgeBasesModel>();
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { };
var dReader = await _dbContext.ExecuteReaderAsync("sp_GetAreasEnv", parameters);
while (dReader.Read())
{
_knowledgeBases.Add(new KnowledgeBasesModel()
{
Id = Convert.ToInt32(dReader[0]),
KnowledgeBase = dReader[1].ToString(),
Description = dReader[2].ToString(),
KeyId = dReader[3].ToString(),
Id_contact = Convert.ToInt32(dReader[4]),
Contact = dReader[5].ToString(),
LastName = dReader[6].ToString(),
Email = dReader[7].ToString(),
Id_env = Convert.ToInt32(dReader[8]),
Environment = dReader[9].ToString()
});
}
}
return(_knowledgeBases);
}
public async Task <List <EnvironmentsModel> > GetEnvironments()
{
List <EnvironmentsModel> _environments = new List <EnvironmentsModel>();
try
{
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { };
var _dReader = await _dbContext.ExecuteReaderAsync("sp_GetEnvironments", parameters);
while (_dReader.Read())
{
var environments = new EnvironmentsModel();
environments.Id = Convert.ToInt32(_dReader[0]);
environments.Environment = _dReader[1].ToString();
environments.HostName = _dReader[2].ToString();
environments.EndPointKey = _dReader[3].ToString();
environments.Username = _dReader[4].ToString();
environments.Password = _dReader[5].ToString();
environments.IsActive = Convert.ToInt32(_dReader[6]);
environments.Score = _dReader[7].ToString();
_environments.Add(environments);
}
}
}
catch (Exception)
{
_environments = new List <EnvironmentsModel>();
}
return(_environments);
}
public async Task <List <QuestionAnswerModel> > SaveAnswerKnowledge(DataTable _dTable, CreateKnowledgeModel model)
{
var questionAnswerModel = new List <QuestionAnswerModel>();
try
{
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { model.NombreResponsable, model.Apellidos, model.Telefono, model.Email, model.NombreConocimiento, _dTable };
var _result = await _dbContext.ExecuteReaderAsync("sp_CreateKnowledgeBase", parameters);
while (_result.Read())
{
questionAnswerModel.Add(new QuestionAnswerModel()
{
id = 0,
answer = _result[1].ToString(),
source = "Editorial",
questions = _result[0].ToString().Split(';'),
metadata = new string[0]
});
}
}
}
catch (Exception) {
questionAnswerModel = new List <QuestionAnswerModel>();
}
return(questionAnswerModel);
}
public async Task <EndPointsModel> GetEndPointQaNMaker(string username)
{
var _list_endPoint = new EndPointsModel();
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { username };
var result = await _dbContext.ExecuteReaderAsync("sp_GetEndPointByUser", parameters);
List <EnviromentEndpointModel> endpoint = new List <EnviromentEndpointModel>();
while (result.Read())
{
endpoint.Add(new EnviromentEndpointModel
{
environment = result.GetString(0),
qnaAuthKey = result.GetString(1),
qnaKBId = result.GetString(2),
endpointHostName = result.GetString(3),
username = result.GetString(4),
password = result.GetString(5),
score = result[6].ToString()
});
}
_list_endPoint.endpoints = endpoint;
}
return(_list_endPoint);
}
public async Task <List <QuestionAnswerModel> > UpdateKnowledge(string name, DataTable dataTable)
{
var questionAnswerModel = new List <QuestionAnswerModel>();
try
{
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { name, dataTable };
var _result = await _dbContext.ExecuteReaderAsync("sp_UpdateQuestionKnowledgeBase", parameters);
while (_result.Read())
{
questionAnswerModel.Add(new QuestionAnswerModel()
{
id = 0,
answer = _result[1].ToString(),
source = "Editorial",
questions = _result[0].ToString().Split(';'),
metadata = new string[0]
});
}
}
}
catch (Exception)
{
questionAnswerModel = new List <QuestionAnswerModel>();
}
return(questionAnswerModel);
}
public async Task <string> GetIdArea(string username)
{
var _result = string.Empty;
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { username };
var _reader = await _context.ExecuteReaderAsync("sp_GetIdAreaByUser", parameters);
while (_reader.Read())
{
_result = _reader[0].ToString();
}
}
return(_result);
}
public async Task <string> GetAnswerForUser(GetMessage model)
{
var strMessage = string.Empty;
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { model.IdQuestion, model.Region, model.IdArea };
var result = await _dbContext.ExecuteReaderAsync("sp_GetAnswerForUser", parameters);
while (result.Read())
{
strMessage = result[0].ToString();
}
}
return(strMessage);
}
public async Task <string> GetReplaceText(string _text)
{
var strMessage = string.Empty;
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { _text };
var result = await _dbContext.ExecuteReaderAsync("sp_SustitucionPalabras", parameters);
while (result.Read())
{
strMessage = result[0].ToString();
}
}
return(strMessage);
}
public async Task <int> SaveNewQuestion(SaveNewQuestion model)
{
var _idQuestion = 0;
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { model.Question, model.Answer, model.IdArea, model.IdRegions, model.Type };
var _result = await _dbContext.ExecuteReaderAsync("sp_SaveNewQuestion", parameters);
while (_result.Read())
{
_idQuestion = Convert.ToInt32(_result[0]);
}
}
return(_idQuestion);
}
public async Task <bool> CredentialValidate(AuthenticateModel model)
{
var isCredentialValid = false;
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { model.Username, model.Password };
var _result = await _context.ExecuteReaderAsync("sp_GetLoginUsuario", parameters);
if (_result.HasRows)
{
isCredentialValid = true;
}
}
return(isCredentialValid);
}
public async Task <ContactAreaModel> getDataContact(int IdArea)
{
ContactAreaModel model = new ContactAreaModel();
using (var _context = new DataBaseContext())
{
object[] parameter = new object[] { IdArea };
var dReader = await _context.ExecuteReaderAsync("sp_GetAreaContact", parameter);
while (dReader.Read())
{
model.ContactName = dReader.GetString(0);
model.Email = dReader.GetString(1);
}
}
return(model);
}
public async Task <AreaEndPointModel> getAreaById(int id)
{
AreaEndPointModel areaEndPointModel = new AreaEndPointModel();
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { id };
var dReader = await _context.ExecuteReaderAsync("sp_GetKeyIdArea", parameters);
while (dReader.Read())
{
areaEndPointModel.Area = dReader.GetString(0);
areaEndPointModel.KeyId = dReader.GetString(1);
}
}
return(areaEndPointModel);
}
public async Task<List<UserModel>> GetUsers() {
var _listUsers = new List<UserModel>();
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { };
var dReader = await _context.ExecuteReaderAsync("sp_GetUsuarios", parameters);
while (dReader.Read())
{
_listUsers.Add(new UserModel {
Id = Convert.ToInt32(dReader[0]),
UserName = dReader[1].ToString(),
Password = dReader[2].ToString(),
IsActive = Convert.ToInt32(dReader[3])
});
}
}
return _listUsers;
}
public async Task <ContactAreaModel> getDataUser(string username)
{
ContactAreaModel model = new ContactAreaModel();
using (var _context = new DataBaseContext())
{
var strQuery = "EXEC sp_GetDataUser '" + username + "'";
object[] parameter = new object[] { username };
var dReader = await _context.ExecuteReaderAsync("sp_GetDataUser", parameter);
while (dReader.Read())
{
model.ContactName = dReader.GetString(0);
model.Email = dReader.GetString(1);
}
}
return(model);
}
public async Task <List <AreasKeyIdModel> > GetKeyId(string IdAreas)
{
var _keyIds = new List <AreasKeyIdModel>();
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { IdAreas };
var _reader = await _context.ExecuteReaderAsync("sp_GetKeyId", parameters);
while (_reader.Read())
{
_keyIds.Add(new AreasKeyIdModel
{
KeId = _reader[0].ToString()
});
}
}
return(_keyIds);
}
public async Task <List <AreasModel> > ValidGetArea(string mail)
{
var listEndPoint = new List <AreasModel>();
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { mail };
var dReader = await _context.ExecuteReaderAsync("sp_validaUsuarioArea", parameters);
while (dReader.Read())
{
var area = new AreasModel();
area.id = dReader.GetInt32(0);
area.area = dReader.GetString(1);
listEndPoint.Add(area);
}
}
return(listEndPoint);
}
public async Task <List <AreasModel> > getEndPoint()
{
var listEndPoint = new List <AreasModel>();
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { };
var dReader = await _context.ExecuteReaderAsync("SP_GETAreas", parameters);
while (dReader.Read())
{
var area = new AreasModel();
area.id = dReader.GetInt32(0);
area.area = dReader.GetString(1);
listEndPoint.Add(area);
}
}
return(listEndPoint);
}
public async Task <List <GetAllQuestionByArea> > GetAllQuestionByArea(int idArea, DataTable _data)
{
var _allQuestion = new List <GetAllQuestionByArea>();
using (var _context = new DataBaseContext())
{
object[] parameters = new object[] { idArea, _data };
var _reader = await _context.ExecuteReaderAsync("sp_GetAllQuestion", parameters);
while (_reader.Read())
{
_allQuestion.Add(new GetAllQuestionByArea
{
Question = _reader[0].ToString(),
Regions = _reader[1].ToString(),
Answer = _reader[2].ToString()
});
}
}
return(_allQuestion);
}
public async Task <List <RegionsModel> > GetRegionsTest()
{
List <RegionsModel> regionsModel = new List <RegionsModel>();
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { };
var dReader = await _dbContext.ExecuteReaderAsync("sp_GetRegionTest", parameters);
while (dReader.Read())
{
regionsModel.Add(new RegionsModel()
{
Id = Convert.ToInt32(dReader[0]),
Region = dReader.GetString(1),
IsActive = Convert.ToInt32(dReader[2])
});
}
}
return(regionsModel);
}
public async Task <List <QuestionAnswerModel> > GetQuestionAnswersByIdArea(string strArea)
{
List <QuestionAnswerModel> questionAnswerModel = new List <QuestionAnswerModel>();
using (var _dbContext = new DataBaseContext())
{
object[] parameters = new object[] { strArea };
var dReader = await _dbContext.ExecuteReaderAsync("sp_GetQuestionAnswerByArea", parameters);
while (dReader.Read())
{
var question = new QuestionAnswerModel();
question.id = 0;
question.answer = dReader.GetString(1);
question.source = "Editorial";
question.questions = dReader.GetString(0).Split(';');
question.metadata = new string[0];
questionAnswerModel.Add(question);
}
}
return(questionAnswerModel);
}
