private string createCreativeRoutine(Player player, Profile profile)
{
string response = "OK";
UnityEngine.Debug.Log("[Create Creative Routine]");
int count = -1;
count = this.daoRoutines.getLastNumberRoutineM();
RoutinesEx routine = null;
if (count > -1)
{
try{
routine = new RoutinesEx(count + 1, "Creative Mode", "2008-7-04", 1);
this.daoRoutines.insertRoutineM(routine);
}catch (Exception e) {
response = "Error inserting Routine";
UnityEngine.Debug.Log("[createCreativeRoutine EXCEPTION] insertRoutine" + e.Message);
}
try{
this.daoProfileRoutines.insertProfileRoutineM(routine, profile);
}catch (Exception e) {
response = "Error inserting Routine in a profile";
UnityEngine.Debug.Log("[createCreativeRoutine EXCEPTION] insertRoutine" + e.Message);
}
}
return(response);
}
/*
* public List<Tuple<int, string>> getExerciesDescriptionFromRoutine(MySqlConnection connection,RoutinesEx routine){
* MySqlCommand cmd = connection.CreateCommand();
* List<Tuple<int, string>> listExercises = new List<Tuple<int, string>>();
* List<int> listIds = new List<int>();
* cmd.CommandText ="Select idExercise from ExercisesInRoutines Where idRoutine="+routine.id+";";
* MySqlDataReader reader = cmd.ExecuteReader();
* while (reader.Read()){
* int id = reader.GetInt32(0);
* listIds.Add(id);
* }
* reader.Close();
* listExercises = this.getDescriptionsListIdExercises(connection,listIds);
*
* return listExercises;
* }
*/
public List <Tuple <int, string> > getExerciesDescriptionFromRoutineM(RoutinesEx routine)
{
List <Tuple <int, string> > listExercises = new List <Tuple <int, string> >();
List <int> listIds = new List <int>();
var values = new Dictionary <string, string>
{
{ "idRoutine", routine.id.ToString() }
};
var content = new FormUrlEncodedContent(values);
var response = client.PostAsync("http://192.168.1.37/UnityBackendTutorial/getExerciseIdFromRoutine.php", content).Result;
string resultContent = response.Content.ReadAsStringAsync().Result;
if (!resultContent.Equals("No idExercise found"))
{
resultContent = resultContent.Remove(resultContent.Length - 1, 1);
string[] resultSplit = resultContent.Split(',');
for (int i = 0; i < resultSplit.Length; i++)
{
listIds.Add(Int16.Parse(resultSplit[i]));
}
listExercises = this.getDescriptionsListIdExercisesM(listIds);
}
return(listExercises);
}
public List <Tuple <int, string> > getExerciesFromRoutine(string username, string profile, int routineId)
{
List <Tuple <int, string> > listExercises = new List <Tuple <int, string> >();
try{
RoutinesEx routine = this.daoRoutines.selectRoutineFromIDM(routineId);
listExercises = this.daoRoutineExercise.getExerciesDescriptionFromRoutineM(routine);
}catch (Exception e) {
UnityEngine.Debug.Log("[Get INSTRUMENTS EXCEPTION]" + e.ToString());
}
return(listExercises);
}
public RoutinesEx readRoutine()
{
List <Exercise> listExercises = new List <Exercise>();
List <ScaleExercise> listScales = new List <ScaleExercise>();
string the_JSON_string = System.IO.File.ReadAllText(@"C:\Users\anton\Routine.JSON");
var json = JSON.Parse(the_JSON_string);
UnityEngine.Debug.Log("Class[JsonParser] method [readRoutine] Creating json" + the_JSON_string);
UnityEngine.Debug.Log("Class[JsonParser] method [readRoutine] Creating json" + json);
string type = json["type"].Value;
UnityEngine.Debug.Log("Class[JsonParser] method [readRoutine] Creating type" + type);
string description = "";
string finalDate = "";
if (type.Equals("Routine"))
{
description = json["description"].Value;
finalDate = json["finalDate"].Value;
}
bool continu = true;
int counter = 1;
while (continu)
{
Exercise exercise = null;
string ex = counter.ToString();
string typeEx = json[ex]["ExerciseType"].Value;
if (typeEx.Equals("") || typeEx.Equals(null))
{
UnityEngine.Debug.Log("FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF");
continu = false;
}
else
{
exercise = factory.GetExercise(typeEx, json[ex]);
UnityEngine.Debug.Log("GET TYPE" + exercise.GetType());
listExercises.Add(exercise);
if (typeEx.Equals("Scale"))
{
UnityEngine.Debug.Log("DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD");
listScales.Add(factory.scale);
}
}
counter++;
}
RoutinesEx routine = new RoutinesEx(description, finalDate, 0);
routine.listExercises = listExercises;
routine.listScales = listScales;
return(routine);
}
/*
* public string insertRoutine(MySqlConnection connection,RoutinesEx routine){
* MySqlCommand cmd = connection.CreateCommand();
* cmd.CommandText= "INSERT INTO Routines(idRoutine,description,finalDate) Values("+routine.id+",'"+
* routine.description+"','"+routine.date+"');";
*
* MySqlDataReader reader = cmd.ExecuteReader();
* reader.Close();
* return null;
* }
*/
public string insertRoutineM(RoutinesEx routine)
{
var values = new Dictionary <string, string>
{
{ "idRoutine", routine.id.ToString() },
{ "description", routine.description },
{ "finalDate", routine.date },
};
var content = new FormUrlEncodedContent(values);
var response = client.PostAsync("http://192.168.1.37/UnityBackendTutorial/insertRoutine.php", content).Result;
string resultContent = response.Content.ReadAsStringAsync().Result;
return(resultContent);
}
/*
* public string insertProfileRoutine(RoutinesEx routine,Profile profile,MySqlConnection connection){
* MySqlCommand cmd = connection.CreateCommand();
*
* cmd.CommandText= "INSERT INTO PlayerRoutines(idRoutine,creative,username,instrument) Values("+routine.id+","+
+routine.creative+",'"+ profile.username+"','"+profile.instrument+"');";
* MySqlDataReader reader = cmd.ExecuteReader();
*
*
* reader.Close();
* return null;
* }
*/
public string insertProfileRoutineM(RoutinesEx routine, Profile profile)
{
var values = new Dictionary <string, string>
{
{ "idRoutine", routine.id.ToString() },
{ "creative", routine.creative.ToString() },
{ "username", profile.username },
{ "instrument", profile.instrument },
};
var content = new FormUrlEncodedContent(values);
var response = client.PostAsync("http://192.168.1.37/UnityBackendTutorial/insertProfileRoutine.php", content).Result;
string resultContent = response.Content.ReadAsStringAsync().Result;
return(resultContent);
}
/*
* public RoutinesEx selectRoutineFromID(MySqlConnection connection,int idRoutine){
* MySqlCommand cmd = connection.CreateCommand();
* cmd.CommandText = "Select * From Routines Where idRoutine="+idRoutine+";";
* MySqlDataReader reader = cmd.ExecuteReader();
* RoutinesEx routine = null;
* while (reader.Read()){
* int _id_routine = reader.GetInt32(0);
* string _description = reader.GetString(1);
* string _finalDate = reader.GetDateTime(2).ToString();
* routine = new RoutinesEx(_id_routine,_description,_finalDate);
* }
* reader.Close();
* return routine;
* }
*/
public RoutinesEx selectRoutineFromIDM(int idRoutine)
{
var values = new Dictionary <string, string>
{
{ "idRoutine", idRoutine.ToString() },
};
var content = new FormUrlEncodedContent(values);
var response = client.PostAsync("http://192.168.1.37/UnityBackendTutorial/getRoutineFromID.php", content).Result;
string resultContent = response.Content.ReadAsStringAsync().Result;
var json = JSON.Parse(resultContent);
int _idRoutine = Int16.Parse(json["idRoutine"]);
string _description = json["description"];
string _finalDate = json["finalDate"];
RoutinesEx routine = new RoutinesEx(_idRoutine, _description, _finalDate);
return(routine);
}
