public static void AlterarStatusProduto(int pro_id, StatusProdutoEnum status)
{
bool ok = false;
try
{
DataSet ds = new DataSet();
IDbConnection objConexao;
IDbCommand objCommand;
objConexao = Mapped.Connection();
string query = "update produtos SET pro_status = ?status WHERE pro_id = ?pro_id";
objCommand = Mapped.Command(query, objConexao);
objCommand.Parameters.Add(Mapped.Parameter("?status", status));
objCommand.Parameters.Add(Mapped.Parameter("?pro_id", pro_id));
objCommand.ExecuteNonQuery();
objConexao.Close();
objConexao.Dispose();
objCommand.Dispose();
ok = true;
}
catch (Exception ex)
{
Console.Write(ex.StackTrace);
ok = false;
}
}
public static DataSet BuscarTodosOsProdutosPorEmpresaEStatus(int empresaId, StatusProdutoEnum status)
{
DataSet ds = new DataSet();
IDbConnection objConexao;
IDbCommand objCommand;
IDataAdapter dataAdapter;
objConexao = Mapped.Connection();
string query = "";
query += " SELECT ";
query += " pro.pro_id id, ";
query += " pro.pro_nome nome, ";
query += " pro.pro_subtitulo subtitulo, ";
query += " pro.pro_descricao descricao, ";
query += " pro.pro_valormoeda preco, ";
query += " ( ";
query += " SELECT ";
query += " mes_saldo ";
query += " FROM ";
query += " movestoque ";
query += " WHERE ";
query += " pro_id = pro.pro_id ";
query += " ORDER BY ";
query += " mes_id DESC ";
query += " LIMIT 1 ";
query += " ) quantidade, ";
query += " CASE WHEN pro.tip_id = 1 THEN 'FISICO' ELSE 'VIRTUAL' END categoria, ";
query += " pro.pro_logo logo_url, ";
query += " pro.pro_status status ";
query += " FROM ";
query += " produtos pro ";
query += " WHERE ";
query += " pro.emp_id = ?emp_id ";
query += " AND pro.pro_status = ?status; ";
objCommand = Mapped.Command(query, objConexao);
objCommand.Parameters.Add(Mapped.Parameter("?emp_id", empresaId));
objCommand.Parameters.Add(Mapped.Parameter("?status", status));
dataAdapter = Mapped.Adapter(objCommand);
dataAdapter.Fill(ds);
objConexao.Close();
objConexao.Dispose();
objCommand.Dispose();
return(ds);
}
