void CreateMissionEntry(MissaoUsuario mission)
{
GameObject go = Instantiate(_missionEntryPrefab);
var tmp = go.GetComponent <MissionDisplay>();
tmp.Mission = mission;
tmp.name = mission.codigo;
tmp.transform.SetParent(gameObject.transform);
tmp.transform.localEulerAngles = new Vector3(0, 0, 0);
tmp.transform.localScale = new Vector3(1, 1, 1);
}
public static bool InsertMissaoUsuario(MissaoUsuario missaoUsuario)
{
bool ok = true;
try
{
IDbConnection objConexao;
IDbCommand objComando;
objConexao = Mapped.Connection();
string query = "";
query += "INSERT ";
query += " INTO MISSAO_USUARIO ( ";
query += " MUS_DT_ATRIBUICAO, ";
query += " MUS_DT_CONCLUSAO, ";
query += " MUS_STATUS, ";
query += " MIS_ID, ";
query += " USU_ID ";
query += " ) ";
query += "VALUES ( ";
query += " ?MUS_DT_ATRIBUICAO, ";
query += " ?MUS_DT_CONCLUSAO, ";
query += " ?MUS_STATUS, ";
query += " ?MIS_ID, ";
query += " ?USU_ID ";
query += " ); ";
objComando = Mapped.Command(query, objConexao);
objComando.Parameters.Add(Mapped.Parameter("?mus_dt_atribuicao", missaoUsuario.DtAtribuicao));
objComando.Parameters.Add(Mapped.Parameter("?mus_dt_conclusao", missaoUsuario.DtConclusao));
objComando.Parameters.Add(Mapped.Parameter("?mus_status", missaoUsuario.Status.ToString()));
objComando.Parameters.Add(Mapped.Parameter("?mis_id", missaoUsuario.Missao.Id));
objComando.Parameters.Add(Mapped.Parameter("?usu_id", missaoUsuario.Usuario.Usu_id));
objComando.ExecuteNonQuery();
objConexao.Dispose();
objComando.Dispose();
}
catch (Exception e)
{
Console.Write(e);
ok = false;
}
return(ok);
}
public static bool concluirMissao(MissaoUsuario missaoUsuario)
{
bool ok = true;
try
{
IDbConnection objConexao;
IDbCommand objComando;
objConexao = Mapped.Connection();
string query = "";
query += " UPDATE ";
query += " MISSAO_USUARIO ";
query += " SET ";
query += " MUS_STATUS = ?mus_status, ";
query += " MUS_DT_CONCLUSAO = ?dt_conclusao ";
query += " WHERE ";
query += " MUS_ID = ?mus_id; ";
objComando = Mapped.Command(query, objConexao);
objComando.Parameters.Add(Mapped.Parameter("?mus_status", missaoUsuario.Status.ToString()));
objComando.Parameters.Add(Mapped.Parameter("?mus_id", missaoUsuario.Id));
objComando.Parameters.Add(Mapped.Parameter("?dt_conclusao", missaoUsuario.DtConclusao));
objComando.ExecuteNonQuery();
objConexao.Dispose();
objComando.Dispose();
}
catch (Exception e)
{
Console.Write(e);
ok = false;
}
return(ok);
}
