public HttpResponseMessage Incluir(CadSaldoControle model) { var context = new AlvoradaContext(); try { context.CadSaldosControle.Add(model); context.SaveChanges(); } catch (Exception ex) { throw ex; } return(Request.CreateResponse(HttpStatusCode.OK)); }
public HttpResponseMessage Excluir(CadSaldoControle model) { var context = new AlvoradaContext(); var result = context.CadSaldosControle.ToList().Where(x => x.DataInclusao.Date == model.DataInclusao.Date && x.IdUsuario == model.IdUsuario).FirstOrDefault(); var saldosPosteriores = context.CadSaldosControle.ToList().Where(x => x.DataInclusao.Date > model.DataInclusao.Date && x.IdUsuario == model.IdUsuario).ToList(); try { context.CadSaldosControle.Remove(result); context.CadSaldosControle.RemoveRange(saldosPosteriores); context.SaveChanges(); } catch (Exception ex) { return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new { Error = ex.Message })); } return(Request.CreateResponse(HttpStatusCode.OK)); }