public Funcionario userInformation(int id) { verificaConexao(); op = new Operations(); DataSet dx = op.setSelectQuery("controle_funcionario", "*", "login_funcionario = " + id); Funcionario fun = new Funcionario(); fun.Matricula = int.Parse(dx.Tables[0].Rows[0]["matricula_funcionario"].ToString()); fun.Nome = dx.Tables[0].Rows[0]["nome_funcionario"].ToString(); fun.Disciplina = dx.Tables[0].Rows[0]["disc_professor"].ToString(); fun.Login = int.Parse(dx.Tables[0].Rows[0]["login_funcionario"].ToString()); return(fun); }
public Login AutenticaUsuario(String Username, String Password) { verificaConexao(); op = new Operations(); DataSet ds = op.setSelectQuery("controle_login", "*", "login_login = '******' and pwd_login = md5('" + Password + "')"); Login lg = new Login(); if (ds.Tables[0].Rows.Count > 0) { lg.ID = int.Parse(ds.Tables[0].Rows[0]["id_login"].ToString()); lg.Role = ds.Tables[0].Rows[0]["perm_login"].ToString(); return(lg); } else { lg = null; return(lg); } }
public FabricanteDAO() { op = new Operations(); }
public FrascosDAO() { op = new SICS___Acesso_ao_Banco_de_Dados.Operations(); }
public ReagenteDAO() { op = new SICS___Acesso_ao_Banco_de_Dados.Operations(); }
public GrupoDAO() { op = new SICS___Acesso_ao_Banco_de_Dados.Operations(); }