internal Barbearia buscarBarbeariaDaFilial(Filial filial)
{
Barbearia barbearia = new Barbearia();
SqlCommand command = new SqlCommand();
command.Connection = this.conexao;
command.CommandType = CommandType.Text;
StringBuilder sql = new StringBuilder();
sql.Append("SELECT * FROM barbearia ");
sql.Append("INNER JOIN filial_barbearia ON barbearia.Id = filial_barbearia.id_barbearia ");
sql.Append("WHERE id_filial = @id");
command.Parameters.AddWithValue("id", filial.Id);
command.CommandText = sql.ToString();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
barbearia.Id = (Int32)reader["Id"];
barbearia.Nome = (String)reader["name"];
barbearia.Cnpj = (String)reader["cnpj"];
return(barbearia);
}
return(null);
}
internal List <Filial> buscarFiliaisDaBarbearia(Barbearia barbearia)
{
List <Filial> filiais = new List <Filial>();
SqlCommand command = new SqlCommand();
command.Connection = this.conexao;
command.CommandType = CommandType.Text;
StringBuilder sql = new StringBuilder();
sql.Append("SELECT * FROM filial ");
sql.Append("INNER JOIN filial_barbearia ON filial.Id = filial_barbearia.id_filial ");
sql.Append("WHERE filial_barbearia.id_barbearia = @id");
command.Parameters.AddWithValue("@id", barbearia.Id);
command.CommandText = sql.ToString();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Filial filial = new Filial();
filial.Id = (Int32)reader["Id"];
filial.Nome = (String)reader["nome"];
filial.Cnpj = (String)reader["cnpj"];
filial.Endereco = (String)reader["endereco"];
filiais.Add(filial);
}
FabricaConexao.CloseConnection(conexao);
return(filiais);
}
private void cbBarbearias_SelectedIndexChanged(object sender, EventArgs e)
{
Barbearia barbearia = (Barbearia)cbBarbearias.SelectedValue;
List <Filial> filiais = FilialService.BuscarFiliaisDaBarbearia(barbearia);
cbFiliais.DataSource = filiais;
}
internal List <Barbearia> buscarBarbeariasLike(string filtro)
{
List <Barbearia> barbearias = new List <Barbearia>();
SqlCommand command = new SqlCommand();
command.Connection = this.conexao;
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM barbearia WHERE name like @filtro";
command.Parameters.AddWithValue("filtro", "%" + filtro + "%");
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Barbearia barbearia = new Barbearia();
barbearia.Id = reader.GetInt32(0);
barbearia.Nome = reader.GetString(1);
barbearia.Cnpj = reader.GetString(2);
barbearias.Add(barbearia);
}
FabricaConexao.CloseConnection(conexao);
return(barbearias);
}
public async Task <IActionResult> PutBarbearia([FromRoute] int id, [FromBody] Barbearia barbearia)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != barbearia.IdBarbearia)
{
return(BadRequest());
}
_context.Entry(barbearia).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BarbeariaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public List <Barbearia> buscarTodosBarbearias()
{
List <Barbearia> barbearias = new List <Barbearia>();
SqlCommand command = new SqlCommand();
command.Connection = conexao;
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM barbearia";
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Barbearia barbearia = new Barbearia();
barbearia.Id = reader.GetInt32(0);
barbearia.Nome = reader.GetString(1);
barbearia.Cnpj = reader.GetString(2);
barbearias.Add(barbearia);
}
FabricaConexao.CloseConnection(conexao);
return(barbearias);
}
private void btnFinalizar_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Deseja finalizar compra?", "Aviso!", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Barbearia barbearia = (Barbearia)cbBarbearias.SelectedValue;
Filial filial = (Filial)cbFiliais.SelectedValue;
Atendente atendente = (Atendente)cbAtendente.SelectedValue;
Cliente cliente = (Cliente)cbClientes.SelectedValue;
this.pedidoAtual.Barbearia = barbearia;
this.pedidoAtual.Filial = filial;
this.pedidoAtual.Atendente = atendente;
this.pedidoAtual.Cliente = cliente;
this.pedidoAtual.DataPedido = DateTime.Now;
try
{
PedidoService.SalvarPedido(this.pedidoAtual);
MessageBox.Show("Salvo com sucesso!");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
internal Barbearia buscarBarbeariaDoPedido(Pedido pedido)
{
Barbearia barbearia = new Barbearia();;
SqlCommand command = new SqlCommand();
command.Connection = this.conexao;
command.CommandType = CommandType.Text;
if (tx != null)
{
command.Transaction = tx;
}
StringBuilder sql = new StringBuilder();
sql.Append("SELECT* FROM barbearia ");
sql.Append("INNER JOIN pedido ON pedido.id_barbearia = barbearia.Id ");
sql.Append("WHERE pedido.Id = @id");
command.Parameters.AddWithValue("@id", pedido.Id);
command.CommandText = sql.ToString();
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
barbearia.Id = (Int32)reader["Id"];
barbearia.Nome = (String)reader["name"];
barbearia.Cnpj = (String)reader["cnpj"];
return(barbearia);
}
return(null);
}
public static void SalvarBarbearia(String nome, String cnpj)
{
SqlConnection conexao = FabricaConexao.GetConnection();
BarbeariaDAO barbeariaDAO = new BarbeariaDAO(conexao);
Barbearia barbearia = new Barbearia(nome, cnpj);
barbeariaDAO.salvarBarbearia(barbearia);
}
internal void atualizarBarbearia(Barbearia barbearia)
{
SqlCommand command = new SqlCommand();
command.Connection = this.conexao;
command.CommandType = CommandType.Text;
command.CommandText = "UPDATE barbearia SET name = @nome, cnpj = @cnpj WHERE id = @id";
command.Parameters.AddWithValue("@nome", barbearia.Nome);
command.Parameters.AddWithValue("@cnpj", barbearia.Cnpj);
command.Parameters.AddWithValue("@id", barbearia.Id);
int n = command.ExecuteNonQuery();
}
public async Task <IActionResult> PostBarbearia([FromBody] Barbearia barbearia)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Barbearia.Add(barbearia);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetBarbearia", new { id = barbearia.IdBarbearia }, barbearia));
}
internal void salvarBarbearia(Barbearia barbearia)
{
SqlCommand command = new SqlCommand();
command.Connection = this.conexao;
command.CommandType = CommandType.Text;
command.CommandText = "insert into barbearia (name, cnpj) values (@nome, @cnpj)";
command.Parameters.AddWithValue("@nome", barbearia.Nome);
command.Parameters.AddWithValue("@cnpj", barbearia.Cnpj);
int n = command.ExecuteNonQuery();
FabricaConexao.CloseConnection(this.conexao);
}
internal static void AtualizarBarbearia(Barbearia barbearia)
{
SqlConnection conexao = null;
try
{
conexao = FabricaConexao.GetConnection();
BarbeariaDAO barbeariaDAO = new BarbeariaDAO(conexao);
barbeariaDAO.atualizarBarbearia(barbearia);
}
catch (Exception ex)
{
throw ex;
}
finally
{
FabricaConexao.CloseConnection(conexao);
}
}
private void btnSalvar_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Deseja salvar?", "Aviso!", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
String nome = tbNome.Text;
String endereco = tbEndereco.Text;
String cnpj = mtbCNPJ.Text
.Replace("-", "")
.Replace(".", "")
.Replace("/", "");
Telefone telefone = new Telefone();
telefone.Numero = mtbTelefone.Text
.Replace("(", "")
.Replace(")", "")
.Replace("-", "");
Barbearia barbearia = (Barbearia)cbBarbearias.SelectedValue;
Filial filial = new Filial();
filial.Nome = nome;
filial.Cnpj = cnpj;
filial.Endereco = endereco;
filial.Barbearia = barbearia;
filial.Telefone = telefone;
try
{
FilialService.SalvarFilial(filial);
MessageBox.Show("Salvo com sucesso!");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
internal static List <Filial> BuscarFiliaisDaBarbearia(Barbearia barbearia)
{
SqlConnection conexao = null;
List <Filial> filiais;
try
{
conexao = FabricaConexao.GetConnection();
FilialDAO filialDAO = new FilialDAO(conexao);
filiais = filialDAO.buscarFiliaisDaBarbearia(barbearia);
}
catch (Exception ex)
{
throw ex;
}
finally
{
FabricaConexao.CloseConnection(conexao);
}
return(filiais);
}
public Barbearia buscarBarbearia(int id)
{
Barbearia barbearia = new Barbearia();
SqlCommand command = new SqlCommand();
command.Connection = this.conexao;
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM barbearia WHERE id = @id";
command.Parameters.AddWithValue("id", id);
SqlDataReader reader = command.ExecuteReader();
reader.Read();
barbearia.Id = reader.GetInt32(0);
barbearia.Nome = reader.GetString(1);
barbearia.Cnpj = reader.GetString(2);
FabricaConexao.CloseConnection(this.conexao);
return(barbearia);
}
private void FrmEditarBarbearia_Load(object sender, EventArgs e)
{
this.barbearia = BarbeariaService.BuscarBarbearia(idBarbearia);
tbNome.Text = barbearia.Nome;
mtbCNPJ.Text = barbearia.Cnpj;
}
