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 Remover(int id) { Entities.tb_employees tb = db.tb_employees.FirstOrDefault(t => t.id_emp == id); db.tb_employees.Remove(tb); db.SaveChanges(); }
public void Alterar(Entities.tb_employees employees) { Entities.tb_employees list = db.tb_employees.First(t => t.id_emp == employees.id_emp); list.nm_firstName = employees.nm_firstName; list.nm_lastName = employees.nm_lastName; list.nr_rg = employees.nr_rg; list.nr_cpf = employees.nr_cpf; list.nr_dependents = employees.nr_dependents; list.ds_sex = employees.ds_sex; list.dt_birth = employees.dt_birth; list.ds_state = employees.ds_state; list.nr_cep = employees.nr_cep; list.ds_address = employees.ds_address; list.ds_note = employees.ds_note; list.nr_cellphone = employees.nr_cellphone; list.nr_tellphone = employees.nr_tellphone; list.ds_email = employees.ds_email; list.pw_password = employees.pw_password; list.bt_manager = employees.bt_manager; list.bt_employee = employees.bt_employee; list.bt_rh = employees.bt_rh; list.bt_financial = employees.bt_financial; list.bt_stock = employees.bt_stock; list.bt_crm = employees.bt_crm; list.dt_hiring = list.dt_hiring; list.dt_resignation = list.dt_resignation; db.SaveChanges(); }
public bool Login(Entities.tb_employees emp) { Entities.tb_employees tb = db.tb_employees.FirstOrDefault(t => t.ds_email == emp.ds_email && t.pw_password == 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 int Consultar(string rg) { Entities.tb_employees tb = DB.tb_employees.First(t => t.nr_rg == rg); return(tb.id_emp); }
public List <Entities.tb_employees> ConsultarPorNomeSexo(Entities.tb_employees employees) { List <Entities.tb_employees> list = db.tb_employees.Where(l => l.nm_firstName == employees.nm_firstName && l.ds_sex == employees.ds_sex).ToList(); return(list); }
public List <Entities.tb_employees> ConsultarPorNomeRG(Entities.tb_employees employees) { List <Entities.tb_employees> list = db.tb_employees.Where(l => l.nm_firstName == employees.nm_firstName && l.nr_rg == employees.nr_rg).ToList(); return(list); }
public List <Entities.tb_employees> ConsultarPorSexo(Entities.tb_employees employees) { List <Entities.tb_employees> list = db.tb_employees.Where(l => l.ds_sex == employees.ds_sex).ToList(); return(list); }
public Entities.tb_employees ConsultaPorID(int id) { Entities.tb_employees employees = db.tb_employees.FirstOrDefault(t => t.id_emp == id); return(employees); }
public void Inserir1(Entities.tb_employees employees) { db.tb_employees.Add(employees); db.SaveChanges(); }