/// <summary>
/// Call next speaker param
/// For DESIGNER and USER use
/// </summary>
/// <param name="simulationId"></param>
/// <param name="nextSpeaker"></param>
public void callNextSpeaker(int simulationId, string nextSpeaker)
{
TSimulation tSimulation = getSimulation(simulationId);
tSimulation.next_speaker = nextSpeaker;
setSimulation(tSimulation);
}
/// <summary>
/// Return a specific simulation
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public TSimulation getSimulation(int id)
{
//--Data Base Access Variables--
MySql.Data.MySqlClient.MySqlConnection dbConnection = new MySql.Data.MySqlClient.MySqlConnection(connectionString);
MySql.Data.MySqlClient.MySqlCommand dbCommand = new MySql.Data.MySqlClient.MySqlCommand();
MySql.Data.MySqlClient.MySqlDataReader dbDataReader;
dbCommand.Connection = dbConnection;
//------------------------------
dbCommand.CommandText = "SELECT * FROM TB_SIMULATIONS WHERE (id = " + id + ")";
try
{
dbConnection.Open();
TSimulation tSimulation;
dbDataReader = dbCommand.ExecuteReader();
dbDataReader.Read();
tSimulation = new TSimulation(Convert.ToInt32(dbDataReader["id"]), dbDataReader["user_id"].ToString(), dbDataReader["designer_id"].ToString(), dbDataReader["next_speaker"].ToString(), dbDataReader["status"].ToString());
tSimulation.startDateTime = Convert.ToDateTime(dbDataReader["startDateTime"]);
if (dbDataReader["finishDateTime"].ToString() != "")
{
tSimulation.finishDateTime = Convert.ToDateTime(dbDataReader["finishDateTime"]);
}
dbDataReader.Close();
dbConnection.Close();
return(tSimulation);
}
catch (Exception e)
{
dbConnection.Close();
System.Threading.Thread.Sleep(20000);
return(null);
}
}
public void cancelSimulation(int id)
{
TSimulation tSimulation = getSimulation(id);
tSimulation.status = "canceled";
tSimulation.finishDateTime = DateTime.Now;
setSimulation(tSimulation);
}
/// <summary>
/// Fisnish Simulation
/// </summary>
/// <param name="id">Simulation Id</param>
public void finishSimulation(int id)
{
TSimulation tSimulation = getSimulation(id);
tSimulation.status = "close";
tSimulation.finishDateTime = DateTime.Now;
setSimulation(tSimulation);
}
/// <summary>
/// Check if next speaker is the SPEAKER paran
/// For DESGINER and USER use
/// </summary>
/// <param name="simulationId"></param>
/// <param name="speaker"></param>
/// <returns></returns>
public bool checkNextSpeaker(int simulationId, string speaker)
{
TSimulation tSimulation = getSimulation(simulationId);
if (tSimulation.next_speaker == speaker)
{
return(true);
}
return(false);
}
private void btnStart_Click(object sender, EventArgs e)
{
TSimulation tSimulation = (TSimulation)listBoxUsers.SelectedItem;
DbControl.getInstance().startSimulation(tSimulation, txtDesignerId.Text);
simulationId = tSimulation.id;
FormInteractionSimulation formInteractionSimulation = new FormInteractionSimulation();
formInteractionSimulation.setXmlFile(txtMoLIXFile.Text);
formInteractionSimulation.setSimulationId(simulationId);
formInteractionSimulation.setSpeaker(speaker);
formInteractionSimulation.setNextSpeaker(nextSpeaker);
formInteractionSimulation.Show();
this.Hide();
}
/// <summary>
/// Set Simulation
/// For USER and DESIGNER use
/// </summary>
/// <param name="tSimulation"></param>
/// <returns></returns>
public bool setSimulation(TSimulation tSimulation)
{
//--Data Base Access Variables--
MySql.Data.MySqlClient.MySqlCommand dbCommand = new MySql.Data.MySqlClient.MySqlCommand();
MySql.Data.MySqlClient.MySqlConnection dbConnection = new MySql.Data.MySqlClient.MySqlConnection(connectionString);
dbCommand.Connection = dbConnection;
//------------------------------
dbCommand.CommandText = "UPDATE TB_SIMULATIONS SET user_id = '" + tSimulation.user_id + "', designer_id = '" + tSimulation.designer_id + "', next_speaker = '" + tSimulation.next_speaker + "', status = '" + tSimulation.status + "', startDateTime = '" + tSimulation.startDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "', finishDateTime = '" + tSimulation.finishDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "' WHERE id = " + tSimulation.id.ToString();
try
{
dbConnection.Open();
dbCommand.ExecuteNonQuery();
dbConnection.Close();
return(true);
}
catch (Exception e)
{
dbConnection.Close();
System.Threading.Thread.Sleep(20000);
return(false);
}
}
/// <summary>
/// Start Simulation
/// For DESIGNER use
/// </summary>
/// <param name="tSimulation"></param>
/// <param name="designerId"></param>
public void startSimulation(TSimulation tSimulation, string designerId)
{
tSimulation.designer_id = designerId;
tSimulation.status = "established";
setSimulation(tSimulation);
}
