public DataSet selectListReagente() { DataSet dx = new DataSet(); dx = op.setSelectQuery("controle_tipo", "*"); return(dx); }
public DataTable select() { DataSet ds = op.setSelectQuery("controle_tipo_grupo", "*"); DataTable ax = ds.Tables[0]; return(ax); }
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 DataSet selectFabricantes() { return(op.setSelectQuery("controle_fabricante", "*")); }
public DataSet selectFrasco() { return(op.setSelectQuery("controle_reagente", "*")); }