public HttpResponseMessage Desbaixar([FromBody] CadSolDesp obj)
{
var context = new AlvoradaContext();
try
{
var result = context.CadSolicitacoesDesp.Where(x => x.IdCadSolDesp == obj.IdCadSolDesp).FirstOrDefault();
result.Baixa = false;
result.DataBaixa = null;
context.SaveChanges();
}
catch (Exception ex)
{
return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new
{
Error = ex.Message
}));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage AprovarReprovar([FromBody] CadSolDesp obj)
{
var context = new AlvoradaContext();
obj.DataAprovacao = DateTime.Now;
try
{
context.Entry(obj).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex)
{
return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new
{
Error = ex.Message
}));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Excluir(IEnumerable <CadAssProdGrade> models)
{
var context = new AlvoradaContext();
try
{
foreach (var item in models)
{
context.Entry(item).State = EntityState.Deleted;
}
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage GetGetByIdProdutoExcluir(int IdCadSolProd)
{
var context = new AlvoradaContext();
try
{
var result = context.CadSolProdGrades.Where(x => x.IdCadSolProd == IdCadSolProd).ToList();
foreach (var item in result)
{
context.CadSolProdGrades.Remove(item);
}
context.SaveChanges();
}
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));
}
public HttpResponseMessage IncluirTodos([FromBody] List <AlertaHistorico> models)
{
context = new AlvoradaContext();
try
{
foreach (var item in models)
{
item.DataDoHistorico = DateTime.Now;
context.AlertasHistorico.Add(item);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage AlterarSugestao(SugestaoAbastecimento obj)
{
var context = new AlvoradaContext();
//var result = context.SugestoesAbastecimento.Where(x => x.cdPessoaFilial == obj.cdPessoaFilial && x.cdPromocao == obj.cdPromocao && x.cdProduto == obj.cdProduto).First();
try
{
//context.Entry(result).State = EntityState.Modified;
//result.sugestaoComprador = obj.sugestaoComprador;
context.SugestoesAbastecimento.Attach(obj);
var entry = context.Entry(obj);
entry.Property(e => e.sugestaoComprador).IsModified = true;
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage AprovarTodosDiretoria(List <CadSolProd> objs)
{
var context = new AlvoradaContext();
var emailService = new EmailService();
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 = 4;
var log = new CadSolProdLog
{
IdCadSolProd = item.Id,
IdStatus = 4,
DataLog = DateTime.Now,
IdUsuario = item.IdUsuario
};
context.CadSolProdLogs.Add(log);
context.SaveChanges();
//emailService.SendEmail("*****@*****.**", "Aprovação de 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 Register(Usuario model)
{
var context = new AlvoradaContext();
try
{
model.PasswordHash = Crypto.HashPassword(model.PasswordHash);
model.DataInclusao = DateTime.Now;
context.Usuarios.Add(model);
context.SaveChanges();
}
catch (Exception ex)
{
return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new
{
Error = ex.Message
}));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Incluir([FromBody] CadSolProd obj)
{
var context = new AlvoradaContext();
var emailService = new EmailService();
try
{
obj.IdStatus = 1;
obj.DataCriacao = DateTime.Now;
context.CadSolProdutos.Add(obj);
context.SaveChanges();
emailService.SendEmail("*****@*****.**", "Nova Aprovação de Cadastro de Produto - Pendente", emailService.BodySolicitacaoCadastro());
//emailService.SendEmail("*****@*****.**", "Aprovação de Cadastro de Produto - Pendente");
//emailService.SendEmail("*****@*****.**", "Nova Aprovação de Cadastro de Produto - Pendente");
}
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;
}
//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));
}
public HttpResponseMessage IncluirTodos(List <AlertaQuarentena> models)
{
var context = new AlvoradaContext();
try
{
foreach (var item in models)
{
item.Dias = 30;
item.DtInclusao = DateTime.Now;
item.DtSaida = DateTime.Now.AddDays(item.Dias);
context.AlertasQuarentena.Add(item);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage ChangePassword2(Usuario model)
{
var context = new AlvoradaContext();
var result = context.Usuarios.Where(x => x.PasswordHash == model.PasswordHash).FirstOrDefault();
if (result != null)
{
try
{
result.PasswordHash = Crypto.HashPassword(model.Nome);
context.Entry(result).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public HttpResponseMessage Incluir([FromBody] CadSolDesp obj)
{
var context = new AlvoradaContext();
try
{
obj.DataInclusao = DateTime.Now;
context.CadSolicitacoesDesp.Add(obj);
context.SaveChanges();
}
//catch (DbEntityValidationException e)
//{
// foreach (var eve in e.EntityValidationErrors)
// {
// var erro = eve.Entry.Entity.GetType().Name;
// var state = eve.Entry.State;
// foreach (var ve in eve.ValidationErrors)
// {
// var property = ve.PropertyName;
// var erroprop = ve.ErrorMessage;
// }
// }
// throw;
//}
catch (Exception ex)
{
return(Request.CreateResponse <dynamic>(HttpStatusCode.InternalServerError, new
{
Error = ex.Message
}));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public void GetAllTerceiroNivel(int ano, int mes, string filial)
{
var context = new AlvoradaContext();
var result = context.VwLancamentoContabilRaizThree.Where(x => x.Ano == ano && x.MesNumber == mes &&
x.nmPessoa == filial).ToList().OrderBy(x => x.CodigoContabil);
foreach (var item in result)
{
terceiroNivel.Add(new TerceiroNivelDTO
{
Ano = item.Ano,
id = item.CodigoContabil,
MesNumber = item.MesNumber,
nmPessoa = item.nmPessoa,
NomeContabil = item.NomeContabil,
Valor = item.Valor,
ValorMesAnt = item.ValorMesAnt,
ValorAnoAnt = item.ValorAnoAnt,
Row = item.Row,
CodigoContabilPai = item.CodigoContabilPai
});
}
}
public CadSaldoControle GetSaldoByUserAndDate(int idUsuario, DateTime date)
{
var context = new AlvoradaContext();
var dataOntem = date.AddDays(-1);
var dataAnteOntem = date.AddDays(-2);
var dataTresontonte = date.AddDays(-3);
var dataQuatroontonte = date.AddDays(-4);
var dataCincoontonte = date.AddDays(-5);
var result = context.CadSaldosControle.Where(x => x.IdUsuario == idUsuario &&
x.DataInclusao == dataOntem).FirstOrDefault();
if (result == null)
{
result = context.CadSaldosControle.Where(x => x.IdUsuario == idUsuario &&
x.DataInclusao == dataAnteOntem).FirstOrDefault();
}
if (result == null)
{
result = context.CadSaldosControle.Where(x => x.IdUsuario == idUsuario &&
x.DataInclusao == dataTresontonte).FirstOrDefault();
}
if (result == null)
{
result = context.CadSaldosControle.Where(x => x.IdUsuario == idUsuario &&
x.DataInclusao == dataQuatroontonte).FirstOrDefault();
}
if (result == null)
{
result = context.CadSaldosControle.Where(x => x.IdUsuario == idUsuario &&
x.DataInclusao == dataCincoontonte).FirstOrDefault();
}
return(result);
}
public IEnumerable <Usuario> GetAllTI()
{
var context = new AlvoradaContext();
return(context.Usuarios.Where(x => x.Grupo.FirstOrDefault().Nome == "TI").ToList());
}
public IEnumerable <AlertaQuarentena> GetAll()
{
var context = new AlvoradaContext();
return(context.AlertasQuarentena.ToList());
}
public IEnumerable <LogAlteracaoAbastecimento> GetBetweenDates(DateTime dtinicio, DateTime dtfim)
{
var context = new AlvoradaContext();
return(context.LogAlteracaoAbastecimento.Where(x => x.Data >= dtinicio && x.Data <= dtfim));
}
public IEnumerable <CadCaixaControle> GetAll()
{
var context = new AlvoradaContext();
return(context.CadCaixasControle.ToList());
}
public ParametroAbastecimento GetParametroByPromocao(int codigo)
{
var context = new AlvoradaContext();
return(context.ParametrosAbastecimento.Where(x => x.cdPromocao == codigo).FirstOrDefault());
}
public CadSolProd GetByID(int Id)
{
var context = new AlvoradaContext();
return(context.CadSolProdutos.Where(x => x.Id == Id).FirstOrDefault());
}
public IEnumerable <CadSolProd> GetAllAproveByDiretoria()
{
var context = new AlvoradaContext();
return(context.CadSolProdutos.Where(x => x.IdStatus == 4).ToList());
}
public IEnumerable <CadUsuarioOperadorLog> GetAllByUser(int idUsuario)
{
var context = new AlvoradaContext();
return(context.CadUsuarioOperadorLogs.Where(x => x.IdUsuario == idUsuario).ToList());
}
public IEnumerable <ParametroAbastecimento> GetAllParametro()
{
var context = new AlvoradaContext();
return(context.ParametrosAbastecimento);
}
public IEnumerable <Usuario> GetAllDPLojas()
{
var context = new AlvoradaContext();
return(context.Usuarios.Where(x => x.Grupo.FirstOrDefault().Nome == "DP/RH Loja" || x.Nome == "Deposito").ToList());
}
public IEnumerable <CadUsuarioOperadorLog> GetAll()
{
var context = new AlvoradaContext();
return(context.CadUsuarioOperadorLogs.ToList());
}
public IEnumerable <CadSolProd> GetAll()
{
var context = new AlvoradaContext();
return(context.CadSolProdutos.Take(500).OrderByDescending(x => x.Id).ToList());
}
public IEnumerable <CadUsuarioOperadorLog> GetAllById(int IdUsuLog)
{
var context = new AlvoradaContext();
return(context.CadUsuarioOperadorLogs.Where(x => x.IdCadUsuOpe == IdUsuLog).ToList());
}
public IEnumerable <CadSolProd> GetAllByStatus(int idStatus, DateTime dtInicio, DateTime dtFim)
{
var context = new AlvoradaContext();
return(context.CadSolProdutos.Where(x => x.IdStatus == idStatus && x.DataCriacao >= dtInicio && x.DataCriacao <= dtFim).Take(500).OrderByDescending(x => x.Id));
}
