public void DeleteDepartamento(Rule depto)
{
FPFContext contexto = new FPFContext();
contexto.Entry(depto).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
contexto.Rules.Remove(depto);
contexto.SaveChanges();
}
public void DeleteFuncionario(Employee depto)
{
FPFContext contexto = new FPFContext();
contexto.Entry(depto).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
contexto.Employees.Remove(depto);
contexto.SaveChanges();
}
public void EditFuncionario(Employee depto)
{
FPFContext contexto = new FPFContext();
depto.ModifiedAt = DateTime.Now;
depto.CreatedAt = depto.CreatedAt;
contexto.Entry(depto).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
contexto.SaveChanges();
}
public void EditDepartamento(Rule depto)
{
FPFContext contexto = new FPFContext();
depto.ModifiedAt = DateTime.Now;
depto.CreatedAt = depto.CreatedAt;
contexto.Entry(depto).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
contexto.SaveChanges();
}
public void AddDepartamento(Rule depto)
{
FPFContext contexto = new FPFContext();
var cont = GetAllDepartamento().Count();
depto.Id = cont + 1;
depto.CreatedAt = DateTime.Now;
depto.ModifiedAt = DateTime.MinValue;
contexto.Rules.Add(depto);
contexto.SaveChanges();
}
public void AddFuncionario(Employee depto)
{
FPFContext contexto = new FPFContext();
var cont = GetAllFuncionario().Count();
depto.Id = cont + 1;
depto.CreatedAt = DateTime.Now;
depto.ModifiedAt = DateTime.MinValue;
depto.Salary = Convert.ToInt32(depto.Salary);
contexto.Employees.Add(depto);
contexto.SaveChanges();
}
public Employee GetFuncionarioById(int deptoId)
{
FPFContext contexto = new FPFContext();
return(contexto.Employees.Where(o => o.Id == deptoId).FirstOrDefault());
}
public IEnumerable <Employee> GetAllFuncionario()
{
FPFContext contexto = new FPFContext();
return(contexto.Employees);
}
public Rule GetDepartamentoById(int deptoId)
{
FPFContext contexto = new FPFContext();
return(contexto.Rules.Where(o => o.Id == deptoId).FirstOrDefault());
}
public List <Rule> CarregaDepartamento()
{
FPFContext contexto = new FPFContext();
return(contexto.Rules.ToList());
}
public IEnumerable <Rule> GetAllDepartamento()
{
FPFContext contexto = new FPFContext();
return(contexto.Rules);
}
