public Garcom consultaGarcom(Garcom garcom)
{
try
{
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
queyString = "select * from tabela_garcom where cpf ='" + garcom.Cpf_garcom + "'";
SqlCommand cmd = new SqlCommand(queyString, sqlConn);
SqlDataReader dados = cmd.ExecuteReader();
while (dados.Read())
{
garcom.Nome = dados.GetString(0);
garcom.Cpf_garcom = dados.GetString(1);
}
dados.Close();
Console.WriteLine(" nome garcom:" + garcom.Nome);
Console.WriteLine(" cpf garcom:" + garcom.Cpf_garcom);
return(garcom);
}
catch (SqlException ex)
{
Console.WriteLine(ex.ToString());
return(garcom);
}
}
public List <Garcom> consultaTabelaGarcom()
{
List <Garcom> listaDeGarcom = new List <Garcom>();
try
{
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
queyString = "select * from tabela_garcom";
SqlCommand cmd = new SqlCommand(queyString, sqlConn);
SqlDataReader dados = cmd.ExecuteReader();
while (dados.Read())
{
Garcom garcom = new Garcom("", "");
garcom.Nome = dados.GetString(0);
garcom.Cpf_garcom = dados.GetString(1);
listaDeGarcom.Add(garcom);
}
dados.Close();
return(listaDeGarcom);
}
catch (SqlException ex)
{
Console.WriteLine(ex.ToString());
return(listaDeGarcom);
}
}
public async Task <Guid> Handle(CriarGarcomCommand request, CancellationToken cancellationToken)
{
try
{
if (!string.IsNullOrWhiteSpace(request.Cpf))
{
request.Cpf = new Cpf(request.Cpf).ToString();
}
if (!request.IsValid())
{
ValidationErrors(request);
return(await Task.FromResult(Guid.Empty));
}
var garcom = new Garcom
{
Id = GeradorGuidService.GetNexGuid(),
Cpf = request.Cpf,
Nome = request.Nome
};
_garcomRepository.Add(garcom);
return(await Task.FromResult(garcom.Id));
}
catch (Exception ex)
{
await Mediator.Publish(new DomainNotification(request.MessageType, $"Erro: {ex.Message}"), cancellationToken);
return(await Task.FromResult(Guid.Empty));
}
}
private void gridGarcons_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewRow row = this.gridGarcons.Rows[e.RowIndex];
if (row.Cells[0].Value.ToString().Trim() != "")
{
try
{
Garcom garcom = new Garcom();
garcom.Identificacao = row.Cells[0].Value.ToString();
garcom.Nome = row.Cells[1].Value.ToString();
garcom.Telefone = row.Cells[2].Value.ToString();
LimparCampos();
carregarGarcom(garcom);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
}
}
public IHttpActionResult PutGarcom(int id, Garcom garcom)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != garcom.Id)
{
return(BadRequest());
}
db.Entry(garcom).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!GarcomExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <bool> Handle(AtualizarGarcomCommand request, CancellationToken cancellationToken)
{
try
{
if (!string.IsNullOrWhiteSpace(request.Cpf))
{
request.Cpf = new Cpf(request.Cpf).ToString();
}
if (!request.IsValid())
{
ValidationErrors(request);
return(await Task.FromResult(false));
}
var garcom = new Garcom
{
Id = request.IDGarcom,
Cpf = request.Cpf,
Nome = request.Nome
};
_garcomRepository.Update(garcom);
return(await Task.FromResult(true));
}
catch (Exception ex)
{
await Mediator.Publish(new DomainNotification(request.MessageType, $"Erro: {ex.Message}"), cancellationToken);
return(await Task.FromResult(false));
}
}
public void deletaGarcom(string cpfPK)
{
Garcom garcom = new Garcom(cpfPK, "");
DAOGarcom garcomDAO = new DAOGarcom();
garcomDAO.deletaGarcom(garcom.Cpf_garcom);
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Nome,Idade,RestauranteId")] Garcom garcom)
{
if (ModelState.IsValid)
{
using (var client = new HttpClient())
{
client.BaseAddress = APIUri;
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
// HTTP PUT
var tmpData = JsonConvert.SerializeObject(garcom);
HttpResponseMessage response = await client.PutAsync("garcom/" + garcom.Id.ToString(), new StringContent(tmpData, Encoding.UTF8, "application/json"));
if (response.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
return(HttpNotFound());
}
var restaurantes = await getRestaurantes();
if (restaurantes != null)
{
ViewBag.RestauranteId = new SelectList(restaurantes, "Id", "Nome", garcom.RestauranteId);
return(View(garcom));
}
return(HttpNotFound());
}
public void Add(Garcom garcom)
{
garcom.DispositivoId = configuracaoDAL.GetConfiguracao().ConfiguracaoDispositivoId;
garcom.EntityId = GetMaxId();
garcom.GarcomId = garcom.DispositivoId.ToString().Trim() + "/" + garcom.EntityId.ToString().Trim();
garcom.OperacaoSincronismo = Modelo.Enums.OperacaoSincronismo.InseridoDispositivo;
sqlConnection.Insert(garcom);
}
public Garcom consultaGarcom(string cpfPK)
{
Garcom garcom = new Garcom(cpfPK, "");
DAOGarcom garcomDAO = new DAOGarcom();
garcom = garcomDAO.consultaGarcom(garcom);
return(garcom);
}
public PedidoCommandHandlerTest()
{
_helperEntitiesTest = new HelperEntitiesTest();
var repositoryPedidoGetEntityNullMoq = new Mock <IPedidoRepository>();
var repositoryPedidoMoq = new Mock <IPedidoRepository>();
var repositoryGarcomMoq = new Mock <IGarcomRepository>();
var repositoryComandaMoq = new Mock <IComandaRepository>();
var repositoryHistoricoPedidoMoq = new Mock <IHistoricoPedidoRepository>();
var repositoryProdutoPedidoMoq = new Mock <IProdutoPedidoRepository>();
var repositoryClientePedidoMoq = new Mock <IClienteRepository>();
Garcom garcomNull = null;
repositoryGarcomMoq
.Setup(x => x.GetEntityById(It.IsAny <Guid>()))
.Returns(garcomNull);
Pedido pedidoNull = null;
repositoryPedidoGetEntityNullMoq
.Setup(x => x.GetEntityById(It.IsAny <Guid>()))
.Returns(pedidoNull);
repositoryPedidoMoq
.Setup(x => x.GetEntityById(It.IsAny <Guid>()))
.Returns(_helperEntitiesTest.Pedido);
Comanda comandaNull = null;
repositoryComandaMoq
.Setup(x => x.GetEntityById(It.IsAny <Guid>()))
.Returns(comandaNull);
ProdutoPedido produtoPedidoNull = null;
repositoryProdutoPedidoMoq
.Setup(x => x.GetEntityById(It.IsAny <Guid>()))
.Returns(produtoPedidoNull);
var mediatorMoq = new Mock <IMediator>();
mediatorMoq
.Setup(x => x.Publish(It.IsAny <object>(), It.IsAny <CancellationToken>()))
.Returns(Task.CompletedTask);
_mediator = mediatorMoq.Object;
_pedidoGetEntityNullRepository = repositoryPedidoGetEntityNullMoq.Object;
_pedidoRepository = repositoryPedidoMoq.Object;
_comandaRepository = repositoryComandaMoq.Object;
_garcomRepository = repositoryGarcomMoq.Object;
_historicoPedidoRepository = repositoryHistoricoPedidoMoq.Object;
_produtoPedidoRepository = repositoryProdutoPedidoMoq.Object;
_clienteRepository = repositoryClientePedidoMoq.Object;
}
private void btn_excluirGarcom_Click_1(object sender, EventArgs e)
{
string cpfGarcom = txt_cpf_exclusao.Text;
GarcomController garcomController = new GarcomController();
Garcom garcom = new Garcom(cpfGarcom, "");
garcomController.deletaGarcom(garcom.Cpf_garcom);
this.Close();
}
private async void BtnGravarClicked(object sender, EventArgs e)
{
var dal = new GarcomDAL();
var garcom = new Garcom();
garcom.Nome = nome.Text;
garcom.Sobrenome = sobrenome.Text;
garcom.Foto = bytesFoto;
dal.Add(garcom);
ClearControls();
await App.Current.MainPage.DisplayAlert("Inserção de garçom", "Garçom inserido com sucesso", "Ok");
}
private void Btn_incluiGarcom_Click(object sender, EventArgs e)
{
string nomeGarcom = txt_garcomNome.Text;
string cpfGarcom = txt_garcomCpf.Text;
Garcom garcom = new Garcom(cpfGarcom, nomeGarcom);
GarcomController garcomController = new GarcomController();
garcomController.insereGarcom(garcom);
this.Close();
}
private void btn_buscar_Click(object sender, EventArgs e)
{
string cpfGarcom = txt_garcom_cpf.Text;
GarcomController garcomController = new GarcomController();
Garcom garcom = new Garcom(cpfGarcom, "");
garcom = garcomController.consultaGarcom(cpfGarcom);
lbl_nome_garcom_info.Text = garcom.Nome;
}
public IHttpActionResult GetGarcom(int id)
{
db.Configuration.ProxyCreationEnabled = false;
Garcom garcom = db.Garcoms.Find(id);
if (garcom == null)
{
return(NotFound());
}
return(Ok(garcom));
}
public IHttpActionResult PostGarcom(Garcom garcom)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Garcoms.Add(garcom);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = garcom.Id }, garcom));
}
private void txt_cpf_exclusao_Leave(object sender, EventArgs e)
{
string cpfGarcom = txt_cpf_exclusao.Text;
GarcomController garcomController = new GarcomController();
Garcom garcom = new Garcom(cpfGarcom, "");
garcom = garcomController.consultaGarcom(cpfGarcom);
lbl_nome_garcom_info.Text = garcom.Nome;
lbl_cpf_do_garcom_info.Text = garcom.Cpf_garcom;
}
public IHttpActionResult DeleteGarcom(int id)
{
Garcom garcom = db.Garcoms.Find(id);
if (garcom == null)
{
return(NotFound());
}
db.Garcoms.Remove(garcom);
db.SaveChanges();
return(Ok(garcom));
}
private void Btn_buscaGarcom_Click(object sender, EventArgs e)
{
string cpfGarcom = txt_garcom_cpf.Text;
GarcomController garcomController = new GarcomController();
Garcom garcom = new Garcom(cpfGarcom, "");
garcom = garcomController.consultaGarcom(cpfGarcom);
lbl_nome_garcom_info.Text = garcom.Nome;
lbl_cpf_do_garcom_info.Text = garcom.Cpf_garcom;
/*this.Close();*/
}
public void excluirGarcom(string identificacao)
{
Garcom garcom = new Garcom();
garcom.Identificacao = identificacao;
try
{
GarcomDAO dao = new GarcomDAO();
dao.delete(garcom);
}
catch (Exception e)
{
throw e;
}
}
public static void run_new()
{
var itens = new Cardapio();
var garcom = new Garcom();
var disponiveis = string.Join(", ", itens.Receitas.Keys);
while (true)
{
Console.WriteLine($"Escolha a bebida ({disponiveis})");
var bebida = Console.ReadLine();
garcom.Servir(bebida, itens);
}
}
private void Btn_editarGarcom_Click(object sender, EventArgs e)
{
string cpfGarcom = txt_garcom_cpf.Text;
string nomeGarcomNovo = txt_garcom_novo_nome.Text;
GarcomController garcomController = new GarcomController();
Garcom garcomNovo = new Garcom(cpfGarcom, nomeGarcomNovo);
garcomController.alteraGarcom(garcomNovo, garcomNovo.Cpf_garcom);
this.Close();
}
public void atualizarMesa(int numero, string identificacao_garcom)
{
try
{
Garcom garcom = new Garcom();
garcom.Identificacao = identificacao_garcom;
Mesa mesa = new Mesa(garcom);
mesa.Numero = numero;
MesaDAO dao = new MesaDAO();
dao.update(mesa);
}
catch (Exception e)
{
throw e;
}
}
public void atualizarGarcom(string identificacao, string nome, string telefone)
{
try
{
Garcom garcom = new Garcom();
garcom.Identificacao = identificacao;
garcom.Nome = nome;
garcom.Telefone = telefone;
GarcomDAO dao = new GarcomDAO();
dao.update(garcom);
}
catch (Exception e)
{
throw e;
}
}
public void insereGarcom(Garcom garcom)
{
try
{
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
queyString = "insert into tabela_garcom (nome_garcom,cpf) values ('" + garcom.Nome + "','" + garcom.Cpf_garcom + "')";
SqlCommand cmd = new SqlCommand(queyString, sqlConn);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (SqlException ex)
{
Console.WriteLine(ex.ToString());
}
}
public void alteraGarcom(Garcom garcom, string cpfPk)
{
try
{
SqlConnection sqlConn = new SqlConnection(connectionString);
sqlConn.Open();
queyString = "update tabela_garcom set nome_garcom = '" + garcom.Nome + "',cpf = '" + garcom.Cpf_garcom + "' where cpf='" + cpfPk + "'";
SqlCommand cmd = new SqlCommand(queyString, sqlConn);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
catch (SqlException ex)
{
Console.WriteLine(ex.ToString());
}
}
public async Task <Guid> Handle(CriarGarcomCommand request, CancellationToken cancellationToken)
{
var garcom = new Garcom(request.Nome, request.Telefone);
if (_garcomRepository.PossuiNomeCadastrado(garcom))
{
garcom.AddNotification("Garcom.Nome", "O nome do garcom ja esta cadastrado no banco.");
}
if (garcom.Invalid)
{
await _mediator.Publish(new DomainNotification
{
Erros = garcom.Notifications
}, cancellationToken);
return(await Task.FromResult(Guid.Empty));
}
_garcomRepository.Add(garcom);
return(await Task.FromResult(garcom.Id));
}
private void gridGarcons_SelectionChanged(object sender, EventArgs e)
{
foreach (DataGridViewRow row in gridGarcons.SelectedRows)
{
if (row.Cells[0].Value.ToString().Trim() != "")
{
try
{
Garcom garcom = new Garcom();
garcom.Identificacao = row.Cells[0].Value.ToString();
garcom.Nome = row.Cells[1].Value.ToString();
garcom.Telefone = row.Cells[2].Value.ToString();
LimparCampos();
carregarGarcom(garcom);
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
}
}
public void Update(Garcom garcom)
{
this.Garcons[this.Garcons.IndexOf(garcom)] = garcom;
}
public Pedido(Garcom _garcom)
{
Garcom = _garcom;
}
