public static int Insert(Tpu tpu)
{
int retorno = 0;
try
{
IDbConnection objConexao;
IDbCommand objCommand;
objConexao = Mapped.Connection();
string query = "insert into tpu_Tipo_Usuario(tpu_descricao) values (?tpu_descricao)";
objCommand = Mapped.Command(query, objConexao);
objCommand.Parameters.Add(Mapped.Parameter("?tpu_descricao", tpu.Tpu_descricao));
objCommand.ExecuteNonQuery();
objConexao.Close();
objConexao.Dispose();
objCommand.Dispose();
}
catch (Exception ex)
{
retorno = -2;
}
return(retorno);
}
public static int Update(Tpu tpu)
{
int retorno = 0;
try
{
IDbConnection objConexao;
IDbCommand objCommand;
objConexao = Mapped.Connection();
string query = "update tpu_Tipo_Usuario SET tpu_descricao = ?tpu_descricao WHERE tpu_pk = ?tpu_pk";
objCommand = Mapped.Command(query, objConexao);
objCommand.Parameters.Add(Mapped.Parameter("?tpu_descricao", tpu.Tpu_descricao));
objCommand.Parameters.Add(Mapped.Parameter("?tpu_pk", tpu.Tpu_pk));
objCommand.ExecuteNonQuery();
objConexao.Close();
objConexao.Dispose();
objCommand.Dispose();
}
catch (Exception ex)
{
retorno = -2;
}
return(retorno);
}
protected void btn_Click(object sender, EventArgs e)
{
Tpu tpu = new Tpu();
tpu.Tpu_descricao = txbTpu.Text;
switch (TpuDB.Insert(tpu))
{
case 0:
ltlMSG.Text = "<div class='alert alert-success btn-block'> >>>> OK <<<< </div>";
txbTpu.Text = "";
break;
case -2:
ltlMSG.Text = "<div class='alert alert-danger form-control'> >>>> ERRO <<<< </div>";
txbTpu.Text = "";
break;
}
}
