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(); } }