public void CarregaNotaFiscal()
{
var servicos = Conection.Select("select * from [notas fiscais]");
while (servicos.Read())
{
table.Add(new NotaFiscalModel
{
NumerodaNota = Convert.ToInt32(servicos["Numero da Nota"]),
Codcli = servicos["Codcli"].ToString(),
Tipodereceita = servicos["Tipo de receita"].ToString(),
Codreceita = servicos["Cod receita"].ToString(),
Datadeemissao = Convert.ToDateTime(servicos["Data de emissão"]),
DatadeVencimento = Convert.ToDateTime(servicos["Data de Vencimento"]),
Pis = Convert.IsDBNull(servicos["Pis"]) ? 0 : Convert.ToDouble(servicos["Pis"]),
Cofins = Convert.IsDBNull(servicos["Cofins"]) ? 0 : Convert.ToDouble(servicos["Cofins"]),
Cssl = Convert.IsDBNull(servicos["Cssl"]) ? 0 : Convert.ToDouble(servicos["Cssl"]),
Irrf = Convert.IsDBNull(servicos["Irrf"]) ? 0 : Convert.ToDouble(servicos["Irrf"]),
Total_bruto = Convert.IsDBNull(servicos["Total_bruto"]) ? 0 : Convert.ToDouble(servicos["Total_bruto"]),
Total_liquido = Convert.IsDBNull(servicos["Total_liquido"]) ? 0 : Convert.ToDouble(servicos["Total_liquido"]),
Preenchida = Convert.IsDBNull(servicos["Preenchida"]) ? false : Convert.ToBoolean(servicos["Preenchida"]),
Emitida = Convert.IsDBNull(servicos["Emitida"]) ? false : Convert.ToBoolean(servicos["Emitida"]),
Controle_impostos = Convert.ToInt32(servicos["Controle_impostos"]),
});
}
CarregaNotaFiscalItens();
}
public void CarregaDados()
{
var servicos = Conection.Select("select * from [Clientes x Serviços]");
while (servicos.Read())
{
serv.Add(new Clientes_x_ServicosModel
{
Codserv = servicos["Codcli"].ToString(),
Codcli = servicos["Codserv"].ToString(),
CodTabeladePrecos = servicos["Cód Tabela de Preços"].ToString(),
});
}
}
public void CarregaTabela()
{
var servicos = Conection.Select("select * from [Tabela de manutenções]");
while (servicos.Read())
{
table.Add(new TabelaManutencaoModel
{
Codcli = servicos["Codcli"].ToString(),
Codsis = servicos["Codsis"].ToString(),
ValorManutencao = Convert.IsDBNull(servicos["Valor Manutenção"]) ? 0 : Convert.ToDouble(servicos["Valor Manutenção"]),
CodServico = servicos["CodServico"].ToString(),
});
}
}
public void CarregaServicos()
{
var servicos = Conection.Select("select * from Serviços");
while (servicos.Read())
{
serv.Add(new servicosModel
{
Codserv = servicos["Codserv"].ToString(),
servico = servicos["Serviço"].ToString(),
descricaonota = servicos["Título na NF"].ToString(),
});
}
CarregaServicosAplicativos();
}
public void CarregaTabelaPrecoServico()
{
List <TabelaPrecoServicoModel> table = new List <TabelaPrecoServicoModel>();
var servicos = Conection.Select("select * from [Tabela de Preços de Serviços]");
while (servicos.Read())
{
table.Add(new TabelaPrecoServicoModel
{
CodTabeladePrecos = Convert.ToInt32(servicos["Cod Tabela de Preços"]),
Itemdatabela = Convert.ToInt32(servicos["Item da tabela"]),
Descricao = servicos["Descrição"].ToString(),
Tipo = servicos["Tipo"].ToString(),
Preco = Convert.IsDBNull(servicos["Preço"]) ? 0 : Convert.ToDouble(servicos["Preço"]),
EP = servicos["EP"].ToString(),
});
}
}
public void CarregaServicosAplicativos()
{
foreach (var item in serv)
{
var servicos = Conection.Select("select * from [Sistemas Aplicativos] where CodigoServico = '" + item.Codserv + "'");
List <ServicosAplicativoModel> itens = new List <ServicosAplicativoModel>();
while (servicos.Read())
{
itens.Add(new ServicosAplicativoModel
{
Codsis = servicos["Codsis"].ToString(),
Sistema = servicos["Sistema"].ToString(),
CodigoServico = servicos["CodigoServico"].ToString(),
vl_anatel = Convert.IsDBNull(servicos["vl_anatel"]) ? 0 : Convert.ToDouble(servicos["vl_anatel"]),
link = servicos["link"].ToString(),
});
}
if (itens.Count > 0)
{
item.ServicosAplicativos = itens;
}
}
}
public void CarregaNotaFiscalItens()
{
foreach (var item in table)
{
var servicos = Conection.Select("select * from [itens da Nota] where [Numero da Nota] = " + item.NumerodaNota);
item.itens = new List <NotaFiscalItensModel>();
if (servicos != null)
{
while (servicos.Read())
{
item.itens.Add(new NotaFiscalItensModel
{
NumerodaNota = Convert.ToInt32(servicos["Numero da Nota"]),
Itemdanota = Convert.ToInt32(servicos["Item da nota"]),
Quantidade = Convert.IsDBNull(servicos["Quantidade"]) ? 0 : Convert.ToInt32(servicos["Quantidade"]),
Descricao = servicos["Descrição"].ToString(),
PrecoUnitario = Convert.IsDBNull(servicos["Preço Unitário"]) ? 0 : Convert.ToDouble(servicos["Preço Unitário"]),
PreçoTotal = Convert.IsDBNull(servicos["Preço Total"]) ? 0 : Convert.ToDouble(servicos["Preço Total"]),
Tipo = servicos["Tipo"].ToString(),
EP = servicos["EP"].ToString(),
tipo_receita = servicos["tipo_receita"].ToString(),
Cssl = Convert.IsDBNull(servicos["Cssl"]) ? 0 : Convert.ToDouble(servicos["Cssl"]),
Irrf = Convert.IsDBNull(servicos["Irrf"]) ? 0 : Convert.ToDouble(servicos["Irrf"]),
Total_bruto = Convert.IsDBNull(servicos["Total_bruto"]) ? 0 : Convert.ToDouble(servicos["Total_bruto"]),
Total_liquido = Convert.IsDBNull(servicos["Total_liquido"]) ? 0 : Convert.ToDouble(servicos["Total_liquido"]),
Preenchida = Convert.IsDBNull(servicos["Preenchida"]) ? false : Convert.ToBoolean(servicos["Preenchida"]),
Emitida = Convert.IsDBNull(servicos["Emitida"]) ? false : Convert.ToBoolean(servicos["Emitida"]),
Emitida1 = Convert.IsDBNull(servicos["Emitida1"]) ? false : Convert.ToBoolean(servicos["Emitida1"]),
});
}
}
}
var teste = table;
}
