public HttpResponseMessage Concluir(CadSolAlterProd obj)
        {
            var context = new AlvoradaContext();

            try
            {
                var result = context.CadSolAlterProdutos.Where(x => x.Id == obj.Id).FirstOrDefault();
                context.Entry(result).State = EntityState.Modified;
                result.IdStatus             = 6;
                var log = new CadSolAlterProdLog
                {
                    DataLog        = DateTime.Now,
                    IdSolAlterProd = obj.Id,
                    IdStatus       = 6,
                    IdUsuario      = obj.IdUsuario
                };
                context.CadSolAlterProdLogs.Add(log);
                context.SaveChanges();
            }
            catch (Exception ex)
            {
                return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new
                {
                    Error = ex.Message
                }));
            }

            return(Request.CreateResponse(HttpStatusCode.OK));
        }
        public HttpResponseMessage Excluir(CadSolAlterProd obj)
        {
            var context = new AlvoradaContext();

            try
            {
                context.Entry(obj).State = EntityState.Deleted;
                context.SaveChanges();
            }
            catch (Exception ex)
            {
                return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new
                {
                    Error = ex.Message
                }));
            }

            return(Request.CreateResponse(HttpStatusCode.OK));
        }
        public HttpResponseMessage Incluir(CadSolAlterProd obj)
        {
            var context      = new AlvoradaContext();
            var emailService = new EmailService();

            try
            {
                obj.DtInclusao = DateTime.Now;
                obj.IdStatus   = 1;
                context.CadSolAlterProdutos.Add(obj);
                context.SaveChanges();
                emailService.SendEmail("*****@*****.**", "Nova Alteração de Produto - Pendente", emailService.BodySolicitacaoCadastro());
            }

            catch (Exception ex)
            {
                throw ex;
            }

            //catch (DbEntityValidationException e)
            //{
            //    foreach (var eve in e.EntityValidationErrors)
            //    {
            //        Console.WriteLine("Entidade do tipo \"{0}\" no estado \"{1}\" tem os seguintes erros de validação:",
            //            eve.Entry.Entity.GetType().Name, eve.Entry.State);
            //        foreach (var ve in eve.ValidationErrors)
            //        {
            //            Console.WriteLine("- Property: \"{0}\", Erro: \"{1}\"",
            //                ve.PropertyName, ve.ErrorMessage);
            //        }
            //    }
            //    throw;
            //}

            return(Request.CreateResponse(HttpStatusCode.OK));
        }