/// <summary> /// Carrega o artigo pelo id /// </summary> /// <param name="id"></param> /// <returns></returns> public static List <ArticleActionObservation> LoadAllFrom(ArticleAction na) { List <ArticleActionObservation> lst = new List <ArticleActionObservation>(); SqlCommand sel = new SqlCommand(); sel.CommandText = "SELECT userid, included, observation FROM " + Base.conf.prefix + "[newsarticleactionobservation] WHERE id=@id ORDER BY included"; sel.Parameters.Add(new SqlParameter("@id", na.id)); sel.Connection = Base.conf.Open(); SqlDataReader rdr = sel.ExecuteReader(); while (rdr.Read()) { // Pega as informações ArticleActionObservation ngo = new ArticleActionObservation(na); ngo.useridInt = rdr.GetString(0); ngo.includedInt = rdr.GetDateTime(1); ngo.observationInt = rdr.GetString(2); lst.Add(ngo); } rdr.Close(); sel.Connection.Close(); return(lst); }
/// <summary> /// Salva a ticket /// </summary> /// <returns></returns> public bool Save() { bool res = false; SqlCommand sel = new SqlCommand(); sel.CommandText = "SELECT id FROM " + Base.conf.prefix + "[newsarticleaction] WHERE id=@id"; sel.Parameters.Add(new SqlParameter("@id", id)); sel.Connection = Base.conf.Open(); SqlDataReader rdr = sel.ExecuteReader(); if (!rdr.Read()) { rdr.Close(); sel.Connection.Close(); SqlCommand ins = new SqlCommand(); ins.CommandText = "INSERT INTO " + Base.conf.prefix + "[newsarticleaction] (id, articleid, userid, type, observation, date, show, billablewords, text) VALUES (@id, @articleid, @userid, @type, @observation, @date, @show, @billablewords, @text)"; ins.Parameters.Add(new SqlParameter("@id", id)); ins.Parameters.Add(new SqlParameter("@articleid", article.id)); ins.Parameters.Add(new SqlParameter("@userid", useridInt)); ins.Parameters.Add(new SqlParameter("@type", typeInt)); ins.Parameters.Add(new SqlParameter("@observation", observationInt)); ins.Parameters.Add(new SqlParameter("@date", dateInt)); ins.Parameters.Add(new SqlParameter("@show", showInt)); ins.Parameters.Add(new SqlParameter("@billablewords", billablewordsInt)); ins.Parameters.Add(new SqlParameter("@text", textInt)); ins.Connection = Base.conf.Open(); ins.ExecuteNonQuery(); ins.Connection.Close(); res = true; dbassignedidInt = true; } else { rdr.Close(); sel.Connection.Close(); SqlCommand upd = new SqlCommand(); upd.CommandText = "UPDATE " + Base.conf.prefix + "[newsarticleaction] SET articleid=@articleid, userid=@userid, type=@type, observation=@observation, date=@date, show=@show, billablewords=@billablewords, text=@text WHERE id=@id"; upd.Parameters.Add(new SqlParameter("@articleid", article.id)); upd.Parameters.Add(new SqlParameter("@userid", useridInt)); upd.Parameters.Add(new SqlParameter("@type", typeInt)); upd.Parameters.Add(new SqlParameter("@observation", observationInt)); upd.Parameters.Add(new SqlParameter("@date", dateInt)); upd.Parameters.Add(new SqlParameter("@show", showInt)); upd.Parameters.Add(new SqlParameter("@billablewords", billablewordsInt)); upd.Parameters.Add(new SqlParameter("@text", textInt)); upd.Parameters.Add(new SqlParameter("@id", id)); upd.Connection = Base.conf.Open(); upd.ExecuteNonQuery(); upd.Connection.Close(); res = true; dbassignedidInt = true; } if (res) { if (grantsInt != null) { ArticleActionGrant.SaveAll(this, grants); } if (observationsInt != null) { ArticleActionObservation.SaveAll(this, observations); } } return(res); }