public Cliente_obs Buscar(int codigo) { try { Cliente_obs Cliente_obs = null; DBSession session = new DBSession(); Query quey = session.CreateQuery("SELECT * FROM Cliente_obs WHERE cliente_obs_id = @cliente_obs_id"); quey.SetParameter("cliente_obs_id", codigo); IDataReader reader = quey.ExecuteQuery(); if (reader.Read()) { Cliente_obs = new Cliente_obs(Convert.ToInt32(reader["cliente_obs_id"]), new Cliente() { codigo = Convert.ToInt32(reader["cliente"]) }, new Painel() { codigo = Convert.ToInt32(reader["painel"]) }, Convert.ToDateTime(reader["data"]), Convert.ToString(reader["obs"])); } reader.Close(); session.Close(); return(Cliente_obs); } catch (Exception error) { throw error; } }
public void Excluir(Cliente_obs variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("DELETE FROM Cliente_obs WHERE cliente_obs_id = @cliente_obs_id"); query.SetParameter("cliente_obs_id", variavel.cliente_obs_id); query.ExecuteUpdate(); session.Close(); } catch (Exception erro) { throw erro; } }
public void Salvar(Cliente_obs variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("INSERT INTO Cliente_obs (cliente, painel, data, obs) VALUES (@cliente, @painel, @data, @obs) "); query.SetParameter("cliente", variavel.cliente.codigo) .SetParameter("painel", variavel.painel.codigo) .SetParameter("data", variavel.data) .SetParameter("obs", variavel.obs); query.ExecuteUpdate(); session.Close(); } catch (Exception erro) { throw erro; } }
public void Alterar(Cliente_obs variavel) { try { DBSession session = new DBSession(); Query query = session.CreateQuery("UPDATE Cliente_obs SET cliente = @cliente, painel = @painel, data = @data, obs = @obs WHERE cliente_obs_id = @cliente_obs_id"); query.SetParameter("cliente_obs_id", variavel.cliente_obs_id) .SetParameter("cliente", variavel.cliente.codigo) .SetParameter("painel", variavel.painel.codigo) .SetParameter("data", variavel.data) .SetParameter("obs", variavel.obs);; query.ExecuteUpdate(); session.Close(); } catch (Exception erro) { throw erro; } }