public async Task <IActionResult> PutDNagroda(string id, DNagroda dNagroda) { dNagroda.id = id; _context.Entry(dNagroda).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DNagrodaExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public IEnumerable <DNagroda> GetNagrody(string IdUser) { String asd = Configuration.GetConnectionString("DevConnection"); using (var conn = new SqlConnection(asd)) { SqlCommand cmd = new SqlCommand("Nagrody_User", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdUser", SqlDbType.NVarChar); cmd.Parameters["@IdUser"].Value = IdUser; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dr in dt.Rows) { DNagroda obj = new DNagroda(); obj.id = dr["id"].ToString(); obj.name = dr["Name"].ToString(); obj.description = dr["Description"].ToString(); obj.cost = Int32.Parse(dr["Cost"].ToString()); obj.ilosc = Int32.Parse(dr["Ilosc"].ToString()); obj.imageB = dr["ImageB"].ToString(); NagrodyGet.Add(obj); } } return(NagrodyGet);//new string[] { "value1", "value2" }; }
public async Task <ActionResult <DNagroda> > PostDNagroda(DNagroda dNagroda) { _context.DNagroda.Add(dNagroda); try { await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (DNagrodaExists(dNagroda.id)) { return(Conflict()); } else { throw; } } return(CreatedAtAction("GetDNagroda", new { id = dNagroda.id }, dNagroda)); }