public async Task <IHttpActionResult> Getassistir(int id)
{
assistir assistir = await db.assistir.FindAsync(id);
if (assistir == null)
{
return(NotFound());
}
return(Ok(assistir));
}
public async Task <IHttpActionResult> Deleteassistir(int id)
{
assistir assistir = await db.assistir.FindAsync(id);
if (assistir == null)
{
return(NotFound());
}
db.assistir.Remove(assistir);
await db.SaveChangesAsync();
return(Ok(assistir));
}
public async Task <IHttpActionResult> DeleteAssistirUser(int id_soci, int id_esdeveniment)
{
assistir assistir = await db.assistir.Where(a => a.id_soci == id_soci && a.id_esdeveniment == id_esdeveniment).FirstOrDefaultAsync();
if (assistir == null)
{
return(NotFound());
}
db.assistir.Remove(assistir);
await db.SaveChangesAsync();
return(Ok(assistir));
}
public async Task <IHttpActionResult> Putassistir(int id, assistir assistir)
{
IHttpActionResult result;
String missatge = "";
if (!ModelState.IsValid)
{
result = BadRequest(ModelState);
}
else
{
if (id != assistir.id_soci)
{
result = BadRequest();
}
db.Entry(assistir).State = EntityState.Modified;
result = StatusCode(HttpStatusCode.NoContent);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!assistirExists(id))
{
result = NotFound();
}
else
{
throw;
}
}
catch (DbUpdateException ex)
{
SqlException sqlException = (SqlException)ex.InnerException.InnerException;
missatge = CLASES.Utilitat.missatgeError(sqlException);
result = BadRequest(missatge);
}
}
return(result);
}
public async Task <IHttpActionResult> Postassistir(assistir assistir)
{
IHttpActionResult result;
String missatge = "";
if (!ModelState.IsValid)
{
result = BadRequest(missatge);
}
else
{
db.assistir.Add(assistir);
result = CreatedAtRoute("DefaultApi", new { id = assistir.id_soci }, assistir);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (assistirExists(assistir.id_soci))
{
result = Conflict();
}
else
{
throw;
}
}
catch (DbUpdateException ex)
{
SqlException sqlException = (SqlException)ex.InnerException.InnerException;
missatge = CLASES.Utilitat.missatgeError(sqlException);
result = BadRequest(missatge);
}
}
return(result);
}
