/// <summary> /// Carrega o artigo pelo id /// </summary> /// <param name="id"></param> /// <returns></returns> public static List <ArticleActionGrant> LoadAllFrom(ArticleAction na) { List <ArticleActionGrant> lst = new List <ArticleActionGrant>(); SqlCommand sel = new SqlCommand(); sel.CommandText = "SELECT awardid, grantedby, granted FROM " + Base.conf.prefix + "[newsarticleactiongrant] WHERE id=@id ORDER BY granted"; sel.Parameters.Add(new SqlParameter("@id", na.id)); sel.Connection = Base.conf.Open(); SqlDataReader rdr = sel.ExecuteReader(); while (rdr.Read()) { // Pega as informações ArticleActionGrant nga = new ArticleActionGrant(na); nga.awardidInt = rdr.GetString(0); nga.grantedById = rdr.GetString(1); nga.granted = rdr.GetDateTime(2); lst.Add(nga); } rdr.Close(); sel.Connection.Close(); return(lst); }
/// <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> /// Cria novo /// </summary> public ArticleActionGrant(ArticleAction n) { articleactionInt = n; awardidInt = ""; grantedbyInt = ""; grantedInt = RacMsg.NullDateTime; }
/// <summary> /// Cria novo /// </summary> public ArticleActionObservation(ArticleAction n) { articleactionInt = n; useridInt = ""; observationInt = ""; includedInt = RacMsg.NullDateTime; }
/// <summary> /// Salva a ticket /// </summary> /// <returns></returns> public static bool SaveAll(ArticleAction na, List <ArticleActionGrant> lst) { bool res = false; SqlCommand del = new SqlCommand(); del.CommandText = "DELETE FROM " + Base.conf.prefix + "[newsarticleactiongrant] WHERE id=@id"; del.Parameters.Add(new SqlParameter("@id", na.id)); del.Connection = Base.conf.Open(); del.ExecuteNonQuery(); del.Connection.Close(); SqlCommand ins = new SqlCommand(); ins.CommandText = "INSERT INTO " + Base.conf.prefix + "[newsarticleactiongrant] (id, awardid, grantedby, granted) VALUES (@id, @awardid, @grantedby, @granted)"; ins.Parameters.Add(new SqlParameter("@id", na.id)); SqlParameter varAttribute = new SqlParameter("@awardid", "0"); ins.Parameters.Add(varAttribute); SqlParameter varGrantedBy = new SqlParameter("@grantedby", "0"); ins.Parameters.Add(varGrantedBy); SqlParameter varGranted = new SqlParameter("@granted", DateTime.Now); ins.Parameters.Add(varGranted); ins.Connection = Base.conf.Open(); for (int i = 0; i < lst.Count; i++) { varAttribute.Value = lst[i].awardidInt; varGrantedBy.Value = lst[i].grantedbyInt; varGranted.Value = lst[i].grantedInt; ins.ExecuteNonQuery(); } ins.Connection.Close(); return(res); }
/// <summary> /// Salva a ticket /// </summary> /// <returns></returns> public static bool SaveAll(ArticleAction na, List <ArticleActionObservation> lst) { bool res = false; SqlCommand del = new SqlCommand(); del.CommandText = "DELETE FROM " + Base.conf.prefix + "[newsarticleactionobservation] WHERE id=@id"; del.Parameters.Add(new SqlParameter("@id", na.id)); del.Connection = Base.conf.Open(); del.ExecuteNonQuery(); del.Connection.Close(); SqlCommand ins = new SqlCommand(); ins.CommandText = "INSERT INTO " + Base.conf.prefix + "[newsarticleactionobservation] (id, userid, included, observation) VALUES (@id, @userid, @included, @observation)"; ins.Parameters.Add(new SqlParameter("@id", na.id)); SqlParameter varObservation = new SqlParameter("@observation", "0"); ins.Parameters.Add(varObservation); SqlParameter varUserId = new SqlParameter("@userid", "0"); ins.Parameters.Add(varUserId); SqlParameter varIncluded = new SqlParameter("@included", DateTime.Now); ins.Parameters.Add(varIncluded); ins.Connection = Base.conf.Open(); for (int i = 0; i < lst.Count; i++) { varObservation.Value = lst[i].observationInt; varUserId.Value = lst[i].useridInt; varIncluded.Value = lst[i].includedInt; ins.ExecuteNonQuery(); } ins.Connection.Close(); return(res); }
public ValuesPerVideoPerUser(RacLib.RacMsg msgs, LibVisLib.ArticleAction act) { Id = act.id; Title = act.article.title; Date = msgs.ShowDate(act.article.released); switch (act.type) { case ArticleAction.ActionType.Suggested: Role = msgs.Get(RacLib.RacMsg.Id.Suggested); break; case ArticleAction.ActionType.Created: Role = msgs.Get(RacLib.RacMsg.Id.Writer); break; case ArticleAction.ActionType.Approved: Role = msgs.Get(RacLib.RacMsg.Id.Approver); break; case ArticleAction.ActionType.Revised: Role = msgs.Get(RacLib.RacMsg.Id.Revisor); break; case ArticleAction.ActionType.IncludedNaration: Role = msgs.Get(RacLib.RacMsg.Id.Narrator); break; case ArticleAction.ActionType.Produced: Role = msgs.Get(RacLib.RacMsg.Id.Producer); break; case ArticleAction.ActionType.Published: Role = msgs.Get(RacLib.RacMsg.Id.Publisher); break; } Word = act.billableWords; Total = act.value; }