private hashtagDTO SetHashtag(SqlDataReader dr)
{
hashtagDTO obj = new hashtagDTO();
obj.id_hashtag = Convert.ToInt32(dr["id_hashtag"]);
obj.hashtag_name = dr["hashtag"].ToString();
return(obj);
}
public async Task <ActionResult <hashtagDTO> > PostHashtagItem(hashtagDTO item)
{
item.id_hashtag = new t_hashtag().Incluir(item.hashtag_name);
_context.hashtagItems.Add(item);
_context.SaveChanges();
new t_log().Incluir("[HttpPost]", "PostHashtagItem(hashtagDTO " + item.ToString() + ")", "INFO");
return(CreatedAtAction(nameof(GetHashtagItem), new { id = item.id_hashtag }, item));
}
public async Task <IActionResult> PutHashtagItem(long id, hashtagDTO item)
{
if (id != item.id_hashtag)
{
return(BadRequest());
}
new t_hashtag().Alterar(id, item.hashtag_name);
_context.Entry(item).State = EntityState.Modified;
_context.SaveChanges();
new t_log().Incluir("[HttpPut(\"{ id}\")]", "PutHashtagItem(long " + id.ToString() + ", hashtagDTO " + item.ToString() + ")", "INFO");
return(NoContent());
}
public hashtagDTO Consultar(long id_hashtag)
{
try
{
List <SqlParameter> parameters = new List <SqlParameter>();
string strSql = "pr_hashtag_consult";
parameters.Add(new SqlParameter("@id_hashtag", id_hashtag));
SqlDataReader dr = ExecuteAndGetReader(strSql.ToString(), parameters.ToArray(), CommandType.StoredProcedure);
hashtagDTO obj = new hashtagDTO();
if (dr.Read())
{
obj.id_hashtag = Convert.ToInt32(dr["id_hashtag"]);
obj.hashtag_name = dr["hashtag_name"].ToString();
}
dr.Close();
return(obj);
}
catch (Exception ex) { throw ex; }
finally { CloseConn(); }
}
