public static void Initialize()
{
superAdm = false;
showQrCode = false;
choiceAvatar = 1;
if (test == false)
{
path = "URI=file:" + Application.streamingAssetsPath + "/fisiotech.db";
}
else
{
path = "URI=file:" + Application.streamingAssetsPath + "/test_fisiotech.db";
}
var directory = path.Substring(9, path.Length - 9);
if (!System.IO.File.Exists(directory))
{
SqliteConnection.CreateFile(directory);
}
Pessoa.Create();
Fisioterapeuta.Create();
Paciente.Create();
Musculo.Create();
Movimento.Create();
Sessao.Create();
Exercicio.Create();
MovimentoMusculo.Create();
PontosRotuloPaciente.Create();
PontosRotuloFisioterapeuta.Create();
}
/**
* Salva o paciente no banco.
*/
public void saveMovement()
{
var muscles = musculos.text.Split(',');
string movunderscored = (nomeMovimento.text).Replace(' ', '_');
string physiounderscored = (GlobalController.instance.admin.persona.nomePessoa).Replace(' ', '_');
string pathSave = GlobalController.instance.admin.idPessoa + "-";
pathSave += physiounderscored + "/";
pathSave += movunderscored + "-";
pathSave += DateTime.Now.ToString("HHmmss", System.Globalization.DateTimeFormatInfo.InvariantInfo);
Movimento.Insert(GlobalController.instance.admin.idFisioterapeuta,
nomeMovimento.text, descricao.text, pathSave);
List <Movimento> movementsList = Movimento.Read();
foreach (var muscle in muscles)
{
name = new string((from c in muscle where char.IsLetterOrDigit(c) select c).ToArray());
if (!checkMuscle(name))
{
Musculo.Insert(name);
List <Musculo> musclesList = Musculo.Read();
MovimentoMusculo.Insert(musclesList[musclesList.Count - 1].idMusculo, movementsList[movementsList.Count - 1].idMovimento);
}
}
GlobalController.instance.movement = movementsList[movementsList.Count - 1];
SceneManager.LoadScene("Clinic");
}
public DetalleRutina(int pDia, String pSeriesxRepeticiones, String pDescanso, Musculo pMusculo)
{
this.dia = pDia;
this.seriesxRepeticiones = pSeriesxRepeticiones;
this.descanso = pDescanso;
this.musculo = pMusculo;
}
static Musculo presentMuscle(string name)
{
var query = string.Format("SELECT * FROM MUSCULO WHERE \"nomeMusculo\"=\"{0}\";", name);
Musculo mus = Musculo.SingleSpecificSelect(query);
return(mus);
}
// GET: Musculo/Create
public ActionResult Create(int?pagina)
{
ViewBag.Pagina = (pagina ?? 1);
Musculo bdMusculo = new Musculo();
ViewBag.GrupoMusculosID = new SelectList(Funcion.GetListaGrupoMusculos(), "Value", "Text");
return(View(bdMusculo));
}
public static void TestMusculoUpdate()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Musculo.Insert("bíceps");
Musculo.Insert("tríceps");
Musculo.Insert("quadríceps");
Musculo.Update(3, "quintríceps");
Musculo.Update(2, "quadríceps");
var check = "SELECT * FROM MUSCULO;";
var id = 0;
var result = "";
int i = 1;
string[] x = new string[] { "", "b", "quadr", "quintr" };
using (var cmd = new SqliteCommand(check, conn))
{
using (IDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
id = reader.GetInt32(0);
Assert.AreEqual(id, i);
}
if (!reader.IsDBNull(1))
{
result = reader.GetString(1);
string z = x[i] + "íceps";
Assert.AreEqual(result, z);
}
i++;
}
}
finally
{
reader.Dispose();
reader.Close();
}
}
cmd.Dispose();
}
conn.Dispose();
conn.Close();
}
}
/**
* Salva o Movimento no banco.
*/
public void saveMovement()
{
List <InputField> allInputs = new List <InputField>();
allInputs.Add(nomeMovimento);
allInputs.Add(musculos);
allInputs.Add(descricao);
if (ValidInput(allInputs))
{
foreach (var x in allInputs)
{
ApplyColor(x, 1);
}
var muscles = musculos.text.Split(',');
string movunderscored = (nomeMovimento.text).Replace(' ', '_');
string physiounderscored = (GlobalController.instance.admin.persona.nomePessoa).Replace(' ', '_');
string pathSave = GlobalController.instance.admin.idPessoa + "-";
pathSave += physiounderscored + "/";
pathSave += movunderscored + "-";
pathSave += DateTime.Now.ToString("HHmmss", System.Globalization.DateTimeFormatInfo.InvariantInfo);
Movimento.Insert(GlobalController.instance.admin.idFisioterapeuta,
nomeMovimento.text, pathSave + ".points", descricao.text);
List <Movimento> movementsList = Movimento.Read();
foreach (var muscle in muscles)
{
name = new string((from c in muscle where char.IsLetterOrDigit(c) select c).ToArray());
if (!checkMuscle(name))
{
Musculo.Insert(name);
List <Musculo> musclesList = Musculo.Read();
MovimentoMusculo.Insert(musclesList[musclesList.Count - 1].idMusculo, movementsList[movementsList.Count - 1].idMovimento);
}
}
GlobalController.patientOrPhysio = true;
GlobalController.instance.movement = movementsList[movementsList.Count - 1];
if (GlobalController.Sensor == false)
{
Flow.StaticRealtimeGraphKinectPhysio();
}
else
{
Flow.StaticRealtimeGraphUDPPhysio();
}
}
}
/// <summary>
/// Constructor de la clase
/// </summary>
/// <param name="musculo"></param>
/// <param name="ejercicio"></param>
/// <param name="serieRepeticion"></param>
/// <param name="descanso"></param>
public LineaEjercicio(Musculo musculo, Ejercicio ejercicio, string serieRepeticion, int descanso)
{
this.EjercicioId = ejercicio.Id;
this.Ejercicio = ejercicio;
this.MusculoId = musculo.Id;
this.Musculo = musculo;
this.SerieRepeticion = serieRepeticion;
this.Descanso = descanso;
}
private void ProcessFileImage(int pMusculoId, Image pImage, string pExtension)
{
Musculo bdMusculo = db.Musculo.Find(pMusculoId);
string sToFile = "";
string sNameFile = "slmf-musculo-" + Funcion.NameEncode(bdMusculo.Nombre).Trim().ToLower();
bdMusculo.FileImage = sNameFile + "." + pExtension;
db.Entry(bdMusculo).State = EntityState.Modified;
db.SaveChanges();
sToFile = Server.MapPath(sFolderImagesAssets + sNameFile + "." + pExtension);
pImage.Save(sToFile);
}
public ActionResult DeleteConfirmed(int id, int?pagina)
{
ViewBag.Pagina = (pagina ?? 1);
Musculo bdMusculo = db.Musculo.Find(id);
if (bdMusculo.EjerciciosConElMusculo.Count == 0)
{
db.Musculo.Remove(bdMusculo);
db.SaveChanges();
}
return(RedirectToAction("Index", "Musculo", new { pagina = ViewBag.Pagina }));
}
void Initialize()
{
Pessoa.Create();
Fisioterapeuta.Create();
Paciente.Create();
Musculo.Create();
Movimento.Create();
Sessao.Create();
Exercicio.Create();
MovimentoMusculo.Create();
PontosRotuloPaciente.Create();
PontosRotuloFisioterapeuta.Create();
}
static bool checkMuscle(string name)
{
List <Musculo> musclesList = Musculo.Read();
foreach (var muscle in musclesList)
{
if (muscle.nomeMusculo == name)
{
return(true);
}
}
return(false);
}
public ActionResult DeleteImage(int id, int?pagina)
{
ViewBag.Pagina = (pagina ?? 1);
Musculo bdMusculo = db.Musculo.Find(id);
if (bdMusculo.FileImage != null)
{
string sArchivo = Server.MapPath(sFolderImagesAssets + bdMusculo.FileImage);
bdMusculo.FileImage = null;
db.Entry(bdMusculo).State = EntityState.Modified;
db.SaveChanges();
Funcion.EliminaArchivo(sArchivo);
}
return(RedirectToAction("Details", "Musculo", new { id = bdMusculo.ID, pagina = ViewBag.Pagina }));
}
// GET: Musculo/Details/5
public ActionResult Details(int?id, int?pagina)
{
ViewBag.Pagina = (pagina ?? 1);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Musculo bdMusculo = db.Musculo.Find(id);
if (bdMusculo == null)
{
return(HttpNotFound());
}
return(View(bdMusculo));
}
public static void DropAll()
{
if (test == true)
{
Pessoa.Drop();
Fisioterapeuta.Drop();
Paciente.Drop();
Musculo.Drop();
Movimento.Drop();
Sessao.Drop();
Exercicio.Drop();
MovimentoMusculo.Drop();
PontosRotuloPaciente.Drop();
PontosRotuloFisioterapeuta.Drop();
}
}
// GET: Musculo/Edit/5
public ActionResult Edit(int?id, int?pagina)
{
ViewBag.Pagina = (pagina ?? 1);
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Musculo bdMusculo = db.Musculo.Find(id);
if (bdMusculo == null)
{
return(HttpNotFound());
}
ViewBag.GrupoMusculosID = new SelectList(Funcion.GetListaGrupoMusculos(), "Value", "Text", bdMusculo.GrupoMusculosID);
return(View(bdMusculo));
}
public static void TestMusculoDrop()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Musculo.Drop();
var check = "SELECT count(*) FROM sqlite_master WHERE type='table' AND name='MUSCULO';";
var result = 0;
using (var cmd = new SqliteCommand(check, conn))
{
using (IDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
result = reader.GetInt32(0);
}
}
}
finally
{
reader.Dispose();
reader.Close();
}
}
cmd.Dispose();
}
Assert.AreEqual(result, 0);
conn.Dispose();
conn.Close();
}
}
public void TestMovimentoMusculoRead()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Pessoa.Insert("fake name1", "m", "1995-01-01", "6198732711", null);
Pessoa.Insert("fake name2", "m", "1995-01-02", "6198732712", null);
Fisioterapeuta.Insert(1, "abracadabra1", "demais1", null, null);
Fisioterapeuta.Insert(2, "abracadabra2", "demais2", "DF", "123424");
Movimento.Insert(1, "Movimento1", "Musculo Redondo Maior", null);
Movimento.Insert(2, "Movimento2", "Musculo Redondo Maior", "Dificuldade nesse local");
Musculo.Insert("bíceps");
Musculo.Insert("tríceps");
MovimentoMusculo.Insert(1, 1);
MovimentoMusculo.Insert(1, 2);
MovimentoMusculo.Insert(2, 1);
MovimentoMusculo.Insert(2, 2);
List <MovimentoMusculo> allMuscMov = MovimentoMusculo.Read();
for (int i = 1, j = 1, k = 1; i <= allMuscMov.Count; i++, k = 3 - k)
{
Assert.AreEqual(allMuscMov[i - 1].idMusculo, j);
Assert.AreEqual(allMuscMov[i - 1].idMovimento, k);
if (i == 2)
{
j++;
}
}
conn.Dispose();
conn.Close();
}
return;
}
public ActionResult Edit(int?pagina, [Bind(Include = "ID,Nombre,NombreComun,Descripcion,GrupoMusculosID,FileImage")] Musculo musculo)
{
ViewBag.Pagina = (pagina ?? 1);
if (ModelState.IsValid)
{
if (db.Musculo.Any(x => x.Nombre.Trim().ToUpper() == musculo.Nombre.Trim().ToUpper() && x.ID != musculo.ID))
{
ModelState.AddModelError("Nombre", "Ya existe un Musculo con ese Nombre");
}
else if (db.Musculo.Any(x => x.NombreComun.Trim().ToUpper() == musculo.NombreComun.Trim().ToUpper() && x.ID != musculo.ID))
{
ModelState.AddModelError("NombreComun", "Ya existe un Musculo con ese Nombre Comun");
}
else
{
db.Entry(musculo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Musculo", new { sSearchString = musculo.Nombre }));
}
}
ViewBag.GrupoMusculosID = new SelectList(Funcion.GetListaGrupoMusculos(), "Value", "Text", musculo.GrupoMusculosID);
return(View(musculo));
}
public static void TestMusculoReadValue()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Musculo.Insert("bíceps");
Musculo.Insert("tríceps");
Musculo.Insert("quadríceps");
string[] x = new string[] { "", "b", "tr", "quadr" };
for (int i = 1; i <= 3; ++i)
{
Musculo musculo = Musculo.ReadValue(i);
Assert.AreEqual(musculo.idMusculo, i);
Assert.AreEqual(musculo.nomeMusculo, (x[i] + "íceps"));
}
conn.Dispose();
conn.Close();
}
}
public static void TestMusculoRead()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Musculo.Insert("bíceps");
Musculo.Insert("tríceps");
Musculo.Insert("quadríceps");
List <Musculo> allMuscs = Musculo.Read();
string[] x = new string[] { "", "b", "tr", "quadr" };
for (int i = 1; i <= allMuscs.Count; ++i)
{
Assert.AreEqual(allMuscs[i - 1].idMusculo, i);
Assert.AreEqual(allMuscs[i - 1].nomeMusculo, (x[i] + "íceps"));
}
conn.Dispose();
conn.Close();
}
}
public void TestMovimentoMusculoDeleteValue()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Pessoa.Insert("fake name1", "m", "1995-01-01", "6198732711", null);
Pessoa.Insert("fake name2", "m", "1995-01-02", "6198732712", null);
Fisioterapeuta.Insert(1, "abracadabra1", "demais1", null, null);
Fisioterapeuta.Insert(2, "abracadabra2", "demais2", "DF", "123424");
Movimento.Insert(1, "Movimento1", "Musculo Redondo Maior", null);
Musculo.Insert("bíceps");
MovimentoMusculo.Insert(1, 1);
var check = "SELECT EXISTS(SELECT 1 FROM 'MOVIMENTOMUSCULO' WHERE \"idMusculo\" = \"1\" AND \"idMovimento\" = \"1\" LIMIT 1)";
var id = 0;
using (var cmd = new SqliteCommand(check, conn))
{
using (IDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
id = reader.GetInt32(0);
}
}
}
finally
{
reader.Dispose();
reader.Close();
}
}
cmd.Dispose();
}
Assert.AreEqual(id, 1);
MovimentoMusculo.DeleteValue(1, 1);
id = 0;
using (var cmd = new SqliteCommand(check, conn))
{
using (IDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
id = reader.GetInt32(0);
}
}
}
finally
{
reader.Dispose();
reader.Close();
}
}
cmd.Dispose();
}
Assert.AreEqual(id, 0);
conn.Dispose();
conn.Close();
}
return;
}
/**
* Salva o Movimento no banco.
*/
public void saveMovement()
{
List <InputField> allInputs = new List <InputField>();
allInputs.Add(nomeMovimento);
allInputs.Add(musculos);
allInputs.Add(descricao);
if (ValidInput(allInputs))
{
foreach (var x in allInputs)
{
ApplyColor(x, 1);
}
var muscles = GetWords(musculos.text);
string movunderscored = (nomeMovimento.text).Replace(' ', '_');
string physiounderscored = (GlobalController.instance.admin.persona.nomePessoa).Replace(' ', '_');
StringBuilder path = new StringBuilder();
path.Append(GlobalController.instance.admin.idPessoa + "-");
path.Append(physiounderscored + "/");
path.Append(movunderscored + "-");
path.Append(DateTime.Now.ToString("HHmmss", System.Globalization.DateTimeFormatInfo.InvariantInfo));
path.Append(".points");
string pathSave = path.ToString();
Movimento.Insert(GlobalController.instance.admin.idFisioterapeuta,
nomeMovimento.text,
pathSave,
descricao.text);
var lastMovement = Movimento.GetLast();
GlobalController.instance.movement = lastMovement;
foreach (var muscle in muscles)
{
if (!checkMuscle(muscle))
{
Musculo.Insert(muscle);
Musculo lastMusculo = Musculo.GetLast();
MovimentoMusculo.Insert(lastMusculo.idMusculo, lastMovement.idMovimento);
}
else
{
Musculo musculoExistente = presentMuscle(muscle);
MovimentoMusculo.Insert(musculoExistente.idMusculo, lastMovement.idMovimento);
}
}
GlobalController.patientOrPhysio = true;
// Checks the sensor choice from the file
StringBuilder sensorPath = new StringBuilder();
sensorPath.Append("sensor.choice");
string choicePath = sensorPath.ToString();
if (File.Exists(choicePath)) // User has already chosen a sensor
{
string line = File.ReadAllText(choicePath);
int fileValue = Convert.ToInt32(line);
if (fileValue.Equals(0)) // Kinect selected
{
GlobalController.Sensor = false;
}
else if (fileValue.Equals(1)) // UDP selected
{
GlobalController.Sensor = true;
}
}
else // Kinect is default value
{
GlobalController.Sensor = false;
}
// Redirects user to correct scene
if (GlobalController.Sensor == false)
{
Flow.StaticRealtimeGraphKinectPhysio();
}
else
{
Flow.StaticRealtimeGraphUDPPhysio();
}
}
}
public void TestMovimentoMusculoInsert()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Pessoa.Insert("fake name1", "m", "1995-01-01", "6198732711", null);
Pessoa.Insert("fake name2", "m", "1995-01-02", "6198732712", null);
Fisioterapeuta.Insert(1, "abracadabra1", "demais1", null, null);
Fisioterapeuta.Insert(2, "abracadabra2", "demais2", "DF", "123424");
Movimento.Insert(1, "Movimento1", "Musculo Redondo Maior", null);
Movimento.Insert(2, "Movimento2", "Musculo Redondo Maior", "Dificuldade nesse local");
Musculo.Insert("bíceps");
Musculo.Insert("tríceps");
MovimentoMusculo.Insert(1, 1);
MovimentoMusculo.Insert(1, 2);
MovimentoMusculo.Insert(2, 1);
MovimentoMusculo.Insert(2, 2);
var check = "SELECT * FROM MOVIMENTOMUSCULO;";
var id = 0;
int i = 1;
int j = 1;
int k = 1;
using (var cmd = new SqliteCommand(check, conn))
{
using (IDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
id = reader.GetInt32(0);
Assert.AreEqual(id, j);
}
if (!reader.IsDBNull(1))
{
id = reader.GetInt32(1);
Assert.AreEqual(id, i);
}
i = 3 - i;
if (k == 2)
{
j++;
}
k++;
}
}
finally
{
reader.Dispose();
reader.Close();
}
}
cmd.Dispose();
}
conn.Dispose();
conn.Close();
}
return;
}
public Ejercicio(String pNombre, Musculo pMusculo)
{
this.nombre = pNombre;
this.musculo = pMusculo;
}
public void AsociarMusculo(Musculo musculo)
{
this.MusculoId = musculo.Id;
this.Musculo = musculo;
}
public static void TestMusculoDeleteValue()
{
using (var conn = new SqliteConnection(GlobalController.path))
{
conn.Open();
Musculo.Insert("bíceps");
var check = "SELECT EXISTS(SELECT 1 FROM 'MUSCULO' WHERE \"idMusculo\" = \"1\" LIMIT 1)";
var result = 0;
using (var cmd = new SqliteCommand(check, conn))
{
using (IDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
result = reader.GetInt32(0);
}
}
}
finally
{
reader.Dispose();
reader.Close();
}
}
cmd.Dispose();
}
Assert.AreEqual(result, 1);
Musculo.DeleteValue(1);
result = 0;
using (var cmd = new SqliteCommand(check, conn))
{
using (IDataReader reader = cmd.ExecuteReader())
{
try
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
result = reader.GetInt32(0);
}
}
}
finally
{
reader.Dispose();
reader.Close();
}
}
cmd.Dispose();
}
Assert.AreEqual(result, 0);
conn.Dispose();
conn.Close();
}
}
public void NuevoEjercicio(string nombre, Musculo musculo) // constructor de ejercicio
{
var unEjercicio = new Ejercicio(nombre, musculo); // instanciacion de nuevo ejercicio
this.iUnitOfWork.EjercicioRepository.Add(unEjercicio); // agregarEjercicio a listEjercicios
}
public void NuevoMusculo(string nombre) // constructor de musculo
{
var unMusculo = new Musculo(nombre); // instanciacion de nuevo musculo
this.iUnitOfWork.MusculoRepository.Add(unMusculo); // agregarMusculo a listMusculo
}
