private void button1_Click(object sender, EventArgs e)
{
int aux = 0;
int gera = co.presencaPorcentagem().Rows.Count;
int pres = 0, falt = 0;
cod = new int[gera];
progressBar1.Maximum = gera;
cont = co.CarregaDatas().Rows.Count;
foreach (DataRow item in co.presencaPorcentagem().Rows)
{
for (int j = 0; j < cont; j++)
{
if (Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()) <= DateTime.Today)
{
dta = "data" + Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("ddMMyyyy");
if (Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()) >= Convert.ToDateTime(cs.UsuarioPorc().Rows[aux]["dtCad"].ToString()))
{
if (item[dta].ToString() == "P")
{
pres = pres + 1;
}
else
{
falt = falt + 1;
}
}
}
}
if (pres == 0)
{
cod[pos] = item["cod"].GetHashCode();
p = p + 1;
pos = pos + 1;
}
progressBar1.Value++;
falt = 0;
pres = 0;
aux = aux + 1;
}
progressBar1.Value = 0;
progressBar1.Maximum = p;
for (int d = 0; d < pos; d++)
{
va.Codigo = cod[d];
co.Inativo(va);
progressBar1.Value++;
}
progressBar1.Value = 0;
string msg = "TODOS OS INATIVOS FORAM DELETADOS";
frmMensagem mg = new frmMensagem(msg);
mg.ShowDialog();
this.Close();
}
private void frmVerifica_Load(object sender, EventArgs e)
{
this.comboBox1.DisplayMember = "nome";
this.comboBox1.DataSource = co.presencaPorcentagem();
}
private void button2_Click(object sender, EventArgs e)
{
DateTime datas = Convert.ToDateTime(ca.Ano().Rows[0]["dtgerado"].ToString());
TimeSpan diferenca = DateTime.Today - datas;
int totalDias = diferenca.Days;
if (totalDias < 7)
{
string msg = "Você só poderá executar esta ação novamente dia: " + Convert.ToDateTime(ca.Ano().Rows[0]["dtgerado"].ToString()).AddDays(7).ToString("dd/MM/yyyy");
frmMensagem mg = new frmMensagem(msg);
mg.ShowDialog();
}
else
{
System.Threading.Thread tFormAguarde = new System.Threading.Thread(new System.Threading.ThreadStart(CarregaFormAguarde));
tFormAguarde.Start();
gerado = ca.Ano().Rows[0]["gerado"].ToString();
el.Codigo = Convert.ToInt32(cs.UsuarioPorc().Rows[aux]["cod"].ToString());
Convert.ToDateTime(ca.Ano().Rows[0][1].ToString());
int cont = co.CarregaDatas().Rows.Count;
int i = 0, data = 0, pres = 0, falt = 0;
while (i < cont)
{
if (Convert.ToDateTime(co.CarregaDatas().Rows[i]["data"].ToString()) >= Convert.ToDateTime(ca.Ano().Rows[0][1].ToString()) && Convert.ToDateTime(co.CarregaDatas().Rows[i]["data"].ToString()) <= DateTime.Today)
{
data = data + 1;
}
i = i + 1;
}
try
{
int gera = co.presencaPorcentagem().Rows.Count;
foreach (DataRow item in co.presencaPorcentagem().Rows)
{
for (int j = 0; j < cont; j++)
{
if (Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()) >= Convert.ToDateTime(ca.Ano().Rows[0][1].ToString()) && Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()) <= DateTime.Today)
{
dta = "data" + Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("ddMMyyyy");
if (Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()) >= Convert.ToDateTime(cs.UsuarioPorc().Rows[aux]["dtCad"].ToString()))
{
if (item[dta].ToString() == "P")
{
pres = pres + 1;
}
else
{
falt = falt + 1;
}
}
}
}
el.Codigo = Convert.ToInt32(cs.UsuarioPorc().Rows[aux]["cod"].ToString());
int alp = ce.PesquisaAlpinista(el).Rows.Count;
if (alp == 0)
{
el.Codigo = Convert.ToInt32(cs.UsuarioPorc().Rows[aux]["cod"].ToString());
el.Nome = cs.UsuarioPorc().Rows[aux]["nome"].ToString().ToUpper();
el.TotalPresenca = pres;
el.TotalReuniao = pres + falt;
ce.cadastro(el);
}
else if (alp > 0 && gerado == "Ok")
{
el.TotalPresenca = ce.SelecionaDados(el).Rows[0]["t_presenca"].GetHashCode() + pres;
el.TotalReuniao = ce.SelecionaDados(el).Rows[0]["t_reuniao"].GetHashCode() + pres + falt;
ce.AtualizaPorcentagem(el);
}
double total = pres + falt;
double soma = (pres / total) * 100;
pres = 0;
falt = 0;
aux = aux + 1;
}
an.DataGerado = Convert.ToString(DateTime.Today).ToString();
an.Gerado = "Ok";
ca.Alterar(an);
tFormAguarde.Abort();
string msg = "As porcentagens para eleição foram geradas";
frmMensagem mg = new frmMensagem(msg);
mg.ShowDialog();
}
catch (Exception ex)
{
throw new Exception("Erro de comandos: " + ex.Message);
}
tFormAguarde.Abort();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "")
{
string msg = "Escolha uma opção";
frmMensagem mg = new frmMensagem(msg);
mg.ShowDialog();
}
else
{
int cont = co.CarregaDatas().Rows.Count;
int i = 0, data = 0, pres = 0, falt = 0;
while (i < cont)
{
if (Convert.ToDateTime(co.CarregaDatas().Rows[i]["data"].ToString()) <= DateTime.Today)
{
data = data + 1;
}
i = i + 1;
}
try
{
int aux = 0;
int gera = co.presencaPorcentagem().Rows.Count;
dataGridView1.Rows.Clear();
progressBar1.Maximum = gera;
foreach (DataRow item in co.presencaPorcentagem().Rows)
{
for (int j = 0; j < cont; j++)
{
if (Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()) <= DateTime.Today)
{
dta = "data" + Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("ddMMyyyy");
if (Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()) >= Convert.ToDateTime(cs.UsuarioPorc().Rows[aux]["dtCad"].ToString()))
{
if (item[dta].ToString() == "P")
{
pres = pres + 1;
}
else
{
falt = falt + 1;
}
}
}
}
double total = pres + falt;
double soma = (pres / total) * 100;
if (comboBox1.Text == "0% a 50%")
{
if (pres == 0 || soma <= 50)
{
if (pres == 0)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = item["nome"].ToString().ToUpper();
dataGridView1.Rows[n].Cells[1].Value = pres;
dataGridView1.Rows[n].Cells[2].Value = falt;
dataGridView1.Rows[n].Cells[3].Value = 0 + "%";
}
else
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = item["nome"].ToString().ToUpper();
dataGridView1.Rows[n].Cells[1].Value = pres;
dataGridView1.Rows[n].Cells[2].Value = falt;
if (total == 0)
{
dataGridView1.Rows[n].Cells[3].Value = 0 + "%";
}
else
{
dataGridView1.Rows[n].Cells[3].Value = Math.Round(soma, 0) + "%";
}
}
}
}
else if (comboBox1.Text == "50% a 75%")
{
if (soma > 50 && soma <= 75)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = item["nome"].ToString().ToUpper();
dataGridView1.Rows[n].Cells[1].Value = pres;
dataGridView1.Rows[n].Cells[2].Value = falt;
if (total == 0)
{
dataGridView1.Rows[n].Cells[3].Value = 0 + "%";
}
else
{
dataGridView1.Rows[n].Cells[3].Value = Math.Round(soma, 0) + "%";
}
}
}
else if (comboBox1.Text == "75% a 100%")
{
if (soma > 75)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = item["nome"].ToString().ToUpper();
dataGridView1.Rows[n].Cells[1].Value = pres;
dataGridView1.Rows[n].Cells[2].Value = falt;
if (total == 0)
{
dataGridView1.Rows[n].Cells[3].Value = 0 + "%";
}
else
{
dataGridView1.Rows[n].Cells[3].Value = Math.Round(soma, 0) + "%";
}
}
}
else if (comboBox1.Text == "Todos")
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = item["nome"].ToString().ToUpper();
dataGridView1.Rows[n].Cells[1].Value = pres;
dataGridView1.Rows[n].Cells[2].Value = falt;
if (total == 0)
{
dataGridView1.Rows[n].Cells[3].Value = 0 + "%";
}
else
{
dataGridView1.Rows[n].Cells[3].Value = Math.Round(soma, 0) + "%";
}
}
pres = 0;
falt = 0;
aux = aux + 1;
progressBar1.Value++;
}
progressBar1.Value = 0;
}
catch
{
string msg = "Não houve reunião nesta data";
frmMensagem mg = new frmMensagem(msg);
mg.ShowDialog();
}
}
}
