public HttpResponseMessage Concluir(CadSolProd obj)
        {
            var context = new AlvoradaContext();
            var result  = context.CadSolProdutos.Where(x => x.Id == obj.Id).FirstOrDefault();

            try
            {
                context.Entry(result).State = EntityState.Modified;
                result.IdStatus             = 6;
                var log = new CadSolProdLog
                {
                    IdCadSolProd = obj.Id,
                    IdStatus     = 6,
                    DataLog      = DateTime.Now,
                    IdUsuario    = obj.IdUsuario
                };
                context.CadSolProdLogs.Add(log);
                context.SaveChanges();
            }

            catch (Exception ex)
            {
                throw ex;
            }

            return(Request.CreateResponse(HttpStatusCode.OK));
        }
        public HttpResponseMessage AprovarDiretoria(CadSolProd obj)
        {
            var context      = new AlvoradaContext();
            var emailService = new EmailService();
            var result       = context.CadSolProdutos.Where(x => x.Id == obj.Id).FirstOrDefault();

            try
            {
                context.Entry(result).State = EntityState.Modified;
                result.IdStatus             = 4;
                var log = new CadSolProdLog
                {
                    IdCadSolProd = obj.Id,
                    IdStatus     = 4,
                    DataLog      = DateTime.Now,
                    IdUsuario    = obj.IdUsuario
                };
                context.CadSolProdLogs.Add(log);
                context.SaveChanges();
                //emailService.SendEmail("*****@*****.**", "Cadastro de Produto - Pendente");
                emailService.SendEmail("*****@*****.**", "Novo Cadastro de Produto - Pendente", emailService.BodySolicitacaoCadastro());
            }

            catch (Exception ex)
            {
                throw ex;
            }

            return(Request.CreateResponse(HttpStatusCode.OK));
        }
        public HttpResponseMessage ReprovarTodosDiretoria(List <CadSolProd> objs)
        {
            var context = new AlvoradaContext();

            try
            {
                foreach (var item in objs)
                {
                    var result = context.CadSolProdutos.Where(x => x.Id == item.Id).FirstOrDefault();

                    if (result.IdStatus == 2)
                    {
                        context.Entry(result).State = EntityState.Modified;
                        result.IdStatus             = 5;
                        var log = new CadSolProdLog
                        {
                            IdCadSolProd = item.Id,
                            IdStatus     = 5,
                            DataLog      = DateTime.Now,
                            IdUsuario    = item.IdUsuario
                        };
                        context.CadSolProdLogs.Add(log);
                        context.SaveChanges();
                        //emailService.SendEmail("*****@*****.**", "Aprovação de Cadastro de Produto - Pendente");
                    }
                }
            }

            catch (Exception ex)
            {
                throw ex;
            }

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

            try
            {
                obj.DataLog = DateTime.Now;
                context.CadSolProdLogs.Add(obj);
                context.SaveChanges();
            }

            catch (Exception ex)
            {
                return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new
                {
                    Error = ex.Message
                }));
            }

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