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); }