/// <summary> /// Carrega o artigo pelo id /// </summary> /// <param name="id"></param> /// <returns></returns> public static List <TargetActionGrant> LoadAllFrom(TargetAction na) { List <TargetActionGrant> lst = new List <TargetActionGrant>(); SqlCommand sel = new SqlCommand(); sel.CommandText = "SELECT awardid, grantedby, granted FROM " + Base.conf.prefix + "[newstargetactiongrant] 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 TargetActionGrant nga = new TargetActionGrant(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> /// Adiciona um grant pelo usuário /// </summary> /// <param name="awardId"></param> /// <param name="userId"></param> public void AddGrant(string awardId, string userId) { for (int i = 0; i < grants.Count; i++) { if (grants[i].awardId == awardId) { return; } } TargetActionGrant tag = new TargetActionGrant(this); tag.awardId = awardId; tag.grantedById = userId; tag.granted = DateTime.Now; grants.Add(tag); profile.AddAward(awardId); }
/// <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 + "[newstargetaction] 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 + "[newstargetaction] (id, targetid, userid, type, observation, date, show) VALUES (@id, @targetid, @userid, @type, @observation, @date, @show)"; ins.Parameters.Add(new SqlParameter("@id", id)); ins.Parameters.Add(new SqlParameter("@targetid", target.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.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 + "[newstargetaction] SET targetid=@targetid, userid=@userid, type=@type, observation=@observation, date=@date, show=@show WHERE id=@id"; upd.Parameters.Add(new SqlParameter("@targetid", target.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("@id", id)); upd.Connection = Base.conf.Open(); upd.ExecuteNonQuery(); upd.Connection.Close(); res = true; dbassignedidInt = true; } if (res) { if (grantsInt != null) { TargetActionGrant.SaveAll(this, grants); } } return(res); }