private void ExecuteCommandInsertAutor(object obj)
{
mTiposGenericos Tgeneric = new mTiposGenericos();
Tgeneric.Codigo = 0;
Tgeneric.Nome = NovoAutor;
Tgeneric.Cadastro = DateTime.Now;
Tgeneric.Alterado = DateTime.Now;
Tgeneric.Bloqueado = false;
if (MessageBox.Show("Adicionar novo Autor?", "Sim.Apps.Alerta", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
if (new mData().InsertTiposGenericos(SqlCollections.Autor_Insert, SqlCollections.Autor_Last_Codigo, Tgeneric) == true)
{
Autores = new mListaTiposGenericos().GoList(SqlCollections.Autor_All);
}
}
NovoAutor = string.Empty;
}
public vmAutor()
{
Autores = new mListaTiposGenericos().GoList(SqlCollections.Autor_All);
TextBoxEnabled = false;
}
public vmOrigem()
{
Origem = new mListaTiposGenericos().GoList(SqlCollections.Origem_All);
TextBoxEnabled = false;
}
public int GoRelatory(List <object> obj)
{
string sqlcommand_l = @"SELECT * FROM Legislacao
WHERE(Tipo LIKE 'LEI')
AND(Data BETWEEN @Data1 AND @Data2)
AND(Situacao LIKE @Situacao)
AND(Origem LIKE @Origem) AND(Excluido = 0)
ORDER BY Data DESC, Numero DESC";
string sqlcommand_lc = @"SELECT * FROM Legislacao
WHERE(Tipo LIKE 'LEI COMPLEMENTAR')
AND(Data BETWEEN @Data1 AND @Data2)
AND(Situacao LIKE @Situacao)
AND(Origem LIKE @Origem) AND(Excluido = 0)
ORDER BY Data DESC, Numero DESC";
string sqlcommand_d = @"SELECT * FROM Legislacao
WHERE(Tipo LIKE 'DECRETO')
AND(Data BETWEEN @Data1 AND @Data2)
AND(Situacao LIKE @Situacao)
AND(Origem LIKE @Origem) AND(Excluido = 0)
ORDER BY Data DESC, Numero DESC";
var dataAccess = Data.Factory.Connecting(DataBase.Base.Governo);
int total = 0;
DE.ResetValues();
LO.ResetValues();
LC.ResetValues();
try
{
dataAccess.AddParameters("@Data1", (string)obj[3]);
dataAccess.AddParameters("@Data2", (string)obj[4]);
dataAccess.AddParameters("@Situacao", (string)obj[5]);
dataAccess.AddParameters("@Origem", (string)obj[6]);
var full_data = new System.Data.DataTable();
var d_leis = new System.Data.DataTable();
var d_leis_c = new System.Data.DataTable();
var d_decs = new System.Data.DataTable();
full_data = dataAccess.Read("SELECT * FROM Legislacao WHERE (Tipo LIKE 'ZERO')");
full_data.Clear();
if ((bool)obj[0])
{
d_leis = dataAccess.Read(sqlcommand_l);
}
if ((bool)obj[0])
{
d_leis_c = dataAccess.Read(sqlcommand_lc);
}
if ((bool)obj[0])
{
d_decs = dataAccess.Read(sqlcommand_d);
}
foreach (System.Data.DataRow rl in d_leis.Rows)
{
full_data.ImportRow(rl);
}
foreach (System.Data.DataRow rlc in d_leis_c.Rows)
{
full_data.ImportRow(rlc);
}
foreach (System.Data.DataRow rd in d_decs.Rows)
{
full_data.ImportRow(rd);
}
d_leis.Clear();
d_leis_c.Clear();
d_decs.Clear();
d_leis = null;
d_leis_c = null;
d_decs = null;
List <mTiposGenericos> leisClassificacao = new List <mTiposGenericos>();
List <mTiposGenericos> decretosClassificacao = new List <mTiposGenericos>();
List <string> llotipo = new List <string>();
List <string> llosituacao = new List <string>();
List <string> lloorigem = new List <string>();
List <string> lloautor = new List <string>();
List <string> lloclass = new List <string>();
List <string> llctipo = new List <string>();
List <string> llcsituacao = new List <string>();
List <string> llcorigem = new List <string>();
List <string> llcautor = new List <string>();
List <string> llcclass = new List <string>();
List <string> ldctipo = new List <string>();
List <string> ldcsituacao = new List <string>();
List <string> ldcorigem = new List <string>();
List <string> ldcautor = new List <string>();
List <string> ldcclass = new List <string>();
decretosClassificacao = new mListaTiposGenericos().GoList(SqlCollections.Class_D_All);
leisClassificacao = new mListaTiposGenericos().GoList(SqlCollections.Class_L_All);
int cont_reg = 0;
int vreg = full_data.Rows.Count;
foreach (System.Data.DataRow leg in full_data.Rows)
{
cont_reg++;
total = leg.Table.Rows.Count;
var legislacao = new mLegislacao();
legislacao.Tipo = leg["Tipo"].ToString();
legislacao.Classificacao = leg["Classificado"].ToString();
legislacao.Situacao = leg["Situacao"].ToString();
legislacao.Origem = leg["Origem"].ToString();
legislacao.Autor = leg["Autor"].ToString();
switch (legislacao.Tipo)
{
case "LEI":
llotipo.Add(legislacao.Tipo);
if (legislacao.Situacao == 1.ToString())
{
llosituacao.Add("INALTERADA");
}
if (legislacao.Situacao == 2.ToString())
{
llosituacao.Add("ALTERADA");
}
if (legislacao.Situacao == 3.ToString())
{
llosituacao.Add("REVOGADA");
}
if (legislacao.Origem == 1.ToString())
{
lloorigem.Add("EXECUTIVO");
}
if (legislacao.Origem == 2.ToString())
{
lloorigem.Add("LEGISLATIVO");
}
if (legislacao.Autor == string.Empty)
{
lloautor.Add("SEM AUTOR");
}
else
{
lloautor.Add(legislacao.Autor);
}
for (int i = 0; i < leisClassificacao.Count; i++)
{
if (legislacao.Classificacao == i.ToString())
{
if (leisClassificacao[i].Nome == string.Empty ||
leisClassificacao[i].Nome == "...")
{
lloclass.Add("SEM CLASSIFICAÇÃO");
}
else
{
lloclass.Add(leisClassificacao[i].Nome.ToUpper());
}
}
}
break;
case "LEI COMPLEMENTAR":
llctipo.Add(legislacao.Tipo);
if (legislacao.Situacao == 1.ToString())
{
llcsituacao.Add("INALTERADA");
}
if (legislacao.Situacao == 2.ToString())
{
llcsituacao.Add("ALTERADA");
}
if (legislacao.Situacao == 3.ToString())
{
llcsituacao.Add("REVOGADA");
}
if (legislacao.Origem == 1.ToString())
{
llcorigem.Add("EXECUTIVO");
}
if (legislacao.Origem == 2.ToString())
{
llcorigem.Add("LEGISLATIVO");
}
if (legislacao.Autor == string.Empty)
{
llcautor.Add("SEM AUTOR");
}
else
{
llcautor.Add(legislacao.Autor);
}
for (int i = 0; i < leisClassificacao.Count; i++)
{
if (legislacao.Classificacao == i.ToString())
{
if (leisClassificacao[i].Nome == string.Empty ||
leisClassificacao[i].Nome == "...")
{
llcclass.Add("SEM CLASSIFICAÇÃO");
}
else
{
llcclass.Add(leisClassificacao[i].Nome.ToUpper());
}
}
}
break;
case "DECRETO":
ldctipo.Add(legislacao.Tipo);
if (legislacao.Situacao == 1.ToString())
{
ldcsituacao.Add("INALTERADO");
}
if (legislacao.Situacao == 2.ToString())
{
ldcsituacao.Add("ALTERADO");
}
if (legislacao.Situacao == 3.ToString())
{
ldcsituacao.Add("REVOGADO");
}
if (legislacao.Origem == 1.ToString())
{
ldcorigem.Add("EXECUTIVO");
}
if (legislacao.Origem == 2.ToString())
{
ldcorigem.Add("LEGISLATIVO");
}
if (legislacao.Origem != 2.ToString() && legislacao.Origem != 1.ToString())
{
ldcorigem.Add("SEM ORIGEM");
}
if (legislacao.Autor == string.Empty)
{
ldcautor.Add("SEM AUTOR");
}
else
{
ldcautor.Add(legislacao.Autor);
}
for (int i = 0; i < decretosClassificacao.Count; i++)
{
if (legislacao.Classificacao == i.ToString())
{
if (decretosClassificacao[i].Nome == string.Empty)
{
ldcclass.Add("SEM CLASSIFICAÇÃO");
}
else
{
ldcclass.Add(decretosClassificacao[i].Nome.ToUpper());
}
}
}
break;
}
}
// Lei
var lotipo = from x in llotipo
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in lotipo)
{
LO.Tipo.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var losituacao = from x in llosituacao
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in losituacao)
{
LO.Situacao.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var loorigem = from x in lloorigem
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in loorigem)
{
LO.Origem.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var loautor = from x in lloautor
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in loautor)
{
LO.Autor.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var loclass = from x in lloclass
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in loclass)
{
LO.Classificacao.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
// Leis Complementares
var lctipo = from x in llctipo
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in lctipo)
{
LC.Tipo.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var lcsituacao = from x in llcsituacao
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in lcsituacao)
{
LC.Situacao.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var lcorigem = from x in llcorigem
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in lcorigem)
{
LC.Origem.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var lcautor = from x in llcautor
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in lcautor)
{
LC.Autor.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var lcclass = from x in llcclass
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in lcclass)
{
LC.Classificacao.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
//Decretos
var detipo = from x in ldctipo
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in detipo)
{
DE.Tipo.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var desituacao = from x in ldcsituacao
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in desituacao)
{
DE.Situacao.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var deorigem = from x in ldcorigem
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in deorigem)
{
DE.Origem.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var deautor = from x in ldcautor
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in deautor)
{
DE.Autor.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
var declas = from x in ldcclass
group x by x into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count };
foreach (var x in declas)
{
DE.Classificacao.Add(new KeyValuePair <string, int>(x.Value, x.Count));
}
return(total);
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message, "Sim.Alerta!");
return(0);
}
}
public vmAcoes()
{
Acoes = new mListaTiposGenericos().GoList(SqlCollections.Acao_All);
TextBoxEnabled = false;
}
public vmClassDe()
{
ClassificacoesD = new mListaTiposGenericos().GoList(SqlCollections.Class_D_All);
TextBoxEnabled = false;
}
public vmSituacao()
{
Situacoes = new mListaTiposGenericos().GoList(SqlCollections.Situacao_All);
TextBoxEnabled = false;
}
public vmTipos()
{
Tipos = new mListaTiposGenericos().GoList(SqlCollections.Tipo_All);
TextBoxEnabled = false;
}
