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