public JsonResult Cuantia(CuantiaDto collection) { try { var cuantia = string.Empty; smlv salario = db.smlv.Where(e => e.Ano == collection.fechaAno).FirstOrDefault(); int valorS = salario.Valor; if (valorS > 0) { if (collection.valor <= (valorS * 40)) { cuantia = "MÍNIMA"; } else if (collection.valor > (valorS * 40) && collection.valor <= (valorS * 150)) { cuantia = "MENOR"; } else if (collection.valor > (valorS * 150)) { cuantia = "MAYOR"; } } else { cuantia = "{mesage:'no hay un valor para el año'" + collection.fechaAno + "}"; } return(Json(cuantia)); } catch { return(Json("{mesage:'se encontro una exepción'}")); } }
// POST: odata/smlvs public async Task <IHttpActionResult> Post(smlv smlv) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.smlv.Add(smlv); await db.SaveChangesAsync(); return(Created(smlv)); }
// DELETE: odata/smlvs(5) public async Task <IHttpActionResult> Delete([FromODataUri] int key) { smlv smlv = await db.smlv.FindAsync(key); if (smlv == null) { return(NotFound()); } db.smlv.Remove(smlv); await db.SaveChangesAsync(); return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> Patch([FromODataUri] int key, Delta <smlv> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } smlv smlv = await db.smlv.FindAsync(key); if (smlv == null) { return(NotFound()); } patch.Patch(smlv); try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!smlvExists(key)) { return(NotFound()); } else { throw; } } return(Updated(smlv)); }