Example #1
0
        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));
        }
Example #2
0
        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));
        }