public int GetDeviceId(string quizDeviceName) { try { QuizDeviceModel device = _quizDeviceRepository.GetByName(quizDeviceName); return(device.QuizDeviceId); } catch (Exception ex) { return(0); } }
public void SaveDevice(QuizDeviceDto device) { //ValidateDevice(device); if (device.QuizDeviceId == 0) { //Add Device using (TransactionScope scope = new TransactionScope()) { try { QuizDeviceModel quizDeviceModel = new QuizDeviceModel() { QuizDeviceLocation = device.QuizDeviceLocation, QuizDeviceName = device.QuizDeviceName, QuizToApplyId = device.QuizToApplyId }; _quizDeviceRepository.Add(quizDeviceModel); scope.Complete(); } catch (Exception ex) { throw new Exception($"Error en repositorio:\n{ex.Message}"); } } } else { //Update Device using (TransactionScope scope = new TransactionScope()) { try { QuizDeviceModel quizDeviceModel = _quizDeviceRepository.Get(device.QuizDeviceId); quizDeviceModel.QuizDeviceName = device.QuizDeviceName; quizDeviceModel.QuizDeviceLocation = device.QuizDeviceLocation; quizDeviceModel.QuizToApplyId = device.QuizToApplyId; _quizDeviceRepository.Update(quizDeviceModel); scope.Complete(); } catch (Exception ex) { throw new Exception("Error en repositorio"); } } } }
public QuizDeviceDto GetDevice(int deviceId = 0) { QuizDeviceDto item = new QuizDeviceDto(); if (deviceId == 0) { return(item); } QuizDeviceModel model = _quizDeviceRepository.Get(deviceId); item.QuizDeviceName = model.QuizDeviceName; item.QuizDeviceId = model.QuizDeviceId; item.QuizDeviceLocation = model.QuizDeviceLocation; item.QuizToApplyId = model.QuizToApplyId; item.QuizName = _quizRepository.Get(item.QuizToApplyId).QuizName; return(item); }
public QuizDeviceModel Get(int quizDeviceId) { QuizDeviceModel item; try { using (MySqlConnection con = new MySqlConnection(_connectionString)) { string sql = "SELECT quizDeviceId, quizToApplyId, quizDeviceName, quizDeviceLocation, dateCreated FROM quizdevice WHERE quizDeviceId = @quizDeviceId;"; using (MySqlCommand cmd = new MySqlCommand(sql, con)) { cmd.Parameters.AddWithValue("@quizDeviceId", quizDeviceId); con.Open(); using (MySqlDataReader dr = cmd.ExecuteReader()) { item = new QuizDeviceModel(); if (dr.HasRows) { while (dr.Read()) { item = new QuizDeviceModel(); item.QuizDeviceId = Convert.ToInt32(dr["quizDeviceId"]); item.QuizToApplyId = Convert.ToInt32(dr["quizToApplyId"].ToString()); item.QuizDeviceName = dr["quizDeviceName"].ToString(); item.QuizDeviceLocation = dr["quizDeviceLocation"].ToString(); item.DateCreated = Convert.ToDateTime(dr["dateCreated"]); return(item); } } else { return(null); } } } } } catch (Exception ex) { throw new Exception(ex.Message, ex); } return(null); }
public List <Pregunta> GetDeviceQuestions(string deviceName) { QuizDeviceModel device = _quizDeviceRepository.GetByName(deviceName); List <QuestionModel> questionModel = _questionRepository.GetByQuizId(device.QuizToApplyId).ToList(); List <Pregunta> lstPreguntas = new List <Pregunta>(); foreach (QuestionModel model in questionModel) { lstPreguntas.Add(new Pregunta(model.QuestionId, model.Question)); } if (lstPreguntas.Count() == 0) { throw new Exception("Dispositivo mal configurado, no tiene ninguna encuesta vinculada."); } return(lstPreguntas); }
public void Update(QuizDeviceModel model) { try { using (MySqlConnection con = new MySqlConnection(_connectionString)) { string sql = "UPDATE encuesta.quizdevice SET quizToApplyId=@quizToApplyId, quizDeviceName=@quizDeviceName, quizDeviceLocation=@quizDeviceLocation WHERE quizDeviceId=@quizDeviceId;"; using (MySqlCommand cmd = new MySqlCommand(sql, con)) { cmd.Parameters.AddWithValue("@quizToApplyId", model.QuizToApplyId); cmd.Parameters.AddWithValue("@quizDeviceName", model.QuizDeviceName); cmd.Parameters.AddWithValue("@quizDeviceLocation", model.QuizDeviceLocation); cmd.Parameters.AddWithValue("@quizDeviceId", model.QuizDeviceId); con.Open(); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public void Add(QuizDeviceModel model) { try { using (MySqlConnection con = new MySqlConnection(_connectionString)) { string sql = "INSERT INTO encuesta.quizdevice (quizToApplyId, quizDeviceName, quizDeviceLocation, dateCreated) " + "VALUES(@quizToApplyId, @quizDeviceName, @quizDeviceLocation, CURRENT_TIMESTAMP);"; using (MySqlCommand cmd = new MySqlCommand(sql, con)) { cmd.Parameters.AddWithValue("@quizToApplyId", model.QuizToApplyId); cmd.Parameters.AddWithValue("@quizDeviceName", model.QuizDeviceName); cmd.Parameters.AddWithValue("@quizDeviceLocation", model.QuizDeviceLocation); con.Open(); cmd.ExecuteNonQuery(); model.QuizDeviceId = Convert.ToInt32(cmd.LastInsertedId); } } } catch (Exception ex) { throw new Exception(ex.Message, ex); } }