private void timer1_Tick(object sender, EventArgs e)
{
int j = 0;
int cont = cs.Usuario().Rows.Count;
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + caminho + ";Extended Properties=Excel 12.0;");
con.Open();
OleDbDataAdapter query = new OleDbDataAdapter(" SELECT * FROM [Planilha1$]", con);
DataTable dataTable = new DataTable();
query.Fill(dataTable);
timer1.Enabled = true;
timer1.Start();
progressBar1.Maximum = mat1;
Conecta cl = new Conecta();
Variavel va = new Variavel();
foreach (DataRow dtRow in dataTable.Rows)
{
us.Nome = dtRow[0].ToString();
int aux = co.pesquisaFalta(us).Rows.Count;
if (mat1 > progressBar1.Value)
{
if (j == 0)
{
}
else
{
if (cont == 0)
{
if (aux == 0)
{
va.Nome = dtRow[0].ToString();
va.DtCadastro = Convert.ToDateTime(data).ToString("dd/MM/yyyy");
cl.cadastro(va);
}
}
else
{
if (aux == 0)
{
va.Nome = dtRow[0].ToString();
va.DtCadastro = Convert.ToDateTime(data).ToString("dd/MM/yyyy");
cl.cadastro(va);
cont = cs.Usuario().Rows.Count;
}
}
}
j = j + 1;
if (j + 1 <= mat1)
{
progressBar1.Value++;
}
}
}
con.Close();
timer1.Stop();
timer2.Enabled = true;
seg = 10;
}
private void button1_Click(object sender, EventArgs e)
{
us.Nome = comboBox1.Text;
int cont = co.CarregaDatas().Rows.Count;
int i = 0, data = 0, aux = 0, col = 1;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataGridViewColumn grid = new DataGridViewTextBoxColumn();
dataGridView1.Columns.Add("nomeMaisculo", "Nome");
this.dataGridView1.Rows.Insert(0, comboBox1.Text);
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("Lucida Bright", 11, FontStyle.Bold);
while (i < cont)
{
data = data + 1;
i = i + 1;
}
foreach (DataRow item in co.pesquisaFalta(us).Rows)
{
for (int j = 0; j < cont; j++)
{
us.Nome = dataGridView1.Rows[0].Cells[0].Value.ToString();
dta = "data" + Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("ddMMyyyy");
if (Convert.ToDateTime(Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("dd/MM/yyyy")) >= Convert.ToDateTime(Convert.ToDateTime(cs.faltaApinista(us).Rows[aux]["dtCad"].ToString()).ToString("dd/MM/yyyy")))
{
if (item[dta].ToString() == "F" || item[dta].ToString() == "")
{
dataGridView1.Columns.Add("colum" + col, Convert.ToDateTime(co.CarregaDatas().Rows[j]["data"].ToString()).ToString("dd/MM/yyyy"));
dataGridView1.Columns["colum" + col].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.Columns["colum" + col].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.RowsDefaultCellStyle.Font = new Font("Lucida Bright", 11);
dataGridView1.Rows[0].Cells[col].Value = "F";
col = col + 1;
}
}
}
}
}
