public Entities.tb_employees VerificarRecuperação(Entities.tb_employees employees)
{
Entities.tb_employees verificar = db.tb_employees.FirstOrDefault(l => l.nr_cpf == employees.nr_cpf ||
l.nr_rg == employees.nr_rg ||
l.nr_cellphone == employees.nr_cellphone);
return(verificar);
}
public void Alterar(Entities.tb_employees emp, int id)
{
Entities.tb_employees tb = db.tb_employees.FirstOrDefault(t => t.id_emp == id);
tb.nm_firstName = emp.nm_firstName;
tb.nm_lastName = emp.nm_lastName;
tb.nr_cpf = emp.nr_cpf;
tb.nr_rg = emp.nr_rg;
tb.nr_dependents = emp.nr_dependents;
tb.ds_sex = emp.ds_sex;
tb.dt_birth = emp.dt_birth;
tb.ds_state = emp.ds_state;
tb.nr_cep = emp.nr_cep;
tb.ds_address = emp.ds_address;
tb.ds_note = emp.ds_note;
tb.nr_cellphone = emp.nr_cellphone;
tb.nr_tellphone = emp.nr_tellphone;
tb.ds_email = emp.ds_email;
tb.pw_password = emp.pw_password;
tb.dt_hiring = emp.dt_hiring;
tb.dt_resignation = emp.dt_resignation;
tb.bt_employee = emp.bt_employee;
tb.bt_manager = emp.bt_manager;
tb.bt_crm = emp.bt_crm;
tb.bt_provider = emp.bt_provider;
tb.bt_stock = emp.bt_stock;
tb.bt_rh = emp.bt_rh;
tb.bt_financial = emp.bt_financial;
db.SaveChanges();
}
public void ConsultarPorFunc(string func)
{
List <Entities.tb_deptfunction> listFunc = db.tb_deptfunction.Where(t => t.nm_function == func).ToList();
List <Entities.tb_employees> list = new List <Entities.tb_employees>();
foreach (Entities.tb_deptfunction item in listFunc)
{
list.Add(item.tb_employees);
}
if (listEmployees == null)
{
listEmployees = list;
}
else
{
List <Entities.tb_employees> listEmp = new List <Entities.tb_employees>();
foreach (Entities.tb_employees item in list)
{
Entities.tb_employees emp = new Entities.tb_employees();
emp = listEmployees.FirstOrDefault(t => t.id_emp == item.id_emp);
if (emp != null)
{
listEmp.Add(emp);
}
}
listEmployees = listEmp;
}
}
public int Insirir(Entities.tb_employees emp)
{
int idEmp = db.tb_employees.Max(t => t.id_emp) + 1;
emp.id_emp = idEmp;
db.tb_employees.Add(emp);
db.SaveChanges();
return(idEmp);
}
public int Consultar(string rg)
{
try
{
Entities.tb_employees tb = DB.tb_employees.First(t => t.nr_rg == rg);
return(tb.id_emp);
}
catch (Exception)
{
throw new ArgumentException("Não foi possivel encontar o Funcionário!");
}
}
public bool Login(Entities.tb_employees emp)
{
Entities.tb_employees tb = db.tb_employees.FirstOrDefault(t => t.ds_email.ToLower() == emp.ds_email &&
t.pw_password.ToLower() == emp.pw_password);
if (tb != null)
{
return(true);
}
else
{
return(false);
}
}
public void AlterarRecuperação(Entities.tb_employees employees)
{
if (employees.nr_cpf != string.Empty)
{
Entities.tb_employees novo = db.tb_employees.First(u => u.pw_password == employees.pw_password);
novo.pw_password = employees.pw_password;
db.SaveChanges();
}
else if (employees.nr_rg != string.Empty)
{
Entities.tb_employees novo = db.tb_employees.First(u => u.nr_rg == employees.nr_rg);
novo.pw_password = employees.pw_password;
db.SaveChanges();
}
else if (employees.nr_cellphone != string.Empty)
{
Entities.tb_employees novo = db.tb_employees.First(u => u.nr_cellphone == employees.nr_cellphone);
novo.pw_password = employees.pw_password;
db.SaveChanges();
}
}
public void Remover(Entities.tb_employees emp)
{
db.tb_employees.Remove(emp);
db.SaveChanges();
}
public Entities.tb_employees ConsultarPorID(int id)
{
Entities.tb_employees emp = db.tb_employees.FirstOrDefault(t => t.id_emp == id);
return(emp);
}