//Inserção de dados
public string RNFN_Nota(Body_WCF RNFN_Body)
{
Ender_Banco Conexao = new Ender_Banco();
string Query = "insert into emissao_nota (id_empresa,num_nota,tip_nota,qtd_itens,totalg,data)" +
"values(?,?,?,?,?,curdate());";
OdbcConnection Data_Conection = new OdbcConnection(Conexao.Conexao_Banco);
OdbcCommand command = new OdbcCommand(Query, Data_Conection);
string Valid = null;
try
{
Data_Conection.Open();
command.CommandText = Query;
command.Parameters.AddWithValue("@id_empresa", RNFN_Body.Id_empresa);
command.Parameters.AddWithValue("@num_nota", RNFN_Body.Num_nota);
command.Parameters.AddWithValue("@tip_nota", RNFN_Body.Tip_nota);
command.Parameters.AddWithValue("@qtd_itens", RNFN_Body.Qtd_itens);
command.Parameters.AddWithValue("@totalg", RNFN_Body.Totalg);
command.ExecuteNonQuery();
}
catch (OdbcException Erro)
{
Valid = Erro.Message;
if (Valid.Contains("trigger because it is already"))
{
Valid = "Dado Existente";
}
}
finally
{
Data_Conection.Close();
}
return(Valid);
}
public List <string> CE_programa_instituicao(string Query, string[] Coluna, string[] Filtros)
{
Ender_Banco Conexao = new Ender_Banco();
List <string> Valid = new List <string>();
OdbcConnection Data_Conection = new OdbcConnection(Conexao.Conexao_Banco);
OdbcCommand command = new OdbcCommand(Query, Data_Conection);
try
{
Data_Conection.Open();
command.CommandText = Query;
for (int cont = 0; cont < Coluna.Count(); cont++)
{
command.Parameters.AddWithValue("@" + Coluna[cont], Filtros[cont]);
}
command.ExecuteNonQuery();
OdbcDataReader Reader = command.ExecuteReader();
while (Reader.Read())
{
Valid.Add(Reader.GetInt16(0).ToString());
Valid.Add(Reader.GetInt16(1).ToString());
Valid.Add(Reader.GetString(2).ToString());
}
}
catch (OdbcException Erro)
{
Valid.Add(Erro.Message);
}
finally
{
Data_Conection.Close();
}
return(Valid);
}
//Consulta
public List <string> RNFN_Pesquisa(string CNPJ)
{
Ender_Banco Conexao = new Ender_Banco();
List <string> Valid = new List <string>();
string Query = "select programa_instituicao.nome_programa,programa_instituicao.id_instituicao from " +
"programa_instituicao," +
"cadastro_instituicao " +
"where cadastro_instituicao.cnpj=? " +
"and programa_instituicao.id_programa = cadastro_instituicao.id_instituicao;";
OdbcConnection Data_Conection = new OdbcConnection(Conexao.Conexao_Banco);
OdbcCommand command = new OdbcCommand(Query, Data_Conection);
try
{
Data_Conection.Open();
command.CommandText = Query;
command.Parameters.AddWithValue("@cadastro_instituicao.cnpj", CNPJ);
command.ExecuteNonQuery();
OdbcDataReader Reader = command.ExecuteReader();
while (Reader.Read())
{
Valid.Add(Reader.GetString(0));
Valid.Add(Reader.GetInt64(1).ToString());
}
}
catch (OdbcException Erro)
{
Valid.Add(Erro.Message);
}
finally
{
Data_Conection.Close();
}
return(Valid);
}
public string RNFN_Dispesa(Body_WCF RNFN_Body_Dispesa)
{
Ender_Banco Conexao = new Ender_Banco();
string Query = "insert into dispesa_realizada (id_empresa, id_instituicao,id_programa,parcela,num_nota,data)" +
"values (?,?,?,?,?,curdate());";
OdbcConnection Data_Conection = new OdbcConnection(Conexao.Conexao_Banco);
OdbcCommand command = new OdbcCommand(Query, Data_Conection);
string Valid = null;
try
{
Data_Conection.Open();
command.CommandText = Query;
command.Parameters.AddWithValue("@id_empresa", RNFN_Body_Dispesa.Id_empresa);
command.Parameters.AddWithValue("@id_instituicao", RNFN_Body_Dispesa.Id_instituicao);
command.Parameters.AddWithValue("@id_programa", RNFN_Body_Dispesa.Id_programa);
command.Parameters.AddWithValue("@parcela", RNFN_Body_Dispesa.Parcela);
command.Parameters.AddWithValue("@num_nota", RNFN_Body_Dispesa.Num_nota);
command.ExecuteNonQuery();
}
catch (OdbcException Erro)
{
Valid = Erro.Message;
if (Valid.Contains("trigger because it is already"))
{
Valid = "Dado Existente";
}
}
finally
{
Data_Conection.Close();
}
return(Valid);
}
public string Login_Auten(Body_WCF Autenticacao)
{
Ender_Banco Conexao = new Ender_Banco();
string Query = "select tip_senha from autentic where user=? and senha=?;";
OdbcConnection Data_Conection = new OdbcConnection(Conexao.Conexao_Banco);
OdbcCommand command = new OdbcCommand(Query, Data_Conection);
try
{
Data_Conection.Open();
command.Parameters.AddWithValue("@user", Autenticacao.User);
command.Parameters.AddWithValue("@senha", Autenticacao.Senha);
command.ExecuteNonQuery();
OdbcDataReader reader = command.ExecuteReader();
while (reader.Read())
{
if (reader.GetString(0) == null)
{
Query = "Usuário ou Senha Invalido..";
}
else
{
Query = reader.GetString(0);
}
}
}
catch (OdbcException ex)
{
return(ex.Message);
}
finally
{
Data_Conection.Close();
}
return(Query);
}
public string Status_Conexao()
{
Ender_Banco Conexao = new Ender_Banco();
string Valid = null;
string Query = "select * from dispesa_realizada;";
OdbcConnection Data_Conection = new OdbcConnection(Conexao.Conexao_Banco);
OdbcCommand command = new OdbcCommand(Query, Data_Conection);
try
{
Data_Conection.Open();
command.CommandText = Query;
command.ExecuteNonQuery();
}
catch (OdbcException Erro)
{
Valid = Erro.Message;
}
finally
{
Data_Conection.Close();
}
return(Valid);
}