public void Listar_Todos_Agenda() { var mockRepository = new Mock <IAgendaRepositorio>(); var agendaServico = new AgendaServico(mockRepository.Object); var obter = agendaServico.ListarTodos(); mockRepository.Verify(m => m.ListarTodos(), Times.Once()); }
public void Obter_Por_Id_Agenda() { var mockRepository = new Mock <IAgendaRepositorio>(); var agendaServico = new AgendaServico(mockRepository.Object); var obter = agendaServico.ObterPorId(1); mockRepository.Verify(m => m.ObterPorId(It.IsAny <long>()), Times.Once()); }
public async Task <int> Insert(AgendaServico model) { using (IDbConnection conn = Connection) { string insertQuery = @"INSERT INTO [dbo].[AgendaServico]([IdBarbeiro], [IdServico], [IdCliente], [DataAgenda], [Horario]) VALUES (@IdBarbeiro, @IdServico, @IdCliente, @DataAgenda, @Horario)"; var result = conn.Execute(insertQuery, model); return(result); } }
public List <AgendaServico> BuscaAgendaServico(List <Object> Filtro) { List <AgendaServico> listAgendaServico = new List <AgendaServico>(); #region SQL string comandoSQL = @" SELECT AgendaServico.* , SERVICO.DESCRICAO, servico.url_img FROM AgendaServico, SERVICO WHERE AGENDASERVICO.IDSERVICO = SERVICO.ID "; if (Filtro != null) { for (int i = 0; i < Filtro.Count; i++) { comandoSQL = comandoSQL + " " + Filtro.ElementAt(i); } } #endregion MySqlCommand cmd = new MySqlCommand(comandoSQL); cmd.Connection = conn.ConexaoMySql; MySqlDataReader sqlData = conn.ExecutarConsulta(cmd); using (sqlData) { try { while (sqlData.Read()) { AgendaServico AgendaServico = new AgendaServico(); AgendaServico.id = Convert.ToInt32(sqlData["ID"]); AgendaServico.dthr_ini = Convert.ToDateTime(sqlData["dthr_ini"]); AgendaServico.dthr_fim = Convert.ToDateTime(sqlData["dthr_fim"]); AgendaServico.servico = new Servico(); AgendaServico.servico.id = Convert.ToInt32(sqlData["IDSERVICO"]); AgendaServico.servico.descricao = sqlData["descricao"].ToString(); AgendaServico.servico.url_img = sqlData["url_img"].ToString(); listAgendaServico.Add(AgendaServico); } } catch (Exception e) { listAgendaServico.Clear(); } finally { conn.FechaConexao(); } } return(listAgendaServico); }
public void Deletar_Agenda() { var mockRepository = new Mock <IAgendaRepositorio>(); var agendaServico = new AgendaServico(mockRepository.Object); agendaServico.Deletar(new Agenda() { Id = 1, NomePaciente = "Myriana Almeida", DataNascimentoPaciente = DateTime.Parse("04/09/1987"), DataInicialConsulta = new DateTime(2020, 11, 01, 08, 00, 00), DataFimConsulta = new DateTime(2020, 11, 01, 08, 30, 00), Observacoes = "" }); mockRepository.Verify(m => m.Deletar(It.IsAny <Agenda>()), Times.Once()); }
// [Authorize(Roles = "cliente")] public async Task <ActionResult <dynamic> > Agendar([FromBody] AgendaServico model) { var result = await _agendaRepo.Insert(model); if (result == 0) { return(NotFound(new { message = "Erro ao Cadastrar agendamento!." })); } return(new { sucesso = true }); }
public CustomActionResult <MessageItem> deleteagenda_servico(AgendaServico agendaservico) { MessageItem m = new MessageItem(); AgendaServicoDAO agendaservDAO = new AgendaServicoDAO(); if (!agendaservDAO.Delete(agendaservico)) { m.Code = "500"; return(GetResultBadRequest(m)); } else { m.Code = "200"; return(GetResultOK(m)); } }
public void UpDateOrcamento(AgendaServico NovoOrcamento) { String caminho = "SERVER=localhost;DATABASE=Gessoft;UID=root;PASSWORD=vegas;"; try { conexao = new MySqlConnection(caminho); conexao.Open(); String inserir = "update agendaservico set cdStatus = '" + NovoOrcamento.CdStatus + "' where cdOrcamento='" + NovoOrcamento.CdOrcamento + "';"; MySqlCommand comandos = new MySqlCommand(inserir, conexao); comandos.ExecuteNonQuery(); conexao.Close(); } catch (Exception ex) { throw new Exception("Erro de comandos:" + ex.Message); } }
public void NovoCadastroServico(AgendaServico NovoServico) { String caminho = "SERVER=localhost;DATABASE=Gessoft;UID=root;PASSWORD=vegas;"; try { conexao = new MySqlConnection(caminho); conexao.Open(); String inserir = "INSERT INTO agendaservico (cdservico, descricao, cdcliente, dia, mes, ano) values('" + NovoServico.CdServico + "', '" + NovoServico.Descricao + "','" + NovoServico.CodigoCliente + "','" + NovoServico.Dia + "','" + NovoServico.Mes + "','" + NovoServico.Ano + "');"; MySqlCommand comandos = new MySqlCommand(inserir, conexao); comandos.ExecuteNonQuery(); conexao.Close(); } catch (Exception ex) { throw new Exception("Erro de comandos:" + ex.Message); } }
public bool Inclui(AgendaServico AgendaServico) { bool ret = true; String cSQL = @" INSERT INTO AgendaServico (IDSERVICO, DTHR_INI, DTHR_FIM) "; cSQL = cSQL + @" VALUES (@IDSERVICO, @DTHR_INI, @DTHR_FIM)"; MySqlCommand comando = new MySqlCommand(); conn.ConexaoMySql.Open(); comando.Connection = conn.ConexaoMySql; comando.Parameters.Clear(); comando.CommandText = cSQL; //comando.Parameters.Add("ID", MySqlDbType.Decimal).Value = AgendaServico.id; comando.Parameters.Add("idservico", MySqlDbType.Decimal).Value = AgendaServico.servico.id; comando.Parameters.Add("dthr_ini", MySqlDbType.DateTime).Value = AgendaServico.dthr_ini; comando.Parameters.Add("dthr_fim", MySqlDbType.DateTime).Value = AgendaServico.dthr_fim; try { int rt = comando.ExecuteNonQuery(); if (rt == -1) { ret = false; } } catch (Exception e) { ret = false; } finally { conn.ConexaoMySql.Close(); } return(ret); }
public void ConsultaOrcamento(AgendaServico ConsultaServico) { String MyConString = "SERVER=localhost;DATABASE=Gessoft;UID=root;PASSWORD=vegas;"; try { MySqlConnection connection = new MySqlConnection(MyConString); MySqlCommand command = connection.CreateCommand(); MySqlDataReader Reader; command.CommandText = "select * from agendaservico where mes = '" + ConsultaServico.Mes + "' and ano = '" + ConsultaServico.Ano + "' and dia = '" + ConsultaServico.Dia + " and cdOrcamento <> 'null' ';"; connection.Open(); Reader = command.ExecuteReader(); while (Reader.Read()) { ConsultaServico.CdOrcamento = (Reader.GetInt16("cdOrcamento")).ToString(); } } catch (Exception ex) { throw new Exception("Erro de comandos:" + ex.Message); } }
public bool Delete(AgendaServico AgendaServico) { bool ret = true; String cSQL = @" DELETE FROM AgendaServico"; cSQL = cSQL + @" WHERE AgendaServico.ID = @ID"; MySqlCommand comando = new MySqlCommand(); conn.ConexaoMySql.Open(); comando.Connection = conn.ConexaoMySql; comando.Parameters.Clear(); comando.CommandText = cSQL; comando.Parameters.Add("id", MySqlDbType.Decimal).Value = AgendaServico.id; try { int rt = comando.ExecuteNonQuery(); if (rt == -1) { ret = false; } } catch (Exception e) { ret = false; } finally { conn.ConexaoMySql.Close(); } return(ret); }
public async Task AgendarServico(AgendaServico agendaServico) { _dbContext.Add(agendaServico); await _dbContext.SaveChangesAsync(); }