public Boolean AddConfig(Configuracao cfg)
{
try
{
conn = new SqlConnection(strConn);
conn.Open();
var query = "INSERT INTO configuracao VALUES (@id, @SolucaoMax, @TaxaCrossover, @TaxaMutacao, 1, @TotalPopulacao, @totalGeracao);";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@id", cfg.IdConfig);
cmd.Parameters.AddWithValue("@SolucaoMax", cfg.SolucaoMax);
cmd.Parameters.AddWithValue("@TaxaCrossover", cfg.TaxaCrossover);
cmd.Parameters.AddWithValue("@TaxaMutacao", cfg.TaxaMutacao);
//cmd.Parameters.AddWithValue("@Eltimo", true);
cmd.Parameters.AddWithValue("@TotalPopulacao", cfg.TotalPopulacao);
cmd.Parameters.AddWithValue("@TotalGeracao", cfg.TotalGeracao);
return Convert.ToBoolean(cmd.ExecuteNonQuery());
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
private void carregarConfigs(int id)
{
DAO dao = new DAO();
config = dao.GetConfig(id);
if (config != null)
{
txtDefineSolucao.Text = config.SolucaoMax.ToString();
txtCrossover.Text = config.TaxaCrossover.ToString();
txtMutacao.Text = config.TaxaMutacao.ToString();
txtPopulacao.Text = config.TotalPopulacao.ToString();
txtGeracoes.Text = config.TotalGeracao.ToString();
config.IdConfig = id;
}
}
public static string salvarConfiguracoes(string solucao, string crossover, string mutacao, string populacao, string geracao)
{
try
{
DAO dao = new DAO();
if (config != null)
{
//Monta a config
config.SolucaoMax = Convert.ToDouble(solucao);
config.TaxaCrossover = Convert.ToDouble(crossover);
config.TaxaMutacao = Convert.ToDouble(mutacao);
//config.Eltismo = Convert.ToBoolean();
config.TotalPopulacao = Convert.ToInt32(populacao);
config.TotalGeracao = Convert.ToInt32(geracao);
config.IdConfig = Convert.ToInt32(HttpContext.Current.Session["idUsuario"]);
dao.EdtConfig(config); //existe, update!
}
else
{
config = new Configuracao();
//Monta a config
config.SolucaoMax = Convert.ToDouble(solucao);
config.TaxaCrossover = Convert.ToDouble(crossover);
config.TaxaMutacao = Convert.ToDouble(mutacao);
//config.Eltismo = Convert.ToBoolean();
config.TotalPopulacao = Convert.ToInt32(populacao);
config.TotalGeracao = Convert.ToInt32(geracao);
config.IdConfig = Convert.ToInt32(HttpContext.Current.Session["idUsuario"]); //add a ID na config pois ainda nao existe no banco
dao.AddConfig(config); //não existe, insert!
}
return "True";
}
catch (Exception ex)
{
return ex.Message;
}
}
public Boolean EdtConfig(Configuracao cfg)
{
try
{
conn = new SqlConnection(strConn);
conn.Open();
var query = "UPDATE configuracao SET SolucaoMax = @SolucaoMax, TaxaCrossover = @TaxaCrossover, TaxaMutacao = @TaxaMutacao, TotalPopulacao = @TotalPopulacao, TotalGeracao = @TotalGeracao WHERE IdUser = @id";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@SolucaoMax", cfg.SolucaoMax);
cmd.Parameters.AddWithValue("@TaxaCrossover", Convert.ToDouble(cfg.TaxaCrossover));
cmd.Parameters.AddWithValue("@TaxaMutacao", Convert.ToDouble(cfg.TaxaMutacao));
//cmd.Parameters.AddWithValue("@Eltimo", true);
cmd.Parameters.AddWithValue("@TotalPopulacao", cfg.TotalPopulacao);
cmd.Parameters.AddWithValue("@TotalGeracao", cfg.TotalGeracao);
cmd.Parameters.AddWithValue("@id", cfg.IdConfig);
return Convert.ToBoolean(cmd.ExecuteNonQuery());
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
