/// <summary>
/// Carrega o artigo pelo id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static List <VideoActionGrant> LoadAllFrom(VideoAction na)
{
List <VideoActionGrant> lst = new List <VideoActionGrant>();
SqlCommand sel = new SqlCommand();
sel.CommandText = "SELECT awardid, grantedby, granted FROM " + Base.conf.prefix + "[newsvideoactiongrant] WHERE id=@id ORDER BY granted";
sel.Parameters.Add(new SqlParameter("@id", na.id));
sel.Connection = Base.conf.Open();
SqlDataReader rdr = sel.ExecuteReader();
if (rdr.Read())
{
// Pega as informações
VideoActionGrant nga = new VideoActionGrant(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>
/// Salva a ação
/// </summary>
/// <returns></returns>
public bool Save()
{
bool res = false;
SqlCommand sel = new SqlCommand();
sel.CommandText = "SELECT id FROM " + Base.conf.prefix + "[newsvideoaction] 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 + "[newsvideoaction] (id, videoid, userid, type, observation, date, show) VALUES (@id, @videoid, @userid, @type, @observation, @date, @show)";
ins.Parameters.Add(new SqlParameter("@id", id));
ins.Parameters.Add(new SqlParameter("@videoid", video.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 + "[newsvideoaction] SET videoid=@videoid, userid=@userid, type=@type, observation=@observation, date=@date, show=@show WHERE id=@id";
upd.Parameters.Add(new SqlParameter("@videoid", video.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)
{
VideoActionGrant.SaveAll(this, grants);
}
}
return(res);
}