public void Salvar(MontadoraModel model)
{
if (model.Id == 0)
{
Adicionar(model);
return;
}
Alterar(model);
}
private void Adicionar(MontadoraModel model)
{
SqlCommand command = new SqlCommand();
command.Connection = Acesso.Connection;
command.CommandType = CommandType.Text;
command.CommandText = $"insert into montadora (nome, logo)values('{model.Nome}','{model.Logo}')";
command.ExecuteNonQuery();
}
private void Alterar(MontadoraModel model)
{
SqlCommand command = new SqlCommand();
command.Connection = Acesso.Connection;
command.CommandType = CommandType.Text;
command.CommandText = $"update montadora set nome = '{model.Nome}' where id = {model.Id} ";
command.ExecuteNonQuery();
}
protected void btnCadastrar_Click(object sender, EventArgs e)
{
MontadoraBLL montadoraBLL = new MontadoraBLL();
MontadoraModel model = new MontadoraModel();
model.Logo = "teste png";
model.Nome = txtNomeMontadora.Text;
montadoraBLL.Salvar(model);
Response.Redirect("list.aspx");
}
private void Adicionar(MontadoraModel model)
{
SqlCommand comando = new SqlCommand();
comando.Connection = Acesso.Conection;
comando.CommandType = System.Data.CommandType.Text;
comando.CommandText = $@"insert into Montadora (nome, logo)
values('{model.Nome}','{model.Logo}')";
comando.ExecuteNonQuery();
Acesso.Conection.Close();
}
protected void btnCadastrar_Click(object sender, EventArgs e)
{
MontadoraModel model = new MontadoraModel();
model.Nome = txtNomeMontadora.Text;
model.Logo = "Logo.png";
if (txtId.Text != string.Empty)
{
model.Id = Convert.ToInt32(txtId.Text);
}
var montBll = new MontadoraBLL();
montBll.Salvar(model);
Response.Redirect("Lista.aspx");
}
public MontadoraModel Buscar(int id)
{
SqlCommand command = new SqlCommand();
command.Connection = Acesso.Connection;
command.CommandType = CommandType.Text;
command.CommandText = $"select * from montadora where id = {id}";
SqlDataReader dr = command.ExecuteReader();
if (dr.Read())
{
MontadoraModel model = new MontadoraModel();
model.Id = Convert.ToInt32(dr["id"]);
model.Nome = dr["nome"].ToString();
model.Logo = dr["logo"].ToString();
return(model);
}
return(null);
}
private void Alterar(MontadoraModel model)
{
}
private void Adicionar(MontadoraModel model)
{
}
