public List <Recess> getAllRecess() { List <Recess> recesss = new List <Recess>(); OleDbCommand cmd = DBConnection.getInstance.getDbCommand(); cmd.CommandText = "SELECT * FROM RECESS"; OleDbDataReader result = cmd.ExecuteReader(); if (result.HasRows) { while (result.Read()) { Recess recess = new Recess(); recess.idRecess = result.GetInt32(0); recess.company = companyControl.getCompany(result.GetInt32(1)); recess.description = result.GetString(2); recess.recessDate = result.GetDateTime(3); recess.department = departmentControl.getDepartment(result.GetInt32(4)); recesss.Add(recess); } } result.Close(); return(recesss); }
public Boolean updateRecess(Recess recess) { Boolean success; OleDbCommand cmd = DBConnection.getInstance.getDbCommand(); cmd.CommandText = "UPDATE RECESS SET ID_COMPANY=?, ID_DEPARTMENT=?, DESCRIPTION=?, RECESS_DATE=? WHERE ID_RECESS=?"; cmd.Parameters.Add("ID_COMPANY", OleDbType.Integer).Value = recess.company != null ? recess.company.idCompany : 0; cmd.Parameters.Add("ID_DEPARTMENT", OleDbType.Integer).Value = recess.department != null ? recess.department.idDepartment : 0; cmd.Parameters.Add("DESCRIPTION", OleDbType.VarChar).Value = recess.description; cmd.Parameters.Add("RECESS_DATE", OleDbType.Date).Value = recess.recessDate; cmd.Parameters.Add("ID_RECESS", OleDbType.Integer).Value = recess.idRecess; try { cmd.ExecuteNonQuery(); success = true; } catch (Exception e) { Console.WriteLine("Erro ao alterar!" + e); success = false; } DBConnection.getInstance.closeConnection(); return(success); }
private void loadRecess(Recess recess) { int indexCompany = -1; int indexDepartment = -1; for (int i = 0; i < allCompanies.Count; i++) { Company cp = (Company)allCompanies[i]; if (recess.company.idCompany == cp.idCompany) { indexCompany = i; break; } } for (int i = 0; i < allDepartments.Count; i++) { Department dp = (Department)allDepartments[i]; if (recess.department.idDepartment == dp.idDepartment) { indexDepartment = i; break; } } CBCompany.SelectedIndex = indexCompany; TBDescription.Text = recess.description; DPRecessDate.SelectedDate = recess.recessDate; CBDepartment.SelectedIndex = indexDepartment; idRecessEditing = recess.idRecess; editModeControls(); }
public Boolean saveRecess(Recess recess) { Boolean success; OleDbCommand cmd = DBConnection.getInstance.getDbCommand(); cmd.CommandText = "INSERT INTO RECESS (ID_COMPANY, ID_DEPARTMENT, DESCRIPTION, RECESS_DATE) VALUES (?,?,?,?)"; cmd.Parameters.Add("ID_COMPANY", OleDbType.Integer).Value = recess.company != null ? recess.company.idCompany : 0; cmd.Parameters.Add("ID_DEPARTMENT", OleDbType.Integer).Value = recess.department != null ? recess.department.idDepartment : 0; cmd.Parameters.Add("DESCRIPTION", OleDbType.VarChar).Value = recess.description; cmd.Parameters.Add("RECESS_DATE", OleDbType.Date).Value = recess.recessDate; try { cmd.ExecuteNonQuery(); success = true; } catch (Exception e) { Console.WriteLine("Erro ao salvar!" + e); success = false; } DBConnection.getInstance.closeConnection(); return(success); }
private void upsertRecess() { Recess recess = getRecessFromControls(); Boolean success; if (idRecessEditing != 0) { recess.idRecess = idRecessEditing; success = recessControl.updateRecess(recess); saveModeControls(); } else { success = recessControl.saveRecess(recess); } cleanControls(); if (success) { DialogHost.Show(new SampleMessageDialog("Feriado salvo com sucesso."), "DHMain"); recessViewControl.fillGridRecess(); } else { DialogHost.Show(new SampleMessageDialog("Erro ao salvar Feriado."), "DHMain"); } }
private Recess getRecessFromControls() { Recess recess = new Recess(); recess.company = (Company)CBCompany.SelectedItem; recess.description = TBDescription.Text; recess.recessDate = (DateTime)DPRecessDate.SelectedDate; recess.department = (Department)CBDepartment.SelectedItem; return(recess); }
private async void deleteRecess(object sender, RoutedEventArgs e) { OptionMessageDialog optionMessageDialog = new OptionMessageDialog("Deseja realmente excluir este Feriado?"); Boolean result = (Boolean)await DialogHost.Show(optionMessageDialog, "DHMain"); if (result == true) { Recess recess = ((FrameworkElement)sender).DataContext as Recess; deleteRecess(recess); } }
private void deleteRecess(Recess recess) { Boolean success = recessControl.deleteRecess(recess); if (success) { DialogHost.Show(new SampleMessageDialog("Feriado excluído com sucesso."), "DHMain"); recessViewControl.fillGridRecess(); } else { DialogHost.Show(new SampleMessageDialog("Erro ao excluir Feriado."), "DHMain"); } }
public bool Filter(object obj) { Recess data = (Recess)obj; if (obj is Recess) { if (!string.IsNullOrEmpty(_TBFilter)) { return(Util.contains(data.description, _TBFilter)); } return(true); } return(false); }
public Boolean deleteRecess(Recess recess) { Boolean success; OleDbCommand cmd = DBConnection.getInstance.getDbCommand(); cmd.CommandText = "DELETE FROM RECESS WHERE ID_RECESS=?"; cmd.Parameters.Add("ID_RECESS", OleDbType.Integer).Value = recess.idRecess; try { cmd.ExecuteNonQuery(); success = true; } catch (Exception e) { Console.WriteLine("Erro ao excluir!" + e); success = false; } DBConnection.getInstance.closeConnection(); return(success); }
public static List <Recess> getStandardRecess() { List <Recess> standardRecess = new List <Recess>(); Recess recess; recess = new Recess("Conf. Universal", new DateTime(DateTime.Now.Year, 1, 1)); standardRecess.Add(recess); recess = new Recess("Tiradentes", new DateTime(DateTime.Now.Year, 4, 21)); standardRecess.Add(recess); recess = new Recess("Dia do Trabalho", new DateTime(DateTime.Now.Year, 5, 1)); standardRecess.Add(recess); recess = new Recess("Independência", new DateTime(DateTime.Now.Year, 9, 7)); standardRecess.Add(recess); recess = new Recess("N. Sra. Aparecida", new DateTime(DateTime.Now.Year, 10, 12)); standardRecess.Add(recess); recess = new Recess("Finados", new DateTime(DateTime.Now.Year, 11, 2)); standardRecess.Add(recess); recess = new Recess("Proc. da República", new DateTime(DateTime.Now.Year, 11, 15)); standardRecess.Add(recess); recess = new Recess("Natal", new DateTime(DateTime.Now.Year, 12, 25)); standardRecess.Add(recess); return(standardRecess); }
public Boolean deleteRecess(Recess recess) { return(recessDAO.deleteRecess(recess)); }
public Boolean updateRecess(Recess recess) { return(recessDAO.updateRecess(recess)); }
public Boolean saveRecess(Recess recess) { return(recessDAO.saveRecess(recess)); }
private void loadRecess(object sender, RoutedEventArgs e) { Recess recess = ((FrameworkElement)sender).DataContext as Recess; loadRecess(recess); }