public List <Model.Servico> Select()
{
List <Model.Servico> listaServico = new List <Model.Servico>();
SqlConnection conexao = new SqlConnection(strCon);
string sql = "Select * from Servico";
SqlCommand cmd = new SqlCommand(sql, conexao);
try
{
conexao.Open();
SqlDataReader dados = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dados.Read())
{
Model.Servico servico = new Model.Servico();
servico.id = Convert.ToInt32(dados["id"].ToString());
servico.descricao = dados["descricao"].ToString();
servico.valorServ = Convert.ToSingle(dados["valorServ"].ToString());
listaServico.Add(servico);
}
}
catch
{
Console.WriteLine("Erro - Select do Servico");
}
finally
{
conexao.Close();
}
return(listaServico);
}
public List <Model.Servico> SelectByDescricao(string descricao)
{
List <Model.Servico> lstServico = new List <Model.Servico>();
SqlConnection conexao = new SqlConnection(strCon);
string sql = "Select * from Servico where (descricao like @desc);";
SqlCommand cmd = new SqlCommand(sql, conexao);
cmd.Parameters.AddWithValue("@desc", "%" + descricao + "%");
try
{
conexao.Open();
SqlDataReader dados = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dados.Read())
{
Model.Servico servico = new Model.Servico();
servico.id = Convert.ToInt32(dados["id"].ToString());
servico.descricao = dados["descricao"].ToString();
servico.valorServ = Convert.ToSingle(dados["valorServ"].ToString());
lstServico.Add(servico);
}
}
catch
{
Console.WriteLine("Erro - Consulta Select de Servico");
}
finally
{
conexao.Close();
}
return(lstServico);
}
public List <Model.Servico> select()
{
List <Model.Servico> lstServico = new List <Model.Servico>();
string sql = "SELECT * FROM servico";
Conexao conexao = new Conexao();
SqlCommand command = new SqlCommand(sql, conexao.getConexao());
try
{
SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
while (reader.Read())
{
Model.Servico servico = new Model.Servico();
servico.id = Convert.ToInt32(reader["id"]);
servico.descr = Convert.ToString(reader["descr"]);
servico.valor = Convert.ToSingle(reader["valor"]);
lstServico.Add(servico);
}
}
catch
{
Console.WriteLine("Erro na seleção de serviço");
}
finally
{
conexao.Dispose();
}
return(lstServico);
}
public Model.Servico selectByID(int id)
{
Model.Servico servico = new Model.Servico();
string sql = "SELECT * FROM servico WHERE id=@id";
Conexao conexao = new Conexao();
SqlCommand command = new SqlCommand(sql, conexao.getConexao());
try
{
SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
reader.Read();
servico.id = Convert.ToInt32(reader["id"]);
servico.descr = Convert.ToString(reader["descr"]);
servico.valor = Convert.ToSingle(reader["valor"]);
}
catch
{
Console.WriteLine("Erro na seleção de serviço por id");
}
finally
{
conexao.Dispose();
}
return(servico);
}
public void Update(Model.Servico servico)
{
DAL.Servico dalServ = new DAL.Servico();
if (servico.descricao != "")
{
dalServ.Update(servico);
}
}
public void Insert(Model.Servico servico)
{
DAL.Servico dalServ = new DAL.Servico();
if (servico.descricao != string.Empty)
{
dalServ.Insert(servico);
}
}
private Model.Servico getServico()
{
if (verificarCampos())
{
Model.Servico servico = new Model.Servico();
servico.descr = txtDescricao.Text;
servico.valor = Convert.ToSingle(txtValor.Text);
return(servico);
}
else
{
return(null);
}
}
protected void btnAdicionar(object sender, EventArgs e)
{
Model.Servico servico = getServico();
if (servico != null)
{
if (verifEditarInserir())
{
Dal.SerivcoDAL.update(servico);
}
else
{
Dal.SerivcoDAL.insert(servico);
}
Response.Redirect("viewServico.aspx");
}
}
public void insert(Model.Servico servico)
{
string sql = "INSERT INTO servico VALUES (@descr, @valor)";
Conexao conexao = new Bll.Conexao();
SqlCommand command = new SqlCommand(sql, conexao.getConexao());
command.Parameters.AddWithValue("descr", servico.descr);
command.Parameters.AddWithValue("valor", servico.valor);
try
{
command.ExecuteNonQuery();
}
catch
{
Console.WriteLine("Erro na inserção de Serviço");
}
finally
{
conexao.Dispose();
}
}
public void update(Model.Servico servico)
{
string sql = "UPDATE servico SET descr=@descr, valor=@valor WHERE id=@id";
Conexao conexao = new Bll.Conexao();
SqlCommand command = new SqlCommand(sql, conexao.getConexao());
command.Parameters.AddWithValue("descr", servico.descr);
command.Parameters.AddWithValue("valor", servico.valor);
command.Parameters.AddWithValue("id", servico.id);
try
{
command.ExecuteNonQuery();
}
catch
{
Console.WriteLine("Erro na atualização de serviço");
}
finally
{
conexao.Dispose();
}
}
public static void insert(Model.Servico servico)
{
Bll.ServicoBLL servicoBLL = new Bll.ServicoBLL();
servicoBLL.insert(servico);
}
public static void update(Model.Servico servico)
{
Bll.ServicoBLL servicoBLL = new Bll.ServicoBLL();
servicoBLL.update(servico);
}
private void carregarServico()
{
Model.Servico servico = Dal.SerivcoDAL.selectByID(Convert.ToInt32(Request.QueryString["id"]));
txtDescricao.Text = servico.descr;
txtValor.Text = servico.valor.ToString("0.00");
}
