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(); } } }