private void button8_Click(object sender, EventArgs e) { List <WorkStuff> custom_elements = new List <WorkStuff>(); ExcelFile loadedFile; bool first_run = true; string day = null, start_hour = null, stop_hour = null, final_hours = null, curs_hours = null, pregatire_hours = null, recuperare_hours = null; int j = 0, i; double sum = 0; DateTime result, tmp = DateTime.Parse("00:00"); TimeSpan timeSpan_final; string total_hours, total_final_hours; try { loadedFile = ExcelFile.Load(textBox4.Text); } catch (System.IO.FileNotFoundException) { MessageBox.Show("No file found!"); return; } foreach (ExcelWorksheet worksheet in loadedFile.Worksheets) { foreach (ExcelRow row in worksheet.Rows) { if (!first_run) { foreach (ExcelCell cell in row.AllocatedCells) { if (cell.ValueType != CellValueType.Null) { setLoad(cell, j, ref day, ref start_hour, ref stop_hour, ref curs_hours, ref pregatire_hours, ref recuperare_hours, ref final_hours); ++j; } } custom_elements.Add(new WorkStuff(day, start_hour, stop_hour, curs_hours, pregatire_hours, recuperare_hours, final_hours)); j = 0; } first_run = false; } } for (i = 0; i < custom_elements.Count; i++) { result = DateTime.Parse(custom_elements[i].total_hours); sum += (result - tmp).TotalHours; } timeSpan_final = TimeSpan.FromHours(sum); total_hours = timeSpan_final.ToString(); result = Convert.ToDateTime(total_hours); total_final_hours = result.ToString("HH:mm", CultureInfo.CurrentCulture); MessageBox.Show(total_final_hours.ToString()); }
private void get_hours_custom_Click(object sender, EventArgs e) { List <WorkStuff> custom_elements = new List <WorkStuff>(); ExcelFile loadedFile; loadedFile = ExcelFile.Load(textBox4.Text); loadFile(loadedFile, ref custom_elements, false, false); MessageBox.Show(getTotalHours(custom_elements, 0)); }
private void button2_Click(object sender, EventArgs e) { ExcelFile loadedFile; bool first_run = true; i = 0; j = 0; try { loadedFile = ExcelFile.Load("Table.xlsx"); } catch (System.IO.FileNotFoundException) { return; } foreach (ExcelWorksheet worksheet in loadedFile.Worksheets) { foreach (ExcelRow row in worksheet.Rows) { if (!first_run) { foreach (ExcelCell cell in row.AllocatedCells) { if (cell.ValueType != CellValueType.Null) { elements[i, j] = cell.Value.ToString(); ++j; } } ++i; j = 0; } first_run = false; } } j = 4; setStart(); button2.Enabled = false; }
private void button2_Click(object sender, EventArgs e) { ExcelFile loadedFile; bool first_run = true; string day = null, start_hour = null, stop_hour = null, final_hours = null, curs_hours = null, pregatire_hours = null, recuperare_hours = null; int j = 0; total_rows = 0; try { loadedFile = ExcelFile.Load("Table.xlsx"); } catch (System.IO.FileNotFoundException) { MessageBox.Show("No file found!"); return; } foreach (ExcelWorksheet worksheet in loadedFile.Worksheets) { foreach (ExcelRow row in worksheet.Rows) { if (!first_run) { foreach (ExcelCell cell in row.AllocatedCells) { if (cell.ValueType != CellValueType.Null) { setLoad(cell, j, ref day, ref start_hour, ref stop_hour, ref curs_hours, ref pregatire_hours, ref recuperare_hours, ref final_hours); ++j; } } elements.Add(new WorkStuff(day, start_hour, stop_hour, curs_hours, pregatire_hours, recuperare_hours, final_hours)); setLoad(total_rows); ++total_rows; j = 0; } first_run = false; } } button2.Enabled = false; button4.Enabled = true; }
private void get_hours_custom_Click(object sender, EventArgs e) { List <WorkStuff> custom_elements = new List <WorkStuff>(); ExcelFile loadedFile; string day = null, start_hour = null, stop_hour = null, final_hours = null, curs_hours = null, pregatire_hours = null, recuperare_hours = null; bool first_run = true, write = false; int j = 0; loadedFile = ExcelFile.Load(textBox4.Text); foreach (ExcelWorksheet worksheet in loadedFile.Worksheets) { foreach (ExcelRow row in worksheet.Rows) { if (!first_run) { foreach (ExcelCell cell in row.AllocatedCells) { if (cell.ValueType != CellValueType.Null) { if (String.Equals(cell.Value.ToString(), "TOTAL:".ToString())) { write = false; break; } setLoad(cell, j, ref day, ref start_hour, ref stop_hour, ref curs_hours, ref pregatire_hours, ref recuperare_hours, ref final_hours); ++j; write = true; } } if (write) { custom_elements.Add(new WorkStuff(day, start_hour, stop_hour, curs_hours, pregatire_hours, recuperare_hours, final_hours)); write = false; } j = 0; } first_run = false; } } MessageBox.Show(getTotalFinalHours(custom_elements)); }
private void load_button_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog; openFileDialog = new OpenFileDialog { Title = "Browse Excel Files", CheckFileExists = true, CheckPathExists = true, RestoreDirectory = true, DefaultExt = "xlsx", Filter = "xlsx files (*.xlsx)|*.xlsx", FilterIndex = 2, ShowReadOnly = true }; if (openFileDialog.ShowDialog() != DialogResult.OK) { return; } new_file = false; loadedFile = ExcelFile.Load(openFileDialog.FileName); loadFile(loadedFile); if (total_rows > 0) { last_total_rows = total_rows - 1; } MessageBox.Show("File loaded!"); load_button.Enabled = false; save_button.Enabled = true; delete_button.Enabled = true; delete_all_button.Enabled = true; }
private void button2_Click(object sender, EventArgs e) { ExcelFile loadedFile; string day = null, start_hour = null, stop_hour = null, final_hours = null, curs_hours = null, pregatire_hours = null, recuperare_hours = null; int j, k; i = 0; try { loadedFile = ExcelFile.Load("Table.xlsx"); } catch (System.IO.FileNotFoundException) { return; } foreach (ExcelWorksheet worksheet in loadedFile.Worksheets) { for (k = 1; k < 20; k++) { for (j = 0; j < 7; j++) { var cell = worksheet.Cells[k + 1, j]; if (cell.ValueType != CellValueType.Null) { setLoad(cell, j, ref day, ref start_hour, ref stop_hour, ref curs_hours, ref pregatire_hours, ref recuperare_hours, ref final_hours); if (j == 7 - 1) { elements.Add(new WorkStuff(day, start_hour, stop_hour, curs_hours, pregatire_hours, recuperare_hours, final_hours)); setLoad(i); ++i; } } } } } button2.Enabled = false; }
private void load_button_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog; ExcelFile loadedFile; string day = null, start_hour = null, stop_hour = null, final_hours = null, curs_hours = null, pregatire_hours = null, recuperare_hours = null; bool first_run = true; bool write = false; int j = 0; openFileDialog = new OpenFileDialog { Title = "Browse Excel Files", CheckFileExists = true, CheckPathExists = true, RestoreDirectory = true, DefaultExt = "xlsx", Filter = "xlsx files (*.xlsx)|*.xlsx", FilterIndex = 2, ShowReadOnly = true }; if (openFileDialog.ShowDialog() != DialogResult.OK) { return; } loadedFile = ExcelFile.Load(openFileDialog.FileName); total_rows = 0; foreach (ExcelWorksheet worksheet in loadedFile.Worksheets) { foreach (ExcelRow row in worksheet.Rows) { if (!first_run) { foreach (ExcelCell cell in row.AllocatedCells) { if (cell.ValueType != CellValueType.Null) { if (String.Equals(cell.Value.ToString(), "TOTAL:".ToString())) { write = false; break; } setLoad(cell, j, ref day, ref start_hour, ref stop_hour, ref curs_hours, ref pregatire_hours, ref recuperare_hours, ref final_hours); ++j; write = true; } } if (write) { elements.Add(new WorkStuff(day, start_hour, stop_hour, curs_hours, pregatire_hours, recuperare_hours, final_hours)); setLoad(total_rows); ++total_rows; write = false; } j = 0; } first_run = false; } } MessageBox.Show("File loaded!"); load_button.Enabled = false; save_button.Enabled = true; get_hours_normal.Enabled = true; }