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(); } }