/// <summary>
/// Consulta todas informações no banco.
/// </summary>
/// <returns>Retorna uma coleção de objetos com as informações encontradas no banco.</returns>
public ServicoCollectionDTO ReadService(AgendamentoDTO agendamento)
{
try
{
dataBaseAccess.ClearParameters();
dataBaseAccess.AddParameters("_idAgendamento", agendamento.IdAgendamento);
dataBaseAccess.AddParameters("_message", ErrorMessage.MensagemErro);
DataTable dataTable = new DataTable();
dataTable = dataBaseAccess.Consult(CommandType.StoredProcedure, "sp_agendamento_servico_servico");
ServicoCollectionDTO servicos = new ServicoCollectionDTO();
foreach (DataRow row in dataTable.Rows)
{
ServicoDTO servicoDTO = new ServicoDTO();
servicoDTO.IdServico = Convert.ToInt32(row["IdServico"]);
servicoDTO.DescricaoServico = row["DescricaoServico"].ToString();
servicos.Add(servicoDTO);
}
return(servicos);
}
catch (Exception ex)
{
StringBuilder message = new StringBuilder();
message.Append("Não foi possível realizar a consulta de serviços por agendamento: ").Append(ex.Message);
throw new Exception(message.ToString());
}
finally
{
dataBaseAccess.ClearParameters();
}
}
/// <summary>
/// Consulta informações de privilegio por nome.
/// </summary>
/// <param name="servico">Nome do privilegio que será consultado.</param>
/// <returns>Informações do privilegio encontrado.</returns>
public ServicoCollectionDTO ReadName(string servico)
{
ServicoCollectionDTO servicoCollectionDTO = new ServicoCollectionDTO();
try
{
dataBaseAccess.ClearParameters();
dataBaseAccess.AddParameters("_servico", servico);
DataTable dataTable = new DataTable();
dataTable = dataBaseAccess.Consult(CommandType.StoredProcedure, "sp_servico_nome");
foreach (DataRow row in dataTable.Rows)
{
ServicoDTO servicoDTO = new ServicoDTO();
servicoDTO.IdServico = Convert.ToInt32(row["IdServico"]);
servicoDTO.DescricaoServico = row["DescricaoServico"].ToString();
servicoCollectionDTO.Add(servicoDTO);
}
return(servicoCollectionDTO);
}
catch (Exception ex)
{
StringBuilder message = new StringBuilder();
message.Append("Não foi possível consultar cliente por nome:\n\n").Append(ex.Message);
throw new Exception(message.ToString());
}
finally
{
dataBaseAccess.ClearParameters();
}
}
public void CarregarDataGrid(AgendamentoDTO agendamento)
{
newCollection = new ServicoCollectionDTO();
newCollection = agendamentoServicoBLL.ReadService(agendamento);
dataGridViewServices.DataSource = null;
dataGridViewServices.DataSource = newCollection;
cbServices.SelectedIndex = -1;
}
/// <summary>
/// Preenche lista de serviços.
/// </summary>
private void FillServicesList()
{
servicoCollectionDTO = new ServicoCollectionDTO();
servicoCollectionDTO = servicoBLL.ReadName(string.Empty);
dataGridService.ItemsSource = null;
dataGridService.ItemsSource = servicoCollectionDTO;
dataGridStuff.ItemsSource = null;
dataGridAddStuff.ItemsSource = null;
}
private void PreencherServicos()
{
cbServices.Items.Clear();
servicoCollectionDTO = new ServicoCollectionDTO();
servicoCollectionDTO = servicoBLL.ReadName(string.Empty);
foreach (ServicoDTO item in servicoCollectionDTO)
{
cbServices.Items.Add(item.DescricaoServico);
}
}
public AgendamentoDTO()
{
Color = Color.White;
BorderColor = Color.Blue;
//TextColor = Color.White;
Locked = false;
DrawBorder = false;
AllDayEvent = false;
Cliente = new ClienteDTO();
Funcionario = new FuncionarioDTO();
Servicos = new ServicoCollectionDTO();
}
/// <summary>
/// Lista todos os serviços
/// </summary>
private void ListServices()
{
try
{
servicoCollectionDTO = new ServicoCollectionDTO();
servicoCollectionDTO = servicoBLL.ReadName(string.Empty);
dataGridAddService.ItemsSource = null;
dataGridAddService.ItemsSource = servicoCollectionDTO;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Erro", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
