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