public bool editsug(SugestoesProp sugedit)
{
string mainconn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mysqlconn = new MySqlConnection(mainconn);
string sqlquery = "update sugestao set sug='" + sugedit.sug + "' where id_sug='" + sugedit.id_sug + "'";
MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn);
mysqlconn.Open();
int i = sqlcomm.ExecuteNonQuery();
mysqlconn.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
public bool insertsug(SugestoesProp suginsert)
{
string mainconn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString;
MySqlConnection mysqlconn = new MySqlConnection(mainconn);
string sqlquery = "insert into sugestao (id_sug, id_crianca, id_inst, sug) values ('" + suginsert.id_sug + "', '" + suginsert.id_crianca + "','" + suginsert.id_inst + "', '" + suginsert.sug + "')";
MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn);
mysqlconn.Open();
int i = sqlcomm.ExecuteNonQuery();
mysqlconn.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}