public Model.ServicoComanda selectById(int id)
{
Model.ServicoComanda servicoComanda = new Model.ServicoComanda();
string sql = "SELECT * FROM ServicoComanda WHERE id=@id";
Conexao conexao = new Bll.Conexao();
SqlCommand command = new SqlCommand(sql, conexao.getConexao());
command.Parameters.AddWithValue("id", id);
try
{
SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (reader.Read())
{
servicoComanda.id = Convert.ToInt32(reader["id"]);
servicoComanda.valorServico = Convert.ToInt32(reader["valorServico"]);
servicoComanda.desconto = Convert.ToSingle(reader["desconto"]);
servicoComanda.servicoID = Convert.ToInt32(reader["servicoID"]);
servicoComanda.funcionarioID = Convert.ToInt32(reader["funcionarioID"]);
servicoComanda.comandaID = Convert.ToInt32(reader["comandaID"]);
}
}
catch
{
Console.WriteLine("Erro na seleção de Serviços");
}
finally
{
conexao.Dispose();
}
return(servicoComanda);
}
private void carregarServicoComanda(int idServico)
{
Model.ServicoComanda servicoComanda = Dal.ServicoComanda.selectById(idServico);
this.idServico.Value = servicoComanda.id.ToString();
ddlFuncionarioServico.SelectedValue = Convert.ToString(servicoComanda.funcionarioID);
ddlServico.SelectedValue = Convert.ToString(servicoComanda.servicoID);
txtValorServico.Text = Dal.SerivcoDAL.select().First(s => s.id == servicoComanda.servicoID).valor.ToString("0.00");
txtDescontoServico.Text = servicoComanda.desconto.ToString();
txtValorTotalServico.Text = (servicoComanda.valorServico - servicoComanda.desconto).ToString("0.00");
}
public void insert(Model.ServicoComanda servicoComanda)
{
string sql = "INSERT INTO ServicoComanda VALUES(@valorServico, @desconto, @servicoID, @funcionarioID, @comandaID);";
Conexao conexao = new Conexao();
SqlCommand command = new SqlCommand(sql, conexao.getConexao());
command.Parameters.AddWithValue("valorServico", servicoComanda.valorServico);
command.Parameters.AddWithValue("desconto", servicoComanda.desconto);
command.Parameters.AddWithValue("servicoID", servicoComanda.servicoID);
command.Parameters.AddWithValue("funcionarioID", servicoComanda.funcionarioID);
command.Parameters.AddWithValue("comandaID", servicoComanda.comandaID);
command.ExecuteNonQuery();
conexao.Dispose();
}
public void update(Model.ServicoComanda servicoComanda)
{
string sql = "UPDATE ServicoComanda SET valorServico=@valorServico, desconto=@desconto, servicoID=@servicoID, funcionarioID=@funcionarioID, comandaID=@comandaID where id=@id;";
Conexao conexao = new Conexao();
SqlCommand command = new SqlCommand(sql, conexao.getConexao());
command.Parameters.AddWithValue("id", servicoComanda.id);
command.Parameters.AddWithValue("valorServico", servicoComanda.valorServico);
command.Parameters.AddWithValue("desconto", servicoComanda.desconto);
command.Parameters.AddWithValue("servicoID", servicoComanda.servicoID);
command.Parameters.AddWithValue("funcionarioID", servicoComanda.funcionarioID);
command.Parameters.AddWithValue("comandaID", servicoComanda.comandaID);
command.ExecuteNonQuery();
conexao.Dispose();
}
private Model.ServicoComanda getServicoComanda()
{
List <Model.Servico> lstServico = Dal.SerivcoDAL.select();
Model.ServicoComanda servicoComanda = new Model.ServicoComanda();
if (idProduto.Value != "")
{
servicoComanda.id = Convert.ToInt32(idProduto);
}
servicoComanda.desconto = Convert.ToSingle(txtDescontoServico.Text);
servicoComanda.comandaID = Convert.ToInt32(Request.QueryString["id"]);
servicoComanda.funcionarioID = Convert.ToInt32(ddlFuncionarioServico.SelectedValue);
servicoComanda.servicoID = Convert.ToInt32(ddlServico.SelectedValue);
servicoComanda.valorServico = lstServico.First(f => f.id == Convert.ToInt32(ddlServico.SelectedValue)).valor;
return(servicoComanda);
}
protected void btnAdicionarServico_Click(object sender, EventArgs e)
{
Model.ServicoComanda servicoComanda = getServicoComanda();
if (servicoComanda != null)
{
if (idServico.Value != "")
{
Dal.ServicoComanda.update(servicoComanda);
}
else
{
Dal.ServicoComanda.insert(servicoComanda);
}
}
pnlServico.Visible = false;
abrirBtnPanelVisibile(true);
idServico.Value = "";
atualizar();
}
public static void insert(Model.ServicoComanda servicoComanda)
{
Bll.ServicoComandaBLL servicoComandaBLL = new Bll.ServicoComandaBLL();
servicoComandaBLL.insert(servicoComanda);
}
public static void update(Model.ServicoComanda servicoComanda)
{
Bll.ServicoComandaBLL servicoCOmandaBLL = new Bll.ServicoComandaBLL();
servicoCOmandaBLL.update(servicoComanda);
}