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