public List <Estoque> GetAll() { string query = "SELECT * FROM Estoque"; List <Estoque> list = new List <Estoque>(); try { SqlDataReader reader = db.CallExecuteReader(query); while (reader.Read()) { Estoque e = new Estoque(); e.CodEstoque = int.Parse(reader["CodEstoque"].ToString()); e.Local = reader["Local"].ToString(); list.Add(e); } reader.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(list); }
public List <Equipamento> GetAll() { string query = "SELECT * FROM Equipamento"; List <Equipamento> list = new List <Equipamento>(); try { SqlDataReader reader = db.CallExecuteReader(query); while (reader.Read()) { Equipamento e = new Equipamento(); e.CodEquipamento = int.Parse(reader["CodEquipamento"].ToString()); e.Descricao = reader["Descricao"].ToString(); e.NumSerie = reader["NumSerie"].ToString(); e.Estado = reader["Estado"].ToString(); e.CodCategoria = int.Parse(reader["CodCategoria"].ToString()); e.Pertencente = reader["Pertencente"].ToString(); e.Patrimonio = reader["Patrimonio"].ToString(); list.Add(e); } reader.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(list); }
public List <Termo_Emprestimo> GetAll() { string query = "SELECT * FROM Termo_de_Emprestimo"; List <Termo_Emprestimo> list = new List <Termo_Emprestimo>(); try { SqlDataReader reader = db.CallExecuteReader(query); while (reader.Read()) { Termo_Emprestimo t = new Termo_Emprestimo(); t.CodTermo = int.Parse(reader["CodTermo"].ToString()); t.DataRetirada = DateTime.Parse(reader["DataRetirada"].ToString()); t.Rg = reader["Rg"].ToString();; t.DataDevolucao = DateTime.Parse(reader["DataDevolucao"].ToString()); t.CodEquipamento = int.Parse(reader["CodEquipamento"].ToString()); list.Add(t); } reader.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(list); }
public List <Inventario> GetAll() { string query = "SELECT * FROM MostrarInventario"; List <Inventario> list = new List <Inventario>(); try { SqlDataReader reader = db.CallExecuteReader(query); while (reader.Read()) { Inventario c = new Inventario(); c.ID = int.Parse(reader["ID"].ToString()); c.Descricao = reader["Descricao"].ToString(); c.Estado = reader["Estado"].ToString(); c.Pertencente = reader["Pertencente"].ToString(); c.Estoque = reader["Estoque"].ToString(); list.Add(c); } reader.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(list); }
public List <Movimentacao> GetAll() { string query = "SELECT * FROM Movimentacao"; List <Movimentacao> list = new List <Movimentacao>(); try { SqlDataReader reader = db.CallExecuteReader(query); while (reader.Read()) { Movimentacao m = new Movimentacao(); m.CodMovimentacao = int.Parse(reader["CodMovimentacao"].ToString()); m.CodUsuario = int.Parse(reader["CodUsuario"].ToString()); m.CodEquipamento = int.Parse(reader["CodEquipamento"].ToString()); m.CodEstoque = int.Parse(reader["CodEstoque"].ToString());; m.TipoMovimentacao = reader["Estado"].ToString(); m.DataMovimentacao = DateTime.Parse(reader["DataMovimentacao"].ToString()); list.Add(m); } reader.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(list); }
public List <TEMP_Movimentacao> GetAll() { string query = "SELECT * FROM MostrarMovimentacao"; List <TEMP_Movimentacao> list = new List <TEMP_Movimentacao>(); try { SqlDataReader reader = db.CallExecuteReader(query); while (reader.Read()) { TEMP_Movimentacao c = new TEMP_Movimentacao(); c.Usuario = reader["NomeUsu"].ToString(); c.Equipamento = reader["NomeEquip"].ToString(); c.Estoque = reader["NomeLocal"].ToString(); c.TipoMov = reader["Estado"].ToString(); c.DataMov = DateTime.Parse(reader["dataMovimentacao"].ToString()); list.Add(c); } reader.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } return(list); }
public Usuario Logar(string usuario, string senha) { string query = "SELECT CodUsuario, Nome, Cargo, Pin FROM USUARIO WHERE Usuario = @usuario AND Senha = @senha"; Usuario u = new Usuario(usuario, senha); try { SqlDataReader reader = db.CallExecuteReader(query, new SqlParameter("@usuario", u._Usuario), new SqlParameter("@senha", u.Senha)); reader.Read(); u.CodUsuario = int.Parse(reader["CodUsuario"].ToString()); u.Nome = reader["Nome"].ToString(); u.Cargo = reader["Cargo"].ToString(); u.Pin = reader["Pin"].ToString(); } catch (Exception ex) { return(null); } return(u); }