public bool insertAti(CrudProp atiInsert) { string mainconn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mysqlconn = new MySqlConnection(mainconn); string sqlquery = "insert into atividade (nome, data_at, descricao ,avaliacao) values ('" + atiInsert.nome + "','" + atiInsert.data_at + "','" + atiInsert.descricao + "','" + atiInsert.avaliacao + "') "; MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn); mysqlconn.Open(); int i = sqlcomm.ExecuteNonQuery(); mysqlconn.Close(); if (i >= 1) { return(true); } else { return(false); } }
public bool editAtiInst(CrudProp atiEdit) { string mainconn = ConfigurationManager.ConnectionStrings["MysqlConnection"].ConnectionString; MySqlConnection mysqlconn = new MySqlConnection(mainconn); string sqlquery = "update atividade set descricao='" + atiEdit.descricao + "', nome = '" + atiEdit.nome + "' where id_atividade='" + atiEdit.id_atividade + "'"; MySqlCommand sqlcomm = new MySqlCommand(sqlquery, mysqlconn); mysqlconn.Open(); int i = sqlcomm.ExecuteNonQuery(); mysqlconn.Close(); if (i >= 1) { return(true); } else { return(false); } }